jaipur hight - Case type Report

-- SQL file to insert data into case_type table for Jaipur High Court cases

INSERT INTO case_type (case_name, abbreviation, court_id, mattertype) VALUES
('ARBITRATION ACT CASE', 'ARB', 1, ''),
('ARBITRATION CASE (DOMESTIC COMMERCIAL)', 'ARB-DC', 1, ''),
('ARBITRATION CASE (INTERNATIONAL COMMERCIAL ARBITRATION)', 'ARB-ICA', 1, ''),
('CIVIL APPEAL/COMPANY APPLICATION', 'CA', 1, ''),
('COMMERCIAL APPEAL (WRIT)', 'CA-CWP', 1, ''),
('COMMERCIAL APPEAL (MISC)', 'CA-MISC', 1, ''),
('CONTEMPT APPEALS', 'CACP', 1, ''),
('COMPANY APPEAL', 'CAPP', 1, ''),
('CUSTOM CENTRAL EXCISE CASE', 'CCEC', 1, ''),
('CCES', 'CCES', 1, ''),
('CENTRAL EXCISE APPEAL', 'CEA', 1, ''),
('CENTRAL EXCISE CASE', 'CEC', 1, ''),
('CENTRAL EXCISE GOLD CASE', 'CEGC', 1, ''),
('CENTRAL EXCISE AND SALT REFERENCE', 'CESR', 1, ''),
('CLAIMS', 'CLAIM', 1, ''),
('CIVIL MISC', 'CM', 1, ''),
('COMPANY MISC. APPLICATION', 'CMA', 1, ''),
('HMA CASES U/S 24', 'CMM', 1, ''),
('CIVIL ORIGINAL', 'CO', 1, ''),
('CIVIL ORIGINAL (COMMERCIAL)', 'CO-COM', 1, ''),
('COMPANY APPLICATION', 'COA', 1, ''),
('CIVIL ORIGINAL CONTEMPT PETITION', 'COCP', 1, ''),
('COMPANY PETITIONS', 'CP', 1, ''),
('COMMERCIAL PETITION (MISC)', 'CP-MISC', 1, ''),
('CIVIL REVISION', 'CR', 1, ''),
('CIVIL REVISION (COMMERCIAL)', 'CR-COM', 1, ''),
('CRIMINAL APPEAL', 'CRA', 1, ''),
('CRIMINAL APPEAL ACQUITTAL DB', 'CRA-AD', 1, ''),
('CRIMINAL APPEAL ACQUITTAL SB', 'CRA-AS', 1, ''),
('CRIMINAL APPEAL DB', 'CRA-D', 1, ''),
('CRIMINAL APPEAL SB', 'CRA-S', 1, ''),
('CRIMINAL APPEAL CONTEMPT PETITION', 'CRACP', 1, ''),
('CIVIL REFERENCE', 'CREF', 1, ''),
('CRIMINAL MISCELLANEOUS PETITION', 'CRM', 1, ''),
('AGAINST ACQUITTALS', 'CRM-A', 1, ''),
('CRIMINAL MAIN', 'CRM-M', 1, ''),
('CRM IN CRWP', 'CRM-W', 1, ''),
('CRIMINAL ORIGINAL CONTEMPT PETITION', 'CROCP', 1, ''),
('CRIMINAL REVISION', 'CRR', 1, ''),
('CRIMINAL REVISION (FAMILY COURT)', 'CRR(F)', 1, ''),
('CRIMINAL REFERENCE', 'CRREF', 1, ''),
('CRIMINAL WRIT PETITION', 'CRWP', 1, ''),
('CIVIL SUIT', 'CS', 1, ''),
('CIVIL SUIT - ORIGINAL SIDE', 'CS-OS', 1, ''),
('CUSTOM APPEAL', 'CUSAP', 1, ''),
('CIVIL WRIT PETITION', 'CWP', 1, ''),
('CIVIL WRIT PETITION (COMMERCIAL)', 'CWP-COM', 1, ''),
('DIVORCE PETITION', 'DP', 1, ''),
('EXECUTION APPLICATION', 'EA', 1, ''),
('ESTATE DUTY CASE', 'EDC', 1, ''),
('ESTATE DUTY REFERENCE', 'EDREF', 1, ''),
('EXECUTION FIRST APPEAL', 'EFA', 1, ''),
('EXECUTION FIRST APPEAL (COMMERCIAL)', 'EFA-COM', 1, ''),
('ELECTION PETITIONS', 'EP', 1, ''),
('EXECUTION PETITION (COMMERCIAL)', 'EP-COM', 1, ''),
('EXECUTION SECOND APPEAL', 'ESA', 1, ''),
('FIRST APPEAL ORDER', 'FAO', 1, ''),
('FAO (FAMILY COURT)', 'FAO(FC)', 1, ''),
('FAO (CUSTOMS AND MTC)', 'FAO-C', 1, ''),
('FIRST APPEAL FROM ORDER (COMMERCIAL ARBITRATION)', 'FAO-CARB', 1, ''),
('FIRST APPEAL FROM ORDER (COMMERCIAL)', 'FAO-COM', 1, ''),
('FIRST APPEAL FROM ORDER (INTERNATIONAL COMM. ARBITRATION)', 'FAO-ICA', 1, ''),
('FIRST APPEAL ORDER - MATRIMONIAL', 'FAO-M', 1, ''),
('GOLD CONTROL REFERENCE', 'GCR', 1, ''),
('GENERAL SALES TAX REFERENCE', 'GSTR', 1, ''),
('GIFT TAX APPEAL', 'GTA', 1, ''),
('GIFT TAX CASE', 'GTC', 1, ''),
('GIFT TAX REFERENCE', 'GTR', 1, ''),
('GENERAL VAT REFERENCES', 'GVATR', 1, ''),
('INCOMPLETE OBJECTION CASE', 'INCOMP', 1, ''),
('INTEREST TAX APPEAL', 'INTTA', 1, ''),
('INTERIM ORDER IN', 'IOIN', 1, ''),
('INCOME TAX APPEAL', 'ITA', 1, ''),
('INCOME TAX CASES', 'ITC', 1, ''),
('INCOME TAX REFERENCE', 'ITR', 1, ''),
('LATTER PATENT APPEALS', 'LPA', 1, ''),
('LIQUIDATOR REPORT', 'LR', 1, ''),
('MATRIMONIAL REFERENCE', 'MATRF', 1, ''),
('MURDER REFERENCE CASE', 'MRC', 1, ''),
('ORIGINAL & MISCELLANEOUS', 'O&M', 1, ''),
('OFFICIAL LIQUIDATOR REPORT', 'OLR', 1, ''),
('PROBATE', 'PBT', 1, ''),
('PB VAT REVISION', 'PVR', 1, ''),
('REVIEW APPLICATION', 'RA', 1, ''),
('REVIEW IN COMPANY APPEAL', 'RA-CA', 1, ''),
('REVIEW IN COMPANY PETITION', 'RA-CP', 1, ''),
('REVIEW IN CIVIL REVISION', 'RA-CR', 1, ''),
('REVIEW IN CWP', 'RA-CW', 1, ''),
('REVIEW IN LPA', 'RA-LP', 1, ''),
('REVIEW APPLICATION IN RFA', 'RA-RF', 1, ''),
('REVIEW IN RSA', 'RA-RS', 1, ''),
('REVIEW IN CRCWP', 'RCRWP', 1, ''),
('REGULAR FIRST APPEAL', 'RFA', 1, ''),
('REGULAR FIRST APPEAL (COMMERCIAL)', 'RFA-COM', 1, ''),
('RECRIMINATION PETITION', 'RP', 1, ''),
('REGULAR SECOND APPEAL', 'RSA', 1, ''),
('SERVICE APPEAL', 'SA', 1, ''),
('SECOND APPEAL ORDER', 'SAO', 1, ''),
('STATE DUTY REFERENCE', 'SDR', 1, ''),
('SERVICE TAX APPEAL', 'STA', 1, ''),
('SALES TAX CASES', 'STC', 1, ''),
('SALES TAX REFERENCE', 'STR', 1, ''),
('TRANSFER APPLICATION', 'TA', 1, ''),
('TRANSFER APPLICATION (COMMERCIAL)', 'TA-COM', 1, ''),
('TAKENUP CASES', 'TC', 1, ''),
('TRANSFER CRIMINAL PETITION', 'TCRM', 1, ''),
('UT VAT APPEAL', 'UVA', 1, ''),
('UT VAT REVISION', 'UVR', 1, ''),
('VAT APPEAL', 'VATAP', 1, ''),
('VALUE ADDED TAX CASE', 'VATCASE', 1, ''),
('VAT REFERENCE', 'VATREF', 1, ''),
('WEALTH TAX APPEAL', 'WTA', 1, ''),
('WEALTH TAX CASES', 'WTC', 1, ''),
('WEALTH TAX REFERENCE', 'WTR', 1, ''),
('CROSS OBJECTION', 'XOBJ', 1, ''),
('CROSS OBJECTION IN CRIMINAL CASE', 'XOBJC', 1, ''),
('CROSS OBJECTION IN LPA', 'XOBJL', 1, ''),
('CROSS OBJECTION IN RFA', 'XOBJR', 1, ''),
('CROSS OBJECTION IN RSA', 'XOBJS', 1, '');