From d6fe4b23e94f2d44d4b5161260e29aa56184e4ca Mon Sep 17 00:00:00 2001 From: silinoron Date: Tue, 17 Aug 2010 19:18:09 -0700 Subject: Add support for recruit-a-friend XP and reputation multipliers. More research needs to be done to implement summoning and granting levels. --HG-- branch : trunk --- sql/base/auth_database.sql | 1 + sql/updates/9444_auth_account.sql | 1 + 2 files changed, 2 insertions(+) create mode 100644 sql/updates/9444_auth_account.sql (limited to 'sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 459b3fa1468..a0fc7f2f6b5 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -63,6 +63,7 @@ CREATE TABLE `account` ( `expansion` tinyint(3) unsigned NOT NULL default '2', `mutetime` bigint(40) unsigned NOT NULL default '0', `locale` tinyint(3) unsigned NOT NULL default '0', + `recruiter` int(11) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_username` (`username`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC COMMENT='Account System'; diff --git a/sql/updates/9444_auth_account.sql b/sql/updates/9444_auth_account.sql new file mode 100644 index 00000000000..e4ec2c61cd6 --- /dev/null +++ b/sql/updates/9444_auth_account.sql @@ -0,0 +1 @@ +ALTER TABLE `account` ADD COLUMN `recruiter` int(11) NOT NULL default '0' AFTER `locale`; -- cgit v1.2.3