Pastebin

New Paste Add Image

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, 'Dakisolatie Rd ≥ 3,5 m2 K/W', NULL, 0, NULL, NULL, 1.00),
(990002, 'ISDE26 - Zolder/vlieringisolatie', 'ISDE26_ZOLDER', 2, 3, NULL, 4.00, 3.00, NOW(), NOW(), NULL, 9, 'Zolder-of vlieringisolatie Rd ≥ 3,5 m2 K/W', NULL, 0, NULL, NULL, 1.00),
(990003, 'ISDE26 - Gevelisolatie', 'ISDE26_GEVEL', 2, 3, NULL, 19.00, 15.00, NOW(), NOW(), NULL, 9, 'Binnen-of buitengevelisolatie Rd ≥ 3,5 m2 K/W', NULL, 0, NULL, NULL, 1.00),
(990004, 'ISDE26 - Spouwmuurisolatie', 'ISDE26_SPOUW', 2, 3, NULL, 5.00, 4.00, NOW(), NOW(), NULL, 9, 'Spouwmuurisolatie Rd ≥ 1,1 m2 K/W', NULL, 0, NULL, NULL, 1.00),
(990005, 'ISDE26 - Vloerisolatie', 'ISDE26_VLOER', 2, 3, NULL, 5.50, 4.50, NOW(), NOW(), NULL, 9, 'Vloerisolatie Rd ≥ 3,5 m2 K/W', NULL, 0, NULL, NULL, 1.00),
(990006, 'ISDE26 - Bodemisolatie', 'ISDE26_BODEM', 2, 3, NULL, 3.00, 2.50, NOW(), NOW(), NULL, 9, 'Bodemisolatie Rd ≥ 3,5 m2 K/W', 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, 'HR++ glas U ≤ 1,2 W/m2K', NULL, 0, NULL, NULL, 1.00),
(990008, 'ISDE26 - Triple glas', 'ISDE26_TRIPLE', 2, 3, NULL, 111.00, 90.00, NOW(), NOW(), NULL, 9, 'Triple glas U ≤ 0,7 W/m2K', 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, 'Isolerende panelen U ≤ 1,2 W/m2K', 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, 'Isolerende panelen U ≤ 0,7 W/m2K', 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, 'Isolerende deuren U ≤ 1,5 W/m2K', 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, 'Isolerende deuren U ≤ 1,0 W/m2K', 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, 'Zonneboiler ≤ 5 m2', 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, 'Zonneboiler > 5 en ≤ 10 m2', NULL, 0, NULL, NULL, 1.00),
(990022, 'ISDE26 - Zonneboilercombi ≤5m²', 'ISDE26_ZBC_LTE5', 2, 3, NULL, 1950.00, 1560.00, NOW(), NOW(), NULL, 9, 'Zonneboilercombi ≤ 5 m2', 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, 'Zonneboilercombi > 5 en ≤ 10 m2', 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, 'Aansluiting op een warmtenet', NULL, 0, NULL, NULL, 1.00),
(990031, 'ISDE26 - Elektrische kookvoorziening', 'ISDE26_KOKEN', 2, 1, NULL, 400.00, 320.00, NOW(), NOW(), NULL, 9, 'Elektrische kookvoorziening', 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, 'Lucht-water < 1 kW A+++', 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, 'Lucht-water ≥1 ≤70 kW A+++', 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, 'Lucht-water ≥71 ≤400 kW', 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, 'Lucht-water < 1 kW A++', 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, 'Lucht-water ≥1 ≤70 kW A++', 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, 'Lucht-water < 1 kW A+', 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, 'Lucht-water < 1 kW A t/m G', 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, 'Grond-water < 1 kW A+++', 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, 'Grond-water ≥1 <10 kW A+++', 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, 'Grond-water ≥10 ≤70 kW A+++', 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, 'Grond-water ≥71 ≤400 kW', 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, 'Water-water < 1 kW A+++', 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, 'Water-water ≥1 <10 kW A+++', 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, 'Water-water ≥10 ≤70 kW A+++', 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, 'Water-water ≥71 ≤400 kW', 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;

Settings

Title : [Optional]

Paste Folder : [Optional]

Syntax : [Optional]

Expiration : [Optional]

Status : [Optional]

Password : [Optional]

Description: [Optional]

Tags: [Optional]

Encrypt Paste (?)

You are currently not logged in, this means you can not edit or delete anything you paste. Sign Up or Login

Settings

Site Languages