aboutsummaryrefslogtreecommitdiff
path: root/markov/data/init.sql
diff options
context:
space:
mode:
authorArjun Satarkar <me@arjunsatarkar.net>2024-03-26 19:26:06 +0000
committerArjun Satarkar <me@arjunsatarkar.net>2024-03-26 19:26:06 +0000
commit23ba0fb8fc5070ba30a43035970775247da370f3 (patch)
treecf5ece53be0c5197a0c2b9d8c7233436ec6ba2e9 /markov/data/init.sql
parent8b0d67202a0ebbfa17d53d56bef9e515574bdb66 (diff)
downloadaps-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.sql45
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;