33 lines
1.3 KiB
Plaintext
33 lines
1.3 KiB
Plaintext
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; |