diff options
| author | Jesusaves <cpntb1@ymail.com> | 2021-04-10 00:45:07 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2021-04-10 00:45:07 -0300 |
| commit | c6095ad062eaa0f5576cfab1c4fe436b90c2fbfe (patch) | |
| tree | 742dd839971d2aab1f08fd0291af66e6439646ab /hercules/templates/inventory.sql | |
| download | tools-c6095ad062eaa0f5576cfab1c4fe436b90c2fbfe.tar.gz tools-c6095ad062eaa0f5576cfab1c4fe436b90c2fbfe.tar.bz2 tools-c6095ad062eaa0f5576cfab1c4fe436b90c2fbfe.tar.xz tools-c6095ad062eaa0f5576cfab1c4fe436b90c2fbfe.zip | |
Add initial tools
Diffstat (limited to 'hercules/templates/inventory.sql')
| -rw-r--r-- | hercules/templates/inventory.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/hercules/templates/inventory.sql b/hercules/templates/inventory.sql new file mode 100644 index 0000000..9fabd54 --- /dev/null +++ b/hercules/templates/inventory.sql @@ -0,0 +1,23 @@ +DROP TABLE IF EXISTS `inventory`; + +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; + |