-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathGolden_Dairy_Customers.sql
55 lines (48 loc) · 13.9 KB
/
Golden_Dairy_Customers.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
-- 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 `Customers`
--
DROP TABLE IF EXISTS `Customers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Customers` (
`Name` varchar(100) DEFAULT NULL,
`customer_id` int NOT NULL AUTO_INCREMENT,
`password` varchar(50) DEFAULT NULL,
`Address` varchar(100) DEFAULT NULL,
`Email` varchar(100) DEFAULT NULL,
`Contact_No` varchar(100) DEFAULT NULL,
PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 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 ('Mark Reyes',1,'BQxBkXsx','2574 Maynard Plains Danielfort, IN 58475','[email protected]','151-734-8989'),('Austin Bright',2,'mAhmwagR','5606 John Inlet Lake Barbaraside, UT 71910','[email protected]','9921007788'),('Jennifer Harper',3,'ZbRBpWC9','0400 James Divide Apt. 309 West Anna, MT 47535','[email protected]','944.157.5482x79677'),('Alyssa Mills',4,'Ou0ZHOnL','PSC 6888, Box 5196 APO AA 95015','[email protected]','4092106751'),('Michael Williams',5,'7prmSIBN','42247 Richard Square Jamesfort, NV 51887','[email protected]','519.973.2831'),('Miss Michelle Douglas',6,'Uc2dWdM8','13198 Jonathon Stravenue Port Christopherchester, VT 72090','[email protected]','554-837-3677x929'),('Lucas Mcgee',7,'OoQMaQoa','10423 Cuevas Isle Apt. 641 Sophiatown, UT 12268','[email protected]','921-444-7629'),('Edward Floyd',8,'exRH1FAL','698 Peter Meadows Pierceberg, WA 85556','[email protected]','(735)935-9484x2726'),('Louis Novak',9,'05OOfsCt','314 Kim Circle Apt. 361 Hunthaven, NV 86973','[email protected]','664-338-4590x2572'),('Mrs. Lisa Bush DVM',10,'b31tnayf','3275 Goodwin Lock Apt. 175 Josephside, KS 39311','[email protected]','(064)547-9339x633'),('John Gates DDS',11,'kdVmR5Uf','72454 Catherine Well Suite 121 North Anna, RI 98230','[email protected]','(096)178-9205x941'),('Michael Hunter',12,'L3HPqAoV','Unit 4392 Box 6209 DPO AA 34175','[email protected]','001-810-847-4747x85206'),('Mark Parks',13,'PxtpTBMw','2305 Mcdaniel Turnpike Lake Howard, GA 81306','[email protected]','(981)930-1391x28118'),('Michael Butler',14,'jOyAJSO3','USNV Jones FPO AA 06465','[email protected]','4487013918'),('Carol Martinez',15,'iW15WhNT','Unit 7866 Box 5750 DPO AP 60383','[email protected]','(507)732-5002x22761'),('Harold Peterson',16,'RPt9ku0q','Unit 2134 Box 5017 DPO AA 78423','[email protected]','+1-834-131-6903x4087'),('Michael Adams',17,'5jmiJV1D','22647 Kim Glens North Robert, TN 52618','[email protected]','028-720-8808x16086'),('Jonathan Rivera',18,'e9qZII9S','0875 Ellis Walks Courtneyport, NJ 80212','[email protected]','467-335-7629x87057'),('Gary Lewis',19,'yEzPS2sN','89598 Monica Lakes Sawyerside, FL 13738','[email protected]','897-081-0885'),('Christopher Bennett',20,'E3ZVvLA8','1467 Ramirez Vista Apt. 190 North Brianville, MH 63666','[email protected]','538.558.5112'),('Alison Rosales',21,'LTW2RazX','0881 Jones Pike Griffinmouth, ID 00962','[email protected]','(702)882-9190'),('Deborah Jones',22,'2jTBfOvr','95144 John Squares Apt. 316 Collinshaven, NJ 46304','[email protected]','001-306-493-8838x719'),('Nathaniel Wilson',23,'qCHH9JxB','PSC 5893, Box 8622 APO AA 57082','[email protected]','262-391-2203x9853'),('Jeffrey Valenzuela',24,'6ZP3VgXA','28871 Murphy Ways Rojasland, OK 84449','[email protected]','+1-731-062-5017x23130'),('Mia Allen',25,'LpKr7uOs','1911 Nicole Crescent Port Joy, WI 94536','[email protected]','(480)630-2619x46422'),('Alexis Smith',26,'f98jcXf6','USNV Cruz FPO AP 24955','[email protected]','+1-310-159-2451x01160'),('Abigail Scott',27,'KbCzVuLp','7222 Tyler Ridges Suite 703 North Monicamouth, MD 97431','[email protected]','(494)022-7870'),('Cody Velazquez',28,'bflQwhXr','46236 White Stream Suite 691 Tiffanyfurt, ND 02580','[email protected]','657.206.2489'),('Steven Reilly',29,'0oru2Dbh','1875 Ramos Summit Suite 495 East Daniel, WY 93033','[email protected]','353-840-6658x3569'),('Jeffrey Baker',30,'yzxpOGeN','Unit 1353 Box 4094 DPO AP 07479','[email protected]','+1-096-404-1369'),('Eric Reyes',31,'4fykKLZO','636 Kyle Turnpike Apt. 937 New Carolyn, NC 94152','[email protected]','001-115-520-4278'),('Diana Hernandez',32,'35CWds7B','30309 Kelly Camp Suite 271 Debrahaven, MN 60171','[email protected]','(213)904-6342'),('Ryan Schroeder',33,'462VfYWR','38848 Jimmy Plaza Apt. 362 Blackmouth, KS 86954','[email protected]','(949)801-5677x6232'),('Perry Edwards',34,'jjD72wBN','7141 Foster Lakes Kristinafort, VI 83263','[email protected]','726.728.6435x6768'),('Samantha Dunn',35,'OoKRZbme','0433 Brandy Wall Apt. 661 New Darrell, KS 84372','[email protected]','(836)179-3067x42498'),('Debra Lambert',36,'52XEcZh9','78622 Eric Trafficway Port Joshuamouth, AK 68227','[email protected]','+1-632-578-8395x06201'),('Mr. Christopher Miller Jr.',37,'5LFSgaDz','9522 Todd Way Port Cody, MI 01276','[email protected]','001-530-301-3548'),('Ryan Greene',38,'Nr1dW6jd','49443 Clarke Square Noahton, AR 26687','[email protected]','(145)954-4995'),('Ethan Nguyen',39,'urQLDd4T','9674 Adam Points Clinebury, ND 70338','[email protected]','001-517-544-7928x71321'),('Dustin Atkins',40,'J1TlQc69','374 Christine Expressway Suite 825 South Michaelville, AR 19886','[email protected]','(866)380-1193'),('Brandon Andrews',41,'YAAd756E','7569 Hanson Field Suite 272 Lake Kenneth, UT 45377','[email protected]','+1-969-342-1693'),('Daryl Rodriguez',42,'WXB7SIYi','478 Francis Forest Apt. 314 Lake Dianeberg, UT 26054','[email protected]','(203)607-3187x735'),('Shawn Reed',43,'xeSCowLx','USNS Neal FPO AE 92435','[email protected]','467-337-0644x898'),('Nicholas Jones',44,'1FbWsVtR','84140 Sharp Parkways South Timothy, AL 39059','[email protected]','(875)096-4923'),('Martin Keith',45,'b5QZtqVL','663 Bonnie Forges Suite 656 Beanfurt, ME 81464','[email protected]','(522)049-0486'),('Aaron Deleon',46,'SLdQRxvL','88125 Velasquez Key Devinville, ME 96279','[email protected]','001-999-766-0515x1310'),('Heather Pena',47,'9MJpokA9','486 Madison Forges Apt. 570 New Cody, AS 05142','[email protected]','(585)391-8128x363'),('Patricia Simmons PhD',48,'1LncaQC5','6191 Haley Ranch Nicoleburgh, NM 90862','[email protected]','042-510-9719x61981'),('Susan Bailey',49,'Ebgzi8q7','869 Sanchez Loop Apt. 890 Ballardmouth, IL 20884','[email protected]','(399)041-9264'),('Devin Obrien',50,'tDINluh8','62412 Perez Manors Suite 835 Gonzalezburgh, PR 02559','[email protected]','780-079-7830x52309'),('Joseph Miller',51,'8Ohpzv4c','56431 Simpson Estates Apt. 236 Estesmouth, GU 09126','[email protected]','930.993.5664x395'),('Stephen Webb MD',52,'FAT8r7EO','3534 Davies Stream North James, OR 62433','[email protected]','+1-607-417-6644'),('Michael Butler',53,'7UnoXRFz','8574 Barbara Rest Leonshire, CA 29132','[email protected]','+1-296-826-3659'),('Zachary Thompson',54,'MmkWhviY','24078 Alexander Junctions Suite 854 East Katherineshire, AZ 99256','[email protected]','001-547-549-8770'),('Benjamin Stout',55,'1RPaHHAo','Unit 6680 Box 2301 DPO AP 98946','[email protected]','803.828.6949x9984'),('Patrick Parker',56,'iMjxyBK7','175 Pierce Spur Apt. 106 Shannonland, DC 54705','[email protected]','+1-813-830-6382x379'),('Mary Miller',57,'HL17Qy2X','43776 Marsh Plain Rodneyborough, AL 53918','[email protected]','831.217.2046x5425'),('Savannah Page',58,'RjnY6SdM','555 Roy Courts Maciastown, CA 28772','[email protected]','(724)974-3514'),('Willie Johnson',59,'5rN9WtU5','6238 Claudia Drives Kylefurt, OK 54756','[email protected]','8438125183'),('Nicholas Hodges',60,'45nhtpqA','4266 Holder Rapid Apt. 071 Port Bryanport, KS 72891','[email protected]','+1-088-278-5338x6528'),('Matthew Zimmerman',61,'W6DaYF6o','393 Thomas Roads Matthewberg, NJ 47553','[email protected]','8667785261'),('Tracie Kelly',62,'iuz6qMIJ','049 Marc Glen Erintown, DC 63373','[email protected]','144-039-5862'),('Christy Wright',63,'zf9XgR6l','65835 Stevens Trail Apt. 423 East Ericaville, MH 50766','[email protected]','287-049-3790x374'),('Benjamin Nguyen',64,'ELrojDin','71777 Stephen Row West Jason, ME 69786','[email protected]','085.356.6190'),('Blake Williams',65,'WJXKhhXK','2127 Jason Stream Suite 236 Sarahstad, FL 93828','[email protected]','(654)114-9098x20040'),('Christopher Johnson',66,'uecnWwta','Unit 6072 Box 2412 DPO AA 57257','[email protected]','349-953-1905x786'),('Kathryn Johnson',67,'en7BqjQS','6724 Watson Hills Eddieview, MA 18602','[email protected]','+1-942-790-2888x0113'),('Laura Maxwell',68,'uJRLPPt3','841 Collins Drive Jessicaland, NC 96635','[email protected]','001-229-777-9307x9343'),('Scott Harvey',69,'w2CmpXWh','19360 Mary Roads Craigshire, SD 25178','[email protected]','(716)989-1428x219'),('Cynthia Gibbs',70,'cYVAQp9F','86869 Whitaker Creek Lake Jonathanview, MS 72039','[email protected]','+1-446-478-4243x4205'),('Ann Allen',71,'b4qR3rfL','20330 Walker Square Apt. 368 Pricefurt, RI 52787','[email protected]','(983)877-8199x3825'),('James Valenzuela',72,'o1OTwUGc','6110 Ryan Rue Suite 268 Hollandshire, FM 60078','[email protected]','880.061.9919x397'),('Jennifer Frye',73,'OLMzXoJ4','USNS Strong FPO AE 05647','[email protected]','001-875-730-9867'),('Ross Zamora',74,'X8OYVFen','916 Mathews Junctions Apt. 162 Clarkmouth, NM 10108','[email protected]','+1-354-498-4634x967'),('Jillian Lozano',75,'R4ILkWiM','35874 Adrienne Neck Amandamouth, ND 39050','[email protected]','232.804.0379'),('Ronald Downs',76,'ez19wNu4','4684 Ashley Street Suite 490 Joannastad, MS 41312','[email protected]','9465329517'),('John Garrett',77,'mNHzsJPP','20153 Villegas Motorway Apt. 567 Fordfurt, AR 47422','[email protected]','645-074-7065'),('Francisco Proctor',78,'pJ9MldVN','16900 Richard Crest Suite 237 Bergerburgh, NV 02649','[email protected]','(579)466-4726x98673'),('Robin Mills',79,'ogxr69Q1','47157 Thomas Loaf Apt. 195 South Steven, MD 92907','[email protected]','530.903.9879x3254'),('Krystal Hicks',80,'AqHH1rlJ','4395 Bell Hollow Williamhaven, DE 80420','[email protected]','(380)297-1712'),('Susan Hodge',81,'kRe1kvSG','07103 Jacob Mission Stephaniemouth, MP 97338','[email protected]','001-653-464-0017'),('Linda Green',82,'y83qbT8p','835 Ashley Mill Susanchester, MI 37946','[email protected]','001-232-864-9489x7460'),('Daniel Smith',83,'YS5t8Yfp','97387 Ashley Road West Kellyborough, AL 67704','[email protected]','660.057.1127'),('Debbie Figueroa',84,'BeD7XWKF','37851 Cowan Course New Michaeltown, DE 37517','[email protected]','(095)767-3564'),('Gregory Gonzalez',85,'6dp1L23s','USNS Fernandez FPO AA 90270','[email protected]','661-658-0326x9902'),('Alyssa Taylor',86,'mAzuV4tM','7158 Heidi Forge Matthewland, AZ 50120','[email protected]','398-637-7751'),('Robert Tate',87,'p1nsjX6u','877 Allison Stream Suite 288 Port Johnville, ND 51755','[email protected]','001-015-860-8561x6648'),('Richard Duncan',88,'ryEyKOC5','55030 Thompson Corners Teresaside, NJ 22813','[email protected]','901-839-5618x561'),('Jim Boyd',89,'NbR5nzIU','PSC 5726, Box 8078 APO AA 77433','[email protected]','315-357-6736'),('Tammy Stephenson',90,'uLC1Aeme','699 Patricia Plain Suite 549 Kristaborough, UT 11268','[email protected]','709.362.4636x1414'),('Shannon Webb',91,'gw6r6zS0','8539 Kim Shore Apt. 229 New Yeseniabury, WA 69234','[email protected]','+1-325-534-7639x4185'),('Travis Blanchard',92,'ob8mP1u4','230 Moore Crescent Kimberlymouth, OK 36079','[email protected]','885-873-9011x1156'),('Carlos Blair',93,'IbVa5I3m','4240 Cynthia Square Suite 677 Bradfordfurt, WV 42249','[email protected]','001-546-739-2636x35624'),('Michael Blair',94,'ZapEN5Qp','24351 Mary View Suite 054 South Steveport, OR 80160','[email protected]','001-304-762-2519x5175'),('Daniel Perez',95,'9eXYoBQS','55692 Kyle Place Apt. 805 East Julia, MI 94090','[email protected]','243-518-3075x453'),('Timothy Shepherd',96,'9YLbISzw','USNV Sharp FPO AP 97336','[email protected]','(261)993-7370x5956'),('Kimberly Garrison',97,'vYPvG1HO','4862 John Common Apt. 103 Jaredfurt, SC 15850','[email protected]','5856255627'),('Kenneth Robinson',98,'zREQv3et','3727 Wagner Gateway New Kyle, SC 68336','[email protected]','666.355.4369'),('Jerry Guerra',99,'Ue1Jl3Uc','7769 Tiffany River West Marc, HI 62788','[email protected]','(324)065-6096x22957'),('Robert Mejia',100,'TJhHii1J','196 Carter Knoll Port Tammy, MD 31833','[email protected]','260.031.6424');
/*!40000 ALTER TABLE `Customers` 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