mirror of
https://gitee.com/durcframework/SOP.git
synced 2025-08-11 12:56:28 +08:00
19 lines
1.5 KiB
SQL
19 lines
1.5 KiB
SQL
CREATE TABLE `help_doc` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`label` varchar(64) NOT NULL DEFAULT '' COMMENT '文档名称',
|
||
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
|
||
`is_deleted` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '状态，1：启用，2：禁用',
|
||
`content` longtext COMMENT '内容',
|
||
`content_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '内容类型,1-Markdown,2-富文本',
|
||
`parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父级id',
|
||
`add_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
|
||
`add_by` bigint(20) DEFAULT '0' COMMENT '创建人id',
|
||
`update_by` bigint(20) DEFAULT '0' COMMENT '修改人id',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB COMMENT='帮助内容表';
|
||
|
||
INSERT INTO `sys_resource` ( `menu_type`, `title`, `name`, `path`, `component`, `rank`, `redirect`, `icon`, `extra_icon`, `enter_transition`, `leave_transition`, `active_path`, `auths`, `frame_src`, `frame_loading`, `keep_alive`, `hidden_tag`, `fixed_tag`, `show_link`, `show_parent`, `parent_id`, `is_deleted`, `add_time`, `update_time`, `add_by`, `update_by`) VALUES
|
||
( 0, '帮助文档', '/help', '/help', '', 99, '', 'ep:document', '', '', '', '', '', '', 0, 0, 0, 0, 1, 0, 3, 0, '2025-06-14 21:14:53', '2025-06-14 21:16:12', 1, 1);
|