summaryrefslogtreecommitdiff
path: root/hercules/templates/acc_reg_num_db.sql
blob: da8b06104ba73c35cd1bb4854fc10d858eff4f69 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
DROP TABLE IF EXISTS `acc_reg_num_db`;

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;