SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `{QN_PREIX}admin_manager`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}admin_manager`;
CREATE TABLE `{QN_PREIX}admin_manager` (
  `mid` int(20) NOT NULL AUTO_INCREMENT,
  `muname` varchar(50) DEFAULT NULL,
  `mupwd` varchar(200) DEFAULT NULL,
  `mrealname` varchar(50) DEFAULT NULL,
  `memail` varchar(200) DEFAULT NULL,
  `mgroupname` varchar(50) DEFAULT NULL,
  `mcurrentlogindt` datetime DEFAULT NULL,
  `mlastlogindt` datetime DEFAULT NULL,
  `mcurrentloginip` varchar(255) DEFAULT NULL,
  `mlastloginip` varchar(50) DEFAULT NULL,
  `merrortimes` int(11) DEFAULT '0',
  `mislock` int(11) DEFAULT '0',
  PRIMARY KEY (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_admin_manager
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}api_material`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}api_material`;
CREATE TABLE `{QN_PREIX}api_material` (
  `maid` bigint(20) NOT NULL AUTO_INCREMENT,
  `mid` bigint(20) DEFAULT NULL,
  `matype` varchar(20) DEFAULT NULL,
  `matitle` varchar(500) DEFAULT NULL,
  `matxt` text,
  `mamusicurl` varchar(256) DEFAULT NULL,
  `mamusicsize` int(11) DEFAULT NULL,
  `maphotourl` varchar(256) DEFAULT NULL,
  `maphotosize` int(11) DEFAULT NULL,
  `maauthor` varchar(200) DEFAULT NULL,
  `maimageurl` varchar(256) DEFAULT NULL,
  `mazhaiyao` varchar(500) DEFAULT NULL,
  `maimagedesc` text,
  `maimagelink` varchar(1024) DEFAULT NULL,
  `malbsimage` varchar(256) DEFAULT NULL,
  `malbstel` varchar(20) DEFAULT NULL,
  `malbscont` text,
  `malbsaddress` varchar(600) DEFAULT NULL,
  `malbsjingdu` double DEFAULT NULL,
  `malbsweidu` double DEFAULT NULL,
  `malbsdetail` text,
  `malbslink` varchar(1024) DEFAULT NULL,
  `maadddt` datetime DEFAULT NULL,
  `maparentid` bigint(20) DEFAULT '0',
  `maordernum` int(11) DEFAULT NULL,
  PRIMARY KEY (`maid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_api_material
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}backup_database`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}backup_database`;
CREATE TABLE `{QN_PREIX}backup_database` (
  `bdid` int(11) NOT NULL AUTO_INCREMENT,
  `bdUname` varchar(255) DEFAULT NULL,
  `bdFilePath` varchar(255) DEFAULT NULL,
  `bdFileName` varchar(255) DEFAULT NULL,
  `bdFileSize` bigint(20) DEFAULT '0',
  `bdDt` datetime DEFAULT NULL,
  PRIMARY KEY (`bdid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_backup_database
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_fensi`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_fensi`;
CREATE TABLE `{QN_PREIX}base_fensi` (
  `fid` bigint(20) NOT NULL AUTO_INCREMENT,
  `mid` bigint(20) DEFAULT NULL,
  `mpid` bigint(20) DEFAULT NULL,
  `fakeid` varchar(50) DEFAULT NULL,
  `openid` varchar(156) DEFAULT NULL,
  `userheader` varchar(256) DEFAULT NULL,
  `username` varchar(256) DEFAULT NULL,
  `nickname` varchar(256) DEFAULT NULL,
  `remarkname` varchar(1024) DEFAULT NULL,
  `signature` varchar(1024) DEFAULT NULL,
  `country` varchar(200) DEFAULT NULL,
  `province` varchar(200) DEFAULT NULL,
  `city` varchar(200) DEFAULT NULL,
  `sex` varchar(20) DEFAULT NULL,
  `groupid` int(11) DEFAULT NULL,
  `groupname` varchar(200) DEFAULT NULL,
  `qnremarkname` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`fid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_fensi
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_lbsdef`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_lbsdef`;
CREATE TABLE `{QN_PREIX}base_lbsdef` (
  `lid` int(11) NOT NULL AUTO_INCREMENT,
  `mid` bigint(20) DEFAULT NULL,
  `lbslen` int(11) DEFAULT NULL,
  `lbsnocont` varchar(2048) DEFAULT NULL,
  PRIMARY KEY (`lid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_lbsdef
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_material`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_material`;
CREATE TABLE `{QN_PREIX}base_material` (
  `maid` bigint(20) NOT NULL AUTO_INCREMENT,
  `mid` bigint(20) DEFAULT NULL,
  `matype` varchar(20) DEFAULT NULL,
  `matitle` varchar(500) DEFAULT NULL,
  `matxt` text,
  `mamusicurl` varchar(256) DEFAULT NULL,
  `mamusicsize` int(11) DEFAULT NULL,
  `maphotourl` varchar(256) DEFAULT NULL,
  `maphotosize` int(11) DEFAULT NULL,
  `maauthor` varchar(200) DEFAULT NULL,
  `maimageurl` varchar(256) DEFAULT NULL,
  `mazhaiyao` varchar(500) DEFAULT NULL,
  `maimagedesc` text,
  `maimagelink` varchar(1024) DEFAULT NULL,
  `malbsimage` varchar(256) DEFAULT NULL,
  `malbstel` varchar(20) DEFAULT NULL,
  `malbscont` text,
  `malbsaddress` varchar(600) DEFAULT NULL,
  `malbsjingdu` double DEFAULT NULL,
  `malbsweidu` double DEFAULT NULL,
  `malbsdetail` text,
  `malbslink` varchar(1024) DEFAULT NULL,
  `maadddt` datetime DEFAULT NULL,
  `maparentid` bigint(20) DEFAULT '0',
  `maordernum` int(11) DEFAULT NULL,
  PRIMARY KEY (`maid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_material
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_member`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_member`;
CREATE TABLE `{QN_PREIX}base_member` (
  `mid` bigint(20) NOT NULL AUTO_INCREMENT,
  `muname` varchar(50) DEFAULT NULL,
  `mupwd` varchar(200) DEFAULT NULL,
  `meamil` varchar(50) DEFAULT NULL,
  `mqq` varchar(20) DEFAULT NULL,
  `mmobile` varchar(20) DEFAULT NULL,
  `mlevel` int(11) DEFAULT NULL,
  `mroleId` int(11) DEFAULT NULL COMMENT '限权ID',
  `mgroupId` int(11) DEFAULT NULL,
  `mgroupname` varchar(255) DEFAULT NULL,
  `mregdt` datetime DEFAULT NULL,
  `mregip` varchar(100) DEFAULT NULL,
  `mlevelstartdt` datetime DEFAULT NULL,
  `mlevelenddt` datetime DEFAULT NULL,
  `mauditstatus` varchar(255) DEFAULT NULL,
  `mauditinfo` varchar(255) DEFAULT NULL,
  `misemailaudit` int(11) DEFAULT '0' COMMENT '0：否  1：是',
  PRIMARY KEY (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_member
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_membern`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_membern`;
CREATE TABLE `{QN_PREIX}base_membern` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增长ID',
  `Mid` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `mpOrgId` varchar(50) DEFAULT NULL COMMENT '公众号ID',
  `mpOpenId` varchar(50) DEFAULT NULL COMMENT '玩家原始ID',
  `RealName` varchar(100) DEFAULT NULL COMMENT '真实姓名',
  `mpNick` varchar(100) DEFAULT NULL COMMENT '昵称',
  `mpFace` varchar(200) DEFAULT NULL COMMENT '头像',
  `QQ` varchar(20) DEFAULT NULL,
  `TelePhone` varchar(20) DEFAULT NULL COMMENT '固定电话',
  `Sex` varchar(6) DEFAULT NULL COMMENT '性别',
  `Birthday` varchar(50) DEFAULT NULL COMMENT '出生日期',
  `XingZuo` varchar(50) DEFAULT NULL COMMENT '星座',
  `ShengXiao` varchar(50) DEFAULT NULL COMMENT '生肖',
  `MobilePhone` varchar(20) DEFAULT NULL COMMENT '固定电话',
  `CardNum` varchar(50) DEFAULT NULL COMMENT '证件号码',
  `StudentID` varchar(50) DEFAULT NULL COMMENT '学号',
  `Class` varchar(50) DEFAULT NULL COMMENT '班级',
  `MailingAddress` varchar(255) DEFAULT NULL COMMENT '邮寄地址',
  `PostCode` varchar(10) DEFAULT NULL COMMENT '邮编',
  `VIP` varchar(50) DEFAULT NULL COMMENT 'Vip级别',
  `Address` varchar(300) DEFAULT NULL COMMENT '详细地址',
  `Province` varchar(50) DEFAULT NULL COMMENT '省',
  `City` varchar(50) DEFAULT NULL COMMENT '市',
  `Area` varchar(50) DEFAULT NULL COMMENT '区县',
  `GraduatedSchool` varchar(100) DEFAULT NULL COMMENT '毕业学校',
  `Company` varchar(100) DEFAULT NULL COMMENT '公司',
  `Educational` varchar(30) DEFAULT NULL COMMENT '学历',
  `Job` varchar(50) DEFAULT NULL COMMENT '职业',
  `OfficePosition` varchar(50) DEFAULT NULL COMMENT '职位',
  `Revenue` varchar(50) DEFAULT NULL COMMENT '年收入',
  `EmotionalState` varchar(50) DEFAULT NULL COMMENT '情感状态',
  `JyPurposes` varchar(300) DEFAULT NULL COMMENT '交友目的',
  `BloodType` varchar(30) DEFAULT NULL COMMENT '血型',
  `Height` varchar(30) DEFAULT NULL COMMENT '身高',
  `Weight` varchar(30) DEFAULT NULL COMMENT '体重',
  `AlipayAccount` varchar(100) DEFAULT NULL COMMENT '支付宝账号',
  `MSN` varchar(100) DEFAULT NULL COMMENT 'MSN',
  `AliWangwang` varchar(100) DEFAULT NULL COMMENT '阿里旺旺',
  `Email` varchar(100) DEFAULT NULL COMMENT '电子邮箱',
  `MainPage` varchar(255) DEFAULT NULL COMMENT '主页',
  `Introduction` varchar(600) DEFAULT NULL COMMENT '自我介绍',
  `interest` varchar(100) DEFAULT NULL COMMENT '爱好',
  `Nationality` varchar(30) DEFAULT NULL COMMENT '国籍',
  `AddTime` datetime DEFAULT NULL COMMENT '注册日期',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_membern
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_memcpy`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_memcpy`;
CREATE TABLE `{QN_PREIX}base_memcpy` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `mid` bigint(20) DEFAULT NULL,
  `cpy` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_memcpy
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_menu`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_menu`;
CREATE TABLE `{QN_PREIX}base_menu` (
  `menuid` bigint(20) NOT NULL AUTO_INCREMENT,
  `mid` bigint(20) DEFAULT NULL,
  `mpid` bigint(20) DEFAULT NULL,
  `menuName` varchar(30) DEFAULT NULL,
  `menuKey` varchar(100) DEFAULT NULL,
  `menutype` varchar(20) DEFAULT NULL,
  `curcont` text,
  `menuorder` int(11) DEFAULT NULL,
  `replyType` varchar(20) DEFAULT NULL,
  `parentMenuid` bigint(20) DEFAULT NULL,
  `OpFrom` int(11) DEFAULT NULL,
  `ChooseArtId` int(11) DEFAULT NULL,
  PRIMARY KEY (`menuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_menu
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_mppay`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_mppay`;
CREATE TABLE `{QN_PREIX}base_mppay` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增长ID',
  `Mid` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `AppId` varchar(100) DEFAULT NULL,
  `AppSecret` varchar(100) DEFAULT NULL COMMENT '公众平台API权限获取密钥Key',
  `PaySignKey` varchar(100) DEFAULT NULL COMMENT '公众号支付请求中用于加密的密钥Key',
  `PartnerId` varchar(100) DEFAULT NULL COMMENT '财付通商户身份的标识',
  `PartnerKey` varchar(100) DEFAULT NULL COMMENT '财付通商户权限密钥',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_mppay
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_mpset`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_mpset`;
CREATE TABLE `{QN_PREIX}base_mpset` (
  `mpid` int(11) NOT NULL AUTO_INCREMENT,
  `mid` bigint(20) DEFAULT NULL,
  `muname` varchar(50) DEFAULT NULL,
  `mpNick` varchar(100) DEFAULT NULL,
  `mpOrgId` varchar(50) DEFAULT NULL,
  `mpFace` varchar(200) DEFAULT NULL,
  `mpEmail` varchar(100) DEFAULT NULL,
  `mpapi` varchar(50) DEFAULT NULL,
  `mpToken` varchar(100) DEFAULT NULL,
  `mpAppId` varchar(50) DEFAULT NULL,
  `mpAppSecret` varchar(50) DEFAULT NULL,
  `mpuser` varchar(100) DEFAULT NULL,
  `mppwd` varchar(100) DEFAULT NULL,
  `mpProv` varchar(100) DEFAULT NULL,
  `mpCity` varchar(100) DEFAULT NULL,
  `mpArea` varchar(100) DEFAULT NULL,
  `mpfensiNum` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`mpid`),
  UNIQUE KEY `UniqueAPI` (`mpapi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_mpset
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_msglog`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_msglog`;
CREATE TABLE `{QN_PREIX}base_msglog` (
  `lid` bigint(20) NOT NULL AUTO_INCREMENT,
  `mid` bigint(20) DEFAULT NULL,
  `mpid` bigint(20) DEFAULT NULL,
  `fensiid` bigint(20) DEFAULT NULL,
  `fensiName` varchar(256) DEFAULT NULL,
  `fensiheader` varchar(256) DEFAULT NULL,
  `sendmsg` text,
  `adddt` datetime DEFAULT NULL,
  PRIMARY KEY (`lid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_msglog
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_reply`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_reply`;
CREATE TABLE `{QN_PREIX}base_reply` (
  `rid` bigint(20) NOT NULL AUTO_INCREMENT,
  `mid` bigint(20) DEFAULT NULL,
  `mpid` int(11) DEFAULT NULL,
  `mpOrgId` varchar(50) DEFAULT NULL,
  `mpapi` varchar(50) DEFAULT NULL,
  `rtype` varchar(50) DEFAULT NULL,
  `eventkey` varchar(100) DEFAULT NULL,
  `matype` varchar(50) DEFAULT NULL,
  `materialtable` varchar(50) DEFAULT NULL,
  `materialId` bigint(20) DEFAULT NULL,
  `rordernum` int(11) DEFAULT NULL,
  `radddt` datetime DEFAULT NULL,
  `rmathtype` int(11) DEFAULT NULL,
  `fullkey` text,
  `curcont` text,
  PRIMARY KEY (`rid`),
  FULLTEXT KEY `fulltext_fullkey` (`fullkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_reply
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_reqlog`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_reqlog`;
CREATE TABLE `{QN_PREIX}base_reqlog` (
  `rid` bigint(20) NOT NULL AUTO_INCREMENT,
  `mpOrgId` varchar(100) DEFAULT NULL,
  `msgscribe` varchar(100) DEFAULT NULL,
  `msgtype` varchar(100) DEFAULT NULL,
  `orgmsg` text,
  `adddt` date DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `totalfen` bigint(20) DEFAULT NULL,
  `responseflag` int(11) DEFAULT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_reqlog
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}base_usergroup`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}base_usergroup`;
CREATE TABLE `{QN_PREIX}base_usergroup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` bigint(20) DEFAULT NULL,
  `mpid` bigint(20) DEFAULT NULL,
  `groupname` varchar(100) DEFAULT NULL,
  `groupdesc` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_base_usergroup
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}config_annex`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_annex`;
CREATE TABLE `{QN_PREIX}config_annex` (
  `caid` int(10) NOT NULL AUTO_INCREMENT,
  `caMaxSize` bigint(20) DEFAULT NULL,
  `caImageType` varchar(255) DEFAULT NULL,
  `caMusicType` varchar(255) DEFAULT '0',
  `caStorageSide` int(10) DEFAULT '0',
  `caEnRemMinFileSize` int(10) DEFAULT '0',
  PRIMARY KEY (`caid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_annex
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}config_backup_database`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_backup_database`;
CREATE TABLE `{QN_PREIX}config_backup_database` (
  `cbdid` int(11) NOT NULL AUTO_INCREMENT,
  `cbdFileName` varchar(255) DEFAULT NULL,
  `cbdBinPath` varchar(255) DEFAULT NULL,
  `cbdFilePath` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cbdid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_backup_database
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}config_base_upload`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_base_upload`;
CREATE TABLE `{QN_PREIX}config_base_upload` (
  `cbuid` int(10) NOT NULL AUTO_INCREMENT,
  `cbuAnnexPosition` varchar(255) DEFAULT NULL,
  `cbuAnnexUrl` varchar(255) DEFAULT NULL,
  `cbuThumbnailQuality` int(10) DEFAULT '0',
  PRIMARY KEY (`cbuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_base_upload
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}config_cloud_upload`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_cloud_upload`;
CREATE TABLE `{QN_PREIX}config_cloud_upload` (
  `ccuid` int(11) NOT NULL AUTO_INCREMENT,
  `ccuAccessKeyId` varchar(255) DEFAULT NULL,
  `ccuAccessKeySecret` varchar(255) DEFAULT NULL,
  `ccuBucket` varchar(255) DEFAULT NULL,
  `ccuHost` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ccuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_cloud_upload
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}config_ftp_upload`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_ftp_upload`;
CREATE TABLE `{QN_PREIX}config_ftp_upload` (
  `cfuid` int(10) NOT NULL AUTO_INCREMENT,
  `cfuIsSSLEnabled` int(10) DEFAULT '0',
  `cfuServiceAddress` varchar(100) DEFAULT NULL,
  `cfuServicePort` int(10) DEFAULT '0',
  `cfuUserName` varchar(255) DEFAULT NULL,
  `cfuPwd` varchar(255) DEFAULT NULL,
  `cfuIsPasvEnabled` int(10) DEFAULT '0',
  `cfuAnnexDirectory` varchar(255) DEFAULT NULL,
  `cfuRemoteUrl` varchar(255) DEFAULT NULL,
  `cfuTimeout` int(10) DEFAULT '0',
  PRIMARY KEY (`cfuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_ftp_upload
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}config_interface_bottom`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_interface_bottom`;
CREATE TABLE `{QN_PREIX}config_interface_bottom` (
  `cibid` int(10) NOT NULL AUTO_INCREMENT,
  `cibDetail` text,
  PRIMARY KEY (`cibid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_interface_bottom
-- ----------------------------
INSERT INTO `{QN_PREIX}config_interface_bottom` VALUES ('1', '<div id=\"dl_qh\">\n  <div class=\"zpmenu\">\n	<dl id=\"slider2\">\n		<dt class=\"open\"><img src=\"../../Content/images/login/dl_tubiao02.png\" /></dt>\n		<dd>\n			<div class=\"zpinfor\">\n				<h1><a target=\"_blank\" href=\"#\">微趣能微信第三方接口管理系统</a></h1>\n				<span>已有数万商家入驻微趣能，微信营销 如此简单!</span>\n				<h2>功能介绍</h2>\n				<ul>\n					<li><a target=\"_blank\" href=\"#\">微官网</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微会员</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微推送</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微服务</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微留言</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微相册</a></li>\n                    <li><a target=\"_blank\" href=\"#\">自定义菜单</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微调研</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微统计</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微房产</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微汽车</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微喜帖</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微医疗</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微酒店</a></li>\n                    <li><a target=\"_blank\" href=\"#\">LBS回复</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微餐饮</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微商城</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微酒店</a></li>\n                    <li><a target=\"_blank\" href=\"#\">微教育</a></li>\n				</ul>\n			</div>\n		</dd>\n		<dt><img src=\"../../Content/images/login/dl_tubiao01.png\" /></dt>\n		<dd>\n			<div class=\"zpinfor\">\n				<h1><a target=\"_blank\" href=\"#\">我们能为您做什么？</a></h1>\n				<span>提供 超强小黄鸡陪聊+40多款便民功能，微会员（SCRM），微活动 \n微团购+刮刮乐+一战到底+微信喜帖+在线订餐+自定义订单+3G相册+优惠券+幸运大转盘的会员再营销，超炫微信3G网站，\n等您需要的各种微信营销模块。</span>\n			</div>\n		</dd>\n		<dt><img src=\"../../Content/images/login/dl_tubiao03.png\" /></dt>\n		<dd>\n			<div class=\"zpinfor\">\n				<h1><a target=\"_blank\" href=\"#\">联系我们</a></h1>\n				<span>微趣能官方群：①群-76287629(开放中)</span>\n				<h2>撬动百万财富</h2>\n				<ul>\n					<li><a target=\"_blank\" href=\"#\">徐经理：TEL：0539-2052275英经理：TEL：0539-2031772</a></li>\n					<li><a target=\"_blank\" href=\"#\">刘经理：TEL：0539-8168737王经理：TEL：0539-8163367</a></li>\n					<li><a target=\"_blank\" href=\"#\">郭经理：TEL：0539-2031702曲经理：TEL：0539-2031357</a></li>\n				</ul>\n			</div>\n		</dd>\n	</dl>\n</div></div>\n<script type=\"text/javascript\" src=\"../../Scripts/accordion.js\"></script>\n<script type=\"text/javascript\">\nvar slider2=new accordion.slider(\"slider2\");\nslider2.init(\"slider2\",0,\"open\");\n</script>\n<div class=\"shipin\">\n	<div class=\"shipin_m\">\n    	<h1>了解微趣能</h1>\n        <div class=\"buttons\"><a href=\"#\">点击</a></div>\n        <span>To understand the function of Weiquneng.</span>\n    </div>\n</div> \n\n\n    </div>\n</div>');

-- ----------------------------
-- Table structure for `{QN_PREIX}config_mailbox`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_mailbox`;
CREATE TABLE `{QN_PREIX}config_mailbox` (
  `cmid` int(10) NOT NULL AUTO_INCREMENT,
  `cmServer` varchar(255) DEFAULT NULL,
  `cmPort` int(10) DEFAULT '0',
  `cmFromAddress` varchar(255) DEFAULT NULL,
  `cmIsAuthLogin` int(10) DEFAULT '0',
  `cmUserName` varchar(255) DEFAULT NULL,
  `cmPassword` varchar(255) DEFAULT NULL,
  `cmTest` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cmid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_mailbox
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}config_member`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_member`;
CREATE TABLE `{QN_PREIX}config_member` (
  `cmeid` int(10) NOT NULL AUTO_INCREMENT,
  `cmeIsNewReg` int(10) DEFAULT '0',
  `cmeIsSelectMod` int(10) DEFAULT '0',
  `cmeGroupId` int(11) DEFAULT '0',
  `cmeGroupName` varchar(255) DEFAULT NULL,
  `cmeIsEmailVerify` int(10) DEFAULT '0',
  `cmeIsAudit` int(10) DEFAULT '0',
  `cmeAgreement` text,
  `cmeAuthenticateTitle` text,
  `cmeAuthenticateContent` text,
  `cmeAuditSuccessTitle` text,
  `cmeAuditSuccessContent` text,
  `cmeAuditFailTitle` text,
  `cmeAuditFailContent` text,
  `cmeMailGetPwdTitle` text,
  `cmeMailGetPwdContent` text,
  PRIMARY KEY (`cmeid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_member
-- ----------------------------
INSERT INTO `{QN_PREIX}config_member` VALUES ('1', '1', '1', '1', '普通会员', '0', '0', '会员注册协议.', '邮件认证', '亲爱的{会员用户名},<a href=\"{邮箱认证地址}\" target=\"_blank\">点击此处</a>完成账号注册.', '您的账号审核通过了', '恭喜您,您在趣能微信注册的账号已经通过审核了.', '您的账号审核未通过', '注册信息不正确,不能通过审核,请重新填写.', '找回密码', '亲爱的{会员用户名},<a href=\"{重置密码地址}\" target=\"_blank\">点击此处</a>进行密码重置.');

-- ----------------------------
-- Table structure for `{QN_PREIX}config_navigate`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_navigate`;
CREATE TABLE `{QN_PREIX}config_navigate` (
  `cnid` bigint(20) NOT NULL AUTO_INCREMENT,
  `cnOrder` int(20) DEFAULT '0',
  `cnName` varchar(100) DEFAULT NULL,
  `cnLink` varchar(255) DEFAULT NULL,
  `cnIsEnabled` int(10) DEFAULT '0',
  PRIMARY KEY (`cnid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_navigate
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}config_security`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_security`;
CREATE TABLE `{QN_PREIX}config_security` (
  `csid` int(10) NOT NULL AUTO_INCREMENT,
  `csIsLogEnabled` int(10) DEFAULT '0',
  `csIsErrorLogEnabled` int(10) DEFAULT '0',
  `csLogWarnSize` bigint(20) DEFAULT '0',
  `csMaxFailCount` int(10) DEFAULT '0',
  `csRefreshInterval` int(10) DEFAULT '0',
  PRIMARY KEY (`csid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_security
-- ----------------------------
INSERT INTO `{QN_PREIX}config_security` VALUES ('1', '1', '1', '1024', '6', '10');

-- ----------------------------
-- Table structure for `{QN_PREIX}config_shortcut`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_shortcut`;
CREATE TABLE `{QN_PREIX}config_shortcut` (
  `csid` bigint(20) NOT NULL AUTO_INCREMENT,
  `csOrder` int(255) DEFAULT '0',
  `csName` varchar(255) DEFAULT NULL,
  `csLink` varchar(255) DEFAULT NULL,
  `csIsEnabled` int(255) DEFAULT '0',
  `csImgUrl` varchar(500) DEFAULT NULL,
  `csColor` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`csid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_shortcut
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}config_site`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}config_site`;
CREATE TABLE `{QN_PREIX}config_site` (
  `csid` int(10) NOT NULL AUTO_INCREMENT,
  `csName` varchar(100) DEFAULT NULL,
  `csDomainName` varchar(255) DEFAULT NULL,
  `csManagerEamil` varchar(100) DEFAULT NULL,
  `csRecordCode` text,
  `csCopyright` text,
  `csAuthorize` int(10) DEFAULT NULL,
  `csThirdStatisticCode` text,
  `csTitle` varchar(255) DEFAULT NULL,
  `csKey` varchar(255) DEFAULT NULL,
  `csDescription` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`csid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_config_site
-- ----------------------------
INSERT INTO `{QN_PREIX}config_site` VALUES ('1', '趣能微信', 'www.weiqn.com', 'admin@weiqn.com', '鲁ICP备12011474号', '此页面由趣能微信生成', '1', null, null, null, null);

-- ----------------------------
-- Table structure for `{QN_PREIX}data_log`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}data_log`;
CREATE TABLE `{QN_PREIX}data_log` (
  `dlid` bigint(20) NOT NULL AUTO_INCREMENT,
  `dlUname` varchar(255) DEFAULT NULL,
  `dlDt` datetime DEFAULT NULL,
  `dlIp` varchar(255) DEFAULT NULL,
  `dlStatus` varchar(255) DEFAULT NULL,
  `dlDesc` text,
  PRIMARY KEY (`dlid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_data_log
-- ----------------------------

-- ----------------------------
-- Table structure for `{QN_PREIX}group_menu`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}group_menu`;
CREATE TABLE `{QN_PREIX}group_menu` (
  `nid` int(11) NOT NULL AUTO_INCREMENT,
  `nmenuname` varchar(100) DEFAULT NULL,
  `nmenulink` varchar(255) DEFAULT NULL,
  `nmoudle` int(255) DEFAULT NULL,
  `nmoudlename` varchar(255) DEFAULT NULL,
  `nmoudledesc` varchar(255) DEFAULT NULL,
  `nmoudleimg` varchar(255) DEFAULT NULL,
  `nmnamespace` varchar(255) DEFAULT NULL,
  `nmfilepath` varchar(255) DEFAULT NULL,
  `nmauthor` varchar(255) DEFAULT NULL,
  `nmcompy` varchar(255) DEFAULT NULL,
  `nmcompyweb` varchar(255) DEFAULT NULL,
  `nmversion` varchar(255) DEFAULT NULL,
  `nordernum` int(11) DEFAULT NULL,
  `nparentid` int(11) DEFAULT NULL,
  PRIMARY KEY (`nid`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_group_menu
-- ----------------------------
INSERT INTO `{QN_PREIX}group_menu` VALUES ('1', '我的账号', '#', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '1', '0');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('2', '系统设置', '#', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '2', '0');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('3', '内容素材库', '#', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '3', '0');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('4', '菜单管理', '#', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '4', '0');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('5', '应用中心', '#', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '5', '0');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('6', '用户管理', '#', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '6', '0');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('10', '账号信息', '/Member/', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '1', '1');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('11', '统计分析', '/Member/ReqReport', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '2', '1');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('12', '接口配置', '/Member/WxSetAuto', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '3', '1');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('13', '个人资料', '/Member/MemUser', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '4', '1');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('14', '密码修改', '/Member/EditPwd', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '5', '1');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('15', '版权设置', '/Member/CopyRight', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '6', '1');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('20', '关键字应答', '/Member/KeyReply', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '1', '2');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('21', '关注欢迎语', '/Member/AttenReply', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '2', '2');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('22', '无法识别回复', '/Member/NoReply', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '3', '2');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('30', '图文消息', '/Member/Matera', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '1', '3');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('31', '文本消息', '/Member/TxtMaterial', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '2', '3');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('32', '语音消息', '/Member/MusicsMaterial', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '3', '3');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('33', 'lbs回复', '/Member/LbssMaterial', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '4', '3');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('40', '自定义菜单', '/Member/MeTree', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '1', '4');
INSERT INTO `{QN_PREIX}group_menu` VALUES ('60', '概况', '/Member/Survey', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '1', '6');

-- ----------------------------
-- Table structure for `{QN_PREIX}group_role`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}group_role`;
CREATE TABLE `{QN_PREIX}group_role` (
  `gid` int(11) NOT NULL AUTO_INCREMENT,
  `gname` varchar(255) DEFAULT NULL,
  `gdesc` varchar(8888) DEFAULT NULL,
  `gsysflag` int(255) DEFAULT NULL,
  `gsystxt` varchar(255) DEFAULT NULL,
  `gtxtnum` bigint(20) DEFAULT NULL,
  `gnewsnum` bigint(20) DEFAULT NULL,
  `gaudionum` bigint(20) DEFAULT NULL,
  `glbsnum` bigint(20) DEFAULT NULL,
  `gmonthtotalnum` bigint(20) DEFAULT NULL,
  `gstarteffectdt` datetime DEFAULT NULL,
  `gdays` int(10) DEFAULT '0',
  `gvaliddateeaho` varchar(2048) DEFAULT NULL,
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_group_role
-- ----------------------------
INSERT INTO `{QN_PREIX}group_role` VALUES ('1', '普通会员', '普通未付费', '1', '内置', '100', '100', '100', '100', '10000', '2013-11-25 10:13:50', '10000', '已到期.');

-- ----------------------------
-- Table structure for `{QN_PREIX}group_roled`
-- ----------------------------
DROP TABLE IF EXISTS `{QN_PREIX}group_roled`;
CREATE TABLE `{QN_PREIX}group_roled` (
  `rid` bigint(20) NOT NULL AUTO_INCREMENT,
  `gid` int(11) DEFAULT NULL,
  `nid` int(11) DEFAULT NULL,
  `nname` varchar(255) DEFAULT NULL,
  `nlink` varchar(255) DEFAULT NULL,
  `nordernum` int(11) DEFAULT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB AUTO_INCREMENT=933 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qn_group_roled
-- ----------------------------
INSERT INTO `{QN_PREIX}group_roled` VALUES ('1', '1', '10', '账号信息', '/Member/', '1');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('2', '1', '11', '统计分析', '/Member/ReqReport', '2');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('3', '1', '12', '接口配置', '/Member/WxSetAuto', '3');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('4', '1', '13', '个人资料', '/Member/MemUser', '4');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('5', '1', '14', '密码修改', '/Member/EditPwd', '5');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('6', '1', '15', '版权设置', '/Member/CopyRight', '6');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('7', '1', '20', '关键字应答', '/Member/KeyReply', '1');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('8', '1', '21', '关注欢迎语', '/Member/AttenReply', '2');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('9', '1', '22', '无法识别回复', '/Member/NoReply', '3');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('10', '1', '30', '图文消息', '/Member/Matera', '1');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('11', '1', '31', '文本消息', '/Member/TxtMaterial', '2');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('12', '1', '32', '语音消息', '/Member/MusicsMaterial', '3');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('13', '1', '33', 'lbs回复', '/Member/LbssMaterial', '4');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('14', '1', '40', '自定义菜单', '/Member/MyMenu', '1');
INSERT INTO `{QN_PREIX}group_roled` VALUES ('15', '1', '60', '概况', '/Member/Survey', '1');












