blob: 34f54cfa1126c87228e63772e6896fee4c5220bf (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
create table hits (
domain_id integer check(domain_id >0),
addr varchar not null,
scheme varchar not null,
host varchar not null,
path varchar not null,
query varchar null,
title varchar null,
referrer varchar null,
user_agent varchar null,
view_port varchar null,
created_at timestamp not null check(created_at = strftime('%Y-%m-%d %H:%M:%S', created_at))
);
create index "hits#domain_id#created" on hits(domain_id, created_at);
|
