summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn11018.sql
blob: 8c2a4c2d9d35136d4491c80788daa8d45a22e1fb (plain) (blame)
1
2
3
4
5
6
7
8
9
10
DROP TABLE IF EXISTS `hotkey`;
CREATE TABLE `hotkey` (
	`char_id` INT(11) NOT NULL,
	`hotkey` TINYINT(2) unsigned NOT NULL,
	`type` TINYINT(1) unsigned NOT NULL default '0',
	`itemskill_id` INT(11) unsigned NOT NULL default '0',
	`skill_lvl` TINYINT(4) unsigned NOT NULL default '0',
	PRIMARY KEY (`char_id`,`hotkey`),
	INDEX (`char_id`)
) ENGINE=MYISAM;