Advertisement
BM_R1KO

Untitled

Jun 1st, 2017
263
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. if (GLOBAL_INFO & IS_MySQL)
  2. {
  3.     SQL_FastQuery(g_hDatabase, "SET NAMES \"UTF8\"");
  4.     SQL_FastQuery(g_hDatabase, "SET CHARSET \"UTF8\"");
  5.     SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck,    "CREATE TABLE IF NOT EXISTS `vip_users` (\
  6.                 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, \
  7.                 `auth` VARCHAR(64) UNIQUE NOT NULL, \
  8.                 `name` VARCHAR(64) NOT NULL default 'unknown', \
  9.                 `auth_type` TINYINT(2) UNSIGNED NOT NULL default '0', \
  10.                 `pass_key` VARCHAR(64) default NULL, \
  11.                 `password` VARCHAR(64) default NULL, \
  12.                 PRIMARY KEY (`id`), \
  13.                 UNIQUE KEY `auth_id` (`auth`)) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;");
  14.  
  15.     SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck,    "CREATE TABLE IF NOT EXISTS `vip_overrides` (\
  16.             `user_id` INT(10) UNSIGNED NOT NULL, \
  17.             `server_id` INT(10) UNSIGNED NOT NULL, \
  18.             `group` VARCHAR(64) default NULL, \
  19.             `expires` INT(10) UNSIGNED NOT NULL default '0', \
  20.             PRIMARY KEY (`user_id`, `server_id`), \
  21.             UNIQUE KEY `user_id` (`user_id`, `server_id`), \
  22.             CONSTRAINT `vip_overrides_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `vip_users` (`id`)  ON DELETE CASCADE ON UPDATE CASCADE\
  23.             ) DEFAULT CHARSET=utf8;");
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement