text: -- MySQL dump 10.13  Distrib 5.6.50, for Linux (x86_64)
  --
  -- Host: localhost    Database: wm_pinfanfan_cn
  -- ------------------------------------------------------
  -- 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 utf8mb4 */;
  /*!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 `admin_menu`
  --
  
  DROP TABLE IF EXISTS `admin_menu`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_menu` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` int(11) NOT NULL DEFAULT '0',
    `order` int(11) NOT NULL DEFAULT '0',
    `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `uri` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `permission` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admin_menu`
  --
  
  LOCK TABLES `admin_menu` WRITE;
  /*!40000 ALTER TABLE `admin_menu` DISABLE KEYS */;
  INSERT INTO `admin_menu` VALUES (1,0,1,'Dashboard','fa-bar-chart','/',NULL,NULL,NULL),(2,0,2,'Admin','fa-tasks',NULL,NULL,NULL,'2020-06-12 14:43:08'),(3,2,3,'Users','fa-users','auth/users',NULL,NULL,NULL),(4,2,4,'Roles','fa-user','auth/roles',NULL,NULL,NULL),(5,2,5,'Permission','fa-ban','auth/permissions',NULL,NULL,NULL),(6,2,6,'Menu','fa-bars','auth/menu',NULL,NULL,NULL),(7,2,7,'Operation log','fa-history','auth/logs',NULL,NULL,NULL),(37,0,0,'小程序CPS项目管理','fa-bars','project','*','2020-09-19 10:35:12','2020-09-19 10:35:12'),(38,0,0,'友链管理','fa-bars','link','*','2020-09-19 10:35:39','2020-09-19 10:35:39');
  /*!40000 ALTER TABLE `admin_menu` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `admin_operation_log`
  --
  
  DROP TABLE IF EXISTS `admin_operation_log`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_operation_log` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `input` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `admin_operation_log_user_id_index` (`user_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=603 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admin_operation_log`
  --
  
  --
  -- Table structure for table `admin_permissions`
  --
  
  DROP TABLE IF EXISTS `admin_permissions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_permissions` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `http_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `http_path` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `admin_permissions_name_unique` (`name`),
    UNIQUE KEY `admin_permissions_slug_unique` (`slug`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admin_permissions`
  --
  
  LOCK TABLES `admin_permissions` WRITE;
  /*!40000 ALTER TABLE `admin_permissions` DISABLE KEYS */;
  INSERT INTO `admin_permissions` VALUES (1,'All permission','*','','*',NULL,NULL),(2,'Dashboard','dashboard','GET','/',NULL,NULL),(3,'Login','auth.login','','/auth/login\r\n/auth/logout',NULL,NULL),(4,'User setting','auth.setting','GET,PUT','/auth/setting',NULL,NULL),(5,'Auth management','auth.management','','/auth/roles\r\n/auth/permissions\r\n/auth/menu\r\n/auth/logs',NULL,NULL);
  /*!40000 ALTER TABLE `admin_permissions` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `admin_role_menu`
  --
  
  DROP TABLE IF EXISTS `admin_role_menu`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_role_menu` (
    `role_id` int(11) NOT NULL,
    `menu_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    KEY `admin_role_menu_role_id_menu_id_index` (`role_id`,`menu_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admin_role_menu`
  --
  
  LOCK TABLES `admin_role_menu` WRITE;
  /*!40000 ALTER TABLE `admin_role_menu` DISABLE KEYS */;
  INSERT INTO `admin_role_menu` VALUES (1,2,NULL,NULL),(1,11,NULL,NULL),(1,26,NULL,NULL),(2,26,NULL,NULL),(1,31,NULL,NULL),(1,32,NULL,NULL),(1,33,NULL,NULL),(1,35,NULL,NULL),(3,35,NULL,NULL),(1,36,NULL,NULL),(3,36,NULL,NULL),(1,37,NULL,NULL),(1,38,NULL,NULL);
  /*!40000 ALTER TABLE `admin_role_menu` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `admin_role_permissions`
  --
  
  DROP TABLE IF EXISTS `admin_role_permissions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_role_permissions` (
    `role_id` int(11) NOT NULL,
    `permission_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    KEY `admin_role_permissions_role_id_permission_id_index` (`role_id`,`permission_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admin_role_permissions`
  --
  
  LOCK TABLES `admin_role_permissions` WRITE;
  /*!40000 ALTER TABLE `admin_role_permissions` DISABLE KEYS */;
  INSERT INTO `admin_role_permissions` VALUES (1,1,NULL,NULL),(2,2,NULL,NULL),(3,2,NULL,NULL);
  /*!40000 ALTER TABLE `admin_role_permissions` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `admin_role_users`
  --
  
  DROP TABLE IF EXISTS `admin_role_users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_role_users` (
    `role_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    KEY `admin_role_users_role_id_user_id_index` (`role_id`,`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admin_role_users`
  --
  
  LOCK TABLES `admin_role_users` WRITE;
  /*!40000 ALTER TABLE `admin_role_users` DISABLE KEYS */;
  INSERT INTO `admin_role_users` VALUES (1,1,NULL,NULL);
  /*!40000 ALTER TABLE `admin_role_users` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `admin_roles`
  --
  
  DROP TABLE IF EXISTS `admin_roles`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_roles` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `admin_roles_name_unique` (`name`),
    UNIQUE KEY `admin_roles_slug_unique` (`slug`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admin_roles`
  --
  
  LOCK TABLES `admin_roles` WRITE;
  /*!40000 ALTER TABLE `admin_roles` DISABLE KEYS */;
  INSERT INTO `admin_roles` VALUES (1,'Administrator','administrator','2019-10-13 04:42:08','2019-10-13 04:42:08'),(2,'HotAdmin','HotAdmin','2020-06-11 08:17:36','2020-06-11 08:17:36'),(3,'TaiCiAdmin','TaiCiAdmin','2020-07-03 05:17:42','2020-07-03 05:17:42');
  /*!40000 ALTER TABLE `admin_roles` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `admin_user_permissions`
  --
  
  DROP TABLE IF EXISTS `admin_user_permissions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_user_permissions` (
    `user_id` int(11) NOT NULL,
    `permission_id` int(11) NOT NULL,
    `created_at` timestamp NOT NULL,
    `updated_at` timestamp NOT NULL,
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `app_id` int(11) NOT NULL COMMENT '应用权限',
    PRIMARY KEY (`id`),
    KEY `admin_user_permissions_user_id_permission_id_index` (`user_id`,`permission_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admin_user_permissions`
  --
  
  LOCK TABLES `admin_user_permissions` WRITE;
  /*!40000 ALTER TABLE `admin_user_permissions` DISABLE KEYS */;
  /*!40000 ALTER TABLE `admin_user_permissions` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `admin_users`
  --
  
  DROP TABLE IF EXISTS `admin_users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `username` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `admin_users_username_unique` (`username`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admin_users`
  --
  
  LOCK TABLES `admin_users` WRITE;
  /*!40000 ALTER TABLE `admin_users` DISABLE KEYS */;
  INSERT INTO `admin_users` VALUES (1,'admin','$2y$10$bjOWE3KKGMrKjsz0f4Cuy.rNQb/IrdjxkkyNpby3aBbAFHNZszW0C','Administrator',NULL,'h9AC0Z9L9oKRy5afx9kqY8yBw3HGRjduqoDf4AYgNApRRJuvSK3sxP8Zpo7A','2019-10-13 04:42:07','2019-10-13 04:42:07');
  /*!40000 ALTER TABLE `admin_users` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `chihe_coupon_log`
  --
  
  DROP TABLE IF EXISTS `chihe_coupon_log`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `chihe_coupon_log` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) DEFAULT NULL,
    `project_id` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `chihe_coupon_log`
  --
  
  LOCK TABLES `chihe_coupon_log` WRITE;
  /*!40000 ALTER TABLE `chihe_coupon_log` DISABLE KEYS */;
  /*!40000 ALTER TABLE `chihe_coupon_log` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `chihe_project`
  --
  
  DROP TABLE IF EXISTS `chihe_project`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `chihe_project` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(255) DEFAULT NULL,
    `image` varchar(255) DEFAULT NULL,
    `description` varchar(1000) DEFAULT NULL,
    `created_at` datetime NOT NULL,
    `status` tinyint(4) NOT NULL,
    `sort` int(11) NOT NULL,
    `app_id` varchar(255) NOT NULL,
    `path` varchar(2000) DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `chihe_project`
  --
  
  LOCK TABLES `chihe_project` WRITE;
  /*!40000 ALTER TABLE `chihe_project` DISABLE KEYS */;
  INSERT INTO `chihe_project` VALUES (1,'美团56元外卖红包天天领','images/meituan-packet.png',NULL,'2020-08-11 07:40:19',1,998,'wxde8ac0a21135c07d','/index/pages/h5/h5?weburl=https%3A%2F%2Frunion.meituan.com%2Furl%3Fkey%3De87f63660eb85d97c9e93087c8ed9217%26url%3Dhttps%253A%252F%252Fi.meituan.com%252Fawp%252Fhfe%252Fblock%252Fa945391288b790d558b7%252F78716%252Findex.html%253Fappkey%253De87f63660eb85d97c9e93087c8ed9217%253Aapp15899670407user18675510732mm1607090953%26sid%3Dapp15899670407user18675510732mm1607090953&f_token=1&f_userId=1','2021-01-06 08:25:31'),(2,'饿了么外卖天天大红包','images/7d3158638219499b8204c44562a7665b.png',NULL,'2020-08-11 07:42:41',1,999,'wxece3a9a4c82f58c9','pages/sharePid/web/index?scene=s.click.ele.me%2FXAMiSuu','2021-01-06 08:24:44'),(5,'花小猪打车首单无门槛立减券14元','images/d398f1920bb5b0585bddb1826f2c2ee3.png',NULL,'2020-08-19 08:46:24',2,997,'wxd98a20e429ce834b','kfpub/pages/gift?jump_home=1&g_channel=5768fc5198f53fecabc3a519c4f69c89&channel=2001002001&xpsid=82c91ccdf9f14b2d99ddbe737b03ae54&share_code=7177329&dchn=Y6lx2x&channel_id=2001002001','2021-01-06 08:27:13'),(6,'美团商超生鲜33元红包天天领','images/73a363a88e3e115eadc8e25c69817370.png',NULL,'2020-08-11 07:40:19',1,33,'wxde8ac0a21135c07d','/index/pages/h5/h5?weburl=https%3A%2F%2Frunion.meituan.com%2Furl%3Fkey%3De87f63660eb85d97c9e93087c8ed9217%26url%3Dhttps%253A%252F%252Fi.meituan.com%252Fawp%252Fhfe%252Fblock%252F652c4b9d8a2425a98ca5%252F92207%252Findex.html%253Fappkey%253De87f63660eb85d97c9e93087c8ed9217%253Aapp15899670407user18675510732mm1607090953%26sid%3Dapp15899670407user18675510732mm1607090953&f_token=1&f_userId=1','2021-01-06 08:24:18'),(8,'饿了么商超生鲜大红包','images/ca9aea2e9ad089f504dd01dfc2b9c90a.png',NULL,'2020-12-05 10:16:22',1,12,'wxece3a9a4c82f58c9','pages/sharePid/web/index?scene=s.click.ele.me%2FI0aIdtu','2021-01-06 08:22:46');
  /*!40000 ALTER TABLE `chihe_project` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `chihe_project_copy`
  --
  
  DROP TABLE IF EXISTS `chihe_project_copy`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `chihe_project_copy` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(255) DEFAULT NULL,
    `image` varchar(255) DEFAULT NULL,
    `description` varchar(1000) DEFAULT NULL,
    `created_at` datetime NOT NULL,
    `status` tinyint(4) NOT NULL,
    `sort` int(11) NOT NULL,
    `app_id` varchar(255) NOT NULL,
    `path` varchar(255) DEFAULT NULL,
    `updated_at` datetime 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 `chihe_project_copy`
  /*!40000 ALTER TABLE `chihe_project_copy` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `chihe_subscribe`
  --
  
  DROP TABLE IF EXISTS `chihe_subscribe`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `chihe_subscribe` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `created_at` datetime NOT NULL,
    `template_id` varchar(255) NOT NULL,
    `is_send` tinyint(4) NOT NULL,
    `send_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8mb4;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `chihe_subscribe`
  --
  
  LOCK TABLES `chihe_subscribe` WRITE;
  /*!40000 ALTER TABLE `chihe_subscribe` DISABLE KEYS */;
  /*!40000 ALTER TABLE `chihe_subscribe` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `chihe_user`
  --
  
  DROP TABLE IF EXISTS `chihe_user`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `chihe_user` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `open_id` varchar(255) NOT NULL,
    `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `is_deleted` tinyint(4) NOT NULL DEFAULT '2',
    `expired_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `nickname` varchar(255) NOT NULL,
    `avatar` varchar(255) NOT NULL,
    `share_num` int(11) NOT NULL DEFAULT '0',
    `ref_id` int(11) NOT NULL DEFAULT '0' COMMENT '推荐人ID',
    `city` varchar(255) NOT NULL DEFAULT '',
    `gender` tinyint(4) NOT NULL DEFAULT '0',
    `get_coupon_num` int(11) NOT NULL DEFAULT '0' COMMENT '0试用，1会员， 2炒鸡会员',
    `subscribe_num` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=645 DEFAULT CHARSET=utf8mb4;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `chihe_user`
  --
  
  --
  -- Table structure for table `link`
  --
  
  DROP TABLE IF EXISTS `link`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `link` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `app_name` varchar(255) NOT NULL,
    `description` varchar(2155) DEFAULT NULL,
    `path` varchar(1255) DEFAULT NULL,
    `sort` smallint(6) DEFAULT NULL,
    `app_id` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1正常2禁用',
    `logo` varchar(1255) NOT NULL,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `link`
  --
  
  LOCK TABLES `link` WRITE;
  /*!40000 ALTER TABLE `link` DISABLE KEYS */;
  INSERT INTO `link` VALUES (20,'抖印小助手','短视频去视频配音',NULL,5,'wxbdefed10c266bd83','2020-08-21 09:27:00',2,'images/2f67a8208b8e7a6418a36ec0a65e8758.png','2020-11-09 00:32:14'),(22,'Youtube视频下载','Youtube、Instagram视频下载',NULL,2,'wxc52480e547027e4e','2020-06-20 15:19:34',2,'images/logo.png','2020-11-09 00:32:12');
  /*!40000 ALTER TABLE `link` 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 2021-01-06  8:27:31
  