From 3c410c7ab75a2f730ef41ca8d0c55fe1fc23ac13 Mon Sep 17 00:00:00 2001 From: Andrei Karas Date: Thu, 19 Feb 2015 00:02:49 +0300 Subject: hercules: convert to acc_reg_num_db.sql --- hercules/templates/acc_reg_num_db.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 hercules/templates/acc_reg_num_db.sql (limited to 'hercules/templates') diff --git a/hercules/templates/acc_reg_num_db.sql b/hercules/templates/acc_reg_num_db.sql new file mode 100644 index 0000000..71552c2 --- /dev/null +++ b/hercules/templates/acc_reg_num_db.sql @@ -0,0 +1,9 @@ +CREATE TABLE IF NOT EXISTS `acc_reg_num_db` ( + `account_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 (`account_id`,`key`,`index`), + KEY `account_id` (`account_id`) +) ENGINE=InnoDB; + -- cgit v1.2.3-70-g09d2