getan: schema.sql annotate

annotate schema.sql @ 306:afe36c18417f

Allow to deactivate the selection of projects By default all keys are first handled by the urwid element itself and afterwards by the current state. Therefore pressing enter in the ProjectView will always result in selecting the current entry node. This isn't always the desired result and therefore allow to deactivate the selection.

author	Björn Ricks <bjoern.ricks@intevation.de>
date	Fri, 11 Oct 2013 11:03:50 +0200
parents	7eb7886ed8fd
children

rev	line source
0 7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	1 CREATE TABLE projects (
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	2 id INTEGER PRIMARY KEY AUTOINCREMENT,
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	3 key VARCHAR(16),
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	4 description VARCHAR(256),
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	5 active BOOLEAN DEFAULT 1
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	6 );
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	7
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	8 CREATE TABLE entries (
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	9 id INTEGER PRIMARY KEY AUTOINCREMENT,
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	10 project_id INTEGER REFERENCES projects(id),
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	11 start_time TIMESTAMP NOT NULL,
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	12 stop_time TIMESTAMP NOT NULL,
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	13 description VARCHAR(256),
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	14
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	15 CHECK (strftime('%s', start_time) <= strftime('%s', stop_time))
7eb7886ed8fd Initial import. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	16 );

Mercurial > getan

annotate schema.sql @ 306:afe36c18417f