summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn11018.sql
blob: 176d7e12d6908926f95425540581443c165a242f (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`)
) TYPE=MYISAM;