From efae7aa61b3b4d7fbb2782e8f00e27a6adc325c1 Mon Sep 17 00:00:00 2001
From: skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Wed, 15 Aug 2007 22:08:30 +0000
Subject: - Merged and completed Latio's work on server-side hot-key saving
 (http://www.eathena.ws/board/index.php?s=&showtopic=159388&view=findpost&p=884453)
 - Now hotkeys are stored server-side (table hotkey in SQL servers, file
 save/hotkeys.txt for TXT servers). You can disable this behaviour by
 commenting out the 'HOTKEY_SAVING' define in mmo.h - Fixed a few compilation
 warnings/errors. - Apply upgrade_svn11018.sql to create the hotkey table.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11019 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/main.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'sql-files/main.sql')

diff --git a/sql-files/main.sql b/sql-files/main.sql
index d77b8fb42..cae4570b2 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -116,6 +116,21 @@ CREATE TABLE `friends` (
   KEY  `char_id` (`char_id`)
 ) TYPE=MyISAM;
 
+--
+-- Table structure for table `hotkey`
+--
+
+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;
+
 --
 -- Table structure for table `global_reg_value`
 --
-- 
cgit v1.2.3-60-g2f50

