START TRANSACTION;

-- =========================================================
-- TEST SEED for ISDE 2026 schema:
-- - products: test catalog items for all measure types
-- - variants: one standard variant per product
-- - isde2026_subsidy_measures: normalized measures with biobased and purchase_year examples
-- - isde2026_subsidy_measure_mappings: maps (product_id, optional variant_id) -> measure_id
--
-- Assumptions:
-- - MySQL / MariaDB with ON DUPLICATE KEY UPDATE support.
-- - products.id and variants.id are integer PKs (updates on id conflict).
-- - report_code on measures is UNIQUE (updates on report_code conflict).
-- - mappings has UNIQUE on (product_id, variant_id) or similar (updates on conflict).
-- - vat_id = 2 (21% VAT).
-- - product_unit_id = 1 ('stuks'), 3 ('m²').
-- - size_range_id = NULL.
-- - group_id = 9 for all products as per request.
-- - added_product_id = NULL.
-- - default_delivery_period_type = 0.
-- - ean_code = NULL.
-- - stock_type = NULL.
-- - default_quantity = 1.00.
-- - purchase_price and sales_price example values.
-- - order_note = description (corrected from quotation_note).
-- - deleted_at = NULL.
-- - created_at not updated on duplicate, updated_at = NOW().
--
-- Notes:
-- - IDs in high ranges (990000+) to reduce collision risk.
-- - Use INSERT ... ON DUPLICATE KEY UPDATE for upsert (insert or update).
-- - For warmtepomp, examples covering key ranges/labels/powers.
-- - biobased TRUE on some isolation examples.
-- - purchase_year 2024 on some warmtepomp examples.
-- =========================================================

-- =========================================================
-- 0) PRODUCTS
-- =========================================================
INSERT INTO products (id, name, code, vat_id, product_unit_id, size_range_id, sales_price, purchase_price, created_at, updated_at, deleted_at, group_id, order_note, added_product_id, default_delivery_period_type, ean_code, stock_type, default_quantity)
VALUES
-- Isolation
(990001, 'ISDE26 - Dakisolatie', 'ISDE26_DAK', 2, 3, NULL, 16.00, 10.00, NOW(), NOW(), NULL, 9, '<p>Dakisolatie Rd ≥ 3,5 m2 K/W</p>', NULL, 0, NULL, NULL, 1.00),
(990002, 'ISDE26 - Zolder/vlieringisolatie', 'ISDE26_ZOLDER', 2, 3, NULL, 4.00, 3.00, NOW(), NOW(), NULL, 9, '<p>Zolder-of vlieringisolatie Rd ≥ 3,5 m2 K/W</p>', NULL, 0, NULL, NULL, 1.00),
(990003, 'ISDE26 - Gevelisolatie', 'ISDE26_GEVEL', 2, 3, NULL, 19.00, 15.00, NOW(), NOW(), NULL, 9, '<p>Binnen-of buitengevelisolatie Rd ≥ 3,5 m2 K/W</p>', NULL, 0, NULL, NULL, 1.00),
(990004, 'ISDE26 - Spouwmuurisolatie', 'ISDE26_SPOUW', 2, 3, NULL, 5.00, 4.00, NOW(), NOW(), NULL, 9, '<p>Spouwmuurisolatie Rd ≥ 1,1 m2 K/W</p>', NULL, 0, NULL, NULL, 1.00),
(990005, 'ISDE26 - Vloerisolatie', 'ISDE26_VLOER', 2, 3, NULL, 5.50, 4.50, NOW(), NOW(), NULL, 9, '<p>Vloerisolatie Rd ≥ 3,5 m2 K/W</p>', NULL, 0, NULL, NULL, 1.00),
(990006, 'ISDE26 - Bodemisolatie', 'ISDE26_BODEM', 2, 3, NULL, 3.00, 2.50, NOW(), NOW(), NULL, 9, '<p>Bodemisolatie Rd ≥ 3,5 m2 K/W</p>', NULL, 0, NULL, NULL, 1.00),
-- Glazing / Panels / Doors
(990007, 'ISDE26 - HR++ glas', 'ISDE26_HRPP', 2, 3, NULL, 25.00, 20.00, NOW(), NOW(), NULL, 9, '<p>HR++ glas U ≤ 1,2 W/m2K</p>', NULL, 0, NULL, NULL, 1.00),
(990008, 'ISDE26 - Triple glas', 'ISDE26_TRIPLE', 2, 3, NULL, 111.00, 90.00, NOW(), NOW(), NULL, 9, '<p>Triple glas U ≤ 0,7 W/m2K</p>', NULL, 0, NULL, NULL, 1.00),
(990009, 'ISDE26 - Isolerende panelen U≤1.2', 'ISDE26_PANEL12', 2, 3, NULL, 10.00, 8.00, NOW(), NOW(), NULL, 9, '<p>Isolerende panelen U ≤ 1,2 W/m2K</p>', NULL, 0, NULL, NULL, 1.00),
(990010, 'ISDE26 - Isolerende panelen U≤0.7', 'ISDE26_PANEL07', 2, 3, NULL, 45.00, 36.00, NOW(), NOW(), NULL, 9, '<p>Isolerende panelen U ≤ 0,7 W/m2K</p>', NULL, 0, NULL, NULL, 1.00),
(990011, 'ISDE26 - Isolerende deur U≤1.5', 'ISDE26_DEUR15', 2, 1, NULL, 25.00, 20.00, NOW(), NOW(), NULL, 9, '<p>Isolerende deuren U ≤ 1,5 W/m2K</p>', NULL, 0, NULL, NULL, 1.00),
(990012, 'ISDE26 - Isolerende deur U≤1.0', 'ISDE26_DEUR10', 2, 1, NULL, 111.00, 90.00, NOW(), NOW(), NULL, 9, '<p>Isolerende deuren U ≤ 1,0 W/m2K</p>', NULL, 0, NULL, NULL, 1.00),
-- Zonneboiler
(990020, 'ISDE26 - Zonneboiler ≤5m²', 'ISDE26_ZB_LTE5', 2, 3, NULL, 1750.00, 1400.00, NOW(), NOW(), NULL, 9, '<p>Zonneboiler ≤ 5 m2</p>', NULL, 0, NULL, NULL, 1.00),
(990021, 'ISDE26 - Zonneboiler >5≤10m²', 'ISDE26_ZB_GT5', 2, 3, NULL, 2050.00, 1640.00, NOW(), NOW(), NULL, 9, '<p>Zonneboiler > 5 en ≤ 10 m2</p>', NULL, 0, NULL, NULL, 1.00),
(990022, 'ISDE26 - Zonneboilercombi ≤5m²', 'ISDE26_ZBC_LTE5', 2, 3, NULL, 1950.00, 1560.00, NOW(), NOW(), NULL, 9, '<p>Zonneboilercombi ≤ 5 m2</p>', NULL, 0, NULL, NULL, 1.00),
(990023, 'ISDE26 - Zonneboilercombi >5≤10m²', 'ISDE26_ZBC_GT5', 2, 3, NULL, 1950.00, 1560.00, NOW(), NOW(), NULL, 9, '<p>Zonneboilercombi > 5 en ≤ 10 m2</p>', NULL, 0, NULL, NULL, 1.00),
-- Warmtenet & Kook
(990030, 'ISDE26 - Aansluiting warmtenet', 'ISDE26_WARMTE', 2, 1, NULL, 3775.00, 3000.00, NOW(), NOW(), NULL, 9, '<p>Aansluiting op een warmtenet</p>', NULL, 0, NULL, NULL, 1.00),
(990031, 'ISDE26 - Elektrische kookvoorziening', 'ISDE26_KOKEN', 2, 1, NULL, 400.00, 320.00, NOW(), NOW(), NULL, 9, '<p>Elektrische kookvoorziening</p>', NULL, 0, NULL, NULL, 1.00),
-- Warmtepomp examples
(990100, 'ISDE26 - Lucht-water <1kW A+++', 'ISDE26_LW_LT1_A3', 2, 1, NULL, 950.00, 760.00, NOW(), NOW(), NULL, 9, '<p>Lucht-water < 1 kW A+++</p>', NULL, 0, NULL, NULL, 1.00),
(990101, 'ISDE26 - Lucht-water 1-70kW A+++', 'ISDE26_LW_1_70_A3', 2, 1, NULL, 1450.00, 1160.00, NOW(), NOW(), NULL, 9, '<p>Lucht-water ≥1 ≤70 kW A+++</p>', NULL, 0, NULL, NULL, 1.00),
(990102, 'ISDE26 - Lucht-water 71-400kW ANY', 'ISDE26_LW_71_400_ANY', 2, 1, NULL, 12150.00, 9720.00, NOW(), NOW(), NULL, 9, '<p>Lucht-water ≥71 ≤400 kW</p>', NULL, 0, NULL, NULL, 1.00),
(990110, 'ISDE26 - Lucht-water <1kW A++', 'ISDE26_LW_LT1_A2', 2, 1, NULL, 950.00, 760.00, NOW(), NOW(), NULL, 9, '<p>Lucht-water < 1 kW A++</p>', NULL, 0, NULL, NULL, 1.00),
(990111, 'ISDE26 - Lucht-water 1-70kW A++', 'ISDE26_LW_1_70_A2', 2, 1, NULL, 1250.00, 1000.00, NOW(), NOW(), NULL, 9, '<p>Lucht-water ≥1 ≤70 kW A++</p>', NULL, 0, NULL, NULL, 1.00),
(990120, 'ISDE26 - Lucht-water <1kW A+', 'ISDE26_LW_LT1_A1', 2, 1, NULL, 725.00, 580.00, NOW(), NOW(), NULL, 9, '<p>Lucht-water < 1 kW A+</p>', NULL, 0, NULL, NULL, 1.00),
(990130, 'ISDE26 - Lucht-water <1kW A t/m G', 'ISDE26_LW_LT1_ATMG', 2, 1, NULL, 500.00, 400.00, NOW(), NOW(), NULL, 9, '<p>Lucht-water < 1 kW A t/m G</p>', NULL, 0, NULL, NULL, 1.00),
(990200, 'ISDE26 - Grond-water <1kW A+++', 'ISDE26_GW_LT1_A3', 2, 1, NULL, 950.00, 760.00, NOW(), NOW(), NULL, 9, '<p>Grond-water < 1 kW A+++</p>', NULL, 0, NULL, NULL, 1.00),
(990201, 'ISDE26 - Grond-water 1-10kW A+++', 'ISDE26_GW_1_10_A3', 2, 1, NULL, 4425.00, 3540.00, NOW(), NOW(), NULL, 9, '<p>Grond-water ≥1 <10 kW A+++</p>', NULL, 0, NULL, NULL, 1.00),
(990202, 'ISDE26 - Grond-water 10-70kW A+++', 'ISDE26_GW_10_70_A3', 2, 1, NULL, 4425.00, 3540.00, NOW(), NOW(), NULL, 9, '<p>Grond-water ≥10 ≤70 kW A+++</p>', NULL, 0, NULL, NULL, 1.00),
(990203, 'ISDE26 - Grond-water 71-400kW ANY', 'ISDE26_GW_71_400_ANY', 2, 1, NULL, 12900.00, 10320.00, NOW(), NOW(), NULL, 9, '<p>Grond-water ≥71 ≤400 kW</p>', NULL, 0, NULL, NULL, 1.00),
(990300, 'ISDE26 - Water-water <1kW A+++', 'ISDE26_WW_LT1_A3', 2, 1, NULL, 950.00, 760.00, NOW(), NOW(), NULL, 9, '<p>Water-water < 1 kW A+++</p>', NULL, 0, NULL, NULL, 1.00),
(990301, 'ISDE26 - Water-water 1-10kW A+++', 'ISDE26_WW_1_10_A3', 2, 1, NULL, 4425.00, 3540.00, NOW(), NOW(), NULL, 9, '<p>Water-water ≥1 <10 kW A+++</p>', NULL, 0, NULL, NULL, 1.00),
(990302, 'ISDE26 - Water-water 10-70kW A+++', 'ISDE26_WW_10_70_A3', 2, 1, NULL, 4425.00, 3540.00, NOW(), NOW(), NULL, 9, '<p>Water-water ≥10 ≤70 kW A+++</p>', NULL, 0, NULL, NULL, 1.00),
(990303, 'ISDE26 - Water-water 71-400kW ANY', 'ISDE26_WW_71_400_ANY', 2, 1, NULL, 12900.00, 10320.00, NOW(), NOW(), NULL, 9, '<p>Water-water ≥71 ≤400 kW</p>', NULL, 0, NULL, NULL, 1.00)
ON DUPLICATE KEY UPDATE
name = VALUES(name),
code = VALUES(code),
vat_id = VALUES(vat_id),
product_unit_id = VALUES(product_unit_id),
size_range_id = VALUES(size_range_id),
sales_price = VALUES(sales_price),
purchase_price = VALUES(purchase_price),
updated_at = NOW(),
deleted_at = VALUES(deleted_at),
group_id = VALUES(group_id),
order_note = VALUES(order_note),
added_product_id = VALUES(added_product_id),
default_delivery_period_type = VALUES(default_delivery_period_type),
ean_code = VALUES(ean_code),
stock_type = VALUES(stock_type),
default_quantity = VALUES(default_quantity);

-- =========================================================
-- 1) VARIANTS
-- =========================================================
INSERT INTO variants (id, product_id, name, sort_order, created_at, updated_at)
VALUES
(991001, 990001, 'Standaard', 1, NOW(), NOW()),
(991002, 990002, 'Standaard', 1, NOW(), NOW()),
(991003, 990003, 'Standaard', 1, NOW(), NOW()),
(991004, 990004, 'Standaard', 1, NOW(), NOW()),
(991005, 990005, 'Standaard', 1, NOW(), NOW()),
(991006, 990006, 'Standaard', 1, NOW(), NOW()),
(991007, 990007, 'Standaard', 1, NOW(), NOW()),
(991008, 990008, 'Standaard', 1, NOW(), NOW()),
(991009, 990009, 'Standaard', 1, NOW(), NOW()),
(991010, 990010, 'Standaard', 1, NOW(), NOW()),
(991011, 990011, 'Standaard', 1, NOW(), NOW()),
(991012, 990012, 'Standaard', 1, NOW(), NOW()),
(991020, 990020, 'Standaard', 1, NOW(), NOW()),
(991021, 990021, 'Standaard', 1, NOW(), NOW()),
(991022, 990022, 'Standaard', 1, NOW(), NOW()),
(991023, 990023, 'Standaard', 1, NOW(), NOW()),
(991030, 990030, 'Standaard', 1, NOW(), NOW()),
(991031, 990031, 'Standaard', 1, NOW(), NOW()),
(991100, 990100, 'Standaard', 1, NOW(), NOW()),
(991101, 990101, 'Standaard', 1, NOW(), NOW()),
(991102, 990102, 'Standaard', 1, NOW(), NOW()),
(991110, 990110, 'Standaard', 1, NOW(), NOW()),
(991111, 990111, 'Standaard', 1, NOW(), NOW()),
(991120, 990120, 'Standaard', 1, NOW(), NOW()),
(991130, 990130, 'Standaard', 1, NOW(), NOW()),
(991200, 990200, 'Standaard', 1, NOW(), NOW()),
(991201, 990201, 'Standaard', 1, NOW(), NOW()),
(991202, 990202, 'Standaard', 1, NOW(), NOW()),
(991203, 990203, 'Standaard', 1, NOW(), NOW()),
(991300, 990300, 'Standaard', 1, NOW(), NOW()),
(991301, 990301, 'Standaard', 1, NOW(), NOW()),
(991302, 990302, 'Standaard', 1, NOW(), NOW()),
(991303, 990303, 'Standaard', 1, NOW(), NOW())
ON DUPLICATE KEY UPDATE
product_id = VALUES(product_id),
name = VALUES(name),
sort_order = VALUES(sort_order),
updated_at = NOW();

-- =========================================================
-- 2) MEASURES
-- =========================================================
INSERT INTO isde2026_subsidy_measures (id, category, report_code, heat_pump_power, heat_pump_kind, energy_label_band, biobased, purchase_year, created_at, updated_at)
VALUES
(995001, 'Dakisolatie, Rd ≥ 3,5 m2 K/W', 'ISDE26_DAK', NULL, NULL, NULL, TRUE, NULL, NOW(), NOW()),
(995002, 'Zolder- of vlieringisolatie, Rd ≥ 3,5 m2 K/W', 'ISDE26_ZOLDER', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995003, 'Binnen-of buitengevelisolatie, Rd ≥ 3,5m2 K/W', 'ISDE26_GEVEL', NULL, NULL, NULL, TRUE, NULL, NOW(), NOW()),
(995004, 'Spouwmuurisolatie, Rd ≥ 1,1 m2 K/W', 'ISDE26_SPOUW', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995005, 'Vloerisolatie, Rd ≥ 3,5m2 K/W', 'ISDE26_VLOER', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995006, 'Bodemisolatie, Rd ≥ 3,5 m2 K/W', 'ISDE26_BODEM', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995007, 'HR++ glas, U ≤ 1,2 W/m2K', 'ISDE26_HRPP', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995008, 'Triple glas, U ≤ 0,7 W/m2K', 'ISDE26_TRIPLE', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995009, 'Isolerende panelen, U ≤ 1,2 W/m2K', 'ISDE26_PANEL12', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995010, 'Isolerende panelen, U ≤ 0,7 W/m2K', 'ISDE26_PANEL07', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995011, 'Isolerende deuren, U ≤ 1,5 W/m2K', 'ISDE26_DEUR15', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995012, 'Isolerende deuren, U ≤ 1,0 W/m2K', 'ISDE26_DEUR10', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995020, 'Zonneboiler ≤ 5 m2', 'ISDE26_ZB_LTE5', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995021, 'Zonneboiler > 5 en ≤ 10 m2', 'ISDE26_ZB_GT5', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995022, 'Zonneboilercombi ≤ 5 m2', 'ISDE26_ZBC_LTE5', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995023, 'Zonneboilercombi > 5 en ≤ 10 m2', 'ISDE26_ZBC_GT5', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995030, 'Aansluiting op een warmtenet', 'ISDE26_WARMTE', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995031, 'Elektrische kookvoorziening', 'ISDE26_KOKEN', NULL, NULL, NULL, FALSE, NULL, NOW(), NOW()),
(995100, 'Lucht-water < 1 kW', 'ISDE26_LW_LT1_A3', 0.50, 'Lucht-water', 'A+++', FALSE, 2024, NOW(), NOW()),
(995101, 'Lucht-water ≥ 1 kW en ≤ 70 kW', 'ISDE26_LW_1_70_A3', 5.00, 'Lucht-water', 'A+++', FALSE, NULL, NOW(), NOW()),
(995102, 'Lucht-water ≥ 71 kW en ≤ 400 kW', 'ISDE26_LW_71_400_ANY', 100.00, 'Lucht-water', NULL, FALSE, NULL, NOW(), NOW()),
(995110, 'Lucht-water < 1 kW', 'ISDE26_LW_LT1_A2', 0.50, 'Lucht-water', 'A++', FALSE, NULL, NOW(), NOW()),
(995111, 'Lucht-water ≥ 1 kW en ≤ 70 kW', 'ISDE26_LW_1_70_A2', 5.00, 'Lucht-water', 'A++', FALSE, 2024, NOW(), NOW()),
(995120, 'Lucht-water < 1 kW', 'ISDE26_LW_LT1_A1', 0.50, 'Lucht-water', 'A+', FALSE, NULL, NOW(), NOW()),
(995130, 'Lucht-water < 1 kW', 'ISDE26_LW_LT1_ATMG', 0.50, 'Lucht-water', 'A t/m G', FALSE, NULL, NOW(), NOW()),
(995200, 'Grond-water < 1 kW', 'ISDE26_GW_LT1_A3', 0.50, 'Grond-water', 'A+++', FALSE, NULL, NOW(), NOW()),
(995201, 'Grond-water ≥ 1 kW en < 10 kW', 'ISDE26_GW_1_10_A3', 5.00, 'Grond-water', 'A+++', FALSE, NULL, NOW(), NOW()),
(995202, 'Grond-water ≥ 10 kW en ≤ 70 kW', 'ISDE26_GW_10_70_A3', 20.00, 'Grond-water', 'A+++', FALSE, NULL, NOW(), NOW()),
(995203, 'Grond-water ≥ 71 kW en ≤ 400 kW', 'ISDE26_GW_71_400_ANY', 100.00, 'Grond-water', NULL, FALSE, NULL, NOW(), NOW()),
(995300, 'Water-water < 1 kW', 'ISDE26_WW_LT1_A3', 0.50, 'Water-water', 'A+++', FALSE, NULL, NOW(), NOW()),
(995301, 'Water-water ≥ 1 kW en < 10 kW', 'ISDE26_WW_1_10_A3', 5.00, 'Water-water', 'A+++', FALSE, NULL, NOW(), NOW()),
(995302, 'Water-water ≥ 10 kW en ≤ 70 kW', 'ISDE26_WW_10_70_A3', 20.00, 'Water-water', 'A+++', FALSE, NULL, NOW(), NOW()),
(995303, 'Water-water ≥ 71 kW en ≤ 400 kW', 'ISDE26_WW_71_400_ANY', 100.00, 'Water-water', NULL, FALSE, NULL, NOW(), NOW())
ON DUPLICATE KEY UPDATE
category = VALUES(category),
heat_pump_power = VALUES(heat_pump_power),
heat_pump_kind = VALUES(heat_pump_kind),
energy_label_band = VALUES(energy_label_band),
biobased = VALUES(biobased),
purchase_year = VALUES(purchase_year),
updated_at = NOW();

-- =========================================================
-- 3) MAPPINGS
-- =========================================================
INSERT INTO isde2026_subsidy_measure_mappings (product_id, variant_id, measure_id, report_code, created_at, updated_at, deleted_at)
VALUES
(990001, 991001, 995001, 'ISDE26_DAK', NOW(), NOW(), NULL),
(990002, 991002, 995002, 'ISDE26_ZOLDER', NOW(), NOW(), NULL),
(990003, 991003, 995003, 'ISDE26_GEVEL', NOW(), NOW(), NULL),
(990004, 991004, 995004, 'ISDE26_SPOUW', NOW(), NOW(), NULL),
(990005, 991005, 995005, 'ISDE26_VLOER', NOW(), NOW(), NULL),
(990006, 991006, 995006, 'ISDE26_BODEM', NOW(), NOW(), NULL),
(990007, 991007, 995007, 'ISDE26_HRPP', NOW(), NOW(), NULL),
(990008, 991008, 995008, 'ISDE26_TRIPLE', NOW(), NOW(), NULL),
(990009, 991009, 995009, 'ISDE26_PANEL12', NOW(), NOW(), NULL),
(990010, 991010, 995010, 'ISDE26_PANEL07', NOW(), NOW(), NULL),
(990011, 991011, 995011, 'ISDE26_DEUR15', NOW(), NOW(), NULL),
(990012, 991012, 995012, 'ISDE26_DEUR10', NOW(), NOW(), NULL),
(990020, 991020, 995020, 'ISDE26_ZB_LTE5', NOW(), NOW(), NULL),
(990021, 991021, 995021, 'ISDE26_ZB_GT5', NOW(), NOW(), NULL),
(990022, 991022, 995022, 'ISDE26_ZBC_LTE5', NOW(), NOW(), NULL),
(990023, 991023, 995023, 'ISDE26_ZBC_GT5', NOW(), NOW(), NULL),
(990030, 991030, 995030, 'ISDE26_WARMTE', NOW(), NOW(), NULL),
(990031, 991031, 995031, 'ISDE26_KOKEN', NOW(), NOW(), NULL),
(990100, 991100, 995100, 'ISDE26_LW_LT1_A3', NOW(), NOW(), NULL),
(990101, 991101, 995101, 'ISDE26_LW_1_70_A3', NOW(), NOW(), NULL),
(990102, 991102, 995102, 'ISDE26_LW_71_400_ANY', NOW(), NOW(), NULL),
(990110, 991110, 995110, 'ISDE26_LW_LT1_A2', NOW(), NOW(), NULL),
(990111, 991111, 995111, 'ISDE26_LW_1_70_A2', NOW(), NOW(), NULL),
(990120, 991120, 995120, 'ISDE26_LW_LT1_A1', NOW(), NOW(), NULL),
(990130, 991130, 995130, 'ISDE26_LW_LT1_ATMG', NOW(), NOW(), NULL),
(990200, 991200, 995200, 'ISDE26_GW_LT1_A3', NOW(), NOW(), NULL),
(990201, 991201, 995201, 'ISDE26_GW_1_10_A3', NOW(), NOW(), NULL),
(990202, 991202, 995202, 'ISDE26_GW_10_70_A3', NOW(), NOW(), NULL),
(990203, 991203, 995203, 'ISDE26_GW_71_400_ANY', NOW(), NOW(), NULL),
(990300, 991300, 995300, 'ISDE26_WW_LT1_A3', NOW(), NOW(), NULL),
(990301, 991301, 995301, 'ISDE26_WW_1_10_A3', NOW(), NOW(), NULL),
(990302, 991302, 995302, 'ISDE26_WW_10_70_A3', NOW(), NOW(), NULL),
(990303, 991303, 995303, 'ISDE26_WW_71_400_ANY', NOW(), NOW(), NULL)
ON DUPLICATE KEY UPDATE
measure_id = VALUES(measure_id),
report_code = VALUES(report_code),
updated_at = NOW(),
deleted_at = VALUES(deleted_at);

COMMIT;