CREATE TABLE hudsonu.vendor(
vendor_id int PRIMARY KEY
,name VARCHAR(31)
,url VARCHAR(37)
,address VARCHAR(34)
,address2 VARCHAR(12)
,city VARCHAR(17)
,state CHAR(2)
,zip char(5)
,phone VARCHAR(15)
,fax VARCHAR(14)
);
INSERT INTO hudsonu.vendor VALUES (138,'47','https://www.47brand.com/','132 Campanelli Industrial Drive','Door 27','Brockton','MA',02301,'781-702-2921',NULL);
INSERT INTO hudsonu.vendor VALUES (183,'Adidas','https://www.adidas.com/us','5055 N Greeley Avenue',NULL,'Portland','OR',97217,'(800) 982-9337','(971) 234-2450');
INSERT INTO hudsonu.vendor VALUES (154,'Alex And Ani Inc','https://www.alexandani.com/','2000 Chapel View Blvd',NULL,'Cranston','RI',2920,'800-725-7822',NULL);
INSERT INTO hudsonu.vendor VALUES (157,'All Star Dogs','http://www.allstardogs.com/','20 Hastings Road',NULL,'Marlboro','NJ',07746,'800-391-3520','732-566-3401');
INSERT INTO hudsonu.vendor VALUES (153,'Alta Gracia Holdco, Inc','http://www.altagraciaapparel.com/','160 E Saint John St',NULL,'Spartanburg','SC',29306,'(864) 285-9810',NULL);
INSERT INTO hudsonu.vendor VALUES (180,'Alternative Apparel','https://www.alternativeapparel.com/','1650 Indian Brook Way','Ste 200','Norcross','GA',30093,'(877) 747-2915',NULL);
INSERT INTO hudsonu.vendor VALUES (127,'Ambrose Enterprises LLC','https://www.adrenalinepromotions.com/','1527 Brentwood Ln',NULL,'Mount Vernon','WA',98274,'(360) 752-2700',NULL);
INSERT INTO hudsonu.vendor VALUES (178,'Baden Sports, Inc.','https://www.badensports.com/','19015 66TH Ave S',NULL,'Kent','WA',98032,'(253) 925-0500',NULL);
INSERT INTO hudsonu.vendor VALUES (121,'Blue 84','https://blue84.com/','750 Randolph Rd',NULL,'Detroit Lakes','MN',56501,'(218) 847-2171',NULL);
INSERT INTO hudsonu.vendor VALUES (190,'Boelter Brands','https://www.boelterbrands.com/','117 SOUTHEAST PKWY',NULL,'FRANKLIN','TN',37064,'(844) 564-6432',NULL);
INSERT INTO hudsonu.vendor VALUES (182,'Boxercraft Inc','https://boxercraft.com/','7131 Discovery Blvd',NULL,'Mableton','GA',30126,'(404) 355-9994',NULL);
INSERT INTO hudsonu.vendor VALUES (194,'Branded Logistics LLC','https://branded-logistics.com/','528 N Link Ln Unit 2',NULL,'Fort Collins','CO',80524,'(970) 510-6000',NULL);
INSERT INTO hudsonu.vendor VALUES (132,'C.D.I. Corporation','https://www.cdi-corp.com/','3440 N. Knox',NULL,'Chicago','IL',60641,'(773) 205-2960',NULL);
INSERT INTO hudsonu.vendor VALUES (130,'Capri Designs','https://www.capridesigns.com/','549 Capri Point',NULL,'Lavonia','GA',30553,'(678) 400-2354','(706) 356-0228');
INSERT INTO hudsonu.vendor VALUES (103,'Carolina Sewn Products Corp','http://carolinasewnproducts.com/','145 CANE CREEK INDUSTRIAL PARK RD.','SUITE 125','Fletcher','NC',28732,'800-920-5944',NULL);
INSERT INTO hudsonu.vendor VALUES (100,'Catstudio Inc','https://www.catstudio.com/','1340 Industrial Avenue','Suite A','Petaluma','CA',94952,'800-819-3367','707-778-8100');
INSERT INTO hudsonu.vendor VALUES (163,'Centon Electronics Inc','http://www.centon.com/','27412 Aliso Viejo Pkwy',NULL,'Aliso Viejo','CA',92656,'(949) 855-9111',NULL);
INSERT INTO hudsonu.vendor VALUES (140,'Champion Products','https://www.champion.com/','1000 East Hanes Mill Road',NULL,'Winston Salem','NC',27105,'336-519-8080',NULL);
INSERT INTO hudsonu.vendor VALUES (136,'College Concepts','https://www.conceptssport.com/','3350 Riverwood Parkway','Suite 850','Atlanta','GA',30339,'800-284-4288',NULL);
INSERT INTO hudsonu.vendor VALUES (117,'College Kids','https://collegekids.com/','209 Rockwood Ln',NULL,'Neenah','WI',54956,'(800) 556-2036',NULL);
INSERT INTO hudsonu.vendor VALUES (107,'Collegiate Pacific','https://collegiatepacific.com/','532 Luck Avenue',NULL,'Roanoke','VA',24016,'800-336-5996',NULL);
INSERT INTO hudsonu.vendor VALUES (137,'Colosseum Athletics','https://www.colosseumusa.com/','2400 S Wilmington Ave',NULL,'Compton','CA',90220,'(310) 667-8341',NULL);
INSERT INTO hudsonu.vendor VALUES (108,'Cutter ' || chr(38) ||' Buck','https://cutterbuck.com/','4001 Oakesdale Ave SW',NULL,'Renton','WA',98057,'(206) 622-4191',NULL);
INSERT INTO hudsonu.vendor VALUES (193,'E5','https://e5usa.com/','61 Willet Street','Suite QQ','Passaic','NJ',7055,'(973) 773-0750','(973) 773-0751');
INSERT INTO hudsonu.vendor VALUES (109,'Fall Rush','https://www.follett.com/fallrush/','2470 Bancroft Way',NULL,'Berkeley','CA',94704,'(510) 845-1226',NULL);
INSERT INTO hudsonu.vendor VALUES (147,'Fanmats LLC','https://www.fanmats.com/','61 Willet Street','Suite QQ','Passaic','NJ',07055,'(973) 773-0750','(973) 773-0751');
INSERT INTO hudsonu.vendor VALUES (167,'FOCO','https://www.foco.com/','2301 Cottontail Lane',NULL,'Somerset','NJ',08873,'(848) 260-4260',NULL);
INSERT INTO hudsonu.vendor VALUES (112,'For Bare Feet, Inc.','https://www.forbarefeet.com/','1201 S Ohio St','Ste A','Martinsville','IN',46151,'(765) 349-7474',NULL);
INSERT INTO hudsonu.vendor VALUES (177,'Four Point Products','https://fourpoint.com/','1 Looseleaf Lane',NULL,'Vincent','AL',35178,'800-456-6603',NULL);
INSERT INTO hudsonu.vendor VALUES (156,'Framing Success','https://www.framingsuccess.com/','2556 Horse Pasture Road',NULL,'Virginia Beach','VA',23453,'800-200-2044','800-576-3726');
INSERT INTO hudsonu.vendor VALUES (101,'Gameday Couture','https://www.shopthesoho.com/','8620 S Peoria Ave',NULL,'Tulsa','OK',74132,'(855) 343-6100',NULL);
INSERT INTO hudsonu.vendor VALUES (111,'Gametime Sidekicks LLC','https://www.gametimesidekicks.com/','2339 W Beaver Creek Dr',NULL,'Powell','TN',37849,'(865) 938-6822',NULL);
INSERT INTO hudsonu.vendor VALUES (135,'Garb','http://www.garbathletics.com/','PO Box 1561',NULL,'Spanish Fork','UT',84660,'(888) 864-1955',NULL);
INSERT INTO hudsonu.vendor VALUES (174,'Gear For Sports','http://www.gearforsports.com/','9700 Commerce Parkway',NULL,'Lenexa','KS',66219,'800-255-1065',NULL);
INSERT INTO hudsonu.vendor VALUES (151,'Hillflint, Inc','https://hillflint.com/','1732 1ST Ave',NULL,'New York','NY',10128,'(212) 390-8337',NULL);
INSERT INTO hudsonu.vendor VALUES (197,'Holland Bar Stool Co.','https://hollandbarstool.com/','12839 Corporate Circle Place',NULL,'Holland','MI',49424,'(800) 423-1903','888 391-7468');
INSERT INTO hudsonu.vendor VALUES (179,'House of Doolittle','http://www.houseofdoolittle.com/','3001 Malmo Drive',NULL,'Arlington Heights','IL',60005,'800-621-9546','888-621-6660');
INSERT INTO hudsonu.vendor VALUES (175,'Image One','https://imageonecollegiate.com/','3300 W 65th Street',NULL,'Little Rock','AR',72209,'(501) 663-9595',NULL);
INSERT INTO hudsonu.vendor VALUES (122,'Innovative Adhesives, LLC','https://fanapeel.com/','P.O. Box 1719',NULL,'Cary','NC',27512,'866-926-2266',NULL);
INSERT INTO hudsonu.vendor VALUES (115,'Jardine Associates','https://www.jardineassociates.com/','200 Compass Circle',NULL,'North Kingstown','RI',2852,'(800) 543-7655','(401) 667-3818');
INSERT INTO hudsonu.vendor VALUES (125,'Jaymac Sports Products','https://jaymacsports.com/','4255 Bannockburn Rd',NULL,'Florence','SC',29505,'843-661-5622',NULL);
INSERT INTO hudsonu.vendor VALUES (114,'Jenkins Enterprises','https://www.jenkins-enterprises.com/','7200 Industry Dr',NULL,'North Little Rock','AR',72117,'(501) 945-2600',NULL);
INSERT INTO hudsonu.vendor VALUES (120,'Johnnie-O','https://www.johnnie-o.com/','2048 Cotner Avenue',NULL,'Los Angeles','CA',90025,'877-787-4703',NULL);
INSERT INTO hudsonu.vendor VALUES (187,'Jostens Inc','https://www.jostens.com/','7760 France Ave S','Ste 400','Minneapolis','MN',55435,'(952) 830-3300',NULL);
INSERT INTO hudsonu.vendor VALUES (149,'Kitty Keller Designs','https://kittykeller.com/','416 N. Austin Street',NULL,'Seguin','TX',78155,'877-597-3357','830-303-7040');
INSERT INTO hudsonu.vendor VALUES (131,'Ladiva Sport LLC','https://ladivasport.com/','7511 E Rose Garden Ln',NULL,'Scottsdale','AZ',85255,'(855) 523-4827',NULL);
INSERT INTO hudsonu.vendor VALUES (191,'Landes Inc','https://www.landesusa.com/','4500 S. Pinemont Dr',NULL,'HOUSTON','TX',77041,'713-665-0655','713-665-6392');
INSERT INTO hudsonu.vendor VALUES (181,'League Collegiate Wear','https://league-legacy.com/','299 Fame Ave',NULL,'Hanover','PA',17331,'800-627-3243','(717)630-0826');
INSERT INTO hudsonu.vendor VALUES (158,'Legacy Apparel','https://league-legacy.com/','300 Fame Ave',NULL,'Hanover','PA',17331,'800-627-3244','(717)630-0827');
INSERT INTO hudsonu.vendor VALUES (146,'Life Is Good','https://www.lifeisgood.com/','15 Hudson Park Dr',NULL,'Hudson','NH',3051,'(603) 594-6100',NULL);
INSERT INTO hudsonu.vendor VALUES (185,'Logo Brands','https://logobrands.com/','117 SE Parkway',NULL,'Franklin','TN',37064,'(615) 261-2100',NULL);
INSERT INTO hudsonu.vendor VALUES (145,'Logofit LLC','https://www.logofit.com/','3202 Lapeer Rd',NULL,'Flint','MI',48503,'(810) 715-1980',NULL);
INSERT INTO hudsonu.vendor VALUES (172,'Lokai Holdings LLC','https://lokai.com/','180 Varick St','Rm 504','New York','NY',10014,'(646) 979-3474',NULL);
INSERT INTO hudsonu.vendor VALUES (128,'LXG','https://www.lxginc.com/','921 S Park Ln',NULL,'Tempe','AZ',85281,'(602) 437-5550','602-437-5445');
INSERT INTO hudsonu.vendor VALUES (139,'Mascot Factory','https://www.mascotfactory.com/','12340 Stowe Drive','Suite B','Poway','CA',92064,'(858) 679-2244','(407) 386-6968');
INSERT INTO hudsonu.vendor VALUES (134,'Mv Sport Us','https://www.mvsport.com/','88 Spence St',NULL,'Bay Shore','NY',11706,'(800) 367-7900',NULL);
INSERT INTO hudsonu.vendor VALUES (168,'Neil Enterprises Inc','https://www.neilenterprises.com/','1000 Woodlands Parkway',NULL,'Vernon Hills','IL',60061,'847-549-7627','847-549-0349');
INSERT INTO hudsonu.vendor VALUES (118,'New Era Cap Company,Inc.','https://www.neweracap.com/','160 Delaware Ave',NULL,'Buffalo','NY',14201,'(716)604-9000','(716)604-9299');
INSERT INTO hudsonu.vendor VALUES (150,'Nike Team Sports','https://niketeam.nike.com/','1 Bowerman Drive',NULL,'Beaverton','OR',97005,'503-671-6453',NULL);
INSERT INTO hudsonu.vendor VALUES (126,'Nordic','https://www.nordicpromos.com/','5 Tripps Ln',NULL,'Riverside','RI',02915,'(401) 431-9299',NULL);
INSERT INTO hudsonu.vendor VALUES (124,'Outerstuff Ltd','https://www.outerstuff.com/','1412 Broadway','18th floor','New York','NY',10018,'(212) 594 9700',NULL);
INSERT INTO hudsonu.vendor VALUES (173,'Pegasus Sports LLC','https://www.pegasussports.net/','550 Wolverine St',NULL,'Rockford','MI',49341,'616-866-1833',NULL);
INSERT INTO hudsonu.vendor VALUES (116,'Peter Millar','https://www.petermillar.com/','1002 Twin Creeks Ct',NULL,'Durham','NC',27703,'(919) 465-0155',NULL);
INSERT INTO hudsonu.vendor VALUES (161,'Photografx','http://photografxworldwide.com/','34082 Pinehurst Dr',NULL,'Yucaipa','CA',92399,'(909) 797-8426',NULL);
INSERT INTO hudsonu.vendor VALUES (166,'Picnic Time','https://www.picnictime.com/','5131 Maureen Lane',NULL,'Moorpark','CA',93021,'(805) 529-7400','(805) 529-7474');
INSERT INTO hudsonu.vendor VALUES (129,'Pressbox','http://pressboxusa.com/','5800 Royce St',NULL,'Kannapolis','NC',28083,'(704) 933-6000',NULL);
INSERT INTO hudsonu.vendor VALUES (113,'Real-Time Marketing','https://www.chromeemblems.com/','3230 Commander Drive',NULL,'Carrollton','TX',75006,'(214) 363-3170','(214) 363-9236');
INSERT INTO hudsonu.vendor VALUES (144,'Retro Brandss','https://www.originalretrobrand.com/','1415 Emerald Road',NULL,'Greenwood','SC',29646,'855-708-7674',NULL);
INSERT INTO hudsonu.vendor VALUES (152,'RFSJ, Inc','https://www.rfsj.com/','654 W. Main Street',NULL,'Mt. Pleasant','PA',15666,'724-547-4457',NULL);
INSERT INTO hudsonu.vendor VALUES (159,'Riddell, Inc','https://riddell.com/','1700 E Higgins Rd','Ste 500','Des Plaines','IL',60018,'888-681-1717',NULL);
INSERT INTO hudsonu.vendor VALUES (195,'Roaring Spring Blank Book Co.','http://rspaperproducts.com/','740 Spang Street',NULL,'Roaring Spring','PA',16673,'814-224-5141','814-793-2321');
INSERT INTO hudsonu.vendor VALUES (143,'Society 43','https://society43.com/','2505 SE 11TH Ave Ste 300',NULL,'Portland','OR',97202,'(503) 954-2817',NULL);
INSERT INTO hudsonu.vendor VALUES (164,'Spirit Products Ltd.','https://www.spiritproducts.com/','55 Chase St.',NULL,'Methuen','MA',01844,'(978) 372-2022',NULL);
INSERT INTO hudsonu.vendor VALUES (165,'Stance, Inc','https://www.stance.com/','197 Av. La Pata',NULL,'San Clemente','CA',92673,'(888) 391-9020',NULL);
INSERT INTO hudsonu.vendor VALUES (184,'Stockdale Technologies, Inc','http://www.stockdaletechnologies.com/','550 Technology Park',NULL,'Lake Mary','FL',32746,'(407) 323-5121',NULL);
INSERT INTO hudsonu.vendor VALUES (133,'Storm Duds','https://www.stormduds.com/','100 Frank Mossberg Dr',NULL,'Attleboro','MA',02703,'(508) 222-0155',NULL);
INSERT INTO hudsonu.vendor VALUES (189,'Strand Art Co.','https://www.strandart.com/','4700 E Hunter Avenue',NULL,'Anaheim','CA',92807,'714-777-0444','714-970-8890');
INSERT INTO hudsonu.vendor VALUES (119,'Strideline','https://www.strideline.com/','117 E. Louisa St','#536','Seattle','WA',98102,'(206) 801-0116',NULL);
INSERT INTO hudsonu.vendor VALUES (102,'Tervis Tumbler','https://www.tervis.com/','201 Triple Diamond Blvd',NULL,'North Venice','FL',34275,'(848) 260-4260',NULL);
INSERT INTO hudsonu.vendor VALUES (186,'The Fanatic Group','https://www.thefanaticgroup.com/','400 Raritan Center Parkway','Suite E','Edison','NJ',08837,'732.512.1777',NULL);
INSERT INTO hudsonu.vendor VALUES (123,'The Game','https://www.thegameheadwear.com/','16 Downing Dr',NULL,'Phenix City','AL',36869,'(334) 291-5151',NULL);
INSERT INTO hudsonu.vendor VALUES (142,'The Northwest Company','https://thenorthwest.com/','49 Bryant Ave',NULL,'Roslyn','NY',11576,'(800) 242-6996',NULL);
INSERT INTO hudsonu.vendor VALUES (110,'The Original Retro Brand','https://www.originalretrobrand.com/','1415 Emerald Road',NULL,'Greenwood','SC',29646,'855-708-7674',NULL);
INSERT INTO hudsonu.vendor VALUES (192,'Timeless Etchings LLC','https://www.timelessetchingsco.com/','408 Russell Street',NULL,'Milton-Freewater','OR',97862,'541-561-9311',NULL);
INSERT INTO hudsonu.vendor VALUES (105,'Tommy Bahama Group','https://www.tommybahama.com/','400 Fairview Ave. N','Suite 488','Seattle','WA',98109,'1-866-986-8282',NULL);
INSERT INTO hudsonu.vendor VALUES (106,'Twin City Knitting Co.','https://tcksports.com/','PO Box 1179',NULL,'Conover','NC',28613,'828-464-4830','828-465-3209');
INSERT INTO hudsonu.vendor VALUES (160,'University Blanket ' || chr(38) ||' Flag Corp.','https://ubflag.com/','1111 Orange Avenue','Suite C','Coronado','CA',92118,'800-247-5897',NULL);
INSERT INTO hudsonu.vendor VALUES (188,'University Girls','https://ugapparel.com/','112 Olde Ash Ln',NULL,'Charleston','WV',25311,'(304) 610-2280',NULL);
INSERT INTO hudsonu.vendor VALUES (141,'USA Licensed Bows Inc','https://sportsbows.com/','20 Empire Drive',NULL,'Belleville','IL',62220,'800-866-2697',NULL);
INSERT INTO hudsonu.vendor VALUES (176,'Victory Tailgate','https://www.victorytailgate.com/','2437 E. Landstreet Road',NULL,'Orlando','FL',32824,'888-577-4460',NULL);
INSERT INTO hudsonu.vendor VALUES (162,'Wear It Promotions','https://wearitpro.com/','1202 N Taylor Rd',NULL,'Brandon','FL',33510,'(813) 410-7597',NULL);
INSERT INTO hudsonu.vendor VALUES (104,'Wes ' || chr(38) ||' Willy LLC','https://wesandwilly.com/','4524 F Street',NULL,'Omaha','NE',68117,'402-884-5001',NULL);
INSERT INTO hudsonu.vendor VALUES (171,'Wincraft Inc','https://www.wincraft.com/','960 East Mark Street','P.O. Box 888','Winona','MN',55987,'(800) 533-8006',NULL);
INSERT INTO hudsonu.vendor VALUES (196,'Winning Streak Sports','https://winningstreaksports.com/','9821 Widmer Rd',NULL,'Lenexa','KS',66215,'800-768-0889',NULL);
INSERT INTO hudsonu.vendor VALUES (170,'Worthy Promo Products','https://worthypromo.com/','1515 Kowaliga Rd',NULL,'Eclectic','AL',36024,'(334) 541-4070',NULL);
INSERT INTO hudsonu.vendor VALUES (169,'Yeti Coolers','https://www.yeti.com/en_US','7601 Southwest Parkway',NULL,'Austin','TX',78735,'512-394-9384',NULL);
INSERT INTO hudsonu.vendor VALUES (155,'Zephyr Graf-X','https://www.zhats.com/','5443 Earhart Rd',NULL,'Loveland','CO',80538,'970-663-3242',NULL);
INSERT INTO hudsonu.vendor VALUES (148,'Zoozatz','https://www.zoozatz.com/','5121 WINNETKA AVE N','SUITE 290','NEW HOPE','MN',55428,'763-545-9544','763-544-3820');
end;
/
grant select on hudsonu.vendor to public;
vendor_id int PRIMARY KEY
,name VARCHAR(31)
,url VARCHAR(37)
,address VARCHAR(34)
,address2 VARCHAR(12)
,city VARCHAR(17)
,state CHAR(2)
,zip char(5)
,phone VARCHAR(15)
,fax VARCHAR(14)
);
INSERT INTO hudsonu.vendor VALUES (138,'47','https://www.47brand.com/','132 Campanelli Industrial Drive','Door 27','Brockton','MA',02301,'781-702-2921',NULL);
INSERT INTO hudsonu.vendor VALUES (183,'Adidas','https://www.adidas.com/us','5055 N Greeley Avenue',NULL,'Portland','OR',97217,'(800) 982-9337','(971) 234-2450');
INSERT INTO hudsonu.vendor VALUES (154,'Alex And Ani Inc','https://www.alexandani.com/','2000 Chapel View Blvd',NULL,'Cranston','RI',2920,'800-725-7822',NULL);
INSERT INTO hudsonu.vendor VALUES (157,'All Star Dogs','http://www.allstardogs.com/','20 Hastings Road',NULL,'Marlboro','NJ',07746,'800-391-3520','732-566-3401');
INSERT INTO hudsonu.vendor VALUES (153,'Alta Gracia Holdco, Inc','http://www.altagraciaapparel.com/','160 E Saint John St',NULL,'Spartanburg','SC',29306,'(864) 285-9810',NULL);
INSERT INTO hudsonu.vendor VALUES (180,'Alternative Apparel','https://www.alternativeapparel.com/','1650 Indian Brook Way','Ste 200','Norcross','GA',30093,'(877) 747-2915',NULL);
INSERT INTO hudsonu.vendor VALUES (127,'Ambrose Enterprises LLC','https://www.adrenalinepromotions.com/','1527 Brentwood Ln',NULL,'Mount Vernon','WA',98274,'(360) 752-2700',NULL);
INSERT INTO hudsonu.vendor VALUES (178,'Baden Sports, Inc.','https://www.badensports.com/','19015 66TH Ave S',NULL,'Kent','WA',98032,'(253) 925-0500',NULL);
INSERT INTO hudsonu.vendor VALUES (121,'Blue 84','https://blue84.com/','750 Randolph Rd',NULL,'Detroit Lakes','MN',56501,'(218) 847-2171',NULL);
INSERT INTO hudsonu.vendor VALUES (190,'Boelter Brands','https://www.boelterbrands.com/','117 SOUTHEAST PKWY',NULL,'FRANKLIN','TN',37064,'(844) 564-6432',NULL);
INSERT INTO hudsonu.vendor VALUES (182,'Boxercraft Inc','https://boxercraft.com/','7131 Discovery Blvd',NULL,'Mableton','GA',30126,'(404) 355-9994',NULL);
INSERT INTO hudsonu.vendor VALUES (194,'Branded Logistics LLC','https://branded-logistics.com/','528 N Link Ln Unit 2',NULL,'Fort Collins','CO',80524,'(970) 510-6000',NULL);
INSERT INTO hudsonu.vendor VALUES (132,'C.D.I. Corporation','https://www.cdi-corp.com/','3440 N. Knox',NULL,'Chicago','IL',60641,'(773) 205-2960',NULL);
INSERT INTO hudsonu.vendor VALUES (130,'Capri Designs','https://www.capridesigns.com/','549 Capri Point',NULL,'Lavonia','GA',30553,'(678) 400-2354','(706) 356-0228');
INSERT INTO hudsonu.vendor VALUES (103,'Carolina Sewn Products Corp','http://carolinasewnproducts.com/','145 CANE CREEK INDUSTRIAL PARK RD.','SUITE 125','Fletcher','NC',28732,'800-920-5944',NULL);
INSERT INTO hudsonu.vendor VALUES (100,'Catstudio Inc','https://www.catstudio.com/','1340 Industrial Avenue','Suite A','Petaluma','CA',94952,'800-819-3367','707-778-8100');
INSERT INTO hudsonu.vendor VALUES (163,'Centon Electronics Inc','http://www.centon.com/','27412 Aliso Viejo Pkwy',NULL,'Aliso Viejo','CA',92656,'(949) 855-9111',NULL);
INSERT INTO hudsonu.vendor VALUES (140,'Champion Products','https://www.champion.com/','1000 East Hanes Mill Road',NULL,'Winston Salem','NC',27105,'336-519-8080',NULL);
INSERT INTO hudsonu.vendor VALUES (136,'College Concepts','https://www.conceptssport.com/','3350 Riverwood Parkway','Suite 850','Atlanta','GA',30339,'800-284-4288',NULL);
INSERT INTO hudsonu.vendor VALUES (117,'College Kids','https://collegekids.com/','209 Rockwood Ln',NULL,'Neenah','WI',54956,'(800) 556-2036',NULL);
INSERT INTO hudsonu.vendor VALUES (107,'Collegiate Pacific','https://collegiatepacific.com/','532 Luck Avenue',NULL,'Roanoke','VA',24016,'800-336-5996',NULL);
INSERT INTO hudsonu.vendor VALUES (137,'Colosseum Athletics','https://www.colosseumusa.com/','2400 S Wilmington Ave',NULL,'Compton','CA',90220,'(310) 667-8341',NULL);
INSERT INTO hudsonu.vendor VALUES (108,'Cutter ' || chr(38) ||' Buck','https://cutterbuck.com/','4001 Oakesdale Ave SW',NULL,'Renton','WA',98057,'(206) 622-4191',NULL);
INSERT INTO hudsonu.vendor VALUES (193,'E5','https://e5usa.com/','61 Willet Street','Suite QQ','Passaic','NJ',7055,'(973) 773-0750','(973) 773-0751');
INSERT INTO hudsonu.vendor VALUES (109,'Fall Rush','https://www.follett.com/fallrush/','2470 Bancroft Way',NULL,'Berkeley','CA',94704,'(510) 845-1226',NULL);
INSERT INTO hudsonu.vendor VALUES (147,'Fanmats LLC','https://www.fanmats.com/','61 Willet Street','Suite QQ','Passaic','NJ',07055,'(973) 773-0750','(973) 773-0751');
INSERT INTO hudsonu.vendor VALUES (167,'FOCO','https://www.foco.com/','2301 Cottontail Lane',NULL,'Somerset','NJ',08873,'(848) 260-4260',NULL);
INSERT INTO hudsonu.vendor VALUES (112,'For Bare Feet, Inc.','https://www.forbarefeet.com/','1201 S Ohio St','Ste A','Martinsville','IN',46151,'(765) 349-7474',NULL);
INSERT INTO hudsonu.vendor VALUES (177,'Four Point Products','https://fourpoint.com/','1 Looseleaf Lane',NULL,'Vincent','AL',35178,'800-456-6603',NULL);
INSERT INTO hudsonu.vendor VALUES (156,'Framing Success','https://www.framingsuccess.com/','2556 Horse Pasture Road',NULL,'Virginia Beach','VA',23453,'800-200-2044','800-576-3726');
INSERT INTO hudsonu.vendor VALUES (101,'Gameday Couture','https://www.shopthesoho.com/','8620 S Peoria Ave',NULL,'Tulsa','OK',74132,'(855) 343-6100',NULL);
INSERT INTO hudsonu.vendor VALUES (111,'Gametime Sidekicks LLC','https://www.gametimesidekicks.com/','2339 W Beaver Creek Dr',NULL,'Powell','TN',37849,'(865) 938-6822',NULL);
INSERT INTO hudsonu.vendor VALUES (135,'Garb','http://www.garbathletics.com/','PO Box 1561',NULL,'Spanish Fork','UT',84660,'(888) 864-1955',NULL);
INSERT INTO hudsonu.vendor VALUES (174,'Gear For Sports','http://www.gearforsports.com/','9700 Commerce Parkway',NULL,'Lenexa','KS',66219,'800-255-1065',NULL);
INSERT INTO hudsonu.vendor VALUES (151,'Hillflint, Inc','https://hillflint.com/','1732 1ST Ave',NULL,'New York','NY',10128,'(212) 390-8337',NULL);
INSERT INTO hudsonu.vendor VALUES (197,'Holland Bar Stool Co.','https://hollandbarstool.com/','12839 Corporate Circle Place',NULL,'Holland','MI',49424,'(800) 423-1903','888 391-7468');
INSERT INTO hudsonu.vendor VALUES (179,'House of Doolittle','http://www.houseofdoolittle.com/','3001 Malmo Drive',NULL,'Arlington Heights','IL',60005,'800-621-9546','888-621-6660');
INSERT INTO hudsonu.vendor VALUES (175,'Image One','https://imageonecollegiate.com/','3300 W 65th Street',NULL,'Little Rock','AR',72209,'(501) 663-9595',NULL);
INSERT INTO hudsonu.vendor VALUES (122,'Innovative Adhesives, LLC','https://fanapeel.com/','P.O. Box 1719',NULL,'Cary','NC',27512,'866-926-2266',NULL);
INSERT INTO hudsonu.vendor VALUES (115,'Jardine Associates','https://www.jardineassociates.com/','200 Compass Circle',NULL,'North Kingstown','RI',2852,'(800) 543-7655','(401) 667-3818');
INSERT INTO hudsonu.vendor VALUES (125,'Jaymac Sports Products','https://jaymacsports.com/','4255 Bannockburn Rd',NULL,'Florence','SC',29505,'843-661-5622',NULL);
INSERT INTO hudsonu.vendor VALUES (114,'Jenkins Enterprises','https://www.jenkins-enterprises.com/','7200 Industry Dr',NULL,'North Little Rock','AR',72117,'(501) 945-2600',NULL);
INSERT INTO hudsonu.vendor VALUES (120,'Johnnie-O','https://www.johnnie-o.com/','2048 Cotner Avenue',NULL,'Los Angeles','CA',90025,'877-787-4703',NULL);
INSERT INTO hudsonu.vendor VALUES (187,'Jostens Inc','https://www.jostens.com/','7760 France Ave S','Ste 400','Minneapolis','MN',55435,'(952) 830-3300',NULL);
INSERT INTO hudsonu.vendor VALUES (149,'Kitty Keller Designs','https://kittykeller.com/','416 N. Austin Street',NULL,'Seguin','TX',78155,'877-597-3357','830-303-7040');
INSERT INTO hudsonu.vendor VALUES (131,'Ladiva Sport LLC','https://ladivasport.com/','7511 E Rose Garden Ln',NULL,'Scottsdale','AZ',85255,'(855) 523-4827',NULL);
INSERT INTO hudsonu.vendor VALUES (191,'Landes Inc','https://www.landesusa.com/','4500 S. Pinemont Dr',NULL,'HOUSTON','TX',77041,'713-665-0655','713-665-6392');
INSERT INTO hudsonu.vendor VALUES (181,'League Collegiate Wear','https://league-legacy.com/','299 Fame Ave',NULL,'Hanover','PA',17331,'800-627-3243','(717)630-0826');
INSERT INTO hudsonu.vendor VALUES (158,'Legacy Apparel','https://league-legacy.com/','300 Fame Ave',NULL,'Hanover','PA',17331,'800-627-3244','(717)630-0827');
INSERT INTO hudsonu.vendor VALUES (146,'Life Is Good','https://www.lifeisgood.com/','15 Hudson Park Dr',NULL,'Hudson','NH',3051,'(603) 594-6100',NULL);
INSERT INTO hudsonu.vendor VALUES (185,'Logo Brands','https://logobrands.com/','117 SE Parkway',NULL,'Franklin','TN',37064,'(615) 261-2100',NULL);
INSERT INTO hudsonu.vendor VALUES (145,'Logofit LLC','https://www.logofit.com/','3202 Lapeer Rd',NULL,'Flint','MI',48503,'(810) 715-1980',NULL);
INSERT INTO hudsonu.vendor VALUES (172,'Lokai Holdings LLC','https://lokai.com/','180 Varick St','Rm 504','New York','NY',10014,'(646) 979-3474',NULL);
INSERT INTO hudsonu.vendor VALUES (128,'LXG','https://www.lxginc.com/','921 S Park Ln',NULL,'Tempe','AZ',85281,'(602) 437-5550','602-437-5445');
INSERT INTO hudsonu.vendor VALUES (139,'Mascot Factory','https://www.mascotfactory.com/','12340 Stowe Drive','Suite B','Poway','CA',92064,'(858) 679-2244','(407) 386-6968');
INSERT INTO hudsonu.vendor VALUES (134,'Mv Sport Us','https://www.mvsport.com/','88 Spence St',NULL,'Bay Shore','NY',11706,'(800) 367-7900',NULL);
INSERT INTO hudsonu.vendor VALUES (168,'Neil Enterprises Inc','https://www.neilenterprises.com/','1000 Woodlands Parkway',NULL,'Vernon Hills','IL',60061,'847-549-7627','847-549-0349');
INSERT INTO hudsonu.vendor VALUES (118,'New Era Cap Company,Inc.','https://www.neweracap.com/','160 Delaware Ave',NULL,'Buffalo','NY',14201,'(716)604-9000','(716)604-9299');
INSERT INTO hudsonu.vendor VALUES (150,'Nike Team Sports','https://niketeam.nike.com/','1 Bowerman Drive',NULL,'Beaverton','OR',97005,'503-671-6453',NULL);
INSERT INTO hudsonu.vendor VALUES (126,'Nordic','https://www.nordicpromos.com/','5 Tripps Ln',NULL,'Riverside','RI',02915,'(401) 431-9299',NULL);
INSERT INTO hudsonu.vendor VALUES (124,'Outerstuff Ltd','https://www.outerstuff.com/','1412 Broadway','18th floor','New York','NY',10018,'(212) 594 9700',NULL);
INSERT INTO hudsonu.vendor VALUES (173,'Pegasus Sports LLC','https://www.pegasussports.net/','550 Wolverine St',NULL,'Rockford','MI',49341,'616-866-1833',NULL);
INSERT INTO hudsonu.vendor VALUES (116,'Peter Millar','https://www.petermillar.com/','1002 Twin Creeks Ct',NULL,'Durham','NC',27703,'(919) 465-0155',NULL);
INSERT INTO hudsonu.vendor VALUES (161,'Photografx','http://photografxworldwide.com/','34082 Pinehurst Dr',NULL,'Yucaipa','CA',92399,'(909) 797-8426',NULL);
INSERT INTO hudsonu.vendor VALUES (166,'Picnic Time','https://www.picnictime.com/','5131 Maureen Lane',NULL,'Moorpark','CA',93021,'(805) 529-7400','(805) 529-7474');
INSERT INTO hudsonu.vendor VALUES (129,'Pressbox','http://pressboxusa.com/','5800 Royce St',NULL,'Kannapolis','NC',28083,'(704) 933-6000',NULL);
INSERT INTO hudsonu.vendor VALUES (113,'Real-Time Marketing','https://www.chromeemblems.com/','3230 Commander Drive',NULL,'Carrollton','TX',75006,'(214) 363-3170','(214) 363-9236');
INSERT INTO hudsonu.vendor VALUES (144,'Retro Brandss','https://www.originalretrobrand.com/','1415 Emerald Road',NULL,'Greenwood','SC',29646,'855-708-7674',NULL);
INSERT INTO hudsonu.vendor VALUES (152,'RFSJ, Inc','https://www.rfsj.com/','654 W. Main Street',NULL,'Mt. Pleasant','PA',15666,'724-547-4457',NULL);
INSERT INTO hudsonu.vendor VALUES (159,'Riddell, Inc','https://riddell.com/','1700 E Higgins Rd','Ste 500','Des Plaines','IL',60018,'888-681-1717',NULL);
INSERT INTO hudsonu.vendor VALUES (195,'Roaring Spring Blank Book Co.','http://rspaperproducts.com/','740 Spang Street',NULL,'Roaring Spring','PA',16673,'814-224-5141','814-793-2321');
INSERT INTO hudsonu.vendor VALUES (143,'Society 43','https://society43.com/','2505 SE 11TH Ave Ste 300',NULL,'Portland','OR',97202,'(503) 954-2817',NULL);
INSERT INTO hudsonu.vendor VALUES (164,'Spirit Products Ltd.','https://www.spiritproducts.com/','55 Chase St.',NULL,'Methuen','MA',01844,'(978) 372-2022',NULL);
INSERT INTO hudsonu.vendor VALUES (165,'Stance, Inc','https://www.stance.com/','197 Av. La Pata',NULL,'San Clemente','CA',92673,'(888) 391-9020',NULL);
INSERT INTO hudsonu.vendor VALUES (184,'Stockdale Technologies, Inc','http://www.stockdaletechnologies.com/','550 Technology Park',NULL,'Lake Mary','FL',32746,'(407) 323-5121',NULL);
INSERT INTO hudsonu.vendor VALUES (133,'Storm Duds','https://www.stormduds.com/','100 Frank Mossberg Dr',NULL,'Attleboro','MA',02703,'(508) 222-0155',NULL);
INSERT INTO hudsonu.vendor VALUES (189,'Strand Art Co.','https://www.strandart.com/','4700 E Hunter Avenue',NULL,'Anaheim','CA',92807,'714-777-0444','714-970-8890');
INSERT INTO hudsonu.vendor VALUES (119,'Strideline','https://www.strideline.com/','117 E. Louisa St','#536','Seattle','WA',98102,'(206) 801-0116',NULL);
INSERT INTO hudsonu.vendor VALUES (102,'Tervis Tumbler','https://www.tervis.com/','201 Triple Diamond Blvd',NULL,'North Venice','FL',34275,'(848) 260-4260',NULL);
INSERT INTO hudsonu.vendor VALUES (186,'The Fanatic Group','https://www.thefanaticgroup.com/','400 Raritan Center Parkway','Suite E','Edison','NJ',08837,'732.512.1777',NULL);
INSERT INTO hudsonu.vendor VALUES (123,'The Game','https://www.thegameheadwear.com/','16 Downing Dr',NULL,'Phenix City','AL',36869,'(334) 291-5151',NULL);
INSERT INTO hudsonu.vendor VALUES (142,'The Northwest Company','https://thenorthwest.com/','49 Bryant Ave',NULL,'Roslyn','NY',11576,'(800) 242-6996',NULL);
INSERT INTO hudsonu.vendor VALUES (110,'The Original Retro Brand','https://www.originalretrobrand.com/','1415 Emerald Road',NULL,'Greenwood','SC',29646,'855-708-7674',NULL);
INSERT INTO hudsonu.vendor VALUES (192,'Timeless Etchings LLC','https://www.timelessetchingsco.com/','408 Russell Street',NULL,'Milton-Freewater','OR',97862,'541-561-9311',NULL);
INSERT INTO hudsonu.vendor VALUES (105,'Tommy Bahama Group','https://www.tommybahama.com/','400 Fairview Ave. N','Suite 488','Seattle','WA',98109,'1-866-986-8282',NULL);
INSERT INTO hudsonu.vendor VALUES (106,'Twin City Knitting Co.','https://tcksports.com/','PO Box 1179',NULL,'Conover','NC',28613,'828-464-4830','828-465-3209');
INSERT INTO hudsonu.vendor VALUES (160,'University Blanket ' || chr(38) ||' Flag Corp.','https://ubflag.com/','1111 Orange Avenue','Suite C','Coronado','CA',92118,'800-247-5897',NULL);
INSERT INTO hudsonu.vendor VALUES (188,'University Girls','https://ugapparel.com/','112 Olde Ash Ln',NULL,'Charleston','WV',25311,'(304) 610-2280',NULL);
INSERT INTO hudsonu.vendor VALUES (141,'USA Licensed Bows Inc','https://sportsbows.com/','20 Empire Drive',NULL,'Belleville','IL',62220,'800-866-2697',NULL);
INSERT INTO hudsonu.vendor VALUES (176,'Victory Tailgate','https://www.victorytailgate.com/','2437 E. Landstreet Road',NULL,'Orlando','FL',32824,'888-577-4460',NULL);
INSERT INTO hudsonu.vendor VALUES (162,'Wear It Promotions','https://wearitpro.com/','1202 N Taylor Rd',NULL,'Brandon','FL',33510,'(813) 410-7597',NULL);
INSERT INTO hudsonu.vendor VALUES (104,'Wes ' || chr(38) ||' Willy LLC','https://wesandwilly.com/','4524 F Street',NULL,'Omaha','NE',68117,'402-884-5001',NULL);
INSERT INTO hudsonu.vendor VALUES (171,'Wincraft Inc','https://www.wincraft.com/','960 East Mark Street','P.O. Box 888','Winona','MN',55987,'(800) 533-8006',NULL);
INSERT INTO hudsonu.vendor VALUES (196,'Winning Streak Sports','https://winningstreaksports.com/','9821 Widmer Rd',NULL,'Lenexa','KS',66215,'800-768-0889',NULL);
INSERT INTO hudsonu.vendor VALUES (170,'Worthy Promo Products','https://worthypromo.com/','1515 Kowaliga Rd',NULL,'Eclectic','AL',36024,'(334) 541-4070',NULL);
INSERT INTO hudsonu.vendor VALUES (169,'Yeti Coolers','https://www.yeti.com/en_US','7601 Southwest Parkway',NULL,'Austin','TX',78735,'512-394-9384',NULL);
INSERT INTO hudsonu.vendor VALUES (155,'Zephyr Graf-X','https://www.zhats.com/','5443 Earhart Rd',NULL,'Loveland','CO',80538,'970-663-3242',NULL);
INSERT INTO hudsonu.vendor VALUES (148,'Zoozatz','https://www.zoozatz.com/','5121 WINNETKA AVE N','SUITE 290','NEW HOPE','MN',55428,'763-545-9544','763-544-3820');
end;
/
grant select on hudsonu.vendor to public;