| CREATE TABLE IF NOT EXISTS `MV_CREATION_METADATA` ( |
| `MV_CREATION_METADATA_ID` bigint(20) NOT NULL, |
| `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, |
| `TBL_NAME` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, |
| `TXN_LIST` TEXT DEFAULT NULL, |
| PRIMARY KEY (`MV_CREATION_METADATA_ID`) |
| ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| CREATE INDEX MV_UNIQUE_TABLE ON MV_CREATION_METADATA (TBL_NAME, DB_NAME) USING BTREE; |
| CREATE TABLE IF NOT EXISTS `MV_TABLES_USED` ( |
| `MV_CREATION_METADATA_ID` bigint(20) NOT NULL, |
| `TBL_ID` bigint(20) NOT NULL, |
| CONSTRAINT `MV_TABLES_USED_FK1` FOREIGN KEY (`MV_CREATION_METADATA_ID`) REFERENCES `MV_CREATION_METADATA` (`MV_CREATION_METADATA_ID`), |
| CONSTRAINT `MV_TABLES_USED_FK2` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`) |
| ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| |
| ALTER TABLE `COMPLETED_TXN_COMPONENTS` ADD `CTC_TIMESTAMP` timestamp; |
| UPDATE `COMPLETED_TXN_COMPONENTS` SET `CTC_TIMESTAMP` = CURRENT_TIMESTAMP; |
| ALTER TABLE `COMPLETED_TXN_COMPONENTS` MODIFY COLUMN `CTC_TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP; |
| CREATE INDEX COMPLETED_TXN_COMPONENTS_IDX ON COMPLETED_TXN_COMPONENTS (CTC_DATABASE, CTC_TABLE, CTC_PARTITION) USING BTREE; |