Cross Reference: sample-explicit-managed-user.sql
xref
: /
forgerock
/
openidm-v4
/
openidm-zip
/
src
/
main
/
resources
/
db
/
mysql
/
scripts
/
sample-explicit-managed-user.sql
Home
History
Annotate
Line#
Navigate
Download
Search
only in
./
sample-explicit-managed-user.sql revision 48a99a679220c6522d8b11dc1305f7780ae02a8e
0
N/A
0
N/A
-- -----------------------------------------------------
0
N/A
-- Table `openidm`.`managed_user`
0
N/A
-- -----------------------------------------------------
0
N/A
CREATE
TABLE
IF
NOT
EXISTS
`
openidm
`.`
managed_user
` (
0
N/A
`
objectid
`
VARCHAR
(
38
)
NOT
NULL
,
0
N/A
`
rev
`
VARCHAR
(
38
)
NOT
NULL
,
0
N/A
`
userName
`
VARCHAR
(
255
),
0
N/A
`
password
`
VARCHAR
(
255
),
0
N/A
`
accountStatus
`
VARCHAR
(
255
),
0
N/A
`
roles
`
VARCHAR
(
255
),
0
N/A
`
authzRoles
`
VARCHAR
(
255
),
0
N/A
`
lastPasswordSet
`
VARCHAR
(
255
),
0
N/A
`
postalCode
`
VARCHAR
(
255
),
0
N/A
`
stateProvince
`
VARCHAR
(
255
),
0
N/A
`
passwordAttempts
`
VARCHAR
(
255
),
0
N/A
`
lastPasswordAttempt
`
VARCHAR
(
255
),
873
N/A
`
postalAddress
`
VARCHAR
(
255
),
0
N/A
`
address2
`
VARCHAR
(
255
),
0
N/A
`
country
`
VARCHAR
(
255
),
0
N/A
`
city
`
VARCHAR
(
255
),
0
N/A
`
givenName
`
VARCHAR
(
255
),
0
N/A
`
sn
`
VARCHAR
(
255
),
733
N/A
`
telephoneNumber
`
VARCHAR
(
255
),
0
N/A
`
mail
`
VARCHAR
(
255
),
0
N/A
`
siteImage
`
VARCHAR
(
255
),
0
N/A
`
passPhrase
`
VARCHAR
(
255
),
0
N/A
`
securityAnswer
`
VARCHAR
(
255
),
0
N/A
`
securityQuestion
`
VARCHAR
(
255
),
0
N/A
`
securityAnswerAttempts
`
VARCHAR
(
255
),
0
N/A
`
lastSecurityAnswerAttempt
`
VARCHAR
(
255
),
0
N/A
`
total
`
VARCHAR
(
255
),
0
N/A
`
version
`
VARCHAR
(
255
),
0
N/A
PRIMARY
KEY
(`
objectid
`),
0
N/A
UNIQUE
INDEX
`
idx_managed_user_userName
` (`
userName
`
ASC
),
0
N/A
INDEX
`
idx_managed_user_givenName
` (`
givenName
`
ASC
),
0
N/A
INDEX
`
idx_managed_user_sn
` (`
sn
`
ASC
),
0
N/A
INDEX
`
idx_managed_user_mail
` (`
mail
`
ASC
),
0
N/A
INDEX
`
idx_managed_user_accountStatus
` (`
accountStatus
`
ASC
),
0
N/A
INDEX
`
idx_managed_user_roles
` (`
roles
`
ASC
)
0
N/A
)
0
N/A
ENGINE
=
InnoDB
;
0
N/A