27 lines
730 B
Plaintext
27 lines
730 B
Plaintext
CREATE TABLE `chatmessages` (
|
|
`Oid` bigint(19) NOT NULL AUTO_INCREMENT,
|
|
|
|
`SenderPersonOid` bigint(19) DEFAULT NULL,
|
|
`EmpfaengerPersonOid` bigint(19)
|
|
DEFAULT NULL,
|
|
`Tid` int(10) DEFAULT NULL,
|
|
`Notice` varchar(1024) DEFAULT NULL,
|
|
|
|
`InsTs` datetime DEFAULT NULL,
|
|
`InsUser` varchar(1024) DEFAULT NULL,
|
|
`Version` bigint(19) DEFAULT NULL,
|
|
|
|
`UdpUser` varchar(256) DEFAULT NULL,
|
|
`isActive` tinyint(4) DEFAULT NULL,
|
|
`SystemEntryID` int(10) DEFAULT NULL,
|
|
|
|
`ChatText` longblob,
|
|
`Uhrzeit` datetime DEFAULT NULL,
|
|
`IstZugestellt` tinyint(4) DEFAULT NULL,
|
|
|
|
`IstGelesen` tinyint(4) DEFAULT NULL,
|
|
|
|
`TeamOid` bigint(19) DEFAULT NULL,
|
|
PRIMARY KEY (`Oid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=latin1;
|