4 files changed, 0 insertions, 35 deletions
diff --git a/migrations/1_create_stats_tables.down.sql b/migrations/1_create_stats_tables.down.sql
deleted file mode 100644
index ee4593c..0000000
--- a/migrations/1_create_stats_tables.down.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-DROP TABLE IF EXISTS blog_views;
-DROP TABLE IF EXISTS blog_likes;
diff --git a/migrations/1_create_stats_tables.up.sql b/migrations/1_create_stats_tables.up.sql
deleted file mode 100644
index 8852268..0000000
--- a/migrations/1_create_stats_tables.up.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-CREATE TABLE IF NOT EXISTS blog_likes (
-    page_ref VARCHAR(32) NOT NULL,
-    user_id VARCHAR(32) NOT NULL,
-    PRIMARY KEY (page_ref, user_id)
-) WITHOUT ROWID;
-
-CREATE TABLE IF NOT EXISTS blog_views (
-    page_ref VARCHAR(32) NOT NULL,
-    user_id VARCHAR(32) NOT NULL,
-    PRIMARY KEY (page_ref, user_id)
-) WITHOUT ROWID;
diff --git a/migrations/2_create_subscription_tables.down.sql b/migrations/2_create_subscription_tables.down.sql
deleted file mode 100644
index d9a369e..0000000
--- a/migrations/2_create_subscription_tables.down.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-DROP INDEX IF EXISTS user_email_table_email_uindex;
-DROP TABLE IF EXISTS user_email_table;
-DROP TABLE IF EXISTS subscription_user_to_tags_table;
-DROP TABLE IF EXISTS subscription_tag_to_users_table;
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;