CREATE TABLE `message` (
  `id` INTEGER NOT NULL AUTO_INCREMENT UNIQUE,
  `cdate` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `cuser` CHAR(32) NOT NULL,
  `recepient` CHAR(32) NOT NULL,
  `mdate` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `title` varchar(256) DEFAULT NULL ,
  `message` text DEFAULT NULL ,
  `language` varchar(8) DEFAULT NULL ,
  `deleted` DATETIME DEFAULT NULL,
  `readed` boolean DEFAULT 0,
  `category` text DEFAULT NULL ,
  `priority` text DEFAULT NULL ,

  PRIMARY KEY (id) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
