diff options
| author | Andrei Karas <akaras@inbox.ru> | 2015-02-18 21:13:25 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2015-02-18 21:13:25 +0300 |
| commit | 07878798e164453fd208b7187d0f61d0177009b6 (patch) | |
| tree | c1350c7429e11d1058ab364cbc4e9fab4032e899 /hercules/templates | |
| parent | 12e0196bbf34fe878b42b4010be8c08217cf45eb (diff) | |
| download | evol-tools-07878798e164453fd208b7187d0f61d0177009b6.tar.gz evol-tools-07878798e164453fd208b7187d0f61d0177009b6.tar.bz2 evol-tools-07878798e164453fd208b7187d0f61d0177009b6.tar.xz evol-tools-07878798e164453fd208b7187d0f61d0177009b6.zip | |
hercules: convert to storage.sql
Diffstat (limited to 'hercules/templates')
| -rw-r--r-- | hercules/templates/storage.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/hercules/templates/storage.sql b/hercules/templates/storage.sql new file mode 100644 index 0000000..80cdb13 --- /dev/null +++ b/hercules/templates/storage.sql @@ -0,0 +1,20 @@ +CREATE TABLE IF NOT EXISTS `storage` ( + `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `amount` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0', + `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `identify` SMALLINT(6) UNSIGNED 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', + `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), + KEY `account_id` (`account_id`) +) ENGINE=InnoDB; + |