| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/Classes/CST1600/Labs/Lab10/ |
Upload File : |
CREATE DATABASE IF NOT EXISTS `martinson_by_export` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `martinson_by_export`;
-- MySQL dump 10.13 Distrib 5.7.9, for Win64 (x86_64)
--
-- Host: localhost Database: martinson_by_export
-- ------------------------------------------------------
-- Server version 5.5.48
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `dept`
--
DROP TABLE IF EXISTS `dept`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dept` (
`deptID` char(4) NOT NULL,
PRIMARY KEY (`deptID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dept`
--
LOCK TABLES `dept` WRITE;
/*!40000 ALTER TABLE `dept` DISABLE KEYS */;
INSERT INTO `dept` VALUES ('D001'),('D002'),('D004'),('D890'),('D900');
/*!40000 ALTER TABLE `dept` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `employee`
--
DROP TABLE IF EXISTS `employee`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee` (
`employeeID` char(3) NOT NULL,
`employeeName` varchar(45) NOT NULL,
`employeeAddress` varchar(45) DEFAULT NULL,
PRIMARY KEY (`employeeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `employee`
--
LOCK TABLES `employee` WRITE;
/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
INSERT INTO `employee` VALUES ('101','Rick','Delhi'),('102','Jon','Kanpur'),('103','Ron','Chennai'),('104','Lester','Bangalore'),('123','Maggie','Agra'),('166','Glenn','Chennai');
/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `employee_dept`
--
DROP TABLE IF EXISTS `employee_dept`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee_dept` (
`employeeID` char(3) NOT NULL,
`deptID` char(4) NOT NULL,
PRIMARY KEY (`employeeID`,`deptID`),
KEY `fk_employee_dept_employee1_idx` (`employeeID`),
KEY `fk_employee_dept_dept1_idx` (`deptID`),
CONSTRAINT `fk_employee_dept_employee1` FOREIGN KEY (`employeeID`) REFERENCES `employee` (`employeeID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_employee_dept_dept1` FOREIGN KEY (`deptID`) REFERENCES `dept` (`deptID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `employee_dept`
--
LOCK TABLES `employee_dept` WRITE;
/*!40000 ALTER TABLE `employee_dept` DISABLE KEYS */;
INSERT INTO `employee_dept` VALUES ('101','D001'),('101','D002'),('123','D890'),('166','D004'),('166','D900');
/*!40000 ALTER TABLE `employee_dept` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `employee_mobile`
--
DROP TABLE IF EXISTS `employee_mobile`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee_mobile` (
`employeeID` char(3) NOT NULL,
`mobile` varchar(45) NOT NULL,
PRIMARY KEY (`employeeID`,`mobile`),
KEY `fk_table1_employee_idx` (`employeeID`),
CONSTRAINT `fk_table1_employee` FOREIGN KEY (`employeeID`) REFERENCES `employee` (`employeeID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `employee_mobile`
--
LOCK TABLES `employee_mobile` WRITE;
/*!40000 ALTER TABLE `employee_mobile` DISABLE KEYS */;
INSERT INTO `employee_mobile` VALUES ('102','8812121212'),('102','9900012222'),('103','7778881212'),('104','8123450987'),('104','9990000123');
/*!40000 ALTER TABLE `employee_mobile` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2020-12-01 6:08:28