BeWoPlaner/Model/Changes_2018_08_29.txt

CREATE TABLE IF NOT EXISTS `NotizenKategorie` (
  `Oid` bigint(19) NOT NULL AUTO_INCREMENT,
  `Tid` int(10) DEFAULT NULL,
  `IsActive` tinyint(1) 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,
  `ObjectOid` bigint(19) DEFAULT NULL,
  `ObjectTid` int(10) DEFAULT NULL,
  `KategorieName` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`Oid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `NotizenEintrag` (
  `Oid` bigint(19) NOT NULL AUTO_INCREMENT,
  `Datum` datetime DEFAULT NULL,
  `Tid` int(10) DEFAULT NULL,
  `IsActive` tinyint(1) DEFAULT NULL,
  `Notice` mediumtext 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,
  `NotizenKategorieOid` bigint(19) DEFAULT NULL,
  PRIMARY KEY (`Oid`),
  KEY `NOTIZENEINTRAG_KATEGORIE_FK` (`NotizenKategorieOid`),
  CONSTRAINT `FK_NOTIZENEINTRAG_KATEGORIE` FOREIGN KEY (`NotizenKategorieOid`) REFERENCES `NotizenKategorie` (`Oid`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;