2024-03-17 21:57:17 +00:00
|
|
|
create table if not exists hits (
|
|
|
|
id integer primary key,
|
2024-03-25 00:37:06 +00:00
|
|
|
page text not null, -- the slug from the page
|
2024-04-04 00:13:44 +00:00
|
|
|
visit_key text not null,
|
2024-04-03 20:52:23 +00:00
|
|
|
viewed timestamp not null default CURRENT_TIMESTAMP,
|
|
|
|
unique(page, visit_key)
|
2024-03-17 21:57:17 +00:00
|
|
|
);
|
|
|
|
|
|
|
|
create index if not exists hits_page_dex on hits(page);
|
2024-03-30 20:07:56 +00:00
|
|
|
create index if not exists hits_viewed_dex on hits(viewed);
|