1
2
3
4
5
6
7
8
9
10
11
12
13
14

CREATE TABLE `sys_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serviceNodeId` int(10) unsigned NOT NULL DEFAULT '0',
  `login` varchar(20) CHARACTER SET ascii NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `mapped_to` int(10) unsigned DEFAULT NULL,
  `home` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `shell` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `quota` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `serviceNodeId` (`serviceNodeId`,`login`),
  KEY `account_id` (`account_id`),
  KEY `mapped_to` (`mapped_to`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1

CREATE TABLE `sys_users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `serviceNodeId` int(10) unsigned NOT NULL DEFAULT '0', `login` varchar(20) CHARACTER SET ascii NOT NULL, `account_id` int(10) unsigned NOT NULL, `mapped_to` int(10) unsigned DEFAULT NULL, `home` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `shell` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `quota` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `serviceNodeId` (`serviceNodeId`,`login`), KEY `account_id` (`account_id`), KEY `mapped_to` (`mapped_to`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1