CREATE TABLE IF NOT EXISTS oil_viscosities (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, code VARCHAR(40) NOT NULL UNIQUE, standard_family VARCHAR(50) NOT NULL DEFAULT 'SAE J300', description VARCHAR(255) NULL, sort_order INT NOT NULL DEFAULT 0, active TINYINT(1) NOT NULL DEFAULT 1, created_at DATETIME NULL, updated_at DATETIME NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE oil_products ADD COLUMN IF NOT EXISTS viscosity_id INT UNSIGNED NULL AFTER name;

ALTER TABLE oil_products ADD INDEX IF NOT EXISTS idx_oil_viscosity_id (viscosity_id);

ALTER TABLE oil_standards ADD COLUMN IF NOT EXISTS standard_group VARCHAR(40) NOT NULL DEFAULT 'OEM' AFTER issuer;

ALTER TABLE oil_standards ADD INDEX IF NOT EXISTS idx_oil_standard_group (standard_group);

INSERT INTO oil_viscosities(code,standard_family,description,sort_order,active,created_at,updated_at) VALUES
('0W12','SAE J300','', 1,1,NOW(),NOW()),
('0W16','SAE J300','', 2,1,NOW(),NOW()),
('0W20','SAE J300','', 3,1,NOW(),NOW()),
('0W30','SAE J300','', 4,1,NOW(),NOW()),
('0W40','SAE J300','', 5,1,NOW(),NOW()),
('0W8','SAE J300','', 6,1,NOW(),NOW()),
('10W','SAE J300','', 7,1,NOW(),NOW()),
('10W30','SAE J300','', 8,1,NOW(),NOW()),
('10W40','SAE J300','', 9,1,NOW(),NOW()),
('10W50','SAE J300','', 10,1,NOW(),NOW()),
('10W60','SAE J300','', 11,1,NOW(),NOW()),
('15W30','SAE J300','', 12,1,NOW(),NOW()),
('15W40','SAE J300','', 13,1,NOW(),NOW()),
('15W50','SAE J300','', 14,1,NOW(),NOW()),
('15W60','SAE J300','', 15,1,NOW(),NOW()),
('20W','SAE J300','', 16,1,NOW(),NOW()),
('20W20','SAE J300','', 17,1,NOW(),NOW()),
('20W40','SAE J300','', 18,1,NOW(),NOW()),
('20W50','SAE J300','', 19,1,NOW(),NOW()),
('20W60','SAE J300','', 20,1,NOW(),NOW()),
('25W40','SAE J300','', 21,1,NOW(),NOW()),
('25W50','SAE J300','', 22,1,NOW(),NOW()),
('25W60','SAE J300','', 23,1,NOW(),NOW()),
('30','SAE J300','', 24,1,NOW(),NOW()),
('30W','SAE J300','', 25,1,NOW(),NOW()),
('40','SAE J300','', 26,1,NOW(),NOW()),
('50','SAE J300','', 27,1,NOW(),NOW()),
('5W20','SAE J300','', 28,1,NOW(),NOW()),
('5W30','SAE J300','', 29,1,NOW(),NOW()),
('5W40','SAE J300','', 30,1,NOW(),NOW()),
('5W50','SAE J300','', 31,1,NOW(),NOW()),
('6','SAE J300','', 32,1,NOW(),NOW()),
('75W','SAE J306','', 33,1,NOW(),NOW()),
('75W80','SAE J306','', 34,1,NOW(),NOW()),
('75W90','SAE J306','', 35,1,NOW(),NOW()),
('80W90','SAE J306','', 36,1,NOW(),NOW()),
('85W90','SAE J306','', 37,1,NOW(),NOW())
ON DUPLICATE KEY UPDATE standard_family=VALUES(standard_family),active=1,updated_at=NOW();

INSERT INTO oil_standards(code,issuer,standard_group,description,active,created_at,updated_at) VALUES
('ACEA A1','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA A2','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA A3','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA A5','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA A7','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA B1','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA B2','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA B3','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA B3-16','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA B4','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA B4-16','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA B5','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA B7','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA C1','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA C2','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA C3','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA C4','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA C5','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA C5-21','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA C6','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA C6-21','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA C7','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA E11','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA E2','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA E3','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA E4','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA E5','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA E6','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA E7','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA E8','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA E9','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA E9-16','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA F01','ACEA','ACEA','',1,NOW(),NOW()),
('ACEA PD2','ACEA','ACEA','',1,NOW(),NOW()),
('CB','API','API','',1,NOW(),NOW()),
('CC','API','API','',1,NOW(),NOW()),
('CD','API','API','',1,NOW(),NOW()),
('CE','API','API','',1,NOW(),NOW()),
('CF','API','API','',1,NOW(),NOW()),
('CF-2','API','API','',1,NOW(),NOW()),
('CF-4','API','API','',1,NOW(),NOW()),
('CG-4','API','API','',1,NOW(),NOW()),
('CH-4','API','API','',1,NOW(),NOW()),
('CI-4','API','API','',1,NOW(),NOW()),
('CI-4+','API','API','',1,NOW(),NOW()),
('CJ-4','API','API','',1,NOW(),NOW()),
('CK-4','API','API','',1,NOW(),NOW()),
('CL-4','API','API','',1,NOW(),NOW()),
('FA-4','API','API','',1,NOW(),NOW()),
('GL-3','API/GL','API','',1,NOW(),NOW()),
('GL-4','API/GL','API','',1,NOW(),NOW()),
('GL-4+','API/GL','API','',1,NOW(),NOW()),
('GL-5','API/GL','API','',1,NOW(),NOW()),
('ILSAC GF-2','ILSAC','API','',1,NOW(),NOW()),
('ILSAC GF-3','ILSAC','API','',1,NOW(),NOW()),
('ILSAC GF-4','ILSAC','API','',1,NOW(),NOW()),
('ILSAC GF-5','ILSAC','API','',1,NOW(),NOW()),
('ILSAC GF-6','ILSAC','API','',1,NOW(),NOW()),
('ILSAC GF-6A','ILSAC','API','',1,NOW(),NOW()),
('ILSAC GF-6B','ILSAC','API','',1,NOW(),NOW()),
('ILSAC GF-7','ILSAC','API','',1,NOW(),NOW()),
('ILSAC GF-7A','ILSAC','API','',1,NOW(),NOW()),
('ILSAC GF-7B','ILSAC','API','',1,NOW(),NOW()),
('RC','API','API','',1,NOW(),NOW()),
('SA','API','API','',1,NOW(),NOW()),
('SC','API','API','',1,NOW(),NOW()),
('SD','API','API','',1,NOW(),NOW()),
('SE','API','API','',1,NOW(),NOW()),
('SF','API','API','',1,NOW(),NOW()),
('SG','API','API','',1,NOW(),NOW()),
('SH','API','API','',1,NOW(),NOW()),
('SJ','API','API','',1,NOW(),NOW()),
('SL','API','API','',1,NOW(),NOW()),
('SM','API','API','',1,NOW(),NOW()),
('SN','API','API','',1,NOW(),NOW()),
('SN+','API','API','',1,NOW(),NOW()),
('SP','API','API','',1,NOW(),NOW()),
('SQ','API','API','',1,NOW(),NOW()),
('TA','API','API','',1,NOW(),NOW()),
('TB','API','API','',1,NOW(),NOW()),
('TC','API','API','',1,NOW(),NOW()),
('TC+','API','API','',1,NOW(),NOW()),
('TD','API','API','',1,NOW(),NOW()),
('TSC4','API','API','',1,NOW(),NOW()),
('SAE J300','SAE','OEM','',1,NOW(),NOW()),
('SAE J306','SAE','OEM','',1,NOW(),NOW()),
('JASO MA2','JASO','OEM','',1,NOW(),NOW()),
('2G TA-003 AGENITOR 2','2G','OEM','',1,NOW(),NOW()),
('2G TA-003 AGENITOR 3','2G','OEM','',1,NOW(),NOW()),
('AAE (STO 003) GROUP B7','AAE','OEM','',1,NOW(),NOW()),
('ABARTH 0101','ABARTH','OEM','',1,NOW(),NOW()),
('ABARTH 0102','ABARTH','OEM','',1,NOW(),NOW()),
('AFNOR NF E 48-603 HM','AFNOR','OEM','',1,NOW(),NOW()),
('AFNOR NF E 48-603 HV','AFNOR','OEM','',1,NOW(),NOW()),
('AFNOR NF E 68-603 E','AFNOR','OEM','',1,NOW(),NOW()),
('AGROGEN','AGROGEN','OEM','',1,NOW(),NOW()),
('ALLISON C3','ALLISON','OEM','',1,NOW(),NOW()),
('ALLISON C4','ALLISON','OEM','',1,NOW(),NOW()),
('ALLISON TES-439','ALLISON','OEM','',1,NOW(),NOW()),
('ASTM D2896, FB-80813K, FB-83139K, NMMA FC-W','ASTM','OEM','',1,NOW(),NOW()),
('ASTM D2896, FB-80813K, NMMA FC-W','ASTM','OEM','',1,NOW(),NOW()),
('ASTON MARTIN','ASTON','OEM','',1,NOW(),NOW()),
('BMW 8321 0398 507','BMW','OEM','',1,NOW(),NOW()),
('BMW 8321 0398 508','BMW','OEM','',1,NOW(),NOW()),
('BMW 8321 2365 935','BMW','OEM','',1,NOW(),NOW()),
('BMW 8322 2433 157','BMW','OEM','',1,NOW(),NOW()),
('BMW DCTF 2','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-01','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-01 FE','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-01 FE model up to END 2018','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-01 model up to END 2018','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-03','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-04','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-04 model up to END 2018','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-12 FE','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-14 FE+','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-17 FE+','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-19 FE','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-22 FE++','BMW','OEM','',1,NOW(),NOW()),
('BMW LL-98','BMW','OEM','',1,NOW(),NOW()),
('BMW M-MODEL','BMW','OEM','',1,NOW(),NOW()),
('BMW MTF LT-2','BMW','OEM','',1,NOW(),NOW()),
('BMW MTF LT-4','BMW','OEM','',1,NOW(),NOW()),
('BMW SPECIAL OIL','BMW','OEM','',1,NOW(),NOW()),
('BUNDESWEHR TL 9150-0107','BUNDESWEHR','OEM','',1,NOW(),NOW()),
('CASE I H MS 1118','CASE','OEM','',1,NOW(),NOW()),
('CASE I H MS 1204','CASE','OEM','',1,NOW(),NOW()),
('CASE I H MS 1206','CASE','OEM','',1,NOW(),NOW()),
('CASE I H MS 1207','CASE','OEM','',1,NOW(),NOW()),
('CASE I H MS 1209','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1120','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1121','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1204','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1205','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1206','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1207','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1209','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1210','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1216','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1230','CASE','OEM','',1,NOW(),NOW()),
('CASE MS 1317','CASE','OEM','',1,NOW(),NOW()),
('CATERPILLAR ECF-1','CATERPILLAR','OEM','',1,NOW(),NOW()),
('CATERPILLAR ECF-1A','CATERPILLAR','OEM','',1,NOW(),NOW()),
('CATERPILLAR ECF-2','CATERPILLAR','OEM','',1,NOW(),NOW()),
('CATERPILLAR ECF-3','CATERPILLAR','OEM','',1,NOW(),NOW()),
('CATERPILLAR HYDO ADVANCE','CATERPILLAR','OEM','',1,NOW(),NOW()),
('CATERPILLAR TO-2','CATERPILLAR','OEM','',1,NOW(),NOW()),
('CATERPILLAR TO-4M','CATERPILLAR','OEM','',1,NOW(),NOW()),
('CEC L-33-A-93','CEC','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-10725','CHRYSLER','OEM','',1,NOW(),NOW())
ON DUPLICATE KEY UPDATE issuer=VALUES(issuer),standard_group=VALUES(standard_group),active=1,updated_at=NOW();

INSERT INTO oil_standards(code,issuer,standard_group,description,active,created_at,updated_at) VALUES
('CHRYSLER MS-10850','CHRYSLER','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-10896','CHRYSLER','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-10902','CHRYSLER','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-11106','CHRYSLER','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-12145','CHRYSLER','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-12633','CHRYSLER','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-12991','CHRYSLER','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-13340','CHRYSLER','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-50081','CHRYSLER','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-6395','CHRYSLER','OEM','',1,NOW(),NOW()),
('CHRYSLER MS-90047','CHRYSLER','OEM','',1,NOW(),NOW()),
('CITROEN B71 2010','CITROEN','OEM','',1,NOW(),NOW()),
('CITROEN B71 2288','CITROEN','OEM','',1,NOW(),NOW()),
('CITROEN B71 2290','CITROEN','OEM','',1,NOW(),NOW()),
('CITROEN B71 2294','CITROEN','OEM','',1,NOW(),NOW()),
('CITROEN B71 2295','CITROEN','OEM','',1,NOW(),NOW()),
('CITROEN B71 2296','CITROEN','OEM','',1,NOW(),NOW()),
('CITROEN B71 2300','CITROEN','OEM','',1,NOW(),NOW()),
('CITROEN B71 2312','CITROEN','OEM','',1,NOW(),NOW()),
('CITROEN B71 2330','CITROEN','OEM','',1,NOW(),NOW()),
('CNH MAT 3505','CNH','OEM','',1,NOW(),NOW()),
('CNH MAT 3507','CNH','OEM','',1,NOW(),NOW()),
('CNH MAT 3509','CNH','OEM','',1,NOW(),NOW()),
('CNH MAT 3510','CNH','OEM','',1,NOW(),NOW()),
('CNH MAT 3520','CNH','OEM','',1,NOW(),NOW()),
('CNH MAT 3521','CNH','OEM','',1,NOW(),NOW()),
('CNH MAT 3522','CNH','OEM','',1,NOW(),NOW()),
('CNH MAT 3525','CNH','OEM','',1,NOW(),NOW()),
('CNH MAT 3526','CNH','OEM','',1,NOW(),NOW()),
('CNH MAT 3571','CNH','OEM','',1,NOW(),NOW()),
('CUMMINS 20071','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20072','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20074','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20075','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20076','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20077','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20078','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20081','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20085','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20086','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20087','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20092','CUMMINS','OEM','',1,NOW(),NOW()),
('CUMMINS 20100','CUMMINS','OEM','',1,NOW(),NOW()),
('DAF','DAF','OEM','',1,NOW(),NOW()),
('DAF ACEA E6','DAF','OEM','',1,NOW(),NOW()),
('DAF EXTENDED DRAIN','DAF','OEM','',1,NOW(),NOW()),
('DAF HP1','DAF','OEM','',1,NOW(),NOW()),
('DAF HP2','DAF','OEM','',1,NOW(),NOW()),
('DAF LD','DAF','OEM','',1,NOW(),NOW()),
('DAF PSQL 2.1E','DAF','OEM','',1,NOW(),NOW()),
('DAF PSQL 2.1E LD','DAF','OEM','',1,NOW(),NOW()),
('DAF PSQL 2.4','DAF','OEM','',1,NOW(),NOW()),
('DAF PSQL 2.4 LD','DAF','OEM','',1,NOW(),NOW()),
('DAF PX EURO VI','DAF','OEM','',1,NOW(),NOW()),
('DAF STANDARD DRAIN','DAF','OEM','',1,NOW(),NOW()),
('DAIHATSU','DAIHATSU','OEM','',1,NOW(),NOW()),
('DENISON HF-1','DENISON','OEM','',1,NOW(),NOW()),
('DENISON HF-2','DENISON','OEM','',1,NOW(),NOW()),
('DETROIT DIESEL 7SE270','DETROIT','OEM','',1,NOW(),NOW()),
('DETROIT DIESEL 93K214','DETROIT','OEM','',1,NOW(),NOW()),
('DETROIT DIESEL 93K215','DETROIT','OEM','',1,NOW(),NOW()),
('DETROIT DIESEL 93K216','DETROIT','OEM','',1,NOW(),NOW()),
('DETROIT DIESEL 93K218','DETROIT','OEM','',1,NOW(),NOW()),
('DETROIT DIESEL 93K222','DETROIT','OEM','',1,NOW(),NOW()),
('DETROIT DIESEL 93K223','DETROIT','OEM','',1,NOW(),NOW()),
('DEUTZ DQC I-02','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC I-05','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC II-05','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC II-10','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC II-10 LA','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC II-18','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC II-18 LA','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC III','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC III-05','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC III-10','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC III-10 LA','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC III-18','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC III-18 LA','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC IV','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC IV-05','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC IV-10','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC IV-10 LA','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC IV-18','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC IV-18 LA','DEUTZ','OEM','',1,NOW(),NOW()),
('DEUTZ DQC TTCD','DEUTZ','OEM','',1,NOW(),NOW()),
('DEXOS 1','GM','OEM','',1,NOW(),NOW()),
('DEXOS1 GEN2','GM','OEM','',1,NOW(),NOW()),
('DEXOS1 GEN3','GM','OEM','',1,NOW(),NOW()),
('DEXOS 2','GM','OEM','',1,NOW(),NOW()),
('DEXOS 2 NR D235AGDL081','GM','OEM','',1,NOW(),NOW()),
('DEXOS D','GM','OEM','',1,NOW(),NOW()),
('DEXOS R','GM','OEM','',1,NOW(),NOW()),
('DFS 93K223','DFS','OEM','',1,NOW(),NOW()),
('DTFR 13D100','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('DTFR 13D110','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('DTFR 15B110','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('DTFR 15B120','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('DTFR 15C100','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('DTFR 15C110','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('DTFR 15C120','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('DTFR 15C130','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('DTFR 15C140','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('DTFR 15D100','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('EATON I-286-S','EATON','OEM','',1,NOW(),NOW()),
('EATON M-2950-S','EATON','OEM','',1,NOW(),NOW()),
('FB-80813K, FB-83140K, NMMA FC-W','FB-80813K,','OEM','',1,NOW(),NOW()),
('FB-80813K, NMMA FC-W','FB-80813K,','OEM','',1,NOW(),NOW()),
('FB-83139K, NMMA FC-W','FB-83139K,','OEM','',1,NOW(),NOW()),
('FB-83140K, NMMA FC-W','FB-83140K,','OEM','',1,NOW(),NOW()),
('FCA MS-13340','FCA','OEM','',1,NOW(),NOW()),
('FC-W FB-13102U','FC-W','OEM','',1,NOW(),NOW()),
('FC-W FB-23656K','FC-W','OEM','',1,NOW(),NOW()),
('FC-W FB-23656K, NMMA FC-W','FC-W','OEM','',1,NOW(),NOW()),
('FENDT KDM 17/2012','FENDT','OEM','',1,NOW(),NOW()),
('FERRARI','FERRARI','OEM','',1,NOW(),NOW()),
('FIA-CIK','FIA-CIK','OEM','',1,NOW(),NOW()),
('FIAT 9.55535','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 CR1','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 D2','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 DH1','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 DM1','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 DS1','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 DSX','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 G1','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 G2','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 GH2','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 GS1','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 GSX','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 GSY','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 H2','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 H3','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 M2','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 N1','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 N2','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 S1','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 S2','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 S3','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 S4','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 T2','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55535 Z2','FIAT','OEM','',1,NOW(),NOW()),
('FIAT 9.55550 MZ1','FIAT','OEM','',1,NOW(),NOW()),
('FORD 2C-200','FORD','OEM','',1,NOW(),NOW()),
('FORD 2C-201','FORD','OEM','',1,NOW(),NOW()),
('FORD 82009201','FORD','OEM','',1,NOW(),NOW()),
('FORD 82009202','FORD','OEM','',1,NOW(),NOW()),
('FORD 82009203','FORD','OEM','',1,NOW(),NOW()),
('FORD F-DC','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C121 E','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C134 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C134 C','FORD','OEM','',1,NOW(),NOW())
ON DUPLICATE KEY UPDATE issuer=VALUES(issuer),standard_group=VALUES(standard_group),active=1,updated_at=NOW();

INSERT INTO oil_standards(code,issuer,standard_group,description,active,created_at,updated_at) VALUES
('FORD M2C134 D','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C153 E','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C159 B','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C159 B1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C159 C','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C171 D','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C171 E','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C171 F1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C200 B','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C212 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C213 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C213 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C214 B1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C218 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C41 B','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C48 B','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C48 C3','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C53 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C53 B','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C86 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C86 B','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C86 C','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C900 C','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C912 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C913 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C913 B','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C913 C','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C913 D','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C917 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C920 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C925 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C925 B','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C929 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C930 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C930 B','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C931 C','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C931 D','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C931 E1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C934 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C934 B','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C937 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C938 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C944 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C945 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C945 B1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C946 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C946 B1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C947 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C947 B1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C948 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C950 A','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C952 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C953 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C953 B1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C954 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C956 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C960 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C961 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C962 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C963 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD M2C970 A1','FORD','OEM','',1,NOW(),NOW()),
('FORD MERCON','FORD','OEM','',1,NOW(),NOW()),
('FORD MERCON LV','FORD','OEM','',1,NOW(),NOW()),
('FORD MERCON V','FORD','OEM','',1,NOW(),NOW()),
('FORD WSS-M2C948 B','FORD','OEM','',1,NOW(),NOW()),
('FORD XT-5 QMC','FORD','OEM','',1,NOW(),NOW()),
('GLOBAL DHD-1','GLOBAL','OEM','',1,NOW(),NOW()),
('GM','GM','OEM','',1,NOW(),NOW()),
('GM 19 40 768','GM','OEM','',1,NOW(),NOW()),
('GM 19 42 043','GM','OEM','',1,NOW(),NOW()),
('GM 19 42 046','GM','OEM','',1,NOW(),NOW()),
('GM 4718M','GM','OEM','',1,NOW(),NOW()),
('GM 6094A','GM','OEM','',1,NOW(),NOW()),
('GM 6094M','GM','OEM','',1,NOW(),NOW()),
('GM 93165213','GM','OEM','',1,NOW(),NOW()),
('GM LL-A-025','GM','OEM','',1,NOW(),NOW()),
('GM LL-B-025','GM','OEM','',1,NOW(),NOW()),
('GREAT WALL GWM','GREAT','OEM','',1,NOW(),NOW()),
('GWM','GWM','OEM','',1,NOW(),NOW()),
('HAVAL','HAVAL','OEM','',1,NOW(),NOW()),
('HONDA','HONDA','OEM','',1,NOW(),NOW()),
('HONDA HTO-6','HONDA','OEM','',1,NOW(),NOW()),
('HONDA MTF','HONDA','OEM','',1,NOW(),NOW()),
('HONDA MTF-II','HONDA','OEM','',1,NOW(),NOW()),
('HYUNDAI','HYUNDAI','OEM','',1,NOW(),NOW()),
('INFINITI','INFINITI','OEM','',1,NOW(),NOW()),
('INTERNATIONAL HARVESTER B-6 HY-TRAN','INTERNATIONAL','OEM','',1,NOW(),NOW()),
('ISUZU','ISUZU','OEM','',1,NOW(),NOW()),
('ISUZU DEO','ISUZU','OEM','',1,NOW(),NOW()),
('IVECO','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1804','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1804 T2 E7','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1804 T2 E7 C.T.R. NR I517.F06','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1804 T3 E4 C.T.R. NR I719.G08','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1804 TFE E4 C.T.R. NR I023.M01','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1804 TLS CK4 C.T.R. NR 037.F21','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1804 TLS E6','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1804 TLS E6 C.T.R. NR I720.I12','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1804 TLS E9','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1804 TLV LS','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1809 NG2 C.T.R. NR I508.N07','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1811','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1811 S1','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1811 SC1','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1811 SC1 LV','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1811 SC1 LV 16','IVECO','OEM','',1,NOW(),NOW()),
('IVECO 18-1811 SC1 LV C.T.R. NR I842.A14','IVECO','OEM','',1,NOW(),NOW()),
('IVECO NG2','IVECO','OEM','',1,NOW(),NOW()),
('IVECO S1','IVECO','OEM','',1,NOW(),NOW()),
('IVECO S2','IVECO','OEM','',1,NOW(),NOW()),
('IVECO T2 E7','IVECO','OEM','',1,NOW(),NOW()),
('IVECO T3 E4','IVECO','OEM','',1,NOW(),NOW()),
('IVECO TFE','IVECO','OEM','',1,NOW(),NOW()),
('IVECO TLS CK-4','IVECO','OEM','',1,NOW(),NOW()),
('IVECO TLS E6','IVECO','OEM','',1,NOW(),NOW()),
('IVECO TLS E9','IVECO','OEM','',1,NOW(),NOW()),
('JAGUAR 02JDE 26444','JAGUAR','OEM','',1,NOW(),NOW()),
('JAGUAR 03.5003','JAGUAR','OEM','',1,NOW(),NOW()),
('JAGUAR 03.5004','JAGUAR','OEM','',1,NOW(),NOW()),
('JAGUAR 03.5005','JAGUAR','OEM','',1,NOW(),NOW()),
('JAGUAR 03.5006','JAGUAR','OEM','',1,NOW(),NOW()),
('JAGUAR 03.5007','JAGUAR','OEM','',1,NOW(),NOW()),
('JAGUAR 51.5122','JAGUAR','OEM','',1,NOW(),NOW()),
('JAGUAR M2C913-B','JAGUAR','OEM','',1,NOW(),NOW()),
('JASO DH-1','JASO','OEM','',1,NOW(),NOW()),
('JASO DH-2','JASO','OEM','',1,NOW(),NOW()),
('JASO DL-0','JASO','OEM','',1,NOW(),NOW()),
('JASO DL-1','JASO','OEM','',1,NOW(),NOW()),
('JASO F, NMMA TC-W3, RL-30010H C','JASO','OEM','',1,NOW(),NOW()),
('JASO FB','JASO','OEM','',1,NOW(),NOW()),
('JASO FB, NMMA TC-W3','JASO','OEM','',1,NOW(),NOW()),
('JASO FB, NMMA TC-W3, RL-29901H','JASO','OEM','',1,NOW(),NOW()),
('JASO FC','JASO','OEM','',1,NOW(),NOW()),
('JASO FD','JASO','OEM','',1,NOW(),NOW()),
('JASO GLV-1','JASO','OEM','',1,NOW(),NOW()),
('JASO MA','JASO','OEM','',1,NOW(),NOW()),
('JASO MA-2','JASO','OEM','',1,NOW(),NOW()),
('JASO MB','JASO','OEM','',1,NOW(),NOW()),
('JCMAS P041 HK','JCMAS','OEM','',1,NOW(),NOW()),
('JOHN DEERE 78A','JOHN','OEM','',1,NOW(),NOW()),
('JOHN DEERE 78X','JOHN','OEM','',1,NOW(),NOW()),
('JOHN DEERE J14A','JOHN','OEM','',1,NOW(),NOW()),
('JOHN DEERE J14B','JOHN','OEM','',1,NOW(),NOW()),
('JOHN DEERE J14C','JOHN','OEM','',1,NOW(),NOW()),
('JOHN DEERE J20A','JOHN','OEM','',1,NOW(),NOW()),
('JOHN DEERE J20B','JOHN','OEM','',1,NOW(),NOW()),
('JOHN DEERE J20C','JOHN','OEM','',1,NOW(),NOW()),
('JOHN DEERE J20D','JOHN','OEM','',1,NOW(),NOW()),
('JOHN DEERE J21A','JOHN','OEM','',1,NOW(),NOW()),
('JOHN DEERE J27','JOHN','OEM','',1,NOW(),NOW())
ON DUPLICATE KEY UPDATE issuer=VALUES(issuer),standard_group=VALUES(standard_group),active=1,updated_at=NOW();

INSERT INTO oil_standards(code,issuer,standard_group,description,active,created_at,updated_at) VALUES
('JOHN DEERE J27D','JOHN','OEM','',1,NOW(),NOW()),
('KAMAZ','KAMAZ','OEM','',1,NOW(),NOW()),
('KAMAZ V-8','KAMAZ','OEM','',1,NOW(),NOW()),
('KIA','KIA','OEM','',1,NOW(),NOW()),
('KIA 03100-00130','KIA','OEM','',1,NOW(),NOW()),
('KOMATSU HO-46','KOMATSU','OEM','',1,NOW(),NOW()),
('KOMATSU TO-30','KOMATSU','OEM','',1,NOW(),NOW()),
('LAND ROVER','LAND','OEM','',1,NOW(),NOW()),
('LAND ROVER 03.5003','LAND','OEM','',1,NOW(),NOW()),
('LAND ROVER 03.5004','LAND','OEM','',1,NOW(),NOW()),
('LAND ROVER 03.5005','LAND','OEM','',1,NOW(),NOW()),
('LAND ROVER 03.5006','LAND','OEM','',1,NOW(),NOW()),
('LAND ROVER 03.5007','LAND','OEM','',1,NOW(),NOW()),
('LAND ROVER 51.5122','LAND','OEM','',1,NOW(),NOW()),
('LEXUS','LEXUS','OEM','',1,NOW(),NOW()),
('LEXUS LFA','LEXUS','OEM','',1,NOW(),NOW()),
('LIEBHERR LH-00-ENG LA','LIEBHERR','OEM','',1,NOW(),NOW()),
('LIEBHERR LH-00-ENG LA-22 STD DIESEL','LIEBHERR','OEM','',1,NOW(),NOW()),
('MACK EO-K','MACK','OEM','',1,NOW(),NOW()),
('MACK EO-L','MACK','OEM','',1,NOW(),NOW()),
('MACK EO-M','MACK','OEM','',1,NOW(),NOW()),
('MACK EO-M PLUS','MACK','OEM','',1,NOW(),NOW()),
('MACK EO-M PREMIUM PLUS','MACK','OEM','',1,NOW(),NOW()),
('MACK EO-N','MACK','OEM','',1,NOW(),NOW()),
('MACK EO-N PREMIUM PLUS','MACK','OEM','',1,NOW(),NOW()),
('MACK EO-O PLUS','MACK','OEM','',1,NOW(),NOW()),
('MACK EO-O PREMIUM PLUS','MACK','OEM','',1,NOW(),NOW()),
('MACK EO-S 4.5','MACK','OEM','',1,NOW(),NOW()),
('MACK EOs-5','MACK','OEM','',1,NOW(),NOW()),
('MACK EO-S 5','MACK','OEM','',1,NOW(),NOW()),
('MAN 270','MAN','OEM','',1,NOW(),NOW()),
('MAN 271','MAN','OEM','',1,NOW(),NOW()),
('MAN 271-1','MAN','OEM','',1,NOW(),NOW()),
('MAN 3271-1','MAN','OEM','',1,NOW(),NOW()),
('MAN 3271-3','MAN','OEM','',1,NOW(),NOW()),
('MAN 3271-4','MAN','OEM','',1,NOW(),NOW()),
('MAN 3275','MAN','OEM','',1,NOW(),NOW()),
('MAN 3275-1','MAN','OEM','',1,NOW(),NOW()),
('MAN 3277','MAN','OEM','',1,NOW(),NOW()),
('MAN 3277 CRT','MAN','OEM','',1,NOW(),NOW()),
('MAN 3377','MAN','OEM','',1,NOW(),NOW()),
('MAN 3477','MAN','OEM','',1,NOW(),NOW()),
('MAN 3575','MAN','OEM','',1,NOW(),NOW()),
('MAN 3677','MAN','OEM','',1,NOW(),NOW()),
('MAN 3775','MAN','OEM','',1,NOW(),NOW()),
('MAN 3777','MAN','OEM','',1,NOW(),NOW()),
('MAN 3977','MAN','OEM','',1,NOW(),NOW()),
('MASSEY FERGUSON 1127A','MASSEY','OEM','',1,NOW(),NOW()),
('MASSEY FERGUSON 1135','MASSEY','OEM','',1,NOW(),NOW()),
('MASSEY FERGUSON 1138','MASSEY','OEM','',1,NOW(),NOW()),
('MASSEY FERGUSON 1139','MASSEY','OEM','',1,NOW(),NOW()),
('MASSEY FERGUSON 1141','MASSEY','OEM','',1,NOW(),NOW()),
('MASSEY FERGUSON 1143','MASSEY','OEM','',1,NOW(),NOW()),
('MASSEY FERGUSON 1144','MASSEY','OEM','',1,NOW(),NOW()),
('MASSEY FERGUSON 1145','MASSEY','OEM','',1,NOW(),NOW()),
('MAZDA','MAZDA','OEM','',1,NOW(),NOW()),
('MB 000989890110','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 226.5','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 226.51','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 226.52','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 226.9','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 227.1','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 227.61','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 228.0','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 228.1','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 228.3','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 228.31','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 228.5','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 228.51','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 228.52','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 228.61','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 228.71','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 229.1','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 229.3','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 229.31','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 229.5','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 229.51','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 229.52','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 229.6','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 229.61','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 229.71','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 229.72','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 235.27','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 235.28','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 235.7','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 236.20','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 239.21','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 239.71','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MB 239.72','Mercedes-Benz','OEM','',1,NOW(),NOW()),
('MIL L-2104D','MIL','OEM','',1,NOW(),NOW()),
('MIL L-2104E','MIL','OEM','',1,NOW(),NOW()),
('MITSUBISHI','MITSUBISHI','OEM','',1,NOW(),NOW()),
('MS-A0921','MS-A0921','OEM','',1,NOW(),NOW()),
('MTU DK-BS-0001 B','MTU','OEM','',1,NOW(),NOW()),
('MTU DK-BS-0001 E','MTU','OEM','',1,NOW(),NOW()),
('MTU DK-BS-0001 P','MTU','OEM','',1,NOW(),NOW()),
('MTU DK-BS-0002 B','MTU','OEM','',1,NOW(),NOW()),
('MTU TYP 1','MTU','OEM','',1,NOW(),NOW()),
('MTU TYP 2','MTU','OEM','',1,NOW(),NOW()),
('MTU TYP 2.1','MTU','OEM','',1,NOW(),NOW()),
('MTU TYP 3','MTU','OEM','',1,NOW(),NOW()),
('MTU TYP 3.1','MTU','OEM','',1,NOW(),NOW()),
('NATO O-1180','NATO','OEM','',1,NOW(),NOW()),
('NEW HOLLAND','NEW','OEM','',1,NOW(),NOW()),
('NEW HOLLAND 030C','NEW','OEM','',1,NOW(),NOW()),
('NEW HOLLAND 330G','NEW','OEM','',1,NOW(),NOW()),
('NEW HOLLAND 410B','NEW','OEM','',1,NOW(),NOW()),
('NEW HOLLAND 410C','NEW','OEM','',1,NOW(),NOW()),
('NEW HOLLAND 420A','NEW','OEM','',1,NOW(),NOW()),
('NEW HOLLAND 82009201','NEW','OEM','',1,NOW(),NOW()),
('NEW HOLLAND 82009202','NEW','OEM','',1,NOW(),NOW()),
('NEW HOLLAND 82009203','NEW','OEM','',1,NOW(),NOW()),
('NEW HOLLAND FNHA 2C-200.00','NEW','OEM','',1,NOW(),NOW()),
('NEW HOLLAND FNHA 2C-201.00','NEW','OEM','',1,NOW(),NOW()),
('NH 330H','NH','OEM','',1,NOW(),NOW()),
('NH 82009201','NH','OEM','',1,NOW(),NOW()),
('NH 82009202','NH','OEM','',1,NOW(),NOW()),
('NH 82009203','NH','OEM','',1,NOW(),NOW()),
('NISSAN','NISSAN','OEM','',1,NOW(),NOW()),
('NMMA FC-W','NMMA','OEM','',1,NOW(),NOW()),
('NMMA TC-W3','NMMA','OEM','',1,NOW(),NOW()),
('NMMA TC-W3, RL-90001G','NMMA','OEM','',1,NOW(),NOW()),
('OPEL 6094M','OPEL','OEM','',1,NOW(),NOW()),
('OPEL LL-A-025','OPEL','OEM','',1,NOW(),NOW()),
('OPEL LL-B-025','OPEL','OEM','',1,NOW(),NOW()),
('OPEL OV0401547','OPEL','OEM','',1,NOW(),NOW()),
('OPEL OV0401547-A20','OPEL','OEM','',1,NOW(),NOW()),
('OPEL OV0401547-A30','OPEL','OEM','',1,NOW(),NOW()),
('OPEL OV0401547-D30','OPEL','OEM','',1,NOW(),NOW()),
('OPEL OV0401547-D40','OPEL','OEM','',1,NOW(),NOW()),
('OPEL OV0401547-G30','OPEL','OEM','',1,NOW(),NOW()),
('OPEL OV0401547-G40','OPEL','OEM','',1,NOW(),NOW()),
('PERKINS','PERKINS','OEM','',1,NOW(),NOW()),
('PEUGEOT B71 2010','PEUGEOT','OEM','',1,NOW(),NOW()),
('PEUGEOT B71 2288','PEUGEOT','OEM','',1,NOW(),NOW()),
('PEUGEOT B71 2290','PEUGEOT','OEM','',1,NOW(),NOW()),
('PEUGEOT B71 2294','PEUGEOT','OEM','',1,NOW(),NOW()),
('PEUGEOT B71 2295','PEUGEOT','OEM','',1,NOW(),NOW()),
('PEUGEOT B71 2296','PEUGEOT','OEM','',1,NOW(),NOW()),
('PEUGEOT B71 2300','PEUGEOT','OEM','',1,NOW(),NOW()),
('PEUGEOT B71 2312','PEUGEOT','OEM','',1,NOW(),NOW()),
('PEUGEOT B71 2330','PEUGEOT','OEM','',1,NOW(),NOW()),
('PN-73/C-96085','PN-73/C-96085','OEM','',1,NOW(),NOW()),
('PN-79/C-96088/04','PN-79/C-96088/04','OEM','',1,NOW(),NOW()),
('PORSCHE 000 043 20','PORSCHE','OEM','',1,NOW(),NOW()),
('PORSCHE A40','PORSCHE','OEM','',1,NOW(),NOW()),
('PORSCHE C20','PORSCHE','OEM','',1,NOW(),NOW()),
('PORSCHE C30','PORSCHE','OEM','',1,NOW(),NOW()),
('PORSCHE C40','PORSCHE','OEM','',1,NOW(),NOW()),
('PORSCHE C40 GT','PORSCHE','OEM','',1,NOW(),NOW())
ON DUPLICATE KEY UPDATE issuer=VALUES(issuer),standard_group=VALUES(standard_group),active=1,updated_at=NOW();

INSERT INTO oil_standards(code,issuer,standard_group,description,active,created_at,updated_at) VALUES
('PSA B71 2010','Stellantis/PSA','OEM','',1,NOW(),NOW()),
('PSA B71 2290','Stellantis/PSA','OEM','',1,NOW(),NOW()),
('PSA B71 2294','Stellantis/PSA','OEM','',1,NOW(),NOW()),
('PSA B71 2295','Stellantis/PSA','OEM','',1,NOW(),NOW()),
('PSA B71 2296','Stellantis/PSA','OEM','',1,NOW(),NOW()),
('PSA B71 2297','Stellantis/PSA','OEM','',1,NOW(),NOW()),
('PSA B71 2300','Stellantis/PSA','OEM','',1,NOW(),NOW()),
('PSA B71 2302','Stellantis/PSA','OEM','',1,NOW(),NOW()),
('PSA B71 2311','Stellantis/PSA','OEM','',1,NOW(),NOW()),
('PSA B71 2312','Stellantis/PSA','OEM','',1,NOW(),NOW()),
('RENAULT 7711785243','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT AN 2022','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT DW5','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RD','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RD-2','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RGD','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RLD','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RLD-2','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RLD-3','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RLD-4','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RLD-5','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RN 0700','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RN 0710','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RN 0720','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RN 17','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RN 17 FE','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RN 17 RSA','RENAULT','OEM','',1,NOW(),NOW()),
('RENAULT RXD','RENAULT','OEM','',1,NOW(),NOW()),
('SAUER DANFOSS','SAUER','OEM','',1,NOW(),NOW()),
('SAUER SUNDSTRAND HTF','SAUER','OEM','',1,NOW(),NOW()),
('SCANIA','SCANIA','OEM','',1,NOW(),NOW()),
('SCANIA LA','SCANIA','OEM','',1,NOW(),NOW()),
('SCANIA LDF','SCANIA','OEM','',1,NOW(),NOW()),
('SCANIA LDF-2','SCANIA','OEM','',1,NOW(),NOW()),
('SCANIA LDF-3','SCANIA','OEM','',1,NOW(),NOW()),
('SCANIA LDF-4','SCANIA','OEM','',1,NOW(),NOW()),
('SCANIA LDF-5','SCANIA','OEM','',1,NOW(),NOW()),
('SCANIA LDF-LA','SCANIA','OEM','',1,NOW(),NOW()),
('SCANIA LDV','SCANIA','OEM','',1,NOW(),NOW()),
('SCANIA LOW ASH','SCANIA','OEM','',1,NOW(),NOW()),
('SDFG OM 1901A','SDFG','OEM','',1,NOW(),NOW()),
('SDFG OT 1891','SDFG','OEM','',1,NOW(),NOW()),
('SDFG OU 1391','SDFG','OEM','',1,NOW(),NOW()),
('SEVA TRS-07','SEVA','OEM','',1,NOW(),NOW()),
('SPANNER RE2','SPANNER','OEM','',1,NOW(),NOW()),
('STELLANTIS FPW 9.55535/01','STELLANTIS','OEM','',1,NOW(),NOW()),
('STELLANTIS FPW 9.55535/02','STELLANTIS','OEM','',1,NOW(),NOW()),
('STELLANTIS FPW 9.55535/03','STELLANTIS','OEM','',1,NOW(),NOW()),
('STELLANTIS FPW 9.55535/04','STELLANTIS','OEM','',1,NOW(),NOW()),
('STELLANTIS FPW 9.55535/05','STELLANTIS','OEM','',1,NOW(),NOW()),
('STELLANTIS FPW 9.55535/09','STELLANTIS','OEM','',1,NOW(),NOW()),
('STELLANTIS FPW 9.55535/10','STELLANTIS','OEM','',1,NOW(),NOW()),
('STELLANTIS FPW 9.55535/DH1','STELLANTIS','OEM','',1,NOW(),NOW()),
('STEYR A-201','STEYR','OEM','',1,NOW(),NOW()),
('STEYR A-202','STEYR','OEM','',1,NOW(),NOW()),
('STEYR D-401','STEYR','OEM','',1,NOW(),NOW()),
('STJLR.03.5003','Jaguar Land Rover','OEM','',1,NOW(),NOW()),
('SUBARU','SUBARU','OEM','',1,NOW(),NOW()),
('SUZUKI','SUZUKI','OEM','',1,NOW(),NOW()),
('TC-W','TC-W','OEM','',1,NOW(),NOW()),
('TC-W3','TC-W3','OEM','',1,NOW(),NOW()),
('TC-WII','TC-WII','OEM','',1,NOW(),NOW()),
('TEDOM 61-0-0281.1 B','TEDOM','OEM','',1,NOW(),NOW()),
('TEDOM 61-0-0281.1 L','TEDOM','OEM','',1,NOW(),NOW()),
('TEDOM 61-0-0281.1 S','TEDOM','OEM','',1,NOW(),NOW()),
('TOYOTA','TOYOTA','OEM','',1,NOW(),NOW()),
('VAUXHALL OV0401547','VAUXHALL','OEM','',1,NOW(),NOW()),
('VAUXHALL OV0401547-A20','VAUXHALL','OEM','',1,NOW(),NOW()),
('VAUXHALL OV0401547-A30','VAUXHALL','OEM','',1,NOW(),NOW()),
('VAUXHALL OV0401547-D40','VAUXHALL','OEM','',1,NOW(),NOW()),
('VAUXHALL OV0401547-G40','VAUXHALL','OEM','',1,NOW(),NOW()),
('VICKERS I-286-S','VICKERS','OEM','',1,NOW(),NOW()),
('VICKERS M-2950-S','VICKERS','OEM','',1,NOW(),NOW()),
('VOITH CLASS A','VOITH','OEM','',1,NOW(),NOW()),
('VOITH CLASS B','VOITH','OEM','',1,NOW(),NOW()),
('VOITH RETARDER A','VOITH','OEM','',1,NOW(),NOW()),
('VOITH RETARDER B','VOITH','OEM','',1,NOW(),NOW()),
('VOLVO','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO 95200356','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO 95200377','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO 97308','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO 97309','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO CNG','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO RBS0-2AE','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO VDS','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO VDS-2','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO VDS-3','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO VDS-4','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO VDS-4.5','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO VDS-5','VOLVO','OEM','',1,NOW(),NOW()),
('VOLVO WB 101','VOLVO','OEM','',1,NOW(),NOW()),
('VW 500.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 501.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 501.01','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 502.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 503.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 503.01','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 504.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 505.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 505.01','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 506.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 506.01','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 507.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 508.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 509.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VW 511.00','Volkswagen','OEM','',1,NOW(),NOW()),
('VWC 53034','Volkswagen','OEM','',1,NOW(),NOW()),
('VWC 53035','Volkswagen','OEM','',1,NOW(),NOW()),
('VW C 530 35','Volkswagen','OEM','',1,NOW(),NOW()),
('VWC 53036','Volkswagen','OEM','',1,NOW(),NOW()),
('VW C 530 36','Volkswagen','OEM','',1,NOW(),NOW()),
('VWC 53057','Volkswagen','OEM','',1,NOW(),NOW()),
('VW G 052 195 M4','Volkswagen','OEM','',1,NOW(),NOW()),
('VW TL 525 77','Volkswagen','OEM','',1,NOW(),NOW()),
('WHITE FARM Q-1826','WHITE','OEM','',1,NOW(),NOW()),
('WULING','WULING','OEM','',1,NOW(),NOW()),
('ZETOR FORTERRA','ZETOR','OEM','',1,NOW(),NOW()),
('ZETOR PROXIMA','ZETOR','OEM','',1,NOW(),NOW()),
('ZETOR PROXIMA PLUS','ZETOR','OEM','',1,NOW(),NOW()),
('ZETOR PROXIMA POWER','ZETOR','OEM','',1,NOW(),NOW()),
('ZF TE-ML 02','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 04B','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 04D','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 06A','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 06B','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 06C','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 06D','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 06F','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 06L','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 06N','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 06Q','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 06R','ZF','OEM','',1,NOW(),NOW()),
('ZF TE-ML 07B','ZF','OEM','',1,NOW(),NOW())
ON DUPLICATE KEY UPDATE issuer=VALUES(issuer),standard_group=VALUES(standard_group),active=1,updated_at=NOW();

UPDATE oil_products o JOIN oil_viscosities v ON REPLACE(UPPER(o.viscosity),'-','')=REPLACE(UPPER(v.code),'-','') SET o.viscosity_id=v.id WHERE o.viscosity_id IS NULL;