qGg8eYpw

1CREATE TABLE IF NOT EXISTS `player_name_changes` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `account_id` int(11) NOT NULL,
4  `player_id` int(11) NOT NULL,
5  `old_name` varchar(100) NOT NULL,
6  `new_name` varchar(100) NOT NULL,
7  `coins` int(11) NOT NULL,
8  `date` int(11) NOT NULL,
9  PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
11
12CREATE TABLE IF NOT EXISTS `player_sex_changes` (
13  `id` int(11) NOT NULL AUTO_INCREMENT,
14  `account_id` int(11) NOT NULL,
15  `player_id` int(11) NOT NULL,
16  `old_sex` varchar(100) NOT NULL,
17  `new_sex` varchar(100) NOT NULL,
18  `coins` int(11) NOT NULL,
19  `date` int(11) NOT NULL,
20  PRIMARY KEY (`id`)
21) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
22
23CREATE TABLE IF NOT EXISTS `z_shop_category` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `name` varchar(255) NOT NULL,
26  `description` text NOT NULL,
27  `active` int(11) NOT NULL DEFAULT '1',
28  PRIMARY KEY (`id`),
29  UNIQUE KEY `name` (`name`)
30) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
31
32CREATE TABLE IF NOT EXISTS `z_shop_products` (
33  `id` int(11) NOT NULL AUTO_INCREMENT,
34  `name` varchar(255) NOT NULL,
35  `description` text NOT NULL,
36  `category` varchar(255) NOT NULL,
37  `image_name` varchar(50) NOT NULL,
38  `item_id` int(11) NOT NULL DEFAULT '0',
39  `item_count` int(11) NOT NULL DEFAULT '0',
40  `action_id` int(11) NOT NULL DEFAULT '0',
41  `mount_id` int(11) NOT NULL,
42  `outfit_male_id` int(11) NOT NULL,
43  `outfit_female_id` int(11) NOT NULL,
44  `outfit_addons` int(11) NOT NULL,
45  `coins` int(11) NOT NULL DEFAULT '0',
46  `addition_date` int(11) NOT NULL,
47  `active` int(11) NOT NULL DEFAULT '1',
48  PRIMARY KEY (`id`)
49) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
50
51CREATE TABLE IF NOT EXISTS `z_shop_shipment` (
52  `id` int(11) NOT NULL AUTO_INCREMENT,
53  `account_id` int(11) NOT NULL,
54  `player_id` int(11) NOT NULL,
55  `product_id` int(11) NOT NULL,
56  `coins` int(11) NOT NULL,
57  `state` int(11) NOT NULL,
58  `purchase_date` int(11) NOT NULL,
59  `delivery_date` int(11) NOT NULL,
60  PRIMARY KEY (`id`)
61) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;