· 10 years ago · Sep 22, 2016, 01:48 PM
1if (g_bDBMySQL)
2 {
3 SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `vip_users` (\
4 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, \
5 `auth` VARCHAR(64) UNIQUE NULL default NULL, \
6 `name` VARCHAR(64) NOT NULL default 'unknown', \
7 `auth_type` TINYINT(2) UNSIGNED NOT NULL default '0', \
8 `pass_key` VARCHAR(64) default NULL, \
9 `password` VARCHAR(64) default NULL, \
10 PRIMARY KEY (`id`), \
11 UNIQUE KEY `auth_id` (`auth`)) ENGINE=InnoDB default CHARSET=utf8 AUTO_INCREMENT=1;");
12
13 SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `vip_overrides` (\
14 `user_id` INT(10) UNSIGNED NOT NULL, \
15 `server_id` INT(10) UNSIGNED NOT NULL, \
16 `group` VARCHAR(64) default NULL, \
17 `expires` INT(10) UNSIGNED NOT NULL default '0', \
18 PRIMARY KEY (`user_id`, `server_id`), \
19 UNIQUE KEY `user_id` (`user_id`, `server_id`), \
20 CONSTRAINT `vip_overrides_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `vip_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
22 }
23 else
24 {
25 SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `vip_users` (\
26 `id` INTEGER PRIMARY KEY AUTOINCREMENT, \
27 `auth` VARCHAR(32) UNIQUE NULL default NULL, \
28 `name` VARCHAR(64) NOT NULL default 'unknown', \
29 `ip` VARCHAR(32) default NULL, \
30 `auth_type` INTEGER UNSIGNED NOT NULL default '0', \
31 `pass_key` VARCHAR(64) default NULL, \
32 `password` VARCHAR(64) default NULL, \
33 `group` VARCHAR(64) default NULL, \
34 `expires` INTEGER UNSIGNED NOT NULL default '0');");
35 }