-
Notifications
You must be signed in to change notification settings - Fork 0
/
insertBusinesses.sql
18 lines (17 loc) · 2.82 KB
/
insertBusinesses.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
INSERT INTO repair_businesses (repairName, repairPhone, repairWeb, repairAddress, repairCity, repairState, repairZip, repairAddInfo)
VALUES("Furniture Restoration Center", "5419296681", "http://restorationsupplies.com", "1321 Main St.", "Philomath", "OR", "97370", "Restores all typers of furniture and has hardware for doing it yourself"),
("Power equipment", "5417578075", "https://corvallispowerequipment.stihldealer.net", "713 NE Circle Blvd", "Corvallis", "OR", "97330", "lawn and garden equipment, chain saws (Stihl, honda, shindiawh), hand held equipment. "),
("Robnett's", "5417535531", "http://ww3.truevalue.com/robnetts/Home.aspx", "400 SW 2nd St", "Corvallis", "OR", "97333", "Adjustment and sharpening"),
("Footwise", "5417570875", "http://footwise.com/", "301 SW Madison Ave #100", "Corvallis", "OR", "97333", "resoles berkenstock"),
("Sedlack", "5417521498", "http://www.sedlaksshoes.net/", "225 SW 2nd St", "Corvallis", "OR", "97333", "full resoles, elastic and velcros, sewing and patching, leather patches, zippers, half soles and heels. "),
("Foam Man", "5417549378", "http://www.thefoammancorvallis.com", "2511 NW 9th St.", "Corvallis", "OR", "97330", "Replacement foam cushions for chairs and couches; upholstery"),
("P.K Furniture Repair & Refinishing", "5412301727", "http://www.pkfurniturerefinishing.net", "5720 NW Hwy 99", "Corvallis", "OR", "97330", "Complete Restoration, Complete Refinishing, Modifications, Custom Color Matching, Furniture Stripping,Chair Press Caning, Repairs"),
("Bellevue Computers", "5417573487", "http://fa.oregonstate.edu/surplus", "Oregon State University Property Services Building 644 SW 13th St", "Corvallis", "OR", "97333", "Occurs twice per quarter in the evenings Small appliances, Bicycles, Clothing, Computers (hardware and software) Electronics (small items only) Housewares (furniture, ceramics, lamps, etc.)"),
("Covallis Technical", "5417047009", "http://www.corvallistechnical.com", "966 NW Circle Blvd", "Corvallis", "OR", "97330", "repair Computers and laptops"),
("Specialty Sewing By Leslie", "5417584556", "http://www.specialtysewing.com/Leslie_Seamstress/Welcome.html", "225 SW Madison Ave", "Corvallis", "OR", "97333", "Alterations and custom work"),
("Geeks 'N' Nerds", "5417530018", "http://www.computergeeksnnerds.com", "950 Southeast Geary St Unit D", "Albany", "OR", "97321", "repair Computers of all kinds and cell phone repair; in home repair available"),
("Book binding", "5417579861", "http://www.cornerstoneassociates.com/bj-bookbinding-about-us.html", "108 SW 3rd St.", "Corvallis", "OR", "97333", "Rebind and restore books");
INSERT INTO repair_businesses
(repairName, repairPhone, repairAddress, repairCity, RepairState,
repairZip, repairAddInfo)
VALUES("Cell Phone Sick Bay", "5412301785", "252 SW Madison Ave. Suite 110", "Corvallis", "OR", "97333", "Cell phones and tablets");