· 7 years ago · Feb 03, 2019, 02:36 AM
1[Err] 1046 - No database selected
2[Err] /*
3 Navicat Premium Data Transfer
4
5 Source Server : localhost_3306
6 Source Server Type : MySQL
7 Source Server Version : 50723
8 Source Host : localhost:3306
9 Source Schema : elision
10
11 Target Server Type : MySQL
12 Target Server Version : 50723
13 File Encoding : 65001
14
15 Date: 02/02/2019 12:09:16
16*/
17
18SET NAMES utf8mb4;
19SET FOREIGN_KEY_CHECKS = 0;
20
21-- ----------------------------
22-- Table structure for accounts
23-- ----------------------------
24DROP TABLE IF EXISTS `accounts`;
25CREATE TABLE `accounts` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `name` varchar(13) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
28 `password` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
29 `salt` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
30 `2ndpassword` varchar(134) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
31 `salt2` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
32 `loggedin` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
33 `lastlogin` timestamp(0) NULL DEFAULT NULL,
34 `createdat` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
35 `birthday` date NOT NULL,
36 `banned` tinyint(1) NOT NULL DEFAULT 0,
37 `banreason` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
38 `gm` tinyint(1) NOT NULL DEFAULT 0,
39 `email` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
40 `macs` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
41 `tempban` timestamp(0) NOT NULL,
42 `greason` tinyint(4) UNSIGNED NULL DEFAULT NULL,
43 `ACash` int(11) NOT NULL DEFAULT 0,
44 `mPoints` int(11) NOT NULL DEFAULT 0,
45 `gender` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
46 `SessionIP` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
47 `points` int(11) NOT NULL DEFAULT 0,
48 `vpoints` int(11) NOT NULL DEFAULT 0,
49 `dpoints` int(11) NOT NULL DEFAULT 0,
50 `epoints` int(11) NOT NULL DEFAULT 0,
51 `lastWorld` tinyint(3) NULL DEFAULT NULL,
52 `monthvotes` int(11) NOT NULL DEFAULT 0,
53 `totalvotes` int(11) NOT NULL DEFAULT 0,
54 `lastvote` int(11) NOT NULL DEFAULT 0,
55 `lastvote2` int(11) NOT NULL DEFAULT 0,
56 `lastlogon` timestamp(0) NULL DEFAULT NULL,
57 `lastvoteip` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
58 `webadmin` int(1) NULL DEFAULT 0,
59 `rebirths` int(11) NOT NULL DEFAULT 0,
60 `ip` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
61 `mainchar` int(6) NOT NULL DEFAULT 0,
62 `nxCredit` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
63 `sitelogged` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
64 `nick` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
65 `mute` int(1) UNSIGNED NULL DEFAULT NULL,
66 `RewardPoints` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
67 `rpcap` int(11) NOT NULL DEFAULT 0,
68 `lastGtopVote` datetime(0) NOT NULL,
69 `firstChar` int(1) NOT NULL DEFAULT 0,
70 `tester` int(11) NOT NULL DEFAULT 0,
71 PRIMARY KEY (`id`) USING BTREE,
72 UNIQUE INDEX `name`(`name`) USING BTREE,
73 INDEX `ranking1`(`id`, `banned`, `gm`) USING BTREE,
74 INDEX `id`(`id`) USING BTREE
75) ENGINE = InnoDB AUTO_INCREMENT = 3995 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
76
77-- ----------------------------
78-- Table structure for achievements
79-- ----------------------------
80DROP TABLE IF EXISTS `achievements`;
81CREATE TABLE `achievements` (
82 `achievementid` int(9) NOT NULL DEFAULT 0,
83 `charid` int(9) NOT NULL DEFAULT 0,
84 `accountid` int(11) NOT NULL DEFAULT 0,
85 PRIMARY KEY (`achievementid`, `charid`) USING BTREE,
86 INDEX `achievementid`(`achievementid`) USING BTREE,
87 INDEX `accountid`(`accountid`) USING BTREE,
88 INDEX `charid`(`charid`) USING BTREE
89) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
90
91-- ----------------------------
92-- Table structure for adminlog
93-- ------
94[Err] 1046 - No database selected
95[Err] CREATE TABLE `bbs_replies` (
96 `replyid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
97 `threadid` int(10) UNSIGNED NOT NULL,
98 `postercid` int(10) UNSIGNED NOT NULL,
99 `timestamp` bigint(20) UNSIGNED NOT NULL,
100 `content` varchar(26) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
101 `guildid` int(11) NOT NULL DEFAULT 0,
102 PRIMARY KEY (`replyid`) USING BTREE
103) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
104[Err] 1046 - No database selected
105[Err] -- ----------------------------
106-- Table structure for bbs_threads
107-- ----------------------------
108DROP TABLE IF EXISTS `bbs_threads`;
109CREATE TABLE `bbs_threads` (
110 `threadid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
111 `postercid` int(10) UNSIGNED NOT NULL,
112 `name` varchar(26) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
113 `timestamp` bigint(20) UNSIGNED NOT NULL,
114 `icon` smallint(5) UNSIGNED NOT NULL,
115 `startpost` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
116 `guildid` int(10) UNSIGNED NOT NULL,
117 `localthreadid` int(10) UNSIGNED NOT NULL,
118 PRIMARY KEY (`threadid`) USING BTREE
119) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
120
121-- ----------------------------
122-- Table structure for bcomments
123-- ----------------------------
124DROP TABLE IF EXISTS `bcomments`;
125CREATE TABLE `bcomments` (
126 `id` int(10) NOT NULL AUTO_INCREMENT,
127 `bid` int(10) NOT NULL,
128 `author` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
129 `feedback` int(1) NOT NULL,
130 `date` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
131 `comment` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
132 PRIMARY KEY (`id`) USING BTREE
133) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
134
135-- ----------------------------
136-- Table structure for bit_bcomments
137-- ----------------------------
138DROP TABLE IF EXISTS `bit_bcomments`;
139CREATE TABLE `bit_bcomments` (
140 `id` int(10) NOT NULL AUTO_INCREMENT,
141 `bid` int(10) NOT NULL,
142 `author` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
143 `feedback` int(1) NOT NULL,
144 `date` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
145 `comment` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
146 PRIMARY KEY (`id`) USING BTREE
147) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
148
149-- ----------------------------
150-- Table structure for bit_buynx
151-- ----------------------------
152DROP TABLE IF EXISTS `bit_buynx`;
153CREATE TABLE `bit_buynx` (
154 `id` int(11) NOT NULL AUTO_INCREMENT,
155 `meso` int(11) NOT NULL,
156 `nx` int(11) NOT NULL,
157 PRIMARY KEY (`id`) USING BTREE
158) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
159
160-- ----------------------------
161-- Table structure for bit_ecomments
162-- ----------------------------
163DROP TABLE IF EXISTS `bit_ecomments`;
164CREATE TABLE `bit_ecomments` (
165 `id` int(10) NOT NULL AUTO_INCREMENT,
166 `eid` int(10) NOT NULL,
167 `author` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
168 `feedback` int(1) NOT NULL,
169 `date` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
170 `comment` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
171 PRIMARY KEY (`id`) USING BTREE
172) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
173
174-- ----------------------------
175-- Table structure for bit_events
176-- ----------------------------
177DROP TABLE IF EXISTS `bit_events`;
178CREATE TABLE `bit_events` (
179 `id` int(10) NOT NULL AUTO_INCREMENT,
180 `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
181 `author` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
182 `date` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
183 `type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
184 `status` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
185 `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
186 `views` int(10) NOT NULL DEFAULT 0,
187 `locked` int(10) UNSIGNED NOT NULL DEFAULT 0,
188 PRIMARY KEY (`id`) USING BTREE
189) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
190
191-- ----------------------------
192-- Table structure for bit_gdcache
193-- ----------------------------
194DROP
195[Err] 1046 - No database selected
196[Err] -- ----------------------------
197-- Table structure for familiars
198-- ----------------------------
199DROP TABLE IF EXISTS `familiars`;
200CREATE TABLE `familiars` (
201 `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
202 `characterid` int(11) NOT NULL DEFAULT 0,
203 `familiar` int(11) NOT NULL DEFAULT 0,
204 `name` varchar(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
205 `fatigue` int(11) NOT NULL DEFAULT 0,
206 `expiry` bigint(20) NOT NULL DEFAULT 0,
207 `vitality` tinyint(1) NOT NULL DEFAULT 0,
208 PRIMARY KEY (`id`) USING BTREE
209) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
210
211-- ----------------------------
212-- Table structure for families
213-- ----------------------------
214DROP TABLE IF EXISTS `families`;
215CREATE TABLE `families` (
216 `familyid` int(11) NOT NULL AUTO_INCREMENT,
217 `leaderid` int(11) NOT NULL DEFAULT 0,
218 `notice` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
219 PRIMARY KEY (`familyid`) USING BTREE,
220 INDEX `familyid`(`familyid`) USING BTREE,
221 INDEX `leaderid`(`leaderid`) USING BTREE
222) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
223
224-- ----------------------------
225-- Table structure for favorites
226-- ----------------------------
227DROP TABLE IF EXISTS `favorites`;
228CREATE TABLE `favorites` (
229 `accountid` int(11) NOT NULL,
230 `sn` int(11) NOT NULL,
231 INDEX `accountid`(`accountid`) USING BTREE
232) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
233
234-- ----------------------------
235-- Table structure for gdcache
236-- ----------------------------
237DROP TABLE IF EXISTS `gdcache`;
238CREATE TABLE `gdcache` (
239 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
240 `hash` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
241 `name` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
242 PRIMARY KEY (`id`) USING BTREE
243) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
244
245-- ----------------------------
246-- Table structure for gifts
247-- ----------------------------
248DROP TABLE IF EXISTS `gifts`;
249CREATE TABLE `gifts` (
250 `giftid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
251 `recipient` int(11) NOT NULL DEFAULT 0,
252 `from` varchar(13) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
253 `message` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
254 `sn` int(11) NOT NULL DEFAULT 0,
255 `uniqueid` int(11) NOT NULL DEFAULT 0,
256 PRIMARY KEY (`giftid`) USING BTREE,
257 INDEX `recipient`(`recipient`) USING BTREE
258) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
259
260-- ----------------------------
261-- Table structure for gmblog
262-- ----------------------------
263DROP TABLE IF EXISTS `gmblog`;
264CREATE TABLE `gmblog` (
265 `id` int(10) NOT NULL AUTO_INCREMENT,
266 `title` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
267 `author` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
268 `date` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
269 `content` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
270 `views` int(10) NOT NULL DEFAULT 0,
271 `locked` int(10) UNSIGNED NOT NULL DEFAULT 0,
272 PRIMARY KEY (`id`) USING BTREE
273) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
274
275-- ----------------------------
276-- Table structure for gmlog
277-- ----------------------------
278DROP TABLE IF EXISTS `gmlog`;
279CREATE TABLE `gmlog` (
280 `gmlogid` int(11) NOT NULL AUTO_INCREMENT,
281 `cid` int(11) NOT NULL DEFAULT 0,
282 `command` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
283 `mapid` int(11) NOT NULL DEFAULT 0,
284 `time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
285 PRIMARY KEY (`gmlogid`) USING BTREE
286) ENGINE = InnoDB AUTO_INCREMENT = 4871 CHARACTER SET = lat
287[Err] 1046 - No database selected
288[Err] -- ----------------------------
289-- Table structure for news
290-- ----------------------------
291DROP TABLE IF EXISTS `news`;
292CREATE TABLE `news` (
293 `id` int(10) NOT NULL AUTO_INCREMENT,
294 `title` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
295 `author` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
296 `date` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
297 `type` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
298 `content` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
299 `views` int(10) NOT NULL DEFAULT 0,
300 `locked` int(10) UNSIGNED NOT NULL DEFAULT 0,
301 PRIMARY KEY (`id`) USING BTREE
302) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
303
304-- ----------------------------
305-- Table structure for notes
306-- ----------------------------
307DROP TABLE IF EXISTS `notes`;
308CREATE TABLE `notes` (
309 `id` int(11) NOT NULL AUTO_INCREMENT,
310 `to` varchar(13) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
311 `from` varchar(13) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
312 `message` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
313 `timestamp` bigint(20) UNSIGNED NOT NULL,
314 `gift` tinyint(1) NOT NULL DEFAULT 0,
315 PRIMARY KEY (`id`) USING BTREE,
316 INDEX `to`(`to`) USING BTREE
317) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
318
319-- ----------------------------
320-- Table structure for nxcode
321-- ----------------------------
322DROP TABLE IF EXISTS `nxcode`;
323CREATE TABLE `nxcode` (
324 `code` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
325 `valid` int(11) NOT NULL DEFAULT 1,
326 `user` varchar(13) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
327 `type` int(11) NOT NULL DEFAULT 0,
328 `item` int(11) NOT NULL DEFAULT 10000,
329 `quantity` int(11) NOT NULL DEFAULT 1,
330 PRIMARY KEY (`code`) USING BTREE
331) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
332
333-- ----------------------------
334-- Table structure for online_stats
335-- ----------------------------
336DROP TABLE IF EXISTS `online_stats`;
337CREATE TABLE `online_stats` (
338 `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
339 `timestamp` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
340 `online` int(10) UNSIGNED NOT NULL,
341 PRIMARY KEY (`id`) USING BTREE
342) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
343
344-- ----------------------------
345-- Table structure for oweditems
346-- ----------------------------
347DROP TABLE IF EXISTS `oweditems`;
348CREATE TABLE `oweditems` (
349 `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
350 `characterid` int(11) NOT NULL,
351 `itemid` int(11) NOT NULL,
352 `owner` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
353 PRIMARY KEY (`id`) USING BTREE
354) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
355
356-- ----------------------------
357-- Table structure for pages
358-- ----------------------------
359DROP TABLE IF EXISTS `pages`;
360CREATE TABLE `pages` (
361 `id` int(11) NOT NULL AUTO_INCREMENT,
362 `title` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
363 `slug` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
364 `author` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
365 `content` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
366 `visible` tinyint(1) NOT NULL DEFAULT 1,
367 PRIMARY KEY (`id`) USING BTREE
368) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
369
370-- ----------------------------
371-- Table structure for parttime
372-- ----------------------------
373DROP TABLE IF EXISTS `parttime`;
374CREATE TABLE `parttime` (
375 `id` int(11) NOT NULL AUTO_INCREMENT,
376 `cid` int(11) NOT NULL,
377 `job` tinyint(1) NOT NULL DEFAULT 0,
378 `time` bigint(20) NOT NULL DEF
379[Err] 1046 - No database selected
380[Err] -- ----------------------------
381-- Table structure for website_news
382-- ----------------------------
383DROP TABLE IF EXISTS `website_news`;
384CREATE TABLE `website_news` (
385 `id` int(10) NOT NULL AUTO_INCREMENT,
386 `title` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
387 `author` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
388 `date` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
389 `type` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
390 `content` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
391 `views` int(10) NOT NULL DEFAULT 0,
392 PRIMARY KEY (`id`) USING BTREE
393) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
394
395-- ----------------------------
396-- Table structure for wishlist
397-- ----------------------------
398DROP TABLE IF EXISTS `wishlist`;
399CREATE TABLE `wishlist` (
400 `characterid` int(11) NOT NULL,
401 `sn` int(11) NOT NULL,
402 INDEX `characterid`(`characterid`) USING BTREE
403) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
404
405-- ----------------------------
406-- Table structure for wz_customlife
407-- ----------------------------
408DROP TABLE IF EXISTS `wz_customlife`;
409CREATE TABLE `wz_customlife` (
410 `id` int(11) NOT NULL AUTO_INCREMENT,
411 `dataid` int(11) NOT NULL,
412 `f` int(11) NOT NULL,
413 `hide` tinyint(1) NOT NULL DEFAULT 0,
414 `fh` int(11) NOT NULL,
415 `type` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
416 `cy` int(11) NOT NULL,
417 `rx0` int(11) NOT NULL,
418 `rx1` int(11) NOT NULL,
419 `x` int(11) NOT NULL,
420 `y` int(11) NOT NULL,
421 `mobtime` int(11) NULL DEFAULT 1000,
422 `mid` int(11) NOT NULL,
423 PRIMARY KEY (`id`) USING BTREE
424) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
425
426-- ----------------------------
427-- Table structure for wz_itemadddata
428-- ----------------------------
429DROP TABLE IF EXISTS `wz_itemadddata`;
430CREATE TABLE `wz_itemadddata` (
431 `id` int(11) NOT NULL AUTO_INCREMENT,
432 `itemid` int(11) NOT NULL,
433 `key` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
434 `subKey` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
435 `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
436 PRIMARY KEY (`id`) USING BTREE
437) ENGINE = MyISAM AUTO_INCREMENT = 44066 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
438
439-- ----------------------------
440-- Table structure for wz_itemdata
441-- ----------------------------
442DROP TABLE IF EXISTS `wz_itemdata`;
443CREATE TABLE `wz_itemdata` (
444 `itemid` int(11) NOT NULL,
445 `name` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
446 `msg` varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
447 `desc` varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
448 `slotMax` smallint(5) NOT NULL DEFAULT 1,
449 `price` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1.0',
450 `wholePrice` int(11) NOT NULL DEFAULT -1,
451 `stateChange` int(11) NOT NULL DEFAULT 0,
452 `flags` smallint(4) NOT NULL DEFAULT 0,
453 `karma` tinyint(1) NOT NULL DEFAULT 0,
454 `meso` int(11) NOT NULL DEFAULT 0,
455 `monsterBook` int(11) NOT NULL DEFAULT 0,
456 `itemMakeLevel` smallint(6) NOT NULL DEFAULT 0,
457 `questId` int(11) NOT NULL DEFAULT 0,
458 `scrollReqs` varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
459 `consumeItem` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
460 `totalprob` int(11) NOT NULL DEFAULT 0,
461 `incSkill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
462 `replaceid` int(11) NOT NULL DEFAULT 0,
463 `replacemsg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
464 `create` int(11) NOT NULL DEFAULT 0,
465 `afterImage` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
466 PRIMARY KEY (`itemid`) USING BTREE
467) ENGINE
468[Msg] Finished - Unsuccessfully
469--------------------------------------------------