text: -- Create Types --
  
  create or replace type address_Type as OBJECT(
  country VARCHAR(50),
  city VARCHAR(50),
  address VARCHAR(100),
  postal_code VARCHAR(8)
  );
  
  create or replace type phone_list_type as VARRAY(3) of varchar(30);
  /
  create or replace type Email_list_type as VARRAY(3) of varchar(30);
  /
  create or replace type coordinates_type as OBJECT(
  latitude varchar(20),
  longitude varchar(20));
  /
  create or replace type open_hours_type as table of VARCHAR(5);
  /
  create or replace type COMMENTS_TYPE AS OBJECT
  (
     COMMENT_ID           INT,
     USER_ID              INTEGER,
     COMMENT_CREATION_DATE DATE,
     COMMENT_TEXT         CLOB
  )NOT FINAL ;
  /
  
  create or replace type COMMENT_RESTAURANT_TYPE UNDER COMMENTS_TYPE(
     RESTAURANT_ID        INTEGER,
     RESTAURANT_RATING    INTEGER,
     RESTAURANT_REVIEW_TYPE VARCHAR2(25)
     ) NOT FINAL;
  /
  
  
  create or replace type COMMENT_DISH_TYPE UNDER COMMENTS_TYPE(
     DISH_ID        INTEGER,
     DISH_RATING    INTEGER
     ) NOT FINAL;
  /
  -- Create Tables --
  
  create table USERS
  (
     USER_ID              INT GENERATED BY DEFAULT ON NULL AS IDENTITY,
     USER_NAME            VARCHAR2(20)         not null,
     USER_PASSWORD        VARCHAR2(200)        not null,
     USER_CREATIONDATE    DATE                 default sysdate,
     USER_EMAIL           Email_list_type,
     USER_PHONE           phone_list_type,
     constraint PK_USERS primary key (USER_ID)
  );
  create table RESTAURANTS
  (
     RESTAURANT_ID        INT GENERATED BY DEFAULT ON NULL AS IDENTITY,
     RESTAURANT_NAME      VARCHAR2(200)        not null,
     RESTAURANT_ADDRESS   VARCHAR2(200),
     RESTAURANT_COORDS   coordinates_type,
     RESTAURANT_OPEN_HOURS open_hours_type,
     RESTAURANT_RESERVATIONS smallint,
     RESTAURANT_WIFI      smallint,
     RESTAURANT_DELIVERY  smallint,
     RESTAURANT_MULTIBANCO smallint,
     RESTAURANT_OUTDOOR_SEATING smallint,
     RESTAURANT_POINTS    FLOAT default '3',
     RESTAURANT_IMAGE NVARCHAR2(200) default 'placeholder.jpg',
     constraint PK_RESTAURANT primary key (RESTAURANT_ID))
     NESTED TABLE RESTAURANT_OPEN_HOURS STORE AS OPEN_HOURS_NESTED;
  
  create table COMMENTS OF COMMENTS_TYPE;
  
  create table MENUS
  (
     MENU_ID              INT GENERATED BY DEFAULT ON NULL AS IDENTITY,
     RESTAURANT_ID        INTEGER              not null,
     MENU_NAME            VARCHAR2(200),
     constraint PK_MENUS primary key (MENU_ID),
     constraint FK_RESTAURANT_MENUS foreign key (RESTAURANT_ID) REFERENCES RESTAURANTS(RESTAURANT_ID)
  );
  
  create table PRICES
  (
     PRICE_ID             INT GENERATED BY DEFAULT ON NULL AS IDENTITY,
     MENU_ID INT not null,
     PRICE_VALUE          NUMBER(8,2)          not null,
     constraint PK_PRICES primary key (PRICE_ID),
     constraint FK_MENUS foreign key (MENU_ID) REFERENCES MENUS(MENU_ID)
  );
  
  create table DISHES
  (
     DISH_ID              INT GENERATED BY DEFAULT ON NULL AS IDENTITY,
     DISH_NAME            VARCHAR2(200)        not null,
     DISH_TYPE            VARCHAR2(200)        not null,
     DISH_IMAGE NVARCHAR2(200),
     constraint PK_DISHES primary key (DISH_ID)
  );
  
  
  CREATE TABLE COMMENTS_RESTAURANT OF COMMENT_RESTAURANT_TYPE;
  
  CREATE TABLE COMMENTS_DISH OF COMMENT_DISH_TYPE;
  
  create table DISHES_PRICES
  (
     DISH_ID              INTEGER              not null,
     PRICE_ID             INTEGER              not null,
     constraint PK_DISHES_PRICES primary key (DISH_ID, PRICE_ID),
     constraint FK_DISHES_DISH foreign key (DISH_ID) REFERENCES DISHES(DISH_ID),
     constraint FK_DISHES_PRICE foreign key (PRICE_ID) REFERENCES PRICES(PRICE_ID)
  );
  create table COORDS
  (
     COORDS_ID              INT GENERATED BY DEFAULT ON NULL AS IDENTITY,
     RESTAURANT_ID        INTEGER              not null,
     LATITUDE            VARCHAR2(200),
     LONGITUDE           VARCHAR2(200),
     constraint PK_COORDS primary key (COORDS_ID),
     constraint FK_COORDS_RESTAURANT foreign key (RESTAURANT_ID) REFERENCES RESTAURANTS(RESTAURANT_ID)
  );
  --Drops --
  
  DROP TABLE DISHES_PRICES;
  DROP TABLE COMMENTS_DISH;
  DROP TABLE COMMENTS_RESTAURANT;
  --DROP TABLE DISHES_MENUS;
  DROP TABLE DISHES;
  DROP TABLE PRICES;
  DROP TABLE MENUS;
  DROP TABLE COORDS;
  DROP TABLE RESTAURANTS;
  DROP TABLE COMMENTS;
  DROP TABLE USERS;
  -- INSERTS --
  --INSERTS COMMENTS--
  
  INSERT INTO Comments (comment_id,user_id, COMMENT_CREATION_DATE, comment_text)
  values(
  '1',
  '1',
  sysdate,
  ' Este restaurante recomenda-se, pois tem um optimo funcionamento e a qualidade e muito boa'
  );
  
  INSERT INTO Comments_Dish
  values(
  '1',
  '1',
  sysdate,
  ' Este restaurante recomenda-se, pois tem um optimo funcionamento e a qualidade e muito boa',
  '15',
  '3,5'
  );
  INSERT INTO Comments_restaurant
  values(
  '1',
  '1',
  sysdate,
  ' Este restaurante recomenda-se, pois tem um optimo funcionamento e a qualidade e muito boa',
  '15',
  '3,5',
  'familia'
  );
  
  COMMIT;
  --INSERTS RESTAURANTS--
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS, RESTAURANT_IMAGE)
  values(
  'Tia Iva',
  'Viseu',
  coordinates_type('10','20'),
  open_hours_type('10:00','22:00'),
  '1',
  '1',
  '0',
  '1',
  '1',
  '5',
  'tia_iva.jpg'
  );
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'O Tosco',
  'Vila Cha de Sa',
  coordinates_type('12','20'),
  open_hours_type('12:00','23:00'),
  '1',
  '0',
  '0',
  '1',
  '1',
  '3',
  'tosco.jpg'
  );
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'Casa Arouquesa',
  'Repeses',
  coordinates_type('13','20'),
  open_hours_type('12:00','00:00'),
  '1',
  '0',
  '0',
  '1',
  '1',
  '5',
  'casa_arouquesa.jpg'
  );
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'Maionese',
  'Jugueiros',
  coordinates_type('15','30'),
  open_hours_type('11:00','23:00'),
  '1',
  '0',
  '0',
  '0',
  '1',
  '4',
  'maionese.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'Churrasqueira Santa Eulalia',
  'Repeses',
  coordinates_type('20','35'),
  open_hours_type('09:00','23:00'),
  '0',
  '0',
  '1',
  '0',
  '1',
  '3',
  'churrasqueria.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'Vintage',
  'Rossio',
  coordinates_type('40','5'),
  open_hours_type('09:00','23:00'),
  '1',
  '1',
  '1',
  '1',
  '1',
  '5',
  'vintage.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'O Cortico',
  'Viseu',
  coordinates_type('10','51'),
  open_hours_type('13:00','23:00'),
  '1',
  '1',
  '0',
  '1',
  '0',
  '5',
  'cortico.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'Cantinho do Tito',
  'Viseu',
  coordinates_type('1','5'),
  open_hours_type('13:00','00:00'),
  '1',
  '1',
  '1',
  '1',
  '1',
  '5',
  'cantinho_tito.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'Budega',
  'Viseu',
  coordinates_type('11','14'),
  open_hours_type('19:00','00:00'),
  '1',
  '1',
  '1',
  '0',
  '0',
  '4',
  'budega.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'CasaBlanca',
  'Viseu',
  coordinates_type('2','10'),
  open_hours_type('12:00','22:00'),
  '1',
  '1',
  '1',
  '0',
  '0',
  '3',
  'casablanca.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'CB House',
  'Viseu',
  coordinates_type('255','010'),
  open_hours_type('12:00','02:00'),
  '0',
  '1',
  '1',
  '0',
  '0',
  '3',
  'cb.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'Forno da Mimi',
  'Viseu',
  coordinates_type('150','05'),
  open_hours_type('12:00','00:00'),
  '1',
  '1',
  '1',
  '1',
  '1',
  '5',
  'forno_mimi.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'O Martelo',
  'Viseu',
  coordinates_type('08','05'),
  open_hours_type('13:00','23:00'),
  '0',
  '0',
  '0',
  '0',
  '1',
  '2',
  'martelo.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
   'Porta da Se',
  'Viseu',
  coordinates_type('081','051'),
  open_hours_type('11:00','01:00'),
  '0',
  '1',
  '1',
  '1',
  '1',
  '3',
  'portase.png');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'Cervejaria Cacimbo',
  'Viseu',
  coordinates_type('00','222'),
  open_hours_type('10:00','22:00'),
  '0',
  '0',
  '1',
  '0',
  '1',
  '4',
  'cacimbo.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'McDonalds',
  'Viseu',
  coordinates_type('111','200'),
  open_hours_type('9:00','3:00'),
  '0',
  '0',
  '1',
  '1',
  '1',
  '3',
  'mac.jpg');
  INSERT INTO Restaurants (RESTAURANT_NAME,RESTAURANT_ADDRESS,RESTAURANT_COORDS,RESTAURANT_OPEN_HOURS,RESTAURANT_RESERVATIONS,RESTAURANT_WIFI,
  RESTAURANT_DELIVERY,RESTAURANT_MULTIBANCO,RESTAURANT_OUTDOOR_SEATING,RESTAURANT_POINTS,RESTAURANT_IMAGE)
  values(
  'Solar do Verde Gaio',
  'Viseu',
  coordinates_type('111','200'),
  open_hours_type('9:00'',00:00'),
  '1',
  '0',
  '1',
  '1',
  '1',
  '5',
  'verd.jpg');
  
  --INSERTS Menus--
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '1',
  'Menu Tia Iva'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '2',
  'Menu Tosco'
  );
  
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '3',
  'Menu Arouqueza'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '4',
  'Menu Maionese'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '5',
  'Menu Churrasqueira'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '6',
  'Menu Vintage'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '7',
  'Menu Cortico'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '8',
  'Menu Tito'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '9',
  'Menu Budega'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '10',
  'Menu Casa'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '11',
  'Menu CB'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '12',
  'Menu Forno'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '13',
  'Menu Martelo'
  );
  
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '14',
  'Menu Porta'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '15',
  'Menu Cacimbo'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '16',
  'Menu Mac'
  );
  INSERT INTO Menus (RESTAURANT_ID, MENU_NAME)
  values(
  '17',
  'Menu Verde'
  );
  --INSERTS PRICES--
  insert into Prices (menu_id,price_value)
  values('1','20');
  insert into Prices (menu_id,price_value)
  values('2','15');
  insert into Prices (menu_id,price_value)
  values('3','25');
  insert into Prices (menu_id,price_value)
  values('4','10');
  insert into Prices (menu_id,price_value)
  values('5','20');
  insert into Prices (menu_id,price_value)
  values('6','9,50');
  insert into Prices (menu_id,price_value)
  values('7','30');
  insert into Prices (menu_id,price_value)
  values('8','15');
  insert into Prices (menu_id,price_value)
  values('9','20');
  insert into Prices (menu_id,price_value)
  values('10','35');
  insert into Prices (menu_id,price_value)
  values('11','6');
  insert into Prices (menu_id,price_value)
  values('12','35');
  insert into Prices (menu_id,price_value)
  values('13','15');
  insert into Prices (menu_id,price_value)
  values('14','8');
  insert into Prices (menu_id,price_value)
  values('15','15');
  insert into Prices (menu_id,price_value)
  values('16','7');
  insert into Prices (menu_id,price_value)
  values('17','40');
  --insert dish
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Bacalhau a Bras',
  'Peixe',
  'bacalhau_bras.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Cozido a Potuguesa',
  'Carne',
  'cozido.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Sardinha Assada com Batata Cozida e Pimentos',
  'Peixe',
  'sardinha.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Creme de Legumes',
  'Sopa',
  'creme_legumes.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Bitoque',
  'Carne',
  'bitoque.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'CheeseCake',
  'Sobremesa',
  'chesse.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Caldo Verde',
  'Sopa',
  'caldo_verde.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Mousse de Chocolate',
  'Sobremesa',
  'mousse.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Pao e Azeitonas',
  'Entrada',
  'azeitonas.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Vinho Tinto',
  'Bebida',
  'tinto.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Tabuleiro de Queijos',
  'Entrada',
  'queijos.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Vinho Branco',
  'Bebida',
  'branco.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Agua',
  'Bebida',
  'agua.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Sumo de Laranja',
  'Bebida',
  'sumo.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Cafe',
  'Bebida',
  'cafe.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Morangos',
  'Fruta',
  'morango.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Hambuger com carne e salada',
  'Fast-Food',
  'fast.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Francesinha',
  'Fast-Food',
  'francesinha.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Grelhada Mista',
  'Carne',
  'mista.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Martini',
  'Aperitivo',
  'drink.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Banana',
  'Fruta',
  'banana.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Salada Mista',
  'Salada',
  'salada_mista.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Salada de Fruta',
  'Sobremesa',
  'salada_fruta.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Cafe com Maceira',
  'Bebida',
  'bagacu.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Salada de Alface',
  'Salada',
  'alface.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Salada de Cenoura',
  'Salada',
  'cenoura.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Salada de Tomate',
  'Salada',
  'tomate.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Salada de Tomate e Alface',
  'Salada',
  'al_to.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Salada de Pepino',
  'Salada',
  'pepino.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Bola de Gelado',
  'Sobremesa',
  'gelado.png'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Carbonara',
  'Carne',
  'carbonara.jpg'
  );
  
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Peixe com batata cozida',
  'Peixe',
  'ovo.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Legumes Saltiados',
  'Vegetariano',
  'legumes.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Legumes Cozidos',
  'Vegetariano',
  'leg_cozidos.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Feijoada',
  'Carne',
  'feijoada.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Rancho',
  'Carne',
  'rancho.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Bacalhau a Gomes de Sa',
  'Peixe',
  'bacalhau_gomes.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Bacalhau com Broa',
  'Peixe',
  'bacalhau_broa.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Salmao Grelhado com batata cozida',
  'Peixe',
  'salmao.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Maca',
  'Fruta',
  'maca.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Laranja',
  'Fruta',
  'laranja.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Vinho do Porto',
  'Aperitivo',
  'orto.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Favaios',
  'Aperitivo',
  'favaios.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Ricard',
  'Aperitivo',
  'ricard.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Canja',
  'Sopa',
  'canja.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Sopa da Pedra',
  'Sopa',
  'pedra.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Pate',
  'Entrada',
  'pate.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Camarao',
  'Entrada',
  'camarao.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Pizza',
  'Fast-Food',
  'pizza.jpg'
  );
  INSERT INTO Dishes (DISH_NAME,DISH_TYPE,DISH_IMAGE)
  values(
  'Cachorro',
  'Fast-Food',
  'cachorro.jpg'
  );
  
  --INSERTS DISH_PRICES--
  insert into Dishes_Prices (Dish_id, price_id)
  values ('1','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('1','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('1','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('1','13');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('2','2');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('2','8');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('2','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('2','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('3','3');
  insert into Dishes_Prices (Dish_id, PRICE_IDid)
  values ('3','17');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('3','15');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('3','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('4','11');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('4','14');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('4','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('4','4');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('5','5');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('5','8');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('5','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('5','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('6','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('6','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('6','2');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('6','17');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('7','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('7','11');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('7','15');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('8','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('8','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('8','11');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('9','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('9','5');
  insert into Dishes_Prices (Dish_id,price_id)
  values ('9','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('10','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('10','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('10','14');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('10','16');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('11','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('11','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('11','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('12','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('12','1');
  insert into Dishes_Prices (Dish_id,price_id)
  values ('12','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('13','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('13','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('13','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('14','2');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('14','4');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('14','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('14','8');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('15','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('15','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('15','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('15','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('15','15');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('16','4');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('16','8');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('16','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('16','16');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('17','17');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('17','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('17','5');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('18','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('18','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('18','7');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('18','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('19','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('19','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('19','15');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('20','17');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('20','16');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('20','15');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('20','14');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('21','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('21','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('22','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('22','2');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('22','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('22','4');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('23','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('23','7');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('23','8');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('23','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('23','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('24','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('24','11');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('24','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('25','8');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('25','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('25','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('25','11');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('25','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('26','15');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('26','16');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('26','17');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('27','16');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('27','17');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('28','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('28','4');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('28','5');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('29','2');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('29','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('29','4');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('29','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('29','7');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('30','8');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('30','2');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('30','4');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('30','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('31','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('31','2');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('31','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('31','17');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('32','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('32','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('33','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('33','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('33','17');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('33','13');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('34','2');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('34','4');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('34','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('35','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('35','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('35','15');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('36','2');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('36','4');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('36','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('37','4');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('37','5');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('37','8');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('37','17');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('38','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('38','11');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('39','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('39','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('39','17');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('40','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('40','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('40','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('41','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('41','2');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('42','3');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('42','6');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('42','9');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('43','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('43','11');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('43','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('43','13');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('44','1');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('44','10');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('45','12');
  insert into Dishes_Prices (Dish_id, price_id)
  values ('45','13');
  insert into Dishes_Prices (Dish_id,price_id)
  values ('46','2');
  
  --inserts coords
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('1',
  '6',
  '40.656700',
  '-7.915568');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('2',
  '1',
  '40.6600778',
  '-7.9127714');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('3',
  '2',
  '40.6121032',
  '-7.9511443');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('4',
  '3',
  '40.6382983',
  '-7.9300961');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('5',
  '4',
  '40.6462259',
  ',-7.920701');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('6',
  '5',
  '40.642002',
  '7.9268327');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('7',
  '7',
  '40.659125',
  '7.9134872');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('9',
  '9',
  '40.672276',
  '-7.9037807');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('10',
  '10',
  '40.66217',
  '-7.9115861');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('11',
  '11',
  '40.656575',
  '-7.9088937');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('12',
  '12',
  '40.6977016',
  '-7.91345');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('13',
  '13',
  '40.5594641',
  '-7.9529667');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('14',
  '14',
  '40.659196',
  '-7.9192967');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('15',
  '15',
  '40.653393',
  '-7.9160527');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('16',
  '16',
  '40.6462727',
  '-7.9194923');
  insert into coords (COORDS_ID,RESTAURANT_ID,LATITUDE,LONGITUDE)
  values('17',
  '17',
  '40.6463406',
  '-7.9501345');
  
  -- insert USERS
  -- pode e nao dar a palavra passe
  
  INSERT INTO USERS (USER_NAME,USER_PASSWORD,USER_CREATIONDATE,USER_EMAIL,USER_PHONE)
  values(
  'Filipa',
  '1234',
  sysdate,
  Email_list_type('claudiaftrigo@hotmail.com'),
  phone_list_type('935136801'));
  INSERT INTO USERS (USER_NAME,USER_PASSWORD,USER_CREATIONDATE,USER_EMAIL,USER_PHONE)
  values(
  'Rafael',
  '1234',
  sysdate,
  Email_list_type('rafael.ntw@gmail.com'),
  phone_list_type('935136300'));
  