05_insert_data.sql

-- ============================================================
-- Food Delivery Platform
-- 05_insert_data.sql
-- Meaningful sample data for Oracle 11g XE
-- Run after 01, 02, 03, and 04.
-- ============================================================

-- Delivery zones
INSERT INTO delivery_zone VALUES (delivery_zone_seq.NEXTVAL, 'Civil Lines', 120, 1.10, 35);
INSERT INTO delivery_zone VALUES (delivery_zone_seq.NEXTVAL, 'Madina Town', 150, 1.20, 40);
INSERT INTO delivery_zone VALUES (delivery_zone_seq.NEXTVAL, 'D Ground', 100, 1.00, 30);
INSERT INTO delivery_zone VALUES (delivery_zone_seq.NEXTVAL, 'Peoples Colony', 130, 1.15, 45);
INSERT INTO delivery_zone VALUES (delivery_zone_seq.NEXTVAL, 'Canal Road', 110, 1.05, 35);
INSERT INTO delivery_zone VALUES (delivery_zone_seq.NEXTVAL, 'FAST Campus Area', 90, 1.00, 25);
INSERT INTO delivery_zone VALUES (delivery_zone_seq.NEXTVAL, 'Susan Road', 140, 1.20, 45);
INSERT INTO delivery_zone VALUES (delivery_zone_seq.NEXTVAL, 'Clock Tower', 160, 1.30, 50);

-- Users: customers, restaurant owners, and admin
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Areeba Khan', 'areeba.khan@example.com', '03001230001', 'hash_1001', 'CUSTOMER', TO_DATE('2026-02-01', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Bilal Ahmed', 'bilal.ahmed@example.com', '03001230002', 'hash_1002', 'CUSTOMER', TO_DATE('2026-02-03', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Hina Saleem', 'hina.saleem@example.com', '03001230003', 'hash_1003', 'CUSTOMER', TO_DATE('2026-02-05', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Usman Tariq', 'usman.tariq@example.com', '03001230004', 'hash_1004', 'CUSTOMER', TO_DATE('2026-02-08', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Maham Noor', 'maham.noor@example.com', '03001230005', 'hash_1005', 'CUSTOMER', TO_DATE('2026-02-10', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Danish Ali', 'danish.ali@example.com', '03001230006', 'hash_1006', 'CUSTOMER', TO_DATE('2026-02-12', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Sara Iqbal', 'sara.iqbal@example.com', '03001230007', 'hash_1007', 'CUSTOMER', TO_DATE('2026-02-14', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Fahad Raza', 'fahad.raza@example.com', '03001230008', 'hash_1008', 'CUSTOMER', TO_DATE('2026-02-16', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Nimra Shah', 'nimra.shah@example.com', '03001230009', 'hash_1009', 'CUSTOMER', TO_DATE('2026-02-18', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Zain Malik', 'zain.malik@example.com', '03001230010', 'hash_1010', 'CUSTOMER', TO_DATE('2026-02-20', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Iqra Javed', 'iqra.javed@example.com', '03001230011', 'hash_1011', 'CUSTOMER', TO_DATE('2026-02-22', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Hamza Nadeem', 'hamza.nadeem@example.com', '03001230012', 'hash_1012', 'CUSTOMER', TO_DATE('2026-02-24', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Omar Farooq', 'omar.farooq@example.com', '03001230013', 'hash_1013', 'OWNER', TO_DATE('2026-01-10', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Sadia Imran', 'sadia.imran@example.com', '03001230014', 'hash_1014', 'OWNER', TO_DATE('2026-01-12', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Kamran Butt', 'kamran.butt@example.com', '03001230015', 'hash_1015', 'OWNER', TO_DATE('2026-01-15', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Mehwish Aslam', 'mehwish.aslam@example.com', '03001230016', 'hash_1016', 'OWNER', TO_DATE('2026-01-20', 'YYYY-MM-DD'), 'ACTIVE');
INSERT INTO app_user VALUES (app_user_seq.NEXTVAL, 'Platform Admin', 'admin.foodflow@example.com', '03001230017', 'hash_1017', 'ADMIN', TO_DATE('2026-01-01', 'YYYY-MM-DD'), 'ACTIVE');

-- Customer subclass rows
INSERT INTO customer VALUES (1001, 101, 'House 14, Civil Lines, Faisalabad', 450, 'SILVER');
INSERT INTO customer VALUES (1002, 102, 'Street 8, Madina Town, Faisalabad', 820, 'GOLD');
INSERT INTO customer VALUES (1003, 103, 'Block C, D Ground, Faisalabad', 240, 'BRONZE');
INSERT INTO customer VALUES (1004, 104, 'Main Boulevard, Peoples Colony, Faisalabad', 1200, 'PLATINUM');
INSERT INTO customer VALUES (1005, 105, 'Canal View Apartments, Canal Road', 610, 'SILVER');
INSERT INTO customer VALUES (1006, 106, 'Hostel B, FAST Campus Area', 300, 'BRONZE');
INSERT INTO customer VALUES (1007, 101, 'Flat 5, Civil Lines Market', 90, 'BRONZE');
INSERT INTO customer VALUES (1008, 102, 'Madina Town Commercial Area', 780, 'GOLD');
INSERT INTO customer VALUES (1009, 104, 'Peoples Colony No. 2', 510, 'SILVER');
INSERT INTO customer VALUES (1010, 103, 'D Ground near Food Street', 150, 'BRONZE');
INSERT INTO customer VALUES (1011, 106, 'FAST Campus Faculty Block', 980, 'GOLD');
INSERT INTO customer VALUES (1012, 105, 'Canal Road Executive Homes', 430, 'SILVER');

-- Restaurant owner subclass rows
INSERT INTO restaurant_owner VALUES (1013, 'FD-OWN-2026-001', '04111111001');
INSERT INTO restaurant_owner VALUES (1014, 'FD-OWN-2026-002', '04111111002');
INSERT INTO restaurant_owner VALUES (1015, 'FD-OWN-2026-003', '04111111003');
INSERT INTO restaurant_owner VALUES (1016, 'FD-OWN-2026-004', '04111111004');

-- Restaurants
INSERT INTO restaurant VALUES (restaurant_seq.NEXTVAL, 1013, 101, 'Spice Junction', 'Pakistani Fast Food', '11:00', '23:30', 22, 1, 4.50);
INSERT INTO restaurant VALUES (restaurant_seq.NEXTVAL, 1014, 103, 'Green Fork', 'Healthy Meals', '09:00', '22:00', 18, 1, 4.70);
INSERT INTO restaurant VALUES (restaurant_seq.NEXTVAL, 1015, 102, 'Slice Lab', 'Pizza', '12:00', '01:00', 25, 1, 4.40);
INSERT INTO restaurant VALUES (restaurant_seq.NEXTVAL, 1013, 104, 'BBQ Bazaar', 'Pakistani BBQ', '13:00', '00:30', 28, 1, 4.60);
INSERT INTO restaurant VALUES (restaurant_seq.NEXTVAL, 1016, 105, 'Dessert Pilot', 'Desserts', '10:00', '23:00', 15, 1, 4.30);
INSERT INTO restaurant VALUES (restaurant_seq.NEXTVAL, 1014, 106, 'Campus Bites', 'Budget Meals', '08:00', '22:30', 16, 1, 4.20);

-- Menu categories
INSERT INTO menu_category VALUES (menu_category_seq.NEXTVAL, 'Burgers', 'Chicken, beef, and student budget burgers');
INSERT INTO menu_category VALUES (menu_category_seq.NEXTVAL, 'Biryani and Rice', 'Rice meals and biryani boxes');
INSERT INTO menu_category VALUES (menu_category_seq.NEXTVAL, 'Pizza', 'Personal and family pizza choices');
INSERT INTO menu_category VALUES (menu_category_seq.NEXTVAL, 'Healthy Bowls', 'Balanced meals with nutrition-friendly options');
INSERT INTO menu_category VALUES (menu_category_seq.NEXTVAL, 'Desserts', 'Cakes, brownies, and sweet boxes');
INSERT INTO menu_category VALUES (menu_category_seq.NEXTVAL, 'Drinks', 'Cold and hot beverages');
INSERT INTO menu_category VALUES (menu_category_seq.NEXTVAL, 'Fast Snacks', 'Wraps, fries, sandwiches, and rolls');
INSERT INTO menu_category VALUES (menu_category_seq.NEXTVAL, 'Pakistani BBQ', 'Kabab, tikka, boti, and paratha items');

-- Menu items
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 301, 202, 'Chicken Biryani Box', 450, 18, 0, 'HOT', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 301, 201, 'Crunch Zinger Burger', 520, 16, 0, 'MEDIUM', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 301, 206, 'Mint Raita Cup', 120, 3, 1, 'MILD', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 302, 204, 'Quinoa Chicken Bowl', 650, 15, 0, 'MILD', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 302, 207, 'Grilled Veg Wrap', 380, 12, 1, 'MILD', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 302, 206, 'Fresh Lime Cooler', 150, 4, 1, 'NONE', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 303, 203, 'Chicken Fajita Pizza', 1250, 24, 0, 'MEDIUM', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 303, 203, 'Pepperoni Max Pizza', 1450, 26, 0, 'HOT', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 303, 205, 'Choco Lava Cup', 300, 8, 1, 'NONE', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 304, 208, 'Seekh Kabab Roll', 420, 14, 0, 'HOT', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 304, 208, 'Malai Boti Plate', 1100, 28, 0, 'MILD', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 304, 207, 'Tandoori Paratha', 80, 5, 1, 'NONE', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 305, 205, 'Lotus Cheesecake Slice', 550, 10, 1, 'NONE', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 305, 205, 'Brownie Box', 700, 12, 1, 'NONE', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 305, 206, 'Iced Coffee', 300, 5, 1, 'NONE', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 306, 207, 'Club Sandwich', 430, 12, 0, 'MILD', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 306, 207, 'Loaded Student Fries', 250, 10, 1, 'MEDIUM', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 306, 201, 'Budget Chicken Burger', 300, 10, 0, 'MILD', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 306, 206, 'Karak Chai', 90, 5, 1, 'NONE', 1);
INSERT INTO menu_item VALUES (menu_item_seq.NEXTVAL, 306, 208, 'Half Chicken Karahi', 1200, 32, 0, 'HOT', 1);

-- Riders
INSERT INTO rider VALUES (rider_seq.NEXTVAL, 'Noman Jutt', '03112220001', 'BIKE', 101, 4.60, 'BUSY', TO_DATE('2026-01-15', 'YYYY-MM-DD'));
INSERT INTO rider VALUES (rider_seq.NEXTVAL, 'Awais Gill', '03112220002', 'BIKE', 102, 4.40, 'BUSY', TO_DATE('2026-01-18', 'YYYY-MM-DD'));
INSERT INTO rider VALUES (rider_seq.NEXTVAL, 'Rehan Akhtar', '03112220003', 'CYCLE', 103, 4.20, 'BUSY', TO_DATE('2026-01-20', 'YYYY-MM-DD'));
INSERT INTO rider VALUES (rider_seq.NEXTVAL, 'Shahzaib Mir', '03112220004', 'BIKE', 104, 4.70, 'AVAILABLE', TO_DATE('2026-01-22', 'YYYY-MM-DD'));
INSERT INTO rider VALUES (rider_seq.NEXTVAL, 'Taimoor Shah', '03112220005', 'CAR', 105, 4.10, 'BUSY', TO_DATE('2026-01-25', 'YYYY-MM-DD'));
INSERT INTO rider VALUES (rider_seq.NEXTVAL, 'Ali Rauf', '03112220006', 'BIKE', 106, 4.50, 'AVAILABLE', TO_DATE('2026-01-28', 'YYYY-MM-DD'));
INSERT INTO rider VALUES (rider_seq.NEXTVAL, 'Sameer Qureshi', '03112220007', 'BIKE', 107, 4.30, 'AVAILABLE', TO_DATE('2026-02-01', 'YYYY-MM-DD'));
INSERT INTO rider VALUES (rider_seq.NEXTVAL, 'Hassan Waqas', '03112220008', 'BIKE', 108, 4.00, 'OFFLINE', TO_DATE('2026-02-02', 'YYYY-MM-DD'));

-- Coupons
INSERT INTO coupon VALUES (coupon_seq.NEXTVAL, 'WELCOME100', 'Flat 100 discount for new users', 'FLAT', 100, 500, TO_DATE('2026-04-01', 'YYYY-MM-DD'), TO_DATE('2026-06-30', 'YYYY-MM-DD'), 500, 1);
INSERT INTO coupon VALUES (coupon_seq.NEXTVAL, 'RUSH200', 'Rush hour discount up to 200', 'FLAT', 200, 1000, TO_DATE('2026-05-01', 'YYYY-MM-DD'), TO_DATE('2026-05-31', 'YYYY-MM-DD'), 300, 1);
INSERT INTO coupon VALUES (coupon_seq.NEXTVAL, 'GOLD10', 'Gold members get 10 percent off', 'PERCENT', 10, 900, TO_DATE('2026-04-15', 'YYYY-MM-DD'), TO_DATE('2026-07-15', 'YYYY-MM-DD'), 250, 1);
INSERT INTO coupon VALUES (coupon_seq.NEXTVAL, 'STUDENT50', 'Student snack discount', 'FLAT', 50, 400, TO_DATE('2026-05-01', 'YYYY-MM-DD'), TO_DATE('2026-08-31', 'YYYY-MM-DD'), 1000, 1);
INSERT INTO coupon VALUES (coupon_seq.NEXTVAL, 'SWEET125', 'Dessert lover flat discount', 'FLAT', 125, 800, TO_DATE('2026-05-01', 'YYYY-MM-DD'), TO_DATE('2026-06-15', 'YYYY-MM-DD'), 200, 1);
INSERT INTO coupon VALUES (coupon_seq.NEXTVAL, 'HEALTH80', 'Healthy meal promotion', 'FLAT', 80, 650, TO_DATE('2026-04-20', 'YYYY-MM-DD'), TO_DATE('2026-06-20', 'YYYY-MM-DD'), 150, 1);

-- Orders
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1001, 301, 501, 101, TO_DATE('2026-05-01 12:15', 'YYYY-MM-DD HH24:MI'), 'House 14, Civil Lines, Faisalabad', 'DELIVERED', 970, 120, 100, 990, 35, TO_DATE('2026-05-01 12:49', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1002, 303, 502, 102, TO_DATE('2026-05-01 13:05', 'YYYY-MM-DD HH24:MI'), 'Street 8, Madina Town, Faisalabad', 'DELIVERED', 1550, 150, 0, 1700, 40, TO_DATE('2026-05-01 13:50', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1003, 302, 503, 103, TO_DATE('2026-05-01 14:10', 'YYYY-MM-DD HH24:MI'), 'Block C, D Ground, Faisalabad', 'DELIVERED', 800, 100, 80, 820, 30, TO_DATE('2026-05-01 14:36', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1004, 304, 504, 104, TO_DATE('2026-05-01 18:20', 'YYYY-MM-DD HH24:MI'), 'Main Boulevard, Peoples Colony, Faisalabad', 'PICKED_UP', 1180, 130, 0, 1310, 45, NULL, 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1005, 305, 505, 105, TO_DATE('2026-05-01 19:05', 'YYYY-MM-DD HH24:MI'), 'Canal View Apartments, Canal Road', 'PREPARING', 850, 110, 50, 910, 35, NULL, 'UNPAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1006, 306, 506, 106, TO_DATE('2026-05-02 09:15', 'YYYY-MM-DD HH24:MI'), 'Hostel B, FAST Campus Area', 'DELIVERED', 820, 90, 0, 910, 25, TO_DATE('2026-05-02 09:38', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1007, 301, 501, 101, TO_DATE('2026-05-02 11:40', 'YYYY-MM-DD HH24:MI'), 'Flat 5, Civil Lines Market', 'CANCELLED', 570, 120, 0, 0, 35, NULL, 'REFUNDED');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1008, 303, 502, 102, TO_DATE('2026-05-02 12:30', 'YYYY-MM-DD HH24:MI'), 'Madina Town Commercial Area', 'ACCEPTED', 1450, 150, 150, 1450, 40, NULL, 'UNPAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1009, 304, 504, 104, TO_DATE('2026-05-02 20:10', 'YYYY-MM-DD HH24:MI'), 'Peoples Colony No. 2', 'DELIVERED', 1180, 130, 130, 1180, 45, TO_DATE('2026-05-02 21:00', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1010, 302, 503, 103, TO_DATE('2026-05-03 10:05', 'YYYY-MM-DD HH24:MI'), 'D Ground near Food Street', 'PENDING', 1030, 100, 0, 1130, 30, NULL, 'UNPAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1011, 306, 506, 106, TO_DATE('2026-05-03 12:00', 'YYYY-MM-DD HH24:MI'), 'FAST Campus Faculty Block', 'DELIVERED', 550, 90, 0, 640, 25, TO_DATE('2026-05-03 12:24', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1012, 305, 505, 105, TO_DATE('2026-05-03 15:45', 'YYYY-MM-DD HH24:MI'), 'Canal Road Executive Homes', 'DELIVERED', 1000, 110, 100, 1010, 35, TO_DATE('2026-05-03 16:18', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1001, 304, 507, 107, TO_DATE('2026-05-04 13:25', 'YYYY-MM-DD HH24:MI'), 'Susan Road Office Block', 'DELIVERED', 920, 140, 0, 1060, 45, TO_DATE('2026-05-04 14:05', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1002, 301, 508, 108, TO_DATE('2026-05-04 21:10', 'YYYY-MM-DD HH24:MI'), 'Clock Tower Food Street', 'DELIVERED', 1090, 160, 109, 1141, 50, TO_DATE('2026-05-04 22:00', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1003, 306, 506, 106, TO_DATE('2026-05-05 11:15', 'YYYY-MM-DD HH24:MI'), 'FAST Campus Area Gate 2', 'PREPARING', 1290, 90, 0, 1380, 25, NULL, 'UNPAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1004, 303, 502, 102, TO_DATE('2026-05-05 18:30', 'YYYY-MM-DD HH24:MI'), 'Madina Town Family Park', 'DELIVERED', 1750, 150, 200, 1700, 40, TO_DATE('2026-05-05 19:22', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1005, 302, 503, 103, TO_DATE('2026-05-05 19:05', 'YYYY-MM-DD HH24:MI'), 'D Ground Office Plaza', 'PICKED_UP', 1180, 100, 100, 1180, 30, NULL, 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1006, 304, 504, 104, TO_DATE('2026-05-06 20:15', 'YYYY-MM-DD HH24:MI'), 'Peoples Colony Commercial Market', 'DELIVERED', 1600, 130, 0, 1730, 45, TO_DATE('2026-05-06 21:02', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1007, 305, 505, 105, TO_DATE('2026-05-06 22:05', 'YYYY-MM-DD HH24:MI'), 'Canal Road Service Lane', 'ACCEPTED', 550, 110, 0, 660, 35, NULL, 'UNPAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1008, 301, 501, 101, TO_DATE('2026-05-07 13:35', 'YYYY-MM-DD HH24:MI'), 'Civil Lines Business Center', 'DELIVERED', 1090, 120, 0, 1210, 35, TO_DATE('2026-05-07 14:02', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1009, 303, 502, 102, TO_DATE('2026-05-07 19:45', 'YYYY-MM-DD HH24:MI'), 'Madina Town Main Road', 'DELIVERED', 2500, 150, 250, 2400, 40, TO_DATE('2026-05-07 20:34', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1010, 302, 503, 103, TO_DATE('2026-05-08 09:40', 'YYYY-MM-DD HH24:MI'), 'D Ground near Food Street', 'DELIVERED', 1030, 100, 0, 1130, 30, TO_DATE('2026-05-08 10:07', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1011, 306, 506, 106, TO_DATE('2026-05-08 12:15', 'YYYY-MM-DD HH24:MI'), 'FAST Campus Faculty Block', 'CANCELLED', 390, 90, 0, 0, 25, NULL, 'FAILED');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1012, 304, 507, 107, TO_DATE('2026-05-08 20:20', 'YYYY-MM-DD HH24:MI'), 'Susan Road Residential Lane', 'DELIVERED', 1180, 140, 0, 1320, 45, TO_DATE('2026-05-08 21:10', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1001, 305, 505, 105, TO_DATE('2026-05-09 16:05', 'YYYY-MM-DD HH24:MI'), 'Canal Road Executive Homes', 'DELIVERED', 1250, 110, 125, 1235, 35, TO_DATE('2026-05-09 16:36', 'YYYY-MM-DD HH24:MI'), 'PAID');
INSERT INTO customer_order VALUES (customer_order_seq.NEXTVAL, 1002, 306, 508, 108, TO_DATE('2026-05-09 18:55', 'YYYY-MM-DD HH24:MI'), 'Clock Tower Food Street', 'PENDING', 730, 160, 0, 890, 50, NULL, 'UNPAID');

-- Order items: composite primary key table and M:N bridge between orders and menu items
INSERT INTO order_item VALUES (7001, 401, 1, 450, 'Extra spicy');
INSERT INTO order_item VALUES (7001, 402, 1, 520, NULL);
INSERT INTO order_item VALUES (7002, 407, 1, 1250, NULL);
INSERT INTO order_item VALUES (7002, 409, 1, 300, 'Warm dessert');
INSERT INTO order_item VALUES (7003, 404, 1, 650, 'No onion');
INSERT INTO order_item VALUES (7003, 406, 1, 150, NULL);
INSERT INTO order_item VALUES (7004, 411, 1, 1100, NULL);
INSERT INTO order_item VALUES (7004, 412, 1, 80, NULL);
INSERT INTO order_item VALUES (7005, 413, 1, 550, NULL);
INSERT INTO order_item VALUES (7005, 415, 1, 300, 'Less ice');
INSERT INTO order_item VALUES (7006, 416, 1, 430, NULL);
INSERT INTO order_item VALUES (7006, 418, 1, 300, NULL);
INSERT INTO order_item VALUES (7006, 419, 1, 90, NULL);
INSERT INTO order_item VALUES (7007, 401, 1, 450, NULL);
INSERT INTO order_item VALUES (7007, 403, 1, 120, NULL);
INSERT INTO order_item VALUES (7008, 408, 1, 1450, NULL);
INSERT INTO order_item VALUES (7009, 411, 1, 1100, NULL);
INSERT INTO order_item VALUES (7009, 412, 1, 80, NULL);
INSERT INTO order_item VALUES (7010, 404, 1, 650, NULL);
INSERT INTO order_item VALUES (7010, 405, 1, 380, NULL);
INSERT INTO order_item VALUES (7011, 418, 1, 300, NULL);
INSERT INTO order_item VALUES (7011, 417, 1, 250, NULL);
INSERT INTO order_item VALUES (7012, 414, 1, 700, NULL);
INSERT INTO order_item VALUES (7012, 415, 1, 300, NULL);
INSERT INTO order_item VALUES (7013, 410, 2, 420, 'Separate chutney');
INSERT INTO order_item VALUES (7013, 412, 1, 80, NULL);
INSERT INTO order_item VALUES (7014, 401, 1, 450, NULL);
INSERT INTO order_item VALUES (7014, 402, 1, 520, NULL);
INSERT INTO order_item VALUES (7014, 403, 1, 120, NULL);
INSERT INTO order_item VALUES (7015, 420, 1, 1200, NULL);
INSERT INTO order_item VALUES (7015, 419, 1, 90, NULL);
INSERT INTO order_item VALUES (7016, 408, 1, 1450, NULL);
INSERT INTO order_item VALUES (7016, 409, 1, 300, NULL);
INSERT INTO order_item VALUES (7017, 404, 1, 650, NULL);
INSERT INTO order_item VALUES (7017, 405, 1, 380, NULL);
INSERT INTO order_item VALUES (7017, 406, 1, 150, NULL);
INSERT INTO order_item VALUES (7018, 411, 1, 1100, NULL);
INSERT INTO order_item VALUES (7018, 410, 1, 420, NULL);
INSERT INTO order_item VALUES (7018, 412, 1, 80, NULL);
INSERT INTO order_item VALUES (7019, 413, 1, 550, NULL);
INSERT INTO order_item VALUES (7020, 401, 1, 450, NULL);
INSERT INTO order_item VALUES (7020, 402, 1, 520, NULL);
INSERT INTO order_item VALUES (7020, 403, 1, 120, NULL);
INSERT INTO order_item VALUES (7021, 407, 2, 1250, 'Thin crust');
INSERT INTO order_item VALUES (7022, 404, 1, 650, NULL);
INSERT INTO order_item VALUES (7022, 405, 1, 380, NULL);
INSERT INTO order_item VALUES (7023, 418, 1, 300, NULL);
INSERT INTO order_item VALUES (7023, 419, 1, 90, NULL);
INSERT INTO order_item VALUES (7024, 411, 1, 1100, NULL);
INSERT INTO order_item VALUES (7024, 412, 1, 80, NULL);
INSERT INTO order_item VALUES (7025, 414, 1, 700, NULL);
INSERT INTO order_item VALUES (7025, 413, 1, 550, NULL);
INSERT INTO order_item VALUES (7026, 416, 1, 430, NULL);
INSERT INTO order_item VALUES (7026, 418, 1, 300, NULL);

-- Payments
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7001, 'WALLET', 990, 'PAID', TO_DATE('2026-05-01 12:16', 'YYYY-MM-DD HH24:MI'), 'TXN-7001');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7002, 'CARD', 1700, 'PAID', TO_DATE('2026-05-01 13:06', 'YYYY-MM-DD HH24:MI'), 'TXN-7002');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7003, 'EASYPAISA', 820, 'PAID', TO_DATE('2026-05-01 14:11', 'YYYY-MM-DD HH24:MI'), 'TXN-7003');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7004, 'CASH', 1310, 'PAID', TO_DATE('2026-05-01 18:21', 'YYYY-MM-DD HH24:MI'), 'TXN-7004');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7005, 'CASH', 0, 'PENDING', NULL, 'TXN-7005');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7006, 'WALLET', 910, 'PAID', TO_DATE('2026-05-02 09:16', 'YYYY-MM-DD HH24:MI'), 'TXN-7006');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7007, 'CARD', 0, 'REFUNDED', TO_DATE('2026-05-02 11:45', 'YYYY-MM-DD HH24:MI'), 'TXN-7007');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7008, 'CASH', 0, 'PENDING', NULL, 'TXN-7008');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7009, 'WALLET', 1180, 'PAID', TO_DATE('2026-05-02 20:12', 'YYYY-MM-DD HH24:MI'), 'TXN-7009');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7010, 'CASH', 0, 'PENDING', NULL, 'TXN-7010');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7011, 'WALLET', 640, 'PAID', TO_DATE('2026-05-03 12:01', 'YYYY-MM-DD HH24:MI'), 'TXN-7011');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7012, 'CARD', 1010, 'PAID', TO_DATE('2026-05-03 15:46', 'YYYY-MM-DD HH24:MI'), 'TXN-7012');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7013, 'CASH', 1060, 'PAID', TO_DATE('2026-05-04 13:26', 'YYYY-MM-DD HH24:MI'), 'TXN-7013');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7014, 'CARD', 1141, 'PAID', TO_DATE('2026-05-04 21:12', 'YYYY-MM-DD HH24:MI'), 'TXN-7014');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7015, 'CASH', 0, 'PENDING', NULL, 'TXN-7015');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7016, 'WALLET', 1700, 'PAID', TO_DATE('2026-05-05 18:32', 'YYYY-MM-DD HH24:MI'), 'TXN-7016');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7017, 'EASYPAISA', 1180, 'PAID', TO_DATE('2026-05-05 19:06', 'YYYY-MM-DD HH24:MI'), 'TXN-7017');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7018, 'CARD', 1730, 'PAID', TO_DATE('2026-05-06 20:16', 'YYYY-MM-DD HH24:MI'), 'TXN-7018');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7019, 'CASH', 0, 'PENDING', NULL, 'TXN-7019');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7020, 'WALLET', 1210, 'PAID', TO_DATE('2026-05-07 13:37', 'YYYY-MM-DD HH24:MI'), 'TXN-7020');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7021, 'CARD', 2400, 'PAID', TO_DATE('2026-05-07 19:46', 'YYYY-MM-DD HH24:MI'), 'TXN-7021');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7022, 'EASYPAISA', 1130, 'PAID', TO_DATE('2026-05-08 09:41', 'YYYY-MM-DD HH24:MI'), 'TXN-7022');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7023, 'CARD', 0, 'FAILED', NULL, 'TXN-7023');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7024, 'CASH', 1320, 'PAID', TO_DATE('2026-05-08 20:22', 'YYYY-MM-DD HH24:MI'), 'TXN-7024');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7025, 'WALLET', 1235, 'PAID', TO_DATE('2026-05-09 16:06', 'YYYY-MM-DD HH24:MI'), 'TXN-7025');
INSERT INTO payment VALUES (payment_seq.NEXTVAL, 7026, 'CASH', 0, 'PENDING', NULL, 'TXN-7026');

-- Coupon usage bridge
INSERT INTO order_coupon VALUES (7001, 601, 100);
INSERT INTO order_coupon VALUES (7003, 606, 80);
INSERT INTO order_coupon VALUES (7005, 604, 50);
INSERT INTO order_coupon VALUES (7008, 602, 150);
INSERT INTO order_coupon VALUES (7009, 602, 130);
INSERT INTO order_coupon VALUES (7012, 601, 100);
INSERT INTO order_coupon VALUES (7014, 603, 109);
INSERT INTO order_coupon VALUES (7016, 602, 200);
INSERT INTO order_coupon VALUES (7017, 601, 100);
INSERT INTO order_coupon VALUES (7021, 603, 250);
INSERT INTO order_coupon VALUES (7025, 605, 125);

-- Ratings
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7001, 1001, 301, 501, 5, 5, 'Hot food and fast rider.', TO_DATE('2026-05-01', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7002, 1002, 303, 502, 4, 4, 'Pizza was good but delivery was slightly late.', TO_DATE('2026-05-01', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7003, 1003, 302, 503, 5, 4, 'Fresh bowl and neat packaging.', TO_DATE('2026-05-01', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7006, 1006, 306, 506, 4, 5, 'Perfect for campus lunch.', TO_DATE('2026-05-02', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7009, 1009, 304, 504, 5, 4, 'BBQ taste was excellent.', TO_DATE('2026-05-02', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7011, 1011, 306, 506, 4, 4, 'Budget meal was worth it.', TO_DATE('2026-05-03', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7012, 1012, 305, 505, 5, 4, 'Brownie box was rich and fresh.', TO_DATE('2026-05-03', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7016, 1004, 303, 502, 4, 3, 'Great pizza, delivery crossed promised time.', TO_DATE('2026-05-05', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7018, 1006, 304, 504, 5, 5, 'Very good family dinner.', TO_DATE('2026-05-06', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7020, 1008, 301, 501, 5, 5, 'Spicy and delivered warm.', TO_DATE('2026-05-07', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7022, 1010, 302, 503, 4, 5, 'Healthy meal arrived quickly.', TO_DATE('2026-05-08', 'YYYY-MM-DD'));
INSERT INTO rating VALUES (rating_seq.NEXTVAL, 7025, 1001, 305, 505, 5, 4, 'Dessert quality was premium.', TO_DATE('2026-05-09', 'YYYY-MM-DD'));

-- Initial status history rows
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7001, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-01 12:49', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7002, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-01 13:50', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7003, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-01 14:36', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7004, NULL, 'PICKED_UP', 'seed_data', TO_DATE('2026-05-01 18:55', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7005, NULL, 'PREPARING', 'seed_data', TO_DATE('2026-05-01 19:15', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7006, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-02 09:38', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7007, NULL, 'CANCELLED', 'seed_data', TO_DATE('2026-05-02 11:46', 'YYYY-MM-DD HH24:MI'), 'Customer cancelled before pickup');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7008, NULL, 'ACCEPTED', 'seed_data', TO_DATE('2026-05-02 12:35', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7009, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-02 21:00', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7010, NULL, 'PENDING', 'seed_data', TO_DATE('2026-05-03 10:05', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7011, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-03 12:24', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7012, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-03 16:18', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7013, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-04 14:05', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7014, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-04 22:00', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7015, NULL, 'PREPARING', 'seed_data', TO_DATE('2026-05-05 11:30', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7016, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-05 19:22', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7017, NULL, 'PICKED_UP', 'seed_data', TO_DATE('2026-05-05 19:28', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7018, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-06 21:02', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7019, NULL, 'ACCEPTED', 'seed_data', TO_DATE('2026-05-06 22:10', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7020, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-07 14:02', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7021, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-07 20:34', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7022, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-08 10:07', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7023, NULL, 'CANCELLED', 'seed_data', TO_DATE('2026-05-08 12:20', 'YYYY-MM-DD HH24:MI'), 'Payment failed and order cancelled');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7024, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-08 21:10', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7025, NULL, 'DELIVERED', 'seed_data', TO_DATE('2026-05-09 16:36', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');
INSERT INTO order_status_history VALUES (status_history_seq.NEXTVAL, 7026, NULL, 'PENDING', 'seed_data', TO_DATE('2026-05-09 18:55', 'YYYY-MM-DD HH24:MI'), 'Initial imported order state');

COMMIT;