 UNLOCK TABLES;
 
 --
+-- Temporary view structure for view `doherty_case1`
+--
+
+DROP TABLE IF EXISTS `doherty_case1`;
+/*!50001 DROP VIEW IF EXISTS `doherty_case1`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `doherty_case1` AS SELECT 
+ 1 AS `full_name`,
+ 1 AS `user_id`,
+ 1 AS `followers`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary view structure for view `doherty_case10`
+--
+
+DROP TABLE IF EXISTS `doherty_case10`;
+/*!50001 DROP VIEW IF EXISTS `doherty_case10`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `doherty_case10` AS SELECT 
+ 1 AS `full_name`,
+ 1 AS `player_user_id`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary view structure for view `doherty_case2`
+--
+
+DROP TABLE IF EXISTS `doherty_case2`;
+/*!50001 DROP VIEW IF EXISTS `doherty_case2`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `doherty_case2` AS SELECT 
+ 1 AS `full_name`,
+ 1 AS `player_user_id`,
+ 1 AS `H`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary view structure for view `doherty_case3`
+--
+
+DROP TABLE IF EXISTS `doherty_case3`;
+/*!50001 DROP VIEW IF EXISTS `doherty_case3`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `doherty_case3` AS SELECT 
+ 1 AS `full_name`,
+ 1 AS `G`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary view structure for view `doherty_case4`
+--
+
+DROP TABLE IF EXISTS `doherty_case4`;
+/*!50001 DROP VIEW IF EXISTS `doherty_case4`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `doherty_case4` AS SELECT 
+ 1 AS `full_name`,
+ 1 AS `ERA`,
+ 1 AS `team`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary view structure for view `doherty_case5`
+--
+
+DROP TABLE IF EXISTS `doherty_case5`;
+/*!50001 DROP VIEW IF EXISTS `doherty_case5`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `doherty_case5` AS SELECT 
+ 1 AS `full_name`,
+ 1 AS `player_user_id`,
+ 1 AS `HR`,
+ 1 AS `RBI`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary view structure for view `doherty_case6`
+--
+
+DROP TABLE IF EXISTS `doherty_case6`;
+/*!50001 DROP VIEW IF EXISTS `doherty_case6`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `doherty_case6` AS SELECT 
+ 1 AS `full_name`,
+ 1 AS `MAX(dob)`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary view structure for view `doherty_case7`
+--
+
+DROP TABLE IF EXISTS `doherty_case7`;
+/*!50001 DROP VIEW IF EXISTS `doherty_case7`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `doherty_case7` AS SELECT 
+ 1 AS `full_name`,
+ 1 AS `player_user_id`,
+ 1 AS `team_abbrev`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary view structure for view `doherty_case8`
+--
+
+DROP TABLE IF EXISTS `doherty_case8`;
+/*!50001 DROP VIEW IF EXISTS `doherty_case8`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `doherty_case8` AS SELECT 
+ 1 AS `team_name`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary view structure for view `doherty_case9`
+--
+
+DROP TABLE IF EXISTS `doherty_case9`;
+/*!50001 DROP VIEW IF EXISTS `doherty_case9`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `doherty_case9` AS SELECT 
+ 1 AS `MIN(Account.join_date)`*/;
+SET character_set_client = @saved_cs_client;
+
+--
 -- Table structure for table `pitching`
 --
 

INSERT INTO `team` VALUES ('WAS','Nationals','Washington Nationals','Nationals Park','1500 South Capitol Street, SE Washington, DC 20003-1507','National League','East');
/*!40000 ALTER TABLE `team` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

  `HR` int(11) NOT NULL DEFAULT '0',
  `BB` int(11) NOT NULL DEFAULT '0',
  `SO` int(11) NOT NULL DEFAULT '0',
  `BAOpp` double DEFAULT NULL,
  `ERA` double DEFAULT NULL,
  `IBB` int(11) DEFAULT NULL,
  `WP` int(11) NOT NULL DEFAULT '0',
  `HBP` int(11) DEFAULT NULL,
