diff options
Diffstat (limited to 'sql-files/upgrade_svn11018.sql')
-rw-r--r-- | sql-files/upgrade_svn11018.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn11018.sql b/sql-files/upgrade_svn11018.sql new file mode 100644 index 000000000..176d7e12d --- /dev/null +++ b/sql-files/upgrade_svn11018.sql @@ -0,0 +1,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; |