CREATE DATABASE project3;

use project3;

DROP TABLE IF EXISTS businesses;

CREATE TABLE businesses (
    business_id int NOT NULL AUTO_INCREMENT,
    Category varchar,
    Name varchar,
    Phone varchar,
    Address varchar,
    Description varchar,
    Coordinates varchar,
    EntryOwner varchar,
    PRIMARY KEY (business_id)
);

INSERT INTO businesses VALUES
('Restaurant', 'Noodles', '(970)472-2023', '648 S College Avenue Fort Collins CO 80528', 'Welcome. To a town of taste. A village of variety. A hamlet of health.', '750 215', 'Crystal'),
('Restaurant', 'Bagel Place', '(970)491-3825', 'Colorado State University Lory Student Center Food Court Fort Collins CO 80523', 'Soups + Salads + Sandwiches', '260 520', 'Crystal'),
('Restaurant', 'Spoons', '(970)224-2254', 'Colorado State University Lory Student Center Food Court Fort Collins CO 80523', 'World class soups and salads just for you', '270 530', 'Crystal'),
('Restaurant', 'Panda Express', '(970)482-3226', 'Colorado State University Lory Student Center Food Court Fort Collins CO 80523', 'Gourmet Chinese Food', '280 540', 'Crystal'),
('Restaurant', 'Gohan Time', '(970)221-0049', '706 S College Avenue No 102 Fort Collins CO 80524', 'Japanese Cuisine', '750 315', 'Crystal'),
('Restaurant', 'Chipotle', '(970)407-1446', '649 S College Avenue Fort Collins CO 80525', 'Mexican Grill', '690 200', 'Crystal'),
('Restaurant', 'Woody\'s Wood Fired Pizza', '(970)482-7100', '518 West Laurel Fort Collins CO 80521', 'Pasta dishes, sandwiches, salads and Northern Colorado\'s TASTIEST strombolis.', '115 200', 'Crystal'),
('Restaurant', 'Which \'Wich?', '(970)482-WICH', '706 S College Avenue No 101 Fort Collins CO 80524', 'Superior sandwiches', '750 300', 'Crystal'),
('Restaurant', 'Deja Vu Coffeehouse', '(970)221-3243', '646 S College Ave Fort Collins CO 80524', 'It\'s all about relationships.', '750 200', 'Crystal'),
('Restaurant', 'IHOP', '(970)484-2257', '1002 S. College Avenue Fort Collins CO 80524', 'Come hungry.  Leave happy.', '750 480'),
('Shopping', 'The CSU Bookstore', '(970)491-0546', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'Books, apparel, supplies, gifts.', '270 530', 'Crystal'),
('Shopping', 'The Flower Company', '800-638-5853', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'Flowers and gifts', '260 520'),
('Shopping', 'The Software Cellar', '(970)491-7625', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'Computer software, hardware, and repairs', '250 510', 'Crystal'),
(14, 'Shopping', 'Recycled Cycles', '(970)491-9555', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'Bicycles: purchase, service, or repair', '280 540', 'Crystal'),
(15, 'Shopping', 'Lee\'s Cyclery', '(970)482-6006', '202 W Laurel St Fort Collins CO 80521', 'Cyclery and fitness', '650 215', 'Crystal'),
('Shopping', 'Garment District', '(970)484-9212', '633 S College Ave Fort Collins CO 80524', 'The latest fashions', '690 110', 'Crystal'),
('Shopping', 'Discovery Center Science Museum', '(970)472-3990', '703 E. Prospect Road Fort Collins CO 80525', 'Hands-on science and technology center.', '575 1260', 'Crystal'),
('Shopping', 'Schrader\'s Country Store', '(970)484-7114', '1601 S College Ave Fort Collins 80525', 'Convenience store, propane, fuel', '700 1290', 'Crystal'),
('Shopping', 'Classic Nails', '(970)493-6083', '304 W Prospect Rd C Fort Collins CO 80526', 'Manicures and pedicures', '540 1200', 'Crystal'),
('Shopping', 'Action Locksmith', '(970)482-8955', '220 W Prospect Rd Fort Collins CO 80526', 'Locksmith and keys', '560 1200', 'Crystal'),
('Services', 'Office of International Programs', '(970)491-5917', 'Colorado State University Laurel Hall Fort Collins CO 80523', 'Study abroad!', '660 260', 'Crystal'),
('Services', 'Campus Information', '(970)491-6444', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'Event, phone number, office information.', '260 530', 'Crystal'),
('Services', 'Transit Center', '(970)416-2330', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'Public Transportation', '250 510', 'Crystal'),
('Services', 'ID Office', '(970)491-2344', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'RamCard - the key to CSU', '270 540', 'Crystal'),
('Services', 'Career Center', '(970)491-5707', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'Career advising, mock interviews, resume help', '240 500', 'Crystal'),
('Services', 'Student Legal Services', '(970)491-1482', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'Affordable legal assistance', '280 550', 'Crystal'),
('Services', 'Counceling Center', '(970)491-6053', 'Colorado State University C-36 Clark Building Fort Collins CO 80523', 'Comprehensive mental health agency', '380 880', 'Crystal'),
('Services', 'STA Travel Services', '(970)493-5252', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'Flights, tours, trip planning.', '290 560', 'Crystal'),
('Services', 'Picture Perfect Hair', '(970)416-7775', 'Colorado State University Lory Student Center Fort Collins CO 80523', 'Full service salon', '230 510', 'Crystal'),
('Services', 'The Alpha Center', '(970)221-5121', '1212 S College Avenue Fort Collins CO 80524', 'Sharing a hope and a future.', '750 675', 'Crystal');