Mercurial > getan
view schema.sql @ 370:f4dcfbede99b
Move justification of human_time to templates (only for zeiterfassung)
The totals are often longer 100h and more, so if justification is desired
here, it would not be to two full hour digits anyway.
author | Thomas Arendsen Hein <thomas@intevation.de> |
---|---|
date | Mon, 03 Mar 2014 15:57:54 +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)) );