· 8 years ago · Jun 04, 2018, 12:28 AM
1--
2-- Table structure for table `products`
3--
4
5CREATE TABLE IF NOT EXISTS `products` (
6 `id` int(11) NOT NULL AUTO_INCREMENT,
7 `name` varchar(128) NOT NULL,
8 `description` text NOT NULL,
9 `price` double NOT NULL,
10 `created` datetime NOT NULL,
11 `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
12 PRIMARY KEY (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;