diff options
| author | Duarte Duarte <dnpd.dd@gmail.com> | 2014-01-31 04:34:32 +0000 |
|---|---|---|
| committer | Duarte Duarte <dnpd.dd@gmail.com> | 2014-01-31 04:34:32 +0000 |
| commit | efeb54139edddbf33851fb363abd5ce779bffcab (patch) | |
| tree | 5ae35eaee2910d95633c5619d4c86bebbd621747 /sql/base | |
| parent | d749b721930311601b09b14e4e627d0f94ce2e11 (diff) | |
SQL: Update old .sql files to keep consistency with auth_database.sql
Also update characters_database.sql (generated by mysqldump)
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index f880f009893..86d08ca954b 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -221,12 +221,12 @@ DROP TABLE IF EXISTS `banned_addons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `banned_addons` ( - `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, + `Id` int(10) 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, PRIMARY KEY (`Id`), - UNIQUE KEY `idx_name_ver` (`Name`, `Version`) + UNIQUE KEY `idx_name_ver` (`Name`,`Version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1662,7 +1662,7 @@ CREATE TABLE `guild` ( `BorderStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', `BorderColor` tinyint(3) unsigned NOT NULL DEFAULT '0', `BackgroundColor` tinyint(3) unsigned NOT NULL DEFAULT '0', - `info` VARCHAR(500) NOT NULL DEFAULT '', + `info` varchar(500) NOT NULL DEFAULT '', `motd` varchar(128) NOT NULL DEFAULT '', `createdate` int(10) unsigned NOT NULL DEFAULT '0', `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0', @@ -2456,4 +2456,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2013-02-04 16:22:06 +-- Dump completed on 2014-01-26 14:39:20 |