-- Wxplat1.02[20190131]
-- ------------------------------------------------------
-- Server version	5.7.18-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `eom_config`
--

DROP TABLE IF EXISTS `eom_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eom_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sy_id` int(11) NOT NULL,
  `host_id` int(11) NOT NULL,
  `gp_id` int(11) NOT NULL,
  `var_type` int(11) NOT NULL COMMENT '参数类型 :0文本框，1,下拉列表框，2日期选择框，3单选按钮，4复选按钮，5文件',
  `var_code` varchar(16) NOT NULL,
  `var_name` varchar(16) NOT NULL,
  `var_value` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_config_host` (`host_id`,`var_code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eom_config`
--

LOCK TABLES `eom_config` WRITE;
/*!40000 ALTER TABLE `eom_config` DISABLE KEYS */;
INSERT INTO `eom_config` VALUES (1,1,0,1,0,'pagenum','每页显示的记录数','10');
/*!40000 ALTER TABLE `eom_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eom_config_gp`
--

DROP TABLE IF EXISTS `eom_config_gp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eom_config_gp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sy_id` int(11) NOT NULL,
  `gp_name` varchar(16) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eom_config_gp`
--

LOCK TABLES `eom_config_gp` WRITE;
/*!40000 ALTER TABLE `eom_config_gp` DISABLE KEYS */;
INSERT INTO `eom_config_gp` VALUES (1,1,'基本参数');
/*!40000 ALTER TABLE `eom_config_gp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eom_host`
--

DROP TABLE IF EXISTS `eom_host`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eom_host` (
  `host_id` int(11) NOT NULL AUTO_INCREMENT,
  `host_code` varchar(16) NOT NULL,
  `access_code` varchar(50) NOT NULL,
  `host_name` varchar(16) NOT NULL,
  `open_time` int(11) DEFAULT NULL,
  `over_time` int(11) DEFAULT NULL,
  `is_enable` tinyint(1) DEFAULT NULL,
  `licences_sn` varchar(64) DEFAULT NULL,
  `first_changed` int(11) DEFAULT NULL,
  `last_changed` int(11) DEFAULT NULL,
  `sort_no` smallint(6) DEFAULT NULL,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`host_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eom_host`
--

LOCK TABLES `eom_host` WRITE;
/*!40000 ALTER TABLE `eom_host` DISABLE KEYS */;
/*!40000 ALTER TABLE `eom_host` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eom_pm`
--

DROP TABLE IF EXISTS `eom_pm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eom_pm` (
  `pm_id` int(11) NOT NULL AUTO_INCREMENT,
  `pm_code` varchar(64) NOT NULL,
  `pm_name` varchar(64) NOT NULL,
  `pm_alias` varchar(64) DEFAULT NULL,
  `mb_name` varchar(20) DEFAULT NULL,
  `action` varchar(16) DEFAULT NULL,
  `class_no` smallint(6) DEFAULT '1',
  `sy_id` int(11) NOT NULL,
  `gp_id` int(11) NOT NULL,
  `p_id` int(11) NOT NULL,
  `p_code` varchar(64) DEFAULT NULL,
  `pm_cmd` varchar(255) DEFAULT NULL,
  `closed` char(1) NOT NULL,
  `is_menu` char(1) DEFAULT '1',
  `is_show` char(1) DEFAULT '1',
  `is_mobile` char(1) DEFAULT '0',
  `sort_no` smallint(6) DEFAULT NULL,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pm_id`),
  UNIQUE KEY `eom_pm_code` (`pm_code`)
) ENGINE=InnoDB AUTO_INCREMENT=291 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eom_pm`
--

LOCK TABLES `eom_pm` WRITE;
/*!40000 ALTER TABLE `eom_pm` DISABLE KEYS */;
INSERT INTO `eom_pm` VALUES (1,'f1fbcd978068587dc3','系统管理',NULL,NULL,'system',1,1,0,0,'','System','0','1','0','0',1,NULL,NULL,NULL),(2,'bd69e1042cf1fe36ff','系统参数设置',NULL,NULL,'systemset',2,1,0,1,'f1fbcd978068587dc3','System/system','0','1','0','0',1,NULL,NULL,NULL),(3,'65e4e9112d4edc6e22','查看',NULL,NULL,'see',3,1,0,2,'bd69e1042cf1fe36ff','System/syssee','0','0','0','0',1,NULL,NULL,NULL),(4,'11d33415509700fb72','修改',NULL,NULL,'mod',3,1,0,2,'bd69e1042cf1fe36ff','System/systemsave','0','0','0','0',2,NULL,NULL,NULL),(5,'74da6ee0bcfb070901','角色管理',NULL,NULL,'role',2,1,0,1,'f1fbcd978068587dc3','System/role','0','1','0','0',2,NULL,NULL,NULL),(6,'3187fe6ba564b214ad','查看',NULL,NULL,'see',3,1,0,5,'74da6ee0bcfb070901','System/rolesee','0','0','0','0',1,NULL,NULL,NULL),(7,'a1413a3bedb4eaeb4a','新增',NULL,NULL,'add',3,1,0,5,'74da6ee0bcfb070901','System/roleadd','1','0','0','0',2,NULL,NULL,NULL),(8,'7ea0711cb7f6293584','修改',NULL,NULL,'mod',3,1,0,5,'74da6ee0bcfb070901','System/roleupdate','0','0','0','0',3,NULL,NULL,NULL),(9,'0ab07f35e9ac4c4428','删除',NULL,NULL,'del',3,1,0,5,'74da6ee0bcfb070901','System/roledele','0','0','0','0',4,NULL,NULL,NULL),(10,'3f2155fed1c6007a27','操作用户管理',NULL,NULL,'user',2,1,0,1,'f1fbcd978068587dc3','System/user','0','1','0','0',3,NULL,NULL,NULL),(11,'a5cb902cbbd2720f04','查看',NULL,NULL,'see',3,1,0,10,'3f2155fed1c6007a27','System/seeuser','0','0','0','0',1,NULL,NULL,NULL),(12,'33c63145fa8820350b','新增',NULL,NULL,'add',3,1,0,10,'3f2155fed1c6007a27','System/useradd','0','0','0','0',2,NULL,NULL,NULL),(13,'36984db2b2e282d2f0','修改',NULL,NULL,'mod',3,1,0,10,'3f2155fed1c6007a27','System/userupdate','0','0','0','0',3,NULL,NULL,NULL),(14,'a612f20e9c710b3322','删除',NULL,NULL,'del',3,1,0,10,'3f2155fed1c6007a27','System/userdele','0','0','0','0',4,NULL,NULL,NULL),(176,'b4a758a216431b9908','角色',NULL,NULL,'role',3,1,0,10,'3f2155fed1c6007a27','System/userrole','0','0','0','0',5,NULL,NULL,NULL),(177,'718b2f3d6ed475c5d8','权限',NULL,NULL,'rights',3,1,0,5,'74da6ee0bcfb070901','System/rolerights','0','0','0','0',4,NULL,NULL,NULL),(178,'aa43d74357eb1b7e53','微信管理',NULL,NULL,'wechat',1,1,0,0,'','Wechat/','0','1','0','0',6,NULL,NULL,NULL),(179,'ca7efd6b34d0ec63a5','公众号配置',NULL,NULL,'wechats',2,1,0,178,'aa43d74357eb1b7e53','Wechat/account','0','1','0','0',1,NULL,NULL,NULL),(180,'becb4b6b563885090f','查看',NULL,NULL,'see',3,1,0,179,'ca7efd6b34d0ec63a5','Wechat/accountsee','0','0','0','0',1,NULL,NULL,NULL),(181,'2c7321515804fc5b24','新增',NULL,NULL,'add',3,1,0,179,'ca7efd6b34d0ec63a5','Wechat/accountadd','0','0','0','0',2,NULL,NULL,NULL),(182,'e41490de4ba0f8cda2','修改',NULL,NULL,'mod',3,1,0,179,'ca7efd6b34d0ec63a5','Wechat/accountedit','0','0','0','0',3,NULL,NULL,NULL),(183,'e4142b252b5b89a2a9','删除',NULL,NULL,'del',3,1,0,179,'ca7efd6b34d0ec63a5','Wechat/accountdele','0','0','0','0',4,NULL,NULL,NULL),(184,'242b835f94ba608e38','自定义菜单',NULL,NULL,'costom',2,1,0,178,'aa43d74357eb1b7e53','Wechat/costom','0','1','0','0',2,NULL,NULL,NULL),(185,'a3e8ba97644acf1169','查看',NULL,NULL,'see',3,1,0,184,'242b835f94ba608e38','Wechat/costomsee','0','0','0','0',1,NULL,NULL,NULL),(186,'f765189a51c9aca57d','修改',NULL,NULL,'mod',3,1,0,184,'242b835f94ba608e38','Wechat/costomedit','0','0','0','0',2,NULL,NULL,NULL),(190,'a949d3083e586a98dd','消息回复',NULL,NULL,'keyword',2,1,0,178,'aa43d74357eb1b7e53','Wechat/keyword','0','1','0','0',4,NULL,NULL,NULL),(191,'51dcc138931d7c5032','查看',NULL,NULL,'see',3,1,0,190,'a949d3083e586a98dd','Wechat/keywordsee','0','0','0','0',1,NULL,NULL,NULL),(192,'db46451a348ed0e4ed','新增',NULL,NULL,'add',3,1,0,190,'a949d3083e586a98dd','Wechat/keywordadd','0','0','0','0',2,NULL,NULL,NULL),(193,'57109f10f1ba0e3665','修改',NULL,NULL,'mod',3,1,0,190,'a949d3083e586a98dd','Wechat/keywordedit','0','0','0','0',3,NULL,NULL,NULL),(194,'453d9ae3413064737d','删除',NULL,NULL,'del',3,1,0,190,'a949d3083e586a98dd','Wechat/keyworddele','0','0','0','0',4,NULL,NULL,NULL),(195,'a80262880f41c8e6d1','模版消息',NULL,NULL,'template',2,1,0,178,'aa43d74357eb1b7e53','Wechat/template','0','1','0','0',5,NULL,NULL,NULL),(199,'59dc9b128714587fca','删除',NULL,NULL,'del',3,1,0,195,'a80262880f41c8e6d1','Wechat/templatedele','0','0','0','0',4,NULL,NULL,NULL),(200,'4be57ad8fa67b582fd','群发消息',NULL,NULL,'mass',2,1,0,178,'aa43d74357eb1b7e53','Wechat/mass','0','1','0','0',6,NULL,NULL,NULL),(201,'6222f3891382cd81e6','查看',NULL,NULL,'see',3,1,0,200,'4be57ad8fa67b582fd','Wechat/masssee','0','0','0','0',1,NULL,NULL,NULL),(202,'67596a05da79d25edc','新增',NULL,NULL,'add',3,1,0,200,'4be57ad8fa67b582fd','Wechat/massadd','0','0','0','0',2,NULL,NULL,NULL),(203,'77c97ecc0d0e12b77d','修改',NULL,NULL,'mod',3,1,0,200,'4be57ad8fa67b582fd','Wechat/massedit','0','0','0','0',3,NULL,NULL,NULL),(204,'f8f7471830588be8a9','删除',NULL,NULL,'del',3,1,0,200,'4be57ad8fa67b582fd','Wechat/massdele','0','0','0','0',4,NULL,NULL,NULL),(205,'0889556b6843cc2943','发送',NULL,NULL,'send',3,1,0,200,'4be57ad8fa67b582fd','Wechat/masssend','0','0','0','0',5,NULL,NULL,NULL),(206,'8cdd1b5c88115113f3','素材管理',NULL,NULL,'material',2,1,0,178,'aa43d74357eb1b7e53','Wechat/material','0','1','0','0',7,NULL,NULL,NULL),(207,'a3953d0f9b8b9b40b9','查看',NULL,NULL,'see',3,1,0,206,'8cdd1b5c88115113f3','Wechat/materialsee','0','0','0','0',1,NULL,NULL,NULL),(209,'a7fb38cf532c738eb5','修改',NULL,NULL,'mod',3,1,0,206,'8cdd1b5c88115113f3','Wechat/materialedit','0','0','0','0',3,NULL,NULL,NULL),(210,'d03acc1b4376ce2485','删除',NULL,NULL,'del',3,1,0,206,'8cdd1b5c88115113f3','Wechat/materialdel','0','0','0','0',4,NULL,NULL,NULL),(211,'529782abb13566e104','同步',NULL,NULL,'sync',3,1,0,206,'8cdd1b5c88115113f3','Wechat/materialsync','0','0','0','0',5,NULL,NULL,NULL),(212,'ad05f4ac9315f58ed8','粉丝管理',NULL,NULL,'fans',2,1,0,178,'aa43d74357eb1b7e53','Wechat/fans','0','1','5','0',8,NULL,NULL,NULL),(213,'8a9a76d0f1091c887d','查看',NULL,NULL,'see',3,1,0,212,'ad05f4ac9315f58ed8','Wechat/fanssee','0','0','5','0',1,NULL,NULL,NULL),(215,'61adf266a13f9e1edd','修改',NULL,NULL,'mod',3,1,0,212,'ad05f4ac9315f58ed8','Wechat/fansedit','0','0','5','0',3,NULL,NULL,NULL),(279,'00b8fa40ba08e1de62','素材选择',NULL,NULL,'chose',3,1,0,206,'8cdd1b5c88115113f3','Wechat/materialchose','0','1','1','0',NULL,NULL,NULL,NULL),(280,'eee6ef048b82606eed','发送消息',NULL,NULL,'send',3,1,0,212,'ad05f4ac9315f58ed8','Wechat/fanssend','0','0','0','0',4,NULL,NULL,NULL),(281,'5a34e358773fb6f62a','模版消息同步',NULL,NULL,'sync',3,1,0,195,'a80262880f41c8e6d1','Wechat/templatesync','0','0','0','0',1,NULL,NULL,NULL),(282,'97ab805e38f55ea25a','粉丝导出',NULL,NULL,'export',3,1,0,212,'ad05f4ac9315f58ed8','Wechat/fansExport','0','0','0','0',2,NULL,NULL,NULL),(283,'53648cd8b53184299a','粉丝同步',NULL,NULL,'sync',13,1,0,212,'ad05f4ac9315f58ed8','Wechat/fanssync','0','0','0','0',4,NULL,NULL,NULL),(284,'e829ebab46c6d838e1 ','查看',NULL,NULL,'see',3,1,0,195,'a80262880f41c8e6d1','Wechat/tempsee','0','1','0','0',3,NULL,NULL,NULL),(285,'8a27de9ac5d230cf73  ','添加',NULL,NULL,'add',1,1,0,195,'a80262880f41c8e6d1','Wechat/tempadd','0','1','1','0',2,NULL,NULL,NULL),(286,'d1647f41414cfe5671','短信管理',NULL,NULL,'sms',1,1,0,0,NULL,'Sms','0','1','1','0',NULL,NULL,NULL,NULL),(287,'9dcfe308a8b7fe7b08','短信配置',NULL,NULL,'index',2,1,0,286,'d1647f41414cfe5671','Sms/smsindex','0','1','1','0',NULL,NULL,NULL,NULL),(288,'e3c7dd71da474140c2','添加',NULL,NULL,'add',3,1,0,287,'9dcfe308a8b7fe7b08','Sms/smsadd','0','1','5','0',NULL,NULL,NULL,NULL),(289,'9c60a39fd5d76373e7','修改',NULL,NULL,'mod',3,1,0,287,'9dcfe308a8b7fe7b08','Sms/smsmod','0','0','0','0',NULL,NULL,NULL,NULL),(290,'fc327ae90043fc82fa','删除',NULL,NULL,'del',3,1,0,287,'9dcfe308a8b7fe7b08','Sms/smsdel','','1','1','0',NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `eom_pm` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eom_role`
--

DROP TABLE IF EXISTS `eom_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eom_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL,
  `role_code` varchar(16) NOT NULL,
  `role_name` varchar(16) NOT NULL,
  `sort_no` smallint(6) DEFAULT NULL,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eom_role`
--

LOCK TABLES `eom_role` WRITE;
/*!40000 ALTER TABLE `eom_role` DISABLE KEYS */;
/*!40000 ALTER TABLE `eom_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eom_role_pm`
--

DROP TABLE IF EXISTS `eom_role_pm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eom_role_pm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `pm_id` int(11) NOT NULL,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_eom_role_pm_id` (`role_id`,`pm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eom_role_pm`
--

LOCK TABLES `eom_role_pm` WRITE;
/*!40000 ALTER TABLE `eom_role_pm` DISABLE KEYS */;
/*!40000 ALTER TABLE `eom_role_pm` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eom_use_rec`
--

DROP TABLE IF EXISTS `eom_use_rec`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eom_use_rec` (
  `ur_id` int(11) NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL,
  `rec_type` char(1) DEFAULT NULL COMMENT '日志类型:1登录,2插入数据,3修改数据,4获取数据,5删除数据',
  `use_time` int(11) DEFAULT NULL,
  `use_object` varchar(64) DEFAULT NULL COMMENT '操作对象: 表名、操作方法、菜单名称 等',
  `use_str` varchar(1000) DEFAULT NULL COMMENT '具体操作内容说明',
  `user_id` varchar(16) DEFAULT NULL COMMENT '操作用户的user_id',
  `user_name` varchar(16) DEFAULT NULL COMMENT '操作用户的user_name',
  `cmd_ip` varchar(64) DEFAULT NULL COMMENT '当前访问者的ip地址，getenv("REMOTE_ADDR")',
  `device_type` varchar(255) DEFAULT NULL,
  `http_user_agent` varchar(1000) DEFAULT NULL COMMENT '当前访问者浏览器信息，$_SERVER[''HTTP_USER_AGENT'']',
  PRIMARY KEY (`ur_id`),
  KEY `eom_use_rec_rec_type` (`rec_type`),
  KEY `eom_use_rec_use_time` (`use_time`),
  KEY `eom_use_rec_cmd_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eom_use_rec`
--

LOCK TABLES `eom_use_rec` WRITE;
/*!40000 ALTER TABLE `eom_use_rec` DISABLE KEYS */;
/*!40000 ALTER TABLE `eom_use_rec` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eom_user`
--

DROP TABLE IF EXISTS `eom_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eom_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_code` varchar(16) DEFAULT NULL,
  `user_name` varchar(64) NOT NULL,
  `user_alias` varchar(100) DEFAULT NULL,
  `user_password` varchar(64) NOT NULL,
  `host_id` int(11) NOT NULL,
  `group_id` int(11) DEFAULT NULL,
  `per_id` int(11) DEFAULT NULL,
  `all_org` int(11) DEFAULT NULL,
  `all_user` int(11) DEFAULT NULL,
  `exp_date` int(11) DEFAULT NULL,
  `last_login` int(11) DEFAULT NULL,
  `last_ip` varchar(64) DEFAULT NULL,
  `def_page` varchar(64) DEFAULT NULL,
  `is_admin` char(1) DEFAULT '0',
  `user_yzm` varchar(8) DEFAULT NULL,
  `closed` char(1) DEFAULT '0',
  `quy1` varchar(8) DEFAULT NULL,
  `quy2` varchar(8) DEFAULT NULL,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `ix_eom_user_code` (`user_code`,`host_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eom_user`
--

LOCK TABLES `eom_user` WRITE;
/*!40000 ALTER TABLE `eom_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `eom_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eom_user_role`
--

DROP TABLE IF EXISTS `eom_user_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eom_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_eom_user_role_id` (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eom_user_role`
--

LOCK TABLES `eom_user_role` WRITE;
/*!40000 ALTER TABLE `eom_user_role` DISABLE KEYS */;
/*!40000 ALTER TABLE `eom_user_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sms_config`
--

DROP TABLE IF EXISTS `sms_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sms_config` (
  `sms_id` int(11) NOT NULL AUTO_INCREMENT,
  `host_id` int(11) DEFAULT NULL,
  `sms_code` varchar(16) DEFAULT NULL,
  `sms_pwd` varchar(64) DEFAULT NULL,
  `sms_name` varchar(64) DEFAULT NULL,
  `sms_url` varchar(255) DEFAULT NULL,
  `key` varchar(128) DEFAULT NULL,
  `secret` varchar(128) DEFAULT NULL,
  `add_time` int(11) DEFAULT NULL,
  `edit_time` int(11) DEFAULT NULL,
  `last_changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '上次修改时间',
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`sms_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sms_config`
--

LOCK TABLES `sms_config` WRITE;
/*!40000 ALTER TABLE `sms_config` DISABLE KEYS */;
/*!40000 ALTER TABLE `sms_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `top_account`
--

DROP TABLE IF EXISTS `top_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `top_account` (
  `ta_id` int(11) NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL,
  `ta_code` varchar(32) NOT NULL,
  `seller_name` varchar(128) NOT NULL,
  `session_key` varchar(128) NOT NULL,
  `wis_api_url` varchar(1000) NOT NULL,
  `wis_api_key` varchar(64) NOT NULL,
  `wis_api_user` varchar(64) NOT NULL,
  `wis_tmall_code` varchar(32) NOT NULL,
  `first_changed` int(11) DEFAULT NULL,
  `last_changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ta_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `top_account`
--

LOCK TABLES `top_account` WRITE;
/*!40000 ALTER TABLE `top_account` DISABLE KEYS */;
/*!40000 ALTER TABLE `top_account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `top_user`
--

DROP TABLE IF EXISTS `top_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `top_user` (
  `user_id` int(10) NOT NULL AUTO_INCREMENT,
  `host_id` int(10) NOT NULL,
  `ta_id` int(11) NOT NULL,
  `nick` varchar(64) NOT NULL,
  `mobile` varchar(16) NOT NULL,
  `method` varchar(64) DEFAULT NULL,
  `add_time` int(10) NOT NULL,
  `last_changed` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `top_user`
--

LOCK TABLES `top_user` WRITE;
/*!40000 ALTER TABLE `top_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `top_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wt_account`
--

DROP TABLE IF EXISTS `wt_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wt_account` (
  `ac_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL COMMENT '宿主id',
  `ac_no` varchar(64) NOT NULL COMMENT '公众号',
  `ac_name` varchar(64) NOT NULL COMMENT '公众号的名',
  `ac_original` varchar(64) NOT NULL COMMENT '原始的公众号',
  `ac_token` varchar(64) NOT NULL COMMENT '当前的token',
  `ac_appid` varchar(32) NOT NULL COMMENT '公众号的appid',
  `ac_appsecret` varchar(64) NOT NULL COMMENT '公众号的应用密钥',
  `ac_encodingaeskey` varchar(64) NOT NULL,
  `ac_addr` varchar(255) DEFAULT NULL COMMENT '当前的地址',
  `ac_email` varchar(64) NOT NULL COMMENT 'email地址',
  `ac_code` varchar(128) DEFAULT NULL,
  `ac_time` int(11) NOT NULL COMMENT '创建的时间',
  `ac_type` tinyint(4) NOT NULL COMMENT '账号的类型',
  `wis_api_url` varchar(1000) DEFAULT NULL,
  `wis_api_user` varchar(64) DEFAULT NULL,
  `wis_api_key` varchar(64) DEFAULT NULL,
  `wis_mall_code` varchar(100) DEFAULT NULL,
  `accredit` varchar(255) DEFAULT NULL,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ac_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wt_account`
--

LOCK TABLES `wt_account` WRITE;
/*!40000 ALTER TABLE `wt_account` DISABLE KEYS */;
/*!40000 ALTER TABLE `wt_account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wt_card`
--

DROP TABLE IF EXISTS `wt_card`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wt_card` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL,
  `to_user_name` varchar(20) NOT NULL,
  `openid` varchar(64) NOT NULL,
  `event` varchar(32) NOT NULL,
  `card_id` varchar(64) NOT NULL,
  `is_give_by_friend` tinyint(4) NOT NULL,
  `card_code` varchar(32) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `friend_username` varchar(64) DEFAULT NULL,
  `outer_id` int(11) DEFAULT NULL,
  `old_user_card_code` varchar(32) DEFAULT NULL,
  `outer_str` varchar(16) DEFAULT NULL,
  `is_restore_member_card` tinyint(4) NOT NULL,
  `union_id` varchar(64) NOT NULL,
  `create_time` int(11) NOT NULL,
  `activation_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wt_card`
--

LOCK TABLES `wt_card` WRITE;
/*!40000 ALTER TABLE `wt_card` DISABLE KEYS */;
/*!40000 ALTER TABLE `wt_card` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wt_fans`
--

DROP TABLE IF EXISTS `wt_fans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wt_fans` (
  `fans_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL,
  `ac_id` int(11) NOT NULL,
  `fans_openid` varchar(64) NOT NULL COMMENT '用户的唯一标识',
  `fans_nickname` varchar(64) NOT NULL COMMENT '用户名称',
  `fans_sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1为男,2为女,0为未知',
  `fans_language` varchar(16) DEFAULT NULL COMMENT '语言',
  `fans_city` varchar(32) DEFAULT NULL COMMENT '城市',
  `fans_province` varchar(32) DEFAULT NULL COMMENT '省份',
  `fans_country` varchar(32) DEFAULT NULL COMMENT '国家',
  `fans_headimgurl` varchar(255) DEFAULT NULL COMMENT '头像地址',
  `fans_subscribe_time` int(11) DEFAULT NULL COMMENT '关注的时间',
  `fans_unionid` varchar(32) DEFAULT '0' COMMENT '是否绑定到公众平台',
  `fans_remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `fans_groupid` tinyint(4) DEFAULT NULL,
  `fans_tagid_list` varchar(128) DEFAULT NULL,
  `fans_dark` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否拉黑用户 0表示否,1,表示是拉黑',
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`fans_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wt_fans`
--

LOCK TABLES `wt_fans` WRITE;
/*!40000 ALTER TABLE `wt_fans` DISABLE KEYS */;
/*!40000 ALTER TABLE `wt_fans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wt_material`
--

DROP TABLE IF EXISTS `wt_material`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wt_material` (
  `mal_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL,
  `ac_id` int(11) NOT NULL,
  `mal_madia_id` varchar(128) NOT NULL,
  `mal_title` varchar(128) DEFAULT NULL,
  `mal_author` varchar(64) DEFAULT NULL,
  `mal_digest` varchar(128) DEFAULT NULL,
  `mal_content` varchar(255) DEFAULT NULL,
  `mal_content_url` varchar(255) DEFAULT NULL,
  `mal_thumbmedia_id` varchar(255) DEFAULT NULL,
  `mal_cover_pic` int(11) DEFAULT NULL,
  `mal_url` varchar(255) DEFAULT NULL,
  `mal_thumburl` varchar(255) DEFAULT NULL,
  `mal_uptime` int(11) DEFAULT NULL,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wt_material`
--

LOCK TABLES `wt_material` WRITE;
/*!40000 ALTER TABLE `wt_material` DISABLE KEYS */;
/*!40000 ALTER TABLE `wt_material` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wt_media`
--

DROP TABLE IF EXISTS `wt_media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wt_media` (
  `mer_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL,
  `ac_id` int(11) NOT NULL,
  `media_id` varchar(128) NOT NULL,
  `media_title` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`mer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wt_media`
--

LOCK TABLES `wt_media` WRITE;
/*!40000 ALTER TABLE `wt_media` DISABLE KEYS */;
/*!40000 ALTER TABLE `wt_media` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wt_qrcode_back`
--

DROP TABLE IF EXISTS `wt_qrcode_back`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wt_qrcode_back` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `host_id` int(10) unsigned NOT NULL,
  `ac_id` int(10) unsigned NOT NULL,
  `to_user_name` varchar(64) DEFAULT NULL,
  `from_user_name` varchar(64) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `msg_type` varchar(16) DEFAULT NULL,
  `event_type` varchar(32) DEFAULT NULL,
  `event_key` varchar(64) DEFAULT NULL,
  `ticket` varchar(128) DEFAULT NULL,
  `first_changed` int(11) DEFAULT NULL,
  `last_changed` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `inputer` varchar(64) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_wt_qrcode_back_openid` (`host_id`,`ac_id`,`from_user_name`),
  KEY `ix_wt_qrcode_back_event_key` (`event_key`),
  KEY `ix_wt_qrcode_back_ticket` (`ticket`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wt_qrcode_back`
--

LOCK TABLES `wt_qrcode_back` WRITE;
/*!40000 ALTER TABLE `wt_qrcode_back` DISABLE KEYS */;
/*!40000 ALTER TABLE `wt_qrcode_back` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wt_reply`
--

DROP TABLE IF EXISTS `wt_reply`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wt_reply` (
  `reply_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `host_id` int(11) NOT NULL COMMENT '宿主id',
  `ac_id` int(11) NOT NULL COMMENT '微信号的id',
  `receive_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '当前的什么类型',
  `reply_key` varchar(128) DEFAULT NULL COMMENT '关键字',
  `reply_content` text COMMENT '文本类型回复的类容',
  `reply_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '当前要回复的类型',
  `add_time` int(10) unsigned NOT NULL COMMENT '添加的时间',
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `media_id` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`reply_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wt_reply`
--

LOCK TABLES `wt_reply` WRITE;
/*!40000 ALTER TABLE `wt_reply` DISABLE KEYS */;
/*!40000 ALTER TABLE `wt_reply` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wt_template`
--

DROP TABLE IF EXISTS `wt_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wt_template` (
  `temp_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `p_id` int(10) DEFAULT NULL,
  `access_code` varchar(32) NOT NULL,
  `host_id` int(11) NOT NULL,
  `ac_id` int(11) NOT NULL,
  `template_id` varchar(64) NOT NULL,
  `first_changed` int(11) DEFAULT NULL,
  `last_changed` int(11) DEFAULT NULL,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`temp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wt_template`
--

LOCK TABLES `wt_template` WRITE;
/*!40000 ALTER TABLE `wt_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `wt_template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wt_template_model`
--

DROP TABLE IF EXISTS `wt_template_model`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wt_template_model` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `temp_code` varchar(32) NOT NULL,
  `temp_title` varchar(64) NOT NULL,
  `temp_content` text NOT NULL,
  `temp_example` text NOT NULL,
  `first_industry` varchar(32) DEFAULT NULL,
  `second_industry` varchar(32) DEFAULT NULL,
  `is_enable` tinyint(4) DEFAULT '1',
  `first_changed` int(11) DEFAULT NULL,
  `last_changed` int(11) DEFAULT NULL,
  `key_user` varchar(16) DEFAULT NULL,
  `inputer` varchar(64) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wt_template_model`
--

LOCK TABLES `wt_template_model` WRITE;
/*!40000 ALTER TABLE `wt_template_model` DISABLE KEYS */;
INSERT INTO `wt_template_model` VALUES (1,'OPENTM204650588','订单消息通知','<form autocomplete=\"off\" style=\"margin-top: 10px\"  class=\"adddata vip-vipcard layui-form\">\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板标题：</label>\r\n			<div class=\"layui-input-inline\"><input readonly style=\"border: none\" value=\"{$tempdata[\'content\'][\'temp_title\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板名称：</label>\r\n			<div class=\"layui-input-inline\"><input name=\"temp_alias\" value=\"{$tempdata[\'content\'][\'temp_alias\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Tab_page\" style=\"clear: both\">\r\n		<ul class=\"Label\">\r\n			<li class=\"active\"><a href=\"tabs1\"  data-send=\"0\">模板示例</a></li>\r\n			<li><a href=\"tabs2\"  data-send=\"0\">基本配置</a></li>\r\n			<li><a href=\"tabs3\"  data-send=\"0\">变量说明</a></li>\r\n		</ul>\r\n		<div class=\"Label_content\">\r\n\r\n			<div class=\"Label_content_add\">\r\n				<div class=\"tabs1\" style=\"padding: 0 5px;\">\r\n					{$tempdata[\'content\'][\'temp_example\']}\r\n				</div>\r\n				<div class=\"tabs2 layui-hide\" style=\"padding: 0 5px;\">\r\n					<input type=\"hidden\" name=\"id\" value=\"{$tempdata[\'content\'][\'temp_id\']}\">\r\n					<div class=\"add\" style=\"padding-top: 20px\">\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"first\" placeholder=\"请输入\" class=\"layui-input\r\n		required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'first\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>消息类型:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key1\" placeholder=\"请输入\" class=\"layui-input required_value\"\r\n																	   type=\"text\" value=\"{$tempdata[\'data\'][\'key1\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>跟进时间:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key2\" placeholder=\"请输入\" class=\"layui-input required_value\"\r\n																	   type=\"text\" value=\"{$tempdata[\'data\'][\'key2\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"remark\" placeholder=\"请输入\" class=\"layui-input\r\n		required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'remark\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n					</div>\r\n				</div>\r\n				<div class=\"tabs3 layui-hide\" style=\"padding: 0 5px;\">\r\n					变量说明:<br/>\r\n					<span style=\"margin-left: 20px;\">订单号:%order_num%</span><br/>\r\n					<span style=\"margin-left: 20px;\">跟进时间:%time%</span><br/>\r\n					<div style=\"color: red;\">注意:</div>\r\n					<div>\r\n						<span style=\"margin-left: 20px;\">模版消息的填写规范请参照<a href=\"https://mp.weixin.qq.com/mp/opshowpage?action=newoplaw#t3-3-9\" target=\"_blank\">《微信公众平台运营规范》</a></span><br/>\r\n						<span style=\"margin-left: 20px;\">对于违反微信运营规范所造成的损失,请自行承担责任。</span>\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Operation_button\">\r\n		<button data-url=\"3b373ba27cd2b29eb4\" type=\"button\" class=\"layui-btn layui-btn-small layui-btn-warm addsubmit\">确认</button>\r\n		<button type=\"button\" class=\"layui-btn layui-btn-style layui-btn-small layui-btn-cancel\">取消</button>\r\n	</div>\r\n</form>','您的法国租车订单99999999已经确认！车辆由神州公司提供，取车确认号为：88888888（如需与租车公司联系，请提供此确认号），订单金额999元（已支付）。用车时间：2015-06-20 06:30至2015-06-21 22:00，共2天，取车点：广州，还车点：广州。请查收邮件并打印英文电子提车凭证，祝您用车愉快！Your 神州 Confirmation No:111111111(Prepaid).Have a nice trip.<br/>\r\n消息类型：订单确认<br/>\r\n跟进时间：2015年5月13日 18:36<br/>\r\n感谢关注租租车，由您的支持我们会做得更好。','IT科技','互联网|电子商务',1,1511747032,1511747032,NULL,NULL,NULL),(2,'TM00178','验证码下发通知','<form autocomplete=\"off\" style=\"margin-top: 10px\"  class=\"adddata vip-vipcard layui-form\">\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板标题：</label>\r\n			<div class=\"layui-input-inline\"><input readonly style=\"border: none\" value=\"{$tempdata[\'content\'][\'temp_title\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板名称：</label>\r\n			<div class=\"layui-input-inline\"><input name=\"temp_alias\" value=\"{$tempdata[\'content\'][\'temp_alias\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Tab_page\" style=\"clear: both\">\r\n		<ul class=\"Label\">\r\n			<li class=\"active\"><a href=\"tabs1\"  data-send=\"0\">模板示例</a></li>\r\n			<li><a href=\"tabs2\"  data-send=\"0\">基本配置</a></li>\r\n			<li><a href=\"tabs3\"  data-send=\"0\">变量说明</a></li>\r\n		</ul>\r\n		<div class=\"Label_content\">\r\n\r\n			<div class=\"Label_content_add\">\r\n				<div class=\"tabs1\" style=\"padding: 0 5px;\">\r\n					{$tempdata[\'content\'][\'temp_example\']}\r\n				</div>\r\n				<div class=\"tabs2 layui-hide\" style=\"padding: 0 5px;\">\r\n					<input type=\"hidden\" name=\"id\" value=\"{$tempdata[\'content\'][\'temp_id\']}\">\r\n					<div class=\"\" style=\"padding-top: 20px\">\r\n						<div class=\"layui-form-item\" style=\"width:inherit;\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\" style=\"width: inherit\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"first\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'first\']}\"></div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\" style=\"width:inherit;\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\" style=\"width: inherit\"><span class=\"Required\">*</span>手机动态验证码为:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key1\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key1\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\" style=\"width:inherit;\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\" style=\"width: inherit\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"remark\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'remark\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"Operation_button\">\r\n							<button data-url=\"3b373ba27cd2b29eb4\" type=\"button\" class=\"layui-btn layui-btn-small layui-btn-warm addsubmit\">确认</button>\r\n							<button type=\"button\" class=\"layui-btn layui-btn-style layui-btn-small layui-btn-cancel\">取消</button>\r\n						</div>\r\n					</div>\r\n				</div>\r\n				<div class=\"tabs3 layui-hide\" style=\"padding: 0 5px;\">\r\n					变量说明:<br/>\r\n					<span style=\"margin-left: 20px;\">验证码:%verifiy% </span><br/>\r\n					<div style=\"color: red;\">注意:</div>\r\n					<div>\r\n						<span style=\"margin-left: 20px;\">模版消息的填写规范请参照<a href=\"https://mp.weixin.qq.com/mp/opshowpage?action=newoplaw#t3-3-9\" target=\"_blank\">《微信公众平台运营规范》</a></span><br/>\r\n						<span style=\"margin-left: 20px;\">对于违反微信运营规范所造成的损失,请自行承担责任。</span>\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Operation_button\">\r\n		<button data-url=\"3b373ba27cd2b29eb4\" type=\"button\" class=\"layui-btn layui-btn-small layui-btn-warm addsubmit\">确认</button>\r\n		<button type=\"button\" class=\"layui-btn layui-btn-style layui-btn-small layui-btn-cancel\">取消</button>\r\n	</div>\r\n</form>','尊敬的顾客,手机动态验证码为123456。该验证码有效期30分钟可输入1次，转发无效。','IT科技','互联网|电子商务',1,1511747032,1511747032,NULL,NULL,NULL),(3,'OPENTM200539554','消费提醒','<form autocomplete=\"off\" style=\"margin-top: 10px\"  class=\"adddata vip-vipcard layui-form\">\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板标题：</label>\r\n			<div class=\"layui-input-inline\"><input readonly style=\"border: none\" value=\"{$tempdata[\'content\'][\'temp_title\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板名称：</label>\r\n			<div class=\"layui-input-inline\"><input name=\"temp_alias\" value=\"{$tempdata[\'content\'][\'temp_alias\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Tab_page\" style=\"clear: both\">\r\n		<ul class=\"Label\">\r\n			<li class=\"active\"><a href=\"tabs1\"  data-send=\"0\">模板示例</a></li>\r\n			<li><a href=\"tabs2\"  data-send=\"0\">基本配置</a></li>\r\n			<li><a href=\"tabs3\"  data-send=\"0\">变量说明</a></li>\r\n		</ul>\r\n		<div class=\"Label_content\">\r\n\r\n			<div class=\"Label_content_add\">\r\n				<div class=\"tabs1\" style=\"padding: 0 5px;\">\r\n					{$tempdata[\'content\'][\'temp_example\']}\r\n				</div>\r\n				<div class=\"tabs2 layui-hide\" style=\"padding: 0 5px;\">\r\n					<input type=\"hidden\" name=\"id\" value=\"{$tempdata[\'content\'][\'temp_id\']}\">\r\n					<div class=\"add\" style=\"padding-top: 20px\">\r\n\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"first\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'first\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>商户名称:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key1\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key1\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>支付方式:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key2\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key2\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>消费金额:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key3\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key3\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>可获积分:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key4\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key4\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>消费时间:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key5\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key5\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"remark\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'remark\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n					</div>\r\n				</div>\r\n				<div class=\"tabs3 layui-hide\" style=\"padding: 0 5px;\">\r\n					变量说明:<br/>\r\n					<span style=\"margin-left: 20px;\">支付方式:%paytype%</span><br/>\r\n					<span style=\"margin-left: 20px;\">消费金额:%paymoney%</span><br/>\r\n					<span style=\"margin-left: 20px;\">可获积分:%point%</span><br/>\r\n					<span style=\"margin-left: 20px;\">消费时间:%date%</span><br/>\r\n					<div style=\"color: red;\">注意:</div>\r\n					<div>\r\n						<span style=\"margin-left: 20px;\">模板消息的填写规范请参照<a href=\"https://mp.weixin.qq.com/mp/opshowpage?action=newoplaw#t3-3-9\" target=\"_blank\">《微信公众平台运营规范》</a></span><br/>\r\n						<span style=\"margin-left: 20px;\">对于违反微信运营规范所造成的损失,请自行承担责任。</span>\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Operation_button\">\r\n		<button data-url=\"3b373ba27cd2b29eb4\" type=\"button\" class=\"layui-btn layui-btn-small layui-btn-warm addsubmit\">确认</button>\r\n		<button type=\"button\" class=\"layui-btn layui-btn-style layui-btn-small layui-btn-cancel\">取消</button>\r\n	</div>\r\n</form>','您好，您本次消费账单如下：<br/>\r\n商户名称：唐食粥语<br/>\r\n支付方式：现金<br/>\r\n消费金额：100元<br/>\r\n可获积分：10<br/>\r\n消费时间：2014/10/10 09:36<br/>\r\n感谢您的使用。','IT科技','互联网|电子商务',1,1511747032,1511747032,NULL,NULL,NULL),(4,'OPENTM405759324','赠送成功通知','<form autocomplete=\"off\" style=\"margin-top: 10px\"  class=\"adddata vip-vipcard layui-form\">\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板标题：</label>\r\n			<div class=\"layui-input-inline\"><input readonly style=\"border: none\" value=\"{$tempdata[\'content\'][\'temp_title\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板名称：</label>\r\n			<div class=\"layui-input-inline\"><input name=\"temp_alias\" value=\"{$tempdata[\'content\'][\'temp_alias\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Tab_page\" style=\"clear: both\">\r\n		<ul class=\"Label\">\r\n			<li class=\"active\"><a href=\"tabs1\"  data-send=\"0\">模板示例</a></li>\r\n			<li><a href=\"tabs2\"  data-send=\"0\">基本配置</a></li>\r\n			<li><a href=\"tabs3\"  data-send=\"0\">变量说明</a></li>\r\n		</ul>\r\n		<div class=\"Label_content\">\r\n\r\n			<div class=\"Label_content_add\">\r\n				<div class=\"tabs1\" style=\"padding: 0 5px;\">\r\n					{$tempdata[\'content\'][\'temp_example\']}\r\n				</div>\r\n				<div class=\"tabs2 layui-hide\" style=\"padding: 0 5px;\">\r\n					<input type=\"hidden\" name=\"id\" value=\"{$tempdata[\'content\'][\'temp_id\']}\">\r\n					<div class=\"add\">\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"first\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'first\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>赠送时长:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key1\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key1\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>原到期日:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key2\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key2\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>新到期日:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key3\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key3\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"remark\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'remark\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n					</div>\r\n				</div>\r\n				<div class=\"tabs3 layui-hide\" style=\"padding: 0 5px;\">\r\n					变量说明:<br/>\r\n					<span style=\"margin-left: 20px;\">赠送时长:%day%</span><br/>\r\n					<span style=\"margin-left: 20px;\">原到期日:%end_date%</span><br/>\r\n					<span style=\"margin-left: 20px;\">新到期日:%end_date%</span><br/>\r\n					<span style=\"margin-left: 20px;\">生效日期:%start_date%</span><br/>\r\n					<span style=\"margin-left: 20px;\">优惠券面值:%money%</span><br/>\r\n					<div style=\"color: red;\">注意:</div>\r\n					<div>\r\n						<span style=\"margin-left: 20px;\">模版消息的填写规范请参照<a href=\"https://mp.weixin.qq.com/mp/opshowpage?action=newoplaw#t3-3-9\" target=\"_blank\">《微信公众平台运营规范》</a></span><br/>\r\n						<span style=\"margin-left: 20px;\">对于违反微信运营规范所造成的损失,请自行承担责任。</span>\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Operation_button\">\r\n		<button data-url=\"3b373ba27cd2b29eb4\" type=\"button\" class=\"layui-btn layui-btn-small layui-btn-warm addsubmit\">确认</button>\r\n		<button type=\"button\" class=\"layui-btn layui-btn-style layui-btn-small layui-btn-cancel\">取消</button>\r\n	</div>\r\n</form>','您的使用时间已成功增加<br/>\r\n赠送时长：7天<br/>\r\n原到期日：2016-06-03<br/>\r\n新到期日：2016-06-10<br/>\r\n感谢您的使用','IT科技','IT软件与服务',1,1511747032,1511747032,NULL,NULL,NULL),(5,'OPENTM405551574','充值到账通知','<form autocomplete=\"off\" style=\"margin-top: 10px\"  class=\"adddata vip-vipcard layui-form\">\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板标题：</label>\r\n			<div class=\"layui-input-inline\"><input readonly style=\"border: none\" value=\"{$tempdata[\'content\'][\'temp_title\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板名称：</label>\r\n			<div class=\"layui-input-inline\"><input name=\"temp_alias\" value=\"{$tempdata[\'content\'][\'temp_alias\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Tab_page\" style=\"clear: both\">\r\n		<ul class=\"Label\">\r\n			<li class=\"active\"><a href=\"tabs1\"  data-send=\"0\">模板示例</a></li>\r\n			<li><a href=\"tabs2\"  data-send=\"0\">基本配置</a></li>\r\n			<li><a href=\"tabs3\"  data-send=\"0\">变量说明</a></li>\r\n		</ul>\r\n		<div class=\"Label_content\">\r\n\r\n			<div class=\"Label_content_add\">\r\n				<div class=\"tabs1\" style=\"padding: 0 5px;\">\r\n					{$tempdata[\'content\'][\'temp_example\']}\r\n				</div>\r\n				<div class=\"tabs2 layui-hide\" style=\"padding: 0 5px;\">\r\n					<input type=\"hidden\" name=\"id\" value=\"{$tempdata[\'content\'][\'temp_id\']}\">\r\n					<div class=\"add\">\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"first\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'first\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>充值时间:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key1\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key1\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>充值金额:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key2\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key2\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>可用余额:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key3\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key3\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"remark\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'remark\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n					</div>\r\n				</div>\r\n				<div class=\"tabs3 layui-hide\" style=\"padding: 0 5px;\">\r\n					变量说明:<br/>\r\n					<span style=\"margin-left: 20px;\">充值时间:%time%</span><br/>\r\n					<span style=\"margin-left: 20px;\">充值金额:%change_money%</span><br/>\r\n					<span style=\"margin-left: 20px;\">可用余额:%after_money%</span><br/>\r\n					<div style=\"color: red;\">注意:</div>\r\n					<div>\r\n						<span style=\"margin-left: 20px;\">模版消息的填写规范请参照<a href=\"https://mp.weixin.qq.com/mp/opshowpage?action=newoplaw#t3-3-9\" target=\"_blank\">《微信公众平台运营规范》</a></span><br/>\r\n						<span style=\"margin-left: 20px;\">对于违反微信运营规范所造成的损失,请自行承担责任。</span>\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Operation_button\">\r\n		<button data-url=\"3b373ba27cd2b29eb4\" type=\"button\" class=\"layui-btn layui-btn-small layui-btn-warm addsubmit\">确认</button>\r\n		<button type=\"button\" class=\"layui-btn layui-btn-style layui-btn-small layui-btn-cancel\">取消</button>\r\n	</div>\r\n</form>','尊敬的用户，您已成功充值<br/>\r\n充值时间：2016年5月11日 11:36<br/>\r\n充值金额：1000元<br/>\r\n可用余额：1500元<br/>\r\n感谢您对置信度的支持','IT科技1','IT软件与服务',1,1511747032,1511747032,NULL,NULL,NULL),(6,'OPENTM229111864','参与活动即将开始提醒','<form autocomplete=\"off\" style=\"margin-top: 10px\"  class=\"adddata vip-vipcard layui-form\">\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板标题：</label>\r\n			<div class=\"layui-input-inline\"><input readonly style=\"border: none\" value=\"{$tempdata[\'content\'][\'temp_title\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板名称：</label>\r\n			<div class=\"layui-input-inline\"><input name=\"temp_alias\" value=\"{$tempdata[\'content\'][\'temp_alias\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Tab_page\" style=\"clear: both\">\r\n		<ul class=\"Label\">\r\n			<li class=\"active\"><a href=\"tabs1\"  data-send=\"0\">模板示例</a></li>\r\n			<li><a href=\"tabs2\"  data-send=\"0\">基本配置</a></li>\r\n			<li><a href=\"tabs3\"  data-send=\"0\">变量说明</a></li>\r\n		</ul>\r\n		<div class=\"Label_content\">\r\n\r\n			<div class=\"Label_content_add\">\r\n				<div class=\"tabs1\" style=\"padding: 0 5px;\">\r\n					{$tempdata[\'content\'][\'temp_example\']}\r\n				</div>\r\n				<div class=\"tabs2 layui-hide\" style=\"padding: 0 5px;\">\r\n					<input type=\"hidden\" name=\"id\" value=\"{$tempdata[\'content\'][\'temp_id\']}\">\r\n					<div class=\"add\" style=\"padding-top: 20px\">\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"first\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'first\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>用户名:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key1\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key1\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>主题:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key2\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key2\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>时间:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key3\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key3\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span>地点:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key4\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key4\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"remark\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'remark\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div style=\"clear: both;text-align: center;margin-top: 20px\">\r\n							<button data-url=\"3b373ba27cd2b29eb4\" type=\"button\" class=\"layui-btn layui-btn-small layui-btn-warm addsubmit\">确认</button>\r\n							<button type=\"button\" class=\"layui-btn layui-btn-style layui-btn-small layui-btn-cancel\">取消</button>\r\n						</div>\r\n					</div>\r\n				</div>\r\n				<div class=\"tabs3 layui-hide\" style=\"padding: 0 5px;\">\r\n					变量说明:<br/>\r\n					<span style=\"margin-left: 20px;\"></span><br/>\r\n					<div style=\"color: red;\">注意:</div>\r\n					<div>\r\n						<span style=\"margin-left: 20px;\">模板消息的填写规范请参照<a href=\"https://mp.weixin.qq.com/mp/opshowpage?action=newoplaw#t3-3-9\" target=\"_blank\">《微信公众平台运营规范》</a></span><br/>\r\n						<span style=\"margin-left: 20px;\">对于违反微信运营规范所造成的损失,请自行承担责任。</span>\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Operation_button\">\r\n		<button data-url=\"3b373ba27cd2b29eb4\" type=\"button\" class=\"layui-btn layui-btn-small layui-btn-warm addsubmit\">确认</button>\r\n		<button type=\"button\" class=\"layui-btn layui-btn-style layui-btn-small layui-btn-cancel\">取消</button>\r\n	</div>\r\n</form>','你好，你参加的饭局即将开始。<br/>\r\n用户名：Eric<br/>\r\n主题：时尚达人秀<br/>\r\n时间：本周六晚上6点整<br/>\r\n地点：蓉悦 深圳市罗湖区宝安南路1881号华润中心万象城4层468<br/>\r\n点击浏览更多饭局信息','IT科技','互联网|电子商务',1,1511747032,1511747032,NULL,NULL,NULL),(7,'OPENTM202109783','咨询回复消息提醒','<form autocomplete=\"off\" style=\"margin-top: 10px\"  class=\"adddata vip-vipcard layui-form\">\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板标题：</label>\r\n			<div class=\"layui-input-inline\"><input readonly style=\"border: none\" value=\"{$tempdata[\'content\'][\'temp_title\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"layui-form-item\" style=\"width: 50%;float: left\">\r\n		<div class=\"layui-inline\">\r\n			<label class=\"layui-form-label\" style=\"width: inherit\">模板名称：</label>\r\n			<div class=\"layui-input-inline\"><input name=\"temp_alias\" value=\"{$tempdata[\'content\'][\'temp_alias\']}\" class=\"layui-input\"  type=\"text\">\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Tab_page\" style=\"clear: both\">\r\n		<ul class=\"Label\">\r\n			<li class=\"active\"><a href=\"tabs1\"  data-send=\"0\">模板示例</a></li>\r\n			<li><a href=\"tabs2\"  data-send=\"0\">基本配置</a></li>\r\n			<li><a href=\"tabs3\"  data-send=\"0\">变量说明</a></li>\r\n		</ul>\r\n		<div class=\"Label_content\">\r\n\r\n			<div class=\"Label_content_add\">\r\n				<div class=\"tabs1\" style=\"padding: 0 5px;\">\r\n					{$tempdata[\'content\'][\'temp_example\']}\r\n				</div>\r\n				<div class=\"tabs2 layui-hide\" style=\"padding: 0 5px;\">\r\n					<input type=\"hidden\" name=\"id\" value=\"{$tempdata[\'content\'][\'temp_id\']}\">\r\n					<div class=\"\" style=\"padding-top: 20px\">\r\n						<div class=\"layui-form-item\" style=\"width:inherit;\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\" style=\"width: inherit\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"first\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'first\']}\"></div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\" style=\"width:inherit;\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\" style=\"width: inherit\"><span class=\"Required\">*</span>咨询名称:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key1\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key1\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\" style=\"width:inherit;\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\" style=\"width: inherit\"><span class=\"Required\">*</span>消息回复:</label>\r\n								<div class=\"layui-input-inline\"><input name=\"key2\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'key2\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"layui-form-item\" style=\"width:inherit;\">\r\n							<div class=\"layui-inline\">\r\n								<label class=\"layui-form-label\" style=\"width: inherit\"><span class=\"Required\">*</span></label>\r\n								<div class=\"layui-input-inline\"><input name=\"remark\" placeholder=\"请输入\" class=\"layui-input required_value\" type=\"text\" value=\"{$tempdata[\'data\'][\'remark\']}\">\r\n								</div>\r\n							</div>\r\n						</div>\r\n						<div class=\"Operation_button\">\r\n							<button data-url=\"3b373ba27cd2b29eb4\" type=\"button\" class=\"layui-btn layui-btn-small layui-btn-warm addsubmit\">确认</button>\r\n							<button type=\"button\" class=\"layui-btn layui-btn-style layui-btn-small layui-btn-cancel\">取消</button>\r\n						</div>\r\n					</div>\r\n				</div>\r\n				<div class=\"tabs3 layui-hide\" style=\"padding: 0 5px;\">\r\n					变量说明:<br/>\r\n					<span style=\"margin-left: 20px;\">咨询名称:%tp_title% </span><br/>\r\n					<span style=\"margin-left: 20px;\">消息回复:%tp_message% </span><br/>\r\n					<div style=\"color: red;\">注意:</div>\r\n					<div>\r\n						<span style=\"margin-left: 20px;\">模版消息的填写规范请参照<a href=\"https://mp.weixin.qq.com/mp/opshowpage?action=newoplaw#t3-3-9\" target=\"_blank\">《微信公众平台运营规范》</a></span><br/>\r\n						<span style=\"margin-left: 20px;\">对于违反微信运营规范所造成的损失,请自行承担责任。</span>\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n	<div class=\"Operation_button\">\r\n		<button data-url=\"3b373ba27cd2b29eb4\" type=\"button\" class=\"layui-btn layui-btn-small layui-btn-warm addsubmit\">确认</button>\r\n		<button type=\"button\" class=\"layui-btn layui-btn-style layui-btn-small layui-btn-cancel\">取消</button>\r\n	</div>\r\n</form>','您好，您咨询商家的问题已回复<br/>\r\n咨询名称：孕儿美摄影工作室<br/>\r\n消息回复：您明天可以到店里取片<br/>\r\n点击进入咨询页面<br/>','IT科技','互联网|电子商务',1,1526635482,1526635482,NULL,NULL,NULL);
/*!40000 ALTER TABLE `wt_template_model` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wt_template_models`
--

DROP TABLE IF EXISTS `wt_template_models`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wt_template_models` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `p_id` int(10) DEFAULT NULL,
  `field_code` varchar(64) DEFAULT NULL,
  `field_name` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wt_template_models`
--

LOCK TABLES `wt_template_models` WRITE;
/*!40000 ALTER TABLE `wt_template_models` DISABLE KEYS */;
INSERT INTO `wt_template_models` VALUES (1,1,'first',''),(2,1,'key1','消息类型:'),(3,1,'key2','跟进时间:'),(4,1,'remark',NULL),(5,2,'first',''),(6,2,'key1','手机动态验证码为:'),(7,2,'remark',''),(8,3,'first',''),(9,3,'key1','商户名称:'),(10,3,'key2','支付方式:'),(11,3,'key3','消费金额:'),(12,3,'key4','可获积分:'),(13,3,'key5','消费时间:'),(14,3,'remark',''),(15,4,'first',''),(16,4,'key1','赠送时长:'),(17,4,'key2','原到期日:'),(18,4,'key3','新到期日:'),(19,4,'remark',''),(20,5,'first',''),(21,5,'key1','充值时间:'),(22,5,'key2','充值金额:'),(23,5,'key3','可用余额:'),(24,5,'remark',''),(25,6,'first',''),(26,6,'key1','用户名:'),(27,6,'key2','主题:'),(28,6,'key3','时间:'),(29,6,'key4','地点:'),(30,6,'remark',''),(31,7,'first',NULL),(32,7,'key1','咨询名称:'),(33,7,'key2','消息回复:'),(34,7,'remark',NULL);
/*!40000 ALTER TABLE `wt_template_models` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019-02-21 18:05:49
