From 6ca7a7b78d2e08d9eae4b38d18ef7303c19acd82 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 7 Sep 2012 14:39:19 +0200 Subject: Core/Guilds: Implemented basic guild leveling (no player statistics/reputation) --- sql/base/characters_database.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'sql/base') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 718ff3dba20..404ffbb6593 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1639,6 +1639,9 @@ CREATE TABLE `guild` ( `motd` varchar(128) NOT NULL DEFAULT '', `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 */; -- cgit v1.2.3