Mercurial > getan
view schema.sql @ 312:dc92981ec591
Avoid resetting the focus when changing from DeleteEntryState back to the
DefaultEntryListState
This change will avoids resetting the focus of the current entry in the
EntryList to the first entry.
author | Björn Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Fri, 11 Oct 2013 12:09:06 +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)) );