From 6bb1c8f3f9046f6723931f57223f2a6e030aa1ca Mon Sep 17 00:00:00 2001 From: Brian Date: Mon, 26 Jul 2010 17:58:58 -0600 Subject: * Missing SQL from last commit --HG-- branch : trunk --- .../9039_world_reputation_spillover_template.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/9039_world_reputation_spillover_template.sql (limited to 'sql/updates') diff --git a/sql/updates/9039_world_reputation_spillover_template.sql b/sql/updates/9039_world_reputation_spillover_template.sql new file mode 100644 index 00000000000..6f52ad241aa --- /dev/null +++ b/sql/updates/9039_world_reputation_spillover_template.sql @@ -0,0 +1,18 @@ + +DROP TABLE IF EXISTS `reputation_spillover_template`; +CREATE TABLE `reputation_spillover_template` ( + `faction` smallint(6) unsigned NOT NULL default '0' COMMENT 'faction entry', + `faction1` smallint(6) unsigned NOT NULL default '0' COMMENT 'faction to give spillover for', + `rate_1` float NOT NULL default '0' COMMENT 'the given rep points * rate', + `rank_1` tinyint(3) unsigned NOT NULL default '0' COMMENT 'max rank, above this will not give any spillover', + `faction2` smallint(6) unsigned NOT NULL default '0', + `rate_2` float NOT NULL default '0', + `rank_2` tinyint(3) unsigned NOT NULL default '0', + `faction3` smallint(6) unsigned NOT NULL default '0', + `rate_3` float NOT NULL default '0', + `rank_3` tinyint(3) unsigned NOT NULL default '0', + `faction4` smallint(6) unsigned NOT NULL default '0', + `rate_4` float NOT NULL default '0', + `rank_4` tinyint(3) unsigned NOT NULL default '0', + PRIMARY KEY (`faction`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Reputation spillover reputation gain'; -- cgit v1.2.3