 | 感謝分享!!
DB匯入有錯~~求解
[SQL] Query 最終幻想 start
[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 : localhost_3306
Source Server Type : MariaDB
Source Server Version : 100244
Source Host : localhost:3306
Source Schema : 000222
Target Server Type : MariaDB
Target Server Version : 100244
File Encoding : 65001
Date: 19/03/2024 21:13:05
*/
SET NAMES utf8;
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;
-- ----------------------------
-- 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(10) NOT NULL DEFAULT 0,
`add_hpr` int(10) NOT NULL DEFAULT 0,
`add_mpr` int(10) NOT NULL DEFAULT 0,
`add_sp` int(10) NOT NULL DEFAULT 0,
`min_lvl` int(4) UNSIGNED NOT NULL DEFAULT 0,
`max_lvl` int(4) UNSIGNED NOT NULL DEFAULT 0,
`m_def` int(2) NOT NULL DEFAULT 0,
`haste_item` int(2) UNSIGNED NOT NULL DEFAULT 0,
`damage_reduction` int(10) NOT NULL DEFAULT 0,
`weight_reduction`
[SQL] Process terminated
| |