CREATE TABLE IF NOT EXISTS `news` (
`id` int UNSIGNED NOT NULL
AUTO_INCREMENT,
`title` varchar(150) NOT NULL DEFAULT '',
`text` text
NOT NULL,
`time_add` int UNSIGNED NOT NULL DEFAULT 0,
`active`
tinyint(1) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
KEY `active_time`
(`active`, `time_add`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;