-- Sun Rubber Industry Sdn. Bhd. - Full Database Setup
-- Generated for cPanel Deployment
-- Date: 2026-05-02T09:56:47.388Z

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- Sun Rubber Database Schema for cPanel (MySQL/MariaDB)

-- 1. Pattern Groups (For Products)
CREATE TABLE IF NOT EXISTS pattern_groups (
    id VARCHAR(50) PRIMARY KEY,
    pattern_family VARCHAR(100),
    description JSON,
    tyre_position JSON,
    application JSON,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- 2. Products
CREATE TABLE IF NOT EXISTS products (
    id VARCHAR(100) PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    pattern_group_id VARCHAR(50),
    width DOUBLE,
    thickness DOUBLE,
    rim_diameter DOUBLE,
    weight DOUBLE,
    image VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (pattern_group_id) REFERENCES pattern_groups(id) ON DELETE SET NULL
);

-- 3. R&D Equipment
CREATE TABLE IF NOT EXISTS rd_equipment (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    standard VARCHAR(100),
    icon VARCHAR(50),
    image VARCHAR(255),
    description TEXT,
    category VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- 4. News
CREATE TABLE IF NOT EXISTS news (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    category VARCHAR(100),
    date_label VARCHAR(50), -- e.g. "FEB 2026"
    excerpt TEXT,
    content JSON, -- Array of paragraphs
    image VARCHAR(255),
    author VARCHAR(100) DEFAULT 'Sun Rubber Team',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- 5. Enquiries (Existing structure)
CREATE TABLE IF NOT EXISTS enquiries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255),
    phone VARCHAR(50),
    company VARCHAR(255),
    country VARCHAR(100),
    subject VARCHAR(255),
    message TEXT,
    product_context JSON,
    status VARCHAR(50) DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);


-- Clear existing data
TRUNCATE TABLE news;
TRUNCATE TABLE rd_equipment;
TRUNCATE TABLE products;
TRUNCATE TABLE pattern_groups;
SET FOREIGN_KEY_CHECKS = 1;

-- Seeding Pattern Groups & Products
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('ES', 'rib', '["Longitudinal rib with 2 round shoulder","For all wheel positions of touring coaches, city and articulated buses, trucks, trailers and minibuses","Good traction on wet and dry roads due to deep sipes","Low noise and smooth running","High mileage performance"]', '["D","T","A"]', '["R"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('es-195', 'ES-195', 'ES', 195, 14, 3190, 3.26, '/images/frPg16-18/ES.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('es-203', 'ES-203', 'ES', 203, 15, 3220, 3.26, '/images/frPg16-18/ES.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('es-210-1', 'ES-210.1', 'ES', 210, 15, 3280, 3.41, '/images/frPg16-18/ES.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('es-216-3', 'ES-216.3', 'ES', 216, 15, 3740, 3.84, '/images/frPg16-18/ES.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('es-230', 'ES-230', 'ES', 230, 16, 3270, 4.19, '/images/frPg16-18/ES.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('es-245-3', 'ES-245.3', 'ES', 245, 16, 3310, 4.53, '/images/frPg16-18/ES.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('es-245-4', 'ES-245.4', 'ES', 245, 16, 3820, 4.5, '/images/frPg16-18/ES.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('JH', 'rib', '["Longitudinal tread with continuous round shoulder","For use on trailer, semi-trailer and trailing axles","Directionally stable due to large contact area","Smooth running","Fuel saving and low rolling resistance"]', '["T"]', '["H","R"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('jh-160', 'JH-160', 'JH', 160, 15, 2710, 2.58, '/images/frPg8-12/JH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('jh-185', 'JH-185', 'JH', 185, 15, 2800, 3.29, '/images/frPg8-12/JH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('jh-205-1', 'JH-205.1', 'JH', 205, 16, 3320, 4.55, '/images/frPg8-12/JH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('jh-213', 'JH-213', 'JH', 213, 17, 3390, 4.42, '/images/frPg8-12/JH.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('RH', 'rib', '["Longitudinal tread with continuous round shoulder","For trailer, semi-trailer and trailing axles","Directionally stable due to large contact area","Smooth running","Fuel saving and low rolling resistance"]', '["D","T"]', '["H"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rh-142', 'RH-142', 'RH', 142, 13, 2440, 2.21, '/images/frPg1-7/RH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rh-142-7m', 'RH-142(7M)', 'RH', 142, 13, 6880, 2.12, '/images/frPg1-7/RH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rh-152', 'RH-152', 'RH', 152, 12, 2440, 2.09, '/images/frPg1-7/RH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rh-162', 'RH-162', 'RH', 162, 12, 2440, 2.23, '/images/frPg1-7/RH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rh-170', 'RH-170', 'RH', 170, 12, 2610, 2.34, '/images/frPg1-7/RH.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('RP', 'rib', '["Longitudinal rib with round shoulder","For trailer, semi-trailer and trailing axles","For short and long distance use","High resistance to lateral shearing force due to rounded shoulder","Low stress on casing due to minimal tread movement and crown running"]', '["D","T","A"]', '["H","R","U"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-194', 'RP 194', 'RP', 194, 15, 3200, 2.92, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-194-2', 'RP 194.2', 'RP', 194, 15, 2480, 2.86, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-203', 'RP 203', 'RP', 203, 16, 3090, 3.59, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-203-1', 'RP 203.1', 'RP', 203, 16, 3250, 3.98, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-210', 'RP 210', 'RP', 210, 16, 3240, 3.5, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-220-3', 'RP 220.3', 'RP', 220, 16, 3250, 4.06, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-220-4', 'RP 220.4', 'RP', 220, 16, 3750, 3.65, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-230-3', 'RP 230.3', 'RP', 230, 16, 3250, 4, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-230-1-h', 'RP 230.1(H)', 'RP', 230, 18, 3450, 4.66, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-240-1', 'RP 240.1', 'RP', 240, 17, 3080, 4.1, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-240-h', 'RP 240(H)', 'RP', 240, 18, 3440, 4.91, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-250', 'RP 250', 'RP', 250, 18, 3250, 4.89, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-250-4', 'RP 250.4', 'RP', 250, 18, 3770, 4.86, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-260-2', 'RP 260.2', 'RP', 260, 17.5, 3080, 5.58, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-260-4', 'RP 260.4', 'RP', 260, 17.5, 3750, 5.49, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-265', 'RP 265', 'RP', 265, 18, 3260, 5.18, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('S-10', 'rib', '["Longitudinal ribs pattern with open shoulder","For drive axle of city buses and trucks","All round pattern for construction site vehicles","For short and long range use","Good traction on paved roads and off road","Resistant to wear and cuts due to specially formulated compound","Good self cleaning due to open tread design","Directionally stable"]', '["D"]', '["R","U"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s10-194', 'S10-194', 'S-10', 194, 13, 3180, 2.99, '/images/frPg8-12/S-10.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s10-203', 'S10-203', 'S-10', 203, 14, 3240, 3.15, '/images/frPg8-12/S-10.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('S-150', 'rib', '["Exceptional mileage","Resistance to irregular wear","Represents exceptional value for fleets with effective maintenance practices"]', '["T"]', '["H"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s150-210', 'S150-210', 'S-150', 210, 15, 3190, 3.76, '/images/frPg1-7/S150.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s150-220', 'S150-220', 'S-150', 220, 15, 3190, 3.92, '/images/frPg1-7/S150.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s150-230', 'S150-230', 'S-150', 230, 15, 3220, 3.88, '/images/frPg1-7/S150.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s150-240-a', 'S150-240 A', 'S-150', 240, 16, 3060, 4.64, '/images/frPg1-7/S150.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s150-250', 'S150-250', 'S-150', 250, 16, 3250, 4.68, '/images/frPg1-7/S150.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s150-260', 'S150-260', 'S-150', 260, 16, 3270, 4.8, '/images/frPg1-7/S150.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('S85', 'rib', '["Solid block type tread with open shoulder","For drive axles of trucks","For long haul and short haul","All season tread pattern with superior traction and braking on wet and slippery roads","Good transmission","Extreme good running properties due to extra large contact area and specifically designed formula"]', '["D","T","A"]', '["H"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s85-210', 'S85-210', 'S85', 210, 16, 3200, 3.65, '/images/frPg1-7/S85.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s85-220', 'S85-220', 'S85', 220, 16, 3250, 3.72, '/images/frPg1-7/S85.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s85-230', 'S85-230', 'S85', 230, 16, 3250, 4.03, '/images/frPg1-7/S85.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('S88', 'rib', '["Ribbed tread with continuous rounded shoulder","For all wheel positions of tour bus","For trailer, semi-trailer and trailing axles and for all wheel positions of touring coaches, city and articulate buses, trucks and light trucks, vans and mini-buses","For short and long range use","Good traction on wet and dry roads due to distinct sipes","Grooves designed to resist stone penetration and casing damage"]', '["D","T","A"]', '["H","R"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s88-203', 'S88-203', 'S88', 203, 17, 3350, 3.55, '/images/frPg1-7/S88.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s88-215', 'S88-215', 'S88', 215, 17, 3310, 3.95, '/images/frPg1-7/S88.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s88-230', 'S88-230', 'S88', 230, 17, 3370, 4.18, '/images/frPg1-7/S88.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s88-245-n', 'S88-245 (N)', 'S88', 245, 17, 3200, 5.18, '/images/frPg1-7/S88.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SH', 'rib', '["Ribbed tread with continuous round shoulder","For all wheel positions of tour coach, city and articulate bus, truck, light truck, van and mini-buses","For trailer, semi-trailer and trailing axles","Smooth running - semi trailer"]', '["D","T","A"]', '["H","R"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-130', 'SH 130', 'SH', 130, 13, 2550, 1.88, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-140', 'SH 140', 'SH', 140, 13, 2450, 2.16, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-152-1', 'SH 152.1', 'SH', 152, 14, 2450, 2.37, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-180', 'SH 180', 'SH', 180, 15, 2570, 3.04, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-194', 'SH 194', 'SH', 194, 15, 3360, 3.24, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-194-11m', 'SH 194 (11M)', 'SH', 194, 15, 10470, 3.3, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-205', 'SH 205', 'SH', 205, 15.5, 3270, 3.61, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-210', 'SH 210', 'SH', 210, 15, 3240, 3.48, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-210-11m', 'SH 210 (11M)', 'SH', 210, 15, 10470, 3.61, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-220-1', 'SH 220.1', 'SH', 220, 15, 3170, 3.72, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-220-3', 'SH 220.3', 'SH', 220, 15, 3730, 3.76, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-220-11m', 'SH 220 (11M)', 'SH', 220, 15, 10410, 3.66, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-225', 'SH 225', 'SH', 220, 15, 3750, 3.85, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-225-1', 'SH 225.1', 'SH', 225, 15, 3210, 3.89, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-230-2', 'SH 230.2', 'SH', 225, 15, 3180, 3.93, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-230-c', 'SH 230 (C)', 'SH', 230, 15, 3440, 4.13, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-240', 'SH 240', 'SH', 240, 15, 3790, 3.9, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-240-4', 'SH 240.4', 'SH', 240, 15, 3750, 3.87, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-240-c', 'SH 240 (C)', 'SH', 240, 15, 3440, 4.27, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sh-250-2', 'SH 250.2', 'SH', 250, 15, 3230, 4.27, '/images/frPg8-12/SH.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SQH', 'rib', '["Ribbed pattern with continuous round shoulder","For used on trailer, semi-trailer and trailing axles and all wheel positions of touring coaches, city and articulate buses, truck, light truck, vans and minibuses","For short and long range use","Lighter tread","Smooth running and high mileage"]', '["D","T","A"]', '["H","R","U"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sqh-207-3', 'SQH 207.3', 'SQH', 207, 13, 3180, 3.14, '/images/frPg8-12/SQH.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SQH-RS', 'rib', '["Ribbed pattern with continuous round shoulder","For used on trailer, semi-trailer and trailing axles and all wheel positions of touring coaches, city and articulate buses, truck, light truck, vans and minibuses","For short and long range use","Lighter tread","Smooth running and high mileage","Suitable for bias tyre"]', '["D","T","A"]', '["H","R","U"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sqh-rs-140-3', 'SQH 140.3', 'SQH-RS', 140, 11, 2190, 2, '/images/frPg8-12/SQH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sqh-rs-152', 'SQH 152', 'SQH-RS', 152, 11, 2420, 2.02, '/images/frPg8-12/SQH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sqh-rs-160', 'SQH 160', 'SQH-RS', 160, 13, 2530, 2.53, '/images/frPg8-12/SQH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sqh-rs-179r-3', 'SQH 179R.3', 'SQH-RS', 179, 13, 3120, 2.69, '/images/frPg8-12/SQH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sqh-rs-194-1', 'SQH 194.1', 'SQH-RS', 194, 13, 3310, 3.02, '/images/frPg8-12/SQH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sqh-rs-194-11m', 'SQH 194 (11M)', 'SQH-RS', 194, 13, 10550, 3.02, '/images/frPg8-12/SQH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sqh-rs-210-1', 'SQH 210.1', 'SQH-RS', 210, 14, 3170, 3.5, '/images/frPg8-12/SQH.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sqh-rs-216-1', 'SQH 216.1', 'SQH-RS', 216, 14, 3180, 3.52, '/images/frPg8-12/SQH.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SR34', 'rib', '["Longitude ribs with round shoulder","For used on drive axle of city bus and trucks","For use on trailer, semi-trailer and trailing axles","For all wheel positions of construction vehicles","All round performance","Good transmission for traction forces on pave roads and off roads","Good self cleaning due to open tread design","High Mileage","Directional stable","Suitable for use on low noise vehicles"]', '["D","A"]', '["R","U"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sr34-194-1', 'SR34-194.1', 'SR34', 194, 15, 3290, 3.1, '/images/frPg8-12/SR34.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sr34-210', 'SR34-210', 'SR34', 210, 15, 3170, 3.5, '/images/frPg8-12/SR34.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sr34-216', 'SR34-216', 'SR34', 216, 17, 3250, 3.93, '/images/frPg8-12/SR34.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sr34-220', 'SR34-220', 'SR34', 220, 15, 3230, 3.62, '/images/frPg8-12/SR34.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sr34-230-1', 'SR34-230.1', 'SR34', 230, 17, 3200, 4.13, '/images/frPg8-12/SR34.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sr34-240', 'SR34-240', 'SR34', 240, 15, 3230, 4.24, '/images/frPg8-12/SR34.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sr34-245', 'SR34-245', 'SR34', 245, 17, 3260, 4.36, '/images/frPg8-12/SR34.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sr34-250', 'SR34-250', 'SR34', 250, 15, 3250, 4.65, '/images/frPg8-12/SR34.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SZE2', 'rib', '["Solid block type tread with open shoulder","For drive axles of trucks","For long haul and short haul","All season tread pattern with superior traction and braking on wet and slippery road","Good transmission","Extreme good running properties due to extra large contact area and specifically designed formula"]', '["D","T"]', '["H"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sze2-240-11m', 'SZE2-240 (11M)', 'SZE2', 240, 15, 10050, 4.28, '/images/frPg1-7/SZE2.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sze2-250-11m', 'SZE2-250 (11M)', 'SZE2', 250, 15, 10050, 4.48, '/images/frPg1-7/SZE2.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sze2-260-11m', 'SZE2-260 (11M)', 'SZE2', 260, 15, 10050, 4.71, '/images/frPg1-7/SZE2.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sze2-270-11m', 'SZE2-270 (11M)', 'SZE2', 270, 15, 10050, 4.84, '/images/frPg1-7/SZE2.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('XZY', 'rib', '["Longitude ribs with round shoulder","For use on drive axles of city bus and trucks","For use on trailer, semi-trailer and trailing axles","For all wheel positions of construction vehicles","All round performance","Good transmission for traction forces on pave roads and off roads","Good self cleaning due to open treads design","High mileage performance","Directional stable"]', '["D","T"]', '["H","R","U"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('xzy-194', 'XZY 194', 'XZY', 194, 15, 3170, 3.47, '/images/frPg8-12/XZY.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('xzy-203-2', 'XZY 203.2', 'XZY', 203, 15, 3220, 3.56, '/images/frPg8-12/XZY.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('xzy-210', 'XZY 210', 'XZY', 210, 15, 3750, 3.79, '/images/frPg8-12/XZY.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('xzy-210-1', 'XZY 210.1', 'XZY', 210, 15, 3250, 3.75, '/images/frPg8-12/XZY.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('xzy-215-2', 'XZY 215.2', 'XZY', 215, 15, 3230, 3.81, '/images/frPg8-12/XZY.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('xzy-215-3', 'XZY 215.3', 'XZY', 215, 15, 3770, 3.97, '/images/frPg8-12/XZY.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('xzy-230-1', 'XZY 230.1', 'XZY', 230, 15, 3790, 4.2, '/images/frPg8-12/XZY.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('xzy-230-4', 'XZY 230.4', 'XZY', 230, 15, 3300, 4.2, '/images/frPg8-12/XZY.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('xzy-245-n', 'XZY 245 N', 'XZY', 245, 15, 3360, 4.55, '/images/frPg8-12/XZY.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('xzy-260', 'XZY 260', 'XZY', 260, 15, 3290, 4.71, '/images/frPg8-12/XZY.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('DS', 'semi', '["Longitudinal block tyre with open shoulders","For drive axle of city buses and trucks","All season tread","Straight-running stability due to longitudinal tread bars","Smooth running","Good traction properties","Good running properties"]', '["D","A"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ds-142', 'DS-142', 'DS', 142, 13, 2440, 2.05, '/images/frPg1-7/DS.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ds-152', 'DS-152', 'DS', 152, 13, 2430, 2.25, '/images/frPg1-7/DS.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ds-162', 'DS-162', 'DS', 162, 13, 2560, 2.28, '/images/frPg1-7/DS.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ds-162-7m', 'DS-162(7M)', 'DS', 162, 13, 6880, 2.32, '/images/frPg1-7/DS.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ds-195', 'DS-195', 'DS', 195, 16, 3130, 3.26, '/images/frPg1-7/DS.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('KT', 'semi', '["Longitudinal rib in center with shoulder block","For drive axles of construction & special vehicles","Good transmission of traction forces on wet and dry road as well for off-road","Good self cleaning as a result of open tread","Very good straight running stability"]', '["D"]', '["R"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-180', 'KT-180', 'KT', 180, 16, 3075, 2.93, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-194', 'KT-194', 'KT', 194, 16, 3070, 3.3, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-194-11m', 'KT-194 (11M)', 'KT', 194, 16, 10620, 3.3, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-203', 'KT-203', 'KT', 203, 16, 3210, 3.49, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-208', 'KT-208', 'KT', 208, 16, 3160, 3, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-208-1', 'KT-208.1', 'KT', 208, 16, 3220, 3.07, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-216', 'KT-216', 'KT', 216, 16, 3220, 3.78, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-216-2', 'KT-216.2', 'KT', 216, 16, 3750, 3.78, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-230-n', 'KT-230 (N)', 'KT', 230, 17, 3250, 4.15, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-230-2-n', 'KT-230.2 (N)', 'KT', 230, 17, 2660, 4.17, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-245', 'KT-245', 'KT', 245, 16, 3240, 4.01, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('kt-245-1', 'KT-245.1', 'KT', 245, 16, 3070, 4.1, '/images/frPg1-7/KT.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('M810', 'semi', '["All position diagonal block pattern with excellent traction and self cleaning ability","A special, cut-resistant compound makes this pattern particularly suited for use on vehicles in more severe operations, such as waste disposal and logging","Diagonal blocks - good traction","Open tread design - very good self cleaning ability","Cut resistant compound - increased resistance to cutting and chipping"]', '["D","A"]', '["R","O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('m810-168-1', 'M810-168.1', 'M810', 168, 16, 2825, 2.9, '/images/frPg1-7/M810G.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('m810-185', 'M810-185', 'M810', 185, 17, 2590, 3.12, '/images/frPg1-7/M810G.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('M810E', 'semi', '["All position diagonal block pattern with excellent traction and self cleaning ability","A special, cut-resistant compound makes this pattern particularly suited for use on vehicles in more severe operations, such as waste disposal and logging","Diagonal blocks - good traction","Open tread design - very good self cleaning ability","Cut resistant compound - increased resistance to cutting and chipping"]', '["D","A"]', '["R","O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('m810e-160-1', 'M810E-160.1', 'M810E', 160, 16.5, 2490, 2.94, '/images/frPg1-7/M810EH.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('M880', 'semi', '["All position diagonal block pattern with excellent traction and self cleaning ability","A special, cut-resistant compound makes this pattern particularly suited for use on vehicles in more severe operations, such as waste disposal and logging","Diagonal blocks - good traction","Open tread design - very good self cleaning ability","Cut resistant compound - increased resistance to cutting and chipping"]', '["D"]', '["R","O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('m880-215-2', 'M880-215.2', 'M880', 215, 17, 3150, 4.16, '/images/frPg1-7/M880.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('m880-240-1', 'M880-240.1', 'M880', 240, 17, 3120, 4.35, '/images/frPg1-7/M880.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('MIX757', 'semi', '["Longitudinal block type tread with closed shoulders","For drive axle of trucks","For short range use, especially on construction sites","Directionally stable due to closed shoulders","Very good self cleaning as a result of distinct conical profile blocks","Good transmission of traction forces due to solid blocks in centre of tread"]', '["D"]', '["R"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('mix757-212', 'MIX 757-212', 'MIX757', 210, 16, 3350, 3.55, '/images/frPg1-7/MIX757.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('mix757-220', 'MIX 757-220', 'MIX757', 220, 16, 3760, 3.99, '/images/frPg1-7/MIX757.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('mix757-230', 'MIX 757-230', 'MIX757', 230, 16, 3740, 4.06, '/images/frPg1-7/MIX757.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('mix757-240', 'MIX 757-240', 'MIX757', 240, 16, 3250, 4.12, '/images/frPg1-7/MIX757.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('mix757-245', 'MIX 757-245', 'MIX757', 245, 16, 3350, 4, '/images/frPg1-7/MIX757.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('S119', 'semi', '["Solid block type tread with open shoulder","For drive axles of trucks","For long haul and short haul","All season tread pattern with superior traction and braking on wet and slippery roads","Good transmission","Extreme good running properties due to extra large contact area and specifically designed formula"]', '["D"]', '["H","R"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s119-240-1', 'S119-240.1', 'S119', 240, 19, 3250, 5.05, '/images/frPg1-7/S119.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s199-250', 'S199-250', 'S119', 250, 20, 3290, 5.47, '/images/frPg1-7/S119.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s199-260', 'S199-260', 'S119', 260, 20, 3290, 5.62, '/images/frPg1-7/S119.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('S33', 'semi', '["Design as all position tyre for on/off road surface","Provide overall excellent performance and durability","Wider tread and complex groove angles offer enhance tyre life with superior resistance to irregular wear"]', '["D","A"]', '["R","U"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s33-240', 'S33-240', 'S33', 240, 18.5, 3140, 5.19, '/images/frPg16-18/s33.png');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('S722', 'semi', '["Large block tread","Deep traction drive pattern","Resistant to irregular wear","Resist stone penetration and retention"]', '["D"]', '["R","O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s722-230', 'S722-230', 'S722', 230, 16, 3280, 4.24, '/images/frPg1-7/S722.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s722-242', 'S722-242', 'S722', 242, 17, 3300, 4.48, '/images/frPg1-7/S722.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s722-252', 'S722-252', 'S722', 252, 17, 3240, 4.72, '/images/frPg1-7/S722.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('s722-265', 'S722-265', 'S722', 265, 17, 3300, 5.33, '/images/frPg1-7/S722.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SDE', 'semi', '["Solid block type tread with open shoulder","For drive axles of trucks","For long haul and short haul","All season tread pattern with superior traction and braking on wet and slippery roads","Good transmission","Extreme good running properties due to extra large contact area and specifically designed formula"]', '["D"]', '["R"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-220', 'SDE-220', 'SDE', 220, 15, 3770, 3.61, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-220-1', 'SDE-220.1', 'SDE', 220, 15, 3240, 3.6, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-225', 'SDE-225', 'SDE', 225, 15, 3740, 3.88, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-225-1', 'SDE-225.1', 'SDE', 225, 15, 3250, 3.9, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-230', 'SDE-230', 'SDE', 230, 16, 3280, 3.96, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-230-1', 'SDE-230.1', 'SDE', 230, 16, 3740, 3.95, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-230-h', 'SDE-230 (H)', 'SDE', 230, 18.5, 3270, 4.62, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-230-1-h', 'SDE-230.1 (H)', 'SDE', 230, 18.5, 3150, 4.71, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-240', 'SDE-240', 'SDE', 240, 19, 3330, 5.2, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-245', 'SDE-245', 'SDE', 245, 18, 3320, 3.98, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-250-1', 'SDE-250.1', 'SDE', 250, 19, 3290, 5.17, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-260', 'SDE-260', 'SDE', 260, 18.5, 3300, 4.88, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sde-270', 'SDE-270', 'SDE', 270, 19, 3360, 5.62, '/images/frPg16-18/SDE.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SDY3', 'semi', '["Good handling and high haulage in dry and wet condition","High lateral skid prevention capability, good handling stability","High comfort on travel, low noise emissions, low fuel consumption","Tread design provide excellent high-speed performance and great traction","Good mileage performance"]', '["D"]', '["R","O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sdy3-240-n', 'SDY3-240 (N)', 'SDY3', 240, 19, 3380, 5.06, '/images/frPg16-18/SDY3.jpg');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sdy3-250', 'SDY3-250', 'SDY3', 250, 19, 3360, 5, '/images/frPg16-18/SDY3.jpg');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sdy3-260-1', 'SDY3-260.1', 'SDY3', 260, 19, 3320, 5.36, '/images/frPg16-18/SDY3.jpg');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SGP', 'semi', '["Block pattern with offset shoulder block","Good self-cleaning with open shoulder block","Good traction on wet and dry surfaces","All-position tyre for short and long-range operations","Tough compound for all kinds of on/off roads"]', '["D"]', '["W"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sgp-150-10m', 'SGP-150 (10M)', 'SGP', 150, 12, 10260, 1.92, '/images/frPg13-15/SGP.png');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sgp-160-10m', 'SGP-160 (10M)', 'SGP', 160, 12, 10200, 2.11, '/images/frPg13-15/SGP.png');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sgp-170-10m', 'SGP-170 (10M)', 'SGP', 170, 12, 10230, 2.27, '/images/frPg13-15/SGP.png');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sgp-180-10m', 'SGP-180 (10M)', 'SGP', 180, 13, 10170, 2.56, '/images/frPg13-15/SGP.png');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sgp-190-10m', 'SGP-190 (10M)', 'SGP', 190, 14.5, 10080, 2.82, '/images/frPg13-15/SGP.png');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SM', 'semi', '["Longitudinal ribs with sipes","Good transmission of traction forces due to distinctive sipes","Fuel saving, low rolling resistance"]', '["D"]', '["H","R"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sm-205', 'SM-205', 'SM', 205, 11, 3220, 2.95, '/images/frPg16-18/SM.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sm-215', 'SM-215', 'SM', 215, 11, 3220, 3.11, '/images/frPg16-18/SM.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('ST386', 'semi', '["Square, open, staggered shoulder tread blocks","Helps increase side stability with superb traction in mud & snow","Extra deep treading","Minimal stone retention","Open staggered shoulders and large notching","Self-cleaning traction in muddy terrain"]', '["D"]', '["H","R"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('st386-215', 'ST386-215', 'ST386', 215, 14, 3720, 3.9, '/images/frPg16-18/st-386.png');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('st386-225', 'ST386-225', 'ST386', 225, 14, 3720, 4.03, '/images/frPg16-18/st-386.png');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('st386-230', 'ST386-230', 'ST386', 230, 14, 3340, 3.98, '/images/frPg16-18/st-386.png');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('st386-230-1', 'ST386-230.1', 'ST386', 230, 14, 3750, 4.05, '/images/frPg16-18/st-386.png');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SUN32', 'semi', '["Block pattern, closed, rounded shoulder","For drive axle of trucks, semi-trailer, trailer and trailing axles","Well suited for construction-site operation","For short and long range operations","High resistance to lateral shearing forces due to rounded shoulders","Directionally stable due to closed shoulder","Good self cleaning due to open tread design","Good transmission of traction forces due to solid blocks in centre of tread"]', '["D","A"]', '["R","O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sun32-215', 'SUN32-215', 'SUN32', 215, 16, 3220, 3.6, '/images/frPg16-18/SUN-32.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sun32-230', 'SUN32-230', 'SUN32', 230, 16, 3250, 3.66, '/images/frPg16-18/SUN-32.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sun32-240-2', 'SUN32-240.2', 'SUN32', 240, 16, 3230, 3.96, '/images/frPg16-18/SUN-32.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sun32-250', 'SUN32-250', 'SUN32', 250, 16, 3230, 4.24, '/images/frPg16-18/SUN-32.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('CB', 'lug', '["Robust tread with large contact area","For drive axle of construction and special purpose vehicles in heavy duty use","Also for forklift and industrial vehicles","Good transmission of traction forces particularly on unpaved surfaces","Very good self cleaning due to open shoulder design","Resistant to tears and cuts due to specifically formulated compound","Very well suited for high propulsion power","Good running properties due to open tread design"]', '["D","A"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cb-152', 'CB-152', 'CB', 152, 11, 2380, 2.16, '/images/frPg1-7/CB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cb-194', 'CB-194', 'CB', 194, 14, 3250, 3.35, '/images/frPg1-7/CB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cb-203', 'CB-203', 'CB', 203, 15, 3230, 3.8, '/images/frPg1-7/CB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cb-207', 'CB-207', 'CB', 207, 17, 3255, 3.96, '/images/frPg1-7/CB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cb-210', 'CB-210', 'CB', 210, 15, 3310, 3.92, '/images/frPg1-7/CB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cb-220', 'CB-220', 'CB', 220, 15, 3470, 4.15, '/images/frPg1-7/CB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cb-230-2', 'CB-230.2', 'CB', 230, 15, 3190, 4.35, '/images/frPg1-7/CB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cb-250', 'CB-250', 'CB', 250, 15, 3470, 4.8, '/images/frPg1-7/CB.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('CXG', 'lug', '["Speciality tread for fork-lift tyres","For light truck, van and buses"]', '["D","A"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cxg-140', 'CXG-140', 'CXG', 140, 15, 2440, 2.13, '/images/frPg16-18/CXG.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cxg-150', 'CXG-150', 'CXG', 150, 15, 2440, 2.25, '/images/frPg16-18/CXG.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cxg-162', 'CXG-162', 'CXG', 162, 15, 2540, 2.44, '/images/frPg16-18/CXG.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cxg-170', 'CXG-170', 'CXG', 170, 15.5, 2530, 2.73, '/images/frPg16-18/CXG.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('cxg-180', 'CXG-180', 'CXG', 180, 15.5, 2480, 2.94, '/images/frPg16-18/CXG.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('LL', 'lug', '["Transverse solid block tread","For drive axle of construction and special purpose vehicles","Good transmission of traction forces particularly on unpaved surface","Very good self cleaning as a result of open tread design","Resistant to cuts and wears and tears due to specially formulated compound"]', '["D"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ll-140', 'LL-140', 'LL', 140, 13.5, 2450, 2.22, '/images/frPg13-15/LL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ll-160', 'LL-160', 'LL', 160, 14, 2450, 2.51, '/images/frPg13-15/LL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ll-170', 'LL-170', 'LL', 170, 14, 2480, 2.66, '/images/frPg13-15/LL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ll-205-3', 'LL-205.3', 'LL', 205, 16, 2600, 3.8, '/images/frPg13-15/LL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ll-215-1', 'LL-215.1', 'LL', 215, 18, 3160, 4.2, '/images/frPg13-15/LL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ll-215-h', 'LL-215 (H)', 'LL', 215, 20, 3330, 4.65, '/images/frPg13-15/LL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ll-230', 'LL-230', 'LL', 230, 16, 3330, 4.07, '/images/frPg13-15/LL.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('NLL', 'lug', '["Transverse solid block tread","For drive axle of construction and special purpose vehicles","Good transmission of traction forces particularly on unpaved surface","Very good self cleaning as a result of open tread design","Resistant to cuts and wears and tears due to specially formulated compound"]', '["D"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('nll-150', 'NLL-150', 'NLL', 150, 14.5, 2480, 2.26, '/images/frPg13-15/NLL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('nll-180-4', 'NLL-180.4', 'NLL', 180, 15, 2400, 2.79, '/images/frPg13-15/NLL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('nll-180-7m', 'NLL-180 (7M)', 'NLL', 180, 15, 6420, 2.87, '/images/frPg13-15/NLL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('nll-195-2-n', 'NLL-195.2 (N)', 'NLL', 195, 15, 3190, 3.14, '/images/frPg13-15/NLL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('nll-195-n', 'NLL-195 (N)', 'NLL', 195, 15, 3550, 3.14, '/images/frPg13-15/NLL.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('LT', 'lug', '["Solid, cross-groove, block type tread","Used on drive of construction and special purpose vehicles in heavy duty use","Specially formulated formula, helps to prevent cuts and damage to casing","Good self cleaning due to open shoulder design","Good running properties due to extra tread depth"]', '["D"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('lt-195-n', 'LT-195 (N)', 'LT', 195, 23, 3150, 4.48, '/images/frPg13-15/LT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('lt-205-1', 'LT-205.1', 'LT', 205, 25, 3230, 4.74, '/images/frPg13-15/LT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('lt-205-2', 'LT-205.2', 'LT', 205, 25, 3770, 4.93, '/images/frPg13-15/LT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('lt-220-3', 'LT-220.3', 'LT', 220, 25, 3210, 5.16, '/images/frPg13-15/LT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('lt-220-4', 'LT-220.4', 'LT', 220, 25, 3740, 5.16, '/images/frPg13-15/LT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('lt-240', 'LT-240', 'LT', 240, 24, 3320, 5.63, '/images/frPg13-15/LT.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('RB', 'lug', '["Solid block tread","For drive axle of construction and special purpose vehicles on heavy duty use","Only suitable for low speeds and on normal roads","Very good self cleaning as a result of open tread design","Anti chipping and anti-cutting characteristic","High mileage performance in all application because of deep tread and large contact area","Good transmission of traction forces, particularly on unpaved surfaces"]', '["D"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rb-200-1', 'RB-200.1', 'RB', 200, 18.5, 2440, 3.98, '/images/frPg13-15/RB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rb-215-n', 'RB-215 (N)', 'RB', 215, 20, 3250, 4.68, '/images/frPg13-15/RB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rb-220', 'RB-220', 'RB', 220, 21, 3230, 4.79, '/images/frPg13-15/RB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rb-230-n', 'RB-230 (N)', 'RB', 230, 21.5, 3340, 5.12, '/images/frPg13-15/RB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rb-230-4', 'RB-230.4', 'RB', 230, 21.5, 2750, 4.91, '/images/frPg13-15/RB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rb-242-n', 'RB-242 (N)', 'RB', 242, 21.5, 3250, 5.41, '/images/frPg13-15/RB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rb-252-n', 'RB-252 (N)', 'RB', 252, 21.5, 3310, 5.68, '/images/frPg13-15/RB.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rb-260-n', 'RB-260 (N)', 'RB', 260, 23, 3380, 6.59, '/images/frPg13-15/RB.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SHF', 'lug', '["Heavy duty lateral block with open shoulder","For application on drive axle of construction and special purpose vehicles","For short and long range operations","Suitable for all weather use","Good transmission of traction forces on wet and dry roads, particularly in unpaved roads","Good self cleaning as a result of open shoulder","High mileage performance"]', '["D","A"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('shf-240-11m', 'SHF-240 (11M)', 'SHF', 240, 19, 10050, 5.11, '/images/frPg13-15/SHF.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('shf-250-11m', 'SHF-250 (11M)', 'SHF', 250, 19, 10050, 5.32, '/images/frPg13-15/SHF.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('shf-260-11m', 'SHF-260 (11M)', 'SHF', 260, 19, 10050, 5.61, '/images/frPg13-15/SHF.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('SR45', 'lug', '["Solid cross groove, block type tread","Good self cleaning due to open shoulder design","Good running properties due to extra tread depth","Better traction due to L-shape pattern"]', '["D"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('sr45-318', 'SR45-318', 'SR45', 318, 32, 4180, 10.4, '/images/frPg16-18/sr45.png');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('TK', 'lug', '["Solid cross groove, block type tread","For drive axle of construction and special purpose vehicles in heavy duty use","Specialty design for use in logging industry","Specially adapted compound for anti cut and chipping","Good transmission of traction forces, particularly on unpaved surface","Very good self cleaning due to open shoulder","Superbly suited for high propulsion power"]', '["D"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('tk-195', 'TK-195', 'TK', 195, 18, 3160, 3.38, '/images/frPg13-15/TK.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('tk-203', 'TK-203', 'TK', 203, 19, 3290, 4.29, '/images/frPg13-15/TK.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('tk-210', 'TK-210', 'TK', 210, 19, 3240, 4.23, '/images/frPg13-15/TK.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('tk-215-n', 'TK-215 (N)', 'TK', 215, 19, 3200, 4.56, '/images/frPg13-15/TK.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('tk-230-3-n', 'TK-230.3 (N)', 'TK', 230, 21, 3310, 4.7, '/images/frPg13-15/TK.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('tk-254', 'TK-254', 'TK', 254, 19, 3700, 5.46, '/images/frPg13-15/TK.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('tk-254-2', 'TK-254.2', 'TK', 254, 19, 3400, 5.38, '/images/frPg13-15/TK.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('WHL', 'lug', '["Heavy duty lateral block with open shoulder","For application on drive axle of construction and special purpose vehicles","For short and long range operations","Suitable for all weather use","Good transmission of traction forces on wet and dry roads, particularly in unpaved roads","Good self cleaning as a result of open shoulder","High mileage performance"]', '[]', '["R","U"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('whl-165', 'WHL-165', 'WHL', 165, 16, 2610, 2.87, '/images/frPg13-15/WHL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('whl-203-1', 'WHL-203.1', 'WHL', 203, 20, 3405, 4.26, '/images/frPg13-15/WHL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('whl-215-3', 'WHL-215.3', 'WHL', 215, 20, 3110, 4.53, '/images/frPg13-15/WHL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('whl-230', 'WHL-230', 'WHL', 230, 22, 3290, 5.32, '/images/frPg13-15/WHL.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('whl-245', 'WHL-245', 'WHL', 245, 22, 3280, 5.18, '/images/frPg13-15/WHL.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('RP', 'rib', '["Optimised rib pattern for straight-line stability and directional control","Advanced groove geometry for effective water channelling","Low heat build-up under sustained highway speeds"]', '["S"]', '["H"]');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('DT', 'semi', '["Semi-lug pattern for drive axle traction and torque handling","Balanced tread void ratio for highway and mixed-road use","High resistance to irregular wear under loaded conditions"]', '["D"]', '["R","H"]');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('RL', 'lug', '["Deep lug pattern for maximum off-road traction","High cut, chip, and tear resistance in abrasive terrain","Reinforced shoulder design for lateral load stability"]', '["D"]', '["O"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rp-194-showcase', 'RP-194 (Rib Tread)', 'RP', 194, 15, 3200, 2.92, '/images/frPg8-12/RP.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('dt-210', 'DT-210 (Semi-Lug Tread)', 'DT', 210, 16, 3280, 3.48, '/images/frPg8-12/DT.bmp');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('rl-242', 'RL-242 (Lug Tread)', 'RL', 242, 21.5, 3310, 5.41, '/images/frPg13-15/RL.bmp');
INSERT IGNORE INTO pattern_groups (id, pattern_family, description, tyre_position, application) VALUES ('IC', 'semi', '["Custom-formulated compounds for specific industrial requirements","Available in NR, SBR, EPDM, NBR, and CR bases","Engineered for durability and consistency"]', '["A"]', '["I"]');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ic-gp', 'General-Purpose Industrial Compound', 'IC', 0, 0, 0, 0, '/images/industrial/gp_compound.jpg');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ic-ht', 'High-Temperature Industrial Compound', 'IC', 0, 0, 0, 0, '/images/industrial/ht_compound.jpg');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ic-cr', 'Chemical-Resistant Industrial Compound', 'IC', 0, 0, 0, 0, '/images/industrial/cr_compound.jpg');
INSERT IGNORE INTO products (id, name, pattern_group_id, width, thickness, rim_diameter, weight, image) VALUES ('ic-vi', 'Vibration Isolation / Anti-Vibration Compound', 'IC', 0, 0, 0, 0, '/images/industrial/vi_compound.jpg');

-- Seeding R&D Equipment
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (1, 'Rheometer', 'ASTM D6204-15', 'rotate_right', '/images/equipments/rheological_test.jpg', 'Measures the cure characteristics of rubber compounds — including optimum cure time, scorch time, and torque differential.', 'Quality Control Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (2, 'Mooney Viscometer', 'ISO 289-1 / ISO 289-2', 'thermostat', '/images/equipments/money-viscometer.jpg', 'Determines Mooney Viscosity and Mooney Scorch of raw and compounded rubber to assess processability and scorching tendency.', 'Quality Control Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (3, 'Tensometer', 'ISO 37', 'open_in_full', '/images/equipments/tensile_test.png', 'Measures tensile strength, elongation at break, and modulus of cured rubber specimens using dumbbell-shaped test pieces.', 'Quality Control Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (4, 'Abrasion Tester', 'ISO 4649', 'texture', '/images/equipments/abrasion_resistance_test.jpg', 'Determines the abrasion resistance of rubber using the DIN rotating drum method — critical for tread compound evaluation.', 'Quality Control Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (5, 'Dry Oven', 'ISO 188', 'local_fire_department', '/images/equipments/aging_test.png', 'Air-oven aging test to assess the effect of elevated temperature exposure on the physical properties of vulcanised rubber.', 'Quality Control Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (6, 'Densimeter', 'ISO 2781', 'water', '/images/equipments/specific_gravity_test.jpg', 'Measures the specific gravity (density) of rubber compounds using liquid displacement, used for compound QC and specification compliance.', 'Quality Control Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (7, 'Durometer Hardness Tester', 'ISO48-4', 'push_pin', '/images/equipments/durometer_hardness_test.png', 'Measures the Shore A hardness of cured rubber specimens — a key quality parameter for all compound grades.', 'Quality Control Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (9, 'Compression Set Tester', 'ISO 815-1', 'compress', '/images/equipments/compression_set.jpg', 'Evaluates the ability of rubber to recover from sustained compressive deformation — relevant for seal and gasket applications.', 'Quality Control Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (10, 'Thermogravimetric Analyzer (TGA)', 'ISO 9924-1', 'analytics', '/images/rd/measures_analysis_1.jpg', 'Used for material characterization and weight percentage analysis of organic volatiles, carbon black, and filler in rubber compounds.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (11, 'Moisture Analysis', 'ASTM C 566-97', 'water_drop', '/images/rd/measures_analysis_2.png', 'Determines moisture content in raw materials (polymers and carbon black) to monitor quality and detect evaporable moisture.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (12, 'IRHD Hardness', 'ISO 48', 'target', '/images/rd/measures_analysis_3.jpg', 'A specific method to determine the International Rubber Hardness Degrees (IRHD) of vulcanized rubber on flat surfaces.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (13, 'TDS Meter and pH Meter', 'In-House', 'water_ph', '/images/rd/measures_analysis_4.png', 'Checks Total Dissolved Solids (aggregate organic/inorganic material) and pH level (acidity/alkalinity) of water samples.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (14, 'Multiparameter Photometer with COD', 'Multi-parameter', 'biotech', '/images/rd/measures_analysis_5.jpg', 'Measures 40+ key water quality parameters including Alkalinity, Total Hardness, TDS, and Chloride in wastewater.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (15, 'Flexometer Test', 'ISO 4666', 'multiline_chart', '/images/rd/measures_analysis_6.jpg', 'Determines temperature rise and resistance to fatigue in vulcanized rubber under constant-strain amplitude.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (16, 'Flex Cracking & Crack Growth', 'ISO 132', 'history', '/images/rd/measures_analysis_7.jpg', 'Determines resistance to the formation and growth of cracks when subjected to repeat flexing on a De Mattia machine.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (17, 'Resilience Elasticity Test', 'ISO 4662', 'height', '/images/rd/measures_analysis_8.png', 'Uses a pendulum to determine rebound resilience and energy loss through hysteresis in flat rubber specimens.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (18, 'Vertical Rebound Resilience', 'ASTM D2632', 'vertical_align_bottom', '/images/rd/measures_analysis_9.jpg', 'Measures the vertical rebound of a dropped mass to predict dynamic modulus and internal friction of rubber compounds.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (19, 'High Speed Stirrer/Dispersers', 'IN HOUSE LAB METHOD', 'cyclone', '/images/rd/measures_analysis_10.jpg', 'Disperses powders into liquid continuous phases while reducing agglomerate size to homogenize suspensions.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (20, 'Overhead Stirrer', 'In House Lab Method', 'rotate_left', '/images/rd/measures_analysis_11.jpg', 'Used for homogenizing, mixing, suspending, and recirculating high viscosity substances or large volumes.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (21, 'Digital Microscope', 'ISO 11345', 'microscope', '/images/rd/measures_analysis_12.jpg', 'Features 24X to 162X magnification to analyze Carbon Black dispersion as per international safety and quality standards.', 'Measures and Analysis Equipments');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (22, 'Lab Balances Scales', 'In-House Lab Method', 'balance', '/images/rd/lab_weighing_1.jpg', 'Lab balance scales to prepared raw materials for lab mixing and rubber sample preparation', 'Lab Weighing and Mixing Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (23, 'Lab Mixing Kneader & Two Roll Mill', 'In-House Lab Method', 'rebase_edit', '/images/rd/lab_weighing_2.jpg', 'High-shear Kneader for solid/powder/liquid homogenization, and Two Roll Mill for heat dissipation and masterbatch refinement.', 'Lab Weighing and Mixing Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (24, 'Lab Press Mould Machine', 'In-House Lab Method', 'settings_input_component', '/images/rd/sample_preparation_1.jpg', 'Precision curing of rubber specimens and buttons under controlled temperature, pressure, and time with standard moulds.', 'Sample Preparation Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (25, 'Hydraulic Slab Cutter', 'In-House Lab Method', 'content_cut', '/images/rd/sample_preparation_2.jpg', 'Used to cut dumbbell, trouser, angle, and crescent specimens from rubber slabs for tensile and tear strength analysis.', 'Sample Preparation Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (26, 'Abrasion Sample Cutter - Drill Press', 'In-House Lab Method', 'construction', '/images/rd/sample_preparation_3.jpg', 'Specialized drill press assembly designed to precisely extract abrasion test samples from vulcanized rubber blocks.', 'Sample Preparation Equipment');
INSERT IGNORE INTO rd_equipment (id, name, standard, icon, image, description, category) VALUES (27, 'Specimen Cutter - Dumbbell and Tear', 'ISO 37 / ISO 34', 'format_shapes', '/images/rd/sample_preparation_4.jpg', 'Precision cutters engineered to strictly follow ISO 37 (Tensile) and ISO 34 (Tear Strength) specimen geometry standards.', 'Sample Preparation Equipment');

-- Seeding News
INSERT IGNORE INTO news (id, title, category, date_label, excerpt, content, image) VALUES (2, 'New Lug Tread Profile Released — RL-260 Series', 'Product Updates', 'FEB 2026', 'We have introduced the RL-260, a next-generation off-road lug tread formulated for mining and heavy plant vehicles. The profile features an enhanced compound system to improve tread life in high-abrasion environments.', '["Sun Rubber Industry Sdn. Bhd. has released the RL-260, a new-generation off-road lug tread profile developed for mining, earthmoving, and heavy plant vehicle applications. The RL-260 is the successor to the RL-242 and incorporates an updated compound system designed to deliver improved abrasion resistance and extended tread life in demanding terrain.","The RL-260 compound utilises an optimised SMR/carbon black system with enhanced filler dispersion, resulting in a higher DIN abrasion resistance index compared to the previous generation. The lug geometry has also been revised to provide better self-cleaning characteristics in soft ground and clay-heavy environments.","The new profile is available in a range of section widths suitable for commercial truck and mining vehicle fitment. It is compatible with standard cold-process retreading equipment and certified for use with Sun Rubber''s Standard Cushion Gum bonding compound.","Samples and technical data sheets are available upon request. Customers currently sourcing the RL-242 are encouraged to contact our technical team to discuss a transition to the RL-260 and evaluate any compound compatibility requirements."]', '/images/news/rl260_release.png');
INSERT IGNORE INTO news (id, title, category, date_label, excerpt, content, image) VALUES (3, 'Sun Rubber Achieves ESG Compliance Under ECOWISE Holdings', 'ESG', 'JAN 2026', 'In line with ECOWISE Holdings Limited''s ESG mandate, Sun Rubber has completed its assessment and achieved compliance with applicable environmental and social governance standards. This represents a continued commitment to responsible manufacturing practices.', '["Sun Rubber Industry Sdn. Bhd. has successfully completed its Environmental, Social, and Governance (ESG) compliance assessment under the framework established by its parent company, ECOWISE Holdings Limited. The assessment evaluated the company''s operations across environmental impact, raw material sourcing, waste management, and social governance practices.","The compliance process involved a comprehensive review of the Senawang production facility, including an audit of energy consumption, chemical storage and disposal procedures, and supplier due diligence protocols. The findings confirmed that Sun Rubber''s current operations meet the required standards and identified several areas where further improvement targets have been set for 2026.","As part of ECOWISE Holdings'' broader ESG strategy, Sun Rubber has committed to implementing additional environmental monitoring measures and increasing transparency in its raw material sourcing documentation. These initiatives align with global supply chain sustainability requirements that are increasingly demanded by international industrial customers.","Sun Rubber''s management team views ESG compliance not only as a regulatory requirement but as a long-term business principle. Responsible manufacturing and a commitment to environmental accountability are central to the company''s values and its relationship with customers, employees, and the broader community."]', '/images/news/esg_compliance.png');
INSERT IGNORE INTO news (id, title, category, date_label, excerpt, content, image) VALUES (4, 'Tyre Retreading Market Outlook — Malaysia and Singapore 2025–2027', 'Industry', 'DEC 2025', 'An overview of key trends driving demand for retreaded tyres in the commercial vehicle sector across Malaysia and Singapore, with analysis of tread compound performance expectations from major fleet operators.', '["The commercial tyre retreading market across Malaysia and Singapore continues to demonstrate stable demand, underpinned by the growth of logistics and heavy freight sectors in both countries. Fleet operators managing large numbers of truck and bus tyres are increasingly evaluating retreading as a cost-effective and environmentally sound alternative to new tyre replacement.","Key drivers for the 2025–2027 period include rising new tyre costs, expanding logistics infrastructure linked to regional trade growth, and greater awareness of the carbon footprint reduction benefits of retreaded tyres. Retreaded tyres consume significantly fewer raw materials and energy to produce compared to new tyres, making them an attractive option for fleet operators with sustainability mandates.","From a compound performance perspective, fleet operators are placing increasing emphasis on tread life consistency, wet traction performance, and heat dissipation under loaded conditions. This has driven demand for higher-specification tread compounds, particularly in highway and regional haulage applications where tyre performance directly impacts operating costs.","Sun Rubber continues to develop its precured tread liner range in response to these market demands, with ongoing R&D focused on compound systems that deliver improved abrasion resistance without compromising processing compatibility with standard cold-process retreading equipment. We anticipate continued product development activity through 2026 in support of our customers'' evolving requirements."]', '/images/news/market_outlook.png');
