yvjia/db/cms_page.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `cms_page`;
CREATE TABLE `cms_page` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `page_sign` VARCHAR(10) NOT NULL COMMENT '内容标识',
    `sort` INT DEFAULT '1' COMMENT '排序',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    INDEX `idx_page_sign` (`page_sign`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='内容表';

INSERT INTO cms_page(page_sign, sort) VALUES
    ('about', 2),
    ('contact', 1)
;