CREATE TABLE IF NOT EXISTS `costbearer2supportconcepthistory` ( `Oid` bigint NOT NULL AUTO_INCREMENT, `Notice` varchar(1024) DEFAULT NULL, `InsUser` varchar(256) DEFAULT NULL, `InsTs` datetime DEFAULT NULL, `UdpUser` varchar(256) DEFAULT NULL, `Version` bigint DEFAULT NULL, `IsActive` tinyint DEFAULT NULL, `Tid` int NOT NULL, `SystemEntryID` int DEFAULT NULL, `CostBearer2SupportConcept_CostBearerOid` bigint DEFAULT NULL, `CostBearer2SupportConcept_SupportConceptHistoryOid` bigint DEFAULT NULL, `CostBearer2SupportConcept_HourlyRate` decimal(18,10) DEFAULT NULL, `CostBearer2SupportConcept_RateFactor` decimal(18,10) DEFAULT NULL, `CostBearer2SupportConcept_ApprovedFLS` decimal(18,10) DEFAULT NULL, `CostBearer2SupportConcept_ApprovedFLSTotal` decimal(18,10) DEFAULT NULL, `CostBearer2SupportConcept_Status` int DEFAULT NULL, `CostBearer2SupportConcept_RequestedStartDate` datetime DEFAULT NULL, `CostBearer2SupportConcept_RequestedEndDate` datetime DEFAULT NULL, `CostBearer2SupportConcept_ApprovedStartDate` datetime DEFAULT NULL, `CostBearer2SupportConcept_ApprovedEndDate` datetime DEFAULT NULL, `CostBearer2SupportConcept_CustomerReferenceNumber` varchar(512) DEFAULT NULL, `CostBearer2SupportConcept_MonthlyPayment` decimal(18,10) DEFAULT NULL, `CostBearer2SupportConcept_CostBearerContactPersonOid` bigint DEFAULT NULL, `CostBearer2SupportConcept_AuswahlBezeichnung` varchar(512) DEFAULT NULL, `ChangeType` tinyint DEFAULT NULL, PRIMARY KEY (`Oid`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;