26 lines
674 B
Plaintext
26 lines
674 B
Plaintext
CREATE TABLE `passwortverlauf` (
|
|
`Oid` BIGINT(19) NOT NULL
|
|
AUTO_INCREMENT COMMENT '',
|
|
`ApplicationUserOid` BIGINT(19) NULL COMMENT '',
|
|
|
|
`Tid` INT(10) NULL COMMENT '',
|
|
`Notice` VARCHAR(1024) NULL COMMENT '',
|
|
`InsTs`
|
|
DATETIME NULL COMMENT '',
|
|
`InsUser` VARCHAR(1024) NULL COMMENT '',
|
|
`Version`
|
|
BIGINT(19) NULL COMMENT '',
|
|
`UdpUser` VARCHAR(256) NULL COMMENT '',
|
|
`isActive`
|
|
TINYINT(4) NULL COMMENT '',
|
|
`SystemEntryID` INT(10) NULL COMMENT '',
|
|
`ErstellDatum`
|
|
DATETIME NULL COMMENT '',
|
|
`Passwort` VARCHAR(64) NULL COMMENT '',
|
|
|
|
`Salt` VARCHAR(128) NULL COMMENT '',
|
|
|
|
PRIMARY KEY (`Oid`) COMMENT '')
|
|
ENGINE = InnoDB
|
|
DEFAULT CHARACTER SET = latin1;
|