-- Delete all existing data from product_option_volume_masters table
DELETE FROM product_option_volume_masters;

-- Reset the sequence if needed
ALTER SEQUENCE product_option_volume_masters_id_seq RESTART WITH 1;

-- Insert new corrected data
INSERT INTO product_option_volume_masters 
(product_code, variant_type, option_name, strength, num_batches, volume_comp_coat_cap_imp, volume_gran_fbp_blend, is_active, "createdAt", "updatedAt")
VALUES
-- AMT (9 records)
('AMT', 'SB', 'SB_Option1_Strength(10)', '10', 1, 5.0000, 5.0000, true, NOW(), NOW()),
('AMT', 'CB', 'CB_Option1_Strength(25)', '25', 4, 1.1500, 7.0000, true, NOW(), NOW()),
('AMT', 'CB', 'CB_Option1_Strength(50)', '50', 2, 1.1900, 7.0000, true, NOW(), NOW()),
('AMT', 'CB', 'CB_Option2_Strength(25)', '25', 8, 1.1500, 9.2000, true, NOW(), NOW()),
('AMT', 'CB', 'CB_Option3_Strength(50)', '50', 5, 1.1900, 6.0000, true, NOW(), NOW()),
('AMT', 'CB', 'CB_Option4_Strength(75)', '75', 1, 0.8000, 2.4000, true, NOW(), NOW()),
('AMT', 'CB', 'CB_Option4_Strength(100)', '100', 1, 1.3000, 2.4000, true, NOW(), NOW()),
('AMT', 'CB', 'CB_Option4_Strength(150)', '150', 1, 0.2900, 2.4000, true, NOW(), NOW()),
('AMT', 'CB', 'CB_Option5_Strength(150)', '150', 3, 0.2900, 0.9000, true, NOW(), NOW()),

-- ATR (7 records)
('ATR', 'CB', 'CB_Option1_Strength(10)', '10', 3, 2.7300, 12.3000, true, NOW(), NOW()),
('ATR', 'CB', 'CB_Option1_Strength(20)', '20', 1.5, 2.7300, 12.3000, true, NOW(), NOW()),
('ATR', 'CB', 'CB_Option2_Strength(10)', '10', 3, 2.7300, 9.2000, true, NOW(), NOW()),
('ATR', 'CB', 'CB_Option2_Strength(80)', '80', 1, 1.0250, 9.2000, true, NOW(), NOW()),
('ATR', 'CB', 'CB_Option3_Strength(20)', '20', 3, 2.7300, 8.2000, true, NOW(), NOW()),
('ATR', 'CB', 'CB_Option4_Strength(40)', '40', 2, 2.0500, 4.1000, true, NOW(), NOW()),
('ATR', 'CB', 'CB_Option5_Strength(80)', '80', 2, 1.0250, 2.1000, true, NOW(), NOW()),

-- BUP (2 records)
('BUP', 'SB', 'SB_Option1_Strength(150)', '150', 1, 1.5000, 1.5000, true, NOW(), NOW()),
('BUP', 'SB', 'SB_Option2_Strength(300)', '300', 1, 1.5000, 1.5000, true, NOW(), NOW()),

-- CYC (4 records)
('CYC', 'CB', 'CB_Option1_Strength(10)', '10', 3, 1.0200, 3.1000, true, NOW(), NOW()),
('CYC', 'CB', 'CB_Option2_Strength(5)', '5', 1, 0.9000, NULL, true, NOW(), NOW()),
('CYC', 'CB', 'CB_Option2_Strength(7.5)', '7.5', 1, 0.1640, 2.1000, true, NOW(), NOW()),
('CYC', 'CB', 'CB_Strength(10)', '10', 1, 1.0200, NULL, true, NOW(), NOW()),

-- CZX (4 records)
('CZX', 'SB', 'SB_Option1_Strength(250)', '250', 1, 0.2500, 0.3000, true, NOW(), NOW()),
('CZX', 'SB', 'SB_Option2_Strength(375)', '375', 1, 0.1500, 0.2000, true, NOW(), NOW()),
('CZX', 'SB', 'SB_Option3_Strength(500)', '500', 1, 0.4800, 0.5000, true, NOW(), NOW()),
('CZX', 'SB', 'SB_Option4_Strength(750)', '750', 1, 0.1500, 0.2000, true, NOW(), NOW()),

-- ESC (3 records)
('ESC', 'CB', 'CB_Option1_Strength(5)', '5', 1, 6.3000, 6.3000, true, NOW(), NOW()),
('ESC', 'CB', 'CB_Option2_Strength(10)', '10', 1, 3.1500, 3.2000, true, NOW(), NOW()),
('ESC', 'CB', 'CB_Option3_Strength(20)', '20', 1, 1.5750, 1.6000, true, NOW(), NOW()),

-- ESO (6 records)
('ESO', 'CB', 'CB_Option1_Strength(40)', '40', 2, 1.7500, 3.5000, true, NOW(), NOW()),
('ESO', 'CB', 'CB_Option2_Strength(40)', '40', 2, 1.4500, 4.1000, true, NOW(), NOW()),
('ESO', 'CB', 'CB_Option2_Strength(20)', '20', 1, 1.2000, 4.1000, true, NOW(), NOW()),
('ESO', 'CB', 'CB_Strength(40)', '40', 2, 1.4500, 4.1000, true, NOW(), NOW()),
('ESO', 'CB', 'CB_Option3_Strength(20)', '20', 1, 0.6000, 4.1000, true, NOW(), NOW()),
('ESO', 'CB', 'CB_Strength(20-OTC)', '20-OTC', 1, 0.6000, 4.1000, true, NOW(), NOW()),

-- FAMO (4 records)
('FAMO', 'CB1', 'CB1_Option1_Strength(40)', '40', 2, 1.4000, 2.8000, true, NOW(), NOW()),
('FAMO', 'CB2', 'CB2_Option2_Strength(40)', '40', 1, 1.4000, 2.8000, true, NOW(), NOW()),
('FAMO', 'CB2', 'CB2_Option2_Strength(20)', '20', 1, 1.4000, 2.8000, true, NOW(), NOW()),
('FAMO', 'CB2', 'CB2_Option3_Strength(20)', '20', 3, 1.4000, 4.2000, true, NOW(), NOW()),

-- FURO (3 records)
('FURO', 'CB', 'CB_Option1_Strength(20)', '20', 1, 9.0000, 9.0000, true, NOW(), NOW()),
('FURO', 'CB', 'CB_Option2_Strength(40)', '40', 1, 4.5000, 4.5000, true, NOW(), NOW()),
('FURO', 'CB', 'CB_Option3_Strength(80)', '80', 1, 2.2500, 2.3000, true, NOW(), NOW()),

-- GBC (5 records)
('GBC', 'SB', 'SB_Option1_Strength(100)', '100', 1, 4.0000, 4.0000, true, NOW(), NOW()),
('GBC', 'CB1', 'CB1_Option1_Strength(300)', '300', 1, 3.0000, 3.0000, true, NOW(), NOW()),
('GBC', 'CB1', 'CB1_Option2_Strength(400)', '400', 1, 2.2500, 2.3000, true, NOW(), NOW()),
('GBC', 'CB2', 'CB2_Option1_Strength(300)', '300', 1, 4.0000, 4.0000, true, NOW(), NOW()),
('GBC', 'CB2', 'CB2_Option2_Strength(400)', '400', 1, 3.0000, 3.0000, true, NOW(), NOW()),

-- GBT (2 records)
('GBT', 'CB', 'CB_Option1_Strength(600)', '600', 1, 1.2000, 1.2000, true, NOW(), NOW()),
('GBT', 'CB', 'CB_Option2_Strength(800)', '800', 1, 0.9000, 0.9000, true, NOW(), NOW()),

-- HYH (3 records)
('HYH', 'SB', 'SB_Option1_Strength(10)', '10', 1, 6.0000, 6.0000, true, NOW(), NOW()),
('HYH', 'CB', 'CB_Option1_Strength(25)', '25', 1, 4.0500, 4.1000, true, NOW(), NOW()),
('HYH', 'CB', 'CB_Option2_Strength(50)', '50', 1, 2.0250, 2.0000, true, NOW(), NOW()),

-- LVT (1 record)
('LVT', 'SB', 'SB_Option1_Strength(330)', '330', 1, 0.5000, 0.5000, true, NOW(), NOW()),

-- MNT (1 record)
('MNT', 'SB', 'SB_Option1_Strength(10)', '10', 1, 1.4000, 1.4000, true, NOW(), NOW()),

-- TRAM (2 records)
('TRAM', 'SB', 'SB_Option1_Strength(50)', '50', 3, 1.4000, 4.2000, true, NOW(), NOW()),
('TRAM', 'SB', 'SB_Option2_Strength(100)', '100', 1, 0.7000, 0.7000, true, NOW(), NOW()),

-- PANTO (2 records)
('PANTO', 'SB', 'SB_Option1_Strength(20)', '20', 3, 1.4000, 4.2000, true, NOW(), NOW()),
('PANTO', 'SB', 'SB_Option2_Strength(40)', '40', 2, 1.0500, 2.1000, true, NOW(), NOW()),

-- TRAZ (7 records)
('TRAZ', 'CB', 'CB_Option1_Strength(50)', '50', 2, 1.2500, 4.6000, true, NOW(), NOW()),
('TRAZ', 'CB', 'CB_Option1_Strength(100)', '100', 2, 0.7500, 4.6000, true, NOW(), NOW()),
('TRAZ', 'CB', 'CB_Option1_Strength(150)', '150', 1, 0.4500, 4.6000, true, NOW(), NOW()),
('TRAZ', 'CB', 'CB_Strength(300)', '300', 1, 0.1200, 4.6000, true, NOW(), NOW()),
('TRAZ', 'CB', 'CB_Option2_Strength(50)', '50', 2, 1.2500, 4.8000, true, NOW(), NOW()),
('TRAZ', 'CB', 'CB_Option2_Strength(100)', '100', 2, 0.9300, 4.8000, true, NOW(), NOW()),
('TRAZ', 'CB', 'CB_Strength(150)', '150', 1, 0.4500, 4.8000, true, NOW(), NOW()),

-- BUS (5 records)
('BUS', 'CB', 'CB_Option1_Strength(5)', '5', 1, 1.3500, 6.3000, true, NOW(), NOW()),
('BUS', 'CB', 'CB_Option1_Strength(7.5)', '7.5', 1, 0.9000, 6.3000, true, NOW(), NOW()),
('BUS', 'CB', 'CB_Option1_Strength(10)', '10', 1, 2.7000, 6.3000, true, NOW(), NOW()),
('BUS', 'CB', 'CB_Option1_Strength(15)', '15', 1, 1.3500, 6.3000, true, NOW(), NOW()),
('BUS', 'SB', 'SB_Option1_Strength(30)', '30', 1, 1.0500, 1.1000, true, NOW(), NOW()),

-- SPR (3 records)
('SPR', 'CB', 'CB_Option1_Strength(25)', '25', 1, 1.9500, 4.1000, true, NOW(), NOW()),
('SPR', 'CB', 'CB_Option1_Strength(50)', '50', 1, 1.3000, 4.1000, true, NOW(), NOW()),
('SPR', 'CB', 'CB_Strength(100)', '100', 1, 0.8100, 4.1000, true, NOW(), NOW()),

-- LORA (3 records)
('LORA', 'CB', 'CB_Option1_Strength(0.5)', '0.5', 1, 2.3000, 4.7000, true, NOW(), NOW()),
('LORA', 'CB', 'CB_Option1_Strength(1)', '1', 1, 1.7600, 4.7000, true, NOW(), NOW()),
('LORA', 'CB', 'CB_Strength(2)', '2', 1, 0.6000, 4.7000, true, NOW(), NOW()),

-- TIZA (3 records)
('TIZA', 'CB', 'CB_Option1_Strength(2)', '2', 1, 1.2000, 2.4000, true, NOW(), NOW()),
('TIZA', 'CB', 'CB_Option1_Strength(4)', '4', 1, 1.2000, 2.4000, true, NOW(), NOW()),
('TIZA', 'CB', 'CB_Option2_Strength(4)', '4', 1.5, 1.2000, 1.8000, true, NOW(), NOW());

-- Total: 79 records

-- Verify inserted records
SELECT COUNT(*) as total_records FROM product_option_volume_masters;

-- View sample data grouped by product
SELECT product_code, variant_type, option_name, strength, num_batches, volume_comp_coat_cap_imp, volume_gran_fbp_blend 
FROM product_option_volume_masters 
ORDER BY id;
