1) Add ITCORR0 to CRU table in September 2022. Make CMCORR and ITCORRx floats.

ALTER TABLE CRU ADD ITCORR0 Number default NULL;

UPDATE CRU SET "ITCORR0"=1;

ALTER TABLE ITCORR1 MODIFY ( VAL00 Number, VAL01 Number, VAL02 Number, VAL03 Number, VAL04 Number, VAL05 Number, VAL06 Number, VAL07 Number, VAL08 Number, VAL09 Number, VAL10 Number, VAL11 Number, VAL12 Number, VAL13 Number, VAL14 Number, VAL15 Number, VAL16 Number, VAL17 Number, VAL18 Number, VAL19 Number, VAL20 Number, VAL21 Number, VAL22 Number, VAL23 Number, VAL24 Number, VAL25 Number, VAL26 Number, VAL27 Number, VAL28 Number, VAL29 Number, VAL30 Number, VAL31 Number, VAL32 Number, VAL33 Number, VAL34 Number, VAL35 Number, VAL36 Number, VAL37 Number, VAL38 Number, VAL39 Number, VAL40 Number, VAL41 Number, VAL42 Number, VAL43 Number, VAL44 Number, VAL45 Number, VAL46 Number, VAL47 Number, VAL48 Number, VAL49 Number, VAL50 Number, VAL51 Number, VAL52 Number, VAL53 Number, VAL54 Number, VAL55 Number, VAL56 Number, VAL57 Number, VAL58 Number, VAL59 Number, VAL60 Number, VAL61 Number, VAL62 Number, VAL63 Number, VAL64 Number, VAL65 Number, VAL66 Number, VAL67 Number, VAL68 Number, VAL69 Number, VAL70 Number, VAL71 Number, VAL72 Number, VAL73 Number, VAL74 Number, VAL75 Number, VAL76 Number, VAL77 Number, VAL78 Number, VAL79 Number );

ALTER TABLE ITCORR2 MODIFY ( VAL00 Number, VAL01 Number, VAL02 Number, VAL03 Number, VAL04 Number, VAL05 Number, VAL06 Number, VAL07 Number, VAL08 Number, VAL09 Number, VAL10 Number, VAL11 Number, VAL12 Number, VAL13 Number, VAL14 Number, VAL15 Number, VAL16 Number, VAL17 Number, VAL18 Number, VAL19 Number, VAL20 Number, VAL21 Number, VAL22 Number, VAL23 Number, VAL24 Number, VAL25 Number, VAL26 Number, VAL27 Number, VAL28 Number, VAL29 Number, VAL30 Number, VAL31 Number, VAL32 Number, VAL33 Number, VAL34 Number, VAL35 Number, VAL36 Number, VAL37 Number, VAL38 Number, VAL39 Number, VAL40 Number, VAL41 Number, VAL42 Number, VAL43 Number, VAL44 Number, VAL45 Number, VAL46 Number, VAL47 Number, VAL48 Number, VAL49 Number, VAL50 Number, VAL51 Number, VAL52 Number, VAL53 Number, VAL54 Number, VAL55 Number, VAL56 Number, VAL57 Number, VAL58 Number, VAL59 Number, VAL60 Number, VAL61 Number, VAL62 Number, VAL63 Number, VAL64 Number, VAL65 Number, VAL66 Number, VAL67 Number, VAL68 Number, VAL69 Number, VAL70 Number, VAL71 Number, VAL72 Number, VAL73 Number, VAL74 Number, VAL75 Number, VAL76 Number, VAL77 Number, VAL78 Number, VAL79 Number );

ALTER TABLE CMCORR MODIFY ( VAL00 Number, VAL01 Number, VAL02 Number, VAL03 Number, VAL04 Number, VAL05 Number, VAL06 Number, VAL07 Number, VAL08 Number, VAL09 Number, VAL10 Number, VAL11 Number, VAL12 Number, VAL13 Number, VAL14 Number, VAL15 Number, VAL16 Number, VAL17 Number, VAL18 Number, VAL19 Number, VAL20 Number, VAL21 Number, VAL22 Number, VAL23 Number, VAL24 Number, VAL25 Number, VAL26 Number, VAL27 Number, VAL28 Number, VAL29 Number, VAL30 Number, VAL31 Number, VAL32 Number, VAL33 Number, VAL34 Number, VAL35 Number, VAL36 Number, VAL37 Number, VAL38 Number, VAL39 Number, VAL40 Number, VAL41 Number, VAL42 Number, VAL43 Number, VAL44 Number, VAL45 Number, VAL46 Number, VAL47 Number, VAL48 Number, VAL49 Number, VAL50 Number, VAL51 Number, VAL52 Number, VAL53 Number, VAL54 Number, VAL55 Number, VAL56 Number, VAL57 Number, VAL58 Number, VAL59 Number, VAL60 Number, VAL61 Number, VAL62 Number, VAL63 Number, VAL64 Number, VAL65 Number, VAL66 Number, VAL67 Number, VAL68 Number, VAL69 Number, VAL70 Number, VAL71 Number, VAL72 Number, VAL73 Number, VAL74 Number, VAL75 Number, VAL76 Number, VAL77 Number, VAL78 Number, VAL79 Number );

===================

2) Add ITF_EN, CMC_EN, OFFSET and RESYNC_EN to CRU table in November 2022

ALTER TABLE CRU ADD ( ITF_EN Number(1,0) default NULL, CMC_EN Number(20,0) default NULL, OFFSET Number(4,0) default NULL, RESYNC_EN Number(1,0) default NULL );

UPDATE CRU SET "ITF_EN"=0, "CMC_EN"=0, "OFFSET"=0, "RESYNC_EN"=0;

3) Add BC_EN, CMC_THRESH1, CMC_MIN_MATCHES, CMC_MATCH_DISTANCE and CMC_WRITEOUT_EN to CRU table in September 2024

ALTER TABLE CRU ADD ( BC_EN Number(1,0) default NULL, CMC_THRESH1 Number(20,0) default NULL, CMC_MIN_MATCHES Number(4,0) default NULL, CMC_MATCH_DISTANCE Number(11,0) default NULL, CMC_WRITEOUT_EN Number(1,0) default NULL );

UPDATE CRU SET "BC_EN"=1, "CMC_THRESH1"=26112, "CMC_MIN_MATCHES"=6, "CMC_MATCH_DISTANCE"=16, "CMC_WRITEOUT_EN"=0;

bin/dbtool --testdb -TCRU -t2 -n0 -CBC_EN --updateall