Advertisement
sorvani

instance_list_lockout

Jun 11th, 2012
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.64 KB | None | 0 0
  1. CREATE TABLE `instance_list_lockout` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `zone` int(11) unsigned NOT NULL DEFAULT '0',
  4.   `version` tinyint(4) unsigned NOT NULL DEFAULT '0',
  5.   `charid` int(11) unsigned NOT NULL DEFAULT '0',
  6.    -- Not really sure what to use here.. this needs discussed/decided and needs to work with the expedition code
  7.   `lockout_thing_npcid_whatever` int(11) NOT NULL DEFAULT '-1',
  8.   `lockout_expire` int(11) unsigned NOT NULL DEFAULT '0',
  9.   PRIMARY KEY (`zone`,`version`,`charid`,`lockout_thing_npcid_whatever`),
  10.   UNIQUE KEY `id` (`id`),
  11.   KEY `id_2` (`id`)
  12. ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement