adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V8.9.1__AddBuildingBlockRollback.sql


1
2
3
4
5
6
7
8
9
10

use catalogdb;

CREATE TABLE IF NOT EXISTS `building_block_rollback` (
    `ID` INT NOT NULL AUTO_INCREMENT,
    `BUILDING_BLOCK_NAME` varchar(200) NOT NULL,
    `ACTION` varchar(200) null,
    `ROLLBACK_BUILDING_BLOCK_NAME` varchar(200) NOT NULL,
    `ROLLBACK_ACTION` varchar(200) NULL,
    PRIMARY KEY (`ID`)
)  ENGINE=InnoDB DEFAULT CHARSET=latin1;