a5zgt0zT

1USE log;
2
3DROP TABLE IF EXISTS `offlineshop_log`;
4CREATE TABLE `offlineshop_log` (
5  `pid` int(11) NOT NULL,
6  `name` varchar(16) NOT NULL,
7  `item` int(11) NOT NULL,
8  `count` int(3) NOT NULL,
9  `price` bigint(255) NOT NULL,
10  `time` datetime NOT NULL
11) ENGINE=MyISAM DEFAULT CHARSET=latin1;
12SET FOREIGN_KEY_CHECKS=1;
13
14USE player;
15
16ALTER TABLE player ADD shop_money bigint(16) NOT NULL AFTER gold;
17ALTER TABLE player_deleted ADD shop_money bigint(16) NOT NULL AFTER gold;
18
19DROP TABLE IF EXISTS `offline_shop_npc`;
20CREATE TABLE `offline_shop_npc` (
21  `owner_id` int(11) NOT NULL DEFAULT '0',
22  `sign` varchar(900) CHARACTER SET utf32 COLLATE utf32_romanian_ci DEFAULT NULL,
23  `name` varchar(32) DEFAULT NULL,
24  `time` int(11) DEFAULT NULL,
25  `x` int(11) DEFAULT NULL,
26  `y` int(11) DEFAULT NULL,
27  `z` int(11) DEFAULT NULL,
28  `mapIndex` int(11) DEFAULT NULL,
29  `channel` int(2) DEFAULT NULL,
30  `npc_decoration` int(10) DEFAULT '30000',
31  PRIMARY KEY (`owner_id`)
32) ENGINE=MyISAM DEFAULT CHARSET=latin1;
33SET FOREIGN_KEY_CHECKS=1;
34
35DROP TABLE IF EXISTS `offline_shop_item`;
36CREATE TABLE `offline_shop_item` (
37  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
38  `owner_id` int(11) unsigned NOT NULL DEFAULT '0',
39  `pos` smallint(5) unsigned NOT NULL DEFAULT '0',
40  `count` tinyint(3) unsigned NOT NULL DEFAULT '0',
41  `vnum` int(11) unsigned NOT NULL DEFAULT '0',
42  `socket0` int(10) unsigned NOT NULL DEFAULT '0',
43  `socket1` int(10) unsigned NOT NULL DEFAULT '0',
44  `socket2` int(10) unsigned NOT NULL DEFAULT '0',
45  `socket3` int(10) unsigned NOT NULL DEFAULT '0',
46  `socket4` int(10) unsigned NOT NULL DEFAULT '0',
47  `socket5` int(10) unsigned NOT NULL DEFAULT '0',
48  `attrtype0` tinyint(4) NOT NULL DEFAULT '0',
49  `attrvalue0` smallint(6) NOT NULL DEFAULT '0',
50  `attrtype1` tinyint(4) NOT NULL DEFAULT '0',
51  `attrvalue1` smallint(6) NOT NULL DEFAULT '0',
52  `attrtype2` tinyint(4) NOT NULL DEFAULT '0',
53  `attrvalue2` smallint(6) NOT NULL DEFAULT '0',
54  `attrtype3` tinyint(4) NOT NULL DEFAULT '0',
55  `attrvalue3` smallint(6) NOT NULL DEFAULT '0',
56  `attrtype4` tinyint(4) NOT NULL DEFAULT '0',
57  `attrvalue4` smallint(6) NOT NULL DEFAULT '0',
58  `attrtype5` tinyint(4) NOT NULL DEFAULT '0',
59  `attrvalue5` smallint(6) NOT NULL DEFAULT '0',
60  `attrtype6` tinyint(4) NOT NULL DEFAULT '0',
61  `attrvalue6` smallint(6) NOT NULL DEFAULT '0',
62  `applytype0` tinyint(4) NOT NULL DEFAULT '0',
63  `applyvalue0` smallint(6) NOT NULL DEFAULT '0',
64  `applytype1` tinyint(4) NOT NULL DEFAULT '0',
65  `applyvalue1` smallint(6) NOT NULL DEFAULT '0',
66  `applytype2` tinyint(4) NOT NULL DEFAULT '0',
67  `applyvalue2` smallint(6) NOT NULL DEFAULT '0',
68  `applytype3` int(11) NOT NULL DEFAULT '0',
69  `applyvalue3` int(11) NOT NULL DEFAULT '0',
70  `applytype4` int(11) NOT NULL DEFAULT '0',
71  `applyvalue4` int(11) NOT NULL DEFAULT '0',
72  `applytype5` int(11) NOT NULL DEFAULT '0',
73  `applyvalue5` int(11) NOT NULL DEFAULT '0',
74  `applytype6` int(11) NOT NULL DEFAULT '0',
75  `applyvalue6` int(11) NOT NULL DEFAULT '0',
76  `applytype7` int(11) NOT NULL DEFAULT '0',
77  `applyvalue7` int(11) NOT NULL DEFAULT '0',  
78  `price` bigint(15) NOT NULL DEFAULT '0',
79  `status` smallint(1) NOT NULL DEFAULT '0',
80  PRIMARY KEY (`id`),
81  KEY `owner_id_idx` (`owner_id`),
82  KEY `item_vnum_index` (`vnum`)
83) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;