INSERT INTO `sales_order_address` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,'Gloucestershire','GL51HX','YERBURY','41 Daniels Road','Stroud','yerburyr@gmail.com',NULL,'GB','RICHARD A','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,NULL,NULL,NULL,NULL,NULL,'Gloucestershire','GL51HX',NULL,'41 Daniels Road','Stroud','yerburyr@gmail.com',NULL,'GB','RICHARD A YERBURY','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,2,2,NULL,NULL,NULL,NULL,'Surrey','SM3 8NE','Pearce','Southerns House\n133 Church Hill Road','Cheam','info@jdevine.co.uk','02086410071','GB','Frances','billing',NULL,NULL,NULL,'J Devine Civil Engineering Ltd',NULL,NULL,NULL,NULL,NULL),(4,2,NULL,NULL,NULL,NULL,NULL,'Surrey','SM3 8NE','Pearce','Southerns House\n133 Church Hill Road','Cheam','info@jdevine.co.uk','02086410071','GB','Frances','shipping',NULL,NULL,NULL,'J Devine Civil Engineering Ltd',NULL,NULL,NULL,NULL,NULL),(5,3,3,NULL,NULL,NULL,NULL,'Warwickshire','CV37 8BF','George','2 Rivermeade\nBarton Road','Welford on Avon','Steffan.george@googlemail.com','07814911040','GB','Steffan','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,3,4,NULL,NULL,NULL,NULL,'Northants','NN11 3PZ','George','5d Great Central Way\nWoodford Halse','Daventry',NULL,'07814911040','GB','Steffan','shipping',NULL,NULL,NULL,'Master Locksmiths Association',NULL,NULL,NULL,NULL,NULL),(7,4,NULL,NULL,NULL,NULL,NULL,'Northumberland ','NE13 6BZ','Robertson','The Cheese Farm\nGreen lane','Blagdon','admin@northumberland-cheese.co.uk','01670 789798','GB','M','billing',NULL,NULL,NULL,'Northumberland Cheese Company',NULL,NULL,NULL,NULL,NULL),(8,4,NULL,NULL,NULL,NULL,NULL,'Northumberland ','NE13 6BZ','Robertson','The Cheese Farm\nGreen lane','Blagdon','admin@northumberland-cheese.co.uk','01670 789798','GB','M','shipping',NULL,NULL,NULL,'Northumberland Cheese Company',NULL,NULL,NULL,NULL,NULL),(9,5,NULL,NULL,NULL,NULL,NULL,'Wiltshire','SN14 0JW','Chamberlin','349a hungerdown lane','Chippenham','bri2109@gmail.com','07761496508','GB','Brian','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,5,NULL,NULL,NULL,NULL,NULL,'Wiltshire','SN14 0JW','Chamberlin','349a hungerdown lane','Chippenham','bri2109@gmail.com','07761496508','GB','Brian','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,6,NULL,NULL,NULL,NULL,NULL,'West Yorkshire','Ls26 0sn','Rastall','15 Northfield Avenue\nRothwell','Leeds','ryan@jwgolf.co.uk','07834390762','GB','Ryan','billing',NULL,NULL,NULL,'Ryan Rastall',NULL,NULL,NULL,NULL,NULL),(12,6,NULL,NULL,NULL,NULL,NULL,'West Yorkshire','Ls27 0nx','Rastall','Scotchman Lane\nMorley','Leeds',NULL,'01924350102','GB','Ryan','shipping',NULL,NULL,NULL,'Howley Hall Golf Club',NULL,NULL,NULL,NULL,NULL),(13,7,NULL,NULL,NULL,NULL,NULL,'Herefordshire ','HR95SP ','Stones','Watership \nHowle Hill','Ross-on-Wye','dstones00@hotmail.com','01989765513','GB','David','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,7,NULL,NULL,NULL,NULL,NULL,'Herefordshire ','HR95SP ','Stones','Watership \nHowle Hill','Ross-on-Wye','dstones00@hotmail.com','01989765513','GB','David','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,8,NULL,NULL,NULL,NULL,NULL,'Somerset','BS26 2JU','Quantrill','High Meadow\nNottinghill Way','Weare','hmeadow@btinternet.com','+44 1934732882','GB','robert','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,8,NULL,NULL,NULL,NULL,NULL,'Somerset','BS26 2JU',NULL,'High Meadow\nNottinghill Way','Weare','hmeadow@btinternet.com','+44 1934732882','GB','robert Quantrill','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,9,NULL,NULL,NULL,NULL,NULL,'Surrey','SM2 7BY','Carter','54 Burdon Lane','Cheam','rupert_nospam@mac.com','0181 642 93931','GB','Rupert','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,9,NULL,NULL,NULL,NULL,NULL,'Surrey','SM2 7BY','Carter','54 Burdon Lane','Cheam','rupert_nospam@mac.com','0181 642 93931','GB','Rupert','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,10,NULL,NULL,NULL,NULL,NULL,NULL,'Wr9 0RP','Parkes','66 Oakleigh Road','Droitwich Spa','andrewparkes1974@hotmail.co.uk','01995773313','GB','Andrew','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,10,NULL,NULL,NULL,NULL,NULL,NULL,'Wr9 0RP','Parkes','66 Oakleigh Road','Droitwich Spa','andrewparkes1974@hotmail.co.uk','01995773313','GB','Andrew','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,11,NULL,NULL,NULL,NULL,NULL,'Hampshire','PO17 6LT','paffett','4\nPook Lane','Fareham','juliepaffett@hotmail.co.uk','+44 1329480138','GB','Julie','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,11,NULL,NULL,NULL,NULL,NULL,'Hampshire','PO17 6LT',NULL,'4\nPook Lane','Fareham','juliepaffett@hotmail.co.uk','+44 1329480138','GB','Julie paffett','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,13,5,NULL,NULL,NULL,'01142728165',NULL,'NN10 6FB','Fox ','Suite 5 \nsapphire House','Rushden ','john.fox@kier.co.uk','07791920617','GB','John ','billing',NULL,NULL,NULL,'Kier Group ',NULL,NULL,NULL,NULL,NULL),(26,13,6,NULL,NULL,NULL,'01142728165',NULL,'S2 1TR','Fox ','Manor Lane','Sheffield ',NULL,'07791920016','GB','John ','shipping',NULL,NULL,NULL,'Kier Services ',NULL,NULL,NULL,NULL,NULL),(27,14,NULL,NULL,NULL,NULL,NULL,'Buckinghamshire','sl2 3qt','Waters','11 Holly Close','Farnham Common','awaters_pyl@hotmail.com','+44 7790686283','GB','Andrew','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,14,NULL,NULL,NULL,NULL,NULL,'Buckinghamshire','sl2 3qt',NULL,'11 Holly Close','Farnham Common','awaters_pyl@hotmail.com','+44 7790686283','GB','Andrew Waters','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,15,NULL,NULL,NULL,NULL,NULL,NULL,'NR2 3JP','Nichols','75 College Road','Norwich','tom_nichols_@hotmail.com','+44 7738200395','GB','Thomas','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,15,NULL,NULL,NULL,NULL,NULL,NULL,'NR2 3JP',NULL,'75 College Road','Norwich','tom_nichols_@hotmail.com','+44 7738200395','GB','Mr T Nichols','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,16,NULL,NULL,NULL,NULL,NULL,'Lancashire','PR29AP','Greenhalgh','28 Whinsands Close','Fulwood, Preston','dg4jg2@yahoo.co.uk','+44 7944930979','GB','Duncan','billing','Mr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,16,NULL,NULL,NULL,NULL,NULL,'Lancashire','PR29AP',NULL,'28 Whinsands Close','Fulwood, Preston','dg4jg2@yahoo.co.uk','+44 7944930979','GB','Duncan Greenhalgh','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,17,NULL,NULL,NULL,NULL,NULL,'Suffolk','ip3 9nl','gillett','105 Maryon Road','Ipswich','peter.gillett@ntlworld.com','+44 1473405728','GB','peter','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,17,NULL,NULL,NULL,NULL,NULL,'Suffolk','ip3 9nl',NULL,'105 Maryon Road','Ipswich','peter.gillett@ntlworld.com','+44 1473405728','GB','peter gillett','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,18,NULL,NULL,NULL,NULL,'douglas.dinks@btinternet.com','Oxfordshire','OX14 4HZ','Smith','13 The Green\nDrayton','Abingdon','douglas.dinks@btinternet.com','01235531552','GB','Douglas','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,18,NULL,NULL,NULL,NULL,'douglas.dinks@btinternet.com','Oxfordshire','OX14 4HZ','Smith','13 The Green\nDrayton','Abingdon','douglas.dinks@btinternet.com','01235531552','GB','Douglas','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,19,NULL,NULL,NULL,NULL,NULL,'Newport','NP19 0LD','VENCKUNAS','15 Tantallus Cresent','GWENT','dainiuska123@mail.ru','+44 7845134071','GB','DAINIUS','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,19,NULL,NULL,NULL,NULL,NULL,'Newport','NP19 0LD',NULL,'15 Tantallus Cresent','GWENT','dainiuska123@mail.ru','+44 7845134071','GB','DAINIUS VENCKUNAS'

LOCK TABLES `admin_user` WRITE;
/*!40000 ALTER TABLE `admin_user` DISABLE KEYS */;
INSERT INTO `admin_user` VALUES (1,'admin','admin','k_dutta98@yahoo.com','admin','381e90cd419c257a3ba6be099128559b07f1853138d2bc02856062fbb2b94732:V8GNCMvLhsbU9iaA8zbm9W2tgkJKMPi4:1','2020-12-08