INSERT INTO eat.role (id, name)

VALUES (1, 'ADMIN')

,(2, 'USER');

SELECT setval('eat.role_id_seq', (SELECT count(*) FROM eat.role));

INSERT INTO eat.user (id, name, active, password, username)

VALUES (1, 'Administrator', true, '{bcrypt}$2a$10$qTOh9o5HxlXY6jM724XcrOV.mWhOyD3/.V7vuCOwnszwiLrj8wCCO', 'admin') -- Raw password: admin

,(2, 'Normal user', true, '{bcrypt}$2a$10$i7LFiCo1JRm87ERePQOS3OkZ3Srgub8F7GyoWu6NmUuCLDTPq8zMW', 'user'); -- Raw password: user

SELECT setval('eat.user_id_seq', (SELECT count(*) FROM eat.user));

INSERT INTO eat.user_role (user_id, role_id)

VALUES (1, 1)

,(1, 2)

,(2, 2);

INSERT INTO eat.pizza (id, name, cost)

VALUES (1, 'Margherita', 7)

,(2, 'Marinara', 7.5)

,(3, 'Carbonara', 8.25)

,(4, 'Frutti di Mare', 6.5)

,(5, 'Pugliese', 7.5)

,(6, 'Hawaiian', 8);

SELECT setval('eat.pizza_id_seq', (SELECT count(*) FROM eat.pizza));

INSERT INTO eat.ingredient (id, name)

VALUES (1, 'Cheese')

,(2, 'Ham')

,(3, 'Onion')

,(4, 'Pineapple')

,(5, 'Chicken')

,(6, 'Tomato sauce')

,(7, 'Mozzarella')

,(8, 'Oregano')

,(9, 'Garlic')

,(10, 'Mushrooms')

,(11, 'Parmesan')

,(12, 'Egg')

,(13, 'Bacon')

,(14, 'Basil')

,(15, 'Seafood');

SELECT setval('eat.ingredient_id_seq', (SELECT count(*) FROM eat.ingredient));

INSERT INTO eat.pizza_ingredient (pizza_id, ingredient_id)

VALUES (1, 6), (1, 7), (1, 8)

,(2, 6), (2, 9), (2, 14)

,(3, 6), (3, 7), (3, 11), (3, 12), (3, 13)

,(4, 6), (4, 15)

,(5, 6), (5, 7), (5, 8), (5, 3)

,(6, 6), (6, 1), (6, 4), (6, 2);

INSERT INTO eat.order (id, code, created)

VALUES (1, 'Order 1', '2018-12-31 16:00:00'::TIMESTAMP)

,(2, 'Order 2', '2019-01-02 18:00:00'::TIMESTAMP)

,(3, 'Order 3', '2019-01-05 13:30:00'::TIMESTAMP);

SELECT setval('eat.order_id_seq', (SELECT count(*) FROM eat.order));

INSERT INTO eat.order_line(id, order_id, pizza_id, cost, amount)

VALUES (1, 1, 2, 15, 2)

,(2, 2, 4, 6.5, 1), (3, 2, 6, 8, 1)

,(4, 3, 5, 22.5, 3), (5, 3, 1, 14, 2), (6, 3, 3, 8.25, 1);

SELECT setval('eat.order_line_id_seq', (SELECT count(*) FROM eat.order_line));

INSERT INTO security.oauth_client_details (client_id, client_secret

,scope, authorized_grant_types

,web_server_redirect_uri, authorities

,access_token_validity, refresh_token_validity

,additional_information, autoapprove)

VALUES ('Spring5Microservices', '{bcrypt}$2a$10$NlKX/TyTk41qraDjxg98L.xFdu7IQYRoi3Z37PZmjekaQYAeaRZgO' -- Raw password: Spring5Microservices

,'read,write,trust', 'implicit,refresh_token,password,authorization_code,client_credentials'

,null, null

,900, 3600

,null, true);

INSERT INTO security.jwt_client_details (client_id, client_secret

,signature_secret

,signature_algorithm, authentication_generator, token_type

,use_jwe, access_token_validity, refresh_token_validity)

VALUES ('Spring5Microservices', '{bcrypt}$2a$10$NlKX/TyTk41qraDjxg98L.xFdu7IQYRoi3Z37PZmjekaQYAeaRZgO' -- Raw password: Spring5Microservices

-- Raw password: Spring5Microservices_999#secret#789(jwt)$3411781_GTDSAET-569016310k

,'{cipher}04f1b9a71d880569283849aa911e4f3f3373a2522cba355e25e17f7ac7e262cb63d41295ab8bca038823b884858f05457306159cdfe68eb11c616028d6213b719887c07750e8c4b60dfea4196b1ddaffdcd462180028abc1a2d1dda69b8ac4bf'

,'HS512', 'SPRING5_MICROSERVICES', 'Bearer'

,true, 900, 3600);