C#课设项目-基于ASP.NET开发的EasyCms后台权限管理系统源码+项目说明+sql数据库.zip

/* Navicat Premium Data Transfer Source Server : mysql123123 Source Server Type : MySQL Source Server Version : 50726 Source Host : localhost:3306 Source Schema : easycms_net5 Target Server Type : MySQL Target Server Version : 50726 File Encoding : 65001 Date: 24/06/2021 10:47:02 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for cms_ad -- ---------------------------- DROP TABLE IF EXISTS `cms_ad`; CREATE TABLE `cms_ad` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ad_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '广告标题', `ad_href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '链接', `ad_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '广告图', `enable_status` tinyint(1) NOT NULL, `image_width` int(11) NOT NULL COMMENT '显示宽度', `image_height` int(11) NOT NULL COMMENT '显示高度', `create_time` datetime(0) NOT NULL COMMENT '创建时间', `create_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人', `update_time` datetime(0) NOT NULL COMMENT '更新时间', `update_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '更新人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '广告信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_ad -- ---------------------------- INSERT INTO `cms_ad` VALUES (1, '广告测试', 'www.badu.com', '/upfiles/images/20210419/f4f1e4166661432991c83c70daa1e528.png', 1, 100, 150, '2020-06-22 11:35:01', 'admin', '2021-04-19 09:48:01', 'admin'); INSERT INTO `cms_ad` VALUES (2, '广告二', 'www.baidu.com', '/upfiles/images/20210419/607ce176569ee4364cca7013.png', 1, 100, 100, '2021-04-19 09:48:41', 'admin', '2021-04-19 09:48:41', 'admin'); -- ---------------------------- -- Table structure for cms_channel -- ---------------------------- DROP TABLE IF EXISTS `cms_channel`; CREATE TABLE `cms_channel` ( `id` int(11) NOT NULL AUTO_INCREMENT, `channel_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '栏目名称', `channel_index` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '栏目索引', `parent_id` int(11) NOT NULL COMMENT '上级栏目', `channel_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '栏目图片', `channel_href` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '外链', `sort_num` int(11) NOT NULL COMMENT '排序', `channel_template` int(11) NOT NULL DEFAULT 0 COMMENT '栏目模板', `content_template` int(10) NOT NULL DEFAULT 0 COMMENT '内容模板', `drawing_enable` tinyint(255) NOT NULL DEFAULT 0 COMMENT '渲染标识：1-渲染，0-不渲染 根据需要判断', `link_type` tinyint(2) NOT NULL DEFAULT 0 COMMENT '链接类型：0-默认，1-链接到第一篇文章,2-链接到子栏目', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `create_time` datetime(0) NOT NULL, `update_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `update_time` datetime(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '栏目信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_channel -- ---------------------------- INSERT INTO `cms_channel` VALUES (1, '产品', '产品', 0, '/upfiles/images/20210422/95f632254bfe477f8aa9ab1d3a6e4b7b.jpg', '', 1, 0, 0, 1, 0, 'admin', '2020-05-13 10:10:42', 'admin', '2021-04-22 10:29:45'); INSERT INTO `cms_channel` VALUES (6, '新闻动态', '新闻动态', 0, '/upfiles/images/20210422/a88f6a835b364cf59541729481717a9d.jpg', '', 2, 0, 0, 1, 0, 'admin', '2020-05-19 12:32:13', 'admin', '2021-04-22 10:30:09'); INSERT INTO `cms_channel` VALUES (8, '联系我们', '联系我们', 0, '/upfiles/images/20210422/4bfdfca8de40453b8498085b451b01f2.jpg', '', 7, 7, 5, 1, 1, 'admin', '2020-05-19 12:33:01', 'admin', '2021-04-22 11:29:59'); INSERT INTO `cms_channel` VALUES (10, 'Banner', 'Banner', 0, '/upfiles/images/20210422/e11590b8a8324cce9dc60c052643dfe4.png', '', 0, 0, 0, 0, 0, 'admin', '2020-05-19 12:41:15', 'admin', '2021-04-22 10:32:36'); INSERT INTO `cms_channel` VALUES (13, '成功案例', '成功案例', 0, '/upfiles/images/20210422/80a16910fe7c42b2b5a07e6286526240.jpg', '', 3, 0, 0, 1, 0, 'admin', '2021-04-22 10:30:47', 'admin', '2021-04-22 10:30:47'); INSERT INTO `cms_channel` VALUES (14, '关于我们', '关于我们', 0, '/upfiles/images/20210422/e6aa9e456cd24f8bb7d9c1fd77b99bc7.jpg', '', 6, 7, 5, 1, 1, 'admin', '2021-04-22 10:55:42', 'admin', '2021-04-22 11:29:51'); INSERT INTO `cms_channel` VALUES (15, '专业服务', '专业服务', 0, '/upfiles/images/20210422/6080ec04569ee42f08ea754e.jpg', '', 4, 0, 0, 0, 0, 'admin', '2021-04-22 11:22:47', 'admin', '2021-04-22 11:23:11'); INSERT INTO `cms_channel` VALUES (16, '友情链接', '友情链接', 0, '', '', 8, 0, 0, 0, 0, 'admin', '2021-04-23 14:12:57', 'admin', '2021-04-23 14:12:57'); -- ---------------------------- -- Table structure for cms_content -- ---------------------------- DROP TABLE IF EXISTS `cms_content`; CREATE TABLE `cms_content` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文章标题', `sub_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '副标题', `content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文章内容', `summary` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '简介', `cover_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '封面图片', `dept_id` bigint(11) NOT NULL COMMENT '作者归属部门', `channel_id` int(11) NOT NULL COMMENT '栏目id', `ip_limit` tinyint(2) NOT NULL COMMENT '是否开启ip访问限制', `tags` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '标签', `content_status` tinyint(3) NOT NULL COMMENT '文章状态 0-待审，1-通过，2-草稿，100-审核不通过', `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '作者', `source` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '来源', `content_href` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '外链', `hit_count` int(11) NOT NULL DEFAULT 0 COMMENT '点击量', `is_top` tinyint(2) NOT NULL COMMENT '是否置顶 0-不置顶，1-置顶', `is_recommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否推荐 0-不推荐，1-推荐', `publish_time` datetime(0) NOT NULL COMMENT '自定义发布时间', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `create_time` datetime(0) NOT NULL, `update_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `update_time` datetime(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_title`(`title`, `publish_time`) USING BTREE, INDEX `idx_channel`(`channel_id`, `publish_time`) USING BTREE, INDEX `idx_creator`(`create_by`, `publish_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '内容表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_content -- ---------------------------- INSERT INTO `cms_content` VALUES (17, '联系我们', '联系我们', '<p>&nbsp; &nbsp; &nbsp; &nbsp;EasyCms<br/></p><ul class=\" list-paddingleft-2\" style=\"list-style-type: none;\"><li><p>地址：无锡市新吴区新洲生态园</p></li><li><p>总机：15961820351</p></li><li><p>电邮：