
-- --------------------------------------------------------

--
-- Структура таблицы `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `type` varchar(50) DEFAULT NULL COMMENT 'user | group | device | script | event | system | [custom_type]  - (Для удобного поиска)',
  `user_id` int(11) DEFAULT 0,
  `group_alias` varchar(100) DEFAULT NULL,
  `device_id` int(11) DEFAULT 0,
  `script_alias` varchar(100) DEFAULT NULL,
  `event_name` varchar(100) DEFAULT NULL,
  `content` text NOT NULL,
  `create_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
