summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn11018.sql
diff options
context:
space:
mode:
authorskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-08-15 22:08:30 +0000
committerskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-08-15 22:08:30 +0000
commitefae7aa61b3b4d7fbb2782e8f00e27a6adc325c1 (patch)
treea56b8db8327b7fe6f71953469efd34952da10f0a /sql-files/upgrade_svn11018.sql
parent0135f76b2a674a4824c33ac9d5e7ca65c945c7c4 (diff)
downloadhercules-efae7aa61b3b4d7fbb2782e8f00e27a6adc325c1.tar.gz
hercules-efae7aa61b3b4d7fbb2782e8f00e27a6adc325c1.tar.bz2
hercules-efae7aa61b3b4d7fbb2782e8f00e27a6adc325c1.tar.xz
hercules-efae7aa61b3b4d7fbb2782e8f00e27a6adc325c1.zip
- 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
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;