SO-3720 BuildingBlockRollback lookup table
[so.git] / adapters / mso-catalog-db-adapter / src / main / resources / db / migration / V8.9.1__AddBuildingBlockRollback.sql
1 use catalogdb;
2
3 CREATE TABLE IF NOT EXISTS `building_block_rollback` (
4     `ID` INT NOT NULL AUTO_INCREMENT,
5     `BUILDING_BLOCK_NAME` varchar(200) NOT NULL,
6     `ACTION` varchar(200) null,
7     `ROLLBACK_BUILDING_BLOCK_NAME` varchar(200) NOT NULL,
8     `ROLLBACK_ACTION` varchar(200) NULL,
9     PRIMARY KEY (`ID`)
10 )  ENGINE=InnoDB DEFAULT CHARSET=latin1;