· 8 years ago · Mar 03, 2018, 08:56 AM
1CREATE TABLE IF NOT EXISTS `homes_catalogue` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `name` text NOT NULL,
4 `type` varchar(1) NOT NULL,
5 `desc` varchar(255) CHARACTER SET utf8 NOT NULL,
6 `data` text NOT NULL,
7 `price` int(11) NOT NULL,
8 `amount` int(11) NOT NULL DEFAULT '1',
9 `category` text NOT NULL,
10 `categoryid` int(11) NOT NULL,
11 `minrank` int(11) NOT NULL DEFAULT '1',
12 `where` int(11) DEFAULT '0',
13 PRIMARY KEY (`id`)
14) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11301 ;