Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `table_keys` (\
- `key_name` VARCHAR(64) NOT NULL, \
- `type` VARCHAR(64) NOT NULL, \
- `expires` INTEGER UNSIGNED NOT NULL default 0, \
- `uses` INTEGER UNSIGNED NOT NULL default 1, \
- `sid` INTEGER NOT NULL, \
- `param1` VARCHAR(64) NULL default NULL, \
- `param2` VARCHAR(64) NULL default NULL, \
- `param3` VARCHAR(64) NULL default NULL, \
- `param4` VARCHAR(64) NULL default NULL, \
- `param5` VARCHAR(64) NULL default NULL, \
- PRIMARY KEY(`key_name`)) DEFAULT CHARSET=utf8;");
- SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `keys_blocked_players` (\
- `auth` VARCHAR(24) NOT NULL, \
- `block_end` INTEGER UNSIGNED NOT NULL, \
- `sid` INTEGER NOT NULL, \
- PRIMARY KEY(`auth`)) DEFAULT CHARSET=utf8;");
- SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `keys_players_used` (\
- `auth` VARCHAR(24) NOT NULL, \
- `key_name` VARCHAR(64) NOT NULL, \
- `sid` INTEGER NOT NULL) DEFAULT CHARSET=utf8;");
- SQL_TQuery(g_hDatabase, SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `keys_servers` (\
- `sid` INTEGER NOT NULL AUTO_INCREMENT,\
- `address` VARCHAR(24) NOT NULL, \
- PRIMARY KEY(`id`), \
- UNIQUE KEY `address` (`address`)) DEFAULT CHARSET=utf8;");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement