Z00c82ge

1
2-- ----------------------------
3-- Table structure for accounts_extra
4-- ----------------------------
5DROP TABLE IF EXISTS `accounts_extra`;
6CREATE TABLE `accounts_extra` (
7  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID',
8  `login` varchar(18) NOT NULL COMMENT 'Login username',
9  `display_name` varchar(18) DEFAULT NULL,
10  `reg_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Reg date timestamp',
11  `reg_ip` varchar(16) NOT NULL DEFAULT '' COMMENT 'Reg remote address',
12  `money` int(30) unsigned NOT NULL DEFAULT '0' COMMENT 'Account money',
13  `who_invited` int(30) unsigned NOT NULL DEFAULT '0' COMMENT 'Какой игрок пригласил',
14  `lifetimediscount` tinyint(3) NOT NULL DEFAULT '0',
15  `name` varchar(20) NOT NULL DEFAULT '',
16  `surname` varchar(50) NOT NULL DEFAULT '',
17  `main_char` int(30) unsigned NOT NULL DEFAULT '0',
18  `can_change_email` tinyint(1) unsigned NOT NULL DEFAULT '0',
19  `can_change_name` tinyint(1) unsigned NOT NULL DEFAULT '0',
20  `email_valid` tinyint(1) unsigned NOT NULL DEFAULT '0',
21  PRIMARY KEY (`id`),
22  UNIQUE KEY `login` (`login`),
23  UNIQUE KEY `displayname` (`display_name`),
24  KEY `ip` (`reg_ip`),
25  KEY `regdate` (`reg_date`)
26) ENGINE=InnoDB AUTO_INCREMENT=1274 DEFAULT CHARSET=utf8 COMMENT='Account Information';