insert into 'wrcswindon298-r'.purchase_orderdata (Id, PurchaseOrder)
values  (1, 'Order 123'),
    (2, 'Order 124'),
    (3, 'Order 125');

insert into 'wrcswindon298-r'.purchase_boxdata (Id, BoxNo, PurchaseOrderId)
values  (2, 'B 001', 3),
    (3, 'B 002', 2),
    (4, 'B 003', 1),
    (5, 'B 011', 3),
    (6, 'B 012', 2),
    (7, 'B 013', 1);

insert into 'wrcswindon298-r'.purchase_watermeterdata (Id, SerialNo, WaterMeterData_id, PurchaseBoxId)
values  (2, 'SN-123456-1', null, 2),
        (3, 'SN_123456-2', null, 2),
        (4, 'SN_123456-3', null, 2),
        (5, 'SN_123456-4', null, 2),
        (6, 'SN_132456-5', null, 2),
        (7, 'SN_123456-6', null, 2),
        (8, 'SN-123457-1', null, 5),
        (9, 'SN_123457-2', null, 5),
        (10, 'SN_123457-3', null, 5),
        (11, 'SN_123457-4', null, 5),
        (12, 'SN_132457-5', null, 5),
        (13, 'SN_123457-6', null, 5),
        (14, 'SN-1234-1', null, 2),
        (15, 'SN_1234-2', null, 3),
        (16, 'SN_1234-3', null, 4),
        (17, 'SN_1234-4', null, 5),
        (18, 'SN_1324-5', null, 6),
        (19, 'SN_1234-6', null, 7);