BeWoPlaner/Model/Changes_2021_03_10_Dokumentvorlage.txt

CREATE TABLE IF NOT EXISTS `dokumentvorlage` (
  `Oid` bigint NOT NULL AUTO_INCREMENT,
  `Tid` int NOT NULL,
  `ObjectOid` bigint DEFAULT NULL,
  `ObjectTid` int DEFAULT NULL,
  `Notice` varchar(1024) DEFAULT NULL,
  `InsTs` datetime DEFAULT NULL,
  `InsUser` varchar(256) DEFAULT NULL,
  `Version` bigint DEFAULT NULL,
  `UdpUser` varchar(256) DEFAULT NULL,
  `IsActive` tinyint DEFAULT NULL,
  `SystemEntryID` int DEFAULT NULL,
  `Tabellenzugehoerigkeit` bigint DEFAULT NULL,
  `Name` varchar(1024) DEFAULT NULL,
  `Beschreibung` varchar(1024) DEFAULT NULL,
  `Data` mediumblob,
  `Text` mediumtext,
  `RTFText` mediumtext,
  `Parent` bigint DEFAULT NULL,
  PRIMARY KEY (`Oid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;