drop table `article`; create table `article` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT comment '编码', `title` varchar(1023) DEFAULT NULL comment '标题', `author` varchar(127) DEFAULT NULL comment '作者', `content` longtext DEFAULT NULL comment '内容', `status` int(1) DEFAULT NULL comment '状态', `order` int DEFAULT 0 comment '排序', `create_by` bigint unsigned DEFAULT NULL, `update_by` bigint unsigned DEFAULT NULL, `publish_at` datetime NULL DEFAULT NULL comment '发布时间', `created_at` datetime not null default current_timestamp comment '创建时间', `updated_at` datetime not null default current_timestamp on update current_timestamp comment '更新时间', `deleted_at` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci comment ='文章'; drop table `category`; create TABLE `category` ( `id` bigint unsigned not null auto_increment comment '编码', `title` varchar(127) default null comment '标题', `slug` varchar(127) not null comment 'id', `desc` varchar(127) null comment '描述', `parent` bigint default 0 comment '父', `order` bigint default 0 comment '排序', `status` int(1) default NULL comment '状态', `create_by` bigint unsigned DEFAULT NULL, `update_by` bigint unsigned DEFAULT NULL, `created_at` datetime not null default current_timestamp comment '创建时间', `updated_at` datetime not null default current_timestamp on update current_timestamp comment '更新时间', `deleted_at` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`), unique (`slug`) ) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci comment ='分类'; insert into category values (1, '网站首页', 'wzsy', '网站首页-分类', 0, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (2, '协会概况', 'xhgk', '协会概况-分类', 0, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (3, '协会简介', 'xhjj', '协会简介-分类', 2, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (4, '规章制度', 'gzzd', '规章制度-分类', 2, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (5, '协会领导', 'xhld', '协会领导-分类', 2, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (6, '发展历程', 'fzlc', '发展历程-分类', 2, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (7, '联系我们', 'lxwm', '联系我们-分类', 2, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (8, '重点资讯', 'zdzx', '重点资讯-分类', 0, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (9, '新闻资讯', 'xwzx', '新闻资讯-分类', 8, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (10, '通知公告', 'tzgg', '通知公告-分类', 8, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (11, '行业动态', 'hydt', '行业动态-分类', 8, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (12, '品牌活动', 'pphd', '品牌活动-分类', 8, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (13, '学习专栏', 'xxzl', '学习专栏-分类', 8, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (14, '分支机构', 'fzjg', '分支机构-分类', 0, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (15, '乡村振兴与共同富裕委员会', 'xczxygtfywyh', '乡村振兴与共同富裕委员会-分类', 14, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (16, '文化艺术委员会', 'whyswyh', '文化艺术委员会-分类', 14, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (17, '旅游委员会', 'lywyh', '旅游委员会-分类', 14, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (18, '科技委员会', 'kjwyh', '科技委员会-分类', 14, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (19, '海外联谊委员会', 'hwlywyh', '海外联谊委员会-分类', 14, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (20, '中华民族城建委员会', 'zhmzcjwyh', '中华民族城建委员会-分类', 14, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (21, '基金管理委员会', 'jjglwyh', '基金管理委员会-分类', 14, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (22, '专家委员会', 'zjwyh', '专家委员会-分类', 14, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (23, '中华传统医药委员会', 'zhctyywyh', '中华传统医药委员会-分类', 14, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (24, '主题活动', 'tthd', '主题活动-分类', 0, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (25, '会员代表大会', 'hydbdh', '会员代表大会-分类', 24, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (26, '理事会工作会议', 'lshgzhy', '理事会工作会议-分类', 24, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (27, '青少年交流专题', 'qsnjlzt', '青少年交流专题-分类', 24, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (28, '互嵌式发展专题', 'hqsfzzt', '互嵌式发展专题-分类', 24, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (29, '旅游振兴专题', 'lyzxzt', '旅游振兴专题-分类', 24, 0, 0, 0, 0, current_timestamp, current_timestamp, null); insert into category values (30, '会员天地', 'hytd', '会员天地-分类', 0, 0, 0, 0, 0, current_timestamp, current_timestamp, null); drop table `banner`; create table `banner` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT comment '编码', `title` varchar(1023) DEFAULT NULL comment '标题', `url` text DEFAULT NULL comment '地址', `slug` varchar(127) not null comment 'slug', `type` int(2) DEFAULT 0 comment '类型', `order` int DEFAULT 0 comment '排序', `status` int(1) DEFAULT NULL comment '状态', `create_by` bigint unsigned DEFAULT NULL, `update_by` bigint unsigned DEFAULT NULL, `publish_at` datetime NULL DEFAULT NULL comment '发布时间', `created_at` datetime not null default current_timestamp comment '创建时间', `updated_at` datetime not null default current_timestamp on update current_timestamp comment '更新时间', `deleted_at` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci comment ='轮播图';