[Airus 1.1.0] Добавляем систему личных сообщений

Новые таблицы в БД

Создаем 2 таблицы #__chat и #__conversation

CREATE TABLE `g3ebl_chat` (
  `id` int(11) NOT NULL,
  `conv_id` int(11) NOT NULL,
  `sender` int(11) NOT NULL,
  `addressee` int(11) NOT NULL,
  `readed` int(11) NOT NULL,
  `send_mail` int(11) NOT NULL DEFAULT 0,
  `sender_delete` int(11) NOT NULL,
  `addressee_delete` int(11) NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `g3ebl_conversation` (
  `id` int(11) NOT NULL,
  `first` int(11) NOT NULL,
  `second` int(11) NOT NULL,
  `last_message_id` int(11) NOT NULL,
  `sender` int(11) NOT NULL,
  `first_delete` int(11) NOT NULL,
  `second_delete` int(11) NOT NULL,
  `unread` int(11) NOT NULL,
  `push` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;