sample-explicit-managed-user.sql revision 48a99a679220c6522d8b11dc1305f7780ae02a8e
0N/A
0N/A-- -----------------------------------------------------
0N/A-- Table `openidm`.`managed_user`
0N/A-- -----------------------------------------------------
0N/ACREATE TABLE IF NOT EXISTS `openidm`.`managed_user` (
0N/A `objectid` VARCHAR(38) NOT NULL,
0N/A `rev` VARCHAR(38) NOT NULL,
0N/A `userName` VARCHAR(255),
0N/A `password` VARCHAR(255),
0N/A `accountStatus` VARCHAR(255),
0N/A `roles` VARCHAR(255),
0N/A `authzRoles` VARCHAR(255),
0N/A `lastPasswordSet` VARCHAR(255),
0N/A `postalCode` VARCHAR(255),
0N/A `stateProvince` VARCHAR(255),
0N/A `passwordAttempts` VARCHAR(255),
0N/A `lastPasswordAttempt` VARCHAR(255),
873N/A `postalAddress` VARCHAR(255),
0N/A `address2` VARCHAR(255),
0N/A `country` VARCHAR(255),
0N/A `city` VARCHAR(255),
0N/A `givenName` VARCHAR(255),
0N/A `sn` VARCHAR(255),
733N/A `telephoneNumber` VARCHAR(255),
0N/A `mail` VARCHAR(255),
0N/A `siteImage` VARCHAR(255),
0N/A `passPhrase` VARCHAR(255),
0N/A `securityAnswer` VARCHAR(255),
0N/A `securityQuestion` VARCHAR(255),
0N/A `securityAnswerAttempts` VARCHAR(255),
0N/A `lastSecurityAnswerAttempt` VARCHAR(255),
0N/A `total` VARCHAR(255),
0N/A `version` VARCHAR(255),
0N/A PRIMARY KEY (`objectid`),
0N/A UNIQUE INDEX `idx_managed_user_userName` (`userName` ASC),
0N/A INDEX `idx_managed_user_givenName` (`givenName` ASC),
0N/A INDEX `idx_managed_user_sn` (`sn` ASC),
0N/A INDEX `idx_managed_user_mail` (`mail` ASC),
0N/A INDEX `idx_managed_user_accountStatus` (`accountStatus` ASC),
0N/A INDEX `idx_managed_user_roles` (`roles` ASC)
0N/A)
0N/AENGINE = InnoDB;
0N/A