· 7 years ago · Jan 17, 2019, 08:48 PM
1-- Table structure for table `categories`
2CREATE TABLE IF NOT EXISTS `categories` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `name` varchar(256) NOT NULL,
5 `created` datetime NOT NULL,
6 `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
7 PRIMARY KEY (`id`)
8) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
9
10-- Dumping data for table `categories`
11INSERT INTO `categories` (`id`, `name`, `created`, `modified`) VALUES
12(1, 'Fashion', '2014-06-01 00:35:07', '2014-05-30 17:34:33'),
13(2, 'Electronics', '2014-06-01 00:35:07', '2014-05-30 17:34:33'),
14(3, 'Motors', '2014-06-01 00:35:07', '2014-05-30 17:34:54');