BeWoPlaner/Model/Changes_2019_06_06 AddressHistory und ContactHistory Tabelle erstellt.txt

CREATE TABLE IF NOT EXISTS `contacthistory` (
  `Oid` bigint(19) PRIMARY KEY 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,
  `ChangeType` int(10) DEFAULT NULL,
  
  `Contact_Oid` bigint(19) NOT NULL,
  `Contact_Organisation2PersonOid` bigint(19) DEFAULT NULL,
  `Contact_PersonOid` bigint(19) DEFAULT NULL,
  `Contact_InvoiceBaseSenderOid` bigint(19) DEFAULT NULL,
  `Contact_OrganisationOid` bigint(19) DEFAULT NULL,
  `Contact_InvoiceBaseRecipientOid` bigint(19) DEFAULT NULL,
  `Contact_Tid` int(10) NOT NULL,
  `Contact_Type` int(10) DEFAULT NULL,
  `Contact_Value` varchar(1024) DEFAULT NULL,
  `Contact_Notice` varchar(1024) DEFAULT NULL,
  `Contact_InsTs` datetime DEFAULT NULL,
  `Contact_InsUser` varchar(256) DEFAULT NULL,
  `Contact_Version` bigint(19) DEFAULT NULL,
  `Contact_UdpUser` varchar(256) DEFAULT NULL,
  `Contact_IsActive` tinyint(4) DEFAULT NULL,
  `Contact_SystemEntryID` int(10) DEFAULT NULL
)ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `addresshistory` (
  `Oid` bigint(19) PRIMARY KEY 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,
  `ChangeType` int(10) DEFAULT NULL,
  
  `Address_Oid` bigint(19) NOT NULL,
  `Address_Tid` int(10) NOT NULL,
  `Address_Street` varchar(256) DEFAULT NULL,
  `Address_PostalCode` varchar(128) DEFAULT NULL,
  `Address_Town` varchar(256) DEFAULT NULL,
  `Address_State` varchar(256) DEFAULT NULL,
  `Address_Country` varchar(256) DEFAULT NULL,
  `Address_Notice` varchar(1024) DEFAULT NULL,
  `Address_InsTs` datetime DEFAULT NULL,
  `Address_InsUser` varchar(256) DEFAULT NULL,
  `Address_Version` bigint(19) DEFAULT NULL,
  `Address_UdpUser` varchar(256) DEFAULT NULL,
  `Address_IsActive` tinyint(4) DEFAULT NULL,
  `Address_SystemEntryID` int(10) DEFAULT NULL,
  `Address_AddressLine1` varchar(64) DEFAULT NULL,
  `Address_AddressLine2` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;