diff options
author | Arjun Satarkar <me@arjunsatarkar.net> | 2024-03-26 19:26:06 +0000 |
---|---|---|
committer | Arjun Satarkar <me@arjunsatarkar.net> | 2024-03-26 19:26:06 +0000 |
commit | 23ba0fb8fc5070ba30a43035970775247da370f3 (patch) | |
tree | cf5ece53be0c5197a0c2b9d8c7233436ec6ba2e9 /markov/data/init.sql | |
parent | 8b0d67202a0ebbfa17d53d56bef9e515574bdb66 (diff) | |
download | aps-cogs-23ba0fb8fc5070ba30a43035970775247da370f3.tar aps-cogs-23ba0fb8fc5070ba30a43035970775247da370f3.tar.gz aps-cogs-23ba0fb8fc5070ba30a43035970775247da370f3.zip |
teleport: don't teleport within same channel, better text
Diffstat (limited to 'markov/data/init.sql')
-rw-r--r-- | markov/data/init.sql | 45 |
1 files changed, 0 insertions, 45 deletions
diff --git a/markov/data/init.sql b/markov/data/init.sql deleted file mode 100644 index 71ec073..0000000 --- a/markov/data/init.sql +++ /dev/null @@ -1,45 +0,0 @@ -CREATE TABLE IF NOT EXISTS guild_total_completion_count ( - guild_id BLOB, - first_token TEXT, - total_completion_count INTEGER, - UNIQUE (guild_id, first_token) -) STRICT; - -CREATE TABLE IF NOT EXISTS guild_pairs ( - guild_id BLOB, - first_token TEXT, - second_token TEXT, - frequency INTEGER, - UNIQUE (guild_id, first_token, second_token) -) STRICT; - -CREATE INDEX IF NOT EXISTS idx_guild_pairs__guild_id__first_token__frequency__second_token ON guild_pairs (guild_id, first_token, frequency, second_token); - -CREATE TABLE IF NOT EXISTS member_total_completion_count ( - guild_id BLOB, - member_id BLOB, - first_token TEXT, - total_completion_count INTEGER, - UNIQUE (guild_id, member_id, first_token) -) STRICT; - -CREATE TABLE IF NOT EXISTS member_pairs ( - guild_id BLOB, - member_id BLOB, - first_token TEXT, - second_token TEXT, - frequency INTEGER, - UNIQUE (guild_id, member_id, first_token, second_token) -) STRICT; - -CREATE INDEX IF NOT EXISTS idx_member_pairs__guild_id__member_id__first_token__frequency__second_token ON member_pairs ( - guild_id, - member_id, - first_token, - frequency, - second_token -); - -PRAGMA analysis_limit = 1000; - -PRAGMA optimize; |