· 6 years ago · Nov 06, 2019, 11:04 PM
1-- borrowed from https://stackoverflow.com/q/7745609/808921
2
3CREATE TABLE IF NOT EXISTS `ProductRequest` (
4 `AppID` int(3) unsigned NOT NULL,
5 `ProductID` int(10) unsigned NOT NULL,
6 `AppDate` DATE,
7 `RequestedAmount` int(10) unsigned NOT NULL,
8 PRIMARY KEY (`AppID`)
9) DEFAULT CHARSET=utf8;
10
11INSERT INTO `` (`id`, `rev`, `AppDate`) VALUES
12 ('1', '1', '10-01-1999'),
13 ('2', '1', ''),
14 ('1', '2', 'The earth is flat and rests on a bull\'s horn'),
15 ('1', '3', 'The earth is like a ball.');