upgrade_svn11018.sql 355 B

12345678910
  1. DROP TABLE IF EXISTS `hotkey`;
  2. CREATE TABLE `hotkey` (
  3. `char_id` INT(11) NOT NULL,
  4. `hotkey` TINYINT(2) unsigned NOT NULL,
  5. `type` TINYINT(1) unsigned NOT NULL default '0',
  6. `itemskill_id` INT(11) unsigned NOT NULL default '0',
  7. `skill_lvl` TINYINT(4) unsigned NOT NULL default '0',
  8. PRIMARY KEY (`char_id`,`hotkey`),
  9. INDEX (`char_id`)
  10. ) ENGINE=MYISAM;