Add store abstraction

2 files changed, 8 insertions, 3 deletions

diff --git a/sql/sqlite3/01_domains.sql b/sql/sqlite3/01_domains.sql
index feb40bb..b290bb2 100644
--- a/sql/sqlite3/01_domains.sql
+++ b/sql/sqlite3/01_domains.sql
@@ -2,7 +2,11 @@ create table domains (
 	id integer primary key autoincrement,
 	name varchar not null check(length(name) >= 4 and length(name) <= 255),
 	description varchar null,
+	aliases varchar null,
 	enabled integer not null default 0,
-	created_at timestamp not null check(created_at = strftime('%Y-%m-%d %H:%M:%S', created_at)),
-	updated_at timestamp not null check(updated_at = strftime('%Y-%m-%d %H:%M:%S', updated_at))
+	created_at timestamp not null,
+	updated_at timestamp not null
 );
+
+insert into domains (name, description, enabled, created_at, updated_at)
+values ('localhost', 'Example domain', 1, date('now'), date('now'));
diff --git a/sql/sqlite3/02_hits.sql b/sql/sqlite3/02_hits.sql
index 34f54cf..2fd5539 100644
--- a/sql/sqlite3/02_hits.sql
+++ b/sql/sqlite3/02_hits.sql
@@ -1,4 +1,5 @@
 create table hits (
+	id integer primary key autoincrement,
 	domain_id integer check(domain_id >0),
 	addr varchar not null,
 	scheme varchar not null,
@@ -9,6 +10,6 @@ create table hits (
 	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))
+	created_at timestamp not null
 );
 create index "hits#domain_id#created" on hits(domain_id, created_at);