getan: schema.sql annotate

annotate 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

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 @ 131:3d5232dad59a