· 7 years ago · Mar 01, 2019, 09:16 AM
1DROP TABLE IF EXISTS `categories`;
2CREATE TABLE IF NOT EXISTS `categories` (
3 `catid` int(11) NOT NULL AUTO_INCREMENT,
4 `catname` varchar(500) DEFAULT NULL,
5 `catdesk` varchar(500) DEFAULT NULL,
6 `icon` varchar(500) DEFAULT NULL,
7 `displayorder` int(11) DEFAULT NULL,
8 PRIMARY KEY (`catid`)
9) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
10
11--
12-- Dumping data for table `categories`
13--
14
15INSERT INTO `categories` (`catid`, `catname`, `catdesk`, `icon`, `displayorder`) VALUES
16(1, 'Samsung S7 Edge', '4GB RAM, 32GB STORAGE', 's7edge.jpg', 1),
17(2, 'iPhone 8+', '3GB RAM, 64GB STORAGE', 's7edge.jpg', 2),
18(3, 'OnePlus 3', '6GB RAM, 64GB STORAGE', 's7edge.jpg', 3);
19COMMIT;