getan: schema.sql annotate

annotate schema.sql @ 273:a5c5675b6fa4

Give more "weight" to the description when displaying the project node entry With this change the project description will get more space in the row then the time. This avoids cutting long description texts even if the there is enough free space. With urwid 1.1 it would even better to user ("pack", time) for this.

author	Björn Ricks <bjoern.ricks@intevation.de>
date	Fri, 12 Apr 2013 09:34:18 +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 @ 273:a5c5675b6fa4