yvjia/db/cms_navigation.sql

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

DROP TABLE IF EXISTS `cms_navigation`;

CREATE TABLE `cms_navigation` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `parent_id` BIGINT DEFAULT '-1' COMMENT '父ID',
    `uid` VARCHAR(36) NOT NULL COMMENT 'UID',
    `sort` INT DEFAULT '1' COMMENT '排序',
    `is_blank` TINYINT(1) DEFAULT '-1' COMMENT '是否跳转窗口 (-1否, 1是)',
    UNIQUE KEY `uid_unique` (`uid`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='导航表';

INSERT INTO cms_navigation(parent_id, uid, sort) VALUES
    (-1, 'c605271df4', 6),
        (1, '6d24a51067', 1),
        (1, 'f34f0b2b99', 2),
    (-1, '3f482604bc', 1),
    (-1, '8920b8e8e4', 4),
    (-1, 'bb897b34d9', 3),
    (-1, 'b86f989757', 2),
    (-1, '6e9d24eb8a', 5)
;