Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/1_create_stats_tables.down.sql | 2 | ||||
| -rw-r--r-- | migrations/1_create_stats_tables.up.sql | 11 |
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; |