Ticket #6642: test_case.mysql.sql
| File test_case.mysql.sql, 383 bytes (added by , 16 years ago) |
|---|
| Line | |
|---|---|
| 1 | |
| 2 | CREATE TABLE `TestCase` ( |
| 3 | `Date` date NOT NULL default '0000-00-00', |
| 4 | `Header` varchar(150) NOT NULL default '', |
| 5 | `ID` bigint(20) NOT NULL auto_increment, |
| 6 | UNIQUE KEY `ID` (`ID`) |
| 7 | ); |
| 8 | |
| 9 | INSERT INTO `TestCase` VALUES ('2008-02-01', 'test case 1', 1); |
| 10 | INSERT INTO `TestCase` VALUES ('0000-00-00', 'test case 2', 2); |
| 11 | INSERT INTO `TestCase` VALUES ('2008-02-02', 'test case 3', 3); |
| 12 |