· 6 years ago · Jun 10, 2019, 10:32 AM
1[SQL] Query account start
2[ERR] 1067 - Invalid default value for 'create_time'
3[ERR] /*
4Navicat MySQL Data Transfer
5
6Source Server : Project Legacy Server
7Source Server Version : 50561
8Source Host : 178.62.102.108:3306
9Source Database : account
10
11Target Server Type : MYSQL
12Target Server Version : 50561
13File Encoding : 65001
14
15Date: 2019-06-05 19:09:02
16*/
17
18SET FOREIGN_KEY_CHECKS=0;
19
20-- ----------------------------
21-- Table structure for account
22-- ----------------------------
23DROP TABLE IF EXISTS `account`;
24CREATE TABLE `account` (
25 `id` int(11) NOT NULL AUTO_INCREMENT,
26 `login` varchar(30) NOT NULL DEFAULT '',
27 `password` varchar(45) NOT NULL DEFAULT '',
28 `remember_token` varchar(256) DEFAULT NULL,
29 `real_name` varchar(30) NOT NULL DEFAULT '',
30 `social_id` varchar(7) NOT NULL DEFAULT '',
31 `email` varchar(64) NOT NULL DEFAULT '',
32 `phone1` varchar(16) DEFAULT NULL,
33 `phone2` varchar(16) DEFAULT NULL,
34 `address` varchar(128) DEFAULT NULL,
35 `zipcode` varchar(7) NOT NULL DEFAULT '',
36 `create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
37 `question1` varchar(48) DEFAULT NULL,
38 `answer1` varchar(48) DEFAULT NULL,
39 `question2` varchar(48) DEFAULT NULL,
40 `answer2` varchar(48) DEFAULT NULL,
41 `is_testor` tinyint(1) NOT NULL DEFAULT '0',
42 `status` varchar(9) NOT NULL DEFAULT 'OK',
43 `razao` text,
44 `securitycode` varchar(192) DEFAULT '',
45 `newsletter` tinyint(1) NOT NULL DEFAULT '0',
46 `empire` tinyint(4) NOT NULL DEFAULT '0',
47 `name_checked` tinyint(1) NOT NULL DEFAULT '0',
48 `availDt` datetime 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 NOT NULL DEFAULT '0000-00-00 00:00:00',
52 `silver_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
53 `safebox_expire` datetime NOT NULL DEFAULT '2090-01-01 00:00:00',
54 `autoloot_expire` datetime NOT NULL DEFAULT '2090-01-01 00:00:00',
55 `fish_mind_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
56 `marriage_fast_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
57 `money_drop_rate_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
58 `ttl_cash` int(11) NOT NULL DEFAULT '0',
59 `ttl_mileage` int(11) NOT NULL DEFAULT '0',
60 `channel_company` varchar(30) NOT NULL DEFAULT '',
61 `coins` int(11) unsigned NOT NULL DEFAULT '0',
62 `shields` int(11) NOT NULL DEFAULT '0',
63 `resets` int(11) NOT NULL DEFAULT '0',
64 `web_admin` int(1) NOT NULL DEFAULT '0',
65 `last_play` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
66 `website` datetime DEFAULT NULL,
67 `last_ip` varchar(255) DEFAULT '',
68 `register_ip` varchar(255) DEFAULT NULL,
69 `ban_until` datetime DEFAULT NULL,
70 `ban_reason` varchar(255) DEFAULT NULL,
71 `referrer` varchar(255) DEFAULT NULL,
72 `rb_points` int(11) NOT NULL DEFAULT '0',
73 `reason` varchar(256) DEFAULT NULL,
74 `country` varchar(256) NOT NULL DEFAULT '',
75 PRIMARY KEY (`id`),
76 UNIQUE KEY `login` (`login`),
77 KEY `social_id` (`social_id`)
78) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=big5;
79
80-- ----------------------------
81-- Records of account
82-- ----------------------------
83INSERT INTO `account` VALUES ('4', 'New', '*E6CC90B878B948C35E92B003C792C46C58C4AF40', 'mpv9aJSKIbWe7bxwnqBpaRao3mpwC3dqdPhuooXH3UQMI4q0ou9wsYlfQMON', '', '1234567', '', null, null, null, '', '0000-00-00 00:00:00', null, null, null, null, '0', 'OK', null, '', '0', '0', '0', '0000-00-00 00:00:00', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2090-01-01 00:00:00', '2090-01-01 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '0', '', '0', '0', '0', '0', '2019-02-10 18:56:50', null, null, null, null, null, null, '0', null, 'fr');
84INSERT INTO `account` VALUES ('2', 'Jorge', '*E6CC90B878B948C35E92B003C792C46C58C4AF40', null, '', '1234567', '', null, null, null, '', '0000-00-00 00:00:00', null, null, null, null, '0', 'OK', null, '', '0', '0', '0', '0000-00-00 00:00:00', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2090-01-01 00:00:00', '2090-01-01 00:00:00', '0000-00-00 00:00
85[SQL] Finished successfully with error