Golden_Dairy_Employee.sql

-- MySQL dump 10.13  Distrib 8.0.32, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: Golden_Dairy
-- ------------------------------------------------------
-- Server version	8.0.32-0ubuntu0.22.04.2

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

DROP TABLE IF EXISTS `Employee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Employee` (
  `ID` int NOT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `Address` varchar(100) DEFAULT NULL,
  `Email` varchar(50) DEFAULT NULL,
  `Contact_No` varchar(50) DEFAULT NULL,
  `Salary` int DEFAULT NULL,
  `Role` varchar(50) 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 `Employee`
--

LOCK TABLES `Employee` WRITE;
/*!40000 ALTER TABLE `Employee` DISABLE KEYS */;
INSERT INTO `Employee` VALUES (1,'Paul Hernandez','5578 Whitney Lane Apt. 695 Howardmouth, MA 40707','Paul Hernandez@example.com','3282178964',54198,'Finance'),(2,'Joseph Miller','09960 Garcia View Apt. 722 Francesfort, MA 68382','Joseph Miller@example.com','4678762216',55679,'Finance'),(3,'Danielle Rubio','475 Chandler Wells Danachester, SC 13905','Danielle Rubio@example.com','6156693817',36596,'Delivery'),(4,'Jesse Scott','9730 Hood Trail Apt. 644 Lake Julieland, IL 58517','Jesse Scott@example.com','3886137003',42137,'Milk Processor'),(5,'Dr. Robert Snyder','57682 Davis Burg Apt. 450 Port Joshuaberg, KS 08728','Dr. Robert Snyder@example.com','8847433501',40146,'Manager'),(6,'Annette Ruiz','99608 Todd Courts Phamstad, CT 71943','Annette Ruiz@example.com','0117849705',55216,'Manager'),(7,'Angela Galloway','683 Martinez Walks Apt. 521 Christopherbury, OR 43111','Angela Galloway@example.com','2505391648',43038,'Finance'),(8,'Kathleen Hudson','271 Robinson Course Tinaton, UT 65713','Kathleen Hudson@example.com','4958302795',53552,'Delivery'),(9,'Michael Wilkinson','8824 Wong Junction Kerrishire, WI 75519','Michael Wilkinson@example.com','5225633845',48001,'Milk Processor'),(10,'David Smith','996 Moore Path Crossbury, MT 66166','David Smith@example.com','7044632543',48435,'Manager'),(11,'Heather Jackson','692 Bauer Parkway Suite 483 West Brian, LA 26120','Heather Jackson@example.com','1149357365',39834,'Finance'),(12,'Deborah Guerrero','93292 Ashley Center Suite 686 Donaldborough, GU 85131','Deborah Guerrero@example.com','9306789211',31822,'Delivery'),(13,'Mr. James Phillips','944 Richard Stream Fernandezfurt, MP 24247','Mr. James Phillips@example.com','9348366394',35511,'Customer care'),(14,'Joshua Kelly','3111 Anthony Trail Suite 979 East Samanthastad, MN 08681','Joshua Kelly@example.com','9609579645',41475,'Delivery'),(15,'Ricardo Oliver','PSC 1370, Box 9277 APO AE 38392','Ricardo Oliver@example.com','2141559270',39556,'Delivery'),(16,'Whitney Stevens','2004 Wilson Hill Davisborough, RI 97112','Whitney Stevens@example.com','7673108011',47232,'Manager'),(17,'John Hill','6777 Ortiz Parks Suite 556 Port Joshualand, GU 40260','John Hill@example.com','6332945879',39315,'Manager'),(18,'Jay Lopez','755 Hill Valleys New Samantha, IL 54153','Jay Lopez@example.com','1248372263',44904,'Finance'),(19,'Deborah Ford','PSC 4128, Box 3121 APO AA 64697','Deborah Ford@example.com','6976512889',59328,'Customer care'),(20,'Philip Molina','00438 Audrey Extension Apt. 506 South William, VI 03193','Philip Molina@example.com','3083962356',38400,'Manager'),(21,'Joseph Brown DDS','233 Taylor Crossing Jessestad, PA 53983','Joseph Brown DDS@example.com','6000453358',34121,'Milk Processor'),(22,'Larry Johnson','6038 Parker Circles Jamesbury, AZ 49106','Larry Johnson@example.com','2313593364',44937,'Customer care'),(23,'Sara Johnson','74356 Pugh Trail Apt. 254 Mathewburgh, RI 49765','Sara Johnson@example.com','9890975636',44822,'Manager'),(24,'Susan Briggs','USCGC Roman FPO AP 45839','Susan Briggs@example.com','5172300897',52987,'Finance'),(25,'Brian Weiss','7167 Day Neck Martineztown, SC 94888','Brian Weiss@example.com','4566977855',32623,'Delivery'),(26,'Derek Ellis','48359 Liu Course Apt. 928 Christopherhaven, OR 13556','Derek Ellis@example.com','7518822048',48768,'Customer care'),(27,'Mary Cruz','31325 Kelsey Trail Apt. 371 West Petermouth, MO 23538','Mary Cruz@example.com','7756406995',31321,'Finance'),(28,'Mr. Robert Hunter II','PSC 5567, Box 6254 APO AP 01736','Mr. Robert Hunter II@example.com','8070914496',35040,'Manager'),(29,'Scott Davis','4370 Matthew Turnpike Martinezborough, KY 72119','Scott Davis@example.com','0361984972',46147,'Milk Processor'),(30,'Amy Jones','2941 Keith Avenue West Benjaminport, MT 73914','Amy Jones@example.com','2937501085',33525,'Customer care'),(31,'Dustin Leonard','11106 Thomas Course Apt. 595 Port Judithland, IL 43174','Dustin Leonard@example.com','6713762115',54384,'Customer care'),(32,'Michael Butler','3710 Davidson Parks Port Brianport, OH 77866','Michael Butler@example.com','2097815759',46017,'Customer care'),(33,'Julie Dunlap','162 Julian Shoals Gardnerborough, SC 65957','Julie Dunlap@example.com','5429273896',33100,'Milk Processor'),(34,'Cassandra Martin','644 Shannon Villages Apt. 400 New Douglas, MI 01290','Cassandra Martin@example.com','1447753728',34565,'Delivery'),(35,'Dr. Alyssa Morris','PSC 7820, Box 1286 APO AE 62570','Dr. Alyssa Morris@example.com','7027356105',33491,'Manager'),(36,'Crystal Ruiz','28884 Woods Islands Apt. 936 New Leah, IA 99509','Crystal Ruiz@example.com','6153665004',39716,'Milk Processor'),(37,'Deanna Short','914 Leslie Junction Apt. 821 Hochester, OH 73133','Deanna Short@example.com','2508407027',57411,'Finance'),(38,'Kent Brown','Unit 3626 Box 0622 DPO AE 02663','Kent Brown@example.com','8710485297',40226,'Finance'),(39,'Michelle Haynes','84204 Anderson Road Apt. 964 West Jocelyntown, NM 72184','Michelle Haynes@example.com','3541806449',52030,'Finance'),(40,'Nichole Wise','597 Kimberly Well Suite 115 Wilsonmouth, VA 31763','Nichole Wise@example.com','2572516814',39988,'Manager'),(41,'Eddie Simmons','6799 Cheryl Point Suite 439 New Amber, IA 18338','Eddie Simmons@example.com','5422580946',49313,'Finance'),(42,'Amanda Sanchez','7985 Lang Causeway Bernardtown, TN 80453','Amanda Sanchez@example.com','4051745338',44640,'Delivery'),(43,'Richard Davis','82626 Madeline Point Cynthiahaven, WY 94014','Richard Davis@example.com','0171453994',39754,'Manager'),(44,'Edward Francis','0438 Meredith Dam Suite 710 Grahamfort, WA 12903','Edward Francis@example.com','4337760929',42239,'Delivery'),(45,'Nicole Rowe','092 Barker Forest Kimberlyland, GA 52136','Nicole Rowe@example.com','3584202636',34714,'Finance'),(46,'Melissa Chavez','PSC 7634, Box 1641 APO AA 13558','Melissa Chavez@example.com','6743466536',43940,'Delivery'),(47,'Kimberly Moss','00399 Debra Pike Davidfurt, MP 83989','Kimberly Moss@example.com','7367833967',37033,'Finance'),(48,'Daniel Hart','71938 John Trace Apt. 403 Dawnville, MO 56380','Daniel Hart@example.com','5739620160',41026,'Finance'),(49,'Karen Hansen','864 Douglas Stravenue Apt. 451 Port Lucasmouth, AR 40310','Karen Hansen@example.com','3828861310',35107,'Delivery'),(50,'Matthew Martin','8792 Timothy Meadow Suite 749 Eugeneborough, AK 57576','Matthew Martin@example.com','4258135628',53728,'Delivery'),(51,'Chad Roberson','872 Peter Flats Sullivanfurt, IL 62640','Chad Roberson@example.com','2263801331',38577,'Delivery'),(52,'Barbara Gilmore','5698 Henderson Terrace Valdezhaven, MP 60549','Barbara Gilmore@example.com','5481011753',59239,'Manager'),(53,'Jonathan Ramsey','0922 Megan River Kaylatown, OH 23240','Jonathan Ramsey@example.com','2211964744',50373,'Delivery'),(54,'Jon Turner','PSC 6326, Box 0195 APO AA 58163','Jon Turner@example.com','5268173963',45414,'Delivery'),(55,'Isaac Howard','61853 Smith Skyway Yvonneside, AS 18413','Isaac Howard@example.com','5911084208',47014,'Milk Processor'),(56,'Peggy Richardson','465 Isabella Street East Samuel, NM 22281','Peggy Richardson@example.com','8776597960',47056,'Milk Processor'),(57,'Andre Thomas','52829 Pam Lodge East Melinda, DE 63913','Andre Thomas@example.com','9710861627',36782,'Manager'),(58,'Danielle Gutierrez','2130 Derek Passage Apt. 633 Kellyborough, NE 89410','Danielle Gutierrez@example.com','9235491886',54996,'Milk Processor'),(59,'Francisco Jordan','0280 Gonzales Rapids Apt. 138 South Stephanietown, PA 11118','Francisco Jordan@example.com','7542756931',44473,'Customer care'),(60,'Jordan Moore','575 Collins Camp Jamieport, VI 97901','Jordan Moore@example.com','9613478749',43952,'Customer care'),(61,'Brittany Baker','60776 Reyes Isle Popeberg, UT 25759','Brittany Baker@example.com','3983285968',32126,'Customer care'),(62,'Scott Hubbard','52325 Bruce Stream Campbellfurt, NY 26121','Scott Hubbard@example.com','1041042089',48534,'Delivery'),(63,'Tamara Cook','704 Mcfarland Shoal Apt. 273 South Sean, CA 37678','Tamara Cook@example.com','9302049131',41005,'Customer care'),(64,'Melissa Doyle','5917 Smith Meadow Williamhaven, OH 48254','Melissa Doyle@example.com','8466524768',38470,'Milk Processor'),(65,'Michael Vargas','51662 Conley Route West Zacharyland, VT 26466','Michael Vargas@example.com','5057372895',55911,'Finance'),(66,'Nicole Chavez','5799 Simpson Plains Suite 667 Port Dana, CA 42098','Nicole Chavez@example.com','2506144285',44713,'Customer care'),(67,'Brianna Chapman','76976 Ashley Land Apt. 480 South Randall, UT 09188','Brianna Chapman@example.com','6850903613',53968,'Finance'),(68,'Robert Smith','5098 Cindy Flats Apt. 938 Port Elizabethfurt, MN 51974','Robert Smith@example.com','0234051676',41878,'Finance'),(69,'Rickey Bennett','573 Mcconnell Spurs New Thomasshire, NH 41402','Rickey Bennett@example.com','8574199574',40881,'Manager'),(70,'William Gibbs','850 Dunlap Isle Apt. 681 New Mary, ID 09298','William Gibbs@example.com','2136946474',52089,'Manager'),(71,'Travis Clarke','2368 Brian Lake Apt. 648 Coopermouth, AZ 50431','Travis Clarke@example.com','8465108332',49823,'Milk Processor'),(72,'Stacey Watkins MD','09127 Aguirre Cliffs Lake Gregory, MP 51048','Stacey Watkins MD@example.com','9143148072',33555,'Manager'),(73,'Jennifer Walker','489 Michael Locks Apt. 656 New David, ME 71804','Jennifer Walker@example.com','1375038525',33359,'Manager'),(74,'Debra Johnson','9062 Cody Place Suite 337 Jaredside, VA 10336','Debra Johnson@example.com','6032202730',39339,'Manager'),(75,'Russell Gilmore','052 Thompson Branch Apt. 088 Kimland, MS 07851','Russell Gilmore@example.com','1827503723',53923,'Delivery'),(76,'Elizabeth Bell','40095 Snyder Hills Suite 371 Snyderbury, PR 62940','Elizabeth Bell@example.com','2878743050',48083,'Milk Processor'),(77,'Dan Anderson','3196 Amanda Haven East Brenda, NY 46141','Dan Anderson@example.com','7399978819',45121,'Finance'),(78,'Michael Hernandez','61674 Jared Wells New Shawn, LA 45913','Michael Hernandez@example.com','8417997229',58642,'Finance'),(79,'Benjamin Moore','PSC 6753, Box 0933 APO AE 60878','Benjamin Moore@example.com','1980500399',52618,'Customer care'),(80,'Michael Robinson','7271 Grant Roads Apt. 525 Kellieberg, RI 94357','Michael Robinson@example.com','4130045882',39109,'Customer care'),(81,'Jackie Walton','19411 Rhonda Unions Leachtown, PR 85471','Jackie Walton@example.com','1688508083',58185,'Delivery'),(82,'Kristi West','405 Kenneth Extension Suite 217 Robinsontown, IL 39804','Kristi West@example.com','7347890147',42776,'Milk Processor'),(83,'David Hall','USCGC Patton FPO AA 12544','David Hall@example.com','6927737058',54373,'Finance'),(84,'Garrett Shields','844 Mcintyre Lodge Apt. 594 Wattsland, OK 85524','Garrett Shields@example.com','1151047096',53045,'Finance'),(85,'James Wyatt','6282 Phillips Cliffs Anthonyview, NH 83588','James Wyatt@example.com','8940861728',38534,'Delivery'),(86,'Joseph Carter','022 Timothy Grove Suite 135 Miguelberg, RI 02087','Joseph Carter@example.com','4112035647',47971,'Milk Processor'),(87,'Brooke Perez','546 Smith Knolls Scottstad, UT 17604','Brooke Perez@example.com','7817470671',38002,'Customer care'),(88,'Carol Williams','44013 Torres Ridges Heatherton, OK 72845','Carol Williams@example.com','4181344074',54763,'Customer care'),(89,'William Solis','466 Jeffrey Place West Bradley, OR 86511','William Solis@example.com','0546856579',33738,'Finance'),(90,'Janice Davis','987 Kim Trail Cummingsville, MN 42842','Janice Davis@example.com','2312846210',44093,'Manager'),(91,'Alexandra Gallagher','69658 Benjamin Loaf Wilsonville, MS 44397','Alexandra Gallagher@example.com','3613353311',55256,'Customer care'),(92,'Austin Morris','55704 Brandy Bypass West Michaelside, WI 64073','Austin Morris@example.com','2297310705',50834,'Manager'),(93,'Laura Robbins PhD','454 Humphrey Spur Suite 482 Schultzburgh, GU 67852','Laura Robbins PhD@example.com','4315329142',40562,'Finance'),(94,'Ronald Carroll','3031 Jefferson Island Charlesberg, IA 48092','Ronald Carroll@example.com','2636106983',55661,'Milk Processor'),(95,'Cameron Jenkins','1115 Sanchez Terrace North Nathan, MA 08057','Cameron Jenkins@example.com','4988199661',30788,'Manager'),(96,'Diana Mason','66678 Tamara Courts Suite 208 Morganborough, GA 80003','Diana Mason@example.com','7460784769',35554,'Manager'),(97,'Cheryl Best','USS Franklin FPO AE 47129','Cheryl Best@example.com','9749340644',40145,'Manager'),(98,'Albert Wagner','160 Kaitlin Plains Kristinborough, NH 51359','Albert Wagner@example.com','7663779590',43762,'Milk Processor'),(99,'Deborah Holden','877 Thomas Extensions Johnsontown, FL 32079','Deborah Holden@example.com','5412245907',33171,'Manager'),(100,'Stephanie Lester','635 Eric Lights South Joshua, KS 42410','Stephanie Lester@example.com','2934922615',56095,'Delivery');
/*!40000 ALTER TABLE `Employee` 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 2023-02-10 19:03:52