summaryrefslogtreecommitdiff
path: root/migrations
diff refs
from: back
to: back
| flip
diff options
context:
space:
mode:
Diffstat (limited to 'migrations')
-rw-r--r--migrations/1_create_stats_tables.down.sql2
-rw-r--r--migrations/1_create_stats_tables.up.sql11
2 files changed, 0 insertions, 13 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;