-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathAllQueries.sql
18 lines (16 loc) · 14.5 KB
/
AllQueries.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
INSERT INTO AspNetRoles
VALUES ('1234567890', 'canEdit');
INSERT INTO AspNetUserRoles
VALUES ('5da00c27-6748-4cfb-9016-95c7bce5b0f8', '1234567890');
DROP TABLE __MigrationHistory
DROP TABLE AspNetUserClaims
DROP TABLE AspNetUserLogins
DROP TABLE Customers
DROP TABLE AspNetUserRoles
DROP TABLE AspNetRoles
DROP TABLE AspNetUsers
INSERT INTO Customers([FirstName],[LastName],[CompanyName],[Address],[City],[State],[Zip],[PhoneNumber],[Email]) VALUES('Dieter','Hancock','Quisque LLP','Ap #330-4802 Nam Street','Topeka','KS','31627','(715) 788-9256','[email protected]'),('Ishmael','Daniels','Tortor Dictum Eu Consulting','478-7363 Velit Avenue','Springfield','IL','27308','(193) 477-9091','[email protected]'),('Ignatius','Barrera','Et Corp.','Ap #631-1042 Donec Av.','Stamford','CT','39583','(438) 799-6652','[email protected]'),('Zane','Turner','Quisque Consulting','2286 Nonummy. Road','Cincinnati','OH','66078','(815) 941-2661','[email protected]'),('Callum','Cline','Quam A Felis Associates','P.O. Box 199, 7116 Fusce St.','Salt Lake City','UT','35211','(355) 360-8749','[email protected]'),('Ahmed','Palmer','Ligula Nullam Incorporated','Ap #772-7792 Magna. St.','Reno','NV','51157','(518) 346-6835','[email protected]'),('Ezekiel','Wilkinson','Integer Corp.','1779 Ac Rd.','Anchorage','AK','99816','(606) 225-4452','[email protected]'),('Lev','Bright','Nulla Company','Ap #655-6357 Libero St.','Los Angeles','CA','92107','(388) 247-6683','[email protected]'),('Hyatt','Stanton','Pharetra Sed LLC','Ap #547-8724 Lacinia. Ave','Overland Park','KS','25005','(820) 369-8247','[email protected]'),('Brian','Mullen','Quam LLC','Ap #906-2183 Donec Avenue','Billings','MT','44950','(603) 240-9898','[email protected]'),('Barry','Mcintosh','Purus Duis LLP','Ap #612-626 Morbi Street','Georgia','GA','15829','(517) 351-1611','[email protected]'),('Ralph','Leon','Metus Sit Corporation','673-2855 Est, Ave','Lakewood','CO','47521','(381) 590-6600','[email protected]'),('John','Mcleod','Scelerisque Scelerisque Associates','Ap #794-8555 Ac Avenue','Cheyenne','WY','17028','(593) 608-8403','[email protected]'),('Preston','Banks','Ridiculus Mus Proin Foundation','Ap #753-2622 Duis St.','Chandler','AZ','85629','(850) 765-6074','[email protected]'),('Thane','Wynn','Vel Nisl Consulting','946-2514 Nibh. St.','Bloomington','MN','67726','(958) 659-6027','[email protected]'),('Beau','Tran','Hendrerit Donec Porttitor Associates','P.O. Box 306, 2315 Quis, St.','Fort Worth','TX','34331','(833) 203-6266','[email protected]'),('Ray','Compton','Mus Aenean Eget PC','7326 Ac Rd.','Portland','ME','80938','(275) 169-3721','[email protected]'),('Cody','Bright','Nam Consequat Ltd','795 Nibh. Rd.','Anchorage','AK','99957','(938) 125-0147','[email protected]'),('Ivor','Andrews','Fermentum Institute','Ap #160-655 Metus Rd.','Annapolis','MD','23556','(284) 540-7923','[email protected]'),('Emerson','Stokes','Pede Cum Sociis PC','P.O. Box 485, 1755 Tincidunt Ave','Tuscaloosa','AL','36239','(246) 108-8786','[email protected]');
INSERT INTO Customers([FirstName],[LastName],[CompanyName],[Address],[City],[State],[Zip],[PhoneNumber],[Email]) VALUES('Bevis','Reed','Libero Lacus Consulting','1390 Scelerisque Road','Bellevue','NE','30882','(970) 675-1100','[email protected]'),('Otto','Barr','Vehicula Consulting','890-4158 Eget, Street','Metairie','LA','69134','(348) 481-9534','[email protected]'),('Emmanuel','Lyons','Mus Consulting','Ap #109-6086 Adipiscing St.','Kaneohe','HI','47712','(950) 484-7432','[email protected]'),('Yardley','Cardenas','Orci Lacus Vestibulum Industries','2648 Gravida Road','Salt Lake City','UT','12955','(959) 288-2756','[email protected]'),('Shad','Stephenson','Eleifend Non Dapibus Associates','Ap #283-4622 Scelerisque, St.','Cincinnati','OH','54682','(124) 153-9730','[email protected]'),('Griffith','Pratt','Mus Donec Company','Ap #992-5822 Mollis St.','Missoula','MT','20894','(223) 671-7063','[email protected]'),('Merrill','Walls','Neque Inc.','1972 Penatibus Ave','Newport News','VA','98039','(755) 348-0867','[email protected]'),('Kenyon','Mcgowan','Mauris Ipsum Porta Limited','Ap #430-6299 Fusce Rd.','Carson City','NV','82515','(579) 594-6611','[email protected]'),('Hall','Hooper','Pellentesque Tincidunt Associates','8084 Primis Avenue','Tampa','FL','34507','(848) 594-2724','[email protected]'),('Ali','Wooten','Cursus Diam At Consulting','P.O. Box 419, 5276 Risus St.','Tuscaloosa','AL','35137','(312) 216-4460','[email protected]'),('Robert','Woodard','Eu Consulting','Ap #182-1680 Risus. Av.','College','AK','99669','(861) 223-2874','[email protected]'),('Knox','Guthrie','Cras Associates','P.O. Box 649, 7294 Facilisis. Road','Fresno','CA','91543','(127) 593-9363','[email protected]'),('Rooney','Ferguson','Parturient Montes Nascetur Inc.','P.O. Box 815, 1882 Ullamcorper, Street','Bozeman','MT','24382','(489) 662-5156','[email protected]'),('Mufutau','Avery','Risus Donec LLC','1590 Sed Street','Virginia Beach','VA','67873','(756) 620-9068','[email protected]'),('Bert','Marks','Sem Mollis Dui Ltd','P.O. Box 808, 1069 Quis, Road','Colorado Springs','CO','88545','(436) 992-6630','[email protected]'),('Gary','Blackwell','Nunc Inc.','122-4261 Consequat St.','Tacoma','WA','13048','(734) 708-1825','[email protected]'),('Nero','Camacho','Aenean Gravida Nunc Corp.','7417 Eu, Street','Lincoln','NE','60595','(807) 927-8755','[email protected]'),('Kadeem','Compton','Erat Vel Pede LLP','9359 Sapien, St.','Virginia Beach','VA','29822','(417) 784-7094','[email protected]'),('Oren','Weaver','Lectus Consulting','P.O. Box 929, 3349 Dolor. Avenue','Kansas City','KS','14894','(764) 769-3429','[email protected]'),('Tanek','Cortez','Dapibus Ligula Corp.','Ap #644-6575 Lobortis Rd.','Baltimore','MD','95026','(684) 852-5776','[email protected]');
INSERT INTO Customers([FirstName],[LastName],[CompanyName],[Address],[City],[State],[Zip],[PhoneNumber],[Email]) VALUES('Drake','Rush','Nec Cursus Ltd','Ap #417-5012 Ipsum Ave','Tuscaloosa','AL','36658','(239) 651-6764','[email protected]'),('Chandler','Baldwin','Enim Etiam Gravida Foundation','Ap #385-3007 Mi. St.','Salt Lake City','UT','84530','(884) 808-4499','[email protected]'),('Salvador','Parsons','Nibh Corporation','P.O. Box 119, 1264 Commodo Ave','Salt Lake City','UT','53644','(749) 561-6458','[email protected]'),('Malik','Miller','Neque Consulting','Ap #950-4642 Fames Rd.','Tampa','FL','93601','(625) 183-1032','[email protected]'),('Victor','Mann','Massa LLP','Ap #595-6100 Ac Street','Hartford','CT','92269','(591) 124-8623','[email protected]'),('Curran','Gilmore','Sem Institute','Ap #895-5771 Tincidunt, Av.','Cedar Rapids','IA','68994','(346) 294-5041','[email protected]'),('Drake','Orr','Pede Nonummy Ut Corporation','P.O. Box 840, 3961 Enim, St.','Owensboro','KY','27987','(909) 148-3779','[email protected]'),('Ian','Palmer','Faucibus Corp.','P.O. Box 342, 2571 Rutrum Rd.','Lowell','MA','83335','(962) 943-5639','[email protected]'),('Brendan','Harrington','Nullam Industries','Ap #609-3210 Ac Street','Duluth','MN','84163','(686) 946-1217','[email protected]'),('Tiger','Chen','Tempor Inc.','Ap #685-4378 Scelerisque, Avenue','Houston','TX','45974','(936) 875-4893','[email protected]'),('Aaron','Vaughn','Lorem Donec Elementum LLP','134-7996 Integer Road','Aurora','IL','99773','(179) 989-2283','[email protected]'),('Declan','Garner','Vestibulum Mauris Corp.','465-2243 Nullam Rd.','Lakewood','CO','19559','(664) 793-6260','[email protected]'),('Beck','Owens','Malesuada Augue Ut Limited','P.O. Box 492, 9392 Pharetra Av.','Kearney','NE','91864','(838) 187-3503','[email protected]'),('Samson','Barnett','Suspendisse Aliquet Molestie Inc.','368-1720 Phasellus Ave','Burlington','VT','89293','(835) 267-8754','[email protected]'),('Brady','Hays','Ut Institute','P.O. Box 407, 2702 Ipsum Street','San Antonio','TX','82496','(668) 666-2985','[email protected]'),('Marvin','Perry','Libero Corp.','P.O. Box 697, 4560 Adipiscing. Street','Augusta','GA','46320','(992) 506-8825','[email protected]'),('Xavier','Ruiz','Mauris Inc.','7122 Tellus Ave','Davenport','IA','53769','(296) 648-2950','[email protected]'),('Elijah','Irwin','Elit A Incorporated','Ap #414-1653 Dolor, Avenue','Allentown','PA','70086','(852) 161-0912','[email protected]'),('Barrett','Byrd','Amet Metus Inc.','Ap #925-3568 Leo. Avenue','Chicago','IL','92163','(818) 180-0081','[email protected]'),('Ryder','Sargent','Per Inceptos Consulting','322-8214 Convallis Av.','Reading','PA','76637','(762) 295-7934','[email protected]');
INSERT INTO Customers([FirstName],[LastName],[CompanyName],[Address],[City],[State],[Zip],[PhoneNumber],[Email]) VALUES('Jarrod','Daniels','Enim Nunc Corp.','736-1950 Accumsan St.','Birmingham','AL','36577','(754) 931-4857','[email protected]'),('Seth','Berger','Nullam Enim LLC','Ap #662-5579 Ante Avenue','San Antonio','TX','98577','(344) 861-3752','[email protected]'),('Rashad','Hendricks','Sit Industries','2206 Lorem Rd.','Tulsa','OK','19081','(417) 214-3021','[email protected]'),('Jackson','Knowles','Elementum Dui PC','694-2716 Nunc Road','Juneau','AK','99841','(689) 567-1483','[email protected]'),('Uriel','Crosby','Luctus Aliquet Associates','P.O. Box 268, 7940 A Ave','Houston','TX','58747','(232) 276-2304','[email protected]'),('Wade','Boone','Vitae Ltd','Ap #766-4256 Pede. Rd.','San Jose','CA','96998','(808) 588-1284','[email protected]'),('Hedley','Alexander','Ultrices Associates','5250 Eros. Rd.','Overland Park','KS','91833','(709) 562-2239','[email protected]'),('Arthur','Hayden','Sagittis Duis Gravida LLP','765-7398 Cras Ave','Fayetteville','AR','72175','(858) 342-5951','[email protected]'),('Rogan','Lambert','Sodales Mauris Inc.','7600 Arcu. Ave','Broken Arrow','OK','10967','(176) 529-3826','[email protected]'),('Thane','Moon','Mauris Sit PC','312-6717 Morbi Street','Tacoma','WA','86901','(453) 695-0264','[email protected]'),('Aladdin','Figueroa','Nec Ltd','477-396 Nunc St.','South Bend','IN','30222','(150) 914-4898','[email protected]'),('Keith','Hansen','Sem LLP','Ap #866-6784 In St.','Rochester','MN','30935','(567) 573-8775','[email protected]'),('Ian','Britt','Ligula Aliquam Erat Corporation','773 Ornare, St.','Eugene','OR','22361','(537) 816-4060','[email protected]'),('Tad','Patrick','Lobortis Foundation','7499 Ligula. Street','Salem','OR','72710','(387) 637-7883','[email protected]'),('Bert','Wilson','Praesent Eu Dui Industries','219-2130 Augue St.','Lafayette','LA','23109','(832) 894-9529','[email protected]'),('Wing','Perry','Velit Justo Consulting','Ap #755-9438 Dolor St.','Kansas City','KS','66531','(588) 332-1322','[email protected]'),('Clinton','Wilkins','Ipsum Leo Elementum Industries','Ap #702-9698 Et St.','Bridgeport','CT','35343','(270) 875-5725','[email protected]'),('Ulysses','Scott','Eros Proin Company','Ap #986-3447 Phasellus Ave','Vancouver','WA','29492','(985) 397-3952','[email protected]'),('Beck','Wilcox','Aliquam Iaculis Lacus Corp.','5390 Nulla. St.','San Antonio','TX','47198','(320) 138-5614','[email protected]'),('Zahir','Parker','Ut Pharetra Associates','P.O. Box 222, 4274 Nulla. Rd.','Bloomington','MN','94009','(872) 742-7089','[email protected]');
INSERT INTO Customers([FirstName],[LastName],[CompanyName],[Address],[City],[State],[Zip],[PhoneNumber],[Email]) VALUES('Keefe','Giles','Fringilla Cursus Inc.','792-1862 Ipsum Rd.','Norman','OK','12307','(558) 428-6187','[email protected]'),('Ira','Weiss','Pede Limited','P.O. Box 942, 5087 A, St.','Wilmington','DE','94273','(216) 237-6942','[email protected]'),('Bevis','Dunlap','Duis Limited','Ap #879-651 In Street','Kaneohe','HI','96332','(411) 409-8684','[email protected]'),('Christopher','Salinas','Nascetur Consulting','9202 Ultricies Ave','Saint Paul','MN','98189','(675) 829-1745','[email protected]'),('Ivor','Gilbert','Non Feugiat LLP','467-5940 Risus. St.','Hartford','CT','72498','(673) 382-0897','[email protected]'),('Rogan','Rogers','Dictum Foundation','5825 Ut Ave','Lincoln','NE','68217','(891) 204-7456','[email protected]'),('Cadman','Brock','Sit Amet Corporation','8221 Nec Avenue','College','AK','99545','(405) 521-5443','[email protected]'),('Emmanuel','Ayers','Mollis Nec Cursus Industries','801 Augue St.','Juneau','AK','99608','(934) 547-5507','[email protected]'),('Chaim','Shepard','Et Arcu Consulting','772-1183 Rhoncus Av.','Knoxville','TN','88538','(129) 675-5532','[email protected]'),('Bruce','Noble','Penatibus Institute','P.O. Box 507, 9621 A Road','Birmingham','AL','36227','(186) 513-3668','[email protected]'),('Lionel','Wood','Vivamus Institute','Ap #611-2742 Consectetuer St.','Independence','MO','40617','(564) 327-2900','[email protected]'),('Merritt','Powers','Ornare LLC','866-3784 Pretium St.','Sterling Heights','MI','99493','(167) 592-1170','[email protected]'),('Quinn','Walton','Ut Dolor Dapibus PC','Ap #101-5497 Dolor. Road','Sioux City','IA','11910','(118) 714-4070','[email protected]'),('Brendan','Zimmerman','Magna Nam Ligula Associates','P.O. Box 780, 6930 Cras Road','Gaithersburg','MD','68914','(436) 605-9402','[email protected]'),('Abbot','Justice','Donec Egestas Associates','P.O. Box 900, 7058 Nulla St.','Pocatello','ID','45362','(808) 456-9319','[email protected]'),('Bruno','Franco','Montes Nascetur Ridiculus LLP','132 Nulla St.','Bozeman','MT','60189','(563) 797-7126','[email protected]'),('Malik','Harvey','Convallis In Associates','P.O. Box 752, 1823 Est, Avenue','Detroit','MI','40384','(369) 173-5276','[email protected]'),('Randall','Castillo','Mi Ltd','Ap #118-4496 Vitae Avenue','Mobile','AL','35628','(366) 954-3887','[email protected]'),('Elvis','Willis','Ligula Aenean LLC','721-1324 Nulla Rd.','Gillette','WY','64232','(490) 880-6753','[email protected]'),('Chadwick','Brock','Congue A Corporation','P.O. Box 493, 1367 Ipsum. Avenue','Hillsboro','OR','16065','(126) 317-7091','[email protected]');