Files
BeWoPlaner/Model/Changes_2016_12_21.txt

18 lines
679 B
Plaintext
Raw Permalink Normal View History

2025-07-11 18:48:37 +02:00
CREATE TABLE IF NOT EXISTS `passwortverlauf` (
`Oid` BIGINT(19) NOT NULL AUTO_INCREMENT COMMENT '',
2016-12-22 09:43:35 +01:00
`ApplicationUserOid` BIGINT(19) NULL COMMENT '',
2025-07-11 18:48:37 +02:00
`Tid` INT(10) NULL COMMENT '',
2016-12-22 09:43:35 +01:00
`Notice` VARCHAR(1024) NULL COMMENT '',
2025-07-11 18:48:37 +02:00
`InsTs` DATETIME NULL COMMENT '',
2016-12-22 09:43:35 +01:00
`InsUser` VARCHAR(1024) NULL COMMENT '',
2025-07-11 18:48:37 +02:00
`Version` BIGINT(19) NULL COMMENT '',
2016-12-22 09:43:35 +01:00
`UdpUser` VARCHAR(256) NULL COMMENT '',
2025-07-11 18:48:37 +02:00
`isActive` TINYINT(4) NULL COMMENT '',
2016-12-22 09:43:35 +01:00
`SystemEntryID` INT(10) NULL COMMENT '',
2025-07-11 18:48:37 +02:00
`ErstellDatum` DATETIME NULL COMMENT '',
`Passwort` VARCAR(64) NULL COMMENT '',
`Salt` VARCHAR(128) NULL COMMENT '',
PRIMARY KEY (`Oid`) COMMENT '')
2016-12-22 09:43:35 +01:00
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;