INSERT INTO service_catalog
    (code, name, description, hours, category, skill_level, flat_rate_code, warranty, seasonal)
VALUES
-- ========= GENERAL / DIAGNOSTIC =========
('GEN-001','General inspection','Full safety and condition inspection of unit',0.8,'General','B','GEN',0,0),
('GEN-002','Pre-purchase inspection','Comprehensive inspection for potential purchase',1.2,'General','B','GEN',0,0),
('GEN-003','Full diagnostic – no start','Electrical/fuel/spark/compression diagnosis for no-start condition',1.0,'Diagnostics','A','DIAG',0,0),
('GEN-004','Full diagnostic – running issue','Diagnosis of misfire, bog, hesitation, or poor running',1.2,'Diagnostics','A','DIAG',0,0),
('GEN-005','Electrical diagnostic – short/parasite','Trace and locate electrical short or parasitic draw',1.5,'Diagnostics','A','ELEC',0,0),
('GEN-006','Charging system test','Test stator, regulator/rectifier, and battery under load',0.5,'Diagnostics','B','ELEC',0,0),
('GEN-007','Compression test – single cylinder','Compression test on single cylinder engine',0.4,'Diagnostics','B','DIAG',0,0),
('GEN-008','Compression test – multi cylinder','Compression test on multi-cylinder engine',0.7,'Diagnostics','B','DIAG',0,0),
('GEN-009','Leak-down test – single cylinder','Leak-down test and interpretation',0.6,'Diagnostics','A','DIAG',0,0),
('GEN-010','Leak-down test – multi cylinder','Leak-down test on multi-cylinder engine',0.9,'Diagnostics','A','DIAG',0,0),

-- ========= ENGINE – TOP END =========
('ENG-101','Top end rebuild – air-cooled single','Remove and rebuild top end, hone, piston, rings, gaskets',4.5,'Engine','A','TOPEND',0,0),
('ENG-102','Top end rebuild – liquid-cooled single','Remove and rebuild top end, coolant service included',5.0,'Engine','A','TOPEND',0,0),
('ENG-103','Top end rebuild – 2-stroke single','Piston, rings, power valve cleaning, gaskets',3.8,'Engine','A','TOPEND',0,0),
('ENG-104','Top end rebuild – twin','Top end rebuild on parallel or V-twin',6.0,'Engine','A','TOPEND',0,0),
('ENG-105','Cylinder head gasket replacement – single','Replace head gasket, torque to spec, fluids',3.0,'Engine','A','HEAD',0,0),
('ENG-106','Cylinder head gasket replacement – multi','Replace head gasket on multi-cylinder engine',5.5,'Engine','A','HEAD',0,0),
('ENG-107','Valve clearance check – single OHC','Check and record valve clearances',1.2,'Engine','B','VALVE',0,0),
('ENG-108','Valve clearance adjust – shim under bucket','Adjust clearances, cams out, shim selection',3.0,'Engine','A','VALVE',0,0),
('ENG-109','Valve clearance adjust – screw & locknut','Adjust clearances on rocker style valvetrain',1.5,'Engine','B','VALVE',0,0),
('ENG-110','Cam chain replacement – single','Replace cam chain, guides as needed',3.5,'Engine','A','TIMING',0,0),
('ENG-111','Cam chain replacement – multi','Replace cam chain on multi-cylinder engine',5.0,'Engine','A','TIMING',0,0),
('ENG-112','Timing chain tensioner replacement','Replace and set cam chain tensioner',1.0,'Engine','B','TIMING',0,0),
('ENG-113','Engine oil & filter change','Drain and refill engine oil, replace filter, inspect',0.4,'Engine','C','OIL',0,1),
('ENG-114','Engine oil change – ATV/SxS','Oil and filter change on ATV or side-by-side',0.6,'Engine','C','OIL',0,1),
('ENG-115','Spark plug replacement – single','Replace spark plug, inspect cap and wire',0.3,'Engine','C','TUNE',0,0),
('ENG-116','Spark plug replacement – multi','Replace all spark plugs on multi-cylinder engine',0.6,'Engine','C','TUNE',0,0),
('ENG-117','Air filter service – foam','Clean, oil, and reinstall foam air filter',0.4,'Engine','C','TUNE',0,1),
('ENG-118','Air filter replacement – paper','Replace paper air filter element',0.3,'Engine','C','TUNE',0,1),
('ENG-119','Throttle body sync – multi','Synchronize throttle bodies or carb bank',1.2,'Engine','A','TUNE',0,0),
('ENG-120','Idle and mixture tune – carbureted','Adjust idle speed and mixture screws',0.7,'Engine','B','TUNE',0,0),

-- ========= FUEL SYSTEM / CARBURETION =========
('FUEL-201','Carb clean – single','Remove, disassemble, clean, and reinstall single carb',2.0,'Fuel','B','CARB',0,0),
('FUEL-202','Carb clean – twin','Remove, clean, and sync twin carbs',3.0,'Fuel','B','CARB',0,0),
('FUEL-203','Carb clean – 3–4 cylinder bank','Remove, clean, bench sync multi-carb bank',4.5,'Fuel','A','CARB',0,0),
('FUEL-204','Fuel injector clean – off-bike','Remove injectors, bench clean and flow test',1.5,'Fuel','B','EFI',0,0),
('FUEL-205','Fuel pump replacement – in-tank','Replace in-tank fuel pump assembly',1.8,'Fuel','B','EFI',0,0),
('FUEL-206','Fuel filter replacement – external','Replace inline fuel filter and inspect lines',0.4,'Fuel','C','FUEL',0,0),
('FUEL-207','Fuel tank flush – contaminated fuel','Drain, flush, and clean tank for contamination',1.5,'Fuel','B','FUEL',0,0),
('FUEL-208','Throttle body removal & clean','Remove and clean throttle body assembly',1.5,'Fuel','B','EFI',0,0),

-- ========= COOLING SYSTEM =========
('COOL-301','Coolant flush – motorcycle','Drain, flush, and refill cooling system',0.8,'Cooling','C','COOL',0,1),
('COOL-302','Coolant flush – ATV/SxS','Flush and refill cooling system on ATV/SxS',1.0,'Cooling','C','COOL',0,1),
('COOL-303','Radiator replacement','Replace radiator and bleed system',1.5,'Cooling','B','COOL',0,0),
('COOL-304','Water pump rebuild','Replace seals, bearings, and impeller as needed',2.0,'Cooling','A','COOL',0,0),
('COOL-305','Thermostat replacement','Replace thermostat and test operation',0.7,'Cooling','C','COOL',0,0),
('COOL-306','Cooling fan diagnostic & repair','Diagnose and repair cooling fan circuit',1.2,'Cooling','B','ELEC',0,0),

-- ========= DRIVETRAIN / TRANSMISSION =========
('DRIV-401','Chain & sprocket replacement','Replace chain and both sprockets, adjust alignment',1.0,'Drivetrain','C','CHAIN',0,0),
('DRIV-402','Chain adjustment & lube','Adjust chain slack and lubricate',0.3,'Drivetrain','C','CHAIN',0,1),
('DRIV-403','Final drive oil change – shaft','Drain and refill final drive oil',0.4,'Drivetrain','C','DRIVE',0,1),
('DRIV-404','Clutch cable replacement & adjust','Replace clutch cable and set free play',0.6,'Drivetrain','C','CLUTCH',0,0),
('DRIV-405','Hydraulic clutch bleed','Bleed hydraulic clutch system',0.5,'Drivetrain','C','CLUTCH',0,0),
('DRIV-406','Clutch pack replacement – wet','Replace clutch plates and springs, set free play',2.0,'Drivetrain','B','CLUTCH',0,0),
('DRIV-407','CVT belt replacement – ATV/SxS','Replace CVT belt and inspect clutches',1.2,'Drivetrain','B','CVT',0,0),
('DRIV-408','CVT service – clean & inspect','Disassemble, clean, and inspect CVT system',2.0,'Drivetrain','B','CVT',0,0),
('DRIV-409','Transmission oil change – separate','Change transmission oil on separate gearbox',0.5,'Drivetrain','C','DRIVE',0,1),

-- ========= SUSPENSION =========
('SUS-501','Fork seal replacement – conventional','Replace fork seals and oil on conventional forks',3.0,'Suspension','B','FORK',0,0),
('SUS-502','Fork seal replacement – USD','Replace fork seals and oil on upside-down forks',3.5,'Suspension','A','FORK',0,0),
('SUS-503','Fork oil change only','Drain and refill fork oil',1.5,'Suspension','B','FORK',0,0),
('SUS-504','Shock removal & send-out','Remove shock for external rebuild service',0.8,'Suspension','C','SHOCK',0,0),
('SUS-505','Shock replacement – bolt-on','Replace rear shock assembly',1.0,'Suspension','C','SHOCK',0,0),
('SUS-506','Linkage service – clean & grease','Disassemble, clean, and grease linkage bearings',2.0,'Suspension','B','SUS',0,0),
('SUS-507','Steering head bearing service','Replace or service steering head bearings',2.5,'Suspension','B','SUS',0,0),

-- ========= BRAKES =========
('BRK-601','Front brake pad replacement','Replace front pads and inspect caliper',0.6,'Brakes','C','BRAKE',0,0),
('BRK-602','Rear brake pad replacement','Replace rear pads and inspect caliper',0.5,'Brakes','C','BRAKE',0,0),
('BRK-603','Front & rear pad replacement','Replace all pads, inspect system',1.0,'Brakes','C','BRAKE',0,0),
('BRK-604','Brake fluid flush – single circuit','Flush and bleed one brake circuit',0.7,'Brakes','C','BRAKE',0,1),
('BRK-605','Brake fluid flush – dual circuit','Flush and bleed front and rear circuits',1.0,'Brakes','C','BRAKE',0,1),
('BRK-606','Brake rotor replacement – single','Replace single rotor and pads',0.8,'Brakes','C','BRAKE',0,0),
('BRK-607','Brake rotor replacement – dual','Replace dual rotors and pads',1.4,'Brakes','C','BRAKE',0,0),
('BRK-608','Caliper rebuild – single','Rebuild single brake caliper with seals',1.5,'Brakes','B','BRAKE',0,0),
('BRK-609','Caliper rebuild – dual','Rebuild dual calipers',2.5,'Brakes','B','BRAKE',0,0),

-- ========= TIRES / WHEELS =========
('TIRE-701','Tire mount & balance – off bike','Mount and balance tire off the bike',0.5,'Tires','C','TIRE',0,0),
('TIRE-702','Tire mount & balance – on bike front','Remove wheel, mount and balance tire',0.7,'Tires','C','TIRE',0,0),
('TIRE-703','Tire mount & balance – on bike rear','Remove wheel, mount and balance tire',0.8,'Tires','C','TIRE',0,0),
('TIRE-704','Tube replacement – off bike','Replace tube and inspect tire',0.4,'Tires','C','TIRE',0,0),
('TIRE-705','Spoke wheel true & tension','True wheel and tension spokes',1.5,'Tires','B','WHEEL',0,0),
('TIRE-706','Wheel bearing replacement – front','Replace front wheel bearings',0.8,'Tires','C','WHEEL',0,0),
('TIRE-707','Wheel bearing replacement – rear','Replace rear wheel bearings',1.0,'Tires','C','WHEEL',0,0),

-- ========= ELECTRICAL / LIGHTING =========
('ELEC-801','Battery test & replacement','Test and replace battery as needed',0.4,'Electrical','C','ELEC',0,0),
('ELEC-802','Starter motor replacement','Replace starter motor assembly',1.2,'Electrical','B','ELEC',0,0),
('ELEC-803','Stator replacement','Replace charging stator and test output',2.0,'Electrical','B','ELEC',0,0),
('ELEC-804','Regulator/rectifier replacement','Replace regulator/rectifier and test system',0.7,'Electrical','C','ELEC',0,0),
('ELEC-805','Accessory wiring – basic','Install and wire single accessory (grips, charger, etc.)',0.8,'Electrical','C','ELEC',0,0),
('ELEC-806','Accessory wiring – complex','Multiple accessories, relay block, or custom harness',2.0,'Electrical','B','ELEC',0,0),
('ELEC-807','Lighting upgrade – LED kit','Install LED headlight or auxiliary lighting kit',1.2,'Electrical','C','ELEC',0,0),
('ELEC-808','Turn signal/hazard repair','Diagnose and repair turn signal circuit',1.0,'Electrical','B','ELEC',0,0),

-- ========= CONTROLS / COCKPIT =========
('CTRL-901','Handlebar replacement','Replace handlebars and transfer controls',1.5,'Controls','C','CTRL',0,0),
('CTRL-902','Lever & perch replacement','Replace clutch or brake lever and perch',0.4,'Controls','C','CTRL',0,0),
('CTRL-903','Throttle tube & housing service','Service or replace throttle tube and housing',0.6,'Controls','C','CTRL',0,0),
('CTRL-904','Switchgear replacement – single side','Replace left or right switch assembly',0.7,'Controls','C','CTRL',0,0),
('CTRL-905','Mirror replacement – pair','Replace both mirrors',0.3,'Controls','C','CTRL',0,0),

-- ========= ATV / SXS SPECIFIC =========
('ATV-1001','Front diff fluid change','Change front differential fluid',0.5,'ATV/SxS','C','ATV',0,1),
('ATV-1002','Rear diff fluid change','Change rear differential fluid',0.5,'ATV/SxS','C','ATV',0,1),
('ATV-1003','4x4 system diagnostic','Diagnose 4x4 engagement issues',1.2,'ATV/SxS','B','ATV',0,0),
('ATV-1004','Axle replacement – CV shaft','Replace one CV axle shaft',1.5,'ATV/SxS','B','ATV',0,0),
('ATV-1005','Winch install','Install and wire winch kit',2.0,'ATV/SxS','B','ATV',0,0),
('ATV-1006','Plow install','Install plow mount and blade',1.8,'ATV/SxS','C','ATV',0,1),

-- ========= SNOW / PWC / SEASONAL =========
('SNOW-1101','Snowmobile pre-season service','Full pre-season inspection and service',2.5,'Snow','B','SEASON',0,1),
('SNOW-1102','Snowmobile post-season service','Post-season service and storage prep',2.0,'Snow','B','SEASON',0,1),
('SNOW-1103','Hyfax replacement – pair','Replace both hyfax rails',1.0,'Snow','C','SNOW',0,0),
('SNOW-1104','Track tension & alignment','Set track tension and alignment',0.7,'Snow','C','SNOW',0,0),
('PWC-1201','PWC pre-season service','Pre-season inspection and service',2.0,'PWC','B','SEASON',0,1),
('PWC-1202','PWC post-season winterize','Winterize PWC for storage',1.5,'PWC','B','SEASON',0,1),

-- ========= PDI / SETUP =========
('PDI-1301','Motorcycle PDI – new unit','Pre-delivery inspection and setup for new motorcycle',2.0,'PDI','B','PDI',1,0),
('PDI-1302','ATV PDI – new unit','Pre-delivery inspection and setup for new ATV',2.2,'PDI','B','PDI',1,0),
('PDI-1303','SxS PDI – new unit','Pre-delivery inspection and setup for new side-by-side',2.5,'PDI','B','PDI',1,0),
('PDI-1304','Snowmobile PDI – new unit','Pre-delivery inspection and setup for snowmobile',2.3,'PDI','B','PDI',1,0),
('PDI-1305','PWC PDI – new unit','Pre-delivery inspection and setup for PWC',2.0,'PDI','B','PDI',1,0);
INSERT INTO service_catalog
(code, name, description, hours, category, skill_level, flat_rate_code, warranty, seasonal)
VALUES
-- ========= ENGINE – BOTTOM END / INTERNAL =========
('ENG-201','Bottom end rebuild – single','Full teardown, crank bearings, seals, reassembly',6.5,'Engine','A','BOTEND',0,0),
('ENG-202','Bottom end rebuild – twin','Crank rebuild, bearings, seals, full reassembly',8.0,'Engine','A','BOTEND',0,0),
('ENG-203','Crankshaft replacement','Replace crankshaft assembly and bearings',7.0,'Engine','A','CRANK',0,0),
('ENG-204','Connecting rod replacement','Replace connecting rod and bearings',6.0,'Engine','A','CRANK',0,0),
('ENG-205','Engine removal & reinstall – single','Remove and reinstall engine assembly',3.0,'Engine','B','ENGREM',0,0),
('ENG-206','Engine removal & reinstall – multi','Remove and reinstall multi-cylinder engine',4.5,'Engine','B','ENGREM',0,0),
('ENG-207','Engine case reseal','Split cases, reseal, reassemble',7.5,'Engine','A','CASE',0,0),
('ENG-208','Starter clutch replacement','Replace starter clutch assembly',2.5,'Engine','B','START',0,0),
('ENG-209','Flywheel replacement','Remove and replace flywheel/rotor',1.0,'Engine','C','ELEC',0,0),
('ENG-210','De-carbon service – top end','Remove carbon buildup from piston/head',1.5,'Engine','B','TOPEND',0,0),

-- ========= FUEL SYSTEM – ADVANCED =========
('FUEL-301','EFI throttle sync – advanced','Electronic throttle body synchronization',1.5,'Fuel','A','EFI',0,0),
('FUEL-302','Fuel rail replacement','Replace fuel rail and seals',1.2,'Fuel','B','EFI',0,0),
('FUEL-303','Fuel pressure regulator replacement','Replace regulator and test pressure',1.0,'Fuel','B','EFI',0,0),
('FUEL-304','Fuel line replacement – full','Replace all fuel lines and clamps',1.5,'Fuel','C','FUEL',0,0),
('FUEL-305','Carb rebuild – full kit','Full rebuild with jets, gaskets, o-rings',3.0,'Fuel','B','CARB',0,0),
('FUEL-306','Carb sync – multi bank','Synchronize multi-carb bank',1.0,'Fuel','B','CARB',0,0),
('FUEL-307','Fuel tank removal & reinstall','Remove tank for access or service',0.8,'Fuel','C','FUEL',0,0),

-- ========= COOLING – ADVANCED =========
('COOL-401','Radiator fan replacement','Replace cooling fan assembly',1.0,'Cooling','C','COOL',0,0),
('COOL-402','Coolant hose replacement – full set','Replace all coolant hoses',1.5,'Cooling','C','COOL',0,0),
('COOL-403','Water pump shaft replacement','Replace shaft and seals',2.2,'Cooling','B','COOL',0,0),
('COOL-404','Thermostat housing replacement','Replace housing and gasket',0.8,'Cooling','C','COOL',0,0),

-- ========= DRIVETRAIN – ADVANCED =========
('DRIV-501','Clutch basket replacement','Replace clutch basket and plates',2.5,'Drivetrain','B','CLUTCH',0,0),
('DRIV-502','Slipper clutch install','Install aftermarket slipper clutch',3.0,'Drivetrain','A','CLUTCH',0,0),
('DRIV-503','Transmission rebuild – single','Rebuild single-cylinder gearbox',6.5,'Drivetrain','A','TRANS',0,0),
('DRIV-504','Transmission rebuild – multi','Rebuild multi-cylinder gearbox',8.0,'Drivetrain','A','TRANS',0,0),
('DRIV-505','Shift drum replacement','Replace shift drum and forks',4.0,'Drivetrain','A','TRANS',0,0),
('DRIV-506','CVT clutch replacement – primary','Replace primary clutch assembly',1.5,'Drivetrain','B','CVT',0,0),
('DRIV-507','CVT clutch replacement – secondary','Replace secondary clutch assembly',1.5,'Drivetrain','B','CVT',0,0),

-- ========= SUSPENSION – ADVANCED =========
('SUS-601','Fork cartridge rebuild','Rebuild cartridge-style forks',3.5,'Suspension','A','FORK',0,0),
('SUS-602','Fork revalve','Revalve fork internals for rider weight',4.0,'Suspension','A','FORK',0,0),
('SUS-603','Shock revalve – off bike','Revalve shock internals',3.0,'Suspension','A','SHOCK',0,0),
('SUS-604','Shock spring replacement','Replace shock spring and set sag',1.0,'Suspension','C','SHOCK',0,0),
('SUS-605','Triple clamp replacement','Replace upper/lower triple clamps',1.5,'Suspension','B','SUS',0,0),
('SUS-606','Swingarm removal & service','Remove swingarm, inspect bearings',2.0,'Suspension','B','SUS',0,0),

-- ========= BRAKES – ADVANCED =========
('BRK-701','Master cylinder rebuild – front','Rebuild front master cylinder',1.0,'Brakes','B','BRAKE',0,0),
('BRK-702','Master cylinder rebuild – rear','Rebuild rear master cylinder',0.8,'Brakes','B','BRAKE',0,0),
('BRK-703','ABS diagnostic & bleed','Diagnose ABS and perform ABS bleed',1.5,'Brakes','A','BRAKE',0,0),
('BRK-704','Brake line replacement – braided','Install braided brake lines',1.5,'Brakes','B','BRAKE',0,0),
('BRK-705','Caliper piston replacement','Replace caliper pistons and seals',1.8,'Brakes','B','BRAKE',0,0),

-- ========= TIRES / WHEELS – ADVANCED =========
('TIRE-801','Tire studding – snow','Install studs in snow tire',1.2,'Tires','C','TIRE',0,1),
('TIRE-802','Beadlock wheel service','Service beadlock wheel assembly',1.0,'Tires','B','WHEEL',0,0),
('TIRE-803','Mousse insert install','Install mousse foam insert',1.2,'Tires','B','TIRE',0,0),
('TIRE-804','Tire repair – plug/patch','Repair tire puncture',0.5,'Tires','C','TIRE',0,0),

-- ========= ELECTRICAL – ADVANCED =========
('ELEC-901','ECU flash – standard','Flash ECU with standard tune',0.8,'Electrical','B','ECU',0,0),
('ELEC-902','ECU flash – custom','Custom ECU tune and mapping',1.5,'Electrical','A','ECU',0,0),
('ELEC-903','Harness repair – minor','Repair small section of wiring harness',1.0,'Electrical','B','ELEC',0,0),
('ELEC-904','Harness repair – major','Repair multiple circuits or sections',3.0,'Electrical','A','ELEC',0,0),
('ELEC-905','Ignition coil replacement','Replace ignition coil(s)',0.5,'Electrical','C','ELEC',0,0),
('ELEC-906','Sensor replacement – O2/MAF/MAP','Replace engine sensor and test',0.6,'Electrical','C','ELEC',0,0),
('ELEC-907','Starter relay replacement','Replace starter relay',0.4,'Electrical','C','ELEC',0,0),
('ELEC-908','Fuse box replacement','Replace fuse box assembly',1.2,'Electrical','B','ELEC',0,0),

-- ========= CONTROLS / COCKPIT – ADVANCED =========
('CTRL-1001','Bar riser install','Install bar risers and adjust controls',0.8,'Controls','C','CTRL',0,0),
('CTRL-1002','Heated grip install','Install and wire heated grips',1.2,'Controls','C','CTRL',0,0),
('CTRL-1003','GPS mount install','Install GPS mount and wiring',0.7,'Controls','C','CTRL',0,0),
('CTRL-1004','Clutch perch upgrade','Install upgraded clutch perch',0.5,'Controls','C','CTRL',0,0),
('CTRL-1005','Throttle cable replacement','Replace throttle cables and adjust',1.0,'Controls','C','CTRL',0,0),

-- ========= ATV / SXS – ADVANCED =========
('ATV-2001','CV boot replacement – front','Replace front CV boot',1.2,'ATV/SxS','C','ATV',0,0),
('ATV-2002','CV boot replacement – rear','Replace rear CV boot',1.2,'ATV/SxS','C','ATV',0,0),
('ATV-2003','Differential rebuild – front','Rebuild front differential',3.5,'ATV/SxS','A','ATV',0,0),
('ATV-2004','Differential rebuild – rear','Rebuild rear differential',3.5,'ATV/SxS','A','ATV',0,0),
('ATV-2005','SxS door install','Install SxS door kit',1.5,'ATV/SxS','C','ATV',0,0),
('ATV-2006','SxS windshield install','Install windshield kit',0.8,'ATV/SxS','C','ATV',0,0),
('ATV-2007','SxS roof install','Install roof panel',0.7,'ATV/SxS','C','ATV',0,0),
('ATV-2008','SxS light bar install','Install and wire LED light bar',1.5,'ATV/SxS','B','ATV',0,0),

-- ========= SNOW / PWC – ADVANCED =========
('SNOW-2101','Snowmobile clutch service – primary','Service primary clutch',1.5,'Snow','B','SNOW',0,0),
('SNOW-2102','Snowmobile clutch service – secondary','Service secondary clutch',1.5,'Snow','B','SNOW',0,0),
('SNOW-2103','Snowmobile chaincase service','Service chaincase oil and tension',0.8,'Snow','C','SNOW',0,1),
('SNOW-2104','Snowmobile track replacement','Replace track assembly',3.5,'Snow','A','SNOW',0,0),
('PWC-2201','PWC pump service','Service jet pump assembly',1.5,'PWC','B','PWC',0,0),
('PWC-2202','PWC impeller replacement','Replace impeller and wear ring',1.8,'PWC','B','PWC',0,0),
('PWC-2203','PWC engine alignment','Align engine to pump shaft',1.2,'PWC','A','PWC',0,0),

-- ========= PDI / SETUP – ADVANCED =========
('PDI-2301','Accessory install – multi','Install multiple accessories during PDI',1.5,'PDI','C','PDI',1,0),
('PDI-2302','SxS full accessory package','Install full accessory package',3.5,'PDI','B','PDI',1,0),
('PDI-2303','Snowmobile accessory package','Install snow accessory package',2.5,'PDI','B','PDI',1,0);
INSERT INTO service_catalog
(code, name, description, hours, category, skill_level, flat_rate_code, warranty, seasonal)
VALUES
-- ========= PERFORMANCE / DYNO =========
('PERF-3001','Dyno baseline run','Perform baseline dyno pull and record AFR/HP/TQ',0.8,'Performance','B','DYNO',0,0),
('PERF-3002','Dyno tune – fuel only','Fuel mapping tune on dyno',1.5,'Performance','A','DYNO',0,0),
('PERF-3003','Dyno tune – full ECU','Full ECU tune including ignition and fuel',2.5,'Performance','A','DYNO',0,0),
('PERF-3004','Exhaust install – slip-on','Install slip-on exhaust system',0.7,'Performance','C','EXH',0,0),
('PERF-3005','Exhaust install – full system','Install full exhaust system',1.5,'Performance','B','EXH',0,0),
('PERF-3006','Airbox mod & tune','Modify airbox and adjust fueling',1.2,'Performance','B','TUNE',0,0),
('PERF-3007','Big bore kit install','Install big bore kit and tune',5.0,'Performance','A','ENGINE',0,0),
('PERF-3008','Camshaft upgrade','Install performance cams and set timing',3.5,'Performance','A','ENGINE',0,0),
('PERF-3009','Quickshifter install','Install and configure quickshifter',1.0,'Performance','B','ELEC',0,0),
('PERF-3010','Launch control setup','Configure launch control system',0.8,'Performance','B','ELEC',0,0),

-- ========= FABRICATION / CUSTOM =========
('FAB-4001','Custom bracket fabrication','Fabricate custom bracket or mount',1.5,'Fabrication','A','FAB',0,0),
('FAB-4002','Exhaust hanger fabrication','Fabricate custom exhaust hanger',1.2,'Fabrication','A','FAB',0,0),
('FAB-4003','Frame tab repair','Weld and repair frame tab',2.0,'Fabrication','A','WELD',0,0),
('FAB-4004','Crash bar install','Install crash bars and hardware',1.0,'Fabrication','C','FAB',0,0),
('FAB-4005','Custom wiring harness','Build custom wiring harness section',3.0,'Fabrication','A','ELEC',0,0),
('FAB-4006','Light fabrication – aluminum','Fabricate small aluminum part',1.5,'Fabrication','A','WELD',0,0),
('FAB-4007','Light fabrication – steel','Fabricate small steel part',1.5,'Fabrication','A','WELD',0,0),

-- ========= CRASH / FRAME / BODYWORK =========
('CRASH-5001','Crash estimate – full','Full crash damage inspection and estimate',1.0,'Crash','B','EST',0,0),
('CRASH-5002','Fairing replacement – full set','Replace full fairing kit',2.5,'Crash','C','BODY',0,0),
('CRASH-5003','Fairing repair – plastic weld','Plastic weld and repair cracked fairing',2.0,'Crash','A','BODY',0,0),
('CRASH-5004','Subframe replacement','Replace rear subframe assembly',2.0,'Crash','B','FRAME',0,0),
('CRASH-5005','Handlebar replacement – bent','Replace bent handlebars',0.8,'Crash','C','CTRL',0,0),
('CRASH-5006','Footpeg bracket replacement','Replace damaged footpeg bracket',0.6,'Crash','C','BODY',0,0),
('CRASH-5007','Crash bar replacement','Replace damaged crash bars',0.7,'Crash','C','BODY',0,0),
('CRASH-5008','Mirror replacement – crash','Replace broken mirrors',0.4,'Crash','C','CTRL',0,0),

-- ========= VINTAGE MOTORCYCLE SPECIALTY =========
('VINT-6001','Carb sync – vintage multi','Sync vintage multi-carb setup',1.5,'Vintage','A','CARB',0,0),
('VINT-6002','Points ignition setup','Set points gap and timing',1.2,'Vintage','A','IGN',0,0),
('VINT-6003','Vintage wiring repair','Repair brittle or corroded wiring',2.0,'Vintage','A','ELEC',0,0),
('VINT-6004','Vintage fork rebuild','Rebuild vintage fork assembly',2.5,'Vintage','B','FORK',0,0),
('VINT-6005','Vintage brake service – drum','Service drum brake system',1.2,'Vintage','B','BRAKE',0,0),
('VINT-6006','Vintage carb rebuild – single','Rebuild vintage carburetor',1.8,'Vintage','B','CARB',0,0),
('VINT-6007','Vintage carb rebuild – multi','Rebuild multi-carb vintage setup',3.5,'Vintage','A','CARB',0,0),
('VINT-6008','Vintage charging system repair','Repair vintage charging system',2.0,'Vintage','A','ELEC',0,0),

-- ========= ADVANCED ELECTRICAL / DIAGNOSTICS =========
('ELEC-10001','CANBUS diagnostic','Diagnose CANBUS communication faults',1.5,'Electrical','A','ELEC',0,0),
('ELEC-10002','ECU replacement & programming','Replace ECU and program to unit',1.2,'Electrical','A','ECU',0,0),
('ELEC-10003','Key programming – chipped','Program chipped key to ECU',0.8,'Electrical','B','ECU',0,0),
('ELEC-10004','Key programming – fob','Program wireless key fob',0.6,'Electrical','B','ECU',0,0),
('ELEC-10005','Sensor diagnostic – advanced','Diagnose advanced sensor faults',1.2,'Electrical','A','ELEC',0,0),
('ELEC-10006','Harness replacement – full','Replace full wiring harness',4.5,'Electrical','A','ELEC',0,0),
('ELEC-10007','Regulator relocation','Relocate regulator/rectifier',1.0,'Electrical','B','ELEC',0,0),
('ELEC-10008','Accessory fuse block install','Install accessory fuse block',1.2,'Electrical','B','ELEC',0,0),

-- ========= SXS HEAVY MECHANICAL =========
('SXS-7001','SxS clutch rebuild – primary','Rebuild primary clutch',2.0,'ATV/SxS','A','CVT',0,0),
('SXS-7002','SxS clutch rebuild – secondary','Rebuild secondary clutch',2.0,'ATV/SxS','A','CVT',0,0),
('SXS-7003','SxS diff replacement – front','Replace front differential',3.5,'ATV/SxS','A','ATV',0,0),
('SXS-7004','SxS diff replacement – rear','Replace rear differential',3.5,'ATV/SxS','A','ATV',0,0),
('SXS-7005','SxS driveshaft replacement','Replace driveshaft assembly',1.5,'ATV/SxS','B','ATV',0,0),
('SXS-7006','SxS steering rack replacement','Replace steering rack',2.5,'ATV/SxS','B','ATV',0,0),
('SXS-7007','SxS suspension arm replacement','Replace A-arm or trailing arm',1.8,'ATV/SxS','B','ATV',0,0),
('SXS-7008','SxS wheel bearing – heavy duty','Replace HD wheel bearing',1.2,'ATV/SxS','C','ATV',0,0),

-- ========= SNOWMOBILE DEEP SERVICES =========
('SNOW-3101','Snowmobile engine removal','Remove snowmobile engine',3.0,'Snow','B','SNOW',0,0),
('SNOW-3102','Snowmobile engine reinstall','Reinstall snowmobile engine',3.0,'Snow','B','SNOW',0,0),
('SNOW-3103','Snowmobile top end rebuild','Rebuild 2-stroke top end',3.5,'Snow','A','SNOW',0,0),
('SNOW-3104','Snowmobile bottom end rebuild','Rebuild 2-stroke bottom end',5.0,'Snow','A','SNOW',0,0),
('SNOW-3105','Snowmobile clutch alignment','Align primary and secondary clutches',1.0,'Snow','B','SNOW',0,0),
('SNOW-3106','Snowmobile skid removal & service','Remove skid and service bearings',2.0,'Snow','B','SNOW',0,0),
('SNOW-3107','Snowmobile tunnel repair','Repair tunnel damage',2.5,'Snow','A','SNOW',0,0),

-- ========= PWC ADVANCED =========
('PWC-3201','PWC engine removal','Remove PWC engine',3.5,'PWC','B','PWC',0,0),
('PWC-3202','PWC engine reinstall','Reinstall PWC engine',3.5,'PWC','B','PWC',0,0),
('PWC-3203','PWC top end rebuild','Rebuild PWC top end',3.0,'PWC','A','PWC',0,0),
('PWC-3204','PWC bottom end rebuild','Rebuild PWC bottom end',5.0,'PWC','A','PWC',0,0),
('PWC-3205','PWC pump alignment','Align pump to engine',1.2,'PWC','A','PWC',0,0),
('PWC-3206','PWC hull repair – minor','Repair minor hull damage',2.0,'PWC','A','PWC',0,0),
('PWC-3207','PWC hull repair – major','Repair major hull damage',4.0,'PWC','A','PWC',0,0),

-- ========= ACCESSORY INSTALLS – ADVANCED =========
('ACC-8001','Full lighting kit install','Install full lighting kit',2.0,'Accessories','B','ACC',0,0),
('ACC-8002','Heated seat install','Install heated seat kit',1.2,'Accessories','C','ACC',0,0),
('ACC-8003','Crash protection package','Install full crash protection kit',2.0,'Accessories','C','ACC',0,0),
('ACC-8004','Luggage rack install','Install luggage rack system',0.8,'Accessories','C','ACC',0,0),
('ACC-8005','Top case install','Install top case and mount',0.7,'Accessories','C','ACC',0,0),
('ACC-8006','Side case install','Install side case mounts and cases',1.0,'Accessories','C','ACC',0,0),
('ACC-8007','Phone mount & wiring','Install phone mount and power wiring',0.6,'Accessories','C','ACC',0,0),
('ACC-8008','Auxiliary horn install','Install upgraded horn',0.5,'Accessories','C','ACC',0,0);
