diff options
| author | Andrei Karas <akaras@inbox.ru> | 2015-02-18 20:14:54 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2015-02-18 20:14:54 +0300 |
| commit | 12e0196bbf34fe878b42b4010be8c08217cf45eb (patch) | |
| tree | 087d368745d32a9be06c28da3dd04d9fd01969ed /hercules/templates | |
| parent | 561c8902706feec36316c270bcad0947da2a703d (diff) | |
| download | tools-12e0196bbf34fe878b42b4010be8c08217cf45eb.tar.gz tools-12e0196bbf34fe878b42b4010be8c08217cf45eb.tar.bz2 tools-12e0196bbf34fe878b42b4010be8c08217cf45eb.tar.xz tools-12e0196bbf34fe878b42b4010be8c08217cf45eb.zip | |
hercules: convert to inventory.sql
Diffstat (limited to 'hercules/templates')
| -rw-r--r-- | hercules/templates/inventory.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/hercules/templates/inventory.sql b/hercules/templates/inventory.sql new file mode 100644 index 0000000..196dc5d --- /dev/null +++ b/hercules/templates/inventory.sql @@ -0,0 +1,21 @@ +CREATE TABLE IF NOT EXISTS `inventory` ( + `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `identify` SMALLINT(6) NOT NULL DEFAULT '0', + `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `card0` SMALLINT(11) NOT NULL DEFAULT '0', + `card1` SMALLINT(11) NOT NULL DEFAULT '0', + `card2` SMALLINT(11) NOT NULL DEFAULT '0', + `card3` SMALLINT(11) NOT NULL DEFAULT '0', + `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `favorite` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), + KEY `char_id` (`char_id`) +) ENGINE=InnoDB; + |