diff options
| author | Andrei Karas <akaras@inbox.ru> | 2015-02-18 19:15:17 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2015-02-18 19:15:48 +0300 |
| commit | e1413bbc4716e63a89d281b931c2f30d4a7017cd (patch) | |
| tree | 131b66009560e0a0c784ef7afcacb9d1713e2fcb /hercules/templates/char_reg_num_db.sql | |
| parent | 8baf09493f71df2f6ea81802748a638cbb8f6460 (diff) | |
| download | tools-e1413bbc4716e63a89d281b931c2f30d4a7017cd.tar.gz tools-e1413bbc4716e63a89d281b931c2f30d4a7017cd.tar.bz2 tools-e1413bbc4716e63a89d281b931c2f30d4a7017cd.tar.xz tools-e1413bbc4716e63a89d281b931c2f30d4a7017cd.zip | |
hercules: convert to char_reg_num_db.sql
Diffstat (limited to 'hercules/templates/char_reg_num_db.sql')
| -rw-r--r-- | hercules/templates/char_reg_num_db.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/hercules/templates/char_reg_num_db.sql b/hercules/templates/char_reg_num_db.sql new file mode 100644 index 0000000..dd96ae9 --- /dev/null +++ b/hercules/templates/char_reg_num_db.sql @@ -0,0 +1,9 @@ +CREATE TABLE IF NOT EXISTS `char_reg_num_db` ( + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `key` VARCHAR(32) BINARY NOT NULL DEFAULT '', + `index` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `value` INT(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`char_id`,`key`,`index`), + KEY `char_id` (`char_id`) +) ENGINE=InnoDB; + |