Diffstat (limited to 'migrations/1_create_stats_tables.up.sql')
| -rw-r--r-- | migrations/1_create_stats_tables.up.sql | 11 |
1 files changed, 0 insertions, 11 deletions
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; |