<reponame>fried-snickers/my-thai-star<filename>java/mtsj/core/src/main/resources/db/migration/V0006__R001__Add_orders_data.sql
INSERT INTO "ORDERS"(id, orderState, paymentState, modificationCounter, idBooking, idInvitedGuest, idHost) VALUES
(1000021, 'orderDelivered', 'pending', 1, 1000001, NULL, NULL),
(1000026, 'orderTaken', 'pending', 1, 1000002, NULL, NULL),
(1000031, 'orderDelivered', 'paid', 2, 1000003, NULL, NULL),
(1000037, 'orderTaken', 'pending', 0, 1000004, NULL, NULL),
(1000038, 'orderTaken', 'pending', 1, 1000005, NULL, NULL),
(1000040, 'canceled', 'canceled', 1, 1000006, NULL, NULL),
(1000043, 'orderTaken', 'pending', 1, 1000007, NULL, NULL),
(1000046, 'orderTaken', 'pending', 1, 1000008, NULL, NULL),
(1000049, 'orderDelivered', 'pending', 1, 1000009, NULL, NULL),
(1000054, 'orderCompleted', 'paid', 3, 1000010, NULL, NULL),
(1000056, 'orderTaken', 'pending', 0, 1000012, NULL, NULL),
(1000058, 'orderTaken', 'paid', 1, 1000017, NULL, NULL),
(1000063, 'orderCompleted', 'paid', 3, 1000016, NULL, NULL);

INSERT INTO "ORDERLINE"(id, modificationCounter, idDish, amount, comment, idOrder) VALUES
(1000022, 0, 8, 1, NULL, 1000021),
(1000023, 0, 17, 2, '<NAME>', 1000021),
(1000024, 0, 21, 1, NULL, 1000021),
(1000025, 0, 28, 2, 'nicht zu stark', 1000021),
(1000027, 0, 15, 3, 'Nudeln al dente', 1000026),
(1000028, 0, 13, 3, NULL, 1000026),
(1000029, 0, 27, 2, NULL, 1000026),
(1000030, 0, 26, 1, NULL, 1000026),
(1000032, 1, 2, 1, '<NAME> gepraten', 1000031),
(1000033, 0, 12, 2, NULL, 1000031),
(1000034, 2, 17, 3, '<NAME>', 1000031),
(1000035, 2, 27, 3, NULL, 1000031),
(1000036, 2, 24, 2, NULL, 1000031),
(1000039, 2, 29, 5, NULL, 1000038),
(1000041, 0, 1, 3, '<NAME>', 1000040),
(1000042, 0, 25, 3, NULL, 1000040),
(1000044, 0, 11, 2, NULL, 1000043),
(1000045, 2, 24, 1, NULL, 1000043),
(1000047, 1, 19, 1, '<NAME>', 1000046),
(1000048, 2, 15, 1, NULL, 1000046),
(1000050, 0, 14, 1, 'Nudeln gut durchgekocht', 1000049),
(1000055, 0, 28, 1, NULL, 1000054),
(1000057, 0, 14, 2, NULL, 1000056),
(1000059, 0, 9, 3, STRINGDECODE('nicht so stark ged\u00e4mpft'), 1000058),
(1000060, 0, 11, 3, NULL, 1000058),
(1000061, 0, 27, 2, NULL, 1000058),
(1000062, 0, 29, 4, NULL, 1000058),
(1000064, 0, 18, 3, '<NAME>', 1000063);

INSERT INTO "ORDERDISHEXTRAINGREDIENT"(id, modificationCounter, idOrderLine, idIngredient) VALUES
(1, NULL, 1000023, 1),
(2, NULL, 1000024, 0),
(3, NULL, 1000027, 1),
(4, NULL, 1000041, 1),
(6, NULL, 1000050, 1),
(9, NULL, 1000057, 1);