aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql1
-rw-r--r--sql/updates/9444_auth_account.sql1
2 files changed, 2 insertions, 0 deletions
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`;