- UID
- 35934
- 阅读权限
- 40
- 回帖
- 179
- 喵币
- 0
- 有爱
- 44
- DKP
- 700
- 金币
- 14637
- 在线时间
- 650 小时
- 注册时间
- 2022-12-16
- 最后登录
- 2026-2-15
声望: 527   虚弱: 0

Lv.4(锻造者)
|
发表于 2023-12-12 08:36:48
发表自手机触屏版
|
显示全部楼层
[SQL] Query data start
[ERR] 1051 - Unknown table 'acore_characters.ez_item'
[ERR] DROP TABLE `ez_item`;
CREATE TABLE `ez_item` (
`entry` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`itemset` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`label` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
`itemlevel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`setid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`flag` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`entry`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;
DROP TABLE `ez_set`;
CREATE TABLE `ez_set` (
`entry` INT(10) UNSIGNED NOT NULL,
`name` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
`classMask` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`label` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
`description` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
`parent` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`patch` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`order` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`entry`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;
DROP TABLE `ez_store`;
CREATE TABLE `ez_store` (
`entry` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`entry`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;
DROP TABLE `ez_subscription`;
CREATE TABLE `ez_subscription` (
`entry` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`entry`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;
DROP TABLE `ez_toy`;
CREATE TABLE `ez_toy` (
`entry` INT(10) UNSIGNED NOT NULL,
`flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`sourcetype` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`sourcetext` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
`holiday` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`entry`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;
DROP TABLE `ez_character_collections`;
CREATE TABLE `ez_character_collections` (
`guid` INT(10) UNSIGNED NOT NULL,
`itemid` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`guid`, `itemid`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
DROP TABLE `ez_character_items`;
CREATE TABLE `ez_character_items` (
`guid` INT(10) UNSIGNED NOT NULL,
`itemid` INT(10) UNSIGNED NOT NULL,
`setid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`, `itemid`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
DROP TABLE `ez_character_outfits`;
CREATE TABLE `ez_character_outfits` (
`guid` INT(10) UNSIGNED NOT NULL,
`outfitid` INT(10) UNSIGNED NOT NULL,
`outfitname` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
`prepaidflag` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`outfitdata` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
PRIMARY KEY (`guid`, `outfitid`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;
DROP TABLE `ez_character_toys`;
CREATE TABLE `ez_character_toys` (
`guid` INT(10) UNSIGNED NOT NULL,
`itemid` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`guid`, `itemid`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
DROP TABLE `ez_transmogrification`;
CREATE TABLE `ez_transmogrification` (
`guid` INT(10) UNSIGNED NOT NULL,
`fakeentry` INT(10) UNSIGNED NOT NULL,
`fakeenchant` INT(10) NOT NULL,
`owner` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`guid`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
INSERT INTO `ez_toy` (`entry`, `flags`, `expansion`, `sourcetype`, `sourcetext`, `holiday`) VALUES
(1973, 0, 0, 0, '欺诈宝珠', 0),
(5462, 0, 0, 1, '达图尔的变形魔棒', 0),
(5507, 0, 0, 3, '精制望远镜', 0),
(12185, 0, 0, 1, '血帆舰长之帽', 0),
(13379, 0, 0, 0, '烈焰短笛', 0),
(17712, 0, 0, 6, '冬幕伪装包', 0),
(17716, 0, 0, 3, '雪王9000型', 0),
(18258, 0, 0, 1, '戈多克食人魔装', 0),
(18660, 0, 0, 3, '世界放大器', 0),
(18984, 2, 0, 3, '空间撕裂器 - 永望镇', 0),
(18986, 2, 0, 3, '安全传送器:加基森', 0),
(21540, 0, 0, 1, '艾露恩的灯笼', 0),
(22206, 0, 0, 6, '一束红玫瑰', 0),
(23767, 0, 1,
[SQL] Finished with error
这是咋回事 |
|