-- -------------------------------------------------------- -- -- Структура таблицы `notifications` -- CREATE TABLE `notifications` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL COMMENT 'for user with id...', `type` varchar(50) NOT NULL COMMENT '"system" | "script" | "aside"', `icon` varchar(255) NOT NULL COMMENT 'Load from icon pack or url to img', `title` varchar(255) NOT NULL, `body` text NOT NULL, `link` varchar(255) NOT NULL, `create_at` timestamp NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;