-- customers
INSERT INTO customers (id, first_name, last_name, email, phone, city, country, postal_code, is_verified, created_at) VALUES
  (1, 'Tsung-Yu', 'Liu', 'tsungyu.liu@example.org', '+886 977-358-657', 'Taichung', 'Taiwan', '896', TRUE, '2024-04-13 08:38:15'),
  (2, 'Nathan', 'Petit', 'nathan.petit@example.org', '+33 6 92 97 49 83', 'Paris', 'France', '53017', FALSE, '2024-03-19 05:24:23'),
  (3, 'Jules', 'Martin', 'jules.martin@example.com', '+33 6 34 48 44 46', 'Marseille', 'France', '29838', TRUE, '2024-07-09 03:30:38'),
  (4, 'Patricia', 'Smith', 'patricia.smith@example.net', '+1 559-586-8237', 'Chicago', 'United States', '37446', TRUE, '2026-07-05 16:42:10'),
  (5, 'Finn', 'Krüger', 'finn.krueger@example.com', '+49 153 9401106', 'Stuttgart', 'Germany', '58438', TRUE, '2024-12-07 03:46:41'),
  (6, 'Ryan', 'Hall', 'ryanhall@example.com', '+61 406 098 483', 'Brisbane', 'Australia', '2707', TRUE, '2026-07-18 10:38:07'),
  (7, 'Michael', 'Nelson', 'michael.nelson@example.org', NULL, 'Denver', 'United States', NULL, TRUE, '2026-10-11 09:36:19'),
  (8, 'Tsung-Yu', 'Tsai', 'tsungyu_tsai@example.com', NULL, 'Tainan', 'Taiwan', '733', TRUE, '2024-12-20 20:29:17'),
  (9, 'Thomas', 'Robinson', 'thomas.robinson@example.com', '+44 7653 891509', 'London', 'United Kingdom', 'RQ2 5XI', TRUE, '2025-04-17 13:14:28'),
  (10, 'Amelia', 'Wood', 'awood@example.org', '+44 7146 244855', 'Birmingham', 'United Kingdom', 'VJ4 0UA', TRUE, '2025-03-29 08:56:27'),
  (11, 'Valentina', 'Alves', 'valentina.alves@example.net', '+55 11 90435-7997', 'Rio de Janeiro', 'Brazil', '67286-172', TRUE, '2026-08-27 23:25:03'),
  (12, 'Joseph', 'Garcia', 'joseph.garcia@example.org', '+1 591-960-4236', 'Calgary', 'Canada', 'U5Q 0S8', FALSE, '2025-07-15 19:41:26'),
  (13, 'Freya', 'Brown', 'freya.brown@example.com', '+44 7082 159827', 'Bristol', 'United Kingdom', 'ZH5 8IF', FALSE, '2024-10-19 13:15:16'),
  (14, 'Grace', 'Davis', 'grace99@example.org', '+1 842-786-3158', 'Austin', 'United States', '40951', FALSE, '2025-10-22 08:39:02'),
  (15, 'Laura', 'Weber', 'laura.weber@example.com', '+49 152 1639802', 'Berlin', 'Germany', '66178', TRUE, '2025-07-03 06:42:17'),
  (16, 'Olivia', 'Turner', 'olivia.turner@example.com', '+44 7004 208380', 'Cardiff', 'United Kingdom', 'TF1 3BF', TRUE, '2025-03-13 23:11:36'),
  (17, 'Chien-Ming', 'Huang', 'chienming.huang@example.com', NULL, 'Hsinchu', 'Taiwan', '558', TRUE, '2026-10-15 19:34:58'),
  (18, 'Charlie', 'Walker', 'charlie.walker@example.net', '+44 7062 893301', 'Manchester', 'United Kingdom', NULL, FALSE, '2026-03-27 17:01:48'),
  (19, 'Sota', 'Inoue', 'sinoue@example.net', '+81 90-9859-9037', 'Nagoya', 'Japan', '254-2801', FALSE, '2025-08-15 16:39:57'),
  (20, 'Jack', 'Hall', 'jack75@example.org', '+44 7624 074345', 'Bristol', 'United Kingdom', 'BL5 3TB', FALSE, '2025-07-28 19:09:34');
SELECT setval(pg_get_serial_sequence('customers', 'id'), (SELECT MAX(id) FROM customers));

-- products
INSERT INTO products (id, sku, name, category, price, stock, description) VALUES
  (1, 'EVZ-88102', 'Eco-Friendly Chair', 'Books', 105.99, 396, 'Ea dolore duis in excepteur nostrud nostrud aliqua ea nulla nulla sit id labore. Incididunt nulla non mollit enim magna cupidatat et incididunt incididunt ullamco adipiscing dolore. Esse qui ex ipsum fugiat laboris veniam.'),
  (2, 'DAQ-79503', 'Smart Mug', 'Beauty', 50.99, 368, 'Nostrud minim nulla et mollit incididunt reprehenderit voluptate irure. Deserunt ipsum proident est id tempor nulla pariatur incididunt et in. Lorem consequat voluptate id occaecat anim enim sint.'),
  (3, 'OTH-22731', 'Smart Headphones', 'Home & Kitchen', 38.99, 58, 'Quis occaecat dolor minim eiusmod aute velit consectetur labore dolor id eiusmod adipiscing incididunt. Proident in laborum exercitation anim reprehenderit aliqua et consequat id nisi magna mollit cupidatat.'),
  (4, 'BCE-50089', 'Classic Steel Chair', 'Books', 29.99, 140, 'Dolor nulla duis anim officia do sunt cupidatat. Voluptate sunt proident sint ipsum veniam magna elit et pariatur dolor laborum quis ex.'),
  (5, 'JTL-18140', 'Wireless Cotton Cutting Board', 'Sports & Outdoors', 2.99, 378, 'Irure amet sunt voluptate dolor voluptate est tempor cillum consectetur occaecat anim. Qui sed aliqua consequat aliquip veniam eiusmod id laborum incididunt excepteur enim pariatur.'),
  (6, 'KIH-74013', 'Premium Notebook', 'Garden', 168.36, 97, 'Ullamco ullamco occaecat est sed sed. Cupidatat ea lorem enim elit adipiscing do incididunt voluptate dolore dolore dolor.'),
  (7, 'TRO-25807', 'Wireless Leather Watch', 'Pet Supplies', 597.99, 293, 'Et do laboris officia laboris magna proident proident consequat cupidatat laboris magna incididunt irure. Excepteur labore consequat do duis sit duis in est ex. Aute pariatur mollit consequat aliqua nostrud laboris tempor enim anim esse officia tempor.'),
  (8, 'OVW-74257', 'Aluminum Speaker', 'Automotive', 2.99, 386, 'Eiusmod dolor quis aliqua ea ipsum amet adipiscing. Aliquip exercitation labore commodo laboris sunt amet velit exercitation nulla esse aliqua.'),
  (9, 'SKA-16856', 'Ultralight Backpack', 'Office Supplies', 59.99, 110, 'Et in consequat sed duis nisi. Dolor cupidatat duis dolore irure in adipiscing cupidatat enim aute. Tempor lorem commodo ea laborum deserunt. Ea deserunt aute sed velit sint in ut nostrud ipsum reprehenderit elit incididunt sit.'),
  (10, 'ZAC-05798', 'Portable Headphones', 'Beauty', 11.07, 371, 'Commodo sit sit id incididunt ad occaecat minim ea amet. Incididunt exercitation pariatur consectetur tempor ea non nostrud in enim.'),
  (11, 'IPO-14267', 'Classic Phone Stand', 'Office Supplies', 57.99, 234, 'Proident consequat do officia officia duis. Officia ea nostrud amet voluptate aliqua ad ad.'),
  (12, 'QOV-03733', 'Premium Chair', 'Beauty', 60.69, 163, 'Incididunt ullamco sed ipsum nisi exercitation ipsum quis non tempor enim minim exercitation commodo. Minim id reprehenderit non proident irure incididunt cupidatat non dolor officia exercitation aute tempor. Aliqua sit excepteur enim sint nulla adipiscing commodo exercitation sed aliquip eiusmod consectetur.'),
  (13, 'UJE-26309', 'Heavy-Duty Headphones', 'Home & Kitchen', 66.99, 448, 'Ullamco et sed voluptate ipsum occaecat do mollit id elit nostrud id cillum. Qui nisi lorem voluptate elit reprehenderit voluptate in ut incididunt officia ipsum cillum consequat. Sit velit lorem ex reprehenderit aute ex do.'),
  (14, 'DCO-02526', 'Vintage Oak Headphones', 'Home & Kitchen', 3.99, 362, 'Laboris consectetur consectetur cillum reprehenderit minim ipsum cupidatat minim ipsum in do excepteur adipiscing. Mollit mollit labore laboris tempor culpa labore. Nostrud incididunt aute commodo culpa ea ipsum.'),
  (15, 'CFH-91128', 'Classic Watch', 'Office Supplies', 24.99, 269, 'Proident irure aliquip est deserunt culpa culpa magna. Qui fugiat aliqua commodo proident deserunt elit cupidatat. Veniam et dolor culpa ea commodo lorem amet voluptate nisi.'),
  (16, 'QSU-89722', 'Portable Glass Keyboard', 'Books', 52.99, 376, 'Ex adipiscing ad commodo deserunt cupidatat est exercitation qui. Irure tempor culpa adipiscing et cillum. Officia commodo ad magna sit duis qui laboris cillum. Duis sint minim anim tempor nisi nostrud aute pariatur magna proident amet.'),
  (17, 'ALO-83544', 'Premium Jacket', 'Office Supplies', 3.99, 384, 'Elit voluptate fugiat in qui proident nulla nisi cillum veniam excepteur amet. Cillum amet veniam non labore in est enim duis culpa proident.'),
  (18, 'BOB-47390', 'Heavy-Duty Watch', 'Clothing', 35.99, 273, 'Ut non irure aliqua officia voluptate amet ullamco quis. Nulla ea qui occaecat consectetur lorem commodo amet minim mollit aliqua id. Ullamco fugiat lorem consectetur enim minim laborum qui enim cillum minim.'),
  (19, 'XFR-71989', 'Minimalist Sneakers', 'Automotive', 5.39, 146, 'Id ex sunt minim nostrud laborum commodo occaecat mollit et pariatur. Consequat occaecat irure ut sint sit sint aliqua nisi. Laboris qui sint magna do elit eiusmod lorem laboris ut elit tempor.'),
  (20, 'URP-84194', 'Silicone Desk Lamp', 'Grocery', 5.99, 397, 'Deserunt aliquip consectetur elit sint anim consectetur est tempor laboris. Nulla incididunt aliqua proident esse commodo.');
SELECT setval(pg_get_serial_sequence('products', 'id'), (SELECT MAX(id) FROM products));

-- orders
INSERT INTO orders (id, customer_id, status, shipping_address, shipping_city, total, created_at, shipped_at) VALUES
  (1, 8, 'paid', 'No. 158, Minzu Rd., Tainan, Tainan City 733, Taiwan', 'Tainan', 111.97, '2025-10-28 15:15:26', NULL),
  (2, 6, 'delivered', '107 Collins St, Brisbane, QLD 2707, Australia', 'Brisbane', 467.96, '2026-10-12 18:16:57', '2026-10-14 11:43:09'),
  (3, 1, 'paid', 'No. 138, Wenhua Rd., Taichung, Taichung City 896, Taiwan', 'Taichung', 59.99, '2025-11-30 23:12:04', NULL),
  (4, 19, 'shipped', 'Nakano 9-24-8, Nagoya, Aichi 254-2801, Japan', 'Nagoya', 109.96, '2026-07-22 00:07:29', NULL),
  (5, 5, 'delivered', 'Bahnhofstraße 92, Stuttgart, Baden-Württemberg 58438, Germany', 'Stuttgart', 19.95, '2025-01-09 05:51:52', '2025-01-16 21:04:37'),
  (6, 13, 'paid', '118 King Street, Bristol, England ZH5 8IF, United Kingdom', 'Bristol', 21.95, '2025-09-07 19:40:10', NULL),
  (7, 5, 'paid', 'Bahnhofstraße 92, Stuttgart, Baden-Württemberg 58438, Germany', 'Stuttgart', 541.97, '2025-10-03 12:13:51', NULL),
  (8, 7, 'pending', '1978 Sunset Blvd, Denver, CO 26295, United States', 'Denver', 121.38, '2026-10-22 03:30:17', NULL),
  (9, 13, 'shipped', '118 King Street, Bristol, England ZH5 8IF, United Kingdom', 'Bristol', 0, '2026-05-27 23:31:29', '2026-05-28 03:55:45'),
  (10, 17, 'shipped', 'No. 181, Minsheng Rd., Hsinchu, Hsinchu City 558, Taiwan', 'Hsinchu', 0, '2026-10-20 12:41:25', '2026-10-24 01:13:41'),
  (11, 9, 'paid', '8 Mill Lane, London, England RQ2 5XI, United Kingdom', 'London', 0, '2026-08-29 17:44:06', NULL),
  (12, 19, 'delivered', 'Nakano 9-24-8, Nagoya, Aichi 254-2801, Japan', 'Nagoya', 669.97, '2025-12-08 17:58:50', '2025-12-09 09:58:31'),
  (13, 8, 'delivered', 'No. 158, Minzu Rd., Tainan, Tainan City 733, Taiwan', 'Tainan', 275.94, '2025-11-05 09:37:33', '2025-11-11 05:12:20'),
  (14, 17, 'delivered', 'No. 181, Minsheng Rd., Hsinchu, Hsinchu City 558, Taiwan', 'Hsinchu', 0, '2026-10-19 17:28:05', '2026-11-01 21:00:41'),
  (15, 3, 'shipped', '11 boulevard Voltaire, Marseille, Provence-Alpes-Côte d''Azur 29838, France', 'Marseille', 32.98, '2025-04-17 07:53:00', '2025-04-27 09:17:55'),
  (16, 3, 'delivered', '11 boulevard Voltaire, Marseille, Provence-Alpes-Côte d''Azur 29838, France', 'Marseille', 35.99, '2026-06-03 13:02:17', NULL),
  (17, 4, 'delivered', '2952 Maple Dr, Chicago, IL 37446, United States', 'Chicago', 99.96, '2026-10-26 00:45:35', '2026-10-31 22:40:54'),
  (18, 9, 'delivered', '8 Mill Lane, London, England RQ2 5XI, United Kingdom', 'London', 217.96, '2025-06-19 05:35:04', '2025-06-30 22:58:23'),
  (19, 7, 'paid', '1978 Sunset Blvd, Denver, CO 26295, United States', 'Denver', 152.97, '2026-10-31 23:43:18', NULL),
  (20, 8, 'paid', 'No. 158, Minzu Rd., Tainan, Tainan City 733, Taiwan', 'Tainan', 597.99, '2026-06-05 09:41:53', NULL),
  (21, 16, 'delivered', '26 Station Road, Cardiff, Wales TF1 3BF, United Kingdom', 'Cardiff', 0, '2025-10-30 20:39:30', '2025-11-03 20:42:21'),
  (22, 12, 'delivered', '2844 Church St, Calgary, AB U5Q 0S8, Canada', 'Calgary', 7.98, '2025-10-15 19:36:27', '2025-10-26 19:16:01'),
  (23, 4, 'shipped', '2952 Maple Dr, Chicago, IL 37446, United States', 'Chicago', 0, '2026-08-22 00:46:19', '2026-08-28 13:27:23'),
  (24, 4, 'delivered', '2952 Maple Dr, Chicago, IL 37446, United States', 'Chicago', 59.98, '2026-10-16 13:43:30', '2026-10-23 01:39:33'),
  (25, 13, 'delivered', '118 King Street, Bristol, England ZH5 8IF, United Kingdom', 'Bristol', 0, '2026-03-22 14:08:17', '2026-03-25 06:05:29'),
  (26, 13, 'shipped', '118 King Street, Bristol, England ZH5 8IF, United Kingdom', 'Bristol', 0, '2025-09-13 03:33:08', '2025-09-19 13:41:08'),
  (27, 12, 'delivered', '2844 Church St, Calgary, AB U5Q 0S8, Canada', 'Calgary', 0, '2025-11-19 16:24:19', '2025-11-27 10:58:52'),
  (28, 4, 'delivered', '2952 Maple Dr, Chicago, IL 37446, United States', 'Chicago', 66.99, '2026-07-31 06:06:04', '2026-08-13 02:18:23'),
  (29, 15, 'delivered', 'Schulstraße 11, Berlin 66178, Germany', 'Berlin', 16.17, '2026-10-25 02:21:10', '2026-11-01 23:59:59'),
  (30, 1, 'shipped', 'No. 138, Wenhua Rd., Taichung, Taichung City 896, Taiwan', 'Taichung', 38.99, '2025-11-23 15:48:24', NULL),
  (31, 3, 'delivered', '11 boulevard Voltaire, Marseille, Provence-Alpes-Côte d''Azur 29838, France', 'Marseille', 56.38, '2026-10-04 16:37:31', '2026-10-08 18:40:10'),
  (32, 11, 'cancelled', 'Rua XV de Novembro, 143, Rio de Janeiro, RJ 67286-172, Brazil', 'Rio de Janeiro', 144.76, '2026-10-10 10:57:23', NULL),
  (33, 1, 'pending', 'No. 138, Wenhua Rd., Taichung, Taichung City 896, Taiwan', 'Taichung', 0, '2026-08-20 11:16:12', NULL),
  (34, 14, 'delivered', '120 River Rd, Austin, TX 40951, United States', 'Austin', 29.99, '2025-12-19 19:42:35', '2025-12-29 11:07:06'),
  (35, 4, 'delivered', '2952 Maple Dr, Chicago, IL 37446, United States', 'Chicago', 597.99, '2026-10-19 12:08:02', '2026-10-25 18:06:38'),
  (36, 16, 'delivered', '26 Station Road, Cardiff, Wales TF1 3BF, United Kingdom', 'Cardiff', 23.92, '2026-01-24 06:38:32', '2026-02-05 07:32:02'),
  (37, 20, 'pending', '165 Station Road, Bristol, England BL5 3TB, United Kingdom', 'Bristol', 0, '2026-10-13 19:53:03', NULL),
  (38, 1, 'delivered', 'No. 138, Wenhua Rd., Taichung, Taichung City 896, Taiwan', 'Taichung', 10.78, '2025-07-28 02:25:23', '2025-07-28 05:32:41'),
  (39, 14, 'delivered', '120 River Rd, Austin, TX 40951, United States', 'Austin', 0, '2026-10-16 21:05:27', '2026-10-27 02:38:33'),
  (40, 3, 'delivered', '11 boulevard Voltaire, Marseille, Provence-Alpes-Côte d''Azur 29838, France', 'Marseille', 0, '2026-06-16 23:52:40', '2026-06-28 08:25:55'),
  (41, 10, 'delivered', '185 Park Road, Birmingham, England VJ4 0UA, United Kingdom', 'Birmingham', 172.3, '2026-06-04 01:02:08', '2026-06-14 07:23:42'),
  (42, 9, 'pending', '8 Mill Lane, London, England RQ2 5XI, United Kingdom', 'London', 0, '2026-07-05 15:30:18', NULL),
  (43, 8, 'delivered', 'No. 158, Minzu Rd., Tainan, Tainan City 733, Taiwan', 'Tainan', 270.95, '2025-07-14 12:05:06', '2025-07-26 00:11:57'),
  (44, 1, 'cancelled', 'No. 138, Wenhua Rd., Taichung, Taichung City 896, Taiwan', 'Taichung', 2391.96, '2026-02-15 18:09:42', NULL),
  (45, 2, 'delivered', '131 boulevard Voltaire, Paris, Île-de-France 53017, France', 'Paris', 152.97, '2026-08-20 06:15:53', '2026-08-23 18:20:46'),
  (46, 20, 'shipped', '165 Station Road, Bristol, England BL5 3TB, United Kingdom', 'Bristol', 0, '2026-04-29 16:33:32', '2026-05-12 08:25:57'),
  (47, 10, 'shipped', '185 Park Road, Birmingham, England VJ4 0UA, United Kingdom', 'Birmingham', 50.99, '2026-07-13 03:21:18', '2026-07-15 19:06:17'),
  (48, 6, 'paid', '107 Collins St, Brisbane, QLD 2707, Australia', 'Brisbane', 122.36, '2026-10-23 00:24:29', NULL),
  (49, 7, 'delivered', '1978 Sunset Blvd, Denver, CO 26295, United States', 'Denver', 0, '2026-10-24 11:57:57', '2026-11-01 23:59:59'),
  (50, 1, 'delivered', 'No. 138, Wenhua Rd., Taichung, Taichung City 896, Taiwan', 'Taichung', 0, '2025-01-09 21:30:18', '2025-01-22 02:14:35');
SELECT setval(pg_get_serial_sequence('orders', 'id'), (SELECT MAX(id) FROM orders));

-- order_items
INSERT INTO order_items (order_id, product_id, quantity, unit_price) VALUES
  (45, 2, 3, 50.99),
  (31, 19, 1, 5.39),
  (13, 9, 2, 59.99),
  (29, 19, 3, 5.39),
  (15, 5, 1, 2.99),
  (1, 8, 2, 2.99),
  (3, 9, 1, 59.99),
  (2, 3, 10, 38.99),
  (48, 3, 3, 38.99),
  (5, 14, 5, 3.99),
  (12, 7, 1, 597.99),
  (2, 10, 1, 11.07),
  (32, 13, 2, 66.99),
  (20, 7, 1, 597.99),
  (41, 18, 1, 35.99),
  (43, 5, 1, 2.99),
  (32, 19, 2, 5.39),
  (48, 19, 1, 5.39),
  (8, 12, 2, 60.69),
  (17, 15, 4, 24.99),
  (28, 13, 1, 66.99),
  (44, 7, 4, 597.99),
  (7, 12, 3, 60.69),
  (13, 3, 4, 38.99),
  (24, 4, 2, 29.99),
  (15, 4, 1, 29.99),
  (36, 5, 8, 2.99),
  (18, 1, 2, 105.99),
  (19, 2, 3, 50.99),
  (41, 15, 3, 24.99),
  (35, 7, 1, 597.99),
  (6, 17, 4, 3.99),
  (4, 2, 2, 50.99),
  (2, 13, 1, 66.99),
  (22, 14, 2, 3.99),
  (18, 8, 2, 2.99),
  (31, 2, 1, 50.99),
  (12, 18, 2, 35.99),
  (34, 4, 1, 29.99),
  (41, 10, 5, 11.07),
  (41, 20, 1, 5.99),
  (4, 14, 2, 3.99),
  (47, 2, 1, 50.99),
  (30, 3, 1, 38.99),
  (7, 18, 10, 35.99),
  (38, 19, 2, 5.39),
  (6, 20, 1, 5.99),
  (43, 13, 4, 66.99),
  (16, 18, 1, 35.99),
  (1, 1, 1, 105.99);