diff options
| author | Kitzunu <24550914+Kitzunu@users.noreply.github.com> | 2022-04-24 15:56:31 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-04-24 15:56:31 +0200 |
| commit | b4bcdd94d1ff87d88ff3343190def9f0d9145ea4 (patch) | |
| tree | c327d17175cbfbf64deeac35045790404e9aff75 /data/sql/base/db_characters | |
| parent | 6950eb0cd003a4334710aac340cc719b61f40933 (diff) | |
feat(DB): release ACDB 6.0.0 (#11515)
Diffstat (limited to 'data/sql/base/db_characters')
100 files changed, 948 insertions, 783 deletions
diff --git a/data/sql/base/db_characters/account_data.sql b/data/sql/base/db_characters/account_data.sql index ee9f290686..4eb10bfc84 100644 --- a/data/sql/base/db_characters/account_data.sql +++ b/data/sql/base/db_characters/account_data.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.account_data +-- Dumpar struktur för tabell acore_characters.account_data DROP TABLE IF EXISTS `account_data`; CREATE TABLE IF NOT EXISTS `account_data` ( `accountId` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Account Identifier', @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `account_data` ( PRIMARY KEY (`accountId`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.account_data: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.account_data: ~0 rows (ungefär) DELETE FROM `account_data`; /*!40000 ALTER TABLE `account_data` DISABLE KEYS */; /*!40000 ALTER TABLE `account_data` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/account_instance_times.sql b/data/sql/base/db_characters/account_instance_times.sql index e4c4632dd1..44964c48ca 100644 --- a/data/sql/base/db_characters/account_instance_times.sql +++ b/data/sql/base/db_characters/account_instance_times.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.account_instance_times +-- Dumpar struktur för tabell acore_characters.account_instance_times DROP TABLE IF EXISTS `account_instance_times`; CREATE TABLE IF NOT EXISTS `account_instance_times` ( `accountId` INT unsigned NOT NULL, @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `account_instance_times` ( PRIMARY KEY (`accountId`,`instanceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.account_instance_times: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.account_instance_times: ~0 rows (ungefär) DELETE FROM `account_instance_times`; /*!40000 ALTER TABLE `account_instance_times` DISABLE KEYS */; /*!40000 ALTER TABLE `account_instance_times` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/account_tutorial.sql b/data/sql/base/db_characters/account_tutorial.sql index ecff9a7ec4..b075e9de3f 100644 --- a/data/sql/base/db_characters/account_tutorial.sql +++ b/data/sql/base/db_characters/account_tutorial.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.account_tutorial +-- Dumpar struktur för tabell acore_characters.account_tutorial DROP TABLE IF EXISTS `account_tutorial`; CREATE TABLE IF NOT EXISTS `account_tutorial` ( `accountId` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Account Identifier', @@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS `account_tutorial` ( PRIMARY KEY (`accountId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.account_tutorial: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.account_tutorial: ~0 rows (ungefär) DELETE FROM `account_tutorial`; /*!40000 ALTER TABLE `account_tutorial` DISABLE KEYS */; /*!40000 ALTER TABLE `account_tutorial` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/addons.sql b/data/sql/base/db_characters/addons.sql index 95e89f82c3..a902fc62cf 100644 --- a/data/sql/base/db_characters/addons.sql +++ b/data/sql/base/db_characters/addons.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,15 +12,15 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.addons +-- Dumpar struktur för tabell acore_characters.addons DROP TABLE IF EXISTS `addons`; CREATE TABLE IF NOT EXISTS `addons` ( - `name` varchar(120) NOT NULL DEFAULT '', + `name` VARCHAR(120) NOT NULL DEFAULT '', `crc` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Addons'; --- Дамп данных таблицы acore_characters.addons: ~23 rows (приблизительно) +-- Dumpar data för tabell acore_characters.addons: ~23 rows (ungefär) DELETE FROM `addons`; /*!40000 ALTER TABLE `addons` DISABLE KEYS */; INSERT INTO `addons` (`name`, `crc`) VALUES diff --git a/data/sql/base/db_characters/arena_team.sql b/data/sql/base/db_characters/arena_team.sql index a59fbd6836..c034c81c08 100644 --- a/data/sql/base/db_characters/arena_team.sql +++ b/data/sql/base/db_characters/arena_team.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,11 +12,11 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.arena_team +-- Dumpar struktur för tabell acore_characters.arena_team DROP TABLE IF EXISTS `arena_team`; CREATE TABLE IF NOT EXISTS `arena_team` ( `arenaTeamId` INT unsigned NOT NULL DEFAULT 0, - `name` varchar(24) NOT NULL, + `name` VARCHAR(24) NOT NULL, `captainGuid` INT unsigned NOT NULL DEFAULT 0, `type` TINYINT unsigned NOT NULL DEFAULT 0, `rating` SMALLINT unsigned NOT NULL DEFAULT 0, @@ -33,7 +33,7 @@ CREATE TABLE IF NOT EXISTS `arena_team` ( PRIMARY KEY (`arenaTeamId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.arena_team: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.arena_team: ~0 rows (ungefär) DELETE FROM `arena_team`; /*!40000 ALTER TABLE `arena_team` DISABLE KEYS */; /*!40000 ALTER TABLE `arena_team` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/arena_team_member.sql b/data/sql/base/db_characters/arena_team_member.sql index caeac61775..654686efe0 100644 --- a/data/sql/base/db_characters/arena_team_member.sql +++ b/data/sql/base/db_characters/arena_team_member.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.arena_team_member +-- Dumpar struktur för tabell acore_characters.arena_team_member DROP TABLE IF EXISTS `arena_team_member`; CREATE TABLE IF NOT EXISTS `arena_team_member` ( `arenaTeamId` INT unsigned NOT NULL DEFAULT 0, @@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS `arena_team_member` ( PRIMARY KEY (`arenaTeamId`,`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.arena_team_member: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.arena_team_member: ~0 rows (ungefär) DELETE FROM `arena_team_member`; /*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */; /*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/auctionhouse.sql b/data/sql/base/db_characters/auctionhouse.sql index 97becf10a5..d9733febe5 100644 --- a/data/sql/base/db_characters/auctionhouse.sql +++ b/data/sql/base/db_characters/auctionhouse.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,11 +12,11 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.auctionhouse +-- Dumpar struktur för tabell acore_characters.auctionhouse DROP TABLE IF EXISTS `auctionhouse`; CREATE TABLE IF NOT EXISTS `auctionhouse` ( `id` INT unsigned NOT NULL DEFAULT 0, - `houseid` TINYINT unsigned NOT NULL DEFAULT 7, + `houseid` TINYINT unsigned NOT NULL DEFAULT '7', `itemguid` INT unsigned NOT NULL DEFAULT 0, `itemowner` INT unsigned NOT NULL DEFAULT 0, `buyoutprice` INT unsigned NOT NULL DEFAULT 0, @@ -29,7 +29,7 @@ CREATE TABLE IF NOT EXISTS `auctionhouse` ( UNIQUE KEY `item_guid` (`itemguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.auctionhouse: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.auctionhouse: ~0 rows (ungefär) DELETE FROM `auctionhouse`; /*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */; /*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/banned_addons.sql b/data/sql/base/db_characters/banned_addons.sql index 1a3af42e1f..6e76663801 100644 --- a/data/sql/base/db_characters/banned_addons.sql +++ b/data/sql/base/db_characters/banned_addons.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,18 +12,18 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.banned_addons +-- Dumpar struktur för tabell acore_characters.banned_addons DROP TABLE IF EXISTS `banned_addons`; CREATE TABLE IF NOT EXISTS `banned_addons` ( `Id` INT unsigned NOT NULL AUTO_INCREMENT, - `Name` varchar(255) NOT NULL, - `Version` varchar(255) NOT NULL DEFAULT '', - `Timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), + `Name` VARCHAR(255) NOT NULL, + `Version` VARCHAR(255) NOT NULL DEFAULT '', + `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`Id`), UNIQUE KEY `idx_name_ver` (`Name`,`Version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.banned_addons: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.banned_addons: ~0 rows (ungefär) DELETE FROM `banned_addons`; /*!40000 ALTER TABLE `banned_addons` DISABLE KEYS */; /*!40000 ALTER TABLE `banned_addons` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/battleground_deserters.sql b/data/sql/base/db_characters/battleground_deserters.sql index d1a7e7d89b..d458ab34d4 100644 --- a/data/sql/base/db_characters/battleground_deserters.sql +++ b/data/sql/base/db_characters/battleground_deserters.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.battleground_deserters +-- Dumpar struktur för tabell acore_characters.battleground_deserters DROP TABLE IF EXISTS `battleground_deserters`; CREATE TABLE IF NOT EXISTS `battleground_deserters` ( `guid` INT unsigned NOT NULL COMMENT 'characters.guid', @@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `battleground_deserters` ( `datetime` datetime NOT NULL COMMENT 'datetime of the desertion' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --- Дамп данных таблицы acore_characters.battleground_deserters: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.battleground_deserters: ~0 rows (ungefär) DELETE FROM `battleground_deserters`; /*!40000 ALTER TABLE `battleground_deserters` DISABLE KEYS */; /*!40000 ALTER TABLE `battleground_deserters` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/bugreport.sql b/data/sql/base/db_characters/bugreport.sql index e0d3ffcbf4..e5f3fa81ff 100644 --- a/data/sql/base/db_characters/bugreport.sql +++ b/data/sql/base/db_characters/bugreport.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.bugreport +-- Dumpar struktur för tabell acore_characters.bugreport DROP TABLE IF EXISTS `bugreport`; CREATE TABLE IF NOT EXISTS `bugreport` ( `id` INT unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `bugreport` ( PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Debug System'; --- Дамп данных таблицы acore_characters.bugreport: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.bugreport: ~0 rows (ungefär) DELETE FROM `bugreport`; /*!40000 ALTER TABLE `bugreport` DISABLE KEYS */; /*!40000 ALTER TABLE `bugreport` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/calendar_events.sql b/data/sql/base/db_characters/calendar_events.sql index a68ece0ee1..1282b8655a 100644 --- a/data/sql/base/db_characters/calendar_events.sql +++ b/data/sql/base/db_characters/calendar_events.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,22 +12,22 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.calendar_events +-- Dumpar struktur för tabell acore_characters.calendar_events DROP TABLE IF EXISTS `calendar_events`; CREATE TABLE IF NOT EXISTS `calendar_events` ( `id` BIGINT unsigned NOT NULL DEFAULT 0, `creator` INT unsigned NOT NULL DEFAULT 0, - `title` varchar(255) NOT NULL DEFAULT '', - `description` varchar(255) NOT NULL DEFAULT '', - `type` TINYINT unsigned NOT NULL DEFAULT 4, - `dungeon` INT NOT NULL DEFAULT -1, + `title` VARCHAR(255) NOT NULL DEFAULT '', + `description` VARCHAR(255) NOT NULL DEFAULT '', + `type` TINYINT unsigned NOT NULL DEFAULT '4', + `dungeon` INT NOT NULL DEFAULT '-1', `eventtime` INT unsigned NOT NULL DEFAULT 0, `flags` INT unsigned NOT NULL DEFAULT 0, `time2` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.calendar_events: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.calendar_events: ~0 rows (ungefär) DELETE FROM `calendar_events`; /*!40000 ALTER TABLE `calendar_events` DISABLE KEYS */; /*!40000 ALTER TABLE `calendar_events` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/calendar_invites.sql b/data/sql/base/db_characters/calendar_invites.sql index df77a426df..f784addb10 100644 --- a/data/sql/base/db_characters/calendar_invites.sql +++ b/data/sql/base/db_characters/calendar_invites.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.calendar_invites +-- Dumpar struktur för tabell acore_characters.calendar_invites DROP TABLE IF EXISTS `calendar_invites`; CREATE TABLE IF NOT EXISTS `calendar_invites` ( `id` BIGINT unsigned NOT NULL DEFAULT 0, @@ -22,11 +22,11 @@ CREATE TABLE IF NOT EXISTS `calendar_invites` ( `status` TINYINT unsigned NOT NULL DEFAULT 0, `statustime` INT unsigned NOT NULL DEFAULT 0, `rank` TINYINT unsigned NOT NULL DEFAULT 0, - `text` varchar(255) NOT NULL DEFAULT '', + `text` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.calendar_invites: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.calendar_invites: ~0 rows (ungefär) DELETE FROM `calendar_invites`; /*!40000 ALTER TABLE `calendar_invites` DISABLE KEYS */; /*!40000 ALTER TABLE `calendar_invites` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/channels.sql b/data/sql/base/db_characters/channels.sql index bdd105dd1c..bbac65b84a 100644 --- a/data/sql/base/db_characters/channels.sql +++ b/data/sql/base/db_characters/channels.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,20 +12,20 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.channels +-- Dumpar struktur för tabell acore_characters.channels DROP TABLE IF EXISTS `channels`; CREATE TABLE IF NOT EXISTS `channels` ( `channelId` INT unsigned NOT NULL AUTO_INCREMENT, - `name` varchar(128) NOT NULL, + `name` VARCHAR(128) NOT NULL, `team` INT unsigned NOT NULL, `announce` TINYINT unsigned NOT NULL DEFAULT 1, `ownership` TINYINT unsigned NOT NULL DEFAULT 1, - `password` varchar(32) DEFAULT NULL, + `password` VARCHAR(32) DEFAULT NULL, `lastUsed` INT unsigned NOT NULL, PRIMARY KEY (`channelId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Channel System'; --- Дамп данных таблицы acore_characters.channels: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.channels: ~0 rows (ungefär) DELETE FROM `channels`; /*!40000 ALTER TABLE `channels` DISABLE KEYS */; /*!40000 ALTER TABLE `channels` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/channels_bans.sql b/data/sql/base/db_characters/channels_bans.sql index c6319bf34e..d51bf0b697 100644 --- a/data/sql/base/db_characters/channels_bans.sql +++ b/data/sql/base/db_characters/channels_bans.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.channels_bans +-- Dumpar struktur för tabell acore_characters.channels_bans DROP TABLE IF EXISTS `channels_bans`; CREATE TABLE IF NOT EXISTS `channels_bans` ( `channelId` INT unsigned NOT NULL, @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `channels_bans` ( PRIMARY KEY (`channelId`,`playerGUID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.channels_bans: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.channels_bans: ~0 rows (ungefär) DELETE FROM `channels_bans`; /*!40000 ALTER TABLE `channels_bans` DISABLE KEYS */; /*!40000 ALTER TABLE `channels_bans` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/channels_rights.sql b/data/sql/base/db_characters/channels_rights.sql index 88776ea220..110bbec183 100644 --- a/data/sql/base/db_characters/channels_rights.sql +++ b/data/sql/base/db_characters/channels_rights.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,19 +12,19 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.channels_rights +-- Dumpar struktur för tabell acore_characters.channels_rights DROP TABLE IF EXISTS `channels_rights`; CREATE TABLE IF NOT EXISTS `channels_rights` ( - `name` varchar(128) NOT NULL, + `name` VARCHAR(128) NOT NULL, `flags` INT unsigned NOT NULL, `speakdelay` INT unsigned NOT NULL, - `joinmessage` varchar(255) NOT NULL DEFAULT '', - `delaymessage` varchar(255) NOT NULL DEFAULT '', - `moderators` text DEFAULT NULL, + `joinmessage` VARCHAR(255) NOT NULL DEFAULT '', + `delaymessage` VARCHAR(255) NOT NULL DEFAULT '', + `moderators` text, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.channels_rights: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.channels_rights: ~0 rows (ungefär) DELETE FROM `channels_rights`; /*!40000 ALTER TABLE `channels_rights` DISABLE KEYS */; /*!40000 ALTER TABLE `channels_rights` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_account_data.sql b/data/sql/base/db_characters/character_account_data.sql index 12454761f3..303db6cf30 100644 --- a/data/sql/base/db_characters/character_account_data.sql +++ b/data/sql/base/db_characters/character_account_data.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_account_data +-- Dumpar struktur för tabell acore_characters.character_account_data DROP TABLE IF EXISTS `character_account_data`; CREATE TABLE IF NOT EXISTS `character_account_data` ( `guid` INT unsigned NOT NULL DEFAULT 0, @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_account_data` ( PRIMARY KEY (`guid`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_account_data: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_account_data: ~0 rows (ungefär) DELETE FROM `character_account_data`; /*!40000 ALTER TABLE `character_account_data` DISABLE KEYS */; /*!40000 ALTER TABLE `character_account_data` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_achievement.sql b/data/sql/base/db_characters/character_achievement.sql index b165b2ff4f..f8a9f3205f 100644 --- a/data/sql/base/db_characters/character_achievement.sql +++ b/data/sql/base/db_characters/character_achievement.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_achievement +-- Dumpar struktur för tabell acore_characters.character_achievement DROP TABLE IF EXISTS `character_achievement`; CREATE TABLE IF NOT EXISTS `character_achievement` ( `guid` INT unsigned NOT NULL, @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `character_achievement` ( PRIMARY KEY (`guid`,`achievement`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_achievement: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_achievement: ~0 rows (ungefär) DELETE FROM `character_achievement`; /*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */; /*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_achievement_progress.sql b/data/sql/base/db_characters/character_achievement_progress.sql index 05f8bf7d2d..9ca1a99f94 100644 --- a/data/sql/base/db_characters/character_achievement_progress.sql +++ b/data/sql/base/db_characters/character_achievement_progress.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_achievement_progress +-- Dumpar struktur för tabell acore_characters.character_achievement_progress DROP TABLE IF EXISTS `character_achievement_progress`; CREATE TABLE IF NOT EXISTS `character_achievement_progress` ( `guid` INT unsigned NOT NULL, @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_achievement_progress` ( PRIMARY KEY (`guid`,`criteria`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_achievement_progress: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_achievement_progress: ~0 rows (ungefär) DELETE FROM `character_achievement_progress`; /*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */; /*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_action.sql b/data/sql/base/db_characters/character_action.sql index 7a627f709c..b204de46a2 100644 --- a/data/sql/base/db_characters/character_action.sql +++ b/data/sql/base/db_characters/character_action.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_action +-- Dumpar struktur för tabell acore_characters.character_action DROP TABLE IF EXISTS `character_action`; CREATE TABLE IF NOT EXISTS `character_action` ( `guid` INT unsigned NOT NULL DEFAULT 0, @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `character_action` ( PRIMARY KEY (`guid`,`spec`,`button`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_action: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_action: ~0 rows (ungefär) DELETE FROM `character_action`; /*!40000 ALTER TABLE `character_action` DISABLE KEYS */; /*!40000 ALTER TABLE `character_action` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_arena_stats.sql b/data/sql/base/db_characters/character_arena_stats.sql index f411f8e182..bebc72be58 100644 --- a/data/sql/base/db_characters/character_arena_stats.sql +++ b/data/sql/base/db_characters/character_arena_stats.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_arena_stats +-- Dumpar struktur för tabell acore_characters.character_arena_stats DROP TABLE IF EXISTS `character_arena_stats`; CREATE TABLE IF NOT EXISTS `character_arena_stats` ( `guid` INT unsigned NOT NULL DEFAULT 0, @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_arena_stats` ( PRIMARY KEY (`guid`,`slot`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_arena_stats: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_arena_stats: ~0 rows (ungefär) DELETE FROM `character_arena_stats`; /*!40000 ALTER TABLE `character_arena_stats` DISABLE KEYS */; /*!40000 ALTER TABLE `character_arena_stats` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_aura.sql b/data/sql/base/db_characters/character_aura.sql index 4e08c9e02b..24ec5a1370 100644 --- a/data/sql/base/db_characters/character_aura.sql +++ b/data/sql/base/db_characters/character_aura.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_aura +-- Dumpar struktur för tabell acore_characters.character_aura DROP TABLE IF EXISTS `character_aura`; CREATE TABLE IF NOT EXISTS `character_aura` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -34,7 +34,7 @@ CREATE TABLE IF NOT EXISTS `character_aura` ( PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_aura: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_aura: ~0 rows (ungefär) DELETE FROM `character_aura`; /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */; /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_banned.sql b/data/sql/base/db_characters/character_banned.sql index c02020f065..3b02353020 100644 --- a/data/sql/base/db_characters/character_banned.sql +++ b/data/sql/base/db_characters/character_banned.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,19 +12,19 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_banned +-- Dumpar struktur för tabell acore_characters.character_banned DROP TABLE IF EXISTS `character_banned`; CREATE TABLE IF NOT EXISTS `character_banned` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', `bandate` INT unsigned NOT NULL DEFAULT 0, `unbandate` INT unsigned NOT NULL DEFAULT 0, - `bannedby` varchar(50) NOT NULL, - `banreason` varchar(255) NOT NULL, + `bannedby` VARCHAR(50) NOT NULL, + `banreason` VARCHAR(255) NOT NULL, `active` TINYINT unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`guid`,`bandate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Ban List'; --- Дамп данных таблицы acore_characters.character_banned: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_banned: ~0 rows (ungefär) DELETE FROM `character_banned`; /*!40000 ALTER TABLE `character_banned` DISABLE KEYS */; /*!40000 ALTER TABLE `character_banned` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_battleground_random.sql b/data/sql/base/db_characters/character_battleground_random.sql index 9927299f04..ad48bd6438 100644 --- a/data/sql/base/db_characters/character_battleground_random.sql +++ b/data/sql/base/db_characters/character_battleground_random.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,14 +12,14 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_battleground_random +-- Dumpar struktur för tabell acore_characters.character_battleground_random DROP TABLE IF EXISTS `character_battleground_random`; CREATE TABLE IF NOT EXISTS `character_battleground_random` ( `guid` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_battleground_random: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_battleground_random: ~0 rows (ungefär) DELETE FROM `character_battleground_random`; /*!40000 ALTER TABLE `character_battleground_random` DISABLE KEYS */; /*!40000 ALTER TABLE `character_battleground_random` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_brew_of_the_month.sql b/data/sql/base/db_characters/character_brew_of_the_month.sql index ca78ca1239..e85ce628ab 100644 --- a/data/sql/base/db_characters/character_brew_of_the_month.sql +++ b/data/sql/base/db_characters/character_brew_of_the_month.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_brew_of_the_month +-- Dumpar struktur för tabell acore_characters.character_brew_of_the_month DROP TABLE IF EXISTS `character_brew_of_the_month`; CREATE TABLE IF NOT EXISTS `character_brew_of_the_month` ( `guid` INT unsigned NOT NULL, @@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `character_brew_of_the_month` ( PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_brew_of_the_month: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_brew_of_the_month: ~0 rows (ungefär) DELETE FROM `character_brew_of_the_month`; /*!40000 ALTER TABLE `character_brew_of_the_month` DISABLE KEYS */; /*!40000 ALTER TABLE `character_brew_of_the_month` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_declinedname.sql b/data/sql/base/db_characters/character_declinedname.sql index e4d1f2d95c..8c690c82ca 100644 --- a/data/sql/base/db_characters/character_declinedname.sql +++ b/data/sql/base/db_characters/character_declinedname.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,19 +12,19 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_declinedname +-- Dumpar struktur för tabell acore_characters.character_declinedname DROP TABLE IF EXISTS `character_declinedname`; CREATE TABLE IF NOT EXISTS `character_declinedname` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `genitive` varchar(15) NOT NULL DEFAULT '', - `dative` varchar(15) NOT NULL DEFAULT '', - `accusative` varchar(15) NOT NULL DEFAULT '', - `instrumental` varchar(15) NOT NULL DEFAULT '', - `prepositional` varchar(15) NOT NULL DEFAULT '', + `genitive` VARCHAR(15) NOT NULL DEFAULT '', + `dative` VARCHAR(15) NOT NULL DEFAULT '', + `accusative` VARCHAR(15) NOT NULL DEFAULT '', + `instrumental` VARCHAR(15) NOT NULL DEFAULT '', + `prepositional` VARCHAR(15) NOT NULL DEFAULT '', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_declinedname: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_declinedname: ~0 rows (ungefär) DELETE FROM `character_declinedname`; /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */; /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_entry_point.sql b/data/sql/base/db_characters/character_entry_point.sql index 7619b04099..ca1bc9bc99 100644 --- a/data/sql/base/db_characters/character_entry_point.sql +++ b/data/sql/base/db_characters/character_entry_point.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_entry_point +-- Dumpar struktur för tabell acore_characters.character_entry_point DROP TABLE IF EXISTS `character_entry_point`; CREATE TABLE IF NOT EXISTS `character_entry_point` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -21,12 +21,12 @@ CREATE TABLE IF NOT EXISTS `character_entry_point` ( `joinZ` float NOT NULL DEFAULT 0, `joinO` float NOT NULL DEFAULT 0, `joinMapId` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier', - `taxiPath` text DEFAULT NULL, + `taxiPath` text, `mountSpell` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_entry_point: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_entry_point: ~0 rows (ungefär) DELETE FROM `character_entry_point`; /*!40000 ALTER TABLE `character_entry_point` DISABLE KEYS */; /*!40000 ALTER TABLE `character_entry_point` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_equipmentsets.sql b/data/sql/base/db_characters/character_equipmentsets.sql index f58b0365de..64f0d299aa 100644 --- a/data/sql/base/db_characters/character_equipmentsets.sql +++ b/data/sql/base/db_characters/character_equipmentsets.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,14 +12,14 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_equipmentsets +-- Dumpar struktur för tabell acore_characters.character_equipmentsets DROP TABLE IF EXISTS `character_equipmentsets`; CREATE TABLE IF NOT EXISTS `character_equipmentsets` ( `guid` INT NOT NULL DEFAULT 0, `setguid` BIGINT NOT NULL AUTO_INCREMENT, `setindex` TINYINT unsigned NOT NULL DEFAULT 0, - `name` varchar(31) NOT NULL, - `iconname` varchar(100) NOT NULL, + `name` VARCHAR(31) NOT NULL, + `iconname` VARCHAR(100) NOT NULL, `ignore_mask` INT unsigned NOT NULL DEFAULT 0, `item0` INT unsigned NOT NULL DEFAULT 0, `item1` INT unsigned NOT NULL DEFAULT 0, @@ -45,7 +45,7 @@ CREATE TABLE IF NOT EXISTS `character_equipmentsets` ( KEY `Idx_setindex` (`setindex`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_equipmentsets: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_equipmentsets: ~0 rows (ungefär) DELETE FROM `character_equipmentsets`; /*!40000 ALTER TABLE `character_equipmentsets` DISABLE KEYS */; /*!40000 ALTER TABLE `character_equipmentsets` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_gifts.sql b/data/sql/base/db_characters/character_gifts.sql index d0c01b7df5..e7c5a6f9d4 100644 --- a/data/sql/base/db_characters/character_gifts.sql +++ b/data/sql/base/db_characters/character_gifts.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_gifts +-- Dumpar struktur för tabell acore_characters.character_gifts DROP TABLE IF EXISTS `character_gifts`; CREATE TABLE IF NOT EXISTS `character_gifts` ( `guid` INT unsigned NOT NULL DEFAULT 0, @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `character_gifts` ( KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_gifts: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_gifts: ~0 rows (ungefär) DELETE FROM `character_gifts`; /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */; /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_glyphs.sql b/data/sql/base/db_characters/character_glyphs.sql index f4d9afdc26..1136020860 100644 --- a/data/sql/base/db_characters/character_glyphs.sql +++ b/data/sql/base/db_characters/character_glyphs.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_glyphs +-- Dumpar struktur för tabell acore_characters.character_glyphs DROP TABLE IF EXISTS `character_glyphs`; CREATE TABLE IF NOT EXISTS `character_glyphs` ( `guid` INT unsigned NOT NULL, @@ -26,7 +26,7 @@ CREATE TABLE IF NOT EXISTS `character_glyphs` ( PRIMARY KEY (`guid`,`talentGroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_glyphs: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_glyphs: ~0 rows (ungefär) DELETE FROM `character_glyphs`; /*!40000 ALTER TABLE `character_glyphs` DISABLE KEYS */; /*!40000 ALTER TABLE `character_glyphs` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_homebind.sql b/data/sql/base/db_characters/character_homebind.sql index e14d6dd66c..dba049f652 100644 --- a/data/sql/base/db_characters/character_homebind.sql +++ b/data/sql/base/db_characters/character_homebind.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_homebind +-- Dumpar struktur för tabell acore_characters.character_homebind DROP TABLE IF EXISTS `character_homebind`; CREATE TABLE IF NOT EXISTS `character_homebind` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -24,7 +24,7 @@ CREATE TABLE IF NOT EXISTS `character_homebind` ( PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_homebind: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_homebind: ~0 rows (ungefär) DELETE FROM `character_homebind`; /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */; /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_instance.sql b/data/sql/base/db_characters/character_instance.sql index 39404e274d..d2d2edf60f 100644 --- a/data/sql/base/db_characters/character_instance.sql +++ b/data/sql/base/db_characters/character_instance.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_instance +-- Dumpar struktur för tabell acore_characters.character_instance DROP TABLE IF EXISTS `character_instance`; CREATE TABLE IF NOT EXISTS `character_instance` ( `guid` INT unsigned NOT NULL DEFAULT 0, @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `character_instance` ( KEY `instance` (`instance`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_instance: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_instance: ~0 rows (ungefär) DELETE FROM `character_instance`; /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */; /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_inventory.sql b/data/sql/base/db_characters/character_inventory.sql index 7c214c0a7e..bca3b695f0 100644 --- a/data/sql/base/db_characters/character_inventory.sql +++ b/data/sql/base/db_characters/character_inventory.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_inventory +-- Dumpar struktur för tabell acore_characters.character_inventory DROP TABLE IF EXISTS `character_inventory`; CREATE TABLE IF NOT EXISTS `character_inventory` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -24,7 +24,7 @@ CREATE TABLE IF NOT EXISTS `character_inventory` ( KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_inventory: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_inventory: ~0 rows (ungefär) DELETE FROM `character_inventory`; /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */; /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_pet.sql b/data/sql/base/db_characters/character_pet.sql index f57a2fc9f5..2f73994a99 100644 --- a/data/sql/base/db_characters/character_pet.sql +++ b/data/sql/base/db_characters/character_pet.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_pet +-- Dumpar struktur för tabell acore_characters.character_pet DROP TABLE IF EXISTS `character_pet`; CREATE TABLE IF NOT EXISTS `character_pet` ( `id` INT unsigned NOT NULL DEFAULT 0, @@ -24,20 +24,20 @@ CREATE TABLE IF NOT EXISTS `character_pet` ( `level` SMALLINT unsigned NOT NULL DEFAULT 1, `exp` INT unsigned NOT NULL DEFAULT 0, `Reactstate` TINYINT unsigned NOT NULL DEFAULT 0, - `name` varchar(21) NOT NULL DEFAULT 'Pet', + `name` VARCHAR(21) NOT NULL DEFAULT 'Pet', `renamed` TINYINT unsigned NOT NULL DEFAULT 0, `slot` TINYINT unsigned NOT NULL DEFAULT 0, `curhealth` INT unsigned NOT NULL DEFAULT 1, `curmana` INT unsigned NOT NULL DEFAULT 0, `curhappiness` INT unsigned NOT NULL DEFAULT 0, `savetime` INT unsigned NOT NULL DEFAULT 0, - `abdata` text DEFAULT NULL, + `abdata` text, PRIMARY KEY (`id`), KEY `owner` (`owner`), KEY `idx_slot` (`slot`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Pet System'; --- Дамп данных таблицы acore_characters.character_pet: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_pet: ~0 rows (ungefär) DELETE FROM `character_pet`; /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */; /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_pet_declinedname.sql b/data/sql/base/db_characters/character_pet_declinedname.sql index dcf93a602e..e3ec580c9b 100644 --- a/data/sql/base/db_characters/character_pet_declinedname.sql +++ b/data/sql/base/db_characters/character_pet_declinedname.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,21 +12,21 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_pet_declinedname +-- Dumpar struktur för tabell acore_characters.character_pet_declinedname DROP TABLE IF EXISTS `character_pet_declinedname`; CREATE TABLE IF NOT EXISTS `character_pet_declinedname` ( `id` INT unsigned NOT NULL DEFAULT 0, `owner` INT unsigned NOT NULL DEFAULT 0, - `genitive` varchar(12) NOT NULL DEFAULT '', - `dative` varchar(12) NOT NULL DEFAULT '', - `accusative` varchar(12) NOT NULL DEFAULT '', - `instrumental` varchar(12) NOT NULL DEFAULT '', - `prepositional` varchar(12) NOT NULL DEFAULT '', + `genitive` VARCHAR(12) NOT NULL DEFAULT '', + `dative` VARCHAR(12) NOT NULL DEFAULT '', + `accusative` VARCHAR(12) NOT NULL DEFAULT '', + `instrumental` VARCHAR(12) NOT NULL DEFAULT '', + `prepositional` VARCHAR(12) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `owner_key` (`owner`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_pet_declinedname: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_pet_declinedname: ~0 rows (ungefär) DELETE FROM `character_pet_declinedname`; /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */; /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_queststatus.sql b/data/sql/base/db_characters/character_queststatus.sql index 3c1eabcb1b..56665f8882 100644 --- a/data/sql/base/db_characters/character_queststatus.sql +++ b/data/sql/base/db_characters/character_queststatus.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_queststatus +-- Dumpar struktur för tabell acore_characters.character_queststatus DROP TABLE IF EXISTS `character_queststatus`; CREATE TABLE IF NOT EXISTS `character_queststatus` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -34,7 +34,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus` ( PRIMARY KEY (`guid`,`quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_queststatus: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_queststatus: ~0 rows (ungefär) DELETE FROM `character_queststatus`; /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_queststatus_daily.sql b/data/sql/base/db_characters/character_queststatus_daily.sql index 95cb52a48a..f921cab562 100644 --- a/data/sql/base/db_characters/character_queststatus_daily.sql +++ b/data/sql/base/db_characters/character_queststatus_daily.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_queststatus_daily +-- Dumpar struktur för tabell acore_characters.character_queststatus_daily DROP TABLE IF EXISTS `character_queststatus_daily`; CREATE TABLE IF NOT EXISTS `character_queststatus_daily` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus_daily` ( KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_queststatus_daily: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_queststatus_daily: ~0 rows (ungefär) DELETE FROM `character_queststatus_daily`; /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_queststatus_monthly.sql b/data/sql/base/db_characters/character_queststatus_monthly.sql index 801a5af967..5de763c49f 100644 --- a/data/sql/base/db_characters/character_queststatus_monthly.sql +++ b/data/sql/base/db_characters/character_queststatus_monthly.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_queststatus_monthly +-- Dumpar struktur för tabell acore_characters.character_queststatus_monthly DROP TABLE IF EXISTS `character_queststatus_monthly`; CREATE TABLE IF NOT EXISTS `character_queststatus_monthly` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus_monthly` ( KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_queststatus_monthly: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_queststatus_monthly: ~0 rows (ungefär) DELETE FROM `character_queststatus_monthly`; /*!40000 ALTER TABLE `character_queststatus_monthly` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_monthly` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_queststatus_rewarded.sql b/data/sql/base/db_characters/character_queststatus_rewarded.sql index 0e4197e0a0..a194da1395 100644 --- a/data/sql/base/db_characters/character_queststatus_rewarded.sql +++ b/data/sql/base/db_characters/character_queststatus_rewarded.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_queststatus_rewarded +-- Dumpar struktur för tabell acore_characters.character_queststatus_rewarded DROP TABLE IF EXISTS `character_queststatus_rewarded`; CREATE TABLE IF NOT EXISTS `character_queststatus_rewarded` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus_rewarded` ( PRIMARY KEY (`guid`,`quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_queststatus_rewarded: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_queststatus_rewarded: ~0 rows (ungefär) DELETE FROM `character_queststatus_rewarded`; /*!40000 ALTER TABLE `character_queststatus_rewarded` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_rewarded` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_queststatus_seasonal.sql b/data/sql/base/db_characters/character_queststatus_seasonal.sql index 815500effb..b0a5a5520b 100644 --- a/data/sql/base/db_characters/character_queststatus_seasonal.sql +++ b/data/sql/base/db_characters/character_queststatus_seasonal.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_queststatus_seasonal +-- Dumpar struktur för tabell acore_characters.character_queststatus_seasonal DROP TABLE IF EXISTS `character_queststatus_seasonal`; CREATE TABLE IF NOT EXISTS `character_queststatus_seasonal` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus_seasonal` ( KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_queststatus_seasonal: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_queststatus_seasonal: ~0 rows (ungefär) DELETE FROM `character_queststatus_seasonal`; /*!40000 ALTER TABLE `character_queststatus_seasonal` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_seasonal` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_queststatus_weekly.sql b/data/sql/base/db_characters/character_queststatus_weekly.sql index 008cb2dc7d..5e8d39ec40 100644 --- a/data/sql/base/db_characters/character_queststatus_weekly.sql +++ b/data/sql/base/db_characters/character_queststatus_weekly.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_queststatus_weekly +-- Dumpar struktur för tabell acore_characters.character_queststatus_weekly DROP TABLE IF EXISTS `character_queststatus_weekly`; CREATE TABLE IF NOT EXISTS `character_queststatus_weekly` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus_weekly` ( KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_queststatus_weekly: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_queststatus_weekly: ~0 rows (ungefär) DELETE FROM `character_queststatus_weekly`; /*!40000 ALTER TABLE `character_queststatus_weekly` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_weekly` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_reputation.sql b/data/sql/base/db_characters/character_reputation.sql index 7acdeec370..ddffa9c962 100644 --- a/data/sql/base/db_characters/character_reputation.sql +++ b/data/sql/base/db_characters/character_reputation.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_reputation +-- Dumpar struktur för tabell acore_characters.character_reputation DROP TABLE IF EXISTS `character_reputation`; CREATE TABLE IF NOT EXISTS `character_reputation` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_reputation` ( PRIMARY KEY (`guid`,`faction`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_reputation: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_reputation: ~0 rows (ungefär) DELETE FROM `character_reputation`; /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */; /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_settings.sql b/data/sql/base/db_characters/character_settings.sql index 9001553c2b..326d218214 100644 --- a/data/sql/base/db_characters/character_settings.sql +++ b/data/sql/base/db_characters/character_settings.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,16 +12,16 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_settings +-- Dumpar struktur för tabell acore_characters.character_settings DROP TABLE IF EXISTS `character_settings`; CREATE TABLE IF NOT EXISTS `character_settings` ( `guid` INT unsigned NOT NULL, - `source` varchar(40) NOT NULL, - `data` text DEFAULT NULL, + `source` VARCHAR(40) NOT NULL, + `data` text, PRIMARY KEY (`guid`,`source`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='Player Settings'; --- Дамп данных таблицы acore_characters.character_settings: 0 rows +-- Dumpar data för tabell acore_characters.character_settings: 0 rows DELETE FROM `character_settings`; /*!40000 ALTER TABLE `character_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `character_settings` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_skills.sql b/data/sql/base/db_characters/character_skills.sql index d08dc3f42f..a54cb7b43a 100644 --- a/data/sql/base/db_characters/character_skills.sql +++ b/data/sql/base/db_characters/character_skills.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_skills +-- Dumpar struktur för tabell acore_characters.character_skills DROP TABLE IF EXISTS `character_skills`; CREATE TABLE IF NOT EXISTS `character_skills` ( `guid` INT unsigned NOT NULL COMMENT 'Global Unique Identifier', @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_skills` ( PRIMARY KEY (`guid`,`skill`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_skills: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_skills: ~0 rows (ungefär) DELETE FROM `character_skills`; /*!40000 ALTER TABLE `character_skills` DISABLE KEYS */; /*!40000 ALTER TABLE `character_skills` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_social.sql b/data/sql/base/db_characters/character_social.sql index d189f5c62d..3546a1f25d 100644 --- a/data/sql/base/db_characters/character_social.sql +++ b/data/sql/base/db_characters/character_social.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,18 +12,18 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_social +-- Dumpar struktur för tabell acore_characters.character_social DROP TABLE IF EXISTS `character_social`; CREATE TABLE IF NOT EXISTS `character_social` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', `friend` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Friend Global Unique Identifier', `flags` TINYINT unsigned NOT NULL DEFAULT 0 COMMENT 'Friend Flags', - `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note', + `note` VARCHAR(48) NOT NULL DEFAULT '' COMMENT 'Friend Note', PRIMARY KEY (`guid`,`friend`,`flags`), KEY `friend` (`friend`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_social: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_social: ~0 rows (ungefär) DELETE FROM `character_social`; /*!40000 ALTER TABLE `character_social` DISABLE KEYS */; /*!40000 ALTER TABLE `character_social` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_spell.sql b/data/sql/base/db_characters/character_spell.sql index 04049a744d..dbb7cd436a 100644 --- a/data/sql/base/db_characters/character_spell.sql +++ b/data/sql/base/db_characters/character_spell.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_spell +-- Dumpar struktur för tabell acore_characters.character_spell DROP TABLE IF EXISTS `character_spell`; CREATE TABLE IF NOT EXISTS `character_spell` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `character_spell` ( PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.character_spell: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_spell: ~0 rows (ungefär) DELETE FROM `character_spell`; /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */; /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_spell_cooldown.sql b/data/sql/base/db_characters/character_spell_cooldown.sql index a218f2a59a..ed4371eba2 100644 --- a/data/sql/base/db_characters/character_spell_cooldown.sql +++ b/data/sql/base/db_characters/character_spell_cooldown.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_spell_cooldown +-- Dumpar struktur för tabell acore_characters.character_spell_cooldown DROP TABLE IF EXISTS `character_spell_cooldown`; CREATE TABLE IF NOT EXISTS `character_spell_cooldown` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part', @@ -24,7 +24,7 @@ CREATE TABLE IF NOT EXISTS `character_spell_cooldown` ( PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_spell_cooldown: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_spell_cooldown: ~0 rows (ungefär) DELETE FROM `character_spell_cooldown`; /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */; /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_stats.sql b/data/sql/base/db_characters/character_stats.sql index 9ade37fa97..f19319f8e0 100644 --- a/data/sql/base/db_characters/character_stats.sql +++ b/data/sql/base/db_characters/character_stats.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_stats +-- Dumpar struktur för tabell acore_characters.character_stats DROP TABLE IF EXISTS `character_stats`; CREATE TABLE IF NOT EXISTS `character_stats` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part', @@ -47,10 +47,10 @@ CREATE TABLE IF NOT EXISTS `character_stats` ( `spellPower` INT unsigned NOT NULL DEFAULT 0, `resilience` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`), - CHECK (`blockPct` >= 0 and `dodgePct` >= 0 and `parryPct` >= 0 and `critPct` >= 0 and `rangedCritPct` >= 0 and `spellCritPct` >= 0) + CONSTRAINT `character_stats_chk_1` CHECK (((`blockPct` >= 0) and (`dodgePct` >= 0) and (`parryPct` >= 0) and (`critPct` >= 0) and (`rangedCritPct` >= 0) and (`spellCritPct` >= 0))) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_stats: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_stats: ~0 rows (ungefär) DELETE FROM `character_stats`; /*!40000 ALTER TABLE `character_stats` DISABLE KEYS */; /*!40000 ALTER TABLE `character_stats` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/character_talent.sql b/data/sql/base/db_characters/character_talent.sql index 1f49ca2cf8..487bcb0ead 100644 --- a/data/sql/base/db_characters/character_talent.sql +++ b/data/sql/base/db_characters/character_talent.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.character_talent +-- Dumpar struktur för tabell acore_characters.character_talent DROP TABLE IF EXISTS `character_talent`; CREATE TABLE IF NOT EXISTS `character_talent` ( `guid` INT unsigned NOT NULL, @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `character_talent` ( PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.character_talent: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.character_talent: ~0 rows (ungefär) DELETE FROM `character_talent`; /*!40000 ALTER TABLE `character_talent` DISABLE KEYS */; /*!40000 ALTER TABLE `character_talent` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/characters.sql b/data/sql/base/db_characters/characters.sql index 882fbc462c..652b9ef636 100644 --- a/data/sql/base/db_characters/characters.sql +++ b/data/sql/base/db_characters/characters.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,12 +12,12 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.characters +-- Dumpar struktur för tabell acore_characters.characters DROP TABLE IF EXISTS `characters`; CREATE TABLE IF NOT EXISTS `characters` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', `account` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Account Identifier', - `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, + `name` VARCHAR(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `race` TINYINT unsigned NOT NULL DEFAULT 0, `class` TINYINT unsigned NOT NULL DEFAULT 0, `gender` TINYINT unsigned NOT NULL DEFAULT 0, @@ -59,7 +59,7 @@ CREATE TABLE IF NOT EXISTS `characters` ( `at_login` SMALLINT unsigned NOT NULL DEFAULT 0, `zone` SMALLINT unsigned NOT NULL DEFAULT 0, `death_expire_time` INT unsigned NOT NULL DEFAULT 0, - `taxi_path` text DEFAULT NULL, + `taxi_path` text, `arenaPoints` INT unsigned NOT NULL DEFAULT 0, `totalHonorPoints` INT unsigned NOT NULL DEFAULT 0, `todayHonorPoints` INT unsigned NOT NULL DEFAULT 0, @@ -82,16 +82,16 @@ CREATE TABLE IF NOT EXISTS `characters` ( `latency` MEDIUMINT unsigned NOT NULL DEFAULT 0, `talentGroupsCount` TINYINT unsigned NOT NULL DEFAULT 1, `activeTalentGroup` TINYINT unsigned NOT NULL DEFAULT 0, - `exploredZones` longtext DEFAULT NULL, - `equipmentCache` longtext DEFAULT NULL, + `exploredZones` longtext, + `equipmentCache` longtext, `ammoId` INT unsigned NOT NULL DEFAULT 0, - `knownTitles` longtext DEFAULT NULL, + `knownTitles` longtext, `actionBars` TINYINT unsigned NOT NULL DEFAULT 0, `grantableLevels` TINYINT unsigned NOT NULL DEFAULT 0, `order` TINYINT DEFAULT NULL, - `creation_date` timestamp NOT NULL DEFAULT current_timestamp(), + `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `deleteInfos_Account` INT unsigned DEFAULT NULL, - `deleteInfos_Name` varchar(12) DEFAULT NULL, + `deleteInfos_Name` VARCHAR(12) DEFAULT NULL, `deleteDate` INT unsigned DEFAULT NULL, `innTriggerId` INT unsigned NOT NULL, PRIMARY KEY (`guid`), @@ -100,7 +100,7 @@ CREATE TABLE IF NOT EXISTS `characters` ( KEY `idx_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.characters: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.characters: ~0 rows (ungefär) DELETE FROM `characters`; /*!40000 ALTER TABLE `characters` DISABLE KEYS */; /*!40000 ALTER TABLE `characters` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/corpse.sql b/data/sql/base/db_characters/corpse.sql index 156a48f001..de2063cd14 100644 --- a/data/sql/base/db_characters/corpse.sql +++ b/data/sql/base/db_characters/corpse.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.corpse +-- Dumpar struktur för tabell acore_characters.corpse DROP TABLE IF EXISTS `corpse`; CREATE TABLE IF NOT EXISTS `corpse` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', @@ -38,7 +38,7 @@ CREATE TABLE IF NOT EXISTS `corpse` ( KEY `idx_time` (`time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Death System'; --- Дамп данных таблицы acore_characters.corpse: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.corpse: ~0 rows (ungefär) DELETE FROM `corpse`; /*!40000 ALTER TABLE `corpse` DISABLE KEYS */; /*!40000 ALTER TABLE `corpse` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/creature_respawn.sql b/data/sql/base/db_characters/creature_respawn.sql index 39829389ff..d781d84753 100644 --- a/data/sql/base/db_characters/creature_respawn.sql +++ b/data/sql/base/db_characters/creature_respawn.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.creature_respawn +-- Dumpar struktur för tabell acore_characters.creature_respawn DROP TABLE IF EXISTS `creature_respawn`; CREATE TABLE IF NOT EXISTS `creature_respawn` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `creature_respawn` ( KEY `idx_instance` (`instanceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Grid Loading System'; --- Дамп данных таблицы acore_characters.creature_respawn: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.creature_respawn: ~0 rows (ungefär) DELETE FROM `creature_respawn`; /*!40000 ALTER TABLE `creature_respawn` DISABLE KEYS */; /*!40000 ALTER TABLE `creature_respawn` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/game_event_condition_save.sql b/data/sql/base/db_characters/game_event_condition_save.sql index afb6c31843..3e9d16b1ff 100644 --- a/data/sql/base/db_characters/game_event_condition_save.sql +++ b/data/sql/base/db_characters/game_event_condition_save.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.game_event_condition_save +-- Dumpar struktur för tabell acore_characters.game_event_condition_save DROP TABLE IF EXISTS `game_event_condition_save`; CREATE TABLE IF NOT EXISTS `game_event_condition_save` ( `eventEntry` TINYINT unsigned NOT NULL, @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `game_event_condition_save` ( PRIMARY KEY (`eventEntry`,`condition_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.game_event_condition_save: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.game_event_condition_save: ~0 rows (ungefär) DELETE FROM `game_event_condition_save`; /*!40000 ALTER TABLE `game_event_condition_save` DISABLE KEYS */; /*!40000 ALTER TABLE `game_event_condition_save` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/game_event_save.sql b/data/sql/base/db_characters/game_event_save.sql index e35fef95a5..65c2ed8209 100644 --- a/data/sql/base/db_characters/game_event_save.sql +++ b/data/sql/base/db_characters/game_event_save.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.game_event_save +-- Dumpar struktur för tabell acore_characters.game_event_save DROP TABLE IF EXISTS `game_event_save`; CREATE TABLE IF NOT EXISTS `game_event_save` ( `eventEntry` TINYINT unsigned NOT NULL, @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `game_event_save` ( PRIMARY KEY (`eventEntry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.game_event_save: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.game_event_save: ~0 rows (ungefär) DELETE FROM `game_event_save`; /*!40000 ALTER TABLE `game_event_save` DISABLE KEYS */; /*!40000 ALTER TABLE `game_event_save` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/gameobject_respawn.sql b/data/sql/base/db_characters/gameobject_respawn.sql index c6a04a3201..aa45ad64de 100644 --- a/data/sql/base/db_characters/gameobject_respawn.sql +++ b/data/sql/base/db_characters/gameobject_respawn.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.gameobject_respawn +-- Dumpar struktur för tabell acore_characters.gameobject_respawn DROP TABLE IF EXISTS `gameobject_respawn`; CREATE TABLE IF NOT EXISTS `gameobject_respawn` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `gameobject_respawn` ( KEY `idx_instance` (`instanceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Grid Loading System'; --- Дамп данных таблицы acore_characters.gameobject_respawn: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.gameobject_respawn: ~0 rows (ungefär) DELETE FROM `gameobject_respawn`; /*!40000 ALTER TABLE `gameobject_respawn` DISABLE KEYS */; /*!40000 ALTER TABLE `gameobject_respawn` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/gm_subsurvey.sql b/data/sql/base/db_characters/gm_subsurvey.sql index 67eb4bcf46..7b4f5aad2e 100644 --- a/data/sql/base/db_characters/gm_subsurvey.sql +++ b/data/sql/base/db_characters/gm_subsurvey.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.gm_subsurvey +-- Dumpar struktur för tabell acore_characters.gm_subsurvey DROP TABLE IF EXISTS `gm_subsurvey`; CREATE TABLE IF NOT EXISTS `gm_subsurvey` ( `surveyId` INT unsigned NOT NULL AUTO_INCREMENT, @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `gm_subsurvey` ( PRIMARY KEY (`surveyId`,`questionId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.gm_subsurvey: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.gm_subsurvey: ~0 rows (ungefär) DELETE FROM `gm_subsurvey`; /*!40000 ALTER TABLE `gm_subsurvey` DISABLE KEYS */; /*!40000 ALTER TABLE `gm_subsurvey` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/gm_survey.sql b/data/sql/base/db_characters/gm_survey.sql index a2b55a9ab1..8784f14ac6 100644 --- a/data/sql/base/db_characters/gm_survey.sql +++ b/data/sql/base/db_characters/gm_survey.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.gm_survey +-- Dumpar struktur för tabell acore_characters.gm_survey DROP TABLE IF EXISTS `gm_survey`; CREATE TABLE IF NOT EXISTS `gm_survey` ( `surveyId` INT unsigned NOT NULL AUTO_INCREMENT, @@ -24,7 +24,7 @@ CREATE TABLE IF NOT EXISTS `gm_survey` ( PRIMARY KEY (`surveyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.gm_survey: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.gm_survey: ~0 rows (ungefär) DELETE FROM `gm_survey`; /*!40000 ALTER TABLE `gm_survey` DISABLE KEYS */; /*!40000 ALTER TABLE `gm_survey` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/gm_ticket.sql b/data/sql/base/db_characters/gm_ticket.sql index 6852fb2c6a..29be9403cc 100644 --- a/data/sql/base/db_characters/gm_ticket.sql +++ b/data/sql/base/db_characters/gm_ticket.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,13 +12,13 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.gm_ticket +-- Dumpar struktur för tabell acore_characters.gm_ticket DROP TABLE IF EXISTS `gm_ticket`; CREATE TABLE IF NOT EXISTS `gm_ticket` ( `id` INT unsigned NOT NULL AUTO_INCREMENT, `type` TINYINT unsigned NOT NULL DEFAULT 0 COMMENT '0 open, 1 closed, 2 character deleted', `playerGuid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier of ticket creator', - `name` varchar(12) NOT NULL COMMENT 'Name of ticket creator', + `name` VARCHAR(12) NOT NULL COMMENT 'Name of ticket creator', `description` text NOT NULL, `createTime` INT unsigned NOT NULL DEFAULT 0, `mapId` SMALLINT unsigned NOT NULL DEFAULT 0, @@ -38,7 +38,7 @@ CREATE TABLE IF NOT EXISTS `gm_ticket` ( PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.gm_ticket: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.gm_ticket: ~0 rows (ungefär) DELETE FROM `gm_ticket`; /*!40000 ALTER TABLE `gm_ticket` DISABLE KEYS */; /*!40000 ALTER TABLE `gm_ticket` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/group_member.sql b/data/sql/base/db_characters/group_member.sql index 6bbe5b8f83..2de972cc49 100644 --- a/data/sql/base/db_characters/group_member.sql +++ b/data/sql/base/db_characters/group_member.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.group_member +-- Dumpar struktur för tabell acore_characters.group_member DROP TABLE IF EXISTS `group_member`; CREATE TABLE IF NOT EXISTS `group_member` ( `guid` INT unsigned NOT NULL, @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `group_member` ( PRIMARY KEY (`memberGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Groups'; --- Дамп данных таблицы acore_characters.group_member: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.group_member: ~0 rows (ungefär) DELETE FROM `group_member`; /*!40000 ALTER TABLE `group_member` DISABLE KEYS */; /*!40000 ALTER TABLE `group_member` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/groups.sql b/data/sql/base/db_characters/groups.sql index 57c6b98298..30f4090696 100644 --- a/data/sql/base/db_characters/groups.sql +++ b/data/sql/base/db_characters/groups.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.groups +-- Dumpar struktur för tabell acore_characters.groups DROP TABLE IF EXISTS `groups`; CREATE TABLE IF NOT EXISTS `groups` ( `guid` INT unsigned NOT NULL, @@ -36,7 +36,7 @@ CREATE TABLE IF NOT EXISTS `groups` ( KEY `leaderGuid` (`leaderGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Groups'; --- Дамп данных таблицы acore_characters.groups: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.groups: ~0 rows (ungefär) DELETE FROM `groups`; /*!40000 ALTER TABLE `groups` DISABLE KEYS */; /*!40000 ALTER TABLE `groups` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/guild.sql b/data/sql/base/db_characters/guild.sql index 9af87e6042..eff979a8bc 100644 --- a/data/sql/base/db_characters/guild.sql +++ b/data/sql/base/db_characters/guild.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,25 +12,25 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.guild +-- Dumpar struktur för tabell acore_characters.guild DROP TABLE IF EXISTS `guild`; CREATE TABLE IF NOT EXISTS `guild` ( `guildid` INT unsigned NOT NULL DEFAULT 0, - `name` varchar(24) NOT NULL DEFAULT '', + `name` VARCHAR(24) NOT NULL DEFAULT '', `leaderguid` INT unsigned NOT NULL DEFAULT 0, `EmblemStyle` TINYINT unsigned NOT NULL DEFAULT 0, `EmblemColor` TINYINT unsigned NOT NULL DEFAULT 0, `BorderStyle` TINYINT unsigned NOT NULL DEFAULT 0, `BorderColor` TINYINT unsigned NOT NULL DEFAULT 0, `BackgroundColor` TINYINT unsigned NOT NULL DEFAULT 0, - `info` varchar(500) NOT NULL DEFAULT '', - `motd` varchar(128) NOT NULL DEFAULT '', + `info` VARCHAR(500) NOT NULL DEFAULT '', + `motd` VARCHAR(128) NOT NULL DEFAULT '', `createdate` INT unsigned NOT NULL DEFAULT 0, `BankMoney` BIGINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild System'; --- Дамп данных таблицы acore_characters.guild: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.guild: ~0 rows (ungefär) DELETE FROM `guild`; /*!40000 ALTER TABLE `guild` DISABLE KEYS */; /*!40000 ALTER TABLE `guild` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/guild_bank_eventlog.sql b/data/sql/base/db_characters/guild_bank_eventlog.sql index 14ceec1240..d75a7eb049 100644 --- a/data/sql/base/db_characters/guild_bank_eventlog.sql +++ b/data/sql/base/db_characters/guild_bank_eventlog.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.guild_bank_eventlog +-- Dumpar struktur för tabell acore_characters.guild_bank_eventlog DROP TABLE IF EXISTS `guild_bank_eventlog`; CREATE TABLE IF NOT EXISTS `guild_bank_eventlog` ( `guildid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Guild Identificator', @@ -30,7 +30,7 @@ CREATE TABLE IF NOT EXISTS `guild_bank_eventlog` ( KEY `Idx_LogGuid` (`LogGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.guild_bank_eventlog: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.guild_bank_eventlog: ~0 rows (ungefär) DELETE FROM `guild_bank_eventlog`; /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/guild_bank_item.sql b/data/sql/base/db_characters/guild_bank_item.sql index a8617e7c2d..84c15ef1a7 100644 --- a/data/sql/base/db_characters/guild_bank_item.sql +++ b/data/sql/base/db_characters/guild_bank_item.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.guild_bank_item +-- Dumpar struktur för tabell acore_characters.guild_bank_item DROP TABLE IF EXISTS `guild_bank_item`; CREATE TABLE IF NOT EXISTS `guild_bank_item` ( `guildid` INT unsigned NOT NULL DEFAULT 0, @@ -24,7 +24,7 @@ CREATE TABLE IF NOT EXISTS `guild_bank_item` ( KEY `Idx_item_guid` (`item_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.guild_bank_item: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.guild_bank_item: ~0 rows (ungefär) DELETE FROM `guild_bank_item`; /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/guild_bank_right.sql b/data/sql/base/db_characters/guild_bank_right.sql index 5fcf78db9a..b49276c9be 100644 --- a/data/sql/base/db_characters/guild_bank_right.sql +++ b/data/sql/base/db_characters/guild_bank_right.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.guild_bank_right +-- Dumpar struktur för tabell acore_characters.guild_bank_right DROP TABLE IF EXISTS `guild_bank_right`; CREATE TABLE IF NOT EXISTS `guild_bank_right` ( `guildid` INT unsigned NOT NULL DEFAULT 0, @@ -24,7 +24,7 @@ CREATE TABLE IF NOT EXISTS `guild_bank_right` ( KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.guild_bank_right: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.guild_bank_right: ~0 rows (ungefär) DELETE FROM `guild_bank_right`; /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/guild_bank_tab.sql b/data/sql/base/db_characters/guild_bank_tab.sql index 5a854cfc27..37c2745550 100644 --- a/data/sql/base/db_characters/guild_bank_tab.sql +++ b/data/sql/base/db_characters/guild_bank_tab.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,19 +12,19 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.guild_bank_tab +-- Dumpar struktur för tabell acore_characters.guild_bank_tab DROP TABLE IF EXISTS `guild_bank_tab`; CREATE TABLE IF NOT EXISTS `guild_bank_tab` ( `guildid` INT unsigned NOT NULL DEFAULT 0, `TabId` TINYINT unsigned NOT NULL DEFAULT 0, - `TabName` varchar(16) NOT NULL DEFAULT '', - `TabIcon` varchar(100) NOT NULL DEFAULT '', - `TabText` varchar(500) DEFAULT NULL, + `TabName` VARCHAR(16) NOT NULL DEFAULT '', + `TabIcon` VARCHAR(100) NOT NULL DEFAULT '', + `TabText` VARCHAR(500) DEFAULT NULL, PRIMARY KEY (`guildid`,`TabId`), KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.guild_bank_tab: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.guild_bank_tab: ~0 rows (ungefär) DELETE FROM `guild_bank_tab`; /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/guild_eventlog.sql b/data/sql/base/db_characters/guild_eventlog.sql index afab6426b9..c8084ef737 100644 --- a/data/sql/base/db_characters/guild_eventlog.sql +++ b/data/sql/base/db_characters/guild_eventlog.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.guild_eventlog +-- Dumpar struktur för tabell acore_characters.guild_eventlog DROP TABLE IF EXISTS `guild_eventlog`; CREATE TABLE IF NOT EXISTS `guild_eventlog` ( `guildid` INT unsigned NOT NULL COMMENT 'Guild Identificator', @@ -28,7 +28,7 @@ CREATE TABLE IF NOT EXISTS `guild_eventlog` ( KEY `Idx_LogGuid` (`LogGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild Eventlog'; --- Дамп данных таблицы acore_characters.guild_eventlog: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.guild_eventlog: ~0 rows (ungefär) DELETE FROM `guild_eventlog`; /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/guild_member.sql b/data/sql/base/db_characters/guild_member.sql index d453d61be0..019e9e37f9 100644 --- a/data/sql/base/db_characters/guild_member.sql +++ b/data/sql/base/db_characters/guild_member.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,20 +12,20 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.guild_member +-- Dumpar struktur för tabell acore_characters.guild_member DROP TABLE IF EXISTS `guild_member`; CREATE TABLE IF NOT EXISTS `guild_member` ( `guildid` INT unsigned NOT NULL COMMENT 'Guild Identificator', `guid` INT unsigned NOT NULL, `rank` TINYINT unsigned NOT NULL, - `pnote` varchar(31) NOT NULL DEFAULT '', - `offnote` varchar(31) NOT NULL DEFAULT '', + `pnote` VARCHAR(31) NOT NULL DEFAULT '', + `offnote` VARCHAR(31) NOT NULL DEFAULT '', UNIQUE KEY `guid_key` (`guid`), KEY `guildid_key` (`guildid`), KEY `guildid_rank_key` (`guildid`,`rank`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild System'; --- Дамп данных таблицы acore_characters.guild_member: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.guild_member: ~0 rows (ungefär) DELETE FROM `guild_member`; /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/guild_member_withdraw.sql b/data/sql/base/db_characters/guild_member_withdraw.sql index af2093bf6f..ab89602739 100644 --- a/data/sql/base/db_characters/guild_member_withdraw.sql +++ b/data/sql/base/db_characters/guild_member_withdraw.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.guild_member_withdraw +-- Dumpar struktur för tabell acore_characters.guild_member_withdraw DROP TABLE IF EXISTS `guild_member_withdraw`; CREATE TABLE IF NOT EXISTS `guild_member_withdraw` ( `guid` INT unsigned NOT NULL, @@ -26,7 +26,7 @@ CREATE TABLE IF NOT EXISTS `guild_member_withdraw` ( PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild Member Daily Withdraws'; --- Дамп данных таблицы acore_characters.guild_member_withdraw: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.guild_member_withdraw: ~0 rows (ungefär) DELETE FROM `guild_member_withdraw`; /*!40000 ALTER TABLE `guild_member_withdraw` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_member_withdraw` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/guild_rank.sql b/data/sql/base/db_characters/guild_rank.sql index 72e2d51e96..f4fb4a38ed 100644 --- a/data/sql/base/db_characters/guild_rank.sql +++ b/data/sql/base/db_characters/guild_rank.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,19 +12,19 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.guild_rank +-- Dumpar struktur för tabell acore_characters.guild_rank DROP TABLE IF EXISTS `guild_rank`; CREATE TABLE IF NOT EXISTS `guild_rank` ( `guildid` INT unsigned NOT NULL DEFAULT 0, `rid` TINYINT unsigned NOT NULL, - `rname` varchar(20) NOT NULL DEFAULT '', + `rname` VARCHAR(20) NOT NULL DEFAULT '', `rights` MEDIUMINT unsigned NOT NULL DEFAULT 0, `BankMoneyPerDay` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guildid`,`rid`), KEY `Idx_rid` (`rid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild System'; --- Дамп данных таблицы acore_characters.guild_rank: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.guild_rank: ~0 rows (ungefär) DELETE FROM `guild_rank`; /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/instance.sql b/data/sql/base/db_characters/instance.sql index 0d82836213..29798919a1 100644 --- a/data/sql/base/db_characters/instance.sql +++ b/data/sql/base/db_characters/instance.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.instance +-- Dumpar struktur för tabell acore_characters.instance DROP TABLE IF EXISTS `instance`; CREATE TABLE IF NOT EXISTS `instance` ( `id` INT unsigned NOT NULL DEFAULT 0, @@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS `instance` ( KEY `difficulty` (`difficulty`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.instance: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.instance: ~0 rows (ungefär) DELETE FROM `instance`; /*!40000 ALTER TABLE `instance` DISABLE KEYS */; /*!40000 ALTER TABLE `instance` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/instance_reset.sql b/data/sql/base/db_characters/instance_reset.sql index f16b11ad97..73cc4f775f 100644 --- a/data/sql/base/db_characters/instance_reset.sql +++ b/data/sql/base/db_characters/instance_reset.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.instance_reset +-- Dumpar struktur för tabell acore_characters.instance_reset DROP TABLE IF EXISTS `instance_reset`; CREATE TABLE IF NOT EXISTS `instance_reset` ( `mapid` SMALLINT unsigned NOT NULL DEFAULT 0, @@ -22,81 +22,81 @@ CREATE TABLE IF NOT EXISTS `instance_reset` ( KEY `difficulty` (`difficulty`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.instance_reset: ~71 rows (приблизительно) +-- Dumpar data för tabell acore_characters.instance_reset: ~71 rows (ungefär) DELETE FROM `instance_reset`; /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */; INSERT INTO `instance_reset` (`mapid`, `difficulty`, `resettime`) VALUES - (249, 0, 1643270400), - (249, 1, 1643270400), - (269, 1, 1642752000), - (309, 0, 1642752000), - (409, 0, 1643270400), - (469, 0, 1643270400), - (509, 0, 1642752000), - (531, 0, 1643270400), - (532, 0, 1643270400), - (533, 0, 1643270400), - (533, 1, 1643270400), - (534, 0, 1643270400), - (540, 1, 1642752000), - (542, 1, 1642752000), - (543, 1, 1642752000), - (544, 0, 1643270400), - (545, 1, 1642752000), - (546, 1, 1642752000), - (547, 1, 1642752000), - (548, 0, 1643270400), - (550, 0, 1643270400), - (552, 1, 1642752000), - (553, 1, 1642752000), - (554, 1, 1642752000), - (555, 1, 1642752000), - (556, 1, 1642752000), - (557, 1, 1642752000), - (558, 1, 1642752000), - (560, 1, 1642752000), - (564, 0, 1643270400), - (565, 0, 1643270400), - (568, 0, 1642752000), - (574, 1, 1642752000), - (575, 1, 1642752000), - (576, 1, 1642752000), - (578, 1, 1642752000), - (580, 0, 1643270400), - (585, 1, 1642752000), - (595, 1, 1642752000), - (598, 1, 1642752000), - (599, 1, 1642752000), - (600, 1, 1642752000), - (601, 1, 1642752000), - (602, 1, 1642752000), - (603, 0, 1643270400), - (603, 1, 1643270400), - (604, 1, 1642752000), - (608, 1, 1642752000), - (615, 0, 1643270400), - (615, 1, 1643270400), - (616, 0, 1643270400), - (616, 1, 1643270400), - (619, 1, 1642752000), - (624, 0, 1643270400), - (624, 1, 1643270400), - (631, 0, 1643270400), - (631, 1, 1643270400), - (631, 2, 1643270400), - (631, 3, 1643270400), - (632, 1, 1642752000), - (649, 0, 1643270400), - (649, 1, 1643270400), - (649, 2, 1643270400), - (649, 3, 1643270400), - (650, 1, 1642752000), - (658, 1, 1642752000), - (668, 1, 1642752000), - (724, 0, 1643270400), - (724, 1, 1643270400), - (724, 2, 1643270400), - (724, 3, 1643270400); + (249, 0, 1651147200), + (249, 1, 1651147200), + (269, 1, 1650859200), + (309, 0, 1651032000), + (409, 0, 1651147200), + (469, 0, 1651147200), + (509, 0, 1651032000), + (531, 0, 1651147200), + (532, 0, 1651147200), + (533, 0, 1651147200), + (533, 1, 1651147200), + (534, 0, 1651147200), + (540, 1, 1650859200), + (542, 1, 1650859200), + (543, 1, 1650859200), + (544, 0, 1651147200), + (545, 1, 1650859200), + (546, 1, 1650859200), + (547, 1, 1650859200), + (548, 0, 1651147200), + (550, 0, 1651147200), + (552, 1, 1650859200), + (553, 1, 1650859200), + (554, 1, 1650859200), + (555, 1, 1650859200), + (556, 1, 1650859200), + (557, 1, 1650859200), + (558, 1, 1650859200), + (560, 1, 1650859200), + (564, 0, 1651147200), + (565, 0, 1651147200), + (568, 0, 1651032000), + (574, 1, 1650859200), + (575, 1, 1650859200), + (576, 1, 1650168000), + (578, 1, 1650801600), + (580, 0, 1651147200), + (585, 1, 1650801600), + (595, 1, 1650801600), + (598, 1, 1650801600), + (599, 1, 1650801600), + (600, 1, 1650801600), + (601, 1, 1650801600), + (602, 1, 1650801600), + (603, 0, 1651147200), + (603, 1, 1651147200), + (604, 1, 1650801600), + (608, 1, 1650801600), + (615, 0, 1651147200), + (615, 1, 1651147200), + (616, 0, 1651147200), + (616, 1, 1651147200), + (619, 1, 1650801600), + (624, 0, 1651147200), + (624, 1, 1651147200), + (631, 0, 1651147200), + (631, 1, 1651147200), + (631, 2, 1651147200), + (631, 3, 1651147200), + (632, 1, 1650801600), + (649, 0, 1651147200), + (649, 1, 1651147200), + (649, 2, 1651147200), + (649, 3, 1651147200), + (650, 1, 1650801600), + (658, 1, 1650801600), + (668, 1, 1650801600), + (724, 0, 1651147200), + (724, 1, 1651147200), + (724, 2, 1651147200), + (724, 3, 1651147200); /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; diff --git a/data/sql/base/db_characters/item_instance.sql b/data/sql/base/db_characters/item_instance.sql index e0b5ad2734..e781cd0f06 100644 --- a/data/sql/base/db_characters/item_instance.sql +++ b/data/sql/base/db_characters/item_instance.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.item_instance +-- Dumpar struktur för tabell acore_characters.item_instance DROP TABLE IF EXISTS `item_instance`; CREATE TABLE IF NOT EXISTS `item_instance` ( `guid` INT unsigned NOT NULL DEFAULT 0, @@ -22,18 +22,18 @@ CREATE TABLE IF NOT EXISTS `item_instance` ( `giftCreatorGuid` INT unsigned NOT NULL DEFAULT 0, `count` INT unsigned NOT NULL DEFAULT 1, `duration` INT NOT NULL DEFAULT 0, - `charges` tinytext DEFAULT NULL, + `charges` tinytext, `flags` MEDIUMINT unsigned NOT NULL DEFAULT 0, `enchantments` text NOT NULL, `randomPropertyId` SMALLINT NOT NULL DEFAULT 0, `durability` SMALLINT unsigned NOT NULL DEFAULT 0, `playedTime` INT unsigned NOT NULL DEFAULT 0, - `text` text DEFAULT NULL, + `text` text, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Item System'; --- Дамп данных таблицы acore_characters.item_instance: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.item_instance: ~0 rows (ungefär) DELETE FROM `item_instance`; /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/item_loot_storage.sql b/data/sql/base/db_characters/item_loot_storage.sql index f40afa3e5b..6a39e0030b 100644 --- a/data/sql/base/db_characters/item_loot_storage.sql +++ b/data/sql/base/db_characters/item_loot_storage.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.item_loot_storage +-- Dumpar struktur för tabell acore_characters.item_loot_storage DROP TABLE IF EXISTS `item_loot_storage`; CREATE TABLE IF NOT EXISTS `item_loot_storage` ( `containerGUID` INT unsigned NOT NULL, @@ -30,7 +30,7 @@ CREATE TABLE IF NOT EXISTS `item_loot_storage` ( `conditionLootId` INT NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.item_loot_storage: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.item_loot_storage: ~0 rows (ungefär) DELETE FROM `item_loot_storage`; /*!40000 ALTER TABLE `item_loot_storage` DISABLE KEYS */; /*!40000 ALTER TABLE `item_loot_storage` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/item_refund_instance.sql b/data/sql/base/db_characters/item_refund_instance.sql index 905e327f25..7dc095d4e8 100644 --- a/data/sql/base/db_characters/item_refund_instance.sql +++ b/data/sql/base/db_characters/item_refund_instance.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.item_refund_instance +-- Dumpar struktur för tabell acore_characters.item_refund_instance DROP TABLE IF EXISTS `item_refund_instance`; CREATE TABLE IF NOT EXISTS `item_refund_instance` ( `item_guid` INT unsigned NOT NULL COMMENT 'Item GUID', @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `item_refund_instance` ( PRIMARY KEY (`item_guid`,`player_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Item Refund System'; --- Дамп данных таблицы acore_characters.item_refund_instance: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.item_refund_instance: ~0 rows (ungefär) DELETE FROM `item_refund_instance`; /*!40000 ALTER TABLE `item_refund_instance` DISABLE KEYS */; /*!40000 ALTER TABLE `item_refund_instance` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/item_soulbound_trade_data.sql b/data/sql/base/db_characters/item_soulbound_trade_data.sql index 580ae3e038..682ae35702 100644 --- a/data/sql/base/db_characters/item_soulbound_trade_data.sql +++ b/data/sql/base/db_characters/item_soulbound_trade_data.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.item_soulbound_trade_data +-- Dumpar struktur för tabell acore_characters.item_soulbound_trade_data DROP TABLE IF EXISTS `item_soulbound_trade_data`; CREATE TABLE IF NOT EXISTS `item_soulbound_trade_data` ( `itemGuid` INT unsigned NOT NULL COMMENT 'Item GUID', @@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `item_soulbound_trade_data` ( PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Item Refund System'; --- Дамп данных таблицы acore_characters.item_soulbound_trade_data: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.item_soulbound_trade_data: ~0 rows (ungefär) DELETE FROM `item_soulbound_trade_data`; /*!40000 ALTER TABLE `item_soulbound_trade_data` DISABLE KEYS */; /*!40000 ALTER TABLE `item_soulbound_trade_data` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/lag_reports.sql b/data/sql/base/db_characters/lag_reports.sql index 35465c7603..2480a51b33 100644 --- a/data/sql/base/db_characters/lag_reports.sql +++ b/data/sql/base/db_characters/lag_reports.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.lag_reports +-- Dumpar struktur för tabell acore_characters.lag_reports DROP TABLE IF EXISTS `lag_reports`; CREATE TABLE IF NOT EXISTS `lag_reports` ( `reportId` INT unsigned NOT NULL AUTO_INCREMENT, @@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS `lag_reports` ( PRIMARY KEY (`reportId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; --- Дамп данных таблицы acore_characters.lag_reports: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.lag_reports: ~0 rows (ungefär) DELETE FROM `lag_reports`; /*!40000 ALTER TABLE `lag_reports` DISABLE KEYS */; /*!40000 ALTER TABLE `lag_reports` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/lfg_data.sql b/data/sql/base/db_characters/lfg_data.sql index c2327a76b7..01610ca37c 100644 --- a/data/sql/base/db_characters/lfg_data.sql +++ b/data/sql/base/db_characters/lfg_data.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.lfg_data +-- Dumpar struktur för tabell acore_characters.lfg_data DROP TABLE IF EXISTS `lfg_data`; CREATE TABLE IF NOT EXISTS `lfg_data` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `lfg_data` ( PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LFG Data'; --- Дамп данных таблицы acore_characters.lfg_data: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.lfg_data: ~0 rows (ungefär) DELETE FROM `lfg_data`; /*!40000 ALTER TABLE `lfg_data` DISABLE KEYS */; /*!40000 ALTER TABLE `lfg_data` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/log_arena_fights.sql b/data/sql/base/db_characters/log_arena_fights.sql index fc591032f9..34f1a5650d 100644 --- a/data/sql/base/db_characters/log_arena_fights.sql +++ b/data/sql/base/db_characters/log_arena_fights.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.log_arena_fights +-- Dumpar struktur för tabell acore_characters.log_arena_fights DROP TABLE IF EXISTS `log_arena_fights`; CREATE TABLE IF NOT EXISTS `log_arena_fights` ( `fight_id` INT unsigned NOT NULL, @@ -31,7 +31,7 @@ CREATE TABLE IF NOT EXISTS `log_arena_fights` ( PRIMARY KEY (`fight_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.log_arena_fights: 0 rows +-- Dumpar data för tabell acore_characters.log_arena_fights: 0 rows DELETE FROM `log_arena_fights`; /*!40000 ALTER TABLE `log_arena_fights` DISABLE KEYS */; /*!40000 ALTER TABLE `log_arena_fights` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/log_arena_memberstats.sql b/data/sql/base/db_characters/log_arena_memberstats.sql index 1802f1c94d..4c507aab40 100644 --- a/data/sql/base/db_characters/log_arena_memberstats.sql +++ b/data/sql/base/db_characters/log_arena_memberstats.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.log_arena_memberstats +-- Dumpar struktur för tabell acore_characters.log_arena_memberstats DROP TABLE IF EXISTS `log_arena_memberstats`; CREATE TABLE IF NOT EXISTS `log_arena_memberstats` ( `fight_id` INT unsigned NOT NULL, @@ -28,7 +28,7 @@ CREATE TABLE IF NOT EXISTS `log_arena_memberstats` ( PRIMARY KEY (`fight_id`,`member_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.log_arena_memberstats: 0 rows +-- Dumpar data för tabell acore_characters.log_arena_memberstats: 0 rows DELETE FROM `log_arena_memberstats`; /*!40000 ALTER TABLE `log_arena_memberstats` DISABLE KEYS */; /*!40000 ALTER TABLE `log_arena_memberstats` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/log_encounter.sql b/data/sql/base/db_characters/log_encounter.sql index 575950723a..3d5721d79c 100644 --- a/data/sql/base/db_characters/log_encounter.sql +++ b/data/sql/base/db_characters/log_encounter.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.log_encounter +-- Dumpar struktur för tabell acore_characters.log_encounter DROP TABLE IF EXISTS `log_encounter`; CREATE TABLE IF NOT EXISTS `log_encounter` ( `time` datetime NOT NULL, @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `log_encounter` ( `playersInfo` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.log_encounter: 0 rows +-- Dumpar data för tabell acore_characters.log_encounter: 0 rows DELETE FROM `log_encounter`; /*!40000 ALTER TABLE `log_encounter` DISABLE KEYS */; /*!40000 ALTER TABLE `log_encounter` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/log_money.sql b/data/sql/base/db_characters/log_money.sql index a042c727ec..95dcbea224 100644 --- a/data/sql/base/db_characters/log_money.sql +++ b/data/sql/base/db_characters/log_money.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,21 +12,22 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.log_money +-- Dumpar struktur för tabell acore_characters.log_money DROP TABLE IF EXISTS `log_money`; CREATE TABLE IF NOT EXISTS `log_money` ( `sender_acc` INT unsigned NOT NULL, `sender_guid` INT unsigned NOT NULL, - `sender_name` char(32) CHARACTER SET utf8mb4 NOT NULL, - `sender_ip` char(32) CHARACTER SET utf8mb4 NOT NULL, + `sender_name` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `sender_ip` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `receiver_acc` INT unsigned NOT NULL, - `receiver_name` char(32) CHARACTER SET utf8mb4 NOT NULL, + `receiver_name` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `money` BIGINT unsigned NOT NULL, - `topic` char(255) CHARACTER SET utf8mb4 NOT NULL, - `date` datetime NOT NULL + `topic` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `date` datetime NOT NULL, + `type` TINYINT NOT NULL COMMENT '1=COD,2=AH,3=GB DEPOSIT,4=GB WITHDRAW,5=MAIL,6=TRADE' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; --- Дамп данных таблицы acore_characters.log_money: 0 rows +-- Dumpar data för tabell acore_characters.log_money: 0 rows DELETE FROM `log_money`; /*!40000 ALTER TABLE `log_money` DISABLE KEYS */; /*!40000 ALTER TABLE `log_money` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/mail.sql b/data/sql/base/db_characters/mail.sql index 9d68742029..d558e84b26 100644 --- a/data/sql/base/db_characters/mail.sql +++ b/data/sql/base/db_characters/mail.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,29 +12,28 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.mail +-- Dumpar struktur för tabell acore_characters.mail DROP TABLE IF EXISTS `mail`; CREATE TABLE IF NOT EXISTS `mail` ( `id` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Identifier', `messageType` TINYINT unsigned NOT NULL DEFAULT 0, - `stationery` TINYINT NOT NULL DEFAULT 41, + `stationery` TINYINT NOT NULL DEFAULT '41', `mailTemplateId` SMALLINT unsigned NOT NULL DEFAULT 0, `sender` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', `receiver` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', - `subject` longtext DEFAULT NULL, - `body` longtext DEFAULT NULL, + `subject` longtext, + `body` longtext, `has_items` TINYINT unsigned NOT NULL DEFAULT 0, `expire_time` INT unsigned NOT NULL DEFAULT 0, `deliver_time` INT unsigned NOT NULL DEFAULT 0, `money` INT unsigned NOT NULL DEFAULT 0, `cod` INT unsigned NOT NULL DEFAULT 0, `checked` TINYINT unsigned NOT NULL DEFAULT 0, - `auctionId` INT NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_receiver` (`receiver`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Mail System'; --- Дамп данных таблицы acore_characters.mail: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.mail: ~0 rows (ungefär) DELETE FROM `mail`; /*!40000 ALTER TABLE `mail` DISABLE KEYS */; /*!40000 ALTER TABLE `mail` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/mail_items.sql b/data/sql/base/db_characters/mail_items.sql index 4b53f80cfe..f185f0ef57 100644 --- a/data/sql/base/db_characters/mail_items.sql +++ b/data/sql/base/db_characters/mail_items.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.mail_items +-- Dumpar struktur för tabell acore_characters.mail_items DROP TABLE IF EXISTS `mail_items`; CREATE TABLE IF NOT EXISTS `mail_items` ( `mail_id` INT unsigned NOT NULL DEFAULT 0, @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `mail_items` ( KEY `idx_mail_id` (`mail_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; --- Дамп данных таблицы acore_characters.mail_items: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.mail_items: ~0 rows (ungefär) DELETE FROM `mail_items`; /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */; /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/mail_server_character.sql b/data/sql/base/db_characters/mail_server_character.sql new file mode 100644 index 0000000000..49e39ab54c --- /dev/null +++ b/data/sql/base/db_characters/mail_server_character.sql @@ -0,0 +1,31 @@ +-- -------------------------------------------------------- +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 +-- -------------------------------------------------------- + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET NAMES utf8 */; +/*!50503 SET NAMES utf8mb4 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- Dumpar struktur för tabell acore_characters.mail_server_character +DROP TABLE IF EXISTS `mail_server_character`; +CREATE TABLE IF NOT EXISTS `mail_server_character` ( + `guid` INT unsigned NOT NULL, + `mailId` INT unsigned NOT NULL, + PRIMARY KEY (`guid`,`mailId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; + +-- Dumpar data för tabell acore_characters.mail_server_character: ~0 rows (ungefär) +DELETE FROM `mail_server_character`; +/*!40000 ALTER TABLE `mail_server_character` DISABLE KEYS */; +/*!40000 ALTER TABLE `mail_server_character` ENABLE KEYS */; + +/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; +/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */; diff --git a/data/sql/base/db_characters/mail_server_template.sql b/data/sql/base/db_characters/mail_server_template.sql new file mode 100644 index 0000000000..239bc3e800 --- /dev/null +++ b/data/sql/base/db_characters/mail_server_template.sql @@ -0,0 +1,41 @@ +-- -------------------------------------------------------- +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 +-- -------------------------------------------------------- + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET NAMES utf8 */; +/*!50503 SET NAMES utf8mb4 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- Dumpar struktur för tabell acore_characters.mail_server_template +DROP TABLE IF EXISTS `mail_server_template`; +CREATE TABLE IF NOT EXISTS `mail_server_template` ( + `id` INT unsigned NOT NULL AUTO_INCREMENT, + `reqLevel` TINYINT unsigned NOT NULL DEFAULT 0, + `reqPlayTime` INT unsigned NOT NULL DEFAULT 0, + `moneyA` INT unsigned NOT NULL DEFAULT 0, + `moneyH` INT unsigned NOT NULL DEFAULT 0, + `itemA` INT unsigned NOT NULL DEFAULT 0, + `itemCountA` INT unsigned NOT NULL DEFAULT 0, + `itemH` INT unsigned NOT NULL DEFAULT 0, + `itemCountH` INT unsigned NOT NULL DEFAULT 0, + `subject` text NOT NULL, + `body` text NOT NULL, + `active` TINYINT unsigned NOT NULL DEFAULT 1, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; + +-- Dumpar data för tabell acore_characters.mail_server_template: ~0 rows (ungefär) +DELETE FROM `mail_server_template`; +/*!40000 ALTER TABLE `mail_server_template` DISABLE KEYS */; +/*!40000 ALTER TABLE `mail_server_template` ENABLE KEYS */; + +/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; +/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */; diff --git a/data/sql/base/db_characters/pet_aura.sql b/data/sql/base/db_characters/pet_aura.sql index 85364b542e..3a8fb99715 100644 --- a/data/sql/base/db_characters/pet_aura.sql +++ b/data/sql/base/db_characters/pet_aura.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.pet_aura +-- Dumpar struktur för tabell acore_characters.pet_aura DROP TABLE IF EXISTS `pet_aura`; CREATE TABLE IF NOT EXISTS `pet_aura` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -33,7 +33,7 @@ CREATE TABLE IF NOT EXISTS `pet_aura` ( PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Pet System'; --- Дамп данных таблицы acore_characters.pet_aura: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.pet_aura: ~0 rows (ungefär) DELETE FROM `pet_aura`; /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */; /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/pet_spell.sql b/data/sql/base/db_characters/pet_spell.sql index b80c4971c5..eb502f01ff 100644 --- a/data/sql/base/db_characters/pet_spell.sql +++ b/data/sql/base/db_characters/pet_spell.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.pet_spell +-- Dumpar struktur för tabell acore_characters.pet_spell DROP TABLE IF EXISTS `pet_spell`; CREATE TABLE IF NOT EXISTS `pet_spell` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `pet_spell` ( PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Pet System'; --- Дамп данных таблицы acore_characters.pet_spell: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.pet_spell: ~0 rows (ungefär) DELETE FROM `pet_spell`; /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */; /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/pet_spell_cooldown.sql b/data/sql/base/db_characters/pet_spell_cooldown.sql index 63f4b0906b..cf934d52ce 100644 --- a/data/sql/base/db_characters/pet_spell_cooldown.sql +++ b/data/sql/base/db_characters/pet_spell_cooldown.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.pet_spell_cooldown +-- Dumpar struktur för tabell acore_characters.pet_spell_cooldown DROP TABLE IF EXISTS `pet_spell_cooldown`; CREATE TABLE IF NOT EXISTS `pet_spell_cooldown` ( `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part', @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `pet_spell_cooldown` ( PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.pet_spell_cooldown: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.pet_spell_cooldown: ~0 rows (ungefär) DELETE FROM `pet_spell_cooldown`; /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */; /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/petition.sql b/data/sql/base/db_characters/petition.sql index 615c6fccc2..19a9e6275e 100644 --- a/data/sql/base/db_characters/petition.sql +++ b/data/sql/base/db_characters/petition.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,18 +12,18 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.petition +-- Dumpar struktur för tabell acore_characters.petition DROP TABLE IF EXISTS `petition`; CREATE TABLE IF NOT EXISTS `petition` ( `ownerguid` INT unsigned NOT NULL, `petitionguid` INT unsigned DEFAULT 0, - `name` varchar(24) NOT NULL, + `name` VARCHAR(24) NOT NULL, `type` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`ownerguid`,`type`), UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild System'; --- Дамп данных таблицы acore_characters.petition: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.petition: ~0 rows (ungefär) DELETE FROM `petition`; /*!40000 ALTER TABLE `petition` DISABLE KEYS */; /*!40000 ALTER TABLE `petition` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/petition_sign.sql b/data/sql/base/db_characters/petition_sign.sql index 24d468ed88..95430f87b0 100644 --- a/data/sql/base/db_characters/petition_sign.sql +++ b/data/sql/base/db_characters/petition_sign.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.petition_sign +-- Dumpar struktur för tabell acore_characters.petition_sign DROP TABLE IF EXISTS `petition_sign`; CREATE TABLE IF NOT EXISTS `petition_sign` ( `ownerguid` INT unsigned NOT NULL, @@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS `petition_sign` ( KEY `Idx_ownerguid` (`ownerguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild System'; --- Дамп данных таблицы acore_characters.petition_sign: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.petition_sign: ~0 rows (ungefär) DELETE FROM `petition_sign`; /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */; /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/pool_quest_save.sql b/data/sql/base/db_characters/pool_quest_save.sql index 5d614a52b3..38780cd419 100644 --- a/data/sql/base/db_characters/pool_quest_save.sql +++ b/data/sql/base/db_characters/pool_quest_save.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.pool_quest_save +-- Dumpar struktur för tabell acore_characters.pool_quest_save DROP TABLE IF EXISTS `pool_quest_save`; CREATE TABLE IF NOT EXISTS `pool_quest_save` ( `pool_id` INT unsigned NOT NULL DEFAULT 0, @@ -20,48 +20,48 @@ CREATE TABLE IF NOT EXISTS `pool_quest_save` ( PRIMARY KEY (`pool_id`,`quest_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.pool_quest_save: ~38 rows (приблизительно) +-- Dumpar data för tabell acore_characters.pool_quest_save: ~38 rows (ungefär) DELETE FROM `pool_quest_save`; /*!40000 ALTER TABLE `pool_quest_save` DISABLE KEYS */; INSERT INTO `pool_quest_save` (`pool_id`, `quest_id`) VALUES - (348, 24629), - (349, 14104), - (350, 13905), - (351, 13916), - (352, 11377), - (353, 11669), - (354, 13423), - (356, 11363), - (357, 11385), - (358, 14080), - (359, 14076), - (360, 14136), - (361, 14092), - (362, 12759), - (363, 14107), - (380, 12736), - (381, 12741), - (382, 12762), - (384, 13192), - (385, 13154), - (386, 12587), - (5662, 13675), - (5663, 13762), - (5664, 13769), - (5665, 13773), - (5666, 13778), - (5667, 13784), - (5668, 13670), - (5669, 13603), - (5670, 13741), - (5671, 13746), - (5672, 13759), - (5673, 13752), - (5674, 13107), - (5675, 13114), - (5676, 13832), - (5677, 12961), - (5678, 24581); + (348, 24636), + (349, 14102), + (350, 13903), + (351, 13915), + (352, 11380), + (353, 11668), + (354, 13424), + (356, 11373), + (357, 11383), + (358, 14152), + (359, 14112), + (360, 14144), + (361, 14145), + (362, 12703), + (363, 14108), + (380, 12735), + (381, 12758), + (382, 12705), + (384, 13191), + (385, 13153), + (386, 12501), + (5662, 13674), + (5663, 13764), + (5664, 13768), + (5665, 13774), + (5666, 13779), + (5667, 13785), + (5668, 13669), + (5669, 13616), + (5670, 13743), + (5671, 13748), + (5672, 13757), + (5673, 13754), + (5674, 13100), + (5675, 13115), + (5676, 13836), + (5677, 12963), + (5678, 24584); /*!40000 ALTER TABLE `pool_quest_save` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; diff --git a/data/sql/base/db_characters/pvpstats_battlegrounds.sql b/data/sql/base/db_characters/pvpstats_battlegrounds.sql index aebe60aafd..00f0e10725 100644 --- a/data/sql/base/db_characters/pvpstats_battlegrounds.sql +++ b/data/sql/base/db_characters/pvpstats_battlegrounds.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.pvpstats_battlegrounds +-- Dumpar struktur för tabell acore_characters.pvpstats_battlegrounds DROP TABLE IF EXISTS `pvpstats_battlegrounds`; CREATE TABLE IF NOT EXISTS `pvpstats_battlegrounds` ( `id` BIGINT unsigned NOT NULL AUTO_INCREMENT, @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `pvpstats_battlegrounds` ( PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --- Дамп данных таблицы acore_characters.pvpstats_battlegrounds: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.pvpstats_battlegrounds: ~0 rows (ungefär) DELETE FROM `pvpstats_battlegrounds`; /*!40000 ALTER TABLE `pvpstats_battlegrounds` DISABLE KEYS */; /*!40000 ALTER TABLE `pvpstats_battlegrounds` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/pvpstats_players.sql b/data/sql/base/db_characters/pvpstats_players.sql index ca00db1d8d..d33a94110f 100644 --- a/data/sql/base/db_characters/pvpstats_players.sql +++ b/data/sql/base/db_characters/pvpstats_players.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.pvpstats_players +-- Dumpar struktur för tabell acore_characters.pvpstats_players DROP TABLE IF EXISTS `pvpstats_players`; CREATE TABLE IF NOT EXISTS `pvpstats_players` ( `battleground_id` BIGINT unsigned NOT NULL, @@ -32,7 +32,7 @@ CREATE TABLE IF NOT EXISTS `pvpstats_players` ( PRIMARY KEY (`battleground_id`,`character_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --- Дамп данных таблицы acore_characters.pvpstats_players: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.pvpstats_players: ~0 rows (ungefär) DELETE FROM `pvpstats_players`; /*!40000 ALTER TABLE `pvpstats_players` DISABLE KEYS */; /*!40000 ALTER TABLE `pvpstats_players` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/quest_tracker.sql b/data/sql/base/db_characters/quest_tracker.sql index 4bf2c11579..296c8745d4 100644 --- a/data/sql/base/db_characters/quest_tracker.sql +++ b/data/sql/base/db_characters/quest_tracker.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.quest_tracker +-- Dumpar struktur för tabell acore_characters.quest_tracker DROP TABLE IF EXISTS `quest_tracker`; CREATE TABLE IF NOT EXISTS `quest_tracker` ( `id` MEDIUMINT unsigned NOT NULL DEFAULT 0, @@ -21,11 +21,11 @@ CREATE TABLE IF NOT EXISTS `quest_tracker` ( `quest_complete_time` datetime DEFAULT NULL, `quest_abandon_time` datetime DEFAULT NULL, `completed_by_gm` TINYINT NOT NULL DEFAULT 0, - `core_hash` varchar(120) NOT NULL DEFAULT '0', - `core_revision` varchar(120) NOT NULL DEFAULT '0' + `core_hash` VARCHAR(120) NOT NULL DEFAULT 0, + `core_revision` VARCHAR(120) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --- Дамп данных таблицы acore_characters.quest_tracker: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.quest_tracker: ~0 rows (ungefär) DELETE FROM `quest_tracker`; /*!40000 ALTER TABLE `quest_tracker` DISABLE KEYS */; /*!40000 ALTER TABLE `quest_tracker` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/recovery_item.sql b/data/sql/base/db_characters/recovery_item.sql index dd8c4a89c6..97dbef05b6 100644 --- a/data/sql/base/db_characters/recovery_item.sql +++ b/data/sql/base/db_characters/recovery_item.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.recovery_item +-- Dumpar struktur för tabell acore_characters.recovery_item DROP TABLE IF EXISTS `recovery_item`; CREATE TABLE IF NOT EXISTS `recovery_item` ( `Id` INT unsigned NOT NULL AUTO_INCREMENT, @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `recovery_item` ( KEY `idx_guid` (`Guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; --- Дамп данных таблицы acore_characters.recovery_item: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.recovery_item: ~0 rows (ungefär) DELETE FROM `recovery_item`; /*!40000 ALTER TABLE `recovery_item` DISABLE KEYS */; /*!40000 ALTER TABLE `recovery_item` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/reserved_name.sql b/data/sql/base/db_characters/reserved_name.sql index 63f801968d..db13e784c4 100644 --- a/data/sql/base/db_characters/reserved_name.sql +++ b/data/sql/base/db_characters/reserved_name.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,14 +12,14 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.reserved_name +-- Dumpar struktur för tabell acore_characters.reserved_name DROP TABLE IF EXISTS `reserved_name`; CREATE TABLE IF NOT EXISTS `reserved_name` ( - `name` varchar(12) NOT NULL DEFAULT '', + `name` VARCHAR(12) NOT NULL DEFAULT '', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player Reserved Names'; --- Дамп данных таблицы acore_characters.reserved_name: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.reserved_name: ~0 rows (ungefär) DELETE FROM `reserved_name`; /*!40000 ALTER TABLE `reserved_name` DISABLE KEYS */; /*!40000 ALTER TABLE `reserved_name` ENABLE KEYS */; diff --git a/data/sql/base/db_characters/updates.sql b/data/sql/base/db_characters/updates.sql index 7c7225ae55..507a28001f 100644 --- a/data/sql/base/db_characters/updates.sql +++ b/data/sql/base/db_characters/updates.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,18 +12,18 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.updates +-- Dumpar struktur för tabell acore_characters.updates DROP TABLE IF EXISTS `updates`; CREATE TABLE IF NOT EXISTS `updates` ( - `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.', + `name` VARCHAR(200) NOT NULL COMMENT 'filename with extension of the update.', `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.', `state` enum('RELEASED','CUSTOM','MODULE','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', - `timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'timestamp when the query was applied.', + `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', `speed` INT unsigned NOT NULL DEFAULT 0 COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='List of all applied updates in this database.'; --- Дамп данных таблицы acore_characters.updates: 44 rows +-- Dumpar data för tabell acore_characters.updates: 49 rows DELETE FROM `updates`; /*!40000 ALTER TABLE `updates` DISABLE KEYS */; INSERT INTO `updates` (`name`, `hash`, `state`, `timestamp`, `speed`) VALUES @@ -70,7 +70,12 @@ INSERT INTO `updates` (`name`, `hash`, `state`, `timestamp`, `speed`) VALUES ('2021_10_14_01_characters.sql', 'D34A3947055382A390A134D91DD68903CA5FA7C4', 'ARCHIVED', '2022-01-21 23:39:14', 21), ('2021_11_06_00.sql', 'B36ED498D42A54BC818B6027AB1F92A7ACD0DA25', 'ARCHIVED', '2022-01-21 23:39:14', 70), ('2021_12_26_00.sql', '089B77AAA7C676D7850070C1C05644CC50EC7F36', 'ARCHIVED', '2022-01-21 23:39:14', 46), - ('2021_12_26_01.sql', '22C450827DB8E89AF4B0F6B23B3D829B96F69B6A', 'ARCHIVED', '2022-01-21 23:39:14', 54); + ('2021_12_26_01.sql', '22C450827DB8E89AF4B0F6B23B3D829B96F69B6A', 'ARCHIVED', '2022-01-21 23:39:14', 54), + ('2022_01_25_00.sql', '784BA8C193B91B471A6E6B8C4D5BCA5850AB883A', 'ARCHIVED', '2022-04-24 15:20:00', 51), + ('2022_01_29_00.sql', '1EADA7852AC70F49E8EA0030CC5FA087075F9DD4', 'ARCHIVED', '2022-04-24 15:20:00', 40), + ('2022_02_16_00.sql', '60440F15D2DD99B7327FD5BB77E03B44B29768EE', 'ARCHIVED', '2022-04-24 15:20:00', 33), + ('2022_03_01_00.sql', 'CB1DF259CAF17989F36DC7E24DFA7B08F86AE6FD', 'ARCHIVED', '2022-04-24 15:20:00', 61), + ('2022_04_19_00.sql', '5D7010FF56BC3BDFF19BEEDCE394471F768763FE', 'ARCHIVED', '2022-04-24 15:20:00', 62); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; diff --git a/data/sql/base/db_characters/updates_include.sql b/data/sql/base/db_characters/updates_include.sql index c82643598e..d0352959c6 100644 --- a/data/sql/base/db_characters/updates_include.sql +++ b/data/sql/base/db_characters/updates_include.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,15 +12,15 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.updates_include +-- Dumpar struktur för tabell acore_characters.updates_include DROP TABLE IF EXISTS `updates_include`; CREATE TABLE IF NOT EXISTS `updates_include` ( - `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', + `path` VARCHAR(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', `state` enum('RELEASED','ARCHIVED','CUSTOM') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='List of directories where we want to include sql updates.'; --- Дамп данных таблицы acore_characters.updates_include: 3 rows +-- Dumpar data för tabell acore_characters.updates_include: 3 rows DELETE FROM `updates_include`; /*!40000 ALTER TABLE `updates_include` DISABLE KEYS */; INSERT INTO `updates_include` (`path`, `state`) VALUES diff --git a/data/sql/base/db_characters/version_db_characters.sql b/data/sql/base/db_characters/version_db_characters.sql index 296d933315..c9a4101e9f 100644 --- a/data/sql/base/db_characters/version_db_characters.sql +++ b/data/sql/base/db_characters/version_db_characters.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,22 +12,22 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.version_db_characters +-- Dumpar struktur för tabell acore_characters.version_db_characters DROP TABLE IF EXISTS `version_db_characters`; CREATE TABLE IF NOT EXISTS `version_db_characters` ( - `sql_rev` varchar(100) NOT NULL, - `required_rev` varchar(100) DEFAULT NULL, - `date` varchar(50) DEFAULT NULL, - `2021_12_26_01` bit(1) DEFAULT NULL, + `sql_rev` VARCHAR(100) NOT NULL, + `required_rev` VARCHAR(100) DEFAULT NULL, + `date` VARCHAR(50) DEFAULT NULL, + `2022_04_19_00` bit(1) DEFAULT NULL, PRIMARY KEY (`sql_rev`), KEY `required` (`required_rev`), CONSTRAINT `required` FOREIGN KEY (`required_rev`) REFERENCES `version_db_characters` (`sql_rev`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='Last applied sql update to DB'; --- Дамп данных таблицы acore_characters.version_db_characters: ~23 rows (приблизительно) +-- Dumpar data för tabell acore_characters.version_db_characters: ~30 rows (ungefär) DELETE FROM `version_db_characters`; /*!40000 ALTER TABLE `version_db_characters` DISABLE KEYS */; -INSERT INTO `version_db_characters` (`sql_rev`, `required_rev`, `date`, `2021_12_26_01`) VALUES +INSERT INTO `version_db_characters` (`sql_rev`, `required_rev`, `date`, `2022_04_19_00`) VALUES ('1557226918417685700', NULL, NULL, NULL), ('1557608218190967100', NULL, NULL, NULL), ('1572030074009407852', NULL, NULL, NULL), @@ -52,7 +52,12 @@ INSERT INTO `version_db_characters` (`sql_rev`, `required_rev`, `date`, `2021_12 ('1634163696773334100', NULL, '2021_10_14_00', NULL), ('1635587652443122100', NULL, '2021_11_06_00', NULL), ('1638643807174948000', NULL, '2021_12_26_00', NULL), - ('1640532476858588300', NULL, '2021_12_26_01', NULL); + ('1640532476858588300', NULL, '2021_12_26_01', NULL), + ('1642821969869259834', NULL, '2022_01_25_00', NULL), + ('1642926800068632800', NULL, '2022_01_29_00', NULL), + ('1644159033376794200', NULL, '2022_03_01_00', NULL), + ('1644531230030579700', NULL, '2022_04_19_00', NULL), + ('1644943100668922283', NULL, '2022_02_16_00', NULL); /*!40000 ALTER TABLE `version_db_characters` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; diff --git a/data/sql/base/db_characters/warden_action.sql b/data/sql/base/db_characters/warden_action.sql index 1a87c60929..235bb86751 100644 --- a/data/sql/base/db_characters/warden_action.sql +++ b/data/sql/base/db_characters/warden_action.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,7 +12,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.warden_action +-- Dumpar struktur för tabell acore_characters.warden_action DROP TABLE IF EXISTS `warden_action`; CREATE TABLE IF NOT EXISTS `warden_action` ( `wardenId` SMALLINT unsigned NOT NULL, @@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `warden_action` ( PRIMARY KEY (`wardenId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; --- Дамп данных таблицы acore_characters.warden_action: ~0 rows (приблизительно) +-- Dumpar data för tabell acore_characters.warden_action: ~0 rows (ungefär) DELETE FROM `warden_action`; /*!40000 ALTER TABLE `warden_action` DISABLE KEYS */; INSERT INTO `warden_action` (`wardenId`, `action`) VALUES diff --git a/data/sql/base/db_characters/worldstates.sql b/data/sql/base/db_characters/worldstates.sql index 0300dfb03e..57fe46f2e9 100644 --- a/data/sql/base/db_characters/worldstates.sql +++ b/data/sql/base/db_characters/worldstates.sql @@ -1,8 +1,8 @@ -- -------------------------------------------------------- --- Хост: 127.0.0.1 --- Версия сервера: 10.6.4-MariaDB - mariadb.org binary distribution --- Операционная система: Win64 --- HeidiSQL Версия: 11.3.0.6295 +-- Värd: 127.0.0.1 +-- Serverversion: 8.0.28 - MySQL Community Server - GPL +-- Server-OS: Win64 +-- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @@ -12,29 +12,112 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Дамп структуры для таблица acore_characters.worldstates +-- Dumpar struktur för tabell acore_characters.worldstates DROP TABLE IF EXISTS `worldstates`; CREATE TABLE IF NOT EXISTS `worldstates` ( `entry` INT unsigned NOT NULL DEFAULT 0, `value` INT unsigned NOT NULL DEFAULT 0, - `comment` tinytext DEFAULT NULL, + `comment` tinytext, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Variable Saves'; --- Дамп данных таблицы acore_characters.worldstates: ~10 rows (приблизительно) +-- Dumpar data för tabell acore_characters.worldstates: ~93 rows (ungefär) DELETE FROM `worldstates`; /*!40000 ALTER TABLE `worldstates` DISABLE KEYS */; INSERT INTO `worldstates` (`entry`, `value`, `comment`) VALUES + (1, 0, NULL), + (2, 0, NULL), + (3, 0, NULL), + (4, 0, NULL), + (5, 0, NULL), + (6, 0, NULL), + (7, 0, NULL), + (8, 0, NULL), + (9, 0, NULL), + (10, 0, NULL), + (11, 0, NULL), + (12, 0, NULL), + (13, 0, NULL), + (14, 0, NULL), + (16, 0, NULL), + (17, 0, NULL), + (19, 0, NULL), + (20, 0, NULL), + (21, 0, NULL), + (22, 0, NULL), + (23, 0, NULL), + (24, 0, NULL), + (25, 0, NULL), + (26, 0, NULL), + (27, 0, NULL), + (28, 0, NULL), + (29, 0, NULL), + (31, 0, NULL), + (32, 0, NULL), + (33, 0, NULL), + (34, 0, NULL), + (35, 0, NULL), + (36, 0, NULL), + (37, 0, NULL), + (38, 0, NULL), + (39, 0, NULL), + (41, 0, NULL), + (42, 0, NULL), + (43, 0, NULL), + (44, 0, NULL), + (45, 0, NULL), + (46, 0, NULL), + (47, 0, NULL), + (48, 0, NULL), + (49, 0, NULL), + (50, 0, NULL), + (51, 0, NULL), + (52, 0, NULL), + (53, 0, NULL), + (54, 0, NULL), + (55, 0, NULL), + (56, 0, NULL), + (57, 0, NULL), + (58, 0, NULL), + (59, 0, NULL), + (60, 0, NULL), + (61, 0, NULL), + (63, 0, NULL), + (64, 0, NULL), + (65, 0, NULL), + (66, 0, NULL), + (67, 0, NULL), + (68, 0, NULL), + (69, 0, NULL), + (70, 0, NULL), + (71, 0, NULL), + (72, 0, NULL), + (73, 0, NULL), + (74, 0, NULL), + (75, 0, NULL), + (76, 0, NULL), + (77, 0, NULL), + (80, 0, NULL), + (81, 0, NULL), + (82, 0, NULL), + (83, 0, NULL), + (84, 0, NULL), + (85, 0, NULL), + (86, 0, NULL), + (87, 0, NULL), + (88, 0, NULL), + (89, 0, NULL), (3781, 9000000, NULL), (3801, 0, NULL), (3802, 1, NULL), (20001, 1454691600, 'NextArenaPointDistributionTime'), - (20002, 1471492800, 'NextWeeklyQuestResetTime'), - (20003, 1471060800, 'NextBGRandomDailyResetTime'), + (20002, 1651118400, 'NextWeeklyQuestResetTime'), + (20003, 1650859200, 'NextBGRandomDailyResetTime'), (20004, 0, 'cleaning_flags'), - (20005, 1471060800, 'NextDailyQuestResetTime'), - (20006, 1471060800, 'NextGuildDailyResetTime'), - (20007, 1472702400, 'NextMonthlyQuestResetTime'); + (20005, 1650859200, 'NextDailyQuestResetTime'), + (20006, 1650859200, 'NextGuildDailyResetTime'), + (20007, 1651377600, 'NextMonthlyQuestResetTime'), + (20008, 1650859200, NULL); /*!40000 ALTER TABLE `worldstates` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; |