INSERT INTO `order_state` (`id`, `system_state`, `send_email`, `color`, `dt_name`, `created_at`, `updated_at`,
                           `email_template_id`)
VALUES (1, 'received', 1, '#98d723', 'Objednávka přijatá', '2024-07-29 05:06:40', '2024-07-29 05:24:56', 1),
       (2, 'deleted', 0, '#000000', 'Objednávka smazaná', '2024-08-28 18:36:58', NULL, 1),
       (3, 'order_sent', 1, '#d1232350', 'Objednávka odeslána', '2025-06-15 04:09:10', '2025-06-17 13:20:42', 4),
       (4, 'payment_received', 1, '#305836', 'Přijatá platba', '2025-06-15 04:13:55', '2025-06-17 13:21:04', 5);

INSERT INTO `order` (`id`, `notes`, `items_total`, `locale`, `created_by_guest`, `total_price`, `total_tax`,
                     `total_price_with_tax`, `created_at`, `updated_at`, `email`, `delivery_address_id`,
                     `billing_address_id`, `customer_id`, `state_id`, `carrier_id`, `carrier_address`, `carrier_price`,
                     `payment_id`, `payment_price`, `total_weight`, `code`, `exported`, `track_id`, `event_sent`,
                     `currency_id`)
VALUES (1, NULL, 1, 'cs_CZ', 1, 12300, 0, 12300, '2025-03-21 18:34:12', NULL, 'jaroslavtrsek@gmail.com', 1, NULL, 1, 1,
        1, NULL, 0, 1, 0, 0, 'CODE001', 0, '645d6259-3c9c-4021-a351-2f3dc074e7a7', 1, 1),
       (2, NULL, 2, 'cs_CZ', 1, 200000, 0, 200000, '2025-03-20 18:34:41', NULL, 'delivery@delivery.com', 2, NULL, 1, 1,
        1, NULL, 0, 1, 0, 0, 'CODE003', 0, '2e729a94-68fd-4312-9583-638d9ed407c4', 1, 1),
       (3, NULL, 4, 'cs_CZ', 1, 312300, 0, 312300, '2025-03-19 18:35:09', NULL, 'jaroslavtrsek@gmail.com', 3, NULL, 1,
        1, 1, NULL, 0, 1, 0, 0, 'CODE003', 0, '60f2ade7-82f6-4f70-b7b7-568d6c96436b', 1, 1);

INSERT INTO `order_item` (`id`, `product_id`, `variant`, `quantity`, `unit`, `unit_price`, `unit_tax`, `total_price`,
                          `product_name`, `total_tax`, `value_names`, `created_at`, `updated_at`, `cached_image`,
                          `order_id`, `weight`, `total_weight`)
VALUES (1, 4, NULL, 1, 'ks', 12300, NULL, 12300, 'Rum Rammstein 12y 0,7l 40% GB', 0, NULL, NULL, NULL,
        'rammstein-01-6579b3f0c7ca6.jpg', 1, NULL, NULL),
       (2, 5, NULL, 2, 'ks', 100000, NULL, 200000, 'Villa Rica Single barrel 23y', 0, NULL, NULL, NULL,
        'rum-villa-rica-02-658427fbe6a8a.jpg', 2, NULL, NULL),
       (3, 4, NULL, 1, 'ks', 12300, NULL, 12300, 'Rum Rammstein 12y 0,7l 40% GB', 0, NULL, NULL, NULL,
        'rammstein-01-6579b3f0c7ca6.jpg', 3, NULL, NULL),
       (4, 5, NULL, 3, 'ks', 100000, NULL, 300000, 'Villa Rica Single barrel 23y', 0, NULL, NULL, NULL,
        'rum-villa-rica-02-658427fbe6a8a.jpg', 3, NULL, NULL);

INSERT INTO `order_state_history` (`id`, `created_at`, `order_state_id`, `order_ref_id`, `user_id`)
VALUES (1, '2025-03-21 18:34:12', 1, 1, NULL),
       (2, '2025-03-21 18:34:41', 1, 2, NULL),
       (3, '2025-03-21 18:35:09', 1, 3, NULL),
       (4, '2025-04-01 05:45:23', 2, 2, 1),
       (5, '2025-04-01 05:53:29', 1, 2, 1);

INSERT INTO `order_state_translation` (`id`, `name`, `locale`, `created_at`, `updated_at`, `order_state_id`)
VALUES (1, 'Objednávka přijatá', 'cs_CZ', '2024-07-29 05:11:47', NULL, 1),
       (2, 'Objednávka smazaná', 'cs_CZ', '2024-08-28 18:36:58', NULL, 2);
