博客网站是基于最新的.NET 6开发的可跨平台Web应用

/* MySQL Backup Database: appsoft Backup Time: 2020-12-16 14:36:28 */ SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS `appsoft`.`articlecategory`; DROP TABLE IF EXISTS `appsoft`.`articleinfo`; DROP TABLE IF EXISTS `appsoft`.`articletags`; DROP TABLE IF EXISTS `appsoft`.`bannerinfo`; DROP TABLE IF EXISTS `appsoft`.`categoryinfo`; DROP TABLE IF EXISTS `appsoft`.`friendlink`; DROP TABLE IF EXISTS `appsoft`.`leavemsginfo`; DROP TABLE IF EXISTS `appsoft`.`noticeinfo`; DROP TABLE IF EXISTS `appsoft`.`qquserinfo`; DROP TABLE IF EXISTS `appsoft`.`sysaccount`; DROP TABLE IF EXISTS `appsoft`.`sysbutton`; DROP TABLE IF EXISTS `appsoft`.`sysexceptionlog`; DROP TABLE IF EXISTS `appsoft`.`sysexecutesqllog`; DROP TABLE IF EXISTS `appsoft`.`sysloginlog`; DROP TABLE IF EXISTS `appsoft`.`sysmodule`; DROP TABLE IF EXISTS `appsoft`.`sysoperatelog`; DROP TABLE IF EXISTS `appsoft`.`syspermission`; DROP TABLE IF EXISTS `appsoft`.`sysrole`; DROP TABLE IF EXISTS `appsoft`.`sysuser`; DROP TABLE IF EXISTS `appsoft`.`tagsinfo`; DROP TABLE IF EXISTS `appsoft`.`timeline`; CREATE TABLE `articlecategory` ( `Id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID', `ArticleId` varchar(36) DEFAULT NULL COMMENT '文章ID', `CategoryId` varchar(36) DEFAULT NULL COMMENT '栏目ID', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章所属栏目信息记录'; CREATE TABLE `articleinfo` ( `Id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID', `Title` varchar(128) DEFAULT NULL COMMENT '标题', `CreativeType` tinyint DEFAULT NULL COMMENT '创作类型：0-原创；1-转载', `Source` varchar(32) DEFAULT NULL COMMENT '文章来源', `SourceLink` varchar(256) DEFAULT NULL COMMENT '来源链接', `Author` varchar(32) DEFAULT NULL COMMENT '作者', `Summary` varchar(512) DEFAULT NULL COMMENT '内容摘要', `Thumbnail` varchar(256) DEFAULT NULL COMMENT '缩略图', `Content` longtext COMMENT '文章内容', `PublishDate` datetime DEFAULT NULL COMMENT '发布日期', `IsTop` tinyint(1) DEFAULT NULL COMMENT '是否置顶', `Visible` tinyint(1) DEFAULT NULL COMMENT '是否显示', `DeleteMark` tinyint(1) DEFAULT NULL COMMENT '是否删除', `ReadTimes` int DEFAULT NULL COMMENT '阅读次数', `CreatorTime` datetime DEFAULT NULL COMMENT '创建日期', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='记录文章信息'; CREATE TABLE `articletags` ( `Id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID', `ArticleId` varchar(36) DEFAULT NULL COMMENT '文章ID', `TagsId` varchar(36) DEFAULT NULL COMMENT '标签ID', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章所标签'; CREATE TABLE `bannerinfo` ( `Id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键', `Title` varchar(64) DEFAULT NULL COMMENT '标题', `ImgUrl` varchar(256) DEFAULT NULL COMMENT '图片地址', `Link` varchar(256) DEFAULT NULL COMMENT '链接', `Target` varchar(16) DEFAULT NULL COMMENT '跳转方式', `SortCode` tinyint DEFAULT NULL COMMENT '排序', `DeleteMark` tinyint(1) DEFAULT NULL COMMENT '是否删除', `CreatorTime` datetime DEFAULT NULL COMMENT '创建日期', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='首页Banner图'; CREATE TABLE `categoryinfo` ( `Id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '栏目ID', `CategoryName` varchar(32) DEFAULT NULL COMMENT '栏目名称', `ParentId` varchar(36) DEFAULT NULL COMMENT '父级栏目ID', `SortCode` int DEFAULT NULL COMMENT '排序', `EnabledMark` tinyint(1) DEFAULT NULL COMMENT '是否启用', `DeleteMark` tinyint(1) DEFAULT NULL COMMENT '是否删除', `Description` varchar(128) DEFAULT NULL COMMENT '描述', `CreatorTime` datetime DEFAULT NULL COMMENT '创建日期', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章栏目分类'; CREATE TABLE `friendlink` ( `Id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID', `SiteName` varchar(128) DEFAULT NULL COMMENT '网站名称', `Link` varchar(256) DEFAULT NULL COMMENT '网站链接', `Logo` varchar(256) DEFAULT NULL COMMENT '网站logo', `SortCode` tinyint DEFAULT NULL COMMENT '排序', `DeleteMark` tinyint(1) DEFAULT NULL COMMENT '是否删除', `CreatorTime` datetime DEFAULT NULL COMMENT '创建日期', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='友情链接'; CREATE TABLE `leavemsginfo` ( `Id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID', `ArticleId` varchar(36) DEFAULT NULL COMMENT '文章ID', `RootId` varchar(36) DEFAULT NULL COMMENT '顶级评论ID', `ParentId` varchar(36) DEFAULT NULL COMMENT '上级ID', `FromUId` varchar(36) DEFAULT NULL COMMENT '评论人ID（对应QQ用户ID）', `ToUId` varchar(36) DEFAULT NULL COMMENT '回复人ID（对应QQ用户ID）', `Content` varchar(512) DEFAULT NULL COMMENT '评论内容', `IP` varchar(64) DEFAULT NULL COMMENT 'IP地址', `Adscription` varchar(32) DEFAULT NULL COMMENT '归属地', `DeleteMark` tinyint(1) DEFAULT NULL COMMENT '是否删除', `CreatorTime` datetime DEFAULT NULL COMMENT '创建日期', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='留言信息'; CREATE TABLE `noticeinfo` ( `Id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID', `Description` varchar(256) DEFAULT NULL COMMENT '通知内容', `Link` varchar(256) DEFAULT NULL COMMENT '链接', `Target` varchar(16) DEFAULT NULL COMMENT '跳转方式', `SortCode` tinyint DEFAULT NULL COMMENT '排序', `DeleteMark` tinyint(1) DEFAULT NULL COMMENT '是否删除', `CreatorTime` datetime DEFAULT NULL COMMENT '创建日期', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='首页通知轮播展示'; CREATE TABLE `qquserinfo` ( `Id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID', `OpenId` varchar(36) DEFAULT NULL COMMENT 'QQ授权ID', `NikeName` varchar(36) DEFAULT NULL COMMENT '昵称', `Gender` varchar(8) DEFAULT NULL COMMENT '性别', `Birthday` varchar(32) DEFAULT NULL COMMENT '生日', `Province` varchar(32) DEFAULT NULL COMMENT '省份', `Image40` varchar(256) DEFAULT NULL COMMENT 'QQ头像40*40', `Image100` varchar(256) DEFAULT NULL COMMENT 'QQ头像100*100', `IsMaster` tinyint(1) DEFAULT NULL COMMENT '是否是博主', `LastLoginTime` datetime DEFAULT NULL COMMENT '最后登录日期', `AccessToken` varchar(64) DEFAULT NULL COMMENT 'QQ授权token', `ExpireDate` datetime DEFAULT NULL COMMENT 'token过期时间', `RefreshToken` varchar(64) DEFAULT NULL COMMENT '换取token', `CreatorTime` datetime DEFAULT NULL COMMENT '创建日期', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='记录QQ授权后信息接入QQ授权登录'; CREATE TABLE `sysaccount` ( `Id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键', `UserName` varchar(30) DEFAULT NULL COMMENT '账户名', `Password` varchar(100) DEFAULT NULL COMMENT '登录密码', `DepartmentId` varchar(36) DEFAULT NULL COMMENT '所属部门', `RoleId` varchar(36) DEFAULT NULL COMMENT '所属角色', `DeleteMark` tinyint(1) DEFAULT NULL COMMENT '是否删除', `EnabledMark` tinyint(1) DEFAULT NULL COMMENT '是否启用', `CreatorAccountId` varchar(36) DEFAULT NULL COMMENT '创建人账户ID', `DeleteAccountId` varchar(36) DEFAULT NULL COMMENT '删除人账户ID', `CreatorTime` datetime DEFAULT NULL COMMENT '创建日期', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='账户基本信息'; CREATE TABLE `sysbutton` ( `Id` varchar(36) CHARACTER SET utf