forked from das867/IVSystems
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathbrandAndVendor.sql
More file actions
96 lines (91 loc) · 6.22 KB
/
brandAndVendor.sql
File metadata and controls
96 lines (91 loc) · 6.22 KB
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
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 orders(id,user_id,vendor_id,type,closedInvoice) VALUES(null,1,1,'reorder',false);
INSERT INTO orders(id,user_id,vendor_id,type,closedInvoice) VALUES(null,1,2,'reorder',false);
INSERT INTO orders(id,user_id,vendor_id,type,closedInvoice) VALUES(null,1,3,'reorder',false);
INSERT INTO orders(id,user_id,vendor_id,type,closedInvoice) VALUES(null,1,4,'reorder',false);
INSERT INTO orders(id,user_id,vendor_id,type,closedInvoice) VALUES(null,1,5,'reorder',false);
INSERT INTO orders(id,user_id,vendor_id,type,closedInvoice) VALUES(null,1,6,'reorder',false);
INSERT INTO orders(id,user_id,vendor_id,type,closedInvoice) VALUES(null,1,7,'reorder',false);
INSERT INTO orders(id,user_id,vendor_id,type,closedInvoice) VALUES(null,1,8,'reorder',false);
INSERT INTO orders(id,user_id,vendor_id,type,closedInvoice) VALUES(null,1,9,'reorder',false);
INSERT INTO orders(id,user_id,vendor_id,type,closedInvoice) VALUES(null,1,10,'reorder',false);
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 brand(id, name) VALUES(null, 'ACE Comics');
INSERT INTO brand(id, name) VALUES(null, 'All Star DC Comics');
INSERT INTO brand(id, name) VALUES(null, 'Atlas Comics');
INSERT INTO brand(id, name) VALUES(null, 'Caliber Comics');
INSERT INTO brand(id, name) VALUES(null, 'Calvary Comics');
INSERT INTO brand(id, name) VALUES(null, 'DC Comics');
INSERT INTO brand(id, name) VALUES(null, 'D. C. Thomson & Co. Ltd');
INSERT INTO brand(id, name) VALUES(null, 'Deep Sea Comics');
INSERT INTO brand(id, name) VALUES(null, 'Disney Comics');
INSERT INTO brand(id, name) VALUES(null, 'La Pastèque');
INSERT INTO brand(id, name) VALUES(null, 'Marvel Comics');
INSERT INTO brand(id, name) VALUES(null, 'Marvel Adventures');
INSERT INTO brand(id, name) VALUES(null, 'Marvel Age');
INSERT INTO brand(id, name) VALUES(null, 'Matrix Graphic Series');
INSERT INTO brand(id, name) VALUES(null, 'Maverick');
INSERT INTO brand(id, name) VALUES(null, 'Max Comics (MAX)');
INSERT INTO brand(id, name) VALUES(null, 'Media Factory');
INSERT INTO brand(id, name) VALUES(null, 'Michael Hunt Publishing');
INSERT INTO brand(id, name) VALUES(null, 'Mighty Comics');
INSERT INTO brand(id, name) VALUES(null, 'Milestone Media');
INSERT INTO brand(id, name) VALUES(null, 'Mille-Îles');
INSERT INTO brand(id, name) VALUES(null, 'Millennium Publications');
INSERT INTO brand(id, name) VALUES(null, 'Milk Shadow Books');
INSERT INTO brand(id, name) VALUES(null, 'MiniKomix');
INSERT INTO brand(id, name) VALUES(null, 'Mirage Studios');
INSERT INTO brand(id, name) VALUES(null, 'Mirror Comics');
INSERT INTO brand(id, name) VALUES(null, 'M. F. Enterprises');
INSERT INTO brand(id, name) VALUES(null, 'MLJ Magazines');
INSERT INTO brand(id, name) VALUES(null, 'Mojo Press');
INSERT INTO brand(id, name) VALUES(null, 'Moonstone Books');
INSERT INTO brand(id, name) VALUES(null, 'MOSAIK Steinchen für Steinchen Verlag');
INSERT INTO brand(id, name) VALUES(null, 'M Press');
INSERT INTO brand(id, name) VALUES(null, 'MU Press');
INSERT INTO brand(id, name) VALUES(null, 'MyInkComics.com');
INSERT INTO brand(id, name) VALUES(null, 'NBM Publishing');
INSERT INTO brand(id, name) VALUES(null, 'Neko Press');
INSERT INTO brand(id, name) VALUES(null, 'Standard Comics');
INSERT INTO brand(id, name) VALUES(null, 'New Century Comics');
INSERT INTO brand(id, name) VALUES(null, 'New Comics Group');
INSERT INTO brand(id, name) VALUES(null, 'Square Enix');