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/upgrade_svn11018.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 sql-files/upgrade_svn11018.sql

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

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;
-- 
cgit v1.2.3-60-g2f50

