Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (GLOBAL_INFO & IS_MySQL)
- {
- SQL_FastQuery(g_hDatabase, "SET NAMES \"UTF8\"");
- SQL_FastQuery(g_hDatabase, "SET CHARSET \"UTF8\"");
- SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `vip_users` (\
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, \
- `auth` VARCHAR(64) UNIQUE NOT NULL, \
- `name` VARCHAR(64) NOT NULL default 'unknown', \
- `auth_type` TINYINT(2) UNSIGNED NOT NULL default '0', \
- `pass_key` VARCHAR(64) default NULL, \
- `password` VARCHAR(64) default NULL, \
- PRIMARY KEY (`id`), \
- UNIQUE KEY `auth_id` (`auth`)) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;");
- SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `vip_overrides` (\
- `user_id` INT(10) UNSIGNED NOT NULL, \
- `server_id` INT(10) UNSIGNED NOT NULL, \
- `group` VARCHAR(64) default NULL, \
- `expires` INT(10) UNSIGNED NOT NULL default '0', \
- PRIMARY KEY (`user_id`, `server_id`), \
- UNIQUE KEY `user_id` (`user_id`, `server_id`), \
- CONSTRAINT `vip_overrides_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `vip_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\
- ) DEFAULT CHARSET=utf8;");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement