migrations/1_create_stats_tables.up.sql


1
2
3
4
5
6
7
8
9
10
11

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;