-- quickie table(s) for in-class restaurant example

-- (warning: for this example, I didn't really MODEL this
--    scenario properly!!)

drop table restaurant cascade constraints;

create table restaurant
(rest_id         integer,
 rest_name       varchar2(50),
 rest_str_addr   varchar2(50),
 rest_city       varchar2(30),
 rest_phone      varchar2(12), 
 has_pizza       char(1) check(has_pizza in ('y', 'n')),
 has_burgers     char(1) check(has_burgers in ('y', 'n')),
 has_sandwiches  char(1) check(has_sandwiches in ('y', 'n')),
 primary key     (rest_id)
);

drop table rest_menu_faves cascade constraints;

create table rest_menu_faves
(rest_id         integer,
 menu_item       varchar2(100),
 menu_item_cost  decimal(5, 2),
 primary key (rest_id, menu_item),
 foreign key (rest_id) references restaurant
);

insert into restaurant
values
(1, 'Stars Hamburgers', '1535 G St', 'Arcata', '707-826-1379', 'n', 'y', 'y');

insert into restaurant
values
(2, 'Taco Bell', '1811 Central Ave', 'Mckinleyville', '707-839-7734', 
    'n', 'n', 'n');

insert into restaurant
values
(3, 'McDonald''s', '4901 Valley West Blvd', 'Arcata', '707-822-0888', 
    'n', 'y', 'y');

insert into restaurant
values
(4, 'Arcata Pizza Deli', '1057 H St', 'Arcata', '707-822-4650', 'y', 'y', 'y');

insert into restaurant
values
(5, 'Philly Cheese Steak Shoppe', '1811 G St', 'Arcata', '707-825-7400', 
    'n', 'n', 'y');

insert into restaurant
values
(6, 'Hey Juan Burritos', '1642 1/2 G St', 'Arcata', '707-822-8433', 'n', 
    'n', 'n');

insert into restaurant
values
(7, 'Slice of Humboldt Pie', '828 I St', 'Arcata', '707-630-5100', 'n', 
     'n', 'n');

insert into restaurant(rest_id, rest_name, rest_str_addr, rest_city,
    has_pizza, has_burgers, has_sandwiches)
values
(8, 'Carl''s Jr', '4900 Valley West Blvd', 'Arcata', 'n', 'y', 'y');

insert into restaurant(rest_id, rest_name, rest_str_addr, rest_city,
    has_pizza, has_burgers, has_sandwiches)
values
(9, 'Dutchy''s Pizza', '1116 11th Street', 'Arcata', 'y', 'n', 'y');

insert into restaurant(rest_id, rest_name, rest_city, rest_phone,
    has_pizza, has_burgers, has_sandwiches)
values
(10, 'Wendy''s', 'Eureka', '707-441-4900', 'n', 'y', 'y');

insert into restaurant(rest_id, rest_name, rest_city,
    has_pizza, has_burgers, has_sandwiches)
values
(11, 'McDonald''s', 'Eureka', 'n', 'y', 'y');

insert into restaurant(rest_id, rest_name, rest_city, rest_phone,
    has_pizza, has_burgers, has_sandwiches)
values
(12, 'Burger King', 'McKinleyville', '707-839-9299', 'n', 'y', 'y');

insert into restaurant
values
(13, 'Subway', '1731 G St', 'Arcata', '707-822-0155', 'n', 'n', 'y');

insert into restaurant(rest_id, rest_name, rest_city, rest_phone,
    has_pizza, has_burgers, has_sandwiches)
values
(14, 'The Burger Joint', 'Arcata', '707-630-5144', 'n', 'y', 'y');

insert into restaurant(rest_id, rest_name, rest_city, rest_phone,
    has_pizza, has_burgers, has_sandwiches)
values
(15, 'Humboldt Brews', 'Arcata', '707-826-2739', 'n', 'y', 'y');

insert into restaurant(rest_id, rest_name, rest_city, rest_phone,
    has_pizza, has_burgers, has_sandwiches)
values
(16, 'Toni''s 24 Hr Restaurant', 'Arcata', '707-822-0091', 'n', 'y', 'y');

insert into restaurant(rest_id, rest_name, rest_str_addr, rest_city, 
    has_pizza, has_burgers, has_sandwiches)
values
(17, 'Mazzotti''s', '773 8th Street', 'Arcata', 'y', 'n', 'y');

insert into restaurant(rest_id, rest_name, rest_str_addr, rest_city, 
    has_pizza, has_burgers, has_sandwiches)
values
(18, 'La Trattoria', '30 Sunnybrae Ctr', 'Arcata', 'y', 'n', 'n');

insert into restaurant(rest_id, rest_name, rest_str_addr, rest_city, 
    has_pizza, has_burgers, has_sandwiches)
values
(19, 'PastaLuego', '791 8th Street', 'Arcata', 'n', 'n', 'y');

insert into restaurant(rest_id, rest_name, rest_str_addr, rest_city, 
    has_pizza, has_burgers, has_sandwiches)
values
(20, 'Marcelli''s', '1323 5th Street', 'Eureka', 'y', 'n', 'y');

insert into restaurant(rest_id, rest_name, rest_city, rest_str_addr,
    has_pizza, has_burgers, has_sandwiches)
values
(21, 'Paul''s Live from New York', 'Arcata', '665 Samoa Blvd', 'y', 'n', 'y');