-- MySQL dump 10.13  Distrib 8.0.20, for macos10.15 (x86_64)
--
-- Host: localhost    Database: mytools
-- ------------------------------------------------------
-- Server version	8.0.21

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

DROP TABLE IF EXISTS `abc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `abc` (
  `day` date DEFAULT NULL,
  `temper` int DEFAULT NULL,
  `wind` int DEFAULT NULL,
  `forecast` char(20) DEFAULT NULL,
  `city` char(20) DEFAULT NULL,
  `state` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `abc`
--

LOCK TABLES `abc` WRITE;
/*!40000 ALTER TABLE `abc` DISABLE KEYS */;
INSERT INTO `abc` VALUES ('2021-04-03',78,-12,NULL,'se','wa'),('2021-08-04',50,12,'Snow','','mn'),('2021-09-02',45,99,'','sf','ca'),('2021-09-03',15,12,'Snow','chi','il');
/*!40000 ALTER TABLE `abc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `abc2`
--

DROP TABLE IF EXISTS `abc2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `abc2` (
  `day` date DEFAULT NULL,
  `temper` int DEFAULT NULL,
  `wind` int DEFAULT NULL,
  `forecast` char(20) DEFAULT NULL,
  `city` char(20) DEFAULT NULL,
  `state` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `abc2`
--

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

--
-- Table structure for table `account`
--

DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account` (
  `acct_num` int DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `account`
--

LOCK TABLES `account` WRITE;
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
INSERT INTO `account` VALUES (1000,1.00),(1000,2.00),(1000,3.00);
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `update_avg_val` AFTER INSERT ON `account` FOR EACH ROW SET @sum = @sum + NEW.amount */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;

--
-- Table structure for table `ar_mytools`
--

DROP TABLE IF EXISTS `ar_mytools`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ar_mytools` (
  `cust_id` int DEFAULT NULL,
  `po_id` int DEFAULT NULL,
  `PURCH_DATE` date DEFAULT NULL,
  `PAID_DATE` date DEFAULT NULL,
  `PAST_30` date DEFAULT NULL,
  `PAST_60` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ar_mytools`
--

LOCK TABLES `ar_mytools` WRITE;
/*!40000 ALTER TABLE `ar_mytools` DISABLE KEYS */;
INSERT INTO `ar_mytools` VALUES (1000,12500,'2021-12-01','2021-12-15',NULL,NULL),(1000,12600,'2022-01-05','2022-01-10',NULL,NULL);
/*!40000 ALTER TABLE `ar_mytools` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `average_val`
--

DROP TABLE IF EXISTS `average_val`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `average_val` (
  `average` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `average_val`
--

LOCK TABLES `average_val` WRITE;
/*!40000 ALTER TABLE `average_val` DISABLE KEYS */;
INSERT INTO `average_val` VALUES (2);
/*!40000 ALTER TABLE `average_val` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `books`
--

DROP TABLE IF EXISTS `books`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `books` (
  `book_id` int DEFAULT NULL,
  `book_type` varchar(10) DEFAULT NULL,
  `book_title` varchar(20) DEFAULT NULL,
  `rating` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `books`
--

LOCK TABLES `books` WRITE;
/*!40000 ALTER TABLE `books` DISABLE KEYS */;
INSERT INTO `books` VALUES (100,'tech','book#1',10),(200,'tech','book#2',9),(300,'tech','book#3',8),(400,'tech','book#4',7),(150,'drama','book#1',5),(250,'drama','book#2',4),(350,'drama','book#3',3),(400,'drama','book#4',2);
/*!40000 ALTER TABLE `books` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `child_tbl`
--

DROP TABLE IF EXISTS `child_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `child_tbl` (
  `child_id` int NOT NULL,
  `cust_id` int DEFAULT NULL,
  PRIMARY KEY (`child_id`),
  KEY `cust_id` (`cust_id`),
  CONSTRAINT `child_tbl_ibfk_1` FOREIGN KEY (`cust_id`) REFERENCES `parent_tbl` (`cust_id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `child_tbl`
--

LOCK TABLES `child_tbl` WRITE;
/*!40000 ALTER TABLE `child_tbl` DISABLE KEYS */;
INSERT INTO `child_tbl` VALUES (1200,100),(1300,100),(2500,200),(2600,200);
/*!40000 ALTER TABLE `child_tbl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cities`
--

DROP TABLE IF EXISTS `cities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cities` (
  `country_id` int DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  `city_name` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cities`
--

LOCK TABLES `cities` WRITE;
/*!40000 ALTER TABLE `cities` DISABLE KEYS */;
INSERT INTO `cities` VALUES (1000,10000,'San Francisco'),(1000,11000,'Orlando'),(2000,12000,'Milan'),(3000,13000,'Frankfurt'),(4000,14000,'Vancouver'),(5000,15000,'Mexico City');
/*!40000 ALTER TABLE `cities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `countries`
--

DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `countries` (
  `country_id` int DEFAULT NULL,
  `country_name` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `countries`
--

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` VALUES (1000,'United States'),(2000,'Europe'),(3000,'Canada'),(4000,'Mexico');
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `courses`
--

DROP TABLE IF EXISTS `courses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `courses` (
  `course_id` varchar(20) DEFAULT NULL,
  `cname` varchar(20) DEFAULT NULL,
  `cdept` varchar(20) DEFAULT NULL,
  `credits` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `courses`
--

LOCK TABLES `courses` WRITE;
/*!40000 ALTER TABLE `courses` DISABLE KEYS */;
INSERT INTO `courses` VALUES ('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4),('5010','Calculus 1','Mathematics',4),('5020','Calculus 2','Mathematics',4),('5030','Calculus 3','Mathematics',4),('5040','Topology','Mathematics',5),('5050','Statistics','Mathematics',3),('6000','Economics','Economics',4),('7000','Chemistry','Chemistry',4),('8000','Physics','Physics',4);
/*!40000 ALTER TABLE `courses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `curr_exchange_rate`
--

DROP TABLE IF EXISTS `curr_exchange_rate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `curr_exchange_rate` (
  `from_curr` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `to_curr` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `curr_rate` decimal(8,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `curr_exchange_rate`
--

LOCK TABLES `curr_exchange_rate` WRITE;
/*!40000 ALTER TABLE `curr_exchange_rate` DISABLE KEYS */;
INSERT INTO `curr_exchange_rate` VALUES ('dollar','euro',0.80),('dollar','cana',1.35),('dollar','yen',135.00),('dollar','franc',5.50);
/*!40000 ALTER TABLE `curr_exchange_rate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `currencies`
--

DROP TABLE IF EXISTS `currencies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `currencies` (
  `curr_id` int NOT NULL AUTO_INCREMENT,
  `currency` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `curr_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`curr_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `currencies`
--

LOCK TABLES `currencies` WRITE;
/*!40000 ALTER TABLE `currencies` DISABLE KEYS */;
INSERT INTO `currencies` VALUES (1,'$','dollar'),(2,'¥','yen'),(3,'€','euro'),(4,'£','pound'),(5,'₨','rupee');
/*!40000 ALTER TABLE `currencies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `currency`
--

DROP TABLE IF EXISTS `currency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `currency` (
  `from_country_id` int DEFAULT NULL,
  `source` char(10) DEFAULT NULL,
  `to_country_id` int DEFAULT NULL,
  `dest` char(10) DEFAULT NULL,
  `rate` decimal(8,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `currency`
--

LOCK TABLES `currency` WRITE;
/*!40000 ALTER TABLE `currency` DISABLE KEYS */;
INSERT INTO `currency` VALUES (1000,'USD',2000,'EURO',0.75),(1000,'USD',3000,'YEN',120.00),(1000,'USD',4000,'CAN',1.35),(1000,'USD',5000,'PESO',6.00);
/*!40000 ALTER TABLE `currency` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cust_history`
--

DROP TABLE IF EXISTS `cust_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cust_history` (
  `first_name` varchar(20) DEFAULT NULL,
  `last_name` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cust_history`
--

LOCK TABLES `cust_history` WRITE;
/*!40000 ALTER TABLE `cust_history` DISABLE KEYS */;
INSERT INTO `cust_history` VALUES ('John','Smith');
/*!40000 ALTER TABLE `cust_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customer_json`
--

DROP TABLE IF EXISTS `customer_json`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_json` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer` json DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer_json`
--

LOCK TABLES `customer_json` WRITE;
/*!40000 ALTER TABLE `customer_json` DISABLE KEYS */;
INSERT INTO `customer_json` VALUES (1,'{\"city\": \"Fremont\", \"state\": \"CA\", \"address\": \"123 Main Street\", \"cust_id\": \"1000\", \"zip_code\": \"94123\", \"last_name\": \"Smith\", \"first_name\": \"John\"}'),(2,'{\"city\": \"Fremont\", \"state\": \"CA\", \"address\": \"456 Front Street\", \"cust_id\": \"2000\", \"zip_code\": \"95015\", \"last_name\": \"Jones\", \"first_name\": \"Jane\"}');
/*!40000 ALTER TABLE `customer_json` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customers` (
  `cust_id` int DEFAULT NULL,
  `first_name` varchar(20) DEFAULT NULL,
  `last_name` varchar(20) DEFAULT NULL,
  `home_address` varchar(20) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `state` varchar(20) DEFAULT NULL,
  `zip_code` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customers`
--

LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
INSERT INTO `customers` VALUES (1000,'John','Smith','123 Main St','Fremont','CA','94123'),(2000,'Jane','Jones','456 Front St','Fremont','CA','95015');
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customers2`
--

DROP TABLE IF EXISTS `customers2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customers2` (
  `cust_id` int DEFAULT NULL,
  `first_name` varchar(20) DEFAULT NULL,
  `last_name` varchar(20) DEFAULT NULL,
  `home_address` varchar(20) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `state` varchar(20) DEFAULT NULL,
  `zip_code` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customers2`
--

LOCK TABLES `customers2` WRITE;
/*!40000 ALTER TABLE `customers2` DISABLE KEYS */;
INSERT INTO `customers2` VALUES (1000,'John','Smith','123 Main St','Fremont','CA','94123'),(2000,'Jane','Jones','456 Front St','Fremont','CA','95015'),(3000,'Sara','Smith','789 Other St','Fremont','CA','95043'),(4000,'Dave','Dean','789 Halsted St','Chicago','IL','67123'),(5000,'Kenn','Knuth','1234 Halsted St','Chicago','IL','67345');
/*!40000 ALTER TABLE `customers2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `emp_details`
--

DROP TABLE IF EXISTS `emp_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `emp_details` (
  `emp_id` char(15) DEFAULT NULL,
  `city` char(20) DEFAULT NULL,
  `state` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `emp_details`
--

LOCK TABLES `emp_details` WRITE;
/*!40000 ALTER TABLE `emp_details` DISABLE KEYS */;
INSERT INTO `emp_details` VALUES ('1000','Chicago','Illinois'),('2000','Seattle','Washington'),('3000','Santa Cruz','California'),('4000','Boston','Massachusetts');
/*!40000 ALTER TABLE `emp_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employees`
--

DROP TABLE IF EXISTS `employees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employees` (
  `emp_id` int DEFAULT NULL,
  `mgr_id` int DEFAULT NULL,
  `title` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employees`
--

LOCK TABLES `employees` WRITE;
/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
INSERT INTO `employees` VALUES (1000,2000,'Developer'),(2000,3000,'Project Lead'),(3000,4000,'Dev Manager'),(4000,4000,'Senior Dev Manager');
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fact_events`
--

DROP TABLE IF EXISTS `fact_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fact_events` (
  `id` int DEFAULT NULL,
  `time_id` date DEFAULT NULL,
  `user_id` varchar(20) DEFAULT NULL,
  `cust_id` varchar(20) DEFAULT NULL,
  `client_id` varchar(20) DEFAULT NULL,
  `event_type` varchar(20) DEFAULT NULL,
  `event_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fact_events`
--

LOCK TABLES `fact_events` WRITE;
/*!40000 ALTER TABLE `fact_events` DISABLE KEYS */;
INSERT INTO `fact_events` VALUES (1,'2020-02-28','abcd','delta3','desktop','connected',1);
/*!40000 ALTER TABLE `fact_events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fact_table`
--

DROP TABLE IF EXISTS `fact_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fact_table` (
  `id` int DEFAULT NULL,
  `time_id` date DEFAULT NULL,
  `user_id` varchar(20) DEFAULT NULL,
  `cust_id` varchar(20) DEFAULT NULL,
  `client_id` varchar(20) DEFAULT NULL,
  `event_type` varchar(20) DEFAULT NULL,
  `event_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fact_table`
--

LOCK TABLES `fact_table` WRITE;
/*!40000 ALTER TABLE `fact_table` DISABLE KEYS */;
INSERT INTO `fact_table` VALUES (1,'2020-02-28','abcd','delta3','desktop','connected',1);
/*!40000 ALTER TABLE `fact_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `for_fun`
--

DROP TABLE IF EXISTS `for_fun`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `for_fun` (
  `dept_no` char(4) NOT NULL,
  `dept_name` varchar(40) NOT NULL,
  PRIMARY KEY (`dept_no`),
  UNIQUE KEY `dept_name` (`dept_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `for_fun`
--

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

--
-- Table structure for table `friend_table`
--

DROP TABLE IF EXISTS `friend_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `friend_table` (
  `friend_id` int NOT NULL AUTO_INCREMENT,
  `full_name` varchar(40) NOT NULL,
  `fname` varchar(20) NOT NULL,
  `lname` varchar(20) NOT NULL,
  PRIMARY KEY (`friend_id`),
  KEY `full_name` (`full_name`),
  KEY `friend_lname_fname_idx` (`lname`,`fname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `friend_table`
--

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

--
-- Table structure for table `FRIENDS`
--

DROP TABLE IF EXISTS `FRIENDS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FRIENDS` (
  `id` int NOT NULL,
  `fname` varchar(1000) DEFAULT NULL,
  `lname` varchar(1000) DEFAULT NULL,
  `height` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `FRIENDS`
--

LOCK TABLES `FRIENDS` WRITE;
/*!40000 ALTER TABLE `FRIENDS` DISABLE KEYS */;
INSERT INTO `FRIENDS` VALUES (100,'Jane','Jones',170),(200,'Dave','Smith',160),(300,'Jack','Stone',180);
/*!40000 ALTER TABLE `FRIENDS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `FRIENDS2`
--

DROP TABLE IF EXISTS `FRIENDS2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FRIENDS2` (
  `id` int NOT NULL,
  `xml_str` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `FRIENDS2`
--

LOCK TABLES `FRIENDS2` WRITE;
/*!40000 ALTER TABLE `FRIENDS2` DISABLE KEYS */;
INSERT INTO `FRIENDS2` VALUES (100,'<?xml version=\"1.0\"?><friends>  <friend>    <fname>Jane</fname>    <lname>Jones</lname>    <height>170</height>  </friend>  <friend>    <fname>Dave</fname>    <lname>Smith</lname>    <height>160</height>  </friend>  <friend>    <fname>Jack</fname>    <lname>Stone</lname>    <height>180</height>  </friend></friends>');
/*!40000 ALTER TABLE `FRIENDS2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `heights`
--

DROP TABLE IF EXISTS `heights`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `heights` (
  `id` int DEFAULT NULL,
  `name` char(10) DEFAULT NULL,
  `height` int DEFAULT NULL,
  `room` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `heights`
--

LOCK TABLES `heights` WRITE;
/*!40000 ALTER TABLE `heights` DISABLE KEYS */;
INSERT INTO `heights` VALUES (1,'person1',150,1000),(2,'person2',180,1000),(3,'person3',200,1000),(4,'person4',100,1000),(5,'person5',130,2000),(6,'person6',100,2000),(7,'person7',110,2000),(8,'person8',120,2000);
/*!40000 ALTER TABLE `heights` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoices`
--

DROP TABLE IF EXISTS `invoices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoices` (
  `id` int DEFAULT NULL,
  `amount` int DEFAULT NULL,
  `the_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoices`
--

LOCK TABLES `invoices` WRITE;
/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
INSERT INTO `invoices` VALUES (1000,1000,'2021-10-01'),(1000,300,'2022-11-03'),(1000,400,'2022-12-07'),(2000,2500,'2021-01-08'),(3000,3600,'2022-02-09'),(4000,4700,'2022-03-10');
/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `item_desc`
--

DROP TABLE IF EXISTS `item_desc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_desc` (
  `item_id` int DEFAULT NULL,
  `item_desc` varchar(80) DEFAULT NULL,
  `item_price` decimal(8,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `item_desc`
--

LOCK TABLES `item_desc` WRITE;
/*!40000 ALTER TABLE `item_desc` DISABLE KEYS */;
INSERT INTO `item_desc` VALUES (100,'hammer',20.00),(200,'screwdriver',8.00),(100,'wrench',10.00);
/*!40000 ALTER TABLE `item_desc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `japn1`
--

DROP TABLE IF EXISTS `japn1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `japn1` (
  `emp_id` int NOT NULL AUTO_INCREMENT,
  `fname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `lname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`emp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `japn1`
--

LOCK TABLES `japn1` WRITE;
/*!40000 ALTER TABLE `japn1` DISABLE KEYS */;
INSERT INTO `japn1` VALUES (1,'ひでき','日浦','しちお'),(2,'ももたろ','つよい','かちょ'),(3,'オズワルド','カmポ','悪ガキ'),(4,'東京','日本','すごい！');
/*!40000 ALTER TABLE `japn1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `japn2`
--

DROP TABLE IF EXISTS `japn2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `japn2` (
  `emp_id` int NOT NULL AUTO_INCREMENT,
  `fname` varchar(100) NOT NULL,
  `lname` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL,
  PRIMARY KEY (`emp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `japn2`
--

LOCK TABLES `japn2` WRITE;
/*!40000 ALTER TABLE `japn2` DISABLE KEYS */;
INSERT INTO `japn2` VALUES (1,'hideki','hiura','CTO'),(2,'momotaro','strong','manager'),(3,'oswald','campo','funloving'),(4,'tokyo','japan','awesome!');
/*!40000 ALTER TABLE `japn2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `japn3`
--

DROP TABLE IF EXISTS `japn3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `japn3` (
  `emp_id` int NOT NULL AUTO_INCREMENT,
  `fname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `lname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`emp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `japn3`
--

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

--
-- Table structure for table `japn_emps`
--

DROP TABLE IF EXISTS `japn_emps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `japn_emps` (
  `day` date DEFAULT NULL,
  `fname` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `lname` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `japn_emps`
--

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

--
-- Table structure for table `JOIN_TBL`
--

DROP TABLE IF EXISTS `JOIN_TBL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `JOIN_TBL` (
  `idx_tablea` int DEFAULT NULL,
  `idx_tableb` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `JOIN_TBL`
--

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

--
-- Table structure for table `json1`
--

DROP TABLE IF EXISTS `json1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `json1` (
  `id` int DEFAULT NULL,
  `data` json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `json1`
--

LOCK TABLES `json1` WRITE;
/*!40000 ALTER TABLE `json1` DISABLE KEYS */;
INSERT INTO `json1` VALUES (100,'{\"fname\": \"Jane\", \"lname\": \"Jones\"}'),(200,'{\"fname\": \"Dave\", \"lname\": \"Smith\"}'),(300,'{\"fname\": \"Jack\", \"lname\": \"Stone\"}');
/*!40000 ALTER TABLE `json1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `line3`
--

DROP TABLE IF EXISTS `line3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `line3` (
  `po_id` int DEFAULT NULL,
  `line_id` int DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `item_count` int DEFAULT NULL,
  `item_price` decimal(8,2) DEFAULT NULL,
  `item_tax` decimal(8,2) DEFAULT NULL,
  `item_subtotal` decimal(8,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `line3`
--

LOCK TABLES `line3` WRITE;
/*!40000 ALTER TABLE `line3` DISABLE KEYS */;
INSERT INTO `line3` VALUES (12500,501,100,1,20.00,2.00,22.00),(12500,502,200,2,8.00,1.60,17.60),(12500,503,300,3,10.00,30.00,33.00);
/*!40000 ALTER TABLE `line3` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `line_items`
--

DROP TABLE IF EXISTS `line_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `line_items` (
  `po_id` int DEFAULT NULL,
  `line_id` int DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `item_count` int DEFAULT NULL,
  `item_price` decimal(8,2) DEFAULT NULL,
  `item_tax` decimal(8,2) DEFAULT NULL,
  `item_subtotal` decimal(8,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `line_items`
--

LOCK TABLES `line_items` WRITE;
/*!40000 ALTER TABLE `line_items` DISABLE KEYS */;
INSERT INTO `line_items` VALUES (12500,5001,100,1,20.00,2.00,22.00),(12500,5002,200,2,8.00,1.60,17.60),(12500,5003,300,3,10.00,3.00,33.20);
/*!40000 ALTER TABLE `line_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `line_items2`
--

DROP TABLE IF EXISTS `line_items2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `line_items2` (
  `po_id` int DEFAULT NULL,
  `line_id` int DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `item_count` int DEFAULT NULL,
  `item_price` decimal(8,2) DEFAULT NULL,
  `item_tax` decimal(8,2) DEFAULT NULL,
  `item_subtotal` decimal(8,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `line_items2`
--

LOCK TABLES `line_items2` WRITE;
/*!40000 ALTER TABLE `line_items2` DISABLE KEYS */;
INSERT INTO `line_items2` VALUES (12500,5001,100,1,20.00,2.00,22.00),(12500,5002,200,2,8.00,1.60,17.60),(12500,5003,300,3,10.00,3.00,33.20);
/*!40000 ALTER TABLE `line_items2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `locations`
--

DROP TABLE IF EXISTS `locations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `locations` (
  `country_id` int DEFAULT NULL,
  `country_name` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `locations`
--

LOCK TABLES `locations` WRITE;
/*!40000 ALTER TABLE `locations` DISABLE KEYS */;
INSERT INTO `locations` VALUES (1000,'United States'),(2000,'Europe'),(3000,'Canada'),(4000,'Mexico');
/*!40000 ALTER TABLE `locations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `movie_ratings`
--

DROP TABLE IF EXISTS `movie_ratings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `movie_ratings` (
  `movie_id` int DEFAULT NULL,
  `stars` int DEFAULT NULL,
  `movie_desc` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `movie_ratings`
--

LOCK TABLES `movie_ratings` WRITE;
/*!40000 ALTER TABLE `movie_ratings` DISABLE KEYS */;
INSERT INTO `movie_ratings` VALUES (1000,3,'unrated');
/*!40000 ALTER TABLE `movie_ratings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `my_stats_data`
--

DROP TABLE IF EXISTS `my_stats_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `my_stats_data` (
  `num_val` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `my_stats_data`
--

LOCK TABLES `my_stats_data` WRITE;
/*!40000 ALTER TABLE `my_stats_data` DISABLE KEYS */;
INSERT INTO `my_stats_data` VALUES (2),(5),(7),(9),(9),(37);
/*!40000 ALTER TABLE `my_stats_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mytable`
--

DROP TABLE IF EXISTS `mytable`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mytable` (
  `state` char(20) DEFAULT NULL,
  `reply` char(10) DEFAULT NULL,
  `real_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mytable`
--

LOCK TABLES `mytable` WRITE;
/*!40000 ALTER TABLE `mytable` DISABLE KEYS */;
INSERT INTO `mytable` VALUES ('New York','Yes','2021-09-15'),('New York','no','2021-10-16'),('Illinois','yes','2022-01-17'),('New York','No','2022-02-18');
/*!40000 ALTER TABLE `mytable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `new_items`
--

DROP TABLE IF EXISTS `new_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `new_items` (
  `item_id` int DEFAULT NULL,
  `item_desc` varchar(80) DEFAULT NULL,
  `item_price` decimal(8,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `new_items`
--

LOCK TABLES `new_items` WRITE;
/*!40000 ALTER TABLE `new_items` DISABLE KEYS */;
INSERT INTO `new_items` VALUES (100,'hammer',20.00),(200,'screwdriver',8.00),(100,'wrench',10.00),(400,'pliers',10.00),(500,'ballpeen',20.00),(600,'1/4 inch nails',8.00),(700,'Toolbox S',30.00),(800,'Toolbox M',40.00),(900,'Toolbox L',50.00),(1000,'Handsaw',20.00);
/*!40000 ALTER TABLE `new_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `olympics`
--

DROP TABLE IF EXISTS `olympics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `olympics` (
  `pos` int DEFAULT NULL,
  `country` varchar(20) DEFAULT NULL,
  `medal` varchar(20) DEFAULT NULL,
  `count` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `olympics`
--

LOCK TABLES `olympics` WRITE;
/*!40000 ALTER TABLE `olympics` DISABLE KEYS */;
INSERT INTO `olympics` VALUES (1,'USA','gold',39),(1,'USA','silver',41),(1,'USA','bronze',33),(2,'CHINA','gold',38),(2,'CHINA','silver',32),(2,'CHINA','bronze',18),(3,'JAPAN','gold',27),(3,'JAPAN','silver',14),(3,'JAPAN','bronze',17),(4,'UK','gold',22),(4,'UK','silver',21),(4,'UK','bronze',22),(5,'ROC','gold',20),(5,'ROC','silver',28),(5,'ROC','bronze',23);
/*!40000 ALTER TABLE `olympics` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `parent_tbl`
--

DROP TABLE IF EXISTS `parent_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `parent_tbl` (
  `cust_id` int NOT NULL,
  `cust_name` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`cust_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `parent_tbl`
--

LOCK TABLES `parent_tbl` WRITE;
/*!40000 ALTER TABLE `parent_tbl` DISABLE KEYS */;
INSERT INTO `parent_tbl` VALUES (100,'John Smith'),(200,'Jane Jones');
/*!40000 ALTER TABLE `parent_tbl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pasta_prices`
--

DROP TABLE IF EXISTS `pasta_prices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pasta_prices` (
  `kilos` int DEFAULT NULL,
  `dollars` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pasta_prices`
--

LOCK TABLES `pasta_prices` WRITE;
/*!40000 ALTER TABLE `pasta_prices` DISABLE KEYS */;
INSERT INTO `pasta_prices` VALUES (5,12),(6,16),(7,17),(8,20),(9,22),(10,23),(11,25);
/*!40000 ALTER TABLE `pasta_prices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `people`
--

DROP TABLE IF EXISTS `people`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `people` (
  `fname` varchar(20) DEFAULT NULL,
  `lname` varchar(20) DEFAULT NULL,
  `age` varchar(20) DEFAULT NULL,
  `gender` char(1) DEFAULT NULL,
  `country` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `people`
--

LOCK TABLES `people` WRITE;
/*!40000 ALTER TABLE `people` DISABLE KEYS */;
INSERT INTO `people` VALUES ('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain'),('john','smith','30','m','usa'),('jane','smith','31','f','france'),('jack','jones','32','m','france'),('dave','stone','33','m','italy'),('sara','stein','34','f','germany'),('eddy','bower','35','m','spain');
/*!40000 ALTER TABLE `people` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `people2`
--

DROP TABLE IF EXISTS `people2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `people2` (
  `fname` varchar(20) DEFAULT NULL,
  `lname` varchar(20) DEFAULT NULL,
  `age` varchar(20) DEFAULT NULL,
  `gender` char(1) DEFAULT NULL,
  `country` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `people2`
--

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

--
-- Table structure for table `people_ages`
--

DROP TABLE IF EXISTS `people_ages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `people_ages` (
  `int_ages` int DEFAULT NULL,
  `floor_ages` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `people_ages`
--

LOCK TABLES `people_ages` WRITE;
/*!40000 ALTER TABLE `people_ages` DISABLE KEYS */;
INSERT INTO `people_ages` VALUES (12,12),(46,45),(79,78),(-3,-4);
/*!40000 ALTER TABLE `people_ages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phone_numbers`
--

DROP TABLE IF EXISTS `phone_numbers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `phone_numbers` (
  `phone_val` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phone_numbers`
--

LOCK TABLES `phone_numbers` WRITE;
/*!40000 ALTER TABLE `phone_numbers` DISABLE KEYS */;
INSERT INTO `phone_numbers` VALUES ('2125551212'),('212-555-1212'),('(212)5551212');
/*!40000 ALTER TABLE `phone_numbers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `PIZZA`
--

DROP TABLE IF EXISTS `PIZZA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `PIZZA` (
  `name` enum('Small','Medium','Large') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `PIZZA`
--

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

--
-- Table structure for table `purchase_orders`
--

DROP TABLE IF EXISTS `purchase_orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `purchase_orders` (
  `cust_id` int DEFAULT NULL,
  `po_id` int DEFAULT NULL,
  `purchase_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_orders`
--

LOCK TABLES `purchase_orders` WRITE;
/*!40000 ALTER TABLE `purchase_orders` DISABLE KEYS */;
INSERT INTO `purchase_orders` VALUES (1000,12500,'2021-12-01'),(1000,12600,'2022-12-03'),(1000,12700,'2022-05-07');
/*!40000 ALTER TABLE `purchase_orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchase_orders2`
--

DROP TABLE IF EXISTS `purchase_orders2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `purchase_orders2` (
  `cust_id` int DEFAULT NULL,
  `po_id` int DEFAULT NULL,
  `purchase_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_orders2`
--

LOCK TABLES `purchase_orders2` WRITE;
/*!40000 ALTER TABLE `purchase_orders2` DISABLE KEYS */;
INSERT INTO `purchase_orders2` VALUES (1000,12500,'2021-12-01');
/*!40000 ALTER TABLE `purchase_orders2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `revenue`
--

DROP TABLE IF EXISTS `revenue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `revenue` (
  `rev_date` date DEFAULT NULL,
  `revenue` int DEFAULT NULL,
  `location` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `revenue`
--

LOCK TABLES `revenue` WRITE;
/*!40000 ALTER TABLE `revenue` DISABLE KEYS */;
INSERT INTO `revenue` VALUES ('2021-08-13',1200,'Chicago'),('2021-08-15',1000,'SF'),('2021-09-17',1300,'LA'),('2021-09-18',1800,'LA'),('2021-09-18',1400,'Miami'),('2021-09-19',2000,'Miami');
/*!40000 ALTER TABLE `revenue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sample`
--

DROP TABLE IF EXISTS `sample`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sample` (
  `x` float NOT NULL,
  `y` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sample`
--

LOCK TABLES `sample` WRITE;
/*!40000 ALTER TABLE `sample` DISABLE KEYS */;
INSERT INTO `sample` VALUES (1,2),(2,4),(3,6),(4,9);
/*!40000 ALTER TABLE `sample` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `schedule`
--

DROP TABLE IF EXISTS `schedule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `schedule` (
  `year` varchar(4) DEFAULT NULL,
  `term` varchar(10) DEFAULT NULL,
  `student_id` varchar(20) DEFAULT NULL,
  `course_id` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `schedule`
--

LOCK TABLES `schedule` WRITE;
/*!40000 ALTER TABLE `schedule` DISABLE KEYS */;
INSERT INTO `schedule` VALUES ('2020','SPRING','1010','5010'),('2020','SPRING','1020','5010'),('2020','SUMMER','1020','5020'),('2020','SUMMER','1020','5030'),('2020','FALL','1030','5040'),('2020','FALL','1030','5050'),('2020','FALL','1040','6000'),('2020','FALL','1040','7000'),('2020','FALL','1050','6000'),('2020','FALL','1050','7000'),('2020','FALL','1060','6000'),('2020','FALL','1060','7000');
/*!40000 ALTER TABLE `schedule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scores`
--

DROP TABLE IF EXISTS `scores`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `scores` (
  `age` int DEFAULT NULL,
  `score` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scores`
--

LOCK TABLES `scores` WRITE;
/*!40000 ALTER TABLE `scores` DISABLE KEYS */;
INSERT INTO `scores` VALUES (5,12),(6,16),(7,17),(8,20),(9,22),(10,23),(11,25);
/*!40000 ALTER TABLE `scores` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sentences`
--

DROP TABLE IF EXISTS `sentences`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sentences` (
  `id` int DEFAULT NULL,
  `sentence` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sentences`
--

LOCK TABLES `sentences` WRITE;
/*!40000 ALTER TABLE `sentences` DISABLE KEYS */;
INSERT INTO `sentences` VALUES (10,'sentence one'),(20,'sentence two'),(50,'sentence three');
/*!40000 ALTER TABLE `sentences` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `simple_table`
--

DROP TABLE IF EXISTS `simple_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `simple_table` (
  `friend_id` int NOT NULL AUTO_INCREMENT,
  `full_name` varchar(40) NOT NULL,
  `fname` varchar(20) NOT NULL,
  `lname` varchar(20) NOT NULL,
  PRIMARY KEY (`friend_id`),
  KEY `full_name` (`full_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `simple_table`
--

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

--
-- Table structure for table `sold_items`
--

DROP TABLE IF EXISTS `sold_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sold_items` (
  `region` char(20) DEFAULT NULL,
  `qty` int DEFAULT NULL,
  `sold_price` decimal(8,2) DEFAULT NULL,
  `sold_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sold_items`
--

LOCK TABLES `sold_items` WRITE;
/*!40000 ALTER TABLE `sold_items` DISABLE KEYS */;
INSERT INTO `sold_items` VALUES ('branch1',1,15.00,'2021-12-03'),('branch1',2,10.00,'2021-12-03'),('branch1',3,10.00,'2021-12-03'),('branch2',3,10.00,'2021-12-01'),('branch2',2,10.00,'2021-12-01'),('branch2',1,10.00,'2021-12-01'),('branch1',5,10.00,'2021-11-15'),('branch1',6,10.00,'2021-11-15'),('branch1',8,15.00,'2021-11-15'),('branch1',5,15.00,'2021-11-10'),('branch2',5,10.00,'2021-11-10'),('branch3',5,10.00,'2021-11-10'),('branch1',5,15.00,'2021-11-05'),('branch2',6,10.00,'2021-11-05'),('branch3',8,10.00,'2021-11-05');
/*!40000 ALTER TABLE `sold_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `split_float`
--

DROP TABLE IF EXISTS `split_float`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `split_float` (
  `height` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `split_float`
--

LOCK TABLES `split_float` WRITE;
/*!40000 ALTER TABLE `split_float` DISABLE KEYS */;
INSERT INTO `split_float` VALUES ('12.3'),('45.6'),('78.9'),('-3.4');
/*!40000 ALTER TABLE `split_float` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `students`
--

DROP TABLE IF EXISTS `students`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `students` (
  `student_id` varchar(20) DEFAULT NULL,
  `fname` varchar(20) DEFAULT NULL,
  `lname` varchar(20) DEFAULT NULL,
  `age` int DEFAULT NULL,
  `gender` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `students`
--

LOCK TABLES `students` WRITE;
/*!40000 ALTER TABLE `students` DISABLE KEYS */;
INSERT INTO `students` VALUES ('1010','john','smith',30,'m'),('1020','jane','smith',31,'f'),('1030','jack','jones',32,'m'),('1040','dave','stone',33,'m'),('1050','sara','stein',34,'f'),('1060','eddy','bower',35,'m');
/*!40000 ALTER TABLE `students` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TABLEA`
--

DROP TABLE IF EXISTS `TABLEA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `TABLEA` (
  `idx_tablea` int DEFAULT NULL,
  `student_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `TABLEA`
--

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

--
-- Table structure for table `TABLEB`
--

DROP TABLE IF EXISTS `TABLEB`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `TABLEB` (
  `idx_tableb` int DEFAULT NULL,
  `class_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `TABLEB`
--

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

--
-- Table structure for table `temp_cust2`
--

DROP TABLE IF EXISTS `temp_cust2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `temp_cust2` (
  `cust_id` int DEFAULT NULL,
  `first_name` varchar(20) DEFAULT NULL,
  `last_name` varchar(20) DEFAULT NULL,
  `home_address` varchar(20) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `state` varchar(20) DEFAULT NULL,
  `zip_code` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `temp_cust2`
--

LOCK TABLES `temp_cust2` WRITE;
/*!40000 ALTER TABLE `temp_cust2` DISABLE KEYS */;
INSERT INTO `temp_cust2` VALUES (1000,'John','Smith','123 Main St','Fremont','CA','94123');
/*!40000 ALTER TABLE `temp_cust2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `temp_user`
--

DROP TABLE IF EXISTS `temp_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `temp_user` (
  `user_id` int DEFAULT NULL,
  `user_title` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `temp_user`
--

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

--
-- Table structure for table `temperatures`
--

DROP TABLE IF EXISTS `temperatures`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `temperatures` (
  `temper` int DEFAULT NULL,
  `city` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `temperatures`
--

LOCK TABLES `temperatures` WRITE;
/*!40000 ALTER TABLE `temperatures` DISABLE KEYS */;
INSERT INTO `temperatures` VALUES (78,'sf'),(60,'sf'),(42,'sf'),(60,'ny');
/*!40000 ALTER TABLE `temperatures` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
  `user_id` int DEFAULT NULL,
  `user_title` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1000,'Developer'),(2000,'Project Lead'),(3000,'Dev Manager'),(4000,'Senior Dev Manager');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user2`
--

DROP TABLE IF EXISTS `user2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user2` (
  `user_id` int DEFAULT NULL,
  `user_title` varchar(20) DEFAULT NULL,
  `fname` varchar(20) DEFAULT NULL,
  `lname` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user2`
--

LOCK TABLES `user2` WRITE;
/*!40000 ALTER TABLE `user2` DISABLE KEYS */;
INSERT INTO `user2` VALUES (1000,'Developer','John','Smith'),(2000,'Project Lead','Jane','Stone'),(3000,'Dev Manager','Dave','Dodds'),(4000,'Senior Dev Manager','Jack','Jones');
/*!40000 ALTER TABLE `user2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user3`
--

DROP TABLE IF EXISTS `user3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user3` (
  `user_id` int DEFAULT NULL,
  `user_title` varchar(20) DEFAULT NULL,
  `fname` varchar(20) DEFAULT NULL,
  `lname` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user3`
--

LOCK TABLES `user3` WRITE;
/*!40000 ALTER TABLE `user3` DISABLE KEYS */;
INSERT INTO `user3` VALUES (1000,'Developer','John','Smith'),(2000,'Project Lead','Jane','Stone'),(3000,'Dev Manager','Dave','Dodds'),(4000,'Senior Dev Manager','Jack','Jones');
/*!40000 ALTER TABLE `user3` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_dates`
--

DROP TABLE IF EXISTS `users_dates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users_dates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `birth_date` date NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_dates`
--

LOCK TABLES `users_dates` WRITE;
/*!40000 ALTER TABLE `users_dates` DISABLE KEYS */;
INSERT INTO `users_dates` VALUES (1000,'JANE Q JONES','2001-07-07','2021-03-03 00:00:00','2021-09-03 00:01:35');
/*!40000 ALTER TABLE `users_dates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary view structure for view `v_item_desc`
--

DROP TABLE IF EXISTS `v_item_desc`;
/*!50001 DROP VIEW IF EXISTS `v_item_desc`*/;
SET @saved_cs_client     = @@character_set_client;
/*!50503 SET character_set_client = utf8mb4 */;
/*!50001 CREATE VIEW `v_item_desc` AS SELECT 
 1 AS `item_id`,
 1 AS `item_price`,
 1 AS `item_price*0.08`,
 1 AS `TOTAL`*/;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `venues`
--

DROP TABLE IF EXISTS `venues`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `venues` (
  `country_id` int DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  `venue_id` int DEFAULT NULL,
  `venue_name` char(30) DEFAULT NULL,
  `event_date` date DEFAULT NULL,
  `status` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `venues`
--

LOCK TABLES `venues` WRITE;
/*!40000 ALTER TABLE `venues` DISABLE KEYS */;
INSERT INTO `venues` VALUES (1000,10000,100,'Fillmore','2022-01-15','SOLDOUT'),(1000,11000,200,'Social','2022-02-10','SOLDOUT'),(2000,12000,300,'Ciak','2022-03-25','SOLDOUT'),(3000,13000,400,'Batschkapp','2022-04-08','SOLDOUT'),(4000,14000,500,'Orpheum','2022-05-03','SOLDOUT'),(5000,15000,600,'Foro','2022-06-08','SOLDOUT');
/*!40000 ALTER TABLE `venues` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `weath`
--

DROP TABLE IF EXISTS `weath`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `weath` (
  `day` date DEFAULT NULL,
  `temper` int DEFAULT NULL,
  `wind` int DEFAULT NULL,
  `forecast` char(20) DEFAULT NULL,
  `city` char(20) DEFAULT NULL,
  `state` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `weath`
--

LOCK TABLES `weath` WRITE;
/*!40000 ALTER TABLE `weath` DISABLE KEYS */;
INSERT INTO `weath` VALUES ('2021-04-03',78,-12,NULL,'se','wa'),('2021-08-04',50,12,'Snow','','mn'),('2021-09-02',45,99,'','sf','ca'),('2021-09-03',15,12,'Snow','chi','il');
/*!40000 ALTER TABLE `weath` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `weather`
--

DROP TABLE IF EXISTS `weather`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `weather` (
  `day` date DEFAULT NULL,
  `temper` int DEFAULT NULL,
  `wind` int DEFAULT NULL,
  `forecast` char(20) DEFAULT NULL,
  `city` char(20) DEFAULT NULL,
  `state` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `weather`
--

LOCK TABLES `weather` WRITE;
/*!40000 ALTER TABLE `weather` DISABLE KEYS */;
INSERT INTO `weather` VALUES ('2021-04-01',42,16,'Rain','sf','ca'),('2021-04-02',45,3,'Sunny','sf','ca'),('2021-04-03',78,-12,NULL,'se','wa'),('2021-07-01',42,16,'Rain','','ca'),('2021-07-02',45,-3,'Sunny','sf','ca'),('2021-07-03',78,12,NULL,'sf','mn'),('2021-08-04',50,12,'Snow','','mn'),('2021-08-06',51,32,'','sf','ca'),('2021-09-01',42,16,'Rain','sf','ca'),('2021-09-02',45,99,'','sf','ca'),('2021-09-03',15,12,'Snow','chi','il');
/*!40000 ALTER TABLE `weather` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `weather2`
--

DROP TABLE IF EXISTS `weather2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `weather2` (
  `day` date DEFAULT NULL,
  `temper` int DEFAULT NULL,
  `wind` int DEFAULT NULL,
  `forecast` char(20) DEFAULT NULL,
  `city` char(20) DEFAULT NULL,
  `state` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `weather2`
--

LOCK TABLES `weather2` WRITE;
/*!40000 ALTER TABLE `weather2` DISABLE KEYS */;
INSERT INTO `weather2` VALUES ('2021-04-01',42,16,'Rain','sf','ca'),('2021-04-02',45,3,'Sunny','sf','ca'),('2021-04-03',78,-12,NULL,'se','wa'),('2021-07-01',42,16,'Rain','','ca'),('2021-07-02',45,-3,'Sunny','sf','ca'),('2021-07-03',78,12,NULL,'sf','mn'),('2021-08-04',50,12,'Snow','','mn'),('2021-08-06',51,32,'','sf','ca'),('2021-09-01',42,16,'Rain','sf','ca'),('2021-09-02',45,99,'','sf','ca'),('2021-09-03',15,12,'Snow','chi','il');
/*!40000 ALTER TABLE `weather2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `weather3`
--

DROP TABLE IF EXISTS `weather3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `weather3` (
  `day` date DEFAULT NULL,
  `temper` int DEFAULT NULL,
  `wind` int DEFAULT NULL,
  `forecast` char(20) DEFAULT NULL,
  `city` char(20) DEFAULT NULL,
  `state` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `weather3`
--

LOCK TABLES `weather3` WRITE;
/*!40000 ALTER TABLE `weather3` DISABLE KEYS */;
INSERT INTO `weather3` VALUES ('2021-04-01',42,16,'Rain','sf','ca'),('2021-04-02',45,3,'Sunny','sf','ca'),('2021-04-03',78,-12,NULL,'se','wa'),('2021-07-01',42,16,'Rain','','ca'),('2021-07-02',45,-3,'Sunny','sf','ca'),('2021-07-03',78,12,NULL,'sf','mn'),('2021-08-04',50,12,'Snow','','mn'),('2021-08-06',51,-999,'UNKNOWN','sf','ca'),('2021-09-01',42,16,'Rain','sf','ca'),('2021-09-02',45,-999,'UNKNOWN','sf','ca'),('2021-09-03',15,12,'Snow','chi','il');
/*!40000 ALTER TABLE `weather3` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'mytools'
--

--
-- Dumping routines for database 'mytools'
--
/*!50003 DROP FUNCTION IF EXISTS `olympic_tier` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `olympic_tier`(medals INT) RETURNS varchar(20) CHARSET utf8mb4
    DETERMINISTIC
BEGIN
    DECLARE medal_level VARCHAR(20);

    IF medals >= 30 THEN
		SET medal_level = 'TIER 1';
    ELSEIF medals >= 20 THEN
		SET medal_level = 'TIER 2';
    ELSE
		SET medal_level = 'TIER 3';
    END IF;
    
    RETURN (medal_level);
END ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 DROP PROCEDURE IF EXISTS `allrows` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `allrows`()
BEGIN
  SELECT * FROM user;
END ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 DROP PROCEDURE IF EXISTS `double_number` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `double_number`(IN N INT, INOUT result INT)
BEGIN
  SET result := N * 2;
END ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 DROP PROCEDURE IF EXISTS `even_or_odd` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `even_or_odd`(IN N INT, OUT result INT)
BEGIN
  IF N % 2 = 0 THEN
    SET result := 0;
  ELSE
    SET result := 1;
  END IF;
END ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 DROP PROCEDURE IF EXISTS `factorial_recursive` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `factorial_recursive`(IN N INT,OUT factorial INT)
BEGIN
  IF N = 1 THEN
    SET factorial := 1;
  ELSE
    CALL factorial_recursive (N-1, factorial);
    SET factorial := N * factorial;
  END IF;
END ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 DROP PROCEDURE IF EXISTS `get_factorial` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_factorial`(IN N INT)
BEGIN
  SET @@GLOBAL.max_sp_recursion_depth = 255;
  SET @@session.max_sp_recursion_depth = 255;
  CALL factorial_recursive (N, @factorial);
  SELECT @factorial;
END ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 DROP PROCEDURE IF EXISTS `user_count` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `user_count`(IN user CHAR(3), OUT users INT)
BEGIN
  SELECT COUNT(*) INTO users FROM user;
END ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;

--
-- Final view structure for view `v_item_desc`
--

/*!50001 DROP VIEW IF EXISTS `v_item_desc`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_item_desc` AS select `item_desc`.`item_id` AS `item_id`,`item_desc`.`item_price` AS `item_price`,(`item_desc`.`item_price` * 0.08) AS `item_price*0.08`,(`item_desc`.`item_price` * 1.08) AS `TOTAL` from `item_desc` order by `item_desc`.`item_id` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!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-11-20 18:19:06
