CREATE TABLE IF NOT EXISTS `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 DEFAULT NULL,
  `Uhrzeit` datetime DEFAULT NULL,
  `IstZugestellt` tinyint(4) DEFAULT NULL,
  `IstGelesen` tinyint(4) DEFAULT NULL,
  `TeamOid` bigint(19) DEFAULT NULL,
  PRIMARY KEY (`Oid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `employeeappcode` (
  `Oid` BIGINT(19) NOT NULL AUTO_INCREMENT,
  `Employeeoid` BIGINT(19) NULL,
  `Tid` INT(10) NULL,
  `Notice` VARCHAR(1024) NULL,
  `InsTs` DATETIME NULL,
  `InsUser` VARCHAR(1024) NULL,
  `Version` BIGINT(19) NULL,
  `UdpUser` VARCHAR(256) NULL,
  `IsActive` TINYINT(4) NULL,
  `SystemEntryID` INT(10) NULL,
  `EmployeeCode` VARCHAR(512) NULL,
  `EmployeeCodegenDate` DATETIME NULL,
  `IsChatActive` INT DEFAULT 0,
  `NotfallStatement` VARCHAR(1024) NULL,
  PRIMARY KEY (`Oid`),
  UNIQUE INDEX `EmployeeCode_UNIQUE` (`EmployeeCode` ASC)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `customerappcode` (
  `Oid` bigint(19) NOT NULL AUTO_INCREMENT,
  `CustomerOid` 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,
  `CustomerCodeGenDate` datetime DEFAULT NULL,
  `CustomerCode` varchar(512) DEFAULT NULL,
  `IsChatActive` INT DEFAULT 0,
   PRIMARY KEY (`Oid`),
   UNIQUE KEY `CustomerCode_UNIQUE` (`CustomerCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



ALTER TABLE `employee` ADD COLUMN `EmployeeImage` LONGBLOB NULL DEFAULT NULL;