aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2012-09-07 14:39:19 +0200
committerShauren <shauren.trinity@gmail.com>2012-09-07 14:39:19 +0200
commit6ca7a7b78d2e08d9eae4b38d18ef7303c19acd82 (patch)
tree08b5f306b8f62d50795c9076d98f9b358ad7ed58 /sql/base
parent19b400761d011b920de808c80265225096eda7fb (diff)
Core/Guilds: Implemented basic guild leveling (no player statistics/reputation)
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql3
1 files changed, 3 insertions, 0 deletions
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 */;