query insert master_data

INSERT into scora.master_data
(
    produk_id,
    master_serial,
    master_unique,
    active_date,
    deactivate_date,
    flg_status,
    flg_scan,
    created_at,
    master_key
)
SELECT
    -99 AS produk_id,                     -- nilai tetap
    t.serial AS master_serial,          -- dari temp_master_data
    t.unique_code AS master_unique,     -- dari temp_master_data
    NULL AS active_date,     -- NULL atau isi sesuai kebutuhan
    NULL AS deactivate_date, -- NULL atau isi sesuai kebutuhan
    'N' AS flg_status,                   -- nilai default
    'N' AS flg_scan,                     -- nilai default
    NOW() AS created_at,                -- waktu sekarang
    t.unique_code AS master_key                    -- nilai default
FROM scora.temp_master_data t;