insert into users (username, email, password, enabled) VALUES ('admin', '[email protected]', '$2a$10$0MMwY.IQqpsVc1jC8u7IJ.2rT8b0Cd3b3sfIBGV2zfgnPGtT4r0.C', 1) ON CONFLICT DO NOTHING;
insert into users (username, email, password, enabled) VALUES ('user1', '[email protected]', '$2a$06$3jYRJrg0ghaaypjZ/.g4SethoeA51ph3UD4kZi9oPkeMTpjKU5uo6', 1) ON CONFLICT DO NOTHING;
insert into users (username, email, password, enabled) VALUES ('user2', '[email protected]', '$2a$06$3jYRJrg0ghaaypjZ/.g4SethoeA51ph3UD4kZi9oPkeMTpjKU5uo6', 1) ON CONFLICT DO NOTHING;

insert into authorities (user_id, username, authority) VALUES (1, 'admin', 'ROLE_ADMIN') ON CONFLICT DO NOTHING;
insert into authorities (user_id, username, authority) VALUES (2, 'user1', 'ROLE_USER') ON CONFLICT DO NOTHING;
insert into authorities (user_id, username, authority) VALUES (3, 'user2', 'ROLE_USER') ON CONFLICT DO NOTHING;

insert into places (name, user_id, large_description, small_description, address) VALUES ('Sea Hotel', 1, 'Bacon ipsum dolor amet sirloin pork belly short loin shoulder rump bresaola t-bone beef pig leberkas strip steak. Corned beef pork belly strip steak turducken prosciutto cupim cow. Doner salami buffalo shankle pancetta biltong, sirloin fatback short loin burgdoggen ball tip tongue. Doner kevin picanha beef turducken corned beef, kielbasa pork frankfurter jerky pork belly tail boudin ribeye salami. T-bone boudin ham hock burgdoggen. Turkey burgdoggen corned beef, spare ribs pastrami fatback biltong doner ribeye meatball sirloin. Pancetta chicken beef ribs shoulder sausage drumstick shankle rump pork belly capicola cupim turkey tri-tip bacon.', 'Pig corned beef ball tip, turkey pork sirloin fatback capicola.', 'Random Road 32') ON CONFLICT DO NOTHING;
insert into places (name, user_id, large_description, small_description, address) VALUES ('Tower Hotel', 2, 'Bacon ipsum dolor amet sirloin pork belly short loin shoulder rump bresaola t-bone beef pig leberkas strip steak. Corned beef pork belly strip steak turducken prosciutto cupim cow. Doner salami buffalo shankle pancetta biltong, sirloin fatback short loin burgdoggen ball tip tongue. Doner kevin picanha beef turducken corned beef, kielbasa pork frankfurter jerky pork belly tail boudin ribeye salami. T-bone boudin ham hock burgdoggen. Turkey burgdoggen corned beef, spare ribs pastrami fatback biltong doner ribeye meatball sirloin. Pancetta chicken beef ribs shoulder sausage drumstick shankle rump pork belly capicola cupim turkey tri-tip bacon.', 'Pork pork chop sirloin, burgdoggen pancetta ham venison bresaola.', 'Random Road 16') ON CONFLICT DO NOTHING;
insert into places (name, user_id, large_description, small_description, address) VALUES ('Downtown Hotel', 2, 'Bacon ipsum dolor amet sirloin pork belly short loin shoulder rump bresaola t-bone beef pig leberkas strip steak. Corned beef pork belly strip steak turducken prosciutto cupim cow. Doner salami buffalo shankle pancetta biltong, sirloin fatback short loin burgdoggen ball tip tongue. Doner kevin picanha beef turducken corned beef, kielbasa pork frankfurter jerky pork belly tail boudin ribeye salami. T-bone boudin ham hock burgdoggen. Turkey burgdoggen corned beef, spare ribs pastrami fatback biltong doner ribeye meatball sirloin. Pancetta chicken beef ribs shoulder sausage drumstick shankle rump pork belly capicola cupim turkey tri-tip bacon.', 'Chicken jerky biltong kielbasa.', 'Random Road 79') ON CONFLICT DO NOTHING;

insert into place_urls (place_id, url) VALUES (1, 'sea-hotel') ON CONFLICT DO NOTHING;
insert into place_urls (place_id, url) VALUES (2, 'tower-hotel') ON CONFLICT DO NOTHING;
insert into place_urls (place_id, url) VALUES (3, 'downtown-hotel') ON CONFLICT DO NOTHING;

insert into bookings (place_id, name, phonenumber, reservation_date, receipt_number) VALUES (1, 'Matti Näsä', '0403934577', '2019-10-20', '5266894187637345544959825') ON CONFLICT DO NOTHING;
insert into bookings (place_id, name, phonenumber, reservation_date, receipt_number) VALUES (2, 'Jaakko Parantainen', '0501215281', '2019-10-04', '5466894787637345544959825') ON CONFLICT DO NOTHING;
insert into bookings (place_id, name, phonenumber, reservation_date, receipt_number) VALUES (2, 'Iso Pebe', '0505136369', '2019-10-11', '5236894787617345544959825') ON CONFLICT DO NOTHING;
© 2019 GitHub, Inc.