Powerful and easy to use cms to build websites, blogs or ecommerce stores.
HTML backendblogblog-engineblog-platformbloggingcmscontent-managementcontent-management-systemecommerceecommerce-platformno-codepage-builderphpphp-cmsphp7php8self-hostedshopping-cartweb-applicationwebsite-builder
DROP TABLE IF EXISTS `message`;
CREATE TABLE IF NOT EXISTS `message` (
`message_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`type` varchar(20) NOT NULL DEFAULT 'message',
`data` text NOT NULL,
`meta` text NOT NULL,
`status` tinyint NOT NULL DEFAULT '0', -- unread = 0, read = 1
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`message_id`),
KEY `type_status_date` (`type`,`status`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;