INSERT INTO item_barcodes (item_id, barcode, type, is_primary)
SELECT 
    i.id,
    CONCAT(
        UPPER(i.sku),
        '-',
        INSERT(
            INSERT(
                LPAD(i.id, 9, '0'),
                4, 0, '-'
            ),
            8, 0, '-'
        )
    ) AS barcode,
    'CODE128',
    1
FROM items i;