I have a Problem with the new Database, i will upload the exile.sql to my database but it doesn't work.
Error msg:
[Err] 1067 - Invalid default value for 'first_connect_at'
[Err] /*
Navicat MySQL Data Transfer
Source Server : ###
Source Server Version : 50628
Source Host : ###
Source Database : ###
Target Server Type : MYSQL
Target Server Version : 50628
File Encoding : 65001
Date: 2015-12-15 01:24:11
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
`uid` varchar(32) NOT NULL,
`clan_id` int(11) unsigned DEFAULT NULL,
`name` varchar(64) NOT NULL,
`money` double NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`kills` int(11) unsigned NOT NULL DEFAULT '0',
`deaths` int(11) unsigned NOT NULL DEFAULT '0',
`first_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_disconnect_at` datetime DEFAULT NULL,
`total_connections` int(11) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`uid`),
KEY `clan_id` (`clan_id`),
CONSTRAINT `account_ibfk_1` FOREIGN KEY (`clan_id`) REFERENCES `clan` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account
-- ----------------------------
-- ----------------------------
-- Table structure for clan
-- ----------------------------
DROP TABLE IF EXISTS `clan`;
CREATE TABLE `clan` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`leader_uid` varchar(32) NOT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`insignia_texture` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `leader_uid` (`leader_uid`),
CONSTRAINT `clan_ibfk_1` FOREIGN KEY (`leader_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clan
-- ----------------------------
-- ----------------------------
-- Table structure for construction
-- ----------------------------
DROP TABLE IF EXISTS `construction`;
CREATE TABLE `construction` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`class` varchar(64) NOT NULL,
`account_uid` varchar(32) NOT NULL,
`spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`position_x` double NOT NULL DEFAULT '0',
`position_y` double NOT NULL DEFAULT '0',
`position_z` double NOT NULL DEFAULT '0',
`direction_x` double NOT NULL DEFAULT '0',
`direction_y` double NOT NULL DEFAULT '0',
`direction_z` double NOT NULL DEFAULT '0',
`up_x` double NOT NULL DEFAULT '0',
`up_y` double NOT NULL DEFAULT '0',
`up_z` double NOT NULL DEFAULT '0',
`is_locked` tinyint(1) NOT NULL DEFAULT '0',
`pin_code` varchar(6) NOT NULL DEFAULT '000000',
`territory_id` int(11) unsigned DEFAULT NULL,
`last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `account_uid` (`account_uid`),
KEY `territory_id` (`territory_id`),
CONSTRAINT `construction_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
CONSTRAINT `construction_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of construction
-- ----------------------------
-- ----------------------------
-- Table structure for container
-- ----------------------------
DROP TABLE IF EXISTS `container`;
CREATE TABLE `container` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`class` varchar(64) NOT NULL,
`spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`account_uid` varchar(32) DEFAULT NULL,
`is_locked` tinyint(1) NOT NULL DEFAULT '0',
`position_x` double NOT NULL DEFAULT '0',
`position_y` double NOT NULL DEFAULT '0',
`position_z` double NOT NULL DEFAULT '0',
`direction_x` double NOT NULL DEFAULT '0',
`direction_y` double NOT NULL DEFAULT '0',
`direction_z` do
[Err] 1067 - Invalid default value for 'died_at'
[Err] CREATE TABLE `player_history` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`account_uid` varchar(32) NOT NULL,
`name` varchar(64) NOT NULL,
`died_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`position_x` double NOT NULL,
`position_y` double NOT NULL,
`position_z` double NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of player_history
-- ----------------------------
-- ----------------------------
-- Table structure for territory
-- ----------------------------
DROP TABLE IF EXISTS `territory`;
CREATE TABLE `territory` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`owner_uid` varchar(32) NOT NULL,
`name` varchar(64) NOT NULL,
`position_x` double NOT NULL,
`position_y` double NOT NULL,
`position_z` double NOT NULL,
`radius` double NOT NULL,
`level` int(11) NOT NULL,
`flag_texture` varchar(255) NOT NULL,
`flag_stolen` tinyint(1) NOT NULL DEFAULT '0',
`flag_stolen_by_uid` varchar(32) DEFAULT NULL,
`flag_stolen_at` datetime DEFAULT NULL,
`flag_steal_message` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_paid_at` datetime DEFAULT CURRENT_TIMESTAMP,
`build_rights` varchar(640) NOT NULL DEFAULT '0',
`moderators` varchar(320) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `owner_uid` (`owner_uid`),
KEY `flag_stolen_by_uid` (`flag_stolen_by_uid`),
CONSTRAINT `territory_ibfk_1` FOREIGN KEY (`owner_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
CONSTRAINT `territory_ibfk_2` FOREIGN KEY (`flag_stolen_by_uid`) REFERENCES `account` (`uid`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of territory
-- ----------------------------
-- ----------------------------
-- Table structure for vehicle
-- ----------------------------
DROP TABLE IF EXISTS `vehicle`;
CREATE TABLE `vehicle` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`class` varchar(64) NOT NULL,
`spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`account_uid` varchar(32) DEFAULT NULL,
`is_locked` tinyint(1) NOT NULL DEFAULT '0',
`fuel` double unsigned NOT NULL DEFAULT '0',
`damage` double unsigned NOT NULL DEFAULT '0',
`hitpoints` text NOT NULL,
`position_x` double NOT NULL DEFAULT '0',
`position_y` double NOT NULL DEFAULT '0',
`position_z` double NOT NULL DEFAULT '0',
`direction_x` double NOT NULL DEFAULT '0',
`direction_y` double NOT NULL DEFAULT '0',
`direction_z` double NOT NULL DEFAULT '0',
`up_x` double NOT NULL DEFAULT '0',
`up_y` double NOT NULL DEFAULT '0',
`up_z` double NOT NULL DEFAULT '1',
`cargo_items` text NOT NULL,
`cargo_magazines` text NOT NULL,
`cargo_weapons` text NOT NULL,
`cargo_container` text NOT NULL,
`last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`pin_code` varchar(6) NOT NULL DEFAULT '000000',
PRIMARY KEY (`id`),
KEY `account_uid` (`account_uid`),
CONSTRAINT `vehicle_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of vehicle
-- ----------------------------
[Msg] Finished - Unsuccessfully
--------------------------------------------------
