2sPkVNFi

1CREATE TABLE IF NOT EXISTS `shop_boughts` (
2							  `player_id` int(5) NOT NULL,
3							  `item_id` int(5) NOT NULL,
4							  `count` int(4) NOT NULL,
5							  `duration` int(8) NOT NULL,
6							  `timeleft` int(8) NOT NULL,
7							  `buy_price` int(5) NOT NULL,
8							  `sell_price` int(5) NOT NULL,
9							  `buy_time` int(10)
10							) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11CREATE TABLE IF NOT EXISTS `shop_items` (
12							  `id` int(5) NOT NULL AUTO_INCREMENT,
13							  `category` varchar(64) NOT NULL,
14							  `item` varchar(64) NOT NULL,
15							  PRIMARY KEY (`id`)
16							) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
17CREATE TABLE IF NOT EXISTS `shop_players` (
18							  `id` int(5) NOT NULL AUTO_INCREMENT,
19							  `name` varchar(32) NOT NULL DEFAULT 'unknown',
20							  `auth` varchar(22) NOT NULL,
21							  `money` int(12) NOT NULL,
22							  `lastconnect` int(10),
23							  PRIMARY KEY (`id`), 
24								UNIQUE KEY `auth` (`auth`) 
25							) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;