E6de35P9

1/*
2 Navicat Premium Data Transfer
3
4 Source Server         : Lirium
5 Source Server Type    : MySQL
6 Source Server Version : 50727
7 Source Host           : 213.32.6.224:3306
8 Source Schema         : lirium_player
9
10 Target Server Type    : MySQL
11 Target Server Version : 50727
12 File Encoding         : 65001
13
14 Date: 15/12/2019 16:03:31
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for itemshop_categories
22-- ----------------------------
23DROP TABLE IF EXISTS `itemshop_categories`;
24CREATE TABLE `itemshop_categories`  (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
27  PRIMARY KEY (`id`) USING BTREE
28) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
29
30-- ----------------------------
31-- Table structure for itemshop_editors
32-- ----------------------------
33DROP TABLE IF EXISTS `itemshop_editors`;
34CREATE TABLE `itemshop_editors`  (
35  `name` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
36) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
37
38-- ----------------------------
39-- Table structure for itemshop_items
40-- ----------------------------
41DROP TABLE IF EXISTS `itemshop_items`;
42CREATE TABLE `itemshop_items`  (
43  `id` int(11) NOT NULL AUTO_INCREMENT,
44  `category` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
45  `vnum` int(11) NOT NULL,
46  `price` int(10) UNSIGNED NOT NULL DEFAULT 0,
47  `count` smallint(3) NOT NULL,
48  `socket0` int(10) UNSIGNED NOT NULL DEFAULT 0,
49  `socket1` int(10) UNSIGNED NOT NULL DEFAULT 0,
50  `socket2` int(10) UNSIGNED NOT NULL DEFAULT 0,
51  `socket3` int(10) UNSIGNED NOT NULL DEFAULT 0,
52  `socket4` int(10) UNSIGNED NOT NULL DEFAULT 0,
53  `socket5` int(10) UNSIGNED NOT NULL DEFAULT 0,
54  `attrtype0` tinyint(4) NOT NULL DEFAULT 0,
55  `attrvalue0` smallint(6) NOT NULL DEFAULT 0,
56  `attrtype1` tinyint(4) NOT NULL DEFAULT 0,
57  `attrvalue1` smallint(6) NOT NULL DEFAULT 0,
58  `attrtype2` tinyint(4) NOT NULL DEFAULT 0,
59  `attrvalue2` smallint(6) NOT NULL DEFAULT 0,
60  `attrtype3` tinyint(4) NOT NULL DEFAULT 0,
61  `attrvalue3` smallint(6) NOT NULL DEFAULT 0,
62  `attrtype4` tinyint(4) NOT NULL DEFAULT 0,
63  `attrvalue4` smallint(6) NOT NULL DEFAULT 0,
64  `attrtype5` tinyint(4) NOT NULL DEFAULT 0,
65  `attrvalue5` smallint(6) NOT NULL DEFAULT 0,
66  `attrtype6` tinyint(4) NOT NULL DEFAULT 0,
67  `attrvalue6` smallint(6) NOT NULL DEFAULT 0,
68  `fixed_count` tinyint(1) NOT NULL DEFAULT 1,
69  PRIMARY KEY (`id`) USING BTREE,
70  INDEX `item_vnum_index`(`vnum`) USING BTREE
71) ENGINE = MyISAM AUTO_INCREMENT = 339 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;
72
73SET FOREIGN_KEY_CHECKS = 1;