summaryrefslogtreecommitdiff
path: root/hercules/templates/skill.sql
blob: 2ee3002838ac3fd053cf241a6ce3db366cd5dacf (plain) (blame)
1
2
3
4
5
6
7
8
9
10
DROP TABLE IF EXISTS `skill`;

CREATE TABLE IF NOT EXISTS `skill` (
  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
  `lv` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
  `flag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`char_id`,`id`)
) ENGINE=InnoDB;