1
2
3
4
5
6
7
8
9

CREATE TABLE `db_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(16) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `db_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `db_id` (`db_id`,`login`),
  KEY `account_id` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1

CREATE TABLE `db_users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `login` varchar(16) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `account_id` int(10) unsigned NOT NULL, `db_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `db_id` (`db_id`,`login`), KEY `account_id` (`account_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1