· 9 years ago · Dec 02, 2016, 01:02 AM
1CREATE TABLE IF NOT EXISTS `cases` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `class` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
4 `name` varchar(100) NOT NULL,
5 `title` varchar(100) NOT NULL,
6 `picture` varchar(225) NOT NULL,
7 `items` text NOT NULL,
8 `price` int(11) NOT NULL,
9 `visible` int(11) NOT NULL DEFAULT '0',
10 `lim` int(15) NOT NULL,
11 `red_stock` int(15) NOT NULL DEFAULT '0',
12 PRIMARY KEY (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ;