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