
SET DateStyle TO 'SQL, DMY';

DROP TABLE IF EXISTS TestCase;
CREATE TABLE TestCase (
  Date date NOT NULL default '0000-01-01',
  Header varchar(150) NOT NULL default '',
  ID serial NOT NULL
);

INSERT INTO TestCase VALUES ('2008-02-01', 'test case 1', 1);
INSERT INTO TestCase VALUES ('0000-01-01', 'test case 2', 2);
INSERT INTO TestCase VALUES ('2008-02-02', 'test case 3', 3);

