V05vampG

1CREATE TABLE IF NOT EXISTS `cp_itemshop` (
2  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3  `nameid` int(11) unsigned NOT NULL DEFAULT '0',
4  `category` int(11) DEFAULT NULL,
5  `quantity` int(11) unsigned NOT NULL DEFAULT '0',
6  `refine` tinyint(3) unsigned NOT NULL DEFAULT '0',
7  `attribute` tinyint(4) NOT NULL DEFAULT '0',
8  `card0` smallint(11) NOT NULL DEFAULT '0',
9  `card1` smallint(11) NOT NULL DEFAULT '0',
10  `card2` smallint(11) NOT NULL DEFAULT '0',
11  `card3` smallint(11) NOT NULL DEFAULT '0',
12  `cost` int(11) unsigned NOT NULL,
13  `info` text,
14  `use_existing` tinyint(4) NOT NULL DEFAULT '0',
15  `create_date` datetime NOT NULL,
16  PRIMARY KEY (`id`),
17  KEY `nameid` (`nameid`)
18) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Item shop' AUTO_INCREMENT=1 ;