Mercurial > getan > getan
comparison schema.sql @ 0:7eb7886ed8fd
Initial import.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Mon, 28 Jul 2008 22:33:36 +0200 |
| parents | |
| children |
comparison
equal
deleted
inserted
replaced
| -1:000000000000 | 0:7eb7886ed8fd |
|---|---|
| 1 CREATE TABLE projects ( | |
| 2 id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| 3 key VARCHAR(16), | |
| 4 description VARCHAR(256), | |
| 5 active BOOLEAN DEFAULT 1 | |
| 6 ); | |
| 7 | |
| 8 CREATE TABLE entries ( | |
| 9 id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| 10 project_id INTEGER REFERENCES projects(id), | |
| 11 start_time TIMESTAMP NOT NULL, | |
| 12 stop_time TIMESTAMP NOT NULL, | |
| 13 description VARCHAR(256), | |
| 14 | |
| 15 CHECK (strftime('%s', start_time) <= strftime('%s', stop_time)) | |
| 16 ); |