載入DB庫 發生問題

KEKE

	[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0) NULL DEFAULT NULL,   `access_level` int(11) NULL DEFAULT NULL,   `ip` varc' at line 4 [Err] /* Navicat Premium Data Transfer Source Server         : Lineage Source Server Type    : MariaDB Source Server Version : 100244 Source Host           : localhost:3306 Source Schema         : test Target Server Type    : MariaDB Target Server Version : 100244 File Encoding         : 65001 Date: 05/04/2026 15:42:59 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for accounts -- ---------------------------- DROP TABLE IF EXISTS `accounts`; CREATE TABLE `accounts`  (   `login` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',   `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,   `lastactive` datetime(0) NULL DEFAULT NULL,   `access_level` int(11) NULL DEFAULT NULL,   `ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',   `host` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,   `banned` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否連線服務器',   `character_slot` int(2) UNSIGNED NOT NULL DEFAULT 0,   `spw` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,   `warehouse` int(10) NOT NULL DEFAULT 0,   `server_no` int(10) NOT NULL DEFAULT 0 COMMENT '登入服務器編號 (目前未使用)',   `already_login` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '今日是否登錄過遊戲',   `glory_points` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '榮耀點數 當前數值',   `glory_points_slot` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '榮耀點數 擴充恢復',   `glory_points_limit` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '榮耀點數 擴充上限',   `滿額紀錄` int(10) NOT NULL DEFAULT 0,   `累儲紀錄` int(10) NOT NULL DEFAULT 0,   `累消紀錄` int(10) NOT NULL DEFAULT 0,   `累儲金額` int(10) NOT NULL DEFAULT 0,   `累消金額` int(10) NOT NULL DEFAULT 0,   PRIMARY KEY (`login`) USING BTREE,   INDEX `login`(`login`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'MyISAM free: 3072 kB' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of accounts -- ---------------------------- INSERT INTO `accounts` VALUES ('1011', '1011', '2026-04-01 22:54:42', 200, '127.0.0.1', '36.147.127.208', 0, 0, '未建立超級密碼', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 120196); INSERT INTO `accounts` VALUES ('1111', '1111', '2026-04-04 19:55:44', 200, '127.0.0.1', '127.0.0.1', 0, 0, '未建立超級密碼', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 198484); -- ---------------------------- -- Table structure for armor -- ---------------------------- DROP TABLE IF EXISTS `armor`; CREATE TABLE `armor`  (   `item_id` int(5) NOT NULL AUTO_INCREMENT,   `name` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'NULL',   `exp_point` int(5) NOT NULL DEFAULT 0,   `classname` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',   `name_id` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',   `type` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',   `material` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',   `weight` int(7) UNSIGNED NOT NULL DEFAULT 0,   `invgfx` int(5) UNSIGNED NOT NULL DEFAULT 0,   `grdgfx` int(5) UNSIGNED NOT NULL DEFAULT 0,   `itemdesc_id` int(10) NOT NULL DEFAULT 0,   `ac` int(3) NOT NULL DEFAULT 0,   `safenchant` int(2) NOT NULL DEFAULT 0,   `use_royal` int(2) UNSIGNED NOT NULL DEFAULT 0,   `use_knight` int(2) UNSIGNED NOT NULL DEFAULT 0,   `use_mage` int(2) UNSIGNED NOT NULL DEFAULT 0,   `use_elf` int(2) UNSIGNED NOT NULL DEFAULT 0,   `use_darkelf` int(2) UNSIGNED NOT NULL DEFAULT 0,   `use_dragonknight` int(2) UNSIGNED NOT NULL DEFAULT 0,   `use_illusionist` int(2) UNSIGNED NOT NULL DEFAULT 0,   `use_warrior` int(2) UNSIGNED NOT NULL DEFAULT 0,   `add_str` int(2) NOT NULL DEFAULT 0,   `add_con` int(2) NOT NULL DEFAULT 0,   `add_dex` int(2) NOT NULL DEFAULT 0,   `add_int` int(2) NOT NULL DEFAULT 0,   `add_wis` int(2) NOT NULL DEFAULT 0,   `add_cha` int(2) NOT NULL DEFAULT 0,   `add_hp` int(10) NOT NULL DEFAULT 0,   `add_mp` int( [Err] 1146 - Table 'test.armor' doesn't exist [Err] INSERT INTO `armor` VALUES (20093, '古老的長袍', 0, '0', '$1948', 'armor', 'cloth', 30000, 900, 9, 669, -12, 2, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 2, 0, 0, 60, 20, 0, 12, 1, 45, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `armor` VALUES (20094, '古老的鱗甲', 0, '0', '$1949', 'armor', 'dragonscale', 200000, 901, 9, 670, -12, 2, 1, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 1, 1, 0, 150, 25, 8, 4, 0, 45, 0, 5, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `armor` VALUES (20095, '古老的金屬盔甲', 0, '0', '$1946', 'armor', 'iron', 280000, 899, 9, 667, -16, 2, 0, 1, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 80, 50, 5, 0, 0, 45, 0, 5, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `armor` VALUES (20096, '環甲', 0, '0', '$164', 'armor', 'iron', 250000, 86, 3838, 0, -3, 4, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `armor` VALUES (20097, '木甲', 0, '0', '$781', 'armor', 'wood', 80000, 109, 9, 0, -3, 4, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 請問解決方式???