CREATE TABLE IF NOT EXISTS `contracthistory` (
  `Oid` bigint NOT NULL AUTO_INCREMENT,
  `Tid` int NOT NULL,
  `ContractHistoryEmployeeOid` bigint DEFAULT NULL,
  `ContractHistoryEmploymentTypeOid` bigint DEFAULT NULL,
  `Notice` mediumtext,
  `ChangeType` tinyint NOT NULL DEFAULT '0',
  `ContractHistoryHourlyRate` decimal(18,10) DEFAULT NULL,
  `ContractHistoryEntryDate` datetime DEFAULT NULL,
  `ContractHistoryContractEndDate` datetime DEFAULT NULL,
  `ContractHistoryCancellationPeriod` int DEFAULT NULL,
  `ContractHistoryProbationPeriod` int DEFAULT NULL,
  `ContractHistoryWeeklyFls` decimal(18,10) DEFAULT NULL,
  `ContractHistoryWeeklyTotalhours` decimal(18,10) DEFAULT NULL,
  `ContractHistoryLeaveDays` decimal(18,10) DEFAULT NULL,
  `InsTs` datetime DEFAULT NULL,
  `InsUser` varchar(256) DEFAULT NULL,
  `Version` bigint DEFAULT NULL,
  `UpdTs` DATETIME NULL DEFAULT NULL,
  `UdpUser` varchar(256) DEFAULT NULL,
  `IsActive` tinyint DEFAULT NULL,
  `SystemEntryID` int DEFAULT NULL,
  `ContractHistoryWeeklyDays` int DEFAULT NULL,
  `ContractHistoryMonthlyTotalHours` decimal(18,10) DEFAULT NULL,
  `ContractHistoryMonthlyFLS` decimal(18,10) DEFAULT NULL,
  `ContractHistoryHourlyRateCostRateValueOid` bigint DEFAULT NULL,
  `ContractHistoryProbationPeriod2` decimal(18,10) DEFAULT NULL,
  `ContractHistoryContractTypeValueListEntryOid` bigint DEFAULT NULL,
  `ContractHistoryQualifikationsBedarfValueListEntryOid` bigint DEFAULT NULL,
  PRIMARY KEY (`Oid`))
  ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;