brandAndVendor.sql

INSERT INTO vendor(id, name, strAddress, city, state, zipcode) VALUES(null, 'Diamond Comic Distributors','8721 Allen Way ','Montgomery ','AL','90267');
INSERT INTO vendor(id, name, strAddress, city, state, zipcode) VALUES(null, 'Hughes & Son Comics','3214 Beau Road','Charolette','NC','32224');
INSERT INTO vendor(id, name, strAddress, city, state, zipcode) VALUES(null, 'John\'s Apparel','7645 Peachtree Circle','Atlanta ','GA','30303');
INSERT INTO vendor(id, name, strAddress, city, state, zipcode) VALUES(null, 'FYE','16 Devil Lane','Cleveland','OH','57398');
INSERT INTO vendor(id, name, strAddress, city, state, zipcode) VALUES(null, 'Oak City Comicon','354 MLK Street','Las Vegas ','NV ','89798');
INSERT INTO vendor(id, name, strAddress, city, state, zipcode) VALUES(null, 'Batman Manic','1 Wayne Manor ','Gotham City ','NY','64518');
INSERT INTO vendor(id, name, strAddress, city, state, zipcode) VALUES(null, 'Green Man Group','113 Spring Trail','Harlem','NY','98436');
INSERT INTO vendor(id, name, strAddress, city, state, zipcode) VALUES(null, 'Brooklyn Figures','8364 Xite Road','Seattle','WA','39823');
INSERT INTO vendor(id, name, strAddress, city, state, zipcode) VALUES(null, 'Cain Inc','4712 Trapoole Way','Livonia','MI','92650');
INSERT INTO vendor(id, name, strAddress, city, state, zipcode) VALUES(null, 'CollectorsRUs','1902 Renaissance Parkway','Atlanta ','GA','30308');


INSERT INTO tag(id, name) VALUES(null,'Marvel')
INSERT INTO tag(id, name) VALUES(null,'Batman')
INSERT INTO tag(id, name) VALUES(null,'Hulk')
INSERT INTO tag(id, name) VALUES(null,'Avengers')
INSERT INTO tag(id, name) VALUES(null,'Superman')
INSERT INTO tag(id, name) VALUES(null,'Game of Thrones')
INSERT INTO tag(id, name) VALUES(null,'Aquaman')
INSERT INTO tag(id, name) VALUES(null,'Naruto')
INSERT INTO tag(id, name) VALUES(null,'Bleach')
INSERT INTO tag(id, name) VALUES(null,'Attack on Titian')
INSERT INTO tag(id, name) VALUES(null,'DC ')
INSERT INTO tag(id, name) VALUES(null,'Flash')
INSERT INTO tag(id, name) VALUES(null,'Justic League')
INSERT INTO tag(id, name) VALUES(null,'Deadpool')
INSERT INTO tag(id, name) VALUES(null,'Spiderman')
INSERT INTO tag(id, name) VALUES(null,'Captain America')
INSERT INTO tag(id, name) VALUES(null,'Magic The Gathering')
INSERT INTO tag(id, name) VALUES(null,'Dugeon & Dragons')
INSERT INTO tag(id, name) VALUES(null,'Yugioh')
INSERT INTO tag(id, name) VALUES(null,'Pokemon')
INSERT INTO tag(id, name) VALUES(null,'Wolverine')
INSERT INTO tag(id, name) VALUES(null,'X-Men')
INSERT INTO tag(id, name) VALUES(null,'Antman')
INSERT INTO tag(id, name) VALUES(null,'DareDevil')
INSERT INTO tag(id, name) VALUES(null,'Thor')
INSERT INTO tag(id, name) VALUES(null,'Iron Man')
INSERT INTO tag(id, name) VALUES(null,'Nightwing')
INSERT INTO tag(id, name) VALUES(null,'Hawkman')
INSERT INTO tag(id, name) VALUES(null,'Wonder Woman')
INSERT INTO tag(id, name) VALUES(null,'Supergirl')
INSERT INTO tag(id, name) VALUES(null,'The Walking Dead')

INSERT INTO brands(id, name) VALUES(null, 'ACE Comics');
INSERT INTO brands(id, name) VALUES(null, 'All Star DC Comics');
INSERT INTO brands(id, name) VALUES(null, 'Atlas Comics');
INSERT INTO brands(id, name) VALUES(null, 'Caliber Comics');
INSERT INTO brands(id, name) VALUES(null, 'Calvary Comics');
INSERT INTO brands(id, name) VALUES(null, 'DC Comics');
INSERT INTO brands(id, name) VALUES(null, 'D. C. Thomson & Co. Ltd');
INSERT INTO brands(id, name) VALUES(null, 'Deep Sea Comics');
INSERT INTO brands(id, name) VALUES(null, 'Disney Comics');
INSERT INTO brands(id, name) VALUES(null, 'La Pastèque');
INSERT INTO brands(id, name) VALUES(null, 'Marvel Comics');
INSERT INTO brands(id, name) VALUES(null, 'Marvel Adventures');
INSERT INTO brands(id, name) VALUES(null, 'Marvel Age');
INSERT INTO brands(id, name) VALUES(null, 'Matrix Graphic Series');
INSERT INTO brands(id, name) VALUES(null, 'Maverick');
INSERT INTO brands(id, name) VALUES(null, 'Max Comics (MAX)');
INSERT INTO brands(id, name) VALUES(null, 'Media Factory');
INSERT INTO brands(id, name) VALUES(null, 'Michael Hunt Publishing');
INSERT INTO brands(id, name) VALUES(null, 'Mighty Comics');
INSERT INTO brands(id, name) VALUES(null, 'Milestone Media');
INSERT INTO brands(id, name) VALUES(null, 'Mille-Îles');
INSERT INTO brands(id, name) VALUES(null, 'Millennium Publications');
INSERT INTO brands(id, name) VALUES(null, 'Milk Shadow Books');
INSERT INTO brands(id, name) VALUES(null, 'MiniKomix');
INSERT INTO brands(id, name) VALUES(null, 'Mirage Studios');
INSERT INTO brands(id, name) VALUES(null, 'Mirror Comics');
INSERT INTO brands(id, name) VALUES(null, 'M. F. Enterprises');
INSERT INTO brands(id, name) VALUES(null, 'MLJ Magazines');
INSERT INTO brands(id, name) VALUES(null, 'Mojo Press');
INSERT INTO brands(id, name) VALUES(null, 'Moonstone Books');
INSERT INTO brands(id, name) VALUES(null, 'MOSAIK Steinchen für Steinchen Verlag');
INSERT INTO brands(id, name) VALUES(null, 'M Press');
INSERT INTO brands(id, name) VALUES(null, 'MU Press');
INSERT INTO brands(id, name) VALUES(null, 'MyInkComics.com');
INSERT INTO brands(id, name) VALUES(null, 'NBM Publishing');
INSERT INTO brands(id, name) VALUES(null, 'Neko Press');
INSERT INTO brands(id, name) VALUES(null, 'Standard Comics');
INSERT INTO brands(id, name) VALUES(null, 'New Century Comics');
INSERT INTO brands(id, name) VALUES(null, 'New Comics Group');
INSERT INTO brands(id, name) VALUES(null, 'Square Enix');