root/sql-files/upgrade_svn11018.sql
@
11
| Revision 1, 365 bytes (checked in by jinshiro, 17 years ago) |
|---|
| Line | |
|---|---|
| 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.
