-- Additional pump data for 3", 4", 6", and 8" series
-- Model IDs start at 200 to avoid conflicts with 10"WPS data

USE wellpumps_selector;

-- Ensure auto-increment starts above our explicit IDs
-- This is handled by using explicit IDs in the INSERT statements

-- ============================================================================
-- 3"WPS 1 SERIES PUMP MODELS (8 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(200, 1, '3"WPS 1-10', 1.0, 10, '', 0.37, 0.5, 3.4, '3x400V'),
(201, 1, '3"WPS 1-15', 1.0, 15, '', 0.37, 0.5, 3.4, '3x400V'),
(202, 1, '3"WPS 1-20', 1.0, 20, '', 0.55, 0.75, 4.4, '3x400V'),
(203, 1, '3"WPS 1-25', 1.0, 25, '', 0.55, 0.75, 4.4, '3x400V'),
(204, 1, '3"WPS 1-30', 1.0, 30, '', 0.75, 1.0, 6.0, '3x400V'),
(205, 1, '3"WPS 1-35', 1.0, 35, '', 0.75, 1.0, 6.0, '3x400V'),
(206, 1, '3"WPS 1-40', 1.0, 40, '', 1.1, 1.5, 7.8, '3x400V'),
(207, 1, '3"WPS 1-45', 1.0, 45, '', 1.1, 1.5, 7.8, '3x400V');

-- ============================================================================
-- 3"WPS 1 PERFORMANCE DATA (Flow: 0, 0.3, 0.6, 0.9, 1.2, 1.5 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 3"WPS 1-10
(200, 0.0, 55), (200, 0.3, 50), (200, 0.6, 42), (200, 0.9, 33), (200, 1.2, 23), (200, 1.5, 8),
-- 3"WPS 1-15
(201, 0.0, 80), (201, 0.3, 74), (201, 0.6, 63), (201, 0.9, 50), (201, 1.2, 35), (201, 1.5, 12),
-- 3"WPS 1-20
(202, 0.0, 107), (202, 0.3, 98), (202, 0.6, 84), (202, 0.9, 66), (202, 1.2, 46), (202, 1.5, 16),
-- 3"WPS 1-25
(203, 0.0, 134), (203, 0.3, 123), (203, 0.6, 105), (203, 0.9, 83), (203, 1.2, 58), (203, 1.5, 20),
-- 3"WPS 1-30
(204, 0.0, 160), (204, 0.3, 147), (204, 0.6, 126), (204, 0.9, 99), (204, 1.2, 69), (204, 1.5, 24),
-- 3"WPS 1-35
(205, 0.0, 187), (205, 0.3, 172), (205, 0.6, 147), (205, 0.9, 116), (205, 1.2, 81), (205, 1.5, 28),
-- 3"WPS 1-40
(206, 0.0, 214), (206, 0.3, 197), (206, 0.6, 168), (206, 0.9, 133), (206, 1.2, 93), (206, 1.5, 32),
-- 3"WPS 1-45
(207, 0.0, 241), (207, 0.3, 221), (207, 0.6, 189), (207, 0.9, 149), (207, 1.2, 104), (207, 1.5, 36);

-- ============================================================================
-- 3"WPS 2 SERIES PUMP MODELS (9 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(208, 1, '3"WPS 2-10', 2.0, 10, '', 0.37, 0.5, 3.4, '3x400V'),
(209, 1, '3"WPS 2-15', 2.0, 15, '', 0.37, 0.5, 3.4, '3x400V'),
(210, 1, '3"WPS 2-20', 2.0, 20, '', 0.55, 0.75, 4.4, '3x400V'),
(211, 1, '3"WPS 2-25', 2.0, 25, '', 0.75, 1.0, 6.0, '3x400V'),
(212, 1, '3"WPS 2-30', 2.0, 30, '', 0.75, 1.0, 6.0, '3x400V'),
(213, 1, '3"WPS 2-35', 2.0, 35, '', 1.1, 1.5, 7.8, '3x400V'),
(214, 1, '3"WPS 2-40', 2.0, 40, '', 1.1, 1.5, 7.8, '3x400V'),
(215, 1, '3"WPS 2-45', 2.0, 45, '', 1.5, 2.0, 10.5, '3x400V'),
(216, 1, '3"WPS 2-50', 2.0, 50, '', 1.5, 2.0, 10.5, '3x400V');

-- ============================================================================
-- 3"WPS 2 PERFORMANCE DATA (Flow: 0, 0.5, 1.0, 1.5, 2.0, 2.5, 3.0 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 3"WPS 2-10
(208, 0.0, 39), (208, 0.5, 37), (208, 1.0, 34), (208, 1.5, 28), (208, 2.0, 22), (208, 2.5, 13), (208, 3.0, 2),
-- 3"WPS 2-15
(209, 0.0, 58), (209, 0.5, 56), (209, 1.0, 50), (209, 1.5, 42), (209, 2.0, 33), (209, 2.5, 20), (209, 3.0, 3),
-- 3"WPS 2-20
(210, 0.0, 78), (210, 0.5, 75), (210, 1.0, 67), (210, 1.5, 56), (210, 2.0, 43), (210, 2.5, 27), (210, 3.0, 4),
-- 3"WPS 2-25
(211, 0.0, 97), (211, 0.5, 93), (211, 1.0, 84), (211, 1.5, 70), (211, 2.0, 54), (211, 2.5, 34), (211, 3.0, 5),
-- 3"WPS 2-30
(212, 0.0, 117), (212, 0.5, 112), (212, 1.0, 100), (212, 1.5, 84), (212, 2.0, 65), (212, 2.5, 40), (212, 3.0, 6),
-- 3"WPS 2-35
(213, 0.0, 136), (213, 0.5, 131), (213, 1.0, 117), (213, 1.5, 98), (213, 2.0, 76), (213, 2.5, 47), (213, 3.0, 7),
-- 3"WPS 2-40
(214, 0.0, 156), (214, 0.5, 150), (214, 1.0, 134), (214, 1.5, 112), (214, 2.0, 87), (214, 2.5, 54), (214, 3.0, 9),
-- 3"WPS 2-45
(215, 0.0, 175), (215, 0.5, 168), (215, 1.0, 151), (215, 1.5, 126), (215, 2.0, 97), (215, 2.5, 60), (215, 3.0, 10),
-- 3"WPS 2-50
(216, 0.0, 195), (216, 0.5, 187), (216, 1.0, 167), (216, 1.5, 140), (216, 2.0, 108), (216, 2.5, 67), (216, 3.0, 11);

-- ============================================================================
-- 3"WPS 3 SERIES PUMP MODELS (9 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(217, 1, '3"WPS 3-8', 3.0, 8, '', 0.37, 0.5, 3.4, '3x400V'),
(218, 1, '3"WPS 3-11', 3.0, 11, '', 0.37, 0.5, 3.4, '3x400V'),
(219, 1, '3"WPS 3-15', 3.0, 15, '', 0.55, 0.75, 4.4, '3x400V'),
(220, 1, '3"WPS 3-19', 3.0, 19, '', 0.75, 1.0, 6.0, '3x400V'),
(221, 1, '3"WPS 3-23', 3.0, 23, '', 0.75, 1.0, 6.0, '3x400V'),
(222, 1, '3"WPS 3-27', 3.0, 27, '', 1.1, 1.5, 7.8, '3x400V'),
(223, 1, '3"WPS 3-30', 3.0, 30, '', 1.1, 1.5, 7.8, '3x400V'),
(224, 1, '3"WPS 3-34', 3.0, 34, '', 1.5, 2.0, 10.5, '3x400V'),
(225, 1, '3"WPS 3-38', 3.0, 38, '', 1.5, 2.0, 10.5, '3x400V');

-- ============================================================================
-- 3"WPS 3 PERFORMANCE DATA (Flow: 0, 0.5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5, 4.0 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 3"WPS 3-8
(217, 0.0, 23), (217, 0.5, 22), (217, 1.0, 21), (217, 1.5, 19), (217, 2.0, 17), (217, 2.5, 14), (217, 3.0, 11), (217, 3.5, 7), (217, 4.0, 2),
-- 3"WPS 3-11
(218, 0.0, 32), (218, 0.5, 31), (218, 1.0, 29), (218, 1.5, 27), (218, 2.0, 24), (218, 2.5, 20), (218, 3.0, 15), (218, 3.5, 10), (218, 4.0, 3),
-- 3"WPS 3-15
(219, 0.0, 44), (219, 0.5, 42), (219, 1.0, 40), (219, 1.5, 36), (219, 2.0, 33), (219, 2.5, 27), (219, 3.0, 21), (219, 3.5, 14), (219, 4.0, 4),
-- 3"WPS 3-19
(220, 0.0, 55), (220, 0.5, 53), (220, 1.0, 50), (220, 1.5, 46), (220, 2.0, 41), (220, 2.5, 34), (220, 3.0, 26), (220, 3.5, 17), (220, 4.0, 5),
-- 3"WPS 3-23
(221, 0.0, 67), (221, 0.5, 64), (221, 1.0, 61), (221, 1.5, 55), (221, 2.0, 50), (221, 2.5, 42), (221, 3.0, 32), (221, 3.5, 21), (221, 4.0, 6),
-- 3"WPS 3-27
(222, 0.0, 79), (222, 0.5, 76), (222, 1.0, 71), (222, 1.5, 65), (222, 2.0, 58), (222, 2.5, 49), (222, 3.0, 37), (222, 3.5, 24), (222, 4.0, 7),
-- 3"WPS 3-30
(223, 0.0, 88), (223, 0.5, 84), (223, 1.0, 79), (223, 1.5, 72), (223, 2.0, 64), (223, 2.5, 54), (223, 3.0, 42), (223, 3.5, 27), (223, 4.0, 8),
-- 3"WPS 3-34
(224, 0.0, 99), (224, 0.5, 95), (224, 1.0, 90), (224, 1.5, 82), (224, 2.0, 73), (224, 2.5, 61), (224, 3.0, 47), (224, 3.5, 31), (224, 4.0, 9),
-- 3"WPS 3-38
(225, 0.0, 111), (225, 0.5, 106), (225, 1.0, 100), (225, 1.5, 91), (225, 2.0, 82), (225, 2.5, 68), (225, 3.0, 52), (225, 3.5, 34), (225, 4.0, 10);

-- ============================================================================
-- 3"WPS 5 SERIES PUMP MODELS (8 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(226, 1, '3"WPS 5-5', 5.0, 5, '', 0.37, 0.5, 3.4, '3x400V'),
(227, 1, '3"WPS 5-8', 5.0, 8, '', 0.55, 0.75, 4.4, '3x400V'),
(228, 1, '3"WPS 5-11', 5.0, 11, '', 0.75, 1.0, 6.0, '3x400V'),
(229, 1, '3"WPS 5-14', 5.0, 14, '', 0.75, 1.0, 6.0, '3x400V'),
(230, 1, '3"WPS 5-17', 5.0, 17, '', 1.1, 1.5, 7.8, '3x400V'),
(231, 1, '3"WPS 5-20', 5.0, 20, '', 1.1, 1.5, 7.8, '3x400V'),
(232, 1, '3"WPS 5-24', 5.0, 24, '', 1.5, 2.0, 10.5, '3x400V'),
(233, 1, '3"WPS 5-27', 5.0, 27, '', 1.5, 2.0, 10.5, '3x400V');

-- ============================================================================
-- 3"WPS 5 PERFORMANCE DATA (Flow: 0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 3"WPS 5-5
(226, 0.0, 13), (226, 1.0, 12), (226, 2.0, 11), (226, 3.0, 10), (226, 4.0, 9), (226, 5.0, 8), (226, 6.0, 6), (226, 7.0, 3),
-- 3"WPS 5-8
(227, 0.0, 20), (227, 1.0, 19), (227, 2.0, 18), (227, 3.0, 16), (227, 4.0, 15), (227, 5.0, 12), (227, 6.0, 9), (227, 7.0, 5),
-- 3"WPS 5-11
(228, 0.0, 28), (228, 1.0, 27), (228, 2.0, 25), (228, 3.0, 22), (228, 4.0, 20), (228, 5.0, 17), (228, 6.0, 13), (228, 7.0, 7),
-- 3"WPS 5-14
(229, 0.0, 35), (229, 1.0, 34), (229, 2.0, 32), (229, 3.0, 29), (229, 4.0, 26), (229, 5.0, 21), (229, 6.0, 16), (229, 7.0, 9),
-- 3"WPS 5-17
(230, 0.0, 43), (230, 1.0, 41), (230, 2.0, 38), (230, 3.0, 35), (230, 4.0, 31), (230, 5.0, 26), (230, 6.0, 20), (230, 7.0, 11),
-- 3"WPS 5-20
(231, 0.0, 51), (231, 1.0, 49), (231, 2.0, 45), (231, 3.0, 41), (231, 4.0, 37), (231, 5.0, 31), (231, 6.0, 23), (231, 7.0, 13),
-- 3"WPS 5-24
(232, 0.0, 61), (232, 1.0, 58), (232, 2.0, 54), (232, 3.0, 49), (232, 4.0, 44), (232, 5.0, 37), (232, 6.0, 28), (232, 7.0, 15),
-- 3"WPS 5-27
(233, 0.0, 68), (233, 1.0, 65), (233, 2.0, 61), (233, 3.0, 55), (233, 4.0, 49), (233, 5.0, 41), (233, 6.0, 31), (233, 7.0, 17);

-- ============================================================================
-- 4"WPS 1.5 SERIES PUMP MODELS (8 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(234, 4, '4"WPS 1.5-12', 1.5, 12, '', 0.37, 0.5, 3.4, '3x400V'),
(235, 4, '4"WPS 1.5-17', 1.5, 17, '', 0.37, 0.5, 3.4, '3x400V'),
(236, 4, '4"WPS 1.5-22', 1.5, 22, '', 0.55, 0.75, 4.4, '3x400V'),
(237, 4, '4"WPS 1.5-27', 1.5, 27, '', 0.75, 1.0, 6.0, '3x400V'),
(238, 4, '4"WPS 1.5-33', 1.5, 33, '', 0.75, 1.0, 6.0, '3x400V'),
(239, 4, '4"WPS 1.5-38', 1.5, 38, '', 1.1, 1.5, 7.8, '3x400V'),
(240, 4, '4"WPS 1.5-43', 1.5, 43, '', 1.1, 1.5, 7.8, '3x400V'),
(241, 4, '4"WPS 1.5-48', 1.5, 48, '', 1.5, 2.0, 10.2, '3x400V');

-- ============================================================================
-- 4"WPS 1.5 PERFORMANCE DATA (Flow: 0, 0.3, 0.6, 0.9, 1.2, 1.5, 1.8, 2.1 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 4"WPS 1.5-12
(234, 0.0, 48), (234, 0.3, 46), (234, 0.6, 42), (234, 0.9, 37), (234, 1.2, 32), (234, 1.5, 25), (234, 1.8, 16), (234, 2.1, 6),
-- 4"WPS 1.5-17
(235, 0.0, 69), (235, 0.3, 66), (235, 0.6, 60), (235, 0.9, 53), (235, 1.2, 45), (235, 1.5, 36), (235, 1.8, 23), (235, 2.1, 9),
-- 4"WPS 1.5-22
(236, 0.0, 89), (236, 0.3, 85), (236, 0.6, 78), (236, 0.9, 69), (236, 1.2, 59), (236, 1.5, 46), (236, 1.8, 30), (236, 2.1, 12),
-- 4"WPS 1.5-27
(237, 0.0, 109), (237, 0.3, 104), (237, 0.6, 95), (237, 0.9, 84), (237, 1.2, 72), (237, 1.5, 57), (237, 1.8, 37), (237, 2.1, 14),
-- 4"WPS 1.5-33
(238, 0.0, 133), (238, 0.3, 127), (238, 0.6, 116), (238, 0.9, 103), (238, 1.2, 88), (238, 1.5, 69), (238, 1.8, 45), (238, 2.1, 17),
-- 4"WPS 1.5-38
(239, 0.0, 153), (239, 0.3, 147), (239, 0.6, 134), (239, 0.9, 119), (239, 1.2, 101), (239, 1.5, 80), (239, 1.8, 52), (239, 2.1, 20),
-- 4"WPS 1.5-43
(240, 0.0, 174), (240, 0.3, 166), (240, 0.6, 152), (240, 0.9, 135), (240, 1.2, 115), (240, 1.5, 91), (240, 1.8, 59), (240, 2.1, 22),
-- 4"WPS 1.5-48
(241, 0.0, 194), (241, 0.3, 185), (241, 0.6, 169), (241, 0.9, 150), (241, 1.2, 128), (241, 1.5, 101), (241, 1.8, 66), (241, 2.1, 25);

-- ============================================================================
-- 4"WPS 2.5 SERIES PUMP MODELS (9 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(242, 4, '4"WPS 2.5-10', 2.5, 10, '', 0.37, 0.5, 3.4, '3x400V'),
(243, 4, '4"WPS 2.5-14', 2.5, 14, '', 0.55, 0.75, 4.4, '3x400V'),
(244, 4, '4"WPS 2.5-18', 2.5, 18, '', 0.55, 0.75, 4.4, '3x400V'),
(245, 4, '4"WPS 2.5-23', 2.5, 23, '', 0.75, 1.0, 6.0, '3x400V'),
(246, 4, '4"WPS 2.5-27', 2.5, 27, '', 1.1, 1.5, 7.8, '3x400V'),
(247, 4, '4"WPS 2.5-32', 2.5, 32, '', 1.1, 1.5, 7.8, '3x400V'),
(248, 4, '4"WPS 2.5-37', 2.5, 37, '', 1.5, 2.0, 10.2, '3x400V'),
(249, 4, '4"WPS 2.5-42', 2.5, 42, '', 1.5, 2.0, 10.2, '3x400V'),
(250, 4, '4"WPS 2.5-46', 2.5, 46, '', 2.2, 3.0, 14.1, '3x400V');

-- ============================================================================
-- 4"WPS 2.5 PERFORMANCE DATA (Flow: 0, 0.5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 4"WPS 2.5-10
(242, 0.0, 38), (242, 0.5, 36), (242, 1.0, 33), (242, 1.5, 29), (242, 2.0, 24), (242, 2.5, 18), (242, 3.0, 11), (242, 3.5, 2),
-- 4"WPS 2.5-14
(243, 0.0, 53), (243, 0.5, 51), (243, 1.0, 47), (243, 1.5, 41), (243, 2.0, 34), (243, 2.5, 25), (243, 3.0, 15), (243, 3.5, 3),
-- 4"WPS 2.5-18
(244, 0.0, 69), (244, 0.5, 66), (244, 1.0, 60), (244, 1.5, 53), (244, 2.0, 43), (244, 2.5, 32), (244, 3.0, 19), (244, 3.5, 4),
-- 4"WPS 2.5-23
(245, 0.0, 88), (245, 0.5, 84), (245, 1.0, 77), (245, 1.5, 68), (245, 2.0, 55), (245, 2.5, 42), (245, 3.0, 25), (245, 3.5, 5),
-- 4"WPS 2.5-27
(246, 0.0, 103), (246, 0.5, 99), (246, 1.0, 90), (246, 1.5, 79), (246, 2.0, 65), (246, 2.5, 49), (246, 3.0, 29), (246, 3.5, 6),
-- 4"WPS 2.5-32
(247, 0.0, 122), (247, 0.5, 117), (247, 1.0, 107), (247, 1.5, 94), (247, 2.0, 77), (247, 2.5, 58), (247, 3.0, 34), (247, 3.5, 7),
-- 4"WPS 2.5-37
(248, 0.0, 141), (248, 0.5, 136), (248, 1.0, 123), (248, 1.5, 109), (248, 2.0, 89), (248, 2.5, 67), (248, 3.0, 39), (248, 3.5, 8),
-- 4"WPS 2.5-42
(249, 0.0, 161), (249, 0.5, 154), (249, 1.0, 140), (249, 1.5, 123), (249, 2.0, 101), (249, 2.5, 76), (249, 3.0, 44), (249, 3.5, 9),
-- 4"WPS 2.5-46
(250, 0.0, 176), (250, 0.5, 169), (250, 1.0, 153), (250, 1.5, 135), (250, 2.0, 111), (250, 2.5, 83), (250, 3.0, 49), (250, 3.5, 10);

-- ============================================================================
-- 4"WPS 4 SERIES PUMP MODELS (11 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(251, 4, '4"WPS 4-7', 4.0, 7, '', 0.37, 0.5, 3.4, '3x400V'),
(252, 4, '4"WPS 4-10', 4.0, 10, '', 0.55, 0.75, 4.4, '3x400V'),
(253, 4, '4"WPS 4-13', 4.0, 13, '', 0.75, 1.0, 6.0, '3x400V'),
(254, 4, '4"WPS 4-17', 4.0, 17, '', 1.1, 1.5, 7.8, '3x400V'),
(255, 4, '4"WPS 4-20', 4.0, 20, '', 1.1, 1.5, 7.8, '3x400V'),
(256, 4, '4"WPS 4-23', 4.0, 23, '', 1.5, 2.0, 10.2, '3x400V'),
(257, 4, '4"WPS 4-27', 4.0, 27, '', 1.5, 2.0, 10.2, '3x400V'),
(258, 4, '4"WPS 4-30', 4.0, 30, '', 2.2, 3.0, 14.1, '3x400V'),
(259, 4, '4"WPS 4-33', 4.0, 33, '', 2.2, 3.0, 14.1, '3x400V'),
(260, 4, '4"WPS 4-37', 4.0, 37, '', 3.0, 4.0, 19.3, '3x400V'),
(261, 4, '4"WPS 4-40', 4.0, 40, '', 3.0, 4.0, 19.3, '3x400V');

-- ============================================================================
-- 4"WPS 4 PERFORMANCE DATA (Flow: 0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 4"WPS 4-7
(251, 0.0, 25), (251, 1.0, 24), (251, 2.0, 22), (251, 3.0, 19), (251, 4.0, 16), (251, 5.0, 12), (251, 6.0, 5),
-- 4"WPS 4-10
(252, 0.0, 35), (252, 1.0, 34), (252, 2.0, 32), (252, 3.0, 27), (252, 4.0, 22), (252, 5.0, 17), (252, 6.0, 8),
-- 4"WPS 4-13
(253, 0.0, 46), (253, 1.0, 44), (253, 2.0, 41), (253, 3.0, 36), (253, 4.0, 29), (253, 5.0, 22), (253, 6.0, 10),
-- 4"WPS 4-17
(254, 0.0, 60), (254, 1.0, 58), (254, 2.0, 54), (254, 3.0, 47), (254, 4.0, 38), (254, 5.0, 28), (254, 6.0, 13),
-- 4"WPS 4-20
(255, 0.0, 70), (255, 1.0, 68), (255, 2.0, 63), (255, 3.0, 55), (255, 4.0, 45), (255, 5.0, 33), (255, 6.0, 15),
-- 4"WPS 4-23
(256, 0.0, 81), (256, 1.0, 78), (256, 2.0, 73), (256, 3.0, 63), (256, 4.0, 52), (256, 5.0, 38), (256, 6.0, 18),
-- 4"WPS 4-27
(257, 0.0, 95), (257, 1.0, 92), (257, 2.0, 85), (257, 3.0, 74), (257, 4.0, 61), (257, 5.0, 45), (257, 6.0, 21),
-- 4"WPS 4-30
(258, 0.0, 106), (258, 1.0, 102), (258, 2.0, 95), (258, 3.0, 83), (258, 4.0, 68), (258, 5.0, 50), (258, 6.0, 23),
-- 4"WPS 4-33
(259, 0.0, 116), (259, 1.0, 112), (259, 2.0, 104), (259, 3.0, 91), (259, 4.0, 74), (259, 5.0, 55), (259, 6.0, 26),
-- 4"WPS 4-37
(260, 0.0, 130), (260, 1.0, 126), (260, 2.0, 117), (260, 3.0, 102), (260, 4.0, 83), (260, 5.0, 62), (260, 6.0, 29),
-- 4"WPS 4-40
(261, 0.0, 141), (261, 1.0, 136), (261, 2.0, 126), (261, 3.0, 110), (261, 4.0, 90), (261, 5.0, 67), (261, 6.0, 31);

-- ============================================================================
-- 4"WPS 7 SERIES PUMP MODELS (13 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(262, 4, '4"WPS 7-4', 7.0, 4, '', 0.55, 0.75, 4.4, '3x400V'),
(263, 4, '4"WPS 7-6', 7.0, 6, '', 0.75, 1.0, 6.0, '3x400V'),
(264, 4, '4"WPS 7-8', 7.0, 8, '', 1.1, 1.5, 7.8, '3x400V'),
(265, 4, '4"WPS 7-10', 7.0, 10, '', 1.5, 2.0, 10.2, '3x400V'),
(266, 4, '4"WPS 7-12', 7.0, 12, '', 1.5, 2.0, 10.2, '3x400V'),
(267, 4, '4"WPS 7-14', 7.0, 14, '', 2.2, 3.0, 14.1, '3x400V'),
(268, 4, '4"WPS 7-17', 7.0, 17, '', 2.2, 3.0, 14.1, '3x400V'),
(269, 4, '4"WPS 7-19', 7.0, 19, '', 3.0, 4.0, 19.3, '3x400V'),
(270, 4, '4"WPS 7-21', 7.0, 21, '', 3.0, 4.0, 19.3, '3x400V'),
(271, 4, '4"WPS 7-24', 7.0, 24, '', 4.0, 5.5, 25.0, '3x400V'),
(272, 4, '4"WPS 7-27', 7.0, 27, '', 4.0, 5.5, 25.0, '3x400V'),
(273, 4, '4"WPS 7-30', 7.0, 30, '', 5.5, 7.5, 29.0, '3x400V'),
(274, 4, '4"WPS 7-33', 7.0, 33, '', 5.5, 7.5, 29.0, '3x400V');

-- ============================================================================
-- 4"WPS 7 PERFORMANCE DATA (Flow: 0, 2, 4, 6, 8, 10, 12 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 4"WPS 7-4
(262, 0.0, 14), (262, 2.0, 14), (262, 4.0, 12), (262, 6.0, 11), (262, 8.0, 8), (262, 10.0, 5), (262, 12.0, 1),
-- 4"WPS 7-6
(263, 0.0, 22), (263, 2.0, 21), (263, 4.0, 19), (263, 6.0, 16), (263, 8.0, 13), (263, 10.0, 8), (263, 12.0, 2),
-- 4"WPS 7-8
(264, 0.0, 29), (264, 2.0, 28), (264, 4.0, 25), (264, 6.0, 22), (264, 8.0, 17), (264, 10.0, 11), (264, 12.0, 2),
-- 4"WPS 7-10
(265, 0.0, 36), (265, 2.0, 35), (265, 4.0, 31), (265, 6.0, 27), (265, 8.0, 21), (265, 10.0, 14), (265, 12.0, 3),
-- 4"WPS 7-12
(266, 0.0, 43), (266, 2.0, 42), (266, 4.0, 38), (266, 6.0, 33), (266, 8.0, 25), (266, 10.0, 17), (266, 12.0, 3),
-- 4"WPS 7-14
(267, 0.0, 50), (267, 2.0, 49), (267, 4.0, 44), (267, 6.0, 38), (267, 8.0, 30), (267, 10.0, 19), (267, 12.0, 4),
-- 4"WPS 7-17
(268, 0.0, 61), (268, 2.0, 60), (268, 4.0, 54), (268, 6.0, 46), (268, 8.0, 36), (268, 10.0, 23), (268, 12.0, 5),
-- 4"WPS 7-19
(269, 0.0, 68), (269, 2.0, 67), (269, 4.0, 60), (269, 6.0, 52), (269, 8.0, 40), (269, 10.0, 26), (269, 12.0, 5),
-- 4"WPS 7-21
(270, 0.0, 75), (270, 2.0, 74), (270, 4.0, 66), (270, 6.0, 57), (270, 8.0, 44), (270, 10.0, 29), (270, 12.0, 6),
-- 4"WPS 7-24
(271, 0.0, 86), (271, 2.0, 84), (271, 4.0, 76), (271, 6.0, 65), (271, 8.0, 51), (271, 10.0, 33), (271, 12.0, 7),
-- 4"WPS 7-27
(272, 0.0, 97), (272, 2.0, 95), (272, 4.0, 85), (272, 6.0, 73), (272, 8.0, 57), (272, 10.0, 37), (272, 12.0, 7),
-- 4"WPS 7-30
(273, 0.0, 107), (273, 2.0, 105), (273, 4.0, 95), (273, 6.0, 82), (273, 8.0, 64), (273, 10.0, 41), (273, 12.0, 8),
-- 4"WPS 7-33
(274, 0.0, 118), (274, 2.0, 116), (274, 4.0, 104), (274, 6.0, 90), (274, 8.0, 70), (274, 10.0, 45), (274, 12.0, 9);

-- ============================================================================
-- 4"WPS 13 SERIES PUMP MODELS (14 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(275, 4, '4"WPS 13-3', 13.0, 3, '', 0.75, 1.0, 6.0, '3x400V'),
(276, 4, '4"WPS 13-4', 13.0, 4, '', 1.1, 1.5, 7.8, '3x400V'),
(277, 4, '4"WPS 13-5', 13.0, 5, '', 1.5, 2.0, 10.2, '3x400V'),
(278, 4, '4"WPS 13-6', 13.0, 6, '', 1.5, 2.0, 10.2, '3x400V'),
(279, 4, '4"WPS 13-7', 13.0, 7, '', 2.2, 3.0, 14.1, '3x400V'),
(280, 4, '4"WPS 13-8', 13.0, 8, '', 2.2, 3.0, 14.1, '3x400V'),
(281, 4, '4"WPS 13-9', 13.0, 9, '', 3.0, 4.0, 19.3, '3x400V'),
(282, 4, '4"WPS 13-10', 13.0, 10, '', 3.0, 4.0, 19.3, '3x400V'),
(283, 4, '4"WPS 13-11', 13.0, 11, '', 4.0, 5.5, 25.0, '3x400V'),
(284, 4, '4"WPS 13-12', 13.0, 12, '', 4.0, 5.5, 25.0, '3x400V'),
(285, 4, '4"WPS 13-13', 13.0, 13, '', 5.5, 7.5, 29.0, '3x400V'),
(286, 4, '4"WPS 13-14', 13.0, 14, '', 5.5, 7.5, 29.0, '3x400V'),
(287, 4, '4"WPS 13-15', 13.0, 15, '', 5.5, 7.5, 29.0, '3x400V'),
(288, 4, '4"WPS 13-16', 13.0, 16, '', 7.5, 10.0, 38.0, '3x400V');

-- ============================================================================
-- 4"WPS 13 PERFORMANCE DATA (Flow: 0, 3, 6, 9, 12, 15, 18, 21 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 4"WPS 13-3
(275, 0.0, 15), (275, 3.0, 14), (275, 6.0, 13), (275, 9.0, 11), (275, 12.0, 9), (275, 15.0, 7), (275, 18.0, 4), (275, 21.0, 1),
-- 4"WPS 13-4
(276, 0.0, 20), (276, 3.0, 19), (276, 6.0, 17), (276, 9.0, 15), (276, 12.0, 12), (276, 15.0, 9), (276, 18.0, 6), (276, 21.0, 2),
-- 4"WPS 13-5
(277, 0.0, 25), (277, 3.0, 24), (277, 6.0, 22), (277, 9.0, 19), (277, 12.0, 15), (277, 15.0, 12), (277, 18.0, 7), (277, 21.0, 2),
-- 4"WPS 13-6
(278, 0.0, 30), (278, 3.0, 29), (278, 6.0, 26), (278, 9.0, 23), (278, 12.0, 18), (278, 15.0, 14), (278, 18.0, 9), (278, 21.0, 2),
-- 4"WPS 13-7
(279, 0.0, 35), (279, 3.0, 33), (279, 6.0, 30), (279, 9.0, 26), (279, 12.0, 22), (279, 15.0, 16), (279, 18.0, 10), (279, 21.0, 3),
-- 4"WPS 13-8
(280, 0.0, 40), (280, 3.0, 38), (280, 6.0, 35), (280, 9.0, 30), (280, 12.0, 25), (280, 15.0, 19), (280, 18.0, 11), (280, 21.0, 3),
-- 4"WPS 13-9
(281, 0.0, 45), (281, 3.0, 43), (281, 6.0, 39), (281, 9.0, 34), (281, 12.0, 28), (281, 15.0, 21), (281, 18.0, 13), (281, 21.0, 3),
-- 4"WPS 13-10
(282, 0.0, 50), (282, 3.0, 48), (282, 6.0, 43), (282, 9.0, 38), (282, 12.0, 31), (282, 15.0, 23), (282, 18.0, 14), (282, 21.0, 4),
-- 4"WPS 13-11
(283, 0.0, 55), (283, 3.0, 52), (283, 6.0, 48), (283, 9.0, 41), (283, 12.0, 34), (283, 15.0, 26), (283, 18.0, 16), (283, 21.0, 4),
-- 4"WPS 13-12
(284, 0.0, 60), (284, 3.0, 57), (284, 6.0, 52), (284, 9.0, 45), (284, 12.0, 37), (284, 15.0, 28), (284, 18.0, 17), (284, 21.0, 4),
-- 4"WPS 13-13
(285, 0.0, 65), (285, 3.0, 62), (285, 6.0, 56), (285, 9.0, 49), (285, 12.0, 40), (285, 15.0, 30), (285, 18.0, 18), (285, 21.0, 5),
-- 4"WPS 13-14
(286, 0.0, 70), (286, 3.0, 67), (286, 6.0, 61), (286, 9.0, 53), (286, 12.0, 43), (286, 15.0, 33), (286, 18.0, 20), (286, 21.0, 5),
-- 4"WPS 13-15
(287, 0.0, 75), (287, 3.0, 72), (287, 6.0, 65), (287, 9.0, 56), (287, 12.0, 46), (287, 15.0, 35), (287, 18.0, 21), (287, 21.0, 5),
-- 4"WPS 13-16
(288, 0.0, 80), (288, 3.0, 76), (288, 6.0, 69), (288, 9.0, 60), (288, 12.0, 49), (288, 15.0, 37), (288, 18.0, 23), (288, 21.0, 6);

-- ============================================================================
-- 4"WPS 20 SERIES PUMP MODELS (14 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(289, 4, '4"WPS 20-2', 20.0, 2, '', 0.75, 1.0, 6.0, '3x400V'),
(290, 4, '4"WPS 20-3', 20.0, 3, '', 1.1, 1.5, 7.8, '3x400V'),
(291, 4, '4"WPS 20-4', 20.0, 4, '', 1.5, 2.0, 10.2, '3x400V'),
(292, 4, '4"WPS 20-5', 20.0, 5, '', 2.2, 3.0, 14.1, '3x400V'),
(293, 4, '4"WPS 20-6', 20.0, 6, '', 2.2, 3.0, 14.1, '3x400V'),
(294, 4, '4"WPS 20-7', 20.0, 7, '', 3.0, 4.0, 19.3, '3x400V'),
(295, 4, '4"WPS 20-8', 20.0, 8, '', 3.0, 4.0, 19.3, '3x400V'),
(296, 4, '4"WPS 20-9', 20.0, 9, '', 4.0, 5.5, 25.0, '3x400V'),
(297, 4, '4"WPS 20-10', 20.0, 10, '', 4.0, 5.5, 25.0, '3x400V'),
(298, 4, '4"WPS 20-11', 20.0, 11, '', 5.5, 7.5, 29.0, '3x400V'),
(299, 4, '4"WPS 20-12', 20.0, 12, '', 5.5, 7.5, 29.0, '3x400V'),
(300, 4, '4"WPS 20-13', 20.0, 13, '', 7.5, 10.0, 38.0, '3x400V'),
(301, 4, '4"WPS 20-14', 20.0, 14, '', 7.5, 10.0, 38.0, '3x400V');

-- ============================================================================
-- 4"WPS 20 PERFORMANCE DATA (Flow: 0, 5, 10, 15, 20, 25, 30, 35 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 4"WPS 20-2
(289, 0.0, 8), (289, 5.0, 8), (289, 10.0, 7), (289, 15.0, 6), (289, 20.0, 5), (289, 25.0, 4), (289, 30.0, 3), (289, 35.0, 1),
-- 4"WPS 20-3
(290, 0.0, 12), (290, 5.0, 12), (290, 10.0, 11), (290, 15.0, 10), (290, 20.0, 8), (290, 25.0, 6), (290, 30.0, 4), (290, 35.0, 2),
-- 4"WPS 20-4
(291, 0.0, 16), (291, 5.0, 16), (291, 10.0, 14), (291, 15.0, 13), (291, 20.0, 10), (291, 25.0, 8), (291, 30.0, 5), (291, 35.0, 2),
-- 4"WPS 20-5
(292, 0.0, 20), (292, 5.0, 20), (292, 10.0, 18), (292, 15.0, 16), (292, 20.0, 13), (292, 25.0, 10), (292, 30.0, 7), (292, 35.0, 3),
-- 4"WPS 20-6
(293, 0.0, 24), (293, 5.0, 24), (293, 10.0, 22), (293, 15.0, 19), (293, 20.0, 16), (293, 25.0, 12), (293, 30.0, 8), (293, 35.0, 3),
-- 4"WPS 20-7
(294, 0.0, 28), (294, 5.0, 28), (294, 10.0, 25), (294, 15.0, 22), (294, 20.0, 18), (294, 25.0, 14), (294, 30.0, 9), (294, 35.0, 4),
-- 4"WPS 20-8
(295, 0.0, 32), (295, 5.0, 32), (295, 10.0, 29), (295, 15.0, 25), (295, 20.0, 21), (295, 25.0, 16), (295, 30.0, 11), (295, 35.0, 4),
-- 4"WPS 20-9
(296, 0.0, 36), (296, 5.0, 36), (296, 10.0, 32), (296, 15.0, 28), (296, 20.0, 23), (296, 25.0, 18), (296, 30.0, 12), (296, 35.0, 5),
-- 4"WPS 20-10
(297, 0.0, 40), (297, 5.0, 40), (297, 10.0, 36), (297, 15.0, 31), (297, 20.0, 26), (297, 25.0, 20), (297, 30.0, 13), (297, 35.0, 5),
-- 4"WPS 20-11
(298, 0.0, 44), (298, 5.0, 44), (298, 10.0, 40), (298, 15.0, 35), (298, 20.0, 29), (298, 25.0, 22), (298, 30.0, 15), (298, 35.0, 6),
-- 4"WPS 20-12
(299, 0.0, 48), (299, 5.0, 48), (299, 10.0, 43), (299, 15.0, 38), (299, 20.0, 31), (299, 25.0, 24), (299, 30.0, 16), (299, 35.0, 6),
-- 4"WPS 20-13
(300, 0.0, 52), (300, 5.0, 52), (300, 10.0, 47), (300, 15.0, 41), (300, 20.0, 34), (300, 25.0, 26), (300, 30.0, 17), (300, 35.0, 7),
-- 4"WPS 20-14
(301, 0.0, 56), (301, 5.0, 56), (301, 10.0, 50), (301, 15.0, 44), (301, 20.0, 36), (301, 25.0, 28), (301, 30.0, 19), (301, 35.0, 7);

-- ============================================================================
-- 6"WPS 16 SERIES PUMP MODELS (15 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(302, 7, '6"WPS 16-3', 16.0, 3, '', 1.1, 1.5, 7.8, '3x400V'),
(303, 7, '6"WPS 16-5', 16.0, 5, '', 1.5, 2.0, 10.2, '3x400V'),
(304, 7, '6"WPS 16-7', 16.0, 7, '', 2.2, 3.0, 14.1, '3x400V'),
(305, 7, '6"WPS 16-10', 16.0, 10, '', 3.0, 4.0, 19.3, '3x400V'),
(306, 7, '6"WPS 16-14', 16.0, 14, '', 4.0, 5.5, 25.0, '3x400V'),
(307, 7, '6"WPS 16-17', 16.0, 17, '', 5.5, 7.5, 29.0, '3x400V'),
(308, 7, '6"WPS 16-20', 16.0, 20, '', 5.5, 7.5, 29.0, '3x400V'),
(309, 7, '6"WPS 16-25', 16.0, 25, '', 7.5, 10.0, 38.0, '3x400V'),
(310, 7, '6"WPS 16-30', 16.0, 30, '', 9.3, 12.5, 48.0, '3x400V'),
(311, 7, '6"WPS 16-35', 16.0, 35, '', 11.0, 15.0, 55.0, '3x400V'),
(312, 7, '6"WPS 16-40', 16.0, 40, '', 13.0, 17.5, 63.0, '3x400V'),
(313, 7, '6"WPS 16-45', 16.0, 45, '', 15.0, 20.0, 70.0, '3x400V'),
(314, 7, '6"WPS 16-50', 16.0, 50, '', 18.5, 25.0, 83.0, '3x400V'),
(315, 7, '6"WPS 16-55', 16.0, 55, '', 18.5, 25.0, 83.0, '3x400V'),
(316, 7, '6"WPS 16-60', 16.0, 60, '', 22.0, 30.0, 95.0, '3x400V');

-- ============================================================================
-- 6"WPS 16 PERFORMANCE DATA (Flow: 0, 4, 8, 12, 16, 20, 24, 28 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 6"WPS 16-3
(302, 0.0, 16), (302, 4.0, 15), (302, 8.0, 14), (302, 12.0, 13), (302, 16.0, 11), (302, 20.0, 9), (302, 24.0, 6), (302, 28.0, 3),
-- 6"WPS 16-5
(303, 0.0, 26), (303, 4.0, 25), (303, 8.0, 23), (303, 12.0, 21), (303, 16.0, 18), (303, 20.0, 14), (303, 24.0, 10), (303, 28.0, 5),
-- 6"WPS 16-7
(304, 0.0, 37), (304, 4.0, 36), (304, 8.0, 33), (304, 12.0, 30), (304, 16.0, 25), (304, 20.0, 20), (304, 24.0, 14), (304, 28.0, 7),
-- 6"WPS 16-10
(305, 0.0, 53), (305, 4.0, 51), (305, 8.0, 47), (305, 12.0, 42), (305, 16.0, 36), (305, 20.0, 29), (305, 24.0, 20), (305, 28.0, 10),
-- 6"WPS 16-14
(306, 0.0, 74), (306, 4.0, 71), (306, 8.0, 66), (306, 12.0, 59), (306, 16.0, 51), (306, 20.0, 40), (306, 24.0, 28), (306, 28.0, 14),
-- 6"WPS 16-17
(307, 0.0, 90), (307, 4.0, 86), (307, 8.0, 80), (307, 12.0, 72), (307, 16.0, 62), (307, 20.0, 49), (307, 24.0, 34), (307, 28.0, 17),
-- 6"WPS 16-20
(308, 0.0, 106), (308, 4.0, 102), (308, 8.0, 94), (308, 12.0, 84), (308, 16.0, 73), (308, 20.0, 58), (308, 24.0, 40), (308, 28.0, 20),
-- 6"WPS 16-25
(309, 0.0, 132), (309, 4.0, 127), (309, 8.0, 117), (309, 12.0, 105), (309, 16.0, 91), (309, 20.0, 72), (309, 24.0, 50), (309, 28.0, 25),
-- 6"WPS 16-30
(310, 0.0, 158), (310, 4.0, 152), (310, 8.0, 140), (310, 12.0, 126), (310, 16.0, 109), (310, 20.0, 87), (310, 24.0, 60), (310, 28.0, 30),
-- 6"WPS 16-35
(311, 0.0, 185), (311, 4.0, 178), (311, 8.0, 164), (311, 12.0, 148), (311, 16.0, 128), (311, 20.0, 101), (311, 24.0, 70), (311, 28.0, 35),
-- 6"WPS 16-40
(312, 0.0, 211), (312, 4.0, 203), (312, 8.0, 187), (312, 12.0, 169), (312, 16.0, 146), (312, 20.0, 116), (312, 24.0, 80), (312, 28.0, 40),
-- 6"WPS 16-45
(313, 0.0, 238), (313, 4.0, 228), (313, 8.0, 211), (313, 12.0, 190), (313, 16.0, 164), (313, 20.0, 130), (313, 24.0, 90), (313, 28.0, 45),
-- 6"WPS 16-50
(314, 0.0, 264), (314, 4.0, 254), (314, 8.0, 234), (314, 12.0, 211), (314, 16.0, 182), (314, 20.0, 145), (314, 24.0, 100), (314, 28.0, 50),
-- 6"WPS 16-55
(315, 0.0, 291), (315, 4.0, 279), (315, 8.0, 258), (315, 12.0, 232), (315, 16.0, 200), (315, 20.0, 159), (315, 24.0, 110), (315, 28.0, 55),
-- 6"WPS 16-60
(316, 0.0, 317), (316, 4.0, 305), (316, 8.0, 281), (316, 12.0, 253), (316, 16.0, 218), (316, 20.0, 174), (316, 24.0, 120), (316, 28.0, 60);

-- ============================================================================
-- 6"WPS 30 SERIES PUMP MODELS (10 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(317, 7, '6"WPS 30-3', 30.0, 3, '', 1.5, 2.0, 10.2, '3x400V'),
(318, 7, '6"WPS 30-5', 30.0, 5, '', 2.2, 3.0, 14.1, '3x400V'),
(319, 7, '6"WPS 30-7', 30.0, 7, '', 3.0, 4.0, 19.3, '3x400V'),
(320, 7, '6"WPS 30-10', 30.0, 10, '', 4.0, 5.5, 25.0, '3x400V'),
(321, 7, '6"WPS 30-13', 30.0, 13, '', 5.5, 7.5, 29.0, '3x400V'),
(322, 7, '6"WPS 30-16', 30.0, 16, '', 7.5, 10.0, 38.0, '3x400V'),
(323, 7, '6"WPS 30-19', 30.0, 19, '', 9.3, 12.5, 48.0, '3x400V'),
(324, 7, '6"WPS 30-22', 30.0, 22, '', 11.0, 15.0, 55.0, '3x400V'),
(325, 7, '6"WPS 30-25', 30.0, 25, '', 13.0, 17.5, 63.0, '3x400V'),
(326, 7, '6"WPS 30-30', 30.0, 30, '', 15.0, 20.0, 70.0, '3x400V');

-- ============================================================================
-- 6"WPS 30 PERFORMANCE DATA (Flow: 0, 5, 10, 15, 20, 25, 30, 35, 40, 45 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 6"WPS 30-3
(317, 0.0, 10), (317, 5.0, 10), (317, 10.0, 9), (317, 15.0, 9), (317, 20.0, 8), (317, 25.0, 7), (317, 30.0, 6), (317, 35.0, 5), (317, 40.0, 3), (317, 45.0, 1),
-- 6"WPS 30-5
(318, 0.0, 17), (318, 5.0, 17), (318, 10.0, 16), (318, 15.0, 15), (318, 20.0, 14), (318, 25.0, 12), (318, 30.0, 10), (318, 35.0, 8), (318, 40.0, 5), (318, 45.0, 2),
-- 6"WPS 30-7
(319, 0.0, 24), (319, 5.0, 23), (319, 10.0, 22), (319, 15.0, 21), (319, 20.0, 19), (319, 25.0, 17), (319, 30.0, 14), (319, 35.0, 11), (319, 40.0, 7), (319, 45.0, 3),
-- 6"WPS 30-10
(320, 0.0, 34), (320, 5.0, 33), (320, 10.0, 32), (320, 15.0, 30), (320, 20.0, 27), (320, 25.0, 24), (320, 30.0, 20), (320, 35.0, 16), (320, 40.0, 10), (320, 45.0, 4),
-- 6"WPS 30-13
(321, 0.0, 44), (321, 5.0, 43), (321, 10.0, 41), (321, 15.0, 39), (321, 20.0, 36), (321, 25.0, 31), (321, 30.0, 26), (321, 35.0, 21), (321, 40.0, 13), (321, 45.0, 5),
-- 6"WPS 30-16
(322, 0.0, 54), (322, 5.0, 53), (322, 10.0, 51), (322, 15.0, 48), (322, 20.0, 44), (322, 25.0, 38), (322, 30.0, 33), (322, 35.0, 26), (322, 40.0, 16), (322, 45.0, 6),
-- 6"WPS 30-19
(323, 0.0, 64), (323, 5.0, 63), (323, 10.0, 60), (323, 15.0, 57), (323, 20.0, 52), (323, 25.0, 46), (323, 30.0, 39), (323, 35.0, 31), (323, 40.0, 19), (323, 45.0, 7),
-- 6"WPS 30-22
(324, 0.0, 75), (324, 5.0, 73), (324, 10.0, 70), (324, 15.0, 66), (324, 20.0, 61), (324, 25.0, 53), (324, 30.0, 45), (324, 35.0, 36), (324, 40.0, 22), (324, 45.0, 9),
-- 6"WPS 30-25
(325, 0.0, 85), (325, 5.0, 83), (325, 10.0, 79), (325, 15.0, 75), (325, 20.0, 69), (325, 25.0, 60), (325, 30.0, 51), (325, 35.0, 40), (325, 40.0, 25), (325, 45.0, 10),
-- 6"WPS 30-30
(326, 0.0, 102), (326, 5.0, 100), (326, 10.0, 95), (326, 15.0, 90), (326, 20.0, 83), (326, 25.0, 72), (326, 30.0, 62), (326, 35.0, 48), (326, 40.0, 30), (326, 45.0, 12);

-- ============================================================================
-- 6"WPS 45 SERIES PUMP MODELS (11 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(327, 7, '6"WPS 45-2', 45.0, 2, '', 1.5, 2.0, 10.2, '3x400V'),
(328, 7, '6"WPS 45-3', 45.0, 3, '', 2.2, 3.0, 14.1, '3x400V'),
(329, 7, '6"WPS 45-4', 45.0, 4, '', 3.0, 4.0, 19.3, '3x400V'),
(330, 7, '6"WPS 45-5', 45.0, 5, '', 4.0, 5.5, 25.0, '3x400V'),
(331, 7, '6"WPS 45-7', 45.0, 7, '', 5.5, 7.5, 29.0, '3x400V'),
(332, 7, '6"WPS 45-9', 45.0, 9, '', 7.5, 10.0, 38.0, '3x400V'),
(333, 7, '6"WPS 45-11', 45.0, 11, '', 9.3, 12.5, 48.0, '3x400V'),
(334, 7, '6"WPS 45-13', 45.0, 13, '', 11.0, 15.0, 55.0, '3x400V'),
(335, 7, '6"WPS 45-15', 45.0, 15, '', 13.0, 17.5, 63.0, '3x400V'),
(336, 7, '6"WPS 45-18', 45.0, 18, '', 15.0, 20.0, 70.0, '3x400V'),
(337, 7, '6"WPS 45-20', 45.0, 20, '', 18.5, 25.0, 83.0, '3x400V');

-- ============================================================================
-- 6"WPS 45 PERFORMANCE DATA (Flow: 0, 10, 20, 30, 40, 50, 60, 70 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 6"WPS 45-2
(327, 0.0, 7), (327, 10.0, 7), (327, 20.0, 6), (327, 30.0, 6), (327, 40.0, 5), (327, 50.0, 4), (327, 60.0, 3), (327, 70.0, 1),
-- 6"WPS 45-3
(328, 0.0, 11), (328, 10.0, 10), (328, 20.0, 10), (328, 30.0, 9), (328, 40.0, 8), (328, 50.0, 6), (328, 60.0, 4), (328, 70.0, 2),
-- 6"WPS 45-4
(329, 0.0, 14), (329, 10.0, 14), (329, 20.0, 13), (329, 30.0, 12), (329, 40.0, 10), (329, 50.0, 8), (329, 60.0, 5), (329, 70.0, 2),
-- 6"WPS 45-5
(330, 0.0, 18), (330, 10.0, 17), (330, 20.0, 16), (330, 30.0, 15), (330, 40.0, 13), (330, 50.0, 10), (330, 60.0, 7), (330, 70.0, 3),
-- 6"WPS 45-7
(331, 0.0, 25), (331, 10.0, 24), (331, 20.0, 23), (331, 30.0, 21), (331, 40.0, 18), (331, 50.0, 14), (331, 60.0, 10), (331, 70.0, 4),
-- 6"WPS 45-9
(332, 0.0, 32), (332, 10.0, 31), (332, 20.0, 29), (332, 30.0, 27), (332, 40.0, 23), (332, 50.0, 18), (332, 60.0, 12), (332, 70.0, 5),
-- 6"WPS 45-11
(333, 0.0, 39), (333, 10.0, 38), (333, 20.0, 36), (333, 30.0, 33), (333, 40.0, 28), (333, 50.0, 22), (333, 60.0, 15), (333, 70.0, 7),
-- 6"WPS 45-13
(334, 0.0, 46), (334, 10.0, 45), (334, 20.0, 42), (334, 30.0, 39), (334, 40.0, 33), (334, 50.0, 26), (334, 60.0, 18), (334, 70.0, 8),
-- 6"WPS 45-15
(335, 0.0, 53), (335, 10.0, 51), (335, 20.0, 49), (335, 30.0, 45), (335, 40.0, 38), (335, 50.0, 30), (335, 60.0, 21), (335, 70.0, 9),
-- 6"WPS 45-18
(336, 0.0, 64), (336, 10.0, 62), (336, 20.0, 58), (336, 30.0, 54), (336, 40.0, 46), (336, 50.0, 36), (336, 60.0, 25), (336, 70.0, 11),
-- 6"WPS 45-20
(337, 0.0, 71), (337, 10.0, 69), (337, 20.0, 65), (337, 30.0, 60), (337, 40.0, 51), (337, 50.0, 40), (337, 60.0, 28), (337, 70.0, 12);

-- ============================================================================
-- 6"WPS 60 SERIES PUMP MODELS (10 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(338, 7, '6"WPS 60-2', 60.0, 2, '', 2.2, 3.0, 14.1, '3x400V'),
(339, 7, '6"WPS 60-3', 60.0, 3, '', 3.0, 4.0, 19.3, '3x400V'),
(340, 7, '6"WPS 60-4', 60.0, 4, '', 4.0, 5.5, 25.0, '3x400V'),
(341, 7, '6"WPS 60-5', 60.0, 5, '', 5.5, 7.5, 29.0, '3x400V'),
(342, 7, '6"WPS 60-7', 60.0, 7, '', 7.5, 10.0, 38.0, '3x400V'),
(343, 7, '6"WPS 60-9', 60.0, 9, '', 9.3, 12.5, 48.0, '3x400V'),
(344, 7, '6"WPS 60-11', 60.0, 11, '', 11.0, 15.0, 55.0, '3x400V'),
(345, 7, '6"WPS 60-13', 60.0, 13, '', 15.0, 20.0, 70.0, '3x400V'),
(346, 7, '6"WPS 60-15', 60.0, 15, '', 18.5, 25.0, 83.0, '3x400V'),
(347, 7, '6"WPS 60-18', 60.0, 18, '', 22.0, 30.0, 95.0, '3x400V');

-- ============================================================================
-- 6"WPS 60 PERFORMANCE DATA (Flow: 0, 10, 20, 30, 40, 50, 60, 70, 80, 90 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 6"WPS 60-2
(338, 0.0, 7), (338, 10.0, 7), (338, 20.0, 7), (338, 30.0, 6), (338, 40.0, 6), (338, 50.0, 5), (338, 60.0, 4), (338, 70.0, 3), (338, 80.0, 2), (338, 90.0, 1),
-- 6"WPS 60-3
(339, 0.0, 11), (339, 10.0, 11), (339, 20.0, 10), (339, 30.0, 10), (339, 40.0, 9), (339, 50.0, 8), (339, 60.0, 7), (339, 70.0, 5), (339, 80.0, 3), (339, 90.0, 1),
-- 6"WPS 60-4
(340, 0.0, 14), (340, 10.0, 14), (340, 20.0, 14), (340, 30.0, 13), (340, 40.0, 12), (340, 50.0, 10), (340, 60.0, 9), (340, 70.0, 7), (340, 80.0, 4), (340, 90.0, 2),
-- 6"WPS 60-5
(341, 0.0, 18), (341, 10.0, 18), (341, 20.0, 17), (341, 30.0, 16), (341, 40.0, 15), (341, 50.0, 13), (341, 60.0, 11), (341, 70.0, 8), (341, 80.0, 5), (341, 90.0, 2),
-- 6"WPS 60-7
(342, 0.0, 25), (342, 10.0, 25), (342, 20.0, 24), (342, 30.0, 23), (342, 40.0, 21), (342, 50.0, 18), (342, 60.0, 15), (342, 70.0, 12), (342, 80.0, 7), (342, 90.0, 3),
-- 6"WPS 60-9
(343, 0.0, 32), (343, 10.0, 32), (343, 20.0, 31), (343, 30.0, 29), (343, 40.0, 27), (343, 50.0, 24), (343, 60.0, 20), (343, 70.0, 15), (343, 80.0, 9), (343, 90.0, 4),
-- 6"WPS 60-11
(344, 0.0, 39), (344, 10.0, 39), (344, 20.0, 38), (344, 30.0, 36), (344, 40.0, 33), (344, 50.0, 29), (344, 60.0, 24), (344, 70.0, 18), (344, 80.0, 11), (344, 90.0, 5),
-- 6"WPS 60-13
(345, 0.0, 46), (345, 10.0, 46), (345, 20.0, 45), (345, 30.0, 42), (345, 40.0, 39), (345, 50.0, 34), (345, 60.0, 29), (345, 70.0, 22), (345, 80.0, 13), (345, 90.0, 5),
-- 6"WPS 60-15
(346, 0.0, 54), (346, 10.0, 53), (346, 20.0, 52), (346, 30.0, 49), (346, 40.0, 45), (346, 50.0, 39), (346, 60.0, 33), (346, 70.0, 25), (346, 80.0, 15), (346, 90.0, 6),
-- 6"WPS 60-18
(347, 0.0, 64), (347, 10.0, 64), (347, 20.0, 62), (347, 30.0, 59), (347, 40.0, 54), (347, 50.0, 47), (347, 60.0, 40), (347, 70.0, 30), (347, 80.0, 18), (347, 90.0, 7);

-- ============================================================================
-- 6"WPS 75 SERIES PUMP MODELS (9 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(348, 7, '6"WPS 75-2', 75.0, 2, '', 3.0, 4.0, 19.3, '3x400V'),
(349, 7, '6"WPS 75-3', 75.0, 3, '', 4.0, 5.5, 25.0, '3x400V'),
(350, 7, '6"WPS 75-4', 75.0, 4, '', 5.5, 7.5, 29.0, '3x400V'),
(351, 7, '6"WPS 75-5', 75.0, 5, '', 7.5, 10.0, 38.0, '3x400V'),
(352, 7, '6"WPS 75-7', 75.0, 7, '', 9.3, 12.5, 48.0, '3x400V'),
(353, 7, '6"WPS 75-9', 75.0, 9, '', 11.0, 15.0, 55.0, '3x400V'),
(354, 7, '6"WPS 75-11', 75.0, 11, '', 15.0, 20.0, 70.0, '3x400V'),
(355, 7, '6"WPS 75-13', 75.0, 13, '', 18.5, 25.0, 83.0, '3x400V'),
(356, 7, '6"WPS 75-15', 75.0, 15, '', 22.0, 30.0, 95.0, '3x400V');

-- ============================================================================
-- 6"WPS 75 PERFORMANCE DATA (Flow: 0, 15, 30, 45, 60, 75, 90, 105, 120 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 6"WPS 75-2
(348, 0.0, 7), (348, 15.0, 7), (348, 30.0, 6), (348, 45.0, 6), (348, 60.0, 5), (348, 75.0, 4), (348, 90.0, 3), (348, 105.0, 2), (348, 120.0, 1),
-- 6"WPS 75-3
(349, 0.0, 10), (349, 15.0, 10), (349, 30.0, 9), (349, 45.0, 9), (349, 60.0, 8), (349, 75.0, 6), (349, 90.0, 5), (349, 105.0, 3), (349, 120.0, 1),
-- 6"WPS 75-4
(350, 0.0, 13), (350, 15.0, 13), (350, 30.0, 12), (350, 45.0, 12), (350, 60.0, 10), (350, 75.0, 8), (350, 90.0, 6), (350, 105.0, 4), (350, 120.0, 2),
-- 6"WPS 75-5
(351, 0.0, 17), (351, 15.0, 16), (351, 30.0, 16), (351, 45.0, 15), (351, 60.0, 13), (351, 75.0, 11), (351, 90.0, 8), (351, 105.0, 5), (351, 120.0, 2),
-- 6"WPS 75-7
(352, 0.0, 23), (352, 15.0, 23), (352, 30.0, 22), (352, 45.0, 21), (352, 60.0, 18), (352, 75.0, 15), (352, 90.0, 11), (352, 105.0, 7), (352, 120.0, 3),
-- 6"WPS 75-9
(353, 0.0, 30), (353, 15.0, 29), (353, 30.0, 28), (353, 45.0, 27), (353, 60.0, 24), (353, 75.0, 19), (353, 90.0, 14), (353, 105.0, 9), (353, 120.0, 4),
-- 6"WPS 75-11
(354, 0.0, 36), (354, 15.0, 36), (354, 30.0, 34), (354, 45.0, 33), (354, 60.0, 29), (354, 75.0, 24), (354, 90.0, 18), (354, 105.0, 11), (354, 120.0, 5),
-- 6"WPS 75-13
(355, 0.0, 43), (355, 15.0, 42), (355, 30.0, 41), (355, 45.0, 39), (355, 60.0, 34), (355, 75.0, 28), (355, 90.0, 21), (355, 105.0, 13), (355, 120.0, 6),
-- 6"WPS 75-15
(356, 0.0, 50), (356, 15.0, 49), (356, 30.0, 47), (356, 45.0, 45), (356, 60.0, 40), (356, 75.0, 33), (356, 90.0, 25), (356, 105.0, 15), (356, 120.0, 7);

-- ============================================================================
-- 8"WPS 80 SERIES PUMP MODELS (10 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(357, 8, '8"WPS 80-1', 80.0, 1, '', 5.5, 7.5, 29.0, '3x400V'),
(358, 8, '8"WPS 80-2', 80.0, 2, '', 9.3, 12.5, 48.0, '3x400V'),
(359, 8, '8"WPS 80-3', 80.0, 3, '', 15.0, 20.0, 70.0, '3x400V'),
(360, 8, '8"WPS 80-4', 80.0, 4, '', 18.5, 25.0, 83.0, '3x400V'),
(361, 8, '8"WPS 80-5', 80.0, 5, '', 22.0, 30.0, 95.0, '3x400V'),
(362, 8, '8"WPS 80-6', 80.0, 6, '', 30.0, 40.0, 125.0, '3x400V'),
(363, 8, '8"WPS 80-7', 80.0, 7, '', 30.0, 40.0, 125.0, '3x400V'),
(364, 8, '8"WPS 80-8', 80.0, 8, '', 37.0, 50.0, 145.0, '3x400V'),
(365, 8, '8"WPS 80-9', 80.0, 9, '', 37.0, 50.0, 145.0, '3x400V'),
(366, 8, '8"WPS 80-10', 80.0, 10, '', 45.0, 60.0, 165.0, '3x400V');

-- ============================================================================
-- 8"WPS 80 PERFORMANCE DATA (Flow: 0, 20, 40, 60, 80, 100, 120 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 8"WPS 80-1
(357, 0.0, 9), (357, 20.0, 8), (357, 40.0, 8), (357, 60.0, 7), (357, 80.0, 6), (357, 100.0, 4), (357, 120.0, 2),
-- 8"WPS 80-2
(358, 0.0, 18), (358, 20.0, 17), (358, 40.0, 16), (358, 60.0, 14), (358, 80.0, 12), (358, 100.0, 8), (358, 120.0, 3),
-- 8"WPS 80-3
(359, 0.0, 27), (359, 20.0, 26), (359, 40.0, 24), (359, 60.0, 21), (359, 80.0, 17), (359, 100.0, 12), (359, 120.0, 5),
-- 8"WPS 80-4
(360, 0.0, 36), (360, 20.0, 34), (360, 40.0, 32), (360, 60.0, 28), (360, 80.0, 23), (360, 100.0, 16), (360, 120.0, 7),
-- 8"WPS 80-5
(361, 0.0, 45), (361, 20.0, 43), (361, 40.0, 40), (361, 60.0, 35), (361, 80.0, 29), (361, 100.0, 20), (361, 120.0, 9),
-- 8"WPS 80-6
(362, 0.0, 53), (362, 20.0, 51), (362, 40.0, 48), (362, 60.0, 42), (362, 80.0, 34), (362, 100.0, 24), (362, 120.0, 10),
-- 8"WPS 80-7
(363, 0.0, 62), (363, 20.0, 60), (363, 40.0, 56), (363, 60.0, 49), (363, 80.0, 40), (363, 100.0, 28), (363, 120.0, 12),
-- 8"WPS 80-8
(364, 0.0, 71), (364, 20.0, 68), (364, 40.0, 63), (364, 60.0, 56), (364, 80.0, 46), (364, 100.0, 32), (364, 120.0, 14),
-- 8"WPS 80-9
(365, 0.0, 80), (365, 20.0, 77), (365, 40.0, 71), (365, 60.0, 63), (365, 80.0, 52), (365, 100.0, 36), (365, 120.0, 16),
-- 8"WPS 80-10
(366, 0.0, 89), (366, 20.0, 85), (366, 40.0, 79), (366, 60.0, 70), (366, 80.0, 57), (366, 100.0, 40), (366, 120.0, 17);

-- ============================================================================
-- 8"WPS 100 SERIES PUMP MODELS (10 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(367, 8, '8"WPS 100-1', 100.0, 1, '', 5.5, 7.5, 29.0, '3x400V'),
(368, 8, '8"WPS 100-2', 100.0, 2, '', 11.0, 15.0, 55.0, '3x400V'),
(369, 8, '8"WPS 100-3', 100.0, 3, '', 15.0, 20.0, 70.0, '3x400V'),
(370, 8, '8"WPS 100-4', 100.0, 4, '', 22.0, 30.0, 95.0, '3x400V'),
(371, 8, '8"WPS 100-5', 100.0, 5, '', 26.0, 35.0, 110.0, '3x400V'),
(372, 8, '8"WPS 100-6', 100.0, 6, '', 30.0, 40.0, 125.0, '3x400V'),
(373, 8, '8"WPS 100-7', 100.0, 7, '', 37.0, 50.0, 145.0, '3x400V'),
(374, 8, '8"WPS 100-8', 100.0, 8, '', 37.0, 50.0, 145.0, '3x400V'),
(375, 8, '8"WPS 100-9', 100.0, 9, '', 45.0, 60.0, 165.0, '3x400V'),
(376, 8, '8"WPS 100-10', 100.0, 10, '', 45.0, 60.0, 165.0, '3x400V');

-- ============================================================================
-- 8"WPS 100 PERFORMANCE DATA (Flow: 0, 20, 40, 60, 80, 100, 120, 140, 160 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 8"WPS 100-1
(367, 0.0, 7), (367, 20.0, 7), (367, 40.0, 7), (367, 60.0, 6), (367, 80.0, 5), (367, 100.0, 4), (367, 120.0, 3), (367, 140.0, 2), (367, 160.0, 1),
-- 8"WPS 100-2
(368, 0.0, 15), (368, 20.0, 14), (368, 40.0, 13), (368, 60.0, 12), (368, 80.0, 11), (368, 100.0, 9), (368, 120.0, 7), (368, 140.0, 4), (368, 160.0, 1),
-- 8"WPS 100-3
(369, 0.0, 22), (369, 20.0, 21), (369, 40.0, 20), (369, 60.0, 18), (369, 80.0, 16), (369, 100.0, 13), (369, 120.0, 10), (369, 140.0, 6), (369, 160.0, 2),
-- 8"WPS 100-4
(370, 0.0, 29), (370, 20.0, 28), (370, 40.0, 27), (370, 60.0, 25), (370, 80.0, 22), (370, 100.0, 18), (370, 120.0, 13), (370, 140.0, 8), (370, 160.0, 2),
-- 8"WPS 100-5
(371, 0.0, 37), (371, 20.0, 35), (371, 40.0, 33), (371, 60.0, 31), (371, 80.0, 27), (371, 100.0, 22), (371, 120.0, 17), (371, 140.0, 10), (371, 160.0, 3),
-- 8"WPS 100-6
(372, 0.0, 44), (372, 20.0, 43), (372, 40.0, 40), (372, 60.0, 37), (372, 80.0, 33), (372, 100.0, 27), (372, 120.0, 20), (372, 140.0, 12), (372, 160.0, 3),
-- 8"WPS 100-7
(373, 0.0, 51), (373, 20.0, 50), (373, 40.0, 47), (373, 60.0, 43), (373, 80.0, 38), (373, 100.0, 31), (373, 120.0, 23), (373, 140.0, 14), (373, 160.0, 4),
-- 8"WPS 100-8
(374, 0.0, 59), (374, 20.0, 57), (374, 40.0, 54), (374, 60.0, 50), (374, 80.0, 43), (374, 100.0, 36), (374, 120.0, 27), (374, 140.0, 16), (374, 160.0, 4),
-- 8"WPS 100-9
(375, 0.0, 66), (375, 20.0, 64), (375, 40.0, 60), (375, 60.0, 56), (375, 80.0, 49), (375, 100.0, 40), (375, 120.0, 30), (375, 140.0, 18), (375, 160.0, 5),
-- 8"WPS 100-10
(376, 0.0, 73), (376, 20.0, 71), (376, 40.0, 67), (376, 60.0, 62), (376, 80.0, 54), (376, 100.0, 44), (376, 120.0, 33), (376, 140.0, 20), (376, 160.0, 5);

-- ============================================================================
-- 8"WPS 130 SERIES PUMP MODELS (8 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(377, 8, '8"WPS 130-1', 130.0, 1, '', 9.3, 12.5, 48.0, '3x400V'),
(378, 8, '8"WPS 130-2', 130.0, 2, '', 18.5, 25.0, 83.0, '3x400V'),
(379, 8, '8"WPS 130-3', 130.0, 3, '', 26.0, 35.0, 110.0, '3x400V'),
(380, 8, '8"WPS 130-4', 130.0, 4, '', 37.0, 50.0, 145.0, '3x400V'),
(381, 8, '8"WPS 130-5', 130.0, 5, '', 45.0, 60.0, 165.0, '3x400V'),
(382, 8, '8"WPS 130-6', 130.0, 6, '', 55.0, 75.0, 195.0, '3x400V'),
(383, 8, '8"WPS 130-7', 130.0, 7, '', 55.0, 75.0, 195.0, '3x400V'),
(384, 8, '8"WPS 130-8', 130.0, 8, '', 75.0, 100.0, 250.0, '3x400V');

-- ============================================================================
-- 8"WPS 130 PERFORMANCE DATA (Flow: 0, 30, 60, 90, 120, 150, 180, 200 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 8"WPS 130-1
(377, 0.0, 8), (377, 30.0, 8), (377, 60.0, 7), (377, 90.0, 6), (377, 120.0, 5), (377, 150.0, 4), (377, 180.0, 2), (377, 200.0, 1),
-- 8"WPS 130-2
(378, 0.0, 16), (378, 30.0, 15), (378, 60.0, 14), (378, 90.0, 13), (378, 120.0, 11), (378, 150.0, 8), (378, 180.0, 4), (378, 200.0, 2),
-- 8"WPS 130-3
(379, 0.0, 24), (379, 30.0, 23), (379, 60.0, 21), (379, 90.0, 19), (379, 120.0, 16), (379, 150.0, 12), (379, 180.0, 7), (379, 200.0, 3),
-- 8"WPS 130-4
(380, 0.0, 32), (380, 30.0, 31), (380, 60.0, 29), (380, 90.0, 25), (380, 120.0, 21), (380, 150.0, 16), (380, 180.0, 9), (380, 200.0, 4),
-- 8"WPS 130-5
(381, 0.0, 40), (381, 30.0, 39), (381, 60.0, 36), (381, 90.0, 32), (381, 120.0, 27), (381, 150.0, 20), (381, 180.0, 11), (381, 200.0, 5),
-- 8"WPS 130-6
(382, 0.0, 48), (382, 30.0, 46), (382, 60.0, 43), (382, 90.0, 38), (382, 120.0, 32), (382, 150.0, 24), (382, 180.0, 14), (382, 200.0, 6),
-- 8"WPS 130-7
(383, 0.0, 56), (383, 30.0, 54), (383, 60.0, 50), (383, 90.0, 44), (383, 120.0, 37), (383, 150.0, 28), (383, 180.0, 16), (383, 200.0, 7),
-- 8"WPS 130-8
(384, 0.0, 64), (384, 30.0, 62), (384, 60.0, 57), (384, 90.0, 51), (384, 120.0, 42), (384, 150.0, 32), (384, 180.0, 18), (384, 200.0, 8);

-- ============================================================================
-- 8"WPS 150 SERIES PUMP MODELS (8 models total)
-- ============================================================================

INSERT INTO wps_pump_models (id, family_id, model_name, rated_flow, stages, variant, power_kw, power_hp, full_load_current, voltage) VALUES
(385, 8, '8"WPS 150-1', 150.0, 1, '', 11.0, 15.0, 55.0, '3x400V'),
(386, 8, '8"WPS 150-2', 150.0, 2, '', 22.0, 30.0, 95.0, '3x400V'),
(387, 8, '8"WPS 150-3', 150.0, 3, '', 30.0, 40.0, 125.0, '3x400V'),
(388, 8, '8"WPS 150-4', 150.0, 4, '', 45.0, 60.0, 165.0, '3x400V'),
(389, 8, '8"WPS 150-5', 150.0, 5, '', 55.0, 75.0, 195.0, '3x400V'),
(390, 8, '8"WPS 150-6', 150.0, 6, '', 55.0, 75.0, 195.0, '3x400V'),
(391, 8, '8"WPS 150-7', 150.0, 7, '', 75.0, 100.0, 250.0, '3x400V'),
(392, 8, '8"WPS 150-8', 150.0, 8, '', 75.0, 100.0, 250.0, '3x400V');

-- ============================================================================
-- 8"WPS 150 PERFORMANCE DATA (Flow: 0, 30, 60, 90, 120, 150, 180, 210, 240 m³/h)
-- ============================================================================

INSERT INTO wps_pump_performance (model_id, flow_rate, head) VALUES
-- 8"WPS 150-1
(385, 0.0, 7), (385, 30.0, 7), (385, 60.0, 6), (385, 90.0, 6), (385, 120.0, 5), (385, 150.0, 4), (385, 180.0, 3), (385, 210.0, 2), (385, 240.0, 1),
-- 8"WPS 150-2
(386, 0.0, 14), (386, 30.0, 13), (386, 60.0, 12), (386, 90.0, 11), (386, 120.0, 10), (386, 150.0, 8), (386, 180.0, 6), (386, 210.0, 4), (386, 240.0, 1),
-- 8"WPS 150-3
(387, 0.0, 21), (387, 30.0, 20), (387, 60.0, 19), (387, 90.0, 17), (387, 120.0, 15), (387, 150.0, 12), (387, 180.0, 9), (387, 210.0, 6), (387, 240.0, 2),
-- 8"WPS 150-4
(388, 0.0, 28), (388, 30.0, 27), (388, 60.0, 25), (388, 90.0, 23), (388, 120.0, 20), (388, 150.0, 16), (388, 180.0, 12), (388, 210.0, 8), (388, 240.0, 2),
-- 8"WPS 150-5
(389, 0.0, 35), (389, 30.0, 34), (389, 60.0, 32), (389, 90.0, 29), (389, 120.0, 25), (389, 150.0, 20), (389, 180.0, 15), (389, 210.0, 10), (389, 240.0, 3),
-- 8"WPS 150-6
(390, 0.0, 42), (390, 30.0, 41), (390, 60.0, 38), (390, 90.0, 34), (390, 120.0, 30), (390, 150.0, 24), (390, 180.0, 18), (390, 210.0, 12), (390, 240.0, 3),
-- 8"WPS 150-7
(391, 0.0, 49), (391, 30.0, 47), (391, 60.0, 44), (391, 90.0, 40), (391, 120.0, 35), (391, 150.0, 28), (391, 180.0, 21), (391, 210.0, 14), (391, 240.0, 4),
-- 8"WPS 150-8
(392, 0.0, 56), (392, 30.0, 54), (392, 60.0, 50), (392, 90.0, 46), (392, 120.0, 40), (392, 150.0, 32), (392, 180.0, 24), (392, 210.0, 16), (392, 240.0, 4);
