root/sql-files/upgrade_svn11018.sql
@
1
| Revision 1, 365 bytes (checked in by jinshiro, 17 years ago) |
|---|
| Rev | Line | |
|---|---|---|
| [1] | 1 | DROP TABLE IF EXISTS `hotkey`; |
| 2 | CREATE TABLE `hotkey` ( | |
| 3 | `char_id` INT(11) NOT NULL, | |
| 4 | `hotkey` TINYINT(2) unsigned NOT NULL, | |
| 5 | `type` TINYINT(1) unsigned NOT NULL default '0', | |
| 6 | `itemskill_id` INT(11) unsigned NOT NULL default '0', | |
| 7 | `skill_lvl` TINYINT(4) unsigned NOT NULL default '0', | |
| 8 | PRIMARY KEY (`char_id`,`hotkey`), | |
| 9 | INDEX (`char_id`) | |
| 10 | ) ENGINE=MYISAM; |
Note: See TracBrowser
for help on using the browser.
