Mercurial > getan
view schema.sql @ 131:3d5232dad59a
Add methods to reset the ProjectList footer
When going back from the move state ist must be possible to restore the old
footer entry in the ProjectList. The footer may be overriden by the move state
to select a project. In this case the old entry should be restored instead of
showing a blank footer.
author | Björn Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Wed, 31 Oct 2012 09:53:57 +0100 |
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)) );