summaryrefslogtreecommitdiff
path: root/hercules/templates/skill.sql
diff options
context:
space:
mode:
Diffstat (limited to 'hercules/templates/skill.sql')
-rw-r--r--hercules/templates/skill.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/hercules/templates/skill.sql b/hercules/templates/skill.sql
new file mode 100644
index 0000000..d4a93df
--- /dev/null
+++ b/hercules/templates/skill.sql
@@ -0,0 +1,8 @@
+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;
+