-- MySQL dump 10.13  Distrib 5.7.18, for osx10.12 (x86_64)
--
-- Host: localhost    Database: basketball
-- ------------------------------------------------------
-- Server version	5.7.18

/*!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 `common_invitations`
--

DROP TABLE IF EXISTS `common_invitations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `common_invitations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `invite_openid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邀请人的唯一标识',
  `invite_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邀请人名',
  `invite_phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邀请人的电话',
  `invited_openid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '被邀请人的唯一标识',
  `accept_id` int(11) NOT NULL DEFAULT '0' COMMENT '接受的应战id',
  `invite_virtue_point` int(11) NOT NULL DEFAULT '0' COMMENT '邀请人球德评分',
  `invite_skill_point` int(11) NOT NULL DEFAULT '0' COMMENT '邀请人技术评分',
  `invited_virtue_point` int(11) NOT NULL DEFAULT '0' COMMENT '被邀请人球德评分',
  `invited_skill_point` int(11) NOT NULL DEFAULT '0' COMMENT '被邀请人技术评分',
  `invite_is_end` int(11) NOT NULL DEFAULT '0' COMMENT '邀请人是否点击结束',
  `invited_is_end` int(11) NOT NULL DEFAULT '0' COMMENT '被邀请人是否点击结束',
  `is_drawback` int(11) NOT NULL DEFAULT '0' COMMENT '1为撤销,2为过期',
  `drawback_reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'None' COMMENT '撤销理由',
  `match_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '格式跟create_time一样',
  `address_des` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '地址描述',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信小程序接口参数位置名称name',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信小程序接口参数详细地址address',
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信小程序接口参数纬度latitude',
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信小程序接口参数精度longitude',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `common_invitations`
--

LOCK TABLES `common_invitations` WRITE;
/*!40000 ALTER TABLE `common_invitations` DISABLE KEYS */;
INSERT INTO `common_invitations` VALUES (1,'oW3ED0fjtjJea5v_BQYgzBC7lMEo','阿陆','1264871263','oW3ED0fjtjJea5v_BQYgzBC7lMEo',1,0,0,0,0,0,0,0,'None','2017-10-27 01:11:41','A区篮球场','广工','篮球场','123','42','2017-10-15 17:11:41','2017-10-15 17:11:41'),(2,'oW3ED0fjtjJea5v_BQYgzBC7lMEo','阿陆','1264871263','oW3ED0fjtjJea5v_BQYgzBC7lMEo',2,0,0,0,0,0,0,0,'None','2017-10-28 01:11:41','B区足球场','广美','小树林','156','34','2017-10-15 17:11:41','2017-10-15 17:11:41'),(3,'oW3ED0fjtjJea5v_BQYgzBC7lMEo','阿陆','1264871263','0',0,0,0,0,0,0,0,0,'None','2017-10-30 01:11:41','小蛮腰','市中心','体育西路','24','35','2017-10-15 17:11:41','2017-10-15 17:11:41'),(4,'oW3ED0fjtjJea5v_BQYgzBC7lMEo','阿陆','2423234124','0',0,0,0,0,0,0,0,1,'对手太菜','2017-10-31 01:11:41','北京','王府井','小巷子','25','24','2017-10-15 17:11:41','2017-10-15 17:11:41'),(5,'oW3ED0fjtjJea5v_BQYgzBC7lMEo','阿陆','2423234124','oW3ED0fjtjJea5v_BQYgzBC7lMEo',3,2,2,4,5,1,1,0,'None','2017-10-27 01:11:41','华工','教学楼','女厕所','25','23','2017-10-15 17:11:41','2017-10-15 17:11:41'),(6,'oW3ED0fjtjJea5v_BQYgzBC7lMEo','阿陆','2343252342','oW3ED0fjtjJea5v_BQYgzBC7lMEo',4,4,4,3,3,1,1,0,'None','2017-10-26 01:11:41','中大','饭堂','小窗口','26','132','2017-10-15 17:11:41','2017-10-15 17:11:41'),(7,'oW3ED0fjtjJea5v_BQYgzBC7lMEo','阿陆','2312413412','oW3ED0fjtjJea5v_BQYgzBC7lMEo',0,0,0,0,0,0,0,1,'None','2017-10-31 01:11:41','广工','二路','打饭','24','34','2017-10-15 17:11:41','2017-10-15 17:11:41'),(8,'oW3ED0fjtjJea5v_BQYgzBC7lMEo','阿陆','2312413412','oW3ED0fjtjJea5v_BQYgzBC7lMEo',0,0,0,0,0,0,0,2,'None','2017-10-31 01:11:41','广美','游泳池怕是','美女堆','123','42','2017-10-15 17:11:41','2017-10-15 17:11:41');
/*!40000 ALTER TABLE `common_invitations` 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 2017-10-30  1:53:45