iJhKUyp7

1DROP TABLE IF EXISTS `player_shop_buy_items`;
2CREATE TABLE `player_shop_buy_items` (
3  `id` int(255) NOT NULL AUTO_INCREMENT,
4  `shop_id` int(255) NOT NULL, 
5  `owner_id` int(255) NOT NULL, 
6  `owner_name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
7  `player_id` int(255) NOT NULL, 
8  `player_name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
9  `item_id` int(255) NOT NULL, 
10  `count` int(255) NOT NULL, 
11  `gold` int(255) NOT NULL, 
12  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',  
13  PRIMARY KEY (`id`)
14) ENGINE=MyISAM;
15
16DROP TABLE IF EXISTS `exchange_gold`;
17CREATE TABLE `exchange_gold` (
18  `id` int(255) NOT NULL AUTO_INCREMENT,
19  `owner_id` int(255) NOT NULL,
20  `owner_name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
21  `victim_id` int(255) NOT NULL,
22  `victim_name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
23  `count` int(255) NOT NULL,  
24  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
25  PRIMARY KEY (`id`)
26) ENGINE=MyISAM;
27
28DROP TABLE IF EXISTS `exchange_item`;
29CREATE TABLE `exchange_item` (
30  `id` int(255) NOT NULL AUTO_INCREMENT,
31  `owner_id` int(255) NOT NULL,
32  `owner_name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
33  `victim_id` int(255) NOT NULL,
34  `victim_name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
35  `item` int(255) NOT NULL,
36  `vnum` int(255) NOT NULL,
37  `count` int(255) NOT NULL,  
38  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
39  PRIMARY KEY (`id`)
40) ENGINE=MyISAM;
41
42DROP TABLE IF EXISTS `get_item`;
43CREATE TABLE `get_item` (
44  `id` int(255) NOT NULL AUTO_INCREMENT,
45  `playerId` int(255) NOT NULL,
46  `playerName` varchar(255) COLLATE utf8_polish_ci NOT NULL,
47  `itemVnum` int(255) NOT NULL,
48  `itemName` varchar(255) COLLATE utf8_polish_ci NOT NULL,
49  `itemCount` int(255) NOT NULL,
50  `oryginalVnum` int(255) NOT NULL,
51  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
52  PRIMARY KEY (`id`)
53) ENGINE=MyISAM;
54
55DROP TABLE IF EXISTS `drop_item`;
56CREATE TABLE `drop_item` (
57  `id` int(255) NOT NULL AUTO_INCREMENT,
58  `account_id` int(255) NOT NULL,
59  `player_id` int(255) NOT NULL,
60  `player_name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
61  `item` varchar(255) COLLATE utf8_polish_ci NOT NULL,
62  `vnum` int(255) NOT NULL,
63  `oryginal_vnum` int(255) NOT NULL,
64  `count` int(255) NOT NULL,
65  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
66  PRIMARY KEY (`id`)
67) ENGINE=MyISAM;