Ticket #6642: test_case.psql.sql
| File test_case.psql.sql, 384 bytes (added by , 17 years ago) |
|---|
| Line | |
|---|---|
| 1 | |
| 2 | SET DateStyle TO 'SQL, DMY'; |
| 3 | |
| 4 | DROP TABLE IF EXISTS TestCase; |
| 5 | CREATE TABLE TestCase ( |
| 6 | Date date NOT NULL default '0000-01-01', |
| 7 | Header varchar(150) NOT NULL default '', |
| 8 | ID serial NOT NULL |
| 9 | ); |
| 10 | |
| 11 | INSERT INTO TestCase VALUES ('2008-02-01', 'test case 1', 1); |
| 12 | INSERT INTO TestCase VALUES ('0000-01-01', 'test case 2', 2); |
| 13 | INSERT INTO TestCase VALUES ('2008-02-02', 'test case 3', 3); |
| 14 |