From bc0c0ae2a334ee87df726c25b833e38a0c874614 Mon Sep 17 00:00:00 2001
From: Mogadischu <cgnad@live.de>
Date: Fri, 13 Feb 2015 18:31:50 +0000
Subject: 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>
---
 sql/base/characters_database.sql | 10 +++-------
 1 file changed, 3 insertions(+), 7 deletions(-)

(limited to 'sql/base/characters_database.sql')

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`)
-- 
cgit v1.2.3

