-- SQL script to reverse rename EDI columns from lowercase back to uppercase
-- This script is used after migration to restore original column names

ALTER TABLE CLAIM RENAME COLUMN edi TO "EDI";
ALTER TABLE CLAIMH RENAME COLUMN edi TO "EDI";
ALTER TABLE ELMAH$ERROR RENAME COLUMN ERRORID TO "ERRORID";
ALTER TABLE FACILITY RENAME COLUMN npi TO "NPI";
ALTER TABLE PAFILES RENAME COLUMN pafilesid TO "PAFILESID";
ALTER TABLE PAFILES RENAME COLUMN filemime TO "FILEMIME";
ALTER TABLE PAFILES RENAME COLUMN createdate TO "CREATEDATE";
ALTER TABLE PAFILES RENAME COLUMN filename TO "FILENAME";
ALTER TABLE PAFILES RENAME COLUMN dimension TO "DIMENSION";
ALTER TABLE PANAVCONTENT RENAME COLUMN panavcontentid TO "PANAVCONTENTID";
ALTER TABLE PANAVCONTENT RENAME COLUMN panavcontentname TO "PANAVCONTENTNAME";
ALTER TABLE PANAVCONTENT RENAME COLUMN panavcontenttype TO "PANAVCONTENTTYPE";
ALTER TABLE PATEMPLATE RENAME COLUMN patemplatename  TO "PATEMPLATENAME";
ALTER TABLE PATEMPLATE RENAME COLUMN patemplateid TO "PATEMPLATEID";
ALTER TABLE PRACTICE RENAME COLUMN npi TO "NPI";
ALTER TABLE PRODUCER RENAME COLUMN cda TO "CDA";
ALTER TABLE PTALERT RENAME COLUMN ndcid TO "NDCID";
ALTER TABLE INSURANC RENAME COLUMN edi TO "EDI";
ALTER TABLE INSURANC RENAME COLUMN npi TO "NPI";
ALTER TABLE INSURANC RENAME COLUMN cif TO "CIF";
ALTER TABLE PTALERTH RENAME COLUMN ndcid TO "NDCID";
ALTER TABLE TRX RENAME COLUMN edi TO "EDI";
ALTER TABLE USERS RENAME COLUMN pin TO "PIN";
ALTER TABLE USERSHIS RENAME COLUMN pin TO "PIN"; 
ALTER TABLE XRAYINFO RENAME COLUMN pa TO "PA";
ALTER TABLE XRAYINFO RENAME COLUMN fmx TO "FMX";