character_shortcuts.sql 422 B

1234567891011
  1. CREATE TABLE IF NOT EXISTS `character_shortcuts` (
  2. `charId` INT UNSIGNED NOT NULL DEFAULT 0,
  3. `slot` decimal(3) NOT NULL DEFAULT 0,
  4. `page` decimal(3) NOT NULL DEFAULT 0,
  5. `type` decimal(3) ,
  6. `shortcut_id` decimal(16) ,
  7. `level` varchar(4) ,
  8. `class_index` int(1) NOT NULL DEFAULT '0',
  9. PRIMARY KEY (`charId`,`slot`,`page`,`class_index`),
  10. KEY `shortcut_id` (`shortcut_id`)
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;