const SETUP_TABLES_SQL: &str = "PRAGMA page_size = 4096;\nPRAGMA journal_mode = WAL;\nPRAGMA foreign_keys = ON;\nPRAGMA synchronous = FULL;\n\nCREATE TABLE IF NOT EXISTS kv_store (\n key_prefix BLOB NULL CHECK(TYPEOF(key_prefix) IN (\'blob\', \'null\')), \n key_name BLOB NOT NULL CHECK(TYPEOF(key_name) = \'blob\'),\n key_value BLOB NOT NULL CHECK(TYPEOF(key_value) = \'blob\'),\n PRIMARY KEY (key_prefix, key_name),\n UNIQUE (key_prefix, key_name)\n);\n\nCREATE TABLE IF NOT EXISTS disabled_commands (\n guild_id INTEGER NOT NULL CHECK(TYPEOF(guild_id) = \'integer\'),\n name TEXT NOT NULL CHECK(TYPEOF(name) = \'text\'),\n disabled INTEGER NOT NULL CHECK(TYPEOF(disabled) = \'integer\' AND disabled IN (0, 1)),\n PRIMARY KEY (guild_id, name),\n UNIQUE (guild_id, name)\n);\n\nCREATE TABLE IF NOT EXISTS reddit_embed_guild_settings (\n guild_id INTEGER NOT NULL PRIMARY KEY UNIQUE,\n enabled INTEGER NOT NULL CHECK(enabled IN (0, 1))\n) STRICT;\n\nCREATE TABLE IF NOT EXISTS tic_tac_toe_games (\n id INTEGER PRIMARY KEY UNIQUE NOT NULL CHECK(TYPEOF(id) = \'integer\'),\n board INTEGER NOT NULL CHECK(TYPEOF(board) = \'integer\'),\n x_player INTEGER NULL CHECK(TYPEOF(x_player) IN (\'integer\', \'null\')),\n o_player INTEGER NULL CHECK(TYPEOF(o_player) IN (\'integer\', \'null\')),\n guild_id TEXT NOT NULL CHECK(TYPEOF(guild_id) = \'text\'),\n UNIQUE (guild_id, x_player, o_player),\n UNIQUE (guild_id, x_player),\n UNIQUE (guild_id, o_player)\n);\n\nCREATE TABLE IF NOT EXISTS tic_tac_toe_scores (\n guild_id TEXT NOT NULL CHECK(TYPEOF(guild_id) = \'text\'),\n player INTEGER NOT NULL CHECK(TYPEOF(player) = \'integer\'),\n wins INTEGER NOT NULL DEFAULT 0 CHECK(TYPEOF(wins) = \'integer\'),\n losses INTEGER NOT NULL DEFAULT 0 CHECK(TYPEOF(losses) = \'integer\'),\n concedes INTEGER NOT NULL DEFAULT 0 CHECK(TYPEOF(concedes) = \'integer\'),\n ties INTEGER NOT NULL DEFAULT 0 CHECK(TYPEOF(ties) = \'integer\'),\n PRIMARY KEY (guild_id, player),\n UNIQUE (guild_id, player)\n);\n\nCREATE TABLE IF NOT EXISTS tiktok_embed_guild_settings (\n guild_id INTEGER NOT NULL PRIMARY KEY UNIQUE,\n \n -- flags for tiktok embed settings\n --\n -- bit | name | Description\n -- 0 | enabled? | Whether the bot should try to embed links\n -- 1 | delete-link? | Whether the bot should delete the original link on success\n flags INTEGER NOT NULL DEFAULT 0\n) STRICT;";