-- MySQL dump 10.13  Distrib 5.6.50, for Linux (x86_64)
--
-- Host: localhost    Database: www_106pan_com
-- ------------------------------------------------------
-- Server version	5.6.50-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 `far_card`
--

DROP TABLE IF EXISTS `far_card`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `goods_id` int(11) NOT NULL,
  `card_no` varchar(50) NOT NULL,
  `card_pass` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1出售0未出售',
  `create_time` int(11) NOT NULL,
  `complete_time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `card_no` (`card_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_card`
--

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

--
-- Table structure for table `far_email_style`
--

DROP TABLE IF EXISTS `far_email_style`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_email_style` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL COMMENT '标题',
  `content` text NOT NULL COMMENT '内容',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型0掉线1订单',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_email_style`
--

LOCK TABLES `far_email_style` WRITE;
/*!40000 ALTER TABLE `far_email_style` DISABLE KEYS */;
INSERT INTO `far_email_style` VALUES (1,'云端掉线提示','<p>您的云端支付宝已经掉线，请及时上线~~为了不影响您收款请及时设置上线</p>',0),(2,'321','<p>rr</p>',1);
/*!40000 ALTER TABLE `far_email_style` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `far_goods`
--

DROP TABLE IF EXISTS `far_goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cls_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `descr` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态0下架1上架',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '商品发布类别0连接1卡密2html',
  `cost` decimal(14,2) NOT NULL DEFAULT '0.00',
  `price` decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '销售价',
  `mprice` decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '市场价',
  `image` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `html` text NOT NULL,
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_goods`
--

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

--
-- Table structure for table `far_goods_cls`
--

DROP TABLE IF EXISTS `far_goods_cls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_goods_cls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `sort` int(3) NOT NULL DEFAULT '50',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_goods_cls`
--

LOCK TABLES `far_goods_cls` WRITE;
/*!40000 ALTER TABLE `far_goods_cls` DISABLE KEYS */;
INSERT INTO `far_goods_cls` VALUES (42,'常用软件',1);
/*!40000 ALTER TABLE `far_goods_cls` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `far_master`
--

DROP TABLE IF EXISTS `far_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_master` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `userpass` varchar(32) NOT NULL,
  `create_time` int(11) NOT NULL,
  `salt` char(8) NOT NULL,
  `alipay_cookie` text NOT NULL COMMENT 'cookie',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_master`
--

LOCK TABLES `far_master` WRITE;
/*!40000 ALTER TABLE `far_master` DISABLE KEYS */;
INSERT INTO `far_master` VALUES (1,'admin','89275ffad7081cb66599c4e0eb1d114e',0,'IummTbE1','zone=GZ00C;ALIPAYJSESSIONID=RZ41uOk0gPH3UzUIMaq5AK2UkU4rOQauthRZ54GZ00;ctoken=VrpKQuE0gU3cFnCN;rtk=TkZxcjZcEseL6O5vKk0NbXfYQ77h5waG7PCOvWtjPsbEAqrpK3b;mobileSendTime=-1;credibleMobileSendTime=-1;ctuMobileSendTime=-1;riskMobileBankSendTime=-1;riskMobileAccoutSendTime=-1;riskMobileCreditSendTime=-1;riskCredibleMobileSendTime=-1;riskOriginalAccountMobileSendTime=-1;cna=HwahGXyv3hsCAXgZxQewLtl7;UM_distinctid=17ca8ab64eb4a4-00611d82880fdfc-8573f78-120000-17ca8ab64ec62c;LoginForm=alipay_login_home;CLUB_ALIPAY_COM=2088112977759406;ali_apache_tracktmp=\"uid=2088112977759406\";session.cookieNameId=ALIPAYJSESSIONID;iw.userid=\"K1iSL1gmCrEod43PFaiKzQ==\";alipay=\"K1iSL1gmCrEod43PFaiKzWCAaJNkWzicddQvRxTsMg==\";');
/*!40000 ALTER TABLE `far_master` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `far_order`
--

DROP TABLE IF EXISTS `far_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trade_no` varchar(255) NOT NULL,
  `out_trade_no` varchar(255) NOT NULL,
  `notify_url` varchar(255) NOT NULL,
  `return_url` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `pid` varchar(50) NOT NULL DEFAULT '0',
  `out_time` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `pay_amount` decimal(14,2) NOT NULL DEFAULT '0.00',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  `complete_time` int(11) NOT NULL COMMENT '完成时间',
  `amount` decimal(14,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_order`
--

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

--
-- Table structure for table `far_order_goods`
--

DROP TABLE IF EXISTS `far_order_goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_order_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trade_no` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `contact` varchar(255) NOT NULL,
  `card_id` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `goods_id` int(11) NOT NULL,
  `goods_type` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `pay_amount` decimal(14,2) NOT NULL DEFAULT '0.00',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  `complete_time` int(11) NOT NULL COMMENT '完成时间',
  `out_time` int(11) NOT NULL,
  `amount` decimal(14,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_order_goods`
--

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

--
-- Table structure for table `far_qrcode`
--

DROP TABLE IF EXISTS `far_qrcode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_qrcode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(255) NOT NULL COMMENT '图片地址',
  `qrcode` varchar(255) NOT NULL COMMENT '二维码信息',
  `amount` decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类别0微信1支付宝',
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_qrcode`
--

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

--
-- Table structure for table `far_sms_style`
--

DROP TABLE IF EXISTS `far_sms_style`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_sms_style` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) NOT NULL COMMENT '内容',
  `type` tinyint(1) DEFAULT '0' COMMENT '类别0掉线1商品',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_sms_style`
--

LOCK TABLES `far_sms_style` WRITE;
/*!40000 ALTER TABLE `far_sms_style` DISABLE KEYS */;
INSERT INTO `far_sms_style` VALUES (1,'掉线了兄弟',0),(2,'发货了兄弟',1);
/*!40000 ALTER TABLE `far_sms_style` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `far_user_pay`
--

DROP TABLE IF EXISTS `far_user_pay`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_user_pay` (
  `user_id` int(11) NOT NULL,
  `alipay_cookie` text NOT NULL,
  `code` varchar(255) NOT NULL,
  `alipay_id` varchar(255) NOT NULL COMMENT 'appid',
  `order_validity` varchar(255) NOT NULL COMMENT '订单有效期',
  `wechat_nickname` varchar(255) NOT NULL COMMENT '微信昵称',
  `wechat_name` varchar(255) NOT NULL COMMENT '微信实名',
  `wxpay_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '微信开关',
  `alipay_status` tinyint(1) DEFAULT '0' COMMENT '支付宝开关',
  `code_key` varchar(255) NOT NULL COMMENT 'KEY',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_user_pay`
--

LOCK TABLES `far_user_pay` WRITE;
/*!40000 ALTER TABLE `far_user_pay` DISABLE KEYS */;
INSERT INTO `far_user_pay` VALUES (1,'','wtsp0mpei','','180','','',1,1,'8qfmqog8gpwjo6ja');
/*!40000 ALTER TABLE `far_user_pay` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `far_website`
--

DROP TABLE IF EXISTS `far_website`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `far_website` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '网站名',
  `descr` varchar(255) NOT NULL COMMENT '描述',
  `keywords` varchar(255) NOT NULL COMMENT '关键字',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `reason` varchar(255) NOT NULL COMMENT '关闭理由',
  `statistics` varchar(255) NOT NULL COMMENT '统计代码',
  `copyright` varchar(255) NOT NULL COMMENT '版权代码',
  `filing` varchar(255) NOT NULL COMMENT '备案号',
  `email` varchar(255) NOT NULL COMMENT '邮箱',
  `qq` varchar(255) NOT NULL COMMENT 'QQ',
  `downcode` varchar(255) NOT NULL COMMENT '首页信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `far_website`
--

LOCK TABLES `far_website` WRITE;
/*!40000 ALTER TABLE `far_website` DISABLE KEYS */;
INSERT INTO `far_website` VALUES (1,'个人赞助平台','个人赞助平台','个人赞助平台',1,'','个人赞助平台','个人赞助平台','京A0000000','aa@aa.com','123456','爱发赞助平台欢迎您的到来');
/*!40000 ALTER TABLE `far_website` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'www_106pan_com'
--

--
-- Dumping routines for database 'www_106pan_com'
--
/*!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 2021-10-30 21:33:44
