summaryrefslogtreecommitdiffci
path: root/migrations/2_create_subscription_tables.up.sql
diff refs
from: back
to: back
| flip
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/2_create_subscription_tables.up.sql')
-rw-r--r--migrations/2_create_subscription_tables.up.sql18
1 files changed, 0 insertions, 18 deletions
diff --git a/migrations/2_create_subscription_tables.up.sql b/migrations/2_create_subscription_tables.up.sql
deleted file mode 100644
index e6e905a..0000000
--- a/migrations/2_create_subscription_tables.up.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-CREATE TABLE IF NOT EXISTS user_email_table (
- user_id VARCHAR(32) NOT NULL PRIMARY KEY,
- email VARCHAR(64) NOT NULL,
- lang VARCHAR(2) NOT NULL
-) WITHOUT ROWID;
-
-CREATE UNIQUE INDEX user_email_table_email_uindex
-ON user_email_table(email);
-
-CREATE TABLE IF NOT EXISTS subscription_user_to_tags_table (
- user_id VARCHAR(32) NOT NULL PRIMARY KEY,
- tags TEXT NOT NULL
-) WITHOUT ROWID;
-
-CREATE TABLE IF NOT EXISTS subscription_tag_to_users_table (
- tag VARCHAR(32) NOT NULL PRIMARY KEY,
- user_ids TEXT NOT NULL
-) WITHOUT ROWID;