Добрый день
В сети появилась новая версия, рассчитанная для клиента 3.0.
Взято с
https://github.com/NL0bP/Archeage-Server-emulator
Может подскажете, что не так делаю.
Себе попробовал установить, пишет ошибку, когда добавляю Sql обновления.
Пример ошибки из файла обновления (aaemu_game_2019.05.01.sql):
[Err] 1067 - Invalid default value for 'created_at'
[Err] CREATE TABLE IF NOT EXISTS `actabilities` (
`id` int(10) UNSIGNED NOT NULL,
`point` int(10) UNSIGNED NOT NULL DEFAULT '0',
`step` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`owner` int(10) UNSIGNED NOT NULL,
PRIMARY KEY (`owner`,`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `appellations`;
CREATE TABLE IF NOT EXISTS `appellations` (
`id` int(10) UNSIGNED NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '0',
`owner` int(10) UNSIGNED NOT NULL,
PRIMARY KEY (`id`,`owner`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `blocked`;
CREATE TABLE IF NOT EXISTS `blocked` (
`owner` int(11) NOT NULL,
`blocked_id` int(11) NOT NULL,
PRIMARY KEY (`owner`,`blocked_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `characters`;
CREATE TABLE IF NOT EXISTS `characters` (
`id` int(11) UNSIGNED NOT NULL,
`account_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`access_level` int(3) UNSIGNED NOT NULL DEFAULT '0',
`race` tinyint(2) NOT NULL,
`gender` tinyint(1) NOT NULL,
`unit_model_params` blob NOT NULL,
`level` tinyint(4) NOT NULL,
`expirience` int(11) NOT NULL,
`recoverable_exp` int(11) NOT NULL,
`hp` int(11) NOT NULL,
`mp` int(11) NOT NULL,
`labor_power` mediumint(9) NOT NULL,
`labor_power_modified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`consumed_lp` int(11) NOT NULL,
`ability1` tinyint(4) NOT NULL,
`ability2` tinyint(4) NOT NULL,
`ability3` tinyint(4) NOT NULL,
`world_id` int(11) UNSIGNED NOT NULL,
`zone_id` int(11) UNSIGNED NOT NULL,
`x` float NOT NULL,
`y` float NOT NULL,
`z` float NOT NULL,
`rotation_x` tinyint(4) NOT NULL,
`rotation_y` tinyint(4) NOT NULL,
`rotation_z` tinyint(4) NOT NULL,
`faction_id` int(11) UNSIGNED NOT NULL,
`faction_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`expedition_id` int(11) NOT NULL,
`family` int(11) UNSIGNED NOT NULL,
`dead_count` mediumint(8) UNSIGNED NOT NULL,
`dead_time` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`rez_wait_duration` int(11) NOT NULL,
`rez_time` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`rez_penalty_duration` int(11) NOT NULL,
`leave_time` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`money` bigint(20) NOT NULL,
`money2` bigint(20) NOT NULL,
`honor_point` int(11) NOT NULL,
`vocation_point` int(11) NOT NULL,
`crime_point` int(11) NOT NULL,
`crime_record` int(11) NOT NULL,
`delete_request_time` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`transfer_request_time` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`delete_time` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`bm_point` int(11) NOT NULL,
`auto_use_aapoint` tinyint(1) NOT NULL,
`prev_point` int(11) NOT NULL,
`point` int(11) NOT NULL,
`gift` int(11) NOT NULL,
`num_inv_slot` tinyint(3) UNSIGNED NOT NULL DEFAULT '50',
`num_bank_slot` smallint(5) UNSIGNED NOT NULL DEFAULT '50',
`expanded_expert` tinyint(4) NOT NULL,
`slots` blob NOT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
PRIMARY KEY (`id`,`account_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `completed_quests`;
CREATE TABLE IF NOT EXISTS `completed_quests` (
`id` int(11) UNSIGNED NOT NULL,
`data` tinyblob NOT NULL,
`owner` int(11) UNSIGNED NOT NULL,
PRIMARY KEY (`id`,`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `expeditions`;
CREATE TABLE IF NOT EXISTS `expeditions` (
`id` int(11) NOT NULL,
`owner` int(11) NOT NULL,
`owner_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`mother` int(11) NOT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`,`owner`) USING BTREE
) ENGINE=InnoDB DE
[Msg] Finished - Unsuccessfully
--------------------------------------------------