Constant BRDB_SQLITE_SCHEMA

Source
pub const BRDB_SQLITE_SCHEMA: &str = "CREATE TABLE blobs (\n\t\t\t\tblob_id INTEGER PRIMARY KEY,\n\t\t\t\tcompression INTEGER,\n\t\t\t\tsize_uncompressed INTEGER,\n\t\t\t\tsize_compressed INTEGER,\n\t\t\t\tdelta_base_id INTEGER REFERENCES blobs(blob_id),\n\t\t\t\thash BLOB,\n\t\t\t\tcontent BLOB\n\t\t\t);\nCREATE TABLE revisions (\n\t\t\t\trevision_id INTEGER PRIMARY KEY,\n\t\t\t\tdescription TEXT,\n\t\t\t\tcreated_at INTEGER\n\t\t\t);\nCREATE TABLE folders (\n\t\t\t\tfolder_id INTEGER PRIMARY KEY,\n\t\t\t\tparent_id INTEGER REFERENCES folders(folder_id),\n\t\t\t\tname TEXT,\n\t\t\t\tcreated_at INTEGER,\n\t\t\t\tdeleted_at INTEGER\n\t\t\t);\nCREATE TABLE files (\n\t\t\t\tfile_id INTEGER PRIMARY KEY,\n\t\t\t\tparent_id INTEGER REFERENCES folders(folder_id),\n\t\t\t\tname TEXT,\n\t\t\t\tcontent_id INTEGER REFERENCES blobs(blob_id),\n\t\t\t\tcreated_at INTEGER,\n\t\t\t\tdeleted_at INTEGER\n\t\t\t);\nCREATE INDEX blobs_size_hash ON blobs(size_uncompressed, hash);\nCREATE INDEX folders_parent_name_deleted ON folders(parent_id, name, deleted_at);\nCREATE INDEX files_parent_name_deleted ON files(parent_id, name, deleted_at);";