Files
BeWoPlaner/Model/Changes_2019_08_26 ReportTemplate hinzugefügt.txt

15 lines
573 B
Plaintext

CREATE TABLE IF NOT EXISTS `reporttemplate` (
`Oid` bigint(19) NOT NULL AUTO_INCREMENT,
`Tid` int(10) DEFAULT NULL,
`IsActive` tinyint(4) DEFAULT NULL,
`Notice` varchar(1024) DEFAULT NULL,
`InsTs` datetime DEFAULT NULL,
`InsUser` varchar(256) DEFAULT NULL,
`Version` bigint(19) DEFAULT NULL,
`UdpUser` varchar(256) DEFAULT NULL,
`SystemEntryID` int(10) DEFAULT NULL,
`DisplayName` varchar(1024) DEFAULT NULL,
`ReportType` int(10) DEFAULT NULL,
`ReferenceClass` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`Oid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1