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;