doc/db script/shenniusdb-2021-4-8.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : 121.196.178.11
Source Server Version : 50505
Source Host           : 121.196.178.11:3306
Source Database       : shenniusdb

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2021-04-08 15:46:53
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `cms_advlist`
-- ----------------------------
DROP TABLE IF EXISTS `cms_advlist`;
CREATE TABLE `cms_advlist` (
  `Id` int(50) NOT NULL AUTO_INCREMENT,
  `SiteId` int(11) NOT NULL,
  `Title` varchar(200) NOT NULL COMMENT '广告位名称',
  `Type` varchar(11) NOT NULL DEFAULT '0' COMMENT '广告位类型',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否启用',
  `ImgUrl` varchar(255) DEFAULT NULL COMMENT '图片地址',
  `LinkUrl` varchar(500) DEFAULT NULL COMMENT '链接地址',
  `Target` varchar(50) NOT NULL COMMENT '打开窗口类型',
  `IsTimeLimit` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否启用时间显示',
  `BeginTime` datetime DEFAULT NULL COMMENT '开始时间',
  `EndTime` datetime DEFAULT NULL COMMENT '结束时间',
  `Sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `CreateTime` datetime NOT NULL COMMENT '更新时间',
  `Summary` varchar(2000) DEFAULT NULL COMMENT '广告位说明',
  `ModifyTime` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cms_advlist
-- ----------------------------
INSERT INTO `cms_advlist` VALUES ('1', '1', '测试广告名称', '0', '
', 'http://img.feiyit.com/feiyit/website/else/cc.jpg', null, '_blank', '', '2018-11-08 00:00:00', '2018-11-08 00:00:00', '74', '2018-11-08 11:02:52', null, null);
INSERT INTO `cms_advlist` VALUES ('2', '1', '火虫网(一个程序员的日常打卡)', '1', '
', '', 'https://www.52huochong.com/', '_blank', '', null, null, '0', '2019-08-27 22:45:08', null, null);
INSERT INTO `cms_advlist` VALUES ('3', '1', '火虫社区(生活的良师益友)', '1', '
', '', 'https://bbs.52huochong.com/', '_blank', '', null, null, '0', '2019-08-27 22:45:30', null, null);
INSERT INTO `cms_advlist` VALUES ('4', '1', '在线代码工具', '1', '
', '', 'http://tools.jb51.net/code', '_blank', '', null, null, '0', '2019-10-10 22:50:18', null, null);
INSERT INTO `cms_advlist` VALUES ('5', '1', 'Linux工具快速教程', '1', '
', '', 'https://linuxtools-rst.readthedocs.io/zh_CN/latest/', '_blank', '', null, null, '0', '2019-10-10 22:49:27', null, null);
INSERT INTO `cms_advlist` VALUES ('6', '1', '.NET社区联盟', '1', '
', '', 'https://dotnet-china.com/', '_blank', '', null, null, '0', '2019-10-10 22:47:29', null, null);
INSERT INTO `cms_advlist` VALUES ('7', '1', '2222', '1', '
', '/dist/img/b1.jpg', 'javascript:void(0)', '_blank', '', null, null, '17', '2019-03-16 22:13:45', null, null);
INSERT INTO `cms_advlist` VALUES ('8', '1', '测试', '0', '
', 'http://imgs.fenfenlg.com//article/B008AEA3DCDE316834EAE5CC8D211276.jpeg', null, '_target', '', null, null, '2', '2021-04-01 17:46:39', null, '2021-04-01 17:58:02');
INSERT INTO `cms_advlist` VALUES ('9', '1', '121212', '1', '
', 'http://imgs.fenfenlg.com//advList/86B599F6E370E46D78392D3B29263BAB.jpg', null, '_target', '', null, null, '5445', '2021-04-01 17:59:19', null, '2021-04-01 17:59:26');

-- ----------------------------
-- Table structure for `cms_article`
-- ----------------------------
DROP TABLE IF EXISTS `cms_article`;
CREATE TABLE `cms_article` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自动增长',
  `SiteId` int(50) unsigned zerofill DEFAULT NULL,