文章表、文章分类表

极梦网络无忧
135 阅读5分钟 
/*
Navicat MySQL Data Transfer

Source Server         : 47.94.156.208
Source Server Version : 50648
Source Host           : 47.94.156.208:3306
Source Database       : 12_31

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

Date: 2021-04-24 16:39:00
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ds_article
-- ----------------------------
DROP TABLE IF EXISTS `ds_article`;
CREATE TABLE `ds_article` (
  `article_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文章自增ID',
  `ac_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
  `article_url` varchar(100) DEFAULT NULL COMMENT '文章跳转链接',
  `article_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '文章是否显示，0为否，1为是，默认为1',
  `article_sort` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '文章排序',
  `article_title` varchar(100) DEFAULT NULL COMMENT '文章标题',
  `article_content` text COMMENT '内容',
  `article_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文章发布时间',
  `article_pic` varchar(255) NOT NULL DEFAULT '' COMMENT '文章主图',
  PRIMARY KEY (`article_id`),
  KEY `ac_id` (`ac_id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='文章表';

-- ----------------------------
-- Records of ds_article
-- ----------------------------
INSERT INTO `ds_article` VALUES ('6', '2', '', '1', '255', '如何注册成为会员', '如何注册成为会员', '1435672310', '');
INSERT INTO `ds_article` VALUES ('7', '2', '', '1', '255', '如何搜索', '如何搜索', '1435672310', '');
INSERT INTO `ds_article` VALUES ('8', '2', '', '1', '255', '忘记密码', '忘记密码', '1435672310', '');
INSERT INTO `ds_article` VALUES ('9', '2', '', '1', '255', '我要买', '我要买', '1435672310', '');
INSERT INTO `ds_article` VALUES ('10', '2', '', '1', '255', '查看已购买商品', '查看已购买商品', '1435672310', '');
INSERT INTO `ds_article` VALUES ('11', '3', '', '1', '255', '如何管理店铺', '如何管理店铺', '1435672310', '');
INSERT INTO `ds_article` VALUES ('12', '3', '', '1', '255', '查看售出商品', '查看售出商品', '1435672310', '');
INSERT INTO `ds_article` VALUES ('13', '3', '', '1', '255', '如何发货', '如何发货', '1435672310', '');
INSERT INTO `ds_article` VALUES ('14', '3', '', '1', '255', '商城商品推荐', '商城商品推荐', '1435672310', '');
INSERT INTO `ds_article` VALUES ('15', '3', '', '1', '255', '如何申请开店', '如何申请开店', '1435672310', '');
INSERT INTO `ds_article` VALUES ('16', '4', '', '1', '255', '如何注册支付宝', '如何注册支付宝', '1435672310', '');
INSERT INTO `ds_article` VALUES ('17', '4', '', '1', '255', '在线支付', '在线支付', '1435672310', '');
INSERT INTO `ds_article` VALUES ('18', '6', '', '1', '255', '会员修改密码', '会员修改密码', '1435672310', '');
INSERT INTO `ds_article` VALUES ('19', '6', '', '1', '255', '会员修改个人资料', '会员修改个人资料', '1435672310', '');
INSERT INTO `ds_article` VALUES ('20', '6', '', '1', '255', '商品发布', '商品发布', '1435672310', '');
INSERT INTO `ds_article` VALUES ('21', '6', '', '1', '255', '修改收货地址', '修改收货地址', '1435672310', '');
INSERT INTO `ds_article` VALUES ('22', '7', '', '1', '255', '关于我们', '关于我们', '1435672310', '');
INSERT INTO `ds_article` VALUES ('23', '7', '', '1', '255', '联系我们', '联系我们', '1435672310', '');
INSERT INTO `ds_article` VALUES ('24', '7', '', '1', '255', '招聘英才', '招聘英才', '1435672310', '');
INSERT INTO `ds_article` VALUES ('25', '7', '', '1', '255', '合作及洽谈', '合作及洽谈', '1435672310', '');
INSERT INTO `ds_article` VALUES ('26', '5', '', '1', '255', '联系卖家', '联系卖家', '1435672310', '');
INSERT INTO `ds_article` VALUES ('28', '4', '', '1', '255', '分期付款', '分期付款<br />', '1435672310', '');
INSERT INTO `ds_article` VALUES ('29', '4', '', '1', '255', '邮局汇款', '邮局汇款<br />', '1435672310', '');
INSERT INTO `ds_article` VALUES ('30', '4', '', '1', '255', '公司转账', '公司转账<br />', '1435672310', '');
INSERT INTO `ds_article` VALUES ('31', '5', '', '1', '255', '退换货政策', '退换货政策', '1435672310', '');
INSERT INTO `ds_article` VALUES ('32', '5', '', '1', '255', '退换货流程', '退换货流程', '1435672310', '');
INSERT INTO `ds_article` VALUES ('33', '5', '', '1', '255', '返修/退换货', '返修/退换货', '1435672310', '');
INSERT INTO `ds_article` VALUES ('34', '5', '', '1', '255', '退款申请', '退款申请', '1435672310', '');
INSERT INTO `ds_article` VALUES ('35', '1', 'http://www.csdeshang.com/', '1', '1', '火爆销售中', '火爆销售中<br />', '1435672310', '');
INSERT INTO `ds_article` VALUES ('36', '1', '', '1', '255', '管理功能说明', '管理功能说明', '1435672310', '');
INSERT INTO `ds_article` VALUES ('37', '1', '', '1', '255', '如何扩充水印字体库', '如何扩充水印字体库', '1435672310', '');
INSERT INTO `ds_article` VALUES ('38', '1', '', '1', '255', '提示信息', '提示信息', '1435672310', '');
INSERT INTO `ds_article` VALUES ('39', '2', '', '1', '255', '积分细则', '积分细则积分细则', '1435672310', '');
INSERT INTO `ds_article` VALUES ('40', '2', '', '1', '255', '积分兑换说明', '积分兑换说明', '1435672310', '');
INSERT INTO `ds_article` VALUES ('41', '1', '', '1', '255', '功能使用说明', '功能使用说明', '1435672310', '');

-- ----------------------------
-- Table structure for ds_articleclass
-- ----------------------------
DROP TABLE IF EXISTS `ds_articleclass`;
CREATE TABLE `ds_articleclass` (
  `ac_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章分类自增ID',
  `ac_code` varchar(20) DEFAULT NULL COMMENT '文章分类标识码',
  `ac_name` varchar(100) NOT NULL COMMENT '文章分类名称',
  `ac_parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文章分类父ID',
  `ac_sort` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '文章分类排序',
  PRIMARY KEY (`ac_id`),
  KEY `ac_parent_id` (`ac_parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='文章分类表';

-- ----------------------------
-- Records of ds_articleclass
-- ----------------------------
INSERT INTO `ds_articleclass` VALUES ('1', 'notice', '商城公告', '0', '255');
INSERT INTO `ds_articleclass` VALUES ('2', 'member', '帮助中心', '0', '255');
INSERT INTO `ds_articleclass` VALUES ('3', 'store', '店主之家', '0', '255');
INSERT INTO `ds_articleclass` VALUES ('4', 'payment', '支付方式', '0', '255');
INSERT INTO `ds_articleclass` VALUES ('5', 'sold', '售后服务', '0', '255');
INSERT INTO `ds_articleclass` VALUES ('6', 'service', '客服中心', '0', '255');
INSERT INTO `ds_articleclass` VALUES ('7', 'about', '关于我们', '0', '255');
avatar
文章
阅读
粉丝