· 8 years ago · Mar 09, 2018, 11:28 PM
1DROP TABLE IF EXISTS `player_shop`;
2CREATE TABLE `player_shop` (
3 `id` int(255) NOT NULL AUTO_INCREMENT,
4 `player_id` int(255) NOT NULL,
5 `shop_vid` int(255) NOT NULL,
6 `item_count` int(3) NOT NULL DEFAULT '0',
7 `name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
8 `status` enum('OK','CLOSED') COLLATE utf8_polish_ci NOT NULL DEFAULT 'OK',
9 `map_index` int(20) NOT NULL DEFAULT '0',
10 `x` int(30) NOT NULL DEFAULT '0',
11 `y` int(30) NOT NULL DEFAULT '0',
12 `z` int(30) NOT NULL,
13 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
14 `date_close` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
15 `ip` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0.0.0.0',
16 `gold` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
17 `cash` int(255) NOT NULL DEFAULT '0',
18 `channel` int(1) NOT NULL DEFAULT '1',
19 PRIMARY KEY (`id`,`shop_vid`)
20) ENGINE=MyISAM;
21
22DROP TABLE IF EXISTS `player_gift`;
23CREATE TABLE `player_gift` (
24 `id` int(255) NOT NULL AUTO_INCREMENT,
25 `owner_id` int(255) NOT NULL,
26 `date_add` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
27 `date_get` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
28 `status` enum('WAIT','OK') COLLATE utf8_polish_ci NOT NULL DEFAULT 'WAIT',
29 `from` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
30 `reason` text COLLATE utf8_polish_ci NOT NULL,
31 `vnum` int(255) NOT NULL DEFAULT '0',
32 `count` bigint(255) NOT NULL DEFAULT '1',
33 `socket0` int(10) unsigned NOT NULL DEFAULT '0',
34 `socket1` int(10) unsigned NOT NULL DEFAULT '0',
35 `socket2` int(10) unsigned NOT NULL DEFAULT '0',
36 `socket3` int(10) unsigned NOT NULL DEFAULT '0',
37 `socket4` int(10) unsigned NOT NULL DEFAULT '0',
38 `socket5` int(10) unsigned NOT NULL DEFAULT '0',
39 `attrtype0` tinyint(4) NOT NULL DEFAULT '0',
40 `attrvalue0` smallint(6) NOT NULL DEFAULT '0',
41 `attrtype1` tinyint(4) NOT NULL DEFAULT '0',
42 `attrvalue1` smallint(6) NOT NULL DEFAULT '0',
43 `attrtype2` tinyint(4) NOT NULL DEFAULT '0',
44 `attrvalue2` smallint(6) NOT NULL DEFAULT '0',
45 `attrtype3` tinyint(4) NOT NULL DEFAULT '0',
46 `attrvalue3` smallint(6) NOT NULL DEFAULT '0',
47 `attrtype4` tinyint(4) NOT NULL DEFAULT '0',
48 `attrvalue4` smallint(6) NOT NULL DEFAULT '0',
49 `attrtype5` tinyint(4) NOT NULL DEFAULT '0',
50 `attrvalue5` smallint(6) NOT NULL DEFAULT '0',
51 `attrtype6` tinyint(4) NOT NULL DEFAULT '0',
52 `attrvalue6` smallint(6) NOT NULL DEFAULT '0',
53 `applytype0` tinyint(4) NOT NULL DEFAULT '0',
54 `applyvalue0` smallint(6) NOT NULL DEFAULT '0',
55 `applytype1` tinyint(4) NOT NULL DEFAULT '0',
56 `applyvalue1` smallint(6) NOT NULL DEFAULT '0',
57 `applytype2` tinyint(4) NOT NULL DEFAULT '0',
58 `applyvalue2` smallint(6) NOT NULL DEFAULT '0',
59 `applytype3` int(11) NOT NULL DEFAULT '0',
60 `applyvalue3` int(11) NOT NULL DEFAULT '0',
61 `applytype4` int(11) NOT NULL DEFAULT '0',
62 `applyvalue4` int(11) NOT NULL DEFAULT '0',
63 `applytype5` int(11) NOT NULL DEFAULT '0',
64 `applyvalue5` int(11) NOT NULL DEFAULT '0',
65 `applytype6` int(11) NOT NULL DEFAULT '0',
66 `applyvalue6` int(11) NOT NULL DEFAULT '0',
67 `applytype7` int(11) NOT NULL DEFAULT '0',
68 `applyvalue7` int(11) NOT NULL DEFAULT '0',
69 PRIMARY KEY (`id`)
70) ENGINE=MyISAM;
71ALTER TABLE `player_gift` ADD UNIQUE `id` (`id`);