diff options
| author |  SayaAndy <saya.andy@posteo.com>
| 2025-08-30 00:36:46 +0700 |
|---|---|---|
| committer | SayaAndy <saya.andy@posteo.com>
| 2025-08-30 00:36:46 +0700 |
| commit | 78fe4481099fcf6666f1a259e38d9d828a253347 (patch) | |
| tree | c4f8bc344da8a26536fb85d5fb3fec891bdf7eb6 /migrations/1_create_stats_tables.up.sql | |
| parent | 753fe7f1d5bf837a85481425bd6bf6b431ffb611 (diff) | |
| download | web-78fe4481099fcf6666f1a259e38d9d828a253347.tar.gz web-78fe4481099fcf6666f1a259e38d9d828a253347.zip | |
feat: add persistent storage for likes
Diffstat (limited to 'migrations/1_create_stats_tables.up.sql')
| -rw-r--r-- | migrations/1_create_stats_tables.up.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/migrations/1_create_stats_tables.up.sql b/migrations/1_create_stats_tables.up.sql new file mode 100644 index 0000000..8852268 --- /dev/null +++ b/migrations/1_create_stats_tables.up.sql @@ -0,0 +1,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; |