------------------- clientes -----------------
INSERT INTO cliente
    --          cpf     ,nome   ,data_nascimento,sexo,   rua    ,numero, bairro  ,cep       ,email
    VALUES('00000000001','jose',DATE'1960-05-03','m','rua floriano',69,'centro','12345678','ze@bol.com.br');

INSERT INTO cliente
    VALUES('00000000002','maria',DATE'1970-06-06','f','rua peixoto',34,'centenario','11625711','maria@bol.com.br');

INSERT INTO cliente
    VALUES('00000000003','antonio',DATE'1980-07-07','m','rua severino',98,'alto branco','16850111','antonio@bol.com.br');

INSERT INTO cliente
    VALUES('00000000004','ana',DATE'1990-08-01','f','rua bezerra',76,'catole','09639729','ana@bol.com.br');

INSERT INTO cliente
    VALUES('00000000005','lunga',DATE'2000-09-05','m','rua cabral',89,'catole','19274934','lunga@bol.com.br');

--------------------dependentes ---------------------

INSERT INTO dependente
    --        cpf,         titular,       nome,        data_nasc
    VALUES('12315678901','00000000001','jose filho', DATE'1990-03-09');

INSERT INTO dependente
    VALUES('12341434501','00000000002','maria filho', DATE'1990-08-04');

INSERT INTO dependente
    VALUES('34534345341','00000000003','antonio filho', DATE'1990-04-07');

INSERT INTO dependente
    VALUES('13454538401','00000000004','ana filho', DATE'1990-01-06');

INSERT INTO dependente
    VALUES('13453454574','00000000005','lunga filho', DATE'1990-05-09');

-------------------quartos--------------------------------

INSERT INTO quarto
    --id_quarto,numero,tipo,vista,diaria
    VALUES(01,01,'normal','normal',50.00);

INSERT INTO quarto
    VALUES(02,12,'luxo','mar',100.00);

INSERT INTO quarto
    VALUES(03,02,'normal','normal',50.00);

INSERT INTO quarto
    VALUES(04,30,'premium','mar',150.00);

INSERT INTO quarto
    VALUES(05,03,'normal','cidade',50.00);


--------------------hospedagem-------------------------------

INSERT INTO hospedagem
    --     data_inicio,    data_fim,         cpf_cliente,id_quarto
    VALUES(DATE'2017-03-25',DATE'2017-03-27','00000000001',01);

INSERT INTO hospedagem
    VALUES(DATE'2017-03-22',DATE'2017-03-25','00000000002',02);

INSERT INTO hospedagem
    VALUES(DATE'2017-03-24',DATE'2017-03-28','00000000003',03);

INSERT INTO hospedagem
    VALUES(DATE'2017-03-21',DATE'2017-03-22','00000000004',04);

INSERT INTO hospedagem
    VALUES(DATE'2017-03-23',DATE'2017-03-26','00000000005',05);

------------------reserva-------------------------------------
INSERT INTO reserva
    --data_inicio,data_fim,cpf_cliente,id_quarto
    VALUES(DATE'2017-03-25',DATE'2017-03-27','00000000001',01);

INSERT INTO reserva
    VALUES(DATE'2017-03-25',DATE'2017-03-27','00000000002',02);

INSERT INTO reserva
    VALUES(DATE'2017-03-25',DATE'2017-03-27','00000000003',03);

INSERT INTO reserva
    VALUES(DATE'2017-03-25',DATE'2017-03-27','00000000004',04);

INSERT INTO reserva
    VALUES(DATE'2017-03-25',DATE'2017-03-27','00000000005',05);

---------------------SERVICO-----------------------------------
INSERT INTO servico
    --id_servico, valor
    VALUES(01,10.50);

INSERT INTO servico
    VALUES(02,15.55);

INSERT INTO servico
    VALUES(03,28.50);

INSERT INTO servico
    VALUES(04,87.10);

INSERT INTO servico
    VALUES(05,98.51);

-------------AVALIACAO------------------------------------------
INSERT INTO avaliacao
    --id_servico, cpf_cliente, nota,comentario
    VALUES(01,'00000000001', 9, 'bom');

INSERT INTO avaliacao
    --id_servico, cpf_cliente, nota,comentario
    VALUES(02,'00000000002', 7, 'medio');

INSERT INTO avaliacao
    --id_servico, cpf_cliente, nota,comentario
    VALUES(03,'00000000003', 3, 'muito ruim');

INSERT INTO avaliacao
    --id_servico, cpf_cliente, nota,comentario
    VALUES(04,'00000000004', 6, 'ruim');

INSERT INTO avaliacao
    --id_servico, cpf_cliente, nota,comentario
    VALUES(05,'00000000005', 10, 'otimo');