Constant deltachat::sql::migrations::TABLES

source ·
const TABLES: &str = "CREATE TABLE config (\n  id INTEGER PRIMARY KEY,\n  keyname TEXT,\n  value TEXT\n);\nCREATE INDEX config_index1 ON config (keyname);\nCREATE TABLE contacts (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    name TEXT DEFAULT \'\',\n    addr TEXT DEFAULT \'\' COLLATE NOCASE,\n    origin INTEGER DEFAULT 0,\n    blocked INTEGER DEFAULT 0,\n    last_seen INTEGER DEFAULT 0,\n    param TEXT DEFAULT \'\',\n    authname TEXT DEFAULT \'\',\n    selfavatar_sent INTEGER DEFAULT 0\n);\nCREATE INDEX contacts_index1 ON contacts (name COLLATE NOCASE);\nCREATE INDEX contacts_index2 ON contacts (addr COLLATE NOCASE);\nINSERT INTO contacts (id,name,origin) VALUES\n(1,\'self\',262144), (2,\'info\',262144), (3,\'rsvd\',262144),\n(4,\'rsvd\',262144), (5,\'device\',262144), (6,\'rsvd\',262144),\n(7,\'rsvd\',262144), (8,\'rsvd\',262144), (9,\'rsvd\',262144);\n\nCREATE TABLE chats (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    type INTEGER DEFAULT 0,\n    name TEXT DEFAULT \'\',\n    draft_timestamp INTEGER DEFAULT 0,\n    draft_txt TEXT DEFAULT \'\',\n    blocked INTEGER DEFAULT 0,\n    grpid TEXT DEFAULT \'\',\n    param TEXT DEFAULT \'\',\n    archived INTEGER DEFAULT 0,\n    gossiped_timestamp INTEGER DEFAULT 0,\n    locations_send_begin INTEGER DEFAULT 0,\n    locations_send_until INTEGER DEFAULT 0,\n    locations_last_sent INTEGER DEFAULT 0,\n    created_timestamp INTEGER DEFAULT 0,\n    muted_until INTEGER DEFAULT 0,\n    ephemeral_timer INTEGER\n);\nCREATE INDEX chats_index1 ON chats (grpid);\nCREATE INDEX chats_index2 ON chats (archived);\nCREATE INDEX chats_index3 ON chats (locations_send_until);\nINSERT INTO chats (id,type,name) VALUES\n(1,120,\'deaddrop\'), (2,120,\'rsvd\'), (3,120,\'trash\'),\n(4,120,\'msgs_in_creation\'), (5,120,\'starred\'), (6,120,\'archivedlink\'),\n(7,100,\'rsvd\'), (8,100,\'rsvd\'), (9,100,\'rsvd\');\n\nCREATE TABLE chats_contacts (chat_id INTEGER, contact_id INTEGER);\nCREATE INDEX chats_contacts_index1 ON chats_contacts (chat_id);\nCREATE INDEX chats_contacts_index2 ON chats_contacts (contact_id);\n\nCREATE TABLE msgs (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    rfc724_mid TEXT DEFAULT \'\',\n    server_folder TEXT DEFAULT \'\',\n    server_uid INTEGER DEFAULT 0,\n    chat_id INTEGER DEFAULT 0,\n    from_id INTEGER DEFAULT 0,\n    to_id INTEGER DEFAULT 0,\n    timestamp INTEGER DEFAULT 0,\n    type INTEGER DEFAULT 0,\n    state INTEGER DEFAULT 0,\n    msgrmsg INTEGER DEFAULT 1,\n    bytes INTEGER DEFAULT 0,\n    txt TEXT DEFAULT \'\',\n    txt_raw TEXT DEFAULT \'\',\n    param TEXT DEFAULT \'\',\n    starred INTEGER DEFAULT 0,\n    timestamp_sent INTEGER DEFAULT 0,\n    timestamp_rcvd INTEGER DEFAULT 0,\n    hidden INTEGER DEFAULT 0,\n    -- mime_headers column actually contains BLOBs, i.e. it may\n    -- contain non-UTF8 MIME messages.  TEXT was a bad choice, but\n    -- thanks to SQLite 3 being dynamically typed, there is no need to\n    -- change column type.\n    mime_headers TEXT,\n    mime_in_reply_to TEXT,\n    mime_references TEXT,\n    move_state INTEGER DEFAULT 1,\n    location_id INTEGER DEFAULT 0,\n    error TEXT DEFAULT \'\',\n\n-- Timer value in seconds. For incoming messages this\n-- timer starts when message is read, so we want to have\n-- the value stored here until the timer starts.\n    ephemeral_timer INTEGER DEFAULT 0,\n\n-- Timestamp indicating when the message should be\n-- deleted. It is convenient to store it here because UI\n-- needs this value to display how much time is left until\n-- the message is deleted.\n    ephemeral_timestamp INTEGER DEFAULT 0\n);\n\nCREATE INDEX msgs_index1 ON msgs (rfc724_mid);\nCREATE INDEX msgs_index2 ON msgs (chat_id);\nCREATE INDEX msgs_index3 ON msgs (timestamp);\nCREATE INDEX msgs_index4 ON msgs (state);\nCREATE INDEX msgs_index5 ON msgs (starred);\nCREATE INDEX msgs_index6 ON msgs (location_id);\nCREATE INDEX msgs_index7 ON msgs (state, hidden, chat_id);\nINSERT INTO msgs (id,msgrmsg,txt) VALUES\n(1,0,\'marker1\'), (2,0,\'rsvd\'), (3,0,\'rsvd\'),\n(4,0,\'rsvd\'), (5,0,\'rsvd\'), (6,0,\'rsvd\'), (7,0,\'rsvd\'),\n(8,0,\'rsvd\'), (9,0,\'daymarker\');\n\nCREATE TABLE jobs (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    added_timestamp INTEGER,\n    desired_timestamp INTEGER DEFAULT 0,\n    action INTEGER,\n    foreign_id INTEGER,\n    param TEXT DEFAULT \'\',\n    thread INTEGER DEFAULT 0,\n    tries INTEGER DEFAULT 0\n);\nCREATE INDEX jobs_index1 ON jobs (desired_timestamp);\n\nCREATE TABLE leftgrps (\n    id INTEGER PRIMARY KEY,\n    grpid TEXT DEFAULT \'\'\n);\nCREATE INDEX leftgrps_index1 ON leftgrps (grpid);\n\nCREATE TABLE keypairs (\n    id INTEGER PRIMARY KEY,\n    addr TEXT DEFAULT \'\' COLLATE NOCASE,\n    is_default INTEGER DEFAULT 0,\n    private_key,\n    public_key,\n    created INTEGER DEFAULT 0\n);\n\nCREATE TABLE acpeerstates (\n    id INTEGER PRIMARY KEY,\n    addr TEXT DEFAULT \'\' COLLATE NOCASE,\n    last_seen INTEGER DEFAULT 0,\n    last_seen_autocrypt INTEGER DEFAULT 0,\n    public_key,\n    prefer_encrypted INTEGER DEFAULT 0,\n    gossip_timestamp INTEGER DEFAULT 0,\n    gossip_key,\n    public_key_fingerprint TEXT DEFAULT \'\',\n    gossip_key_fingerprint TEXT DEFAULT \'\',\n    verified_key,\n    verified_key_fingerprint TEXT DEFAULT \'\'\n);\nCREATE INDEX acpeerstates_index1 ON acpeerstates (addr);\nCREATE INDEX acpeerstates_index3 ON acpeerstates (public_key_fingerprint);\nCREATE INDEX acpeerstates_index4 ON acpeerstates (gossip_key_fingerprint);\nCREATE INDEX acpeerstates_index5 ON acpeerstates (verified_key_fingerprint);\n\nCREATE TABLE msgs_mdns (\n    msg_id INTEGER,\n    contact_id INTEGER,\n    timestamp_sent INTEGER DEFAULT 0\n);\nCREATE INDEX msgs_mdns_index1 ON msgs_mdns (msg_id);\n\nCREATE TABLE tokens (\n    id INTEGER PRIMARY KEY,\n    namespc INTEGER DEFAULT 0,\n    foreign_id INTEGER DEFAULT 0,\n    token TEXT DEFAULT \'\',\n    timestamp INTEGER DEFAULT 0\n);\n\n-- The currently running securejoin protocols, joiner-side.\n-- CREATE TABLE bobstate (\n--     id INTEGER PRIMARY KEY AUTOINCREMENT,\n--     invite TEXT NOT NULL,\n--     next_step INTEGER NOT NULL,\n--     chat_id INTEGER NOT NULL\n-- );\n\nCREATE TABLE locations (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    latitude REAL DEFAULT 0.0,\n    longitude REAL DEFAULT 0.0,\n    accuracy REAL DEFAULT 0.0,\n    timestamp INTEGER DEFAULT 0,\n    chat_id INTEGER DEFAULT 0,\n    from_id INTEGER DEFAULT 0,\n    independent INTEGER DEFAULT 0\n);\nCREATE INDEX locations_index1 ON locations (from_id);\nCREATE INDEX locations_index2 ON locations (timestamp);\n\nCREATE TABLE devmsglabels (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    label TEXT,\n    msg_id INTEGER DEFAULT 0\n);\nCREATE INDEX devmsglabels_index1 ON devmsglabels (label);\n";