diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/10241_characters_guilds.sql | 2 |
2 files changed, 4 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index cd460411e9e..74ad13fe060 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1533,7 +1533,7 @@ DROP TABLE IF EXISTS `guild_bank_right`; CREATE TABLE `guild_bank_right` ( `guildid` int(11) unsigned NOT NULL default '0', `TabId` tinyint(1) unsigned NOT NULL default '0', - `rid` int(11) unsigned NOT NULL default '0', + `rid` tinyint(1) unsigned NOT NULL default '0', `gbright` tinyint(3) unsigned NOT NULL default '0', `SlotPerDay` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`guildid`,`TabId`,`rid`), @@ -1659,7 +1659,7 @@ DROP TABLE IF EXISTS `guild_rank`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `guild_rank` ( `guildid` int(6) unsigned NOT NULL default '0', - `rid` int(11) unsigned NOT NULL, + `rid` tinyint(1) unsigned NOT NULL, `rname` varchar(255) NOT NULL default '', `rights` int(3) unsigned NOT NULL default '0', `BankMoneyPerDay` int(11) unsigned NOT NULL default '0', diff --git a/sql/updates/10241_characters_guilds.sql b/sql/updates/10241_characters_guilds.sql new file mode 100644 index 00000000000..ba2d2cf7277 --- /dev/null +++ b/sql/updates/10241_characters_guilds.sql @@ -0,0 +1,2 @@ +ALTER TABLE guild_rank CHANGE COLUMN rid rid TINYINT(1) UNSIGNED NOT NULL; +ALTER TABLE guild_bank_right CHANGE COLUMN rid rid TINYINT(1) UNSIGNED NOT NULL DEFAULT 0; |