1CREATE TABLE user (id INTEGER PRIMARY KEY, user TEXT);
2CREATE UNIQUE INDEX idx_user ON user(user);
3
4CREATE TABLE page (id INTEGER PRIMARY KEY, page TEXT);
5CREATE UNIQUE INDEX idx_page ON page(page);
6
7CREATE TABLE project (id INTEGER PRIMARY KEY, page_id INTEGER, abbr TEXT, name TEXT);
8CREATE UNIQUE INDEX idx_project ON project(page_id,abbr);
9
10CREATE TABLE task (id INTEGER PRIMARY KEY, project_id INTEGER, abbr TEXT, name TEXT, active INTEGER);
11CREATE UNIQUE INDEX idx_task ON task(project_id,abbr);
12
13CREATE TABLE user_time (id INTEGER PRIMARY KEY, update_time INTEGER, user_id INTEGER, task_id INTEGER, `date` TEXT,  value INTEGER);
14CREATE UNIQUE INDEX idx_user_time ON user_time(user_id,task_id,date);
15