diff options
Diffstat (limited to 'sql/base/characters_database.sql')
| -rw-r--r-- | sql/base/characters_database.sql | 19 |
1 files changed, 10 insertions, 9 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index f407dd0afef..55abfac06c7 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2,7 +2,7 @@ -- -- Host: localhost Database: characters -- ------------------------------------------------------ --- Server version 5.7.14-log +-- Server version 10.1.6-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -1705,11 +1705,11 @@ CREATE TABLE `characters` ( `deleteInfos_Account` int(10) unsigned DEFAULT NULL, `deleteInfos_Name` varchar(12) DEFAULT NULL, `deleteDate` int(10) unsigned DEFAULT NULL, - `honor` INT(10) unsigned NOT NULL DEFAULT '0', - `honorLevel` INT(10) unsigned NOT NULL DEFAULT '1', - `prestigeLevel` INT(10) unsigned NOT NULL DEFAULT '0', - `honorRestState` TINYINT unsigned NOT NULL DEFAULT '2', - `honorRestBonus` FLOAT NOT NULL DEFAULT '0', + `honor` int(10) unsigned NOT NULL DEFAULT '0', + `honorLevel` int(10) unsigned NOT NULL DEFAULT '1', + `prestigeLevel` int(10) unsigned NOT NULL DEFAULT '0', + `honorRestState` tinyint(3) unsigned NOT NULL DEFAULT '2', + `honorRestBonus` float NOT NULL DEFAULT '0', `lastLoginBuild` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`), KEY `idx_account` (`account`), @@ -3535,8 +3535,9 @@ INSERT INTO `updates` VALUES ('2017_08_20_00_characters.sql','8C5BBF6AEAA6C7DE2F40A7D3878C8187A4729F13','ARCHIVED','2017-08-20 17:00:00',0), ('2017_08_20_01_characters.sql','2F50D5E6BF3888B8C5270D79228A1D0601FAFF1D','ARCHIVED','2017-08-20 17:52:21',0), ('2017_10_29_00_characters.sql','8CFC473E7E87E58C317A72016BF69E9050D3BC83','ARCHIVED','2017-04-19 00:07:40',25), -('2018_02_03_00_characters.sql','73E9BFD848D7A22F2A7DD89CF64E30E3A8689512','RELEASED','2018-02-03 23:52:42',0), -('2018_02_08_00_characters.sql','75FA162A9B85D678B26F972371265F1EC2C75187','RELEASED','2018-02-08 22:23:28',0); +('2018_02_03_00_characters.sql','73E9BFD848D7A22F2A7DD89CF64E30E3A8689512','ARCHIVED','2018-02-03 23:52:42',0), +('2018_02_08_00_characters.sql','75FA162A9B85D678B26F972371265F1EC2C75187','ARCHIVED','2018-02-08 22:23:28',0), +('2018_02_19_00_characters.sql','75A0FFAFD0633921708DB0F72F9CC9796ACB960B','RELEASED','2018-02-19 22:33:32',117); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3629,4 +3630,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2017-04-19 0:17:39 +-- Dump completed on 2018-02-19 22:43:09 |