W04k9dtT

1[Err] 1813 - Tablespace for table '`player`.`itemshop_categories`' exists. Please DISCARD the tablespace before IMPORT.
2[Err] /*
3 Navicat Premium Data Transfer
4
5 Source Server         : localhost_3306
6 Source Server Type    : MySQL
7 Source Server Version : 50634
8 Source Host           : localhost:3306
9 Source Schema         : player
10
11 Target Server Type    : MySQL
12 Target Server Version : 50634
13 File Encoding         : 65001
14
15 Date: 27/08/2018 12:31:58
16*/
17
18SET NAMES utf8mb4;
19SET FOREIGN_KEY_CHECKS = 0;
20
21-- ----------------------------
22-- Table structure for itemshop_categories
23-- ----------------------------
24DROP TABLE IF EXISTS `itemshop_categories`;
25CREATE TABLE `itemshop_categories`  (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
28  PRIMARY KEY (`id`) USING BTREE
29) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
30
31-- ----------------------------
32-- Table structure for itemshop_editors
33-- ----------------------------
34DROP TABLE IF EXISTS `itemshop_editors`;
35CREATE TABLE `itemshop_editors`  (
36  `name` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
37) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
38
39-- ----------------------------
40-- Table structure for itemshop_items
41-- ----------------------------
42DROP TABLE IF EXISTS `itemshop_items`;
43CREATE TABLE `itemshop_items`  (
44  `id` int(11) NOT NULL AUTO_INCREMENT,
45  `category` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
46  `vnum` int(11) NOT NULL,
47  `price` int(10) UNSIGNED NOT NULL DEFAULT 0,
48  `count` tinyint(3) NOT NULL,
49  PRIMARY KEY (`id`) USING BTREE,
50  INDEX `item_vnum_index`(`vnum`) USING BTREE
51) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;
52
53SET FOREIGN_KEY_CHECKS = 1;
54[Msg] Finished - Unsuccessfully