Mercurial > getan
view schema.sql @ 318:27fc5f43a69b
Move setting the ProjectList and EntryList instances into the controller
It doesn't make sense to pass classes for both to the GetanController
constructor. Be don't have different implementations for these classes.
author | Björn Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Fri, 11 Oct 2013 14:12:03 +0200 |
parents | 7eb7886ed8fd |
children |
line wrap: on
line source
CREATE TABLE projects ( id INTEGER PRIMARY KEY AUTOINCREMENT, key VARCHAR(16), description VARCHAR(256), active BOOLEAN DEFAULT 1 ); CREATE TABLE entries ( id INTEGER PRIMARY KEY AUTOINCREMENT, project_id INTEGER REFERENCES projects(id), start_time TIMESTAMP NOT NULL, stop_time TIMESTAMP NOT NULL, description VARCHAR(256), CHECK (strftime('%s', start_time) <= strftime('%s', stop_time)) );