· 6 years ago · Nov 01, 2019, 12:18 AM
1[SQL] Query account start
2[ERR] 1067 - Invalid default value for 'create_time'
3[ERR] /*
4 Navicat Premium Data Transfer
5
6 Source Server : 10.229.1.241
7 Source Server Type : MySQL
8 Source Server Version : 50727
9 Source Host : 10.229.1.241:3306
10 Source Schema : MT2_account
11
12 Target Server Type : MySQL
13 Target Server Version : 50727
14 File Encoding : 65001
15
16 Date: 31/10/2019 15:22:46
17*/
18
19SET NAMES utf8mb4;
20SET FOREIGN_KEY_CHECKS = 0;
21
22-- ----------------------------
23-- Table structure for account
24-- ----------------------------
25DROP TABLE IF EXISTS `account`;
26CREATE TABLE `account` (
27 `id` int(11) NOT NULL AUTO_INCREMENT,
28 `login` varchar(24) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
29 `password` varchar(45) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
30 `real_name` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT '',
31 `social_id` varchar(13) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
32 `email` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
33 `phone1` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
34 `phone2` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
35 `address` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
36 `zipcode` varchar(7) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT '',
37 `create_time` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
38 `question1` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
39 `answer1` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
40 `question2` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
41 `answer2` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
42 `is_testor` tinyint(1) NOT NULL DEFAULT 0,
43 `status` varchar(8) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT 'OK',
44 `securitycode` varchar(192) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT '',
45 `newsletter` tinyint(1) NULL DEFAULT 0,
46 `empire` tinyint(4) NOT NULL DEFAULT 0,
47 `name_checked` tinyint(1) NOT NULL DEFAULT 0,
48 `availDt` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
49 `mileage` int(11) NOT NULL DEFAULT 0,
50 `cash` int(11) NOT NULL DEFAULT 0,
51 `gold_expire` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
52 `silver_expire` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
53 `safebox_expire` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
54 `autoloot_expire` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
55 `fish_mind_expire` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
56 `marriage_fast_expire` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
57 `money_drop_rate_expire` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
58 `last_play` datetime(0) NULL DEFAULT NULL,
59 `web_admin` int(1) NOT NULL DEFAULT 0,
60 `web_ip` varchar(15) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
61 `web_confirm` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
62 PRIMARY KEY (`id`) USING BTREE,
63 UNIQUE INDEX `login`(`login`) USING BTREE,
64 INDEX `social_id`(`social_id`) USING BTREE
65) ENGINE = MyISAM AUTO_INCREMENT = 55570 CHARACTER SET = ascii COLLATE = ascii_general_ci ROW_FORMAT = Dynamic;
66
67-- ----------------------------
68-- Records of account
69-- ----------------------------
70INSERT INTO `account` VALUES (1, 'Terenzo', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9', '', '1234567', '', '', '', '', '', '0000-00-00 00:00:00', '', '', '', '', 0, 'OK', '', 0, 0, 0, '0000-00-00 00:00:00', 0, 4438, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2015-08-24 10:41:55', 1, '192.168.1.11', '');
71INSERT INTO `account` VALUES (2, 'kuba261096', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9', '', '1234567', '', '', '', '', '', '0000-00-00 00:00:00', '', '', '', '', 0, 'OK', '', 0, 0, 0, '0000-00-0
72[SQL] Finished with error