/*
Navicat MySQL Data Transfer

Source Server         : MYSQL
Source Server Version : 50540
Source Host           : localhost:3306
Source Database       : test

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

Date: 2017-03-04 10:56:51
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `site_admin`
-- ----------------------------
DROP TABLE IF EXISTS `site_admin`;
CREATE TABLE `site_admin` (
  `id` smallint(10) unsigned NOT NULL AUTO_INCREMENT,
  `userName` varchar(50) NOT NULL,
  `userPassword` varchar(50) NOT NULL,
  `userType` smallint(10) NOT NULL,
  `uCompetence` varchar(500) DEFAULT NULL,
  `uRealName` varchar(100) DEFAULT NULL,
  `uJoinTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of site_admin
-- ----------------------------
INSERT INTO `site_admin` VALUES ('1', 'admin', '69a1b2b530b3bec6', '216', '', '管理员', '2011-07-13 15:39:06');

-- ----------------------------
-- Table structure for `site_category`
-- ----------------------------
DROP TABLE IF EXISTS `site_category`;
CREATE TABLE `site_category` (
  `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `CatalogParentId` int(10) DEFAULT NULL,
  `Mlevel` smallint(5) DEFAULT NULL,
  `SortId` int(10) DEFAULT NULL,
  `rootid` varchar(200) DEFAULT NULL,
  `MyRootid` varchar(200) DEFAULT NULL,
  `tp` varchar(50) DEFAULT NULL,
  `readme` text,
  `adate` datetime DEFAULT NULL,
  `xia` tinyint(1) DEFAULT '0',
  `InfoType` varchar(20) DEFAULT NULL,
  `ImgW` varchar(5) DEFAULT NULL,
  `ImgH` varchar(5) DEFAULT NULL,
  `pageUrl` varchar(100) DEFAULT NULL,
  `thisCSS` varchar(50) DEFAULT NULL,
  `thisKeywords` text,
  `thisDescription` text,
  `htmlFilePath` varchar(500) DEFAULT NULL,
  `isDisplay` tinyint(1) DEFAULT '0',
  `English` varchar(50) DEFAULT NULL COMMENT '英文信息',
  PRIMARY KEY (`id`),
  KEY `CatalogParentId` (`CatalogParentId`),
  KEY `SortId` (`SortId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 DELAY_KEY_WRITE=1;

-- ----------------------------
-- Records of site_category
-- ----------------------------

-- ----------------------------
-- Table structure for `site_content`
-- ----------------------------
DROP TABLE IF EXISTS `site_content`;
CREATE TABLE `site_content` (
  `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` int(20) NOT NULL,
  `title` varchar(500) DEFAULT NULL,
  `subTitle` varchar(500) DEFAULT NULL,
  `content` longtext,
  `aAuthor` varchar(100) DEFAULT NULL,
  `aFrom` varchar(100) DEFAULT NULL,
  `tColor` varchar(10) DEFAULT NULL,
  `xian` varchar(10) DEFAULT NULL,
  `pic` varchar(500) DEFAULT NULL,
  `isRecommend` tinyint(1) DEFAULT '0',
  `isHot` tinyint(1) DEFAULT '0',
  `isHeadlines` tinyint(1) DEFAULT '0',
  `isSlide` tinyint(1) DEFAULT '0',
  `aKeywords` text,
  `aDescription` text,
  `aPassword` varchar(32) DEFAULT NULL,
  `jumpUrl` varchar(500) DEFAULT NULL,
  `aCount` int(10) DEFAULT NULL,
  `adate` datetime DEFAULT NULL,
  `Content_img` text,
  `userID` int(10) DEFAULT '0',
  `isCheck` tinyint(1) DEFAULT NULL,
  `permissionLevels` int(5) DEFAULT NULL,
  `px` int(10) DEFAULT NULL,
  `isSales` tinyint(1) DEFAULT '0',
  `aPrice` int(10) DEFAULT NULL,
  `htmlFilePath` varchar(200) DEFAULT NULL,
  `aTags` varchar(500) DEFAULT NULL,
  `attachments` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`),
  KEY `adate` (`adate`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 DELAY_KEY_WRITE=1;

-- ----------------------------
-- Records of site_content
-- ----------------------------

-- ----------------------------
-- Table structure for `site_feedback`
-- ----------------------------
DROP TABLE IF EXISTS `site_feedback`;
CREATE TABLE `site_feedback` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `f_Name` varchar(100) DEFAULT NULL COMMENT 'f_Name',
  `f_MobTel` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `f_Mail` varchar(100) DEFAULT NULL COMMENT '联系邮箱',
  `f_Content` text COMMENT '留言内容',
  `f_Reply` text COMMENT '回复内容',
  `addDate` datetime DEFAULT NULL COMMENT '留言时间',
  `reTime` datetime DEFAULT NULL COMMENT '回复时间',
  `okReply` tinyint(1) DEFAULT '0' COMMENT '判断是否回复',
  `okDisplay` tinyint(1) DEFAULT '0' COMMENT '是否显示在前台',
  PRIMARY KEY (`id`),
  KEY `addDate` (`addDate`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of site_feedback
-- ----------------------------
INSERT INTO `site_feedback` VALUES ('1', '你的！', '027-89998995', null, '027-89998995', '0', '2016-10-31 21:40:13', '2016-10-31 21:40:13', '0', '0');

-- ----------------------------
-- Table structure for `site_setting`
-- ----------------------------
DROP TABLE IF EXISTS `site_setting`;
CREATE TABLE `site_setting` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `siteTitle` varchar(500) DEFAULT NULL,
  `companyName` varchar(500) DEFAULT NULL,
  `siteKeywords` varchar(500) DEFAULT NULL,
  `siteDescription` varchar(1000) DEFAULT NULL,
  `siteHttp` varchar(200) DEFAULT NULL,
  `siteStat` varchar(1000) DEFAULT NULL,
  `isOpenQQonline` tinyint(1) DEFAULT '0',
  `isOpenShareCode` tinyint(1) DEFAULT '0',
  `shareCode` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of site_setting
-- ----------------------------
INSERT INTO `site_setting` VALUES ('1', '网站名称', '网站名称', '网站名称', '网站名称', 'http://www.******.com/', 'code', '0', '0', '023-02340234');

-- ----------------------------
-- Table structure for `site_singlepage`
-- ----------------------------
DROP TABLE IF EXISTS `site_singlepage`;
CREATE TABLE `site_singlepage` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(500) DEFAULT NULL,
  `content` longtext,
  `adate` datetime DEFAULT NULL,
  `Content_img` text,
  `typeID` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of site_singlepage
-- ----------------------------
INSERT INTO `site_singlepage` VALUES ('1', '首页公司简介', '      <img src=\"/temp/images/index_03.jpg\" width=\"276\" height=\"95\" alt=\"\" />\r\n               <p>重庆药易商业保理有限公司主要经营：公司尊崇“踏实、拼搏、责任”的企业精神，并以诚信、共赢、开创经营理念，创造良好的企业环境，以全新的管理模式，完善的技术，周到的服务，卓越的品质为\r\n生存根本，我们始终坚持用户至上 用心服务于客户，坚持用自己的服务去打动客户……</p>', '2016-11-08 22:55:17', '/temp/images/index_03.jpg,', '0');
