mjava-ai/LonYue-master/sql/20260811_business_article.sql

CREATE TABLE business_article (
  id bigint NOT NULL AUTO_INCREMENT,
  create_by varchar(64) DEFAULT '',
  create_time datetime NULL,
  update_by varchar(64) DEFAULT '',
  update_time datetime NULL,
  title varchar(200) NOT NULL,
  slug varchar(160) NOT NULL,
  summary varchar(500) DEFAULT '',
  cover_url varchar(500) DEFAULT '',
  content longblob NULL,
  author varchar(100) DEFAULT '云璞信息',
  status char(1) NOT NULL DEFAULT '1' COMMENT '0已发布 1草稿',
  publish_time datetime NULL,
  sort int NOT NULL DEFAULT 0,
  PRIMARY KEY (id),
  UNIQUE KEY uk_business_article_slug (slug),
  KEY idx_business_article_publish (status, publish_time),
  KEY idx_business_article_sort (sort)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='官网资讯文章';

INSERT INTO sys_menu VALUES (2066, '资讯管理', 0, 10, 'article', NULL, NULL, '', 1, 0, 'M', '0', '0', NULL, '#', 'admin', NOW(), '', NULL, '官网资讯管理');
INSERT INTO sys_menu VALUES (2067, '文章管理', 2066, 1, 'article', 'business/article/index', NULL, '', 1, 0, 'C', '0', '0', 'business:article:list', '#', 'admin', NOW(), '', NULL, '官网资讯文章菜单');
INSERT INTO sys_menu VALUES (2068, '文章查询', 2067, 1, '#', '', NULL, '', 1, 0, 'F', '0', '0', 'business:article:query', '#', 'admin', NOW(), '', NULL, '');
INSERT INTO sys_menu VALUES (2069, '文章新增', 2067, 2, '#', '', NULL, '', 1, 0, 'F', '0', '0', 'business:article:add', '#', 'admin', NOW(), '', NULL, '');
INSERT INTO sys_menu VALUES (2070, '文章修改', 2067, 3, '#', '', NULL, '', 1, 0, 'F', '0', '0', 'business:article:edit', '#', 'admin', NOW(), '', NULL, '');
INSERT INTO sys_menu VALUES (2071, '文章删除', 2067, 4, '#', '', NULL, '', 1, 0, 'F', '0', '0', 'business:article:remove', '#', 'admin', NOW(), '', NULL, '');