summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn11018.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/upgrade_svn11018.sql')
-rw-r--r--sql-files/upgrade_svn11018.sql10
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;