robot
/
2019_04_23.sql

# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.17-log)
# Database: robot
# Generation Time: 2019-04-22 18:12:23 +0000
# ************************************************************


/*!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 */;
/*!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 */;


# Dump of table admin
# ------------------------------------------------------------

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `id` bigint(20) NOT NULL,
  `admin_type_enum` int(11) DEFAULT NULL,
  `city_id` bigint(20) DEFAULT NULL,
  `passwd` varchar(255) DEFAULT NULL,
  `province_id` bigint(20) DEFAULT NULL,
  `status` bit(1) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;

INSERT INTO `admin` (`id`, `admin_type_enum`, `city_id`, `passwd`, `province_id`, `status`, `username`)
VALUES
	(1,1,2,'1',NULL,NULL,'1');

/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table company
# ------------------------------------------------------------

DROP TABLE IF EXISTS `company`;

CREATE TABLE `company` (
  `id` bigint(20) NOT NULL,
  `area_id` varchar(255) DEFAULT NULL COMMENT '所在城市',
  `city_id` varchar(255) DEFAULT NULL,
  `company_type` varchar(255) DEFAULT NULL COMMENT '1 学校　2　机构',
  `contact_person` varchar(255) DEFAULT NULL COMMENT '联系人',
  `contact_tel` varchar(255) DEFAULT NULL COMMENT '联系电话',
  `create_time` varchar(255) DEFAULT NULL COMMENT '创建时间',
  `invoice_header` varchar(255) DEFAULT NULL COMMENT '发票抬头',
  `invoice_tax_no` varchar(255) DEFAULT NULL COMMENT '发票税号',
  `name` varchar(255) DEFAULT NULL COMMENT '单位简称',
  `province_id` varchar(255) DEFAULT NULL,
  `status` bit(1) DEFAULT NULL COMMENT '有效标志',
  `update_time` varchar(255) DEFAULT NULL COMMENT '更新时间',
  `zhi_zhao` varchar(255) DEFAULT NULL COMMENT '营业执照名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `company` WRITE;
/*!40000 ALTER TABLE `company` DISABLE KEYS */;

INSERT INTO `company` (`id`, `area_id`, `city_id`, `company_type`, `contact_person`, `contact_tel`, `create_time`, `invoice_header`, `invoice_tax_no`, `name`, `province_id`, `status`, `update_time`, `zhi_zhao`)
VALUES
	(3164,NULL,NULL,'1',NULL,NULL,NULL,NULL,'','濮阳领越科教',NULL,NULL,NULL,''),
	(3156,NULL,NULL,'1',NULL,NULL,NULL,NULL,'','1号创客空间',NULL,NULL,NULL,''),
	(3146,NULL,NULL,'0',NULL,NULL,NULL,NULL,'','濮阳市油田第十中学',NULL,NULL,NULL,''),
	(3112,NULL,NULL,'0',NULL,NULL,NULL,NULL,'12410900417546754H','濮阳市第二实验小学',NULL,NULL,NULL,'濮阳市第二实验小学'),
	(3071,NULL,NULL,'0',NULL,NULL,NULL,NULL,'','清丰县明月湖小学',NULL,NULL,NULL,''),
	(3099,NULL,NULL,'0',NULL,NULL,NULL,NULL,'12410902417575272X','濮阳市华龙区高级中学',NULL,NULL,NULL,'濮阳市华龙区高级中学'),
	(3039,NULL,NULL,'0',NULL,NULL,NULL,NULL,'12410928417650025B','濮阳县第三中学',NULL,NULL,NULL,'濮阳县第三中学'),
	(3059,NULL,NULL,'0',NULL,NULL,NULL,NULL,'12410900MB0T5219XC','濮阳市开德中学',NULL,NULL,NULL,'濮阳市开德中学'),
	(3022,NULL,NULL,'0',NULL,NULL,NULL,NULL,'1241090267167126x4','河南省濮阳市华龙区实验小学',NULL,NULL,NULL,'濮阳市华龙区实验小学'),
	(3003,NULL,NULL,'0',NULL,NULL,NULL,NULL,'','濮阳市油田第一小学',NULL,NULL,NULL,''),
	(2986,NULL,NULL,'0',NULL,NULL,NULL,NULL,'12410900672860580W','濮阳市油田第七小学',NULL,NULL,NULL,'濮阳市油田第七小学'),
	(2963,NULL,NULL,'0',NULL,NULL,NULL,NULL,'124109007982244593','濮阳市油田第五小学',NULL,NULL,NULL,'濮阳市油田第五小学'),
	(2935,NULL,NULL,'0',NULL,NULL,NULL,NULL,'12410900417547968H','濮阳市第三中学',NULL,NULL,NULL,'濮阳市第三中学'),
	(2898,NULL,NULL,'0',NULL,NULL,NULL,NULL,'124109026716715697','濮阳市华龙区第八中学',NULL,NULL,NULL,'濮阳市华龙区第八中学'),
	(2925,NULL,NULL,'1',NULL,NULL,NULL,NULL,'','濮阳市我的小伙伴电子科技有限公司',NULL,NULL,NULL,''),
	(2847,NULL,NULL,'0',NULL,NULL,NULL,NULL,'','濮阳市第一中学',NULL,NULL,NULL,''),
	(2830,NULL,NULL,'1',NULL,NULL,NULL,NULL,'','河南省濮阳市乐创教育科技有限公司',NULL,NULL,NULL,''),
	(2817,NULL,NULL,'1',NULL,NULL,NULL,NULL,'','濮阳罗伯特机器人教育',NULL,NULL,NULL,''),
	(2802,NULL,NULL,'0',NULL,NULL,NULL,NULL,'124109226609301825','清丰县诚睦路小学',NULL,NULL,NULL,'清丰县诚睦路小学');

/*!40000 ALTER TABLE `company` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table dt_area
# ------------------------------------------------------------

DROP TABLE IF EXISTS `dt_area`;

CREATE TABLE `dt_area` (
  `id` bigint(20) NOT NULL,
  `area_code` varchar(255) DEFAULT NULL,
  `area_name` varchar(255) DEFAULT NULL,
  `area_parent_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `dt_area` WRITE;
/*!40000 ALTER TABLE `dt_area` DISABLE KEYS */;

INSERT INTO `dt_area` (`id`, `area_code`, `area_name`, `area_parent_id`)
VALUES
	(1,'2','郑州',410000),
	(2,'1','bbbb',2);

/*!40000 ALTER TABLE `dt_area` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table hibernate_sequence
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hibernate_sequence`;

CREATE TABLE `hibernate_sequence` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `hibernate_sequence` WRITE;
/*!40000 ALTER TABLE `hibernate_sequence` DISABLE KEYS */;

INSERT INTO `hibernate_sequence` (`next_val`)
VALUES
	(3208),
	(3208),
	(3208),
	(3208),
	(3208),
	(3208),
	(3208),
	(3208),
	(3208),
	(3208),
	(3208),
	(3208);

/*!40000 ALTER TABLE `hibernate_sequence` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table jiao_fei
# ------------------------------------------------------------

DROP TABLE IF EXISTS `jiao_fei`;

CREATE TABLE `jiao_fei` (
  `id` bigint(20) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `value` float DEFAULT NULL,
  `team_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK1xuvl3fr30vet1krvf4k8813e` (`team_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


# Dump of table project
# ------------------------------------------------------------

DROP TABLE IF EXISTS `project`;

CREATE TABLE `project` (
  `id` bigint(20) NOT NULL,
  `bao_ming_end_time` datetime DEFAULT NULL,
  `bao_ming_start_time` datetime DEFAULT NULL,
  `city_id` bigint(20) DEFAULT NULL,
  `descr` varchar(255) DEFAULT NULL,
  `fu_dao_count` int(11) DEFAULT NULL,
  `project_class_enum` int(11) DEFAULT NULL,
  `project_end_time` datetime DEFAULT NULL,
  `status` bit(1) DEFAULT NULL,
  `team_member_count` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `project_level_enum` int(10) DEFAULT NULL COMMENT '级别',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `project` WRITE;
/*!40000 ALTER TABLE `project` DISABLE KEYS */;

INSERT INTO `project` (`id`, `bao_ming_end_time`, `bao_ming_start_time`, `city_id`, `descr`, `fu_dao_count`, `project_class_enum`, `project_end_time`, `status`, `team_member_count`, `name`, `project_level_enum`)
VALUES
	(2801,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'智能服务员（B1）',NULL),
	(2822,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WRO常规赛（B类）',NULL),
	(2829,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FLL机器人工程挑战赛（A类）',NULL),
	(2846,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'教育机器人工程创新赛（A类）',NULL),
	(2863,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'vex-iq工程创新赛（B类）',NULL),
	(2873,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'智能擂台（C2）',NULL),
	(2889,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'精准投篮（C1）',NULL),
	(2919,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'教育机器人工程创新赛（B类）',NULL),
	(2962,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'机器人综合技能比赛(A类)',NULL),
	(2994,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'无人机工程挑战赛（B类）',NULL);

/*!40000 ALTER TABLE `project` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table project_class_enum
# ------------------------------------------------------------

DROP TABLE IF EXISTS `project_class_enum`;

CREATE TABLE `project_class_enum` (
  `code` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `project_id` int(10) DEFAULT NULL COMMENT '项目id',
  PRIMARY KEY (`code`),
  KEY `FKr649v0mt1bduaqi4fkdtm9o55` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


# Dump of table project_level
# ------------------------------------------------------------

DROP TABLE IF EXISTS `project_level`;

CREATE TABLE `project_level` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `project_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKlnr0mlqtu04v2n0rp3m88cpk4` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


# Dump of table team
# ------------------------------------------------------------

DROP TABLE IF EXISTS `team`;

CREATE TABLE `team` (
  `id` bigint(20) NOT NULL,
  `area_id` bigint(20) DEFAULT NULL,
  `city_id` bigint(20) DEFAULT NULL,
  `class1id` bigint(20) DEFAULT NULL,
  `confirm_status` bit(1) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `fapiao_status` bit(1) DEFAULT NULL,
  `group_type` int(11) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `project_class_enum` int(11) DEFAULT NULL,
  `province_id` bigint(20) DEFAULT NULL,
  `team_name` varchar(255) DEFAULT NULL,
  `template_id` bigint(20) DEFAULT NULL,
  `xuan_ba` bit(1) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `jiao_fei_id` bigint(20) DEFAULT NULL,
  `project_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKq7becd703i1w0ry1jxy15qxid` (`company_id`),
  KEY `FK6dnc27skjyhokuilu913xgb09` (`jiao_fei_id`),
  KEY `FKp6ovpc4soflfcjbafch33w2ky` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `team` WRITE;
/*!40000 ALTER TABLE `team` DISABLE KEYS */;

INSERT INTO `team` (`id`, `area_id`, `city_id`, `class1id`, `confirm_status`, `create_time`, `fapiao_status`, `group_type`, `phone`, `project_class_enum`, `province_id`, `team_name`, `template_id`, `xuan_ba`, `company_id`, `jiao_fei_id`, `project_id`)
VALUES
	(2803,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'诚睦机器人一队',NULL,NULL,2802,NULL,2801),
	(2808,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'诚睦机器人二队',NULL,NULL,2802,NULL,2801),
	(2811,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'诚睦机器人三队',NULL,NULL,2802,NULL,2801),
	(2814,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'诚睦机器人四队',NULL,NULL,2802,NULL,2801),
	(2818,NULL,2,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'罗伯特机器人一队',NULL,NULL,2817,NULL,2801),
	(2823,NULL,2,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'罗伯特机器人五队',NULL,NULL,2817,NULL,2822),
	(2831,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'乐创机器人一队',NULL,NULL,2830,NULL,2829),
	(2835,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'乐创机器人二队',NULL,NULL,2830,NULL,2822),
	(2840,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'罗伯特机器人三队',NULL,NULL,2817,NULL,2801),
	(2843,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'罗伯特机器人二队',NULL,NULL,2817,NULL,2801),
	(2848,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学一队',NULL,NULL,2847,NULL,2846),
	(2853,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学二队',NULL,NULL,2847,NULL,2846),
	(2857,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学三队',NULL,NULL,2847,NULL,2846),
	(2860,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学四队',NULL,NULL,2847,NULL,2846),
	(2864,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学iq一队',NULL,NULL,2847,NULL,2863),
	(2867,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学iq队',NULL,NULL,2847,NULL,2863),
	(2870,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学iq三队',NULL,NULL,2847,NULL,2863),
	(2874,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学擂台赛一队',NULL,NULL,2847,NULL,2873),
	(2877,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学擂台赛二队',NULL,NULL,2847,NULL,2873),
	(2880,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学擂台赛三队',NULL,NULL,2847,NULL,2873),
	(2883,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳市第一中学擂台赛四队',NULL,NULL,2847,NULL,2873),
	(2886,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'罗伯特机器人四队',NULL,NULL,2817,NULL,2801),
	(2890,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'乐创机器人三队',NULL,NULL,2830,NULL,2889),
	(2894,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'罗伯特机器人六队',NULL,NULL,2817,NULL,2822),
	(2899,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'华龙区八中一队',NULL,NULL,2898,NULL,2801),
	(2904,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'华龙区八中二队',NULL,NULL,2898,NULL,2801),
	(2907,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'华龙区八中三队',NULL,NULL,2898,NULL,2889),
	(2910,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'华龙区八中四队',NULL,NULL,2898,NULL,2846),
	(2913,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'华龙区八中五队',NULL,NULL,2898,NULL,2801),
	(2916,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'华龙区八中六队',NULL,NULL,2898,NULL,2889),
	(2920,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'华龙区八中七队',NULL,NULL,2898,NULL,2919),
	(2922,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'华龙区八中八队',NULL,NULL,2898,NULL,2846),
	(2926,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'濮阳小伙伴机器人一队',NULL,NULL,2925,NULL,2873),
	(2930,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳小伙伴机器人二队',NULL,NULL,2925,NULL,2801),
	(2933,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳小伙伴机器人三队',NULL,NULL,2925,NULL,2801),
	(2936,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳市第三中学一队',NULL,NULL,2935,NULL,2846),
	(2941,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳市第三中学二队',NULL,NULL,2935,NULL,2846),
	(2946,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳市第三中学三队',NULL,NULL,2935,NULL,2846),
	(2950,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳市第三中学四队',NULL,NULL,2935,NULL,2846),
	(2953,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳市第三中学五队',NULL,NULL,2935,NULL,2846),
	(2956,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳市第三中学六队',NULL,NULL,2935,NULL,2846),
	(2959,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳市第三中学七队',NULL,NULL,2935,NULL,2846),
	(2964,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第五小学一队',NULL,NULL,2963,NULL,2962),
	(2969,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第五小学二队',NULL,NULL,2963,NULL,2863),
	(2972,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第五小学三队',NULL,NULL,2963,NULL,2863),
	(2975,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第五小学四队',NULL,NULL,2963,NULL,2801),
	(2980,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第五小学五队',NULL,NULL,2963,NULL,2801),
	(2983,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第五小学六队',NULL,NULL,2963,NULL,2801),
	(2987,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第七小学一队',NULL,NULL,2986,NULL,2801),
	(2991,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第七小学二队',NULL,NULL,2986,NULL,2801),
	(2995,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第七小学三队',NULL,NULL,2986,NULL,2994),
	(2997,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第七小学四队',NULL,NULL,2986,NULL,2994),
	(2999,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第七小学五队',NULL,NULL,2986,NULL,2994),
	(3001,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市油田第七小学六队',NULL,NULL,2986,NULL,2994),
	(3004,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'油田一小一队',NULL,NULL,3003,NULL,2846),
	(3008,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'油田一小二队',NULL,NULL,3003,NULL,2846),
	(3010,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'油田一小三队',NULL,NULL,3003,NULL,2846),
	(3013,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'油田一小四队',NULL,NULL,3003,NULL,2846),
	(3016,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'油田一小五队',NULL,NULL,3003,NULL,2846),
	(3019,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'油田一小六队',NULL,NULL,3003,NULL,2846),
	(3023,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市华龙区实验小学一队',NULL,NULL,3022,NULL,2801),
	(3027,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,2,NULL,'濮阳市华龙区实验小学二队',NULL,NULL,3022,NULL,2801),
	(3030,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市华龙区实验小学三队',NULL,NULL,3022,NULL,2801),
	(3033,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市华龙区实验小学四队',NULL,NULL,3022,NULL,2801),
	(3036,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市华龙区实验小学五队',NULL,NULL,3022,NULL,2801),
	(3040,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,2,NULL,'濮阳县第三中学一队',NULL,NULL,3039,NULL,2962),
	(3045,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,2,NULL,'濮阳县第三中学二队',NULL,NULL,3039,NULL,2962),
	(3049,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,2,NULL,'濮阳县第三中学三队',NULL,NULL,3039,NULL,2962),
	(3052,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,2,NULL,'濮阳县第三中学四队',NULL,NULL,3039,NULL,2962),
	(3056,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳县第三中学五队',NULL,NULL,3039,NULL,2801),
	(3060,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'开德中学一队',NULL,NULL,3059,NULL,2801),
	(3065,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'开德中学二队',NULL,NULL,3059,NULL,2801),
	(3068,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'开德中学三队',NULL,NULL,3059,NULL,2801),
	(3072,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'明月湖小学1队',NULL,NULL,3071,NULL,2801),
	(3076,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'开德中学四队',NULL,NULL,3059,NULL,2801),
	(3079,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'明月湖小学二队',NULL,NULL,3071,NULL,2801),
	(3082,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'开德中学五队',NULL,NULL,3059,NULL,2962),
	(3085,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'明月湖小学三队',NULL,NULL,3071,NULL,2801),
	(3088,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'开德中学六队',NULL,NULL,3059,NULL,2962),
	(3091,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'明月湖小学四队',NULL,NULL,3071,NULL,2801),
	(3094,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'明月湖小学五队',NULL,NULL,3071,NULL,2801),
	(3096,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'明月湖小学六队',NULL,NULL,3071,NULL,2801),
	(3100,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳华高一队',NULL,NULL,3099,NULL,2863),
	(3107,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳华高二队',NULL,NULL,3099,NULL,2863),
	(3113,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市第二实验小学机器人一队',NULL,NULL,3112,NULL,2889),
	(3118,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳华高三队',NULL,NULL,3099,NULL,2863),
	(3123,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市第二实验小学机器人二队',NULL,NULL,3112,NULL,2889),
	(3126,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳华高四队',NULL,NULL,3099,NULL,2863),
	(3131,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市第二实验小学机器人三队',NULL,NULL,3112,NULL,2801),
	(3135,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市第二实验小学机器人四队',NULL,NULL,3112,NULL,2801),
	(3138,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市第二实验小学机器人五队',NULL,NULL,3112,NULL,2801),
	(3141,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,2,NULL,'濮阳华高五队',NULL,NULL,3099,NULL,2863),
	(3147,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'濮阳市油田十中小学部一队',NULL,NULL,3146,NULL,2801),
	(3151,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'濮阳市油田十中小学部二队',NULL,NULL,3146,NULL,2801),
	(3157,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'1号创客空间一队',NULL,NULL,3156,NULL,2962),
	(3160,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'1号创客空间二队',NULL,NULL,3156,NULL,2889),
	(3165,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳领越一队',NULL,NULL,3164,NULL,2801),
	(3169,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,1,NULL,'濮阳领越二队',NULL,NULL,3164,NULL,2801),
	(3172,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'1号创客空间三队',NULL,NULL,3156,NULL,2889),
	(3176,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'濮阳市华龙区第八中学九队',NULL,NULL,2898,NULL,2994),
	(3178,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'濮阳领越三队',NULL,NULL,3164,NULL,2889),
	(3182,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,0,NULL,'濮阳市华龙区第八中学十队',NULL,NULL,2898,NULL,2994),
	(3184,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'濮阳领越四队队',NULL,NULL,3164,NULL,2889),
	(3187,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'濮阳领越五队',NULL,NULL,3164,NULL,2801),
	(3190,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'1号创客空间四队',NULL,NULL,3156,NULL,2889),
	(3194,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'濮阳市油田十中一队',NULL,NULL,3146,NULL,2801),
	(3196,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'濮阳市油田第十中学二队',NULL,NULL,3146,NULL,2801),
	(3197,NULL,NULL,NULL,NULL,NULL,b'1',NULL,NULL,1,NULL,'开德中学八队',NULL,NULL,3059,NULL,2822),
	(3201,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'1号创客空间六队',NULL,NULL,3156,NULL,2889),
	(3204,NULL,NULL,NULL,NULL,NULL,b'0',NULL,NULL,0,NULL,'濮阳领越六队',NULL,NULL,3164,NULL,2889);

/*!40000 ALTER TABLE `team` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table team_class
# ------------------------------------------------------------

DROP TABLE IF EXISTS `team_class`;

CREATE TABLE `team_class` (
  `id` bigint(20) NOT NULL,
  `level` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `special` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


# Dump of table team_leader
# ------------------------------------------------------------

DROP TABLE IF EXISTS `team_leader`;

CREATE TABLE `team_leader` (
  `id` bigint(20) NOT NULL,
  `id_card` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `team_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKj8utyfd8itag0ctia1fubd4ox` (`team_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `team_leader` WRITE;
/*!40000 ALTER TABLE `team_leader` DISABLE KEYS */;

INSERT INTO `team_leader` (`id`, `id_card`, `name`, `phone`, `team_id`)
VALUES
	(2807,NULL,'杨  蕾','18939309996',2814),
	(2821,NULL,'谢少雨','16639769249',2886),
	(2827,NULL,'樊海红','',3197),
	(2828,NULL,'崔祖铭','18639313414',2894),
	(2834,NULL,'张成普','13839393000',2835),
	(2839,NULL,'朱英辉','15139330616',2890),
	(2852,NULL,'李征，吴凤伟，姜云红','13721799503',2883),
	(2893,NULL,'谢朝阳','15603935665',2890),
	(2902,NULL,'杨雪杰','13839360289',3176),
	(2903,NULL,'贾戟震','15936778506',3182),
	(2929,NULL,'郭卫强','18236037258',2933),
	(2939,NULL,'杨焕可','13939306073',2953),
	(2940,NULL,'陈良楚','13673018808',2959),
	(2944,NULL,'李振滢','13683939421',2950),
	(2945,NULL,'赵银铃','13839312823',2959),
	(2949,NULL,'陈红霞','13721765662',2946),
	(2967,NULL,'赵聪聪','16639338569',2972),
	(2968,NULL,'王  勇','13613930357',2972),
	(2978,NULL,'郭  爽','15083261693',2983),
	(2979,NULL,'刘  畅','18238310356',2983),
	(2990,NULL,'王  勇','13839377330',3001),
	(3007,NULL,'王星洲 王海燕','13721751978',3019),
	(3026,NULL,'李少纯','13939370315',3036),
	(3043,NULL,'王冠华','18739340009',3056),
	(3044,NULL,'李相庚','13839373756',3056),
	(3048,NULL,'郭亚楠','13721750667',3201),
	(3055,NULL,'潘彦党','18639940205',3201),
	(3063,NULL,'樊海红','13683932371',3088),
	(3064,NULL,'万会敏','18703932913',3088),
	(3075,NULL,'朱大力','18939331283',3096),
	(3105,NULL,'张学鹏','13633939801',3141),
	(3106,NULL,'程向党','15333939990',3141),
	(3116,NULL,'王  华','13700802627',3138),
	(3117,NULL,'张光宇','15903936216',3138),
	(3134,NULL,'崔存英','15893268500',3135),
	(3150,NULL,'赵书斌 岳志培','13213938977',3147),
	(3154,NULL,'吴建全','15839327519',3196),
	(3155,NULL,'赵书斌','13213938997',3151),
	(3163,NULL,'郭亚楠','15838351067',3160),
	(3168,NULL,'刘礼洲','15893869795',3187),
	(3175,NULL,'岳伟伟','15139359188',3182),
	(3181,NULL,'马腾飞','18939305678',3184),
	(3193,NULL,'梁少杰','19939305140',3190),
	(3195,NULL,'赵书斌','18238338997',3194),
	(3200,NULL,'张淑营','15083291957',3197),
	(3207,NULL,'刘 威','18639391013',3204);

/*!40000 ALTER TABLE `team_leader` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table team_member
# ------------------------------------------------------------

DROP TABLE IF EXISTS `team_member`;

CREATE TABLE `team_member` (
  `id` bigint(20) NOT NULL,
  `id_card` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `school` varchar(255) DEFAULT NULL,
  `sex` int(11) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `team_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK9ubp79ei4tv4crd0r9n7u5i6e` (`team_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `team_member` WRITE;
/*!40000 ALTER TABLE `team_member` DISABLE KEYS */;

INSERT INTO `team_member` (`id`, `id_card`, `name`, `school`, `sex`, `size`, `team_id`)
VALUES
	(2804,'410922200811053836','王铭哲',NULL,1,0,2803),
	(2805,'410922200812150312','李晴天',NULL,1,3,2803),
	(2806,'','',NULL,1,4,3204),
	(2809,'410922200808041615','许庆铭',NULL,1,0,2808),
	(2810,'410922200905190057','陈思达',NULL,1,1,2808),
	(2812,'410922200803046257','关嘉乐',NULL,1,1,2811),
	(2813,'410922200811100954','高  尚',NULL,1,0,2811),
	(2815,'410922200806084910','郎子腾',NULL,1,1,2814),
	(2816,'410922200809294112','程鸿昌',NULL,1,0,2814),
	(2819,'410926200712100110','李豪钰',NULL,1,3,2818),
	(2820,'410902200711307629','麻晓瑶',NULL,1,3,2818),
	(2824,'411621200706180639','陈旭',NULL,1,3,2823),
	(2825,'410902200608090839','马境远',NULL,1,1,2823),
	(2826,'410928200504260091','邢郅睿',NULL,1,3,2823),
	(2832,'410901200409290532','李西晟',NULL,1,3,2831),
	(2833,'410901200504262011','高宇翔',NULL,1,3,2831),
	(2836,'410928200702240016','陈  灏',NULL,1,1,2835),
	(2837,'410928200710252535','王子亿',NULL,1,1,2835),
	(2838,'410902200911250014','张逸骞',NULL,1,0,2835),
	(2841,'410902200805050510','张涵茗',NULL,1,0,2840),
	(2842,'410902200806225036','吴正则',NULL,1,1,2840),
	(2844,'410902200610015010','王俊博',NULL,1,1,2843),
	(2845,'410902200707144513','孟恒远',NULL,1,1,2843),
	(2849,'410902200507278015','张少瀚',NULL,1,3,2848),
	(2850,'41092720040817201X','刘翼璋',NULL,1,3,2848),
	(2851,'410902200605154075','赵飞涵',NULL,1,1,2848),
	(2854,'410902200503274017','冯昊铭',NULL,1,3,2853),
	(2855,'410901200508104053','王谦',NULL,1,1,2853),
	(2856,'41090220050805403x','肖则名',NULL,1,1,2853),
	(2858,'410902200608018052','王琰',NULL,1,1,2857),
	(2859,'410902200606034016','刘豫阳',NULL,1,1,2857),
	(2861,'410902200606034518','赵博文',NULL,1,3,2860),
	(2862,'410922200612220013','王耀',NULL,1,1,2860),
	(2865,'410902200508114514','范乙宏',NULL,1,1,2864),
	(2866,'410902200509234518','刘子郁',NULL,1,3,2864),
	(2868,'41090120041031401X','张炜康',NULL,1,3,2867),
	(2869,'410901200410234036','乔路翔',NULL,1,3,2867),
	(2871,'410922200410154978','张依昂',NULL,1,3,2870),
	(2872,'410902200510085572','王若麒',NULL,1,3,2870),
	(2875,'410902200707064038','丁颂阳',NULL,1,1,2874),
	(2876,'410902200706134014','许子鑫',NULL,1,3,2874),
	(2878,'410922200510183530','陈卓',NULL,1,1,2877),
	(2879,'410902200604264037','程奕凯',NULL,1,1,2877),
	(2881,'410902200605144010','李雨诺',NULL,1,3,2880),
	(2882,'410902200607181114','张文博',NULL,1,3,2880),
	(2884,'410902200608010018','韩宗轩',NULL,1,3,2883),
	(2885,'410922200704262712','刘志崇',NULL,1,3,2883),
	(2887,'410902201001250116','封博文',NULL,1,3,2886),
	(2888,'410922201004170010','李松岭',NULL,1,1,2886),
	(2891,'41092820090720705X','王梓恒',NULL,1,0,2890),
	(2892,'410902201011040219','张家珲',NULL,1,0,2890),
	(2895,'410902200509280530','陈宇轩',NULL,1,4,2894),
	(2896,'410922200609195435','苑钟頔',NULL,1,3,2894),
	(2897,'410902200511020543','麻晓君',NULL,1,3,2894),
	(2900,'410928200803066627','王祯诚',NULL,1,0,2899),
	(2901,'410728200806190040','葛琳依',NULL,1,1,2899),
	(2905,'410926200709265088','丁  慧',NULL,1,0,2904),
	(2906,'410928200712222428','马晗笑',NULL,1,1,2904),
	(2908,'410928200712036799','吴仪康',NULL,1,0,2907),
	(2909,'410928200711300041','吉  玉',NULL,1,0,2907),
	(2911,'410902200801078081','李梦瑶',NULL,1,1,2910),
	(2912,'410928200709286340','张晓娜',NULL,1,1,2910),
	(2914,'410902200507204526','戈怡渲',NULL,1,1,2913),
	(2915,'410926200507211727','索  彤',NULL,1,1,2913),
	(2917,'410901200412281549','赵宸好',NULL,1,1,2916),
	(2918,'410928200604296016','杜家壮',NULL,1,1,2916),
	(2921,'410527200604280075','朱耀雯',NULL,1,1,2920),
	(2923,'410928200409255120','张莹莹',NULL,1,1,2922),
	(2924,'410928200608246120','程晓鑫',NULL,1,1,2922),
	(2927,'410902201003120016','郭丰玮',NULL,1,0,2926),
	(2928,'410902201107290116','李成钰',NULL,1,0,2926),
	(2931,'410928200601192158','安中阳',NULL,1,3,2930),
	(2932,'410922200908286476','张祯裕',NULL,1,1,2930),
	(2934,'41092820060425211X','张迪',NULL,1,3,2933),
	(2937,'410901200501214014','张  立',NULL,1,3,2936),
	(2938,'410902200603104015','霍思维',NULL,1,1,2936),
	(2942,'410928200411180949','娄雨婷',NULL,1,1,2941),
	(2943,'410901200408194530','张昊田',NULL,1,3,2941),
	(2947,'410527200507300054','赵贺宇',NULL,1,1,2946),
	(2948,'410527200507300038','赵贺航',NULL,1,3,2946),
	(2951,'410902200604025546','白盛丹',NULL,1,1,2950),
	(2952,'410928200607230928','管晓灿',NULL,1,1,2950),
	(2954,'410902200604090022','梁路语',NULL,1,1,2953),
	(2955,'410902200604158023','贺佳蓓',NULL,1,1,2953),
	(2957,'410901200412074013','南祥临',NULL,1,3,2956),
	(2958,'41090220060205401X','吕懿恒',NULL,1,3,2956),
	(2960,'410901200501210064','陈  榆',NULL,1,3,2959),
	(2961,'410902200701168020','万建荷',NULL,1,1,2959),
	(2965,'41092220089235016','张世鹏',NULL,1,3,2964),
	(2966,'410621200908115033','张艺博',NULL,1,0,2964),
	(2970,'410902200805060516','黄博奕',NULL,1,1,2969),
	(2971,'410902200902100831','朱子莫',NULL,1,1,2969),
	(2973,'41090220090113057X','殷嘉翰',NULL,1,3,2972),
	(2974,'41092220090629005X','王文煊',NULL,1,1,2972),
	(2976,'410902200812310595','韩宇翔',NULL,1,1,2975),
	(2977,'410902200903210039','王卓立',NULL,1,1,2975),
	(2981,'410902200905124513','裴嘉祥',NULL,1,1,2980),
	(2982,'410922201001020471','刘浩宇',NULL,1,0,2980),
	(2984,'421083200809040039','黄馨文',NULL,1,1,2983),
	(2985,'410902201005090017','张泽彬',NULL,1,0,2983),
	(2988,'410928200801072118','褚博昕',NULL,1,3,2987),
	(2989,'410928200804062118','陈允森',NULL,1,1,2987),
	(2992,'410928200610172116','王运威',NULL,1,1,2991),
	(2993,'410928200806096637','张子轩',NULL,1,1,2991),
	(2996,'410928200902101811','张书傲',NULL,1,0,2995),
	(2998,'410928200801182165','王  雪',NULL,1,0,2997),
	(3000,'410928200906106775','刘德治',NULL,1,0,2999),
	(3002,'410902200905060513','李常达',NULL,1,0,3001),
	(3005,'410902200711085018','陈浩鲲',NULL,1,1,3004),
	(3006,'410902200711255013','张廷睿',NULL,1,1,3004),
	(3009,'410902200908275034','刘钱隆',NULL,1,1,3008),
	(3011,'410902200906215038','蒋松霖',NULL,1,1,3010),
	(3012,'410902200801205036','彭浩宸',NULL,1,1,3010),
	(3014,'410902200804115036','梁奕宸',NULL,1,1,3013),
	(3015,'410902200803065014','李泊锴',NULL,1,1,3013),
	(3017,'410902200907185053','陈耀宇',NULL,1,1,3016),
	(3018,'410902200806042010','崔天哲',NULL,1,0,3016),
	(3020,'410928200808297045','杨子昕',NULL,1,1,3019),
	(3021,'410902200808020843','邵钰涵',NULL,1,1,3019),
	(3024,'410928200710180973','张一弛',NULL,1,1,3023),
	(3025,'410902200705035030','季兴达',NULL,1,1,3023),
	(3028,'410527200801064611','崔义让',NULL,1,0,3027),
	(3029,'410902200706155093','赵晓哲',NULL,1,0,3027),
	(3031,'410902200711045016','张珂嘉',NULL,1,0,3030),
	(3032,'410922200711125812','吴延鑫',NULL,1,1,3030),
	(3034,'410928200805090911','张  博',NULL,1,1,3033),
	(3035,'410902200709195031','王乙林',NULL,1,1,3033),
	(3037,'410902200712140525','王嘉琪',NULL,1,1,3036),
	(3038,'410902200709295040','刘  悦',NULL,1,1,3036),
	(3041,'41092620021117121X','候  松',NULL,1,1,3040),
	(3042,'410928200312215114','田晓荣',NULL,1,3,3040),
	(3046,'410928200404213335','李海博',NULL,1,0,3045),
	(3047,'410928200403060058','刘永博',NULL,1,3,3045),
	(3050,'41092820020307181X','李  轲',NULL,1,1,3049),
	(3051,'410928200309022717','李  社',NULL,1,3,3049),
	(3053,'410928200212223619','王培豪',NULL,1,3,3052),
	(3054,'410928200405135113','魏振濮',NULL,1,3,3052),
	(3057,'410928200504130617','胡子阳',NULL,1,3,3056),
	(3058,'410928200505060032','林重森',NULL,1,3,3056),
	(3061,'410922200403024913','陈令鑫',NULL,1,1,3060),
	(3062,'410902200605105011','冯瑞钊',NULL,1,3,3060),
	(3066,'41092220060505001x','张怡宾',NULL,1,3,3065),
	(3067,'410928200707030915','高天祺',NULL,1,3,3065),
	(3069,'410928200706141891','朱浩天',NULL,1,1,3068),
	(3070,'410902200703288018','黄宇涵',NULL,1,1,3068),
	(3073,'410922200811230011','马浩然',NULL,1,1,3072),
	(3074,'410922200709145937','关一鸣',NULL,1,1,3072),
	(3077,'410901200505241116','杨守稳',NULL,1,1,3076),
	(3078,'410902200502191113','张昊阳',NULL,1,3,3076),
	(3080,'410922200906260619','肖天博',NULL,1,0,3079),
	(3081,'410922200904054133','孙亚旭',NULL,1,0,3079),
	(3083,'410922200511093158','任宗迪',NULL,1,1,3082),
	(3084,'410926200612090816','鲁冠辰',NULL,1,3,3082),
	(3086,'41092220081213091X','李嘉豪',NULL,1,0,3085),
	(3087,'410922200903074917','张驷坦',NULL,1,0,3094),
	(3089,'410902200510251112','班伟彪',NULL,1,1,3088),
	(3090,'410928200607281397','程一鸣',NULL,1,1,3088),
	(3092,'410922200711026259','李启东',NULL,1,1,3091),
	(3093,'410922200808280931','袁一哲',NULL,1,0,3091),
	(3095,'410922201001100332','王子墨',NULL,1,0,3094),
	(3097,'410922200802010033','裴英达',NULL,1,0,3096),
	(3098,'410922200711220051','李玉卓',NULL,1,1,3096),
	(3101,'410901200412245011','杨子喻',NULL,1,3,3100),
	(3102,'410902200509185015','王庆烨',NULL,1,1,3100),
	(3103,'410902200604175018','张  涵',NULL,1,1,3100),
	(3104,'410902200604275019','胡旭睿',NULL,1,1,3100),
	(3108,'410901200504015010','谷建辛',NULL,1,1,3107),
	(3109,'41090120050418501X','朱昕鸣',NULL,1,1,3107),
	(3110,'410928200505250055','李天睿',NULL,1,3,3107),
	(3111,'41090220060827403X','郑  好',NULL,1,1,3107),
	(3114,'41092820090108671X','王一川',NULL,1,1,3113),
	(3115,'410902200808214031','吕佳明',NULL,1,0,3113),
	(3119,'210922200411184813','马昕涛',NULL,1,1,3118),
	(3120,'410727200507187312','赵云翔',NULL,1,1,3118),
	(3121,'410902200610235056','郑仪桉',NULL,1,1,3118),
	(3122,'410902200609034011','贾昊霖',NULL,1,1,3118),
	(3124,'410902200804251118','李明育',NULL,1,0,3123),
	(3125,'41092320080202735X','高家轩',NULL,1,0,3123),
	(3127,'410901200404200817','王鹏飞',NULL,1,4,3126),
	(3128,'410728200510157479','孙睿哲',NULL,1,4,3126),
	(3129,'410922200507070017','张钊瑞',NULL,1,1,3126),
	(3130,'410902200601085017','乔相卜',NULL,1,3,3126),
	(3132,'410902200808164011','郭良旭',NULL,1,1,3131),
	(3133,'410902200805224031','姬熙越',NULL,1,0,3131),
	(3136,'410902200908127533','陈家宝',NULL,1,0,3135),
	(3137,'410923200901202432','张浩哲',NULL,1,0,3135),
	(3139,'410902200809164013','亢家楷',NULL,1,0,3138),
	(3140,'410902200811304011','谢翰程',NULL,1,0,3138),
	(3142,'410901200310245029','程晓艺',NULL,1,3,3141),
	(3143,'410922200403310020','刘江帆',NULL,1,1,3141),
	(3144,'410923200206020039','韩海川',NULL,1,4,3141),
	(3145,'410928200204170932','岳宗鑫',NULL,1,4,3141),
	(3148,'401902200901137771','薛  寒',NULL,1,0,3194),
	(3149,'410902200907017623','万千琦',NULL,1,0,3194),
	(3152,'410902200902238099','李文沐',NULL,1,0,3196),
	(3153,'410902200906130819','郭堃霖',NULL,1,0,3196),
	(3158,'410902200803252039','杨子峥',NULL,1,1,3157),
	(3159,'410526200712120582','张琪菲',NULL,1,0,3157),
	(3161,'410928200902280012','刘畅',NULL,1,1,3160),
	(3162,'410928201203220074','谢宇汎',NULL,1,0,3160),
	(3166,'410922200706030317','李名振',NULL,1,1,3165),
	(3167,'410926200701050015','王晨磊',NULL,1,1,3165),
	(3170,'410902200705284512','韩飞阳',NULL,1,1,3169),
	(3171,'41092820070723685X','马浩天',NULL,1,1,3169),
	(3173,'410928201002120173','张宇航',NULL,1,0,3172),
	(3174,'410527200706030034','刘清泉',NULL,1,0,3172),
	(3177,'410923200608313010','王义天',NULL,1,1,3176),
	(3179,'410902201012190032','袁子瑜',NULL,1,1,3178),
	(3180,'410902200908277857','冯楚原',NULL,1,0,3178),
	(3183,'410902200710257615','管啸天',NULL,1,0,3182),
	(3185,'410902200807084511','张盛尧',NULL,1,1,3184),
	(3186,'410902201006190298','石旗胜',NULL,1,0,3184),
	(3188,'410902200711210018','卞乙博',NULL,1,1,3187),
	(3189,'410902201007190476','王世博',NULL,1,0,3187),
	(3191,'410902200912110216','张容赫',NULL,1,0,3190),
	(3192,'411302200909230258','李辉林',NULL,1,1,3190),
	(3198,'410927200603151011','李庆可',NULL,1,3,3197),
	(3199,'410922200512084536','蒋令一',NULL,1,1,3197),
	(3202,'410902200904212351','陈  钊',NULL,1,0,3201),
	(3203,'4109202200805141519','赵怀周',NULL,1,1,3201),
	(3205,'410902200901051150','李明昱',NULL,1,0,3204),
	(3206,'410902200901210836','边跃达',NULL,1,0,3204);

/*!40000 ALTER TABLE `team_member` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table team_score
# ------------------------------------------------------------

DROP TABLE IF EXISTS `team_score`;

CREATE TABLE `team_score` (
  `id` bigint(20) NOT NULL,
  `lun_ci` varchar(255) DEFAULT NULL,
  `score` float DEFAULT NULL,
  `status` bit(1) DEFAULT NULL,
  `team_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK7fo50glu340ofrfqc7y3xawii` (`team_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


# Dump of table user
# ------------------------------------------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` bigint(20) NOT NULL,
  `area_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `passwd` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `province_id` int(11) DEFAULT NULL,
  `account` varchar(255) DEFAULT NULL COMMENT '登录账号',
  `admin_type_enum` int(10) DEFAULT NULL COMMENT '管理员权限',
  `real_name` varchar(255) DEFAULT NULL COMMENT '真实姓名',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;

INSERT INTO `user` (`id`, `area_id`, `city_id`, `company_id`, `passwd`, `phone`, `province_id`, `account`, `admin_type_enum`, `real_name`)
VALUES
	(69,2,2,NULL,'12345','15190471622',410000,'wdj1990',1,'汪定俊');

/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;


/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */;