Mercurial > getan
diff test_data/getan_test_data.py @ 500:f751499d3f8d
merged, Updated TODO, CHANGES
| author | Magnus Schieder <mschieder@intevation.de> |
|---|---|
| date | Mon, 17 Sep 2018 20:41:28 +0200 |
| parents | 199b3e3657aa |
| children |
line wrap: on
line diff
--- a/test_data/getan_test_data.py Mon Aug 06 15:30:05 2018 +0200 +++ b/test_data/getan_test_data.py Mon Sep 17 20:41:28 2018 +0200 @@ -38,6 +38,16 @@ CHECK (strftime('%s', start_time) <= strftime('%s', stop_time))) ''') + db.execute('''CREATE TABLE recover ( + id INTEGER PRIMARY KEY, + 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))) + ''') + # List of projects. # (key, 'description') pro = [