diff options
| author | Mogadischu <cgnad@live.de> | 2015-02-13 18:31:50 +0000 |
|---|---|---|
| committer | Duarte Duarte <dnpd.dd@gmail.com> | 2015-02-13 18:32:36 +0000 |
| commit | bc0c0ae2a334ee87df726c25b833e38a0c874614 (patch) | |
| tree | 96bca61e912521a85ea64db5cfe3824ba86c93b1 /sql/base | |
| parent | 69104cfa2a8d04af7738bf427d0c35063b3a3cb4 (diff) | |
Core/Guild: Updated and enabled most previously implemented guild and petition related packets
Merged from https://github.com/Mogadischu/TrinityCore/commits/guild
Signed-off-by: Duarte Duarte <dnpd.dd@gmail.com>
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 10 |
1 files changed, 3 insertions, 7 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 0528f355c81..55c71d4bc58 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1795,8 +1795,6 @@ CREATE TABLE `guild` ( `createdate` int(10) unsigned NOT NULL DEFAULT '0', `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0', `level` int(10) unsigned DEFAULT '1', - `experience` bigint(20) unsigned DEFAULT '0', - `todayExperience` bigint(20) unsigned DEFAULT '0', PRIMARY KEY (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1932,8 +1930,8 @@ CREATE TABLE `guild_bank_right` ( `guildid` bigint(20) unsigned NOT NULL DEFAULT '0', `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0', `rid` tinyint(3) unsigned NOT NULL DEFAULT '0', - `gbright` tinyint(3) unsigned NOT NULL DEFAULT '0', - `SlotPerDay` int(10) unsigned NOT NULL DEFAULT '0', + `gbright` tinyint(3) NOT NULL DEFAULT '0', + `SlotPerDay` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`TabId`,`rid`), KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -2610,8 +2608,7 @@ CREATE TABLE `petition` ( `ownerguid` bigint(20) unsigned NOT NULL, `petitionguid` bigint(20) unsigned DEFAULT '0', `name` varchar(24) NOT NULL, - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`ownerguid`,`type`), + PRIMARY KEY (`ownerguid`), UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2637,7 +2634,6 @@ CREATE TABLE `petition_sign` ( `petitionguid` bigint(20) unsigned NOT NULL DEFAULT '0', `playerguid` bigint(20) unsigned NOT NULL DEFAULT '0', `player_account` int(10) unsigned NOT NULL DEFAULT '0', - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`petitionguid`,`playerguid`), KEY `Idx_playerguid` (`playerguid`), KEY `Idx_ownerguid` (`ownerguid`) |