Versions Compared

Old Version 3

changes.mady.by.user Kevin Timoney

Saved on

compared with

New Version 4

changes.mady.by.user Kevin Timoney

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This will copy the upgrade files from /home/policy/sql to $POLICY_HOME/etc/db/migration/<SCHEMA NAME>/sql/

It will also create a master upgrade script for each release

e.g. 01-honolulu.upgrade.sql, 02-istanbul.upgrade.sql

The master script calls the Each individual sql files that make up that release will be run as part of the upgrade.


Downgrade

Prior to downgrading run the following script:

...

This will copy the downgrade files from /home/policy/sql to $POLICY_HOME/etc/db/migration/<SCHEMA NAME>/sql/

It will also create a master downgrade script for each release

e.g. 01-honolulu.downgrade.sql, 02-istanbul.downgrade.sql

The master script calls the Each individual sql files that make up that release will be run as part of the downgrade downgrade.


Sample Test


export POLICY_HOME=/opt/app/policy
export SQL_USER=policy_user
export SQL_PASSWORD=*******
export SQL_HOST=mariadb

...

/opt/app/policy/bin/db-migrator -s policyadmin -o report

sleep 5

/opt/app/policy/bin/prepare_downgrade.sh policyadmin

/opt/app/policy/bin/db-migrator -s policyadmin -o downgrade -f 2 0900 -t 10800

/opt/app/policy/bin/db-migrator -s policyadmin -o report

...


drools-db-migration | Preparing 01-honolulu.upgrade.sqlupgrade version: 0800
drools-db-migration | Preparing 02-istanbul.upgrade.sqlupgrade version: 0900
drools-db-migration | Done
drools-db-migration | name version
drools-db-migration | policyadmin 0
drools-db-migration | policyadmin: upgrade available: 0 -> 020900
drools-db-migration | upgrade: 0 -> 020900
drools-db-migration |
drools-db-migration | > upgrade 01-honolulu.upgrade100-jpapdpgroup_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpgroup_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES VARCHAR(255) NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-dbSET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpstatistics_enginestats (AVERAGEEXECUTIONTIME DOUBLE DEFAULT NULL NULL, ENGINEID VARCHAR(255) NULL, ENGINETIMESTAMP BIGINT DEFAULT NULL NULL, ENGINEWORKERSTATE INT DEFAULT NULL NULL, EVENTCOUNT BIGINT DEFAULT NULL NULL, LASTENTERTIME BIGINT DEFAULT NULL NULL, LASTEXECUTIONTIME BIGINT DEFAULT NULL NULL, LASTSTART BIGINT DEFAULT NULL NULL, UPTIME BIGINT DEFAULT NULL NULL, ID BIGINT DEFAULT NULL NULL, name VARCHAR(120) NULL, version VARCHAR(20jpapdpgroup_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES VARCHAR(255) NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpsubgroup_policies (name VARCHAR(120) NULL, version VARCHAR(20) NULL, parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL)
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-------db-migration |
drools-db-migration | > upgrade 110-jpapdpstatistics_enginestats.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpsubgroup_properties (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, PROPERTIES VARCHAR(255) NULL, PROPERTIES_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpsubgroupjpapdpstatistics_supportedpolicytypes (name VARCHAR(120) enginestats (AVERAGEEXECUTIONTIME DOUBLE DEFAULT NULL NULL, version ENGINEID VARCHAR(20255) NULL, parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120ENGINETIMESTAMP BIGINT DEFAULT NULL NULL, ENGINEWORKERSTATE INT DEFAULT NULL NULL, EVENTCOUNT BIGINT DEFAULT NULL NULL, LASTENTERTIME BIGINT DEFAULT NULL NULL, LASTEXECUTIONTIME BIGINT DEFAULT NULL NULL, LASTSTART BIGINT DEFAULT NULL NULL, UPTIME BIGINT DEFAULT NULL NULL, ID BIGINT DEFAULT NULL NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_attributes (name VARCHAR(120) NULL, version VARCHAR(20) NULL, ATTRIBUTES LONGTEXT NULL, ATTRIBUTES_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)> upgrade 120-jpapdpsubgroup_policies.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL NULL)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignmentjpapdpsubgroup_properties policies (name VARCHAR(120) NULL, version VARCHAR(20) NULL, parentLocalName VARCHAR(120) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)> upgrade 130-jpapdpsubgroup_properties.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscadatatype_constraints (name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINTS VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscadatatype_metadata (name jpapdpsubgroup_properties (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, version parentKeyName VARCHAR(20120) NULL, METADATA PROPERTIES VARCHAR(255) NULL, METADATAPROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscadatatype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 140-jpapdpsubgroup_supportedpolicytypes.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscanodetemplatejpapdpsubgroup_properties supportedpolicytypes (name VARCHAR(120) NULL, version VARCHAR(20) NULL, parentLocalName VARCHAR(120) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscanodetype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 150-jpatoscacapabilityassignment_attributes.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscanodetype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicyjpatoscacapabilityassignment_metadata attributes (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) ATTRIBUTES LONGTEXT NULL, METADATAATTRIBUTES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicy_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 160-jpatoscacapabilityassignment_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicy_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytypejpatoscacapabilityassignment_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 170-jpatoscacapabilityassignment_occurrences.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytypejpatoscacapabilityassignment_triggers occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, TRIGGERS VARCHAR(255) OCCURRENCES INT DEFAULT NULL NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscaproperty_constraints (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, CONSTRAINTS VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 180-jpatoscacapabilityassignment_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscaproperty_metadata (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscarelationshiptypejpatoscacapabilityassignment_metadata properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) PROPERTIES LONGTEXT NULL, METADATAPROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 190-jpatoscacapabilitytype_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscarequirement_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscarequirementjpatoscacapabilitytype_occurrences metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscarequirement_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 200-jpatoscacapabilitytype_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscaservicetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscatopologytemplatejpatoscacapabilitytype_inputs properties (parentLocalName name VARCHAR(120) NULL, localName version VARCHAR(12020) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, INPUTS PROPERTIES LONGBLOB DEFAULT NULL NULL, INPUTSPROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdp (HEALTHY INT DEFAULT NULL NULL, MESSAGE VARCHAR(255) NULL, PDPSTATE INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDP PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-dbSET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 210-jpatoscadatatype_constraints.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpgroup (`DESCRIPTION` VARCHAR(255) NULL, PDPGROUPSTATE INT DEFAULT NULL NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPGROUP PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpgroupjpatoscadatatype_pdpsubgroup constraints (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, parentLocalName CONSTRAINTS VARCHAR(120255) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDPGROUP_PDPSUBGROUP PRIMARY KEY (name, version, parentLocalName, localName, parentKeyVersion, parentKeyName)))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 220-jpatoscadatatype_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdppolicystatus (DEPLOY BIT DEFAULT 0 NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, STATE INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_PDPPOLICYSTATUS PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscadatatype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpstatistics (PDPGROUPNAME VARCHAR(120) NULL, PDPSUBGROUPNAME VARCHAR(120) NULL, POLICYDEPLOYCOUNT BIGINT DEFAULT NULL NULL, POLICYDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, POLICYDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDFAILCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDSUCCESSCOUNT BIGINT DEFAULT NULL NULL, TIMESTAMP datetime DEFAULT NULL NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 230-jpatoscadatatype_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpsubgroup (CURRENTINSTANCECOUNT INT DEFAULT NULL NULL, DESIREDINSTANCECOUNT INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDPSUBGROUP PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpsubgroupjpatoscadatatype_pdp properties (pdpParentKeyName name VARCHAR(120) NOT NULL, pdpParentKeyVersion version VARCHAR(1520) NOT NULL, pdpParentLocalName VARCHAR(120) NOT NULL, pdpLocalName VARCHAR(120) NOT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDPSUBGROUP_PDP PRIMARY KEY (pdpParentKeyName, pdpParentKeyVersion, pdpParentLocalName, pdpLocalName, parentLocalName, localName, parentKeyVersion, parentKeyName))PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilityassignment (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENT PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 240-jpatoscanodetemplate_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilityassignments (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENTS PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilityassignmentsjpatoscanodetemplate_toscacapabilityassignment metadata (conceptContainerMapName name VARCHAR(120) NOT NULL, concpetContainerMapVersion version VARCHAR(20) NOT NULL, conceptContainerName METADATA VARCHAR(120255) NOT NULL, conceptContainerVersion METADATA_KEY VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENTS_TOSCACAPABILITYASSIGNMENT PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilitytype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYTYPE PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 250-jpatoscanodetemplate_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilitytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYTYPES PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilitytypesjpatoscanodetemplate_toscacapabilitytype properties (conceptContainerMapName name VARCHAR(120) NOT NULL, concpetContainerMapVersion version VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT PROPERTIES LONGTEXT NULL, conceptContainerVersion PROPERTIES_KEY VARCHAR(20) NOT NULL, name VARCHAR(120255) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCACAPABILITYTYPES_TOSCACAPABILITYTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscadatatype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCADATATYPE PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 260-jpatoscanodetype_metadata.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscadatatypes jpatoscanodetype_metadata (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, METADATA VARCHAR(255) NULL, CONSTRAINT PKMETADATA_TOSCADATATYPES PRIMARY KEY VARCHAR(name, version255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscadatatypes_toscadatatype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCADATATYPES_TOSCADATATYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 270-jpatoscanodetype_properties.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetemplate jpatoscanodetype_properties (`DESCRIPTION` name VARCHAR(255120) NULL, derived_from_name VARCHAR(255version VARCHAR(20) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL, type_version VARCHAR(255) NULL, capabilitiesName VARCHAR(120) NULL, capabilitiesVersion VARCHAR(20) NULL, requirementsVersion VARCHAR(20) NULL, requirementsName VARCHAR(120) NULL, CONSTRAINT PK_TOSCANODETEMPLATE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetemplates (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETEMPLATES PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 280-jpatoscapolicy_metadata.sql
drools-db-migration | ---------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetemplates_toscanodetemplate (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCANODETEMPLATES_TOSCANODETEMPLATE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))----
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, jpatoscapolicy_metadata (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, requirementsVersion METADATA VARCHAR(20255) NULL, requirementsName METADATA_KEY VARCHAR(120255) NULL, CONSTRAINT PK_TOSCANODETYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETYPES PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 290-jpatoscapolicy_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetypes_toscanodetype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCANODETYPES_TOSCANODETYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscaparameter jpatoscapolicy_properties (VALUE name VARCHAR(255120) NULL, parentLocalName version VARCHAR(12020) NOT NULL, localName VARCHAR(120) NOT PROPERTIES LONGTEXT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPARAMETER PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicies (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICIES PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 300-jpatoscapolicy_targets.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicies_toscapolicy (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPOLICIES_TOSCAPOLICY PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | ----------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicy (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, jpatoscapolicy_targets (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCAPOLICY PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicytype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICYTYPE PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 310-jpatoscapolicytype_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICYTYPES PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicytypesjpatoscapolicytype_toscapolicytype metadata (conceptContainerMapName name VARCHAR(120) NOT NULL, concpetContainerMapVersion version VARCHAR(20) NOT NULL, conceptContainerName METADATA VARCHAR(120255) NOT NULL, conceptContainerVersion METADATA_KEY VARCHAR(20255) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPOLICYTYPES_TOSCAPOLICYTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | )
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscaproperty (DEFAULTVALUE VARCHAR(255) NULL, `DESCRIPTION` VARCHAR(255) NULL, ENTRYSCHEMA LONGBLOB DEFAULT NULL NULL, REQUIRED BIT DEFAULT 0 NULL, STATUS INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPROPERTY PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarelationshiptype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPE PRIMARY KEY (name, version))> upgrade 320-jpatoscapolicytype_properties.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarelationshiptypes jpatoscapolicytype_properties (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, CONSTRAINT PKPROPERTIES_TOSCARELATIONSHIPTYPES PRIMARY KEY VARCHAR(name, version255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarelationshiptypes_toscarelationshiptype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPES_TOSCARELATIONSHIPTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 330-jpatoscapolicytype_targets.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarequirement jpatoscapolicytype_targets (CAPABILITY name VARCHAR(255120) NULL, `DESCRIPTION` VARCHAR(255) NULL, NODE VARCHAR(255) NULL, RELATIONSHIP VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCAREQUIREMENT PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarequirements (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAREQUIREMENTS PRIMARY KEY (name, version))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 340-jpatoscapolicytype_triggers.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarequirements_toscarequirement (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAREQUIREMENTS_TOSCAREQUIREMENT PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscaservicetemplate (`DESCRIPTION` VARCHAR(255) NULL, TOSCADEFINITIONSVERSION VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, jpatoscapolicytype_triggers (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, capabilityTypesVersion TRIGGERS VARCHAR(20255) NULL, capabilityTypesName VARCHAR(120) NULL, dataTypesName VARCHAR(120) NULL, dataTypesVersion VARCHAR(20) NULL, nodeTypesVersion VARCHAR(20) NULL, nodeTypesName VARCHAR(120) NULL, policyTypesName VARCHAR(120) NULL, policyTypesVersion VARCHAR(20) NULL, relationshipTypesVersion VARCHAR(20) NULL, relationshipTypesName VARCHAR(120) NULL, topologyTemplateLocalName VARCHAR(120) NULL, topologyTemplateParentKeyName VARCHAR(120) NULL, topologyTemplateParentKeyVersion VARCHAR(15) NULL, topologyTemplateParentLocalName VARCHAR(120) NULL, CONSTRAINT PK_TOSCASERVICETEMPLATE PRIMARY KEY (name, version)))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscatopologytemplate (`description` VARCHAR(255) NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, nodeTemplatessVersion VARCHAR(20) NULL, nodeTemplatesName VARCHAR(120) NULL, policyVersion VARCHAR(20) NULL, policyName VARCHAR(120) NULL, CONSTRAINT PK_TOSCATOPOLOGYTEMPLATE PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration |
drools-db-migration | > upgrade 350-jpatoscaproperty_constraints.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscatrigger jpatoscaproperty_constraints (ACTION parentLocalName VARCHAR(255120) NULL, toscaCondition LONGBLOB DEFAULT NULL NULL, toscaConstraint LONGBLOB DEFAULT NULL NULL, `DESCRIPTION` VARCHAR(255) NULL, EVALUATIONS INT DEFAULT NULL NULL, EVENTTYPE VARCHAR(255) NULL, METHOD VARCHAR(255) NULL, `PERIOD` LONGBLOB DEFAULT NULL NULL, SCHEDULE LONGBLOB DEFAULT NULL NULL, TARGETFILTER LONGBLOB DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_TOSCATRIGGER PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, CONSTRAINTS VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES toscacapabilityassignments (name, version) ON UPDATE RESTRICT ON DELETE RESTRICTSET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 360-jpatoscaproperty_metadata.sql
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-dbSET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscanodetype ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICTCREATE TABLE IF NOT EXISTS jpatoscaproperty_metadata (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_capabilityTypesName FOREIGN KEY (capabilityTypesName, capabilityTypesVersion) REFERENCES toscacapabilitytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICTSET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 370-jpatoscarelationshiptype_metadata.sql
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES toscadatatypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICTSET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_nodeTypesName FOREIGN KEY (nodeTypesName, nodeTypesVersion) REFERENCES toscanodetypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICTCREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_policyTypesName FOREIGN KEY (policyTypesName, policyTypesVersion) REFERENCES toscapolicytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICTSET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 380-jpatoscarelationshiptype_properties.sql
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_relationshipTypesName FOREIGN KEY (relationshipTypesName, relationshipTypesVersion) REFERENCES toscarelationshiptypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICTSET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_nodeTemplatesName FOREIGN KEY (nodeTemplatesName, nodeTemplatessVersion) REFERENCES toscanodetemplates (name, version) ON UPDATE RESTRICT ON DELETE RESTRICTCREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES toscapolicies (name, version) ON UPDATE RESTRICT ON DELETE RESTRICTSET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 390-jpatoscarequirement_metadata.sql
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT TscaServiceTemplatetopologyTemplateParentLocalName FOREIGN KEY (topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName) REFERENCES toscatopologytemplate (parentLocalName, localName, parentKeyVersion, parentKeyName) ON UPDATE RESTRICT ON DELETE RESTRICTSET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaNodeTemplate_capabilitiesName ON toscanodetemplate(capabilitiesName, capabilitiesVersionTABLE IF NOT EXISTS jpatoscarequirement_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaNodeTemplate_requirementsName ON toscanodetemplate(requirementsName, requirementsVersion)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 400-jpatoscarequirement_occurrences.sql
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaNodeType_requirementsName ON toscanodetype(requirementsName, requirementsVersion)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_capabilityTypesName ON toscaservicetemplate(capabilityTypesName, capabilityTypesVersionTABLE IF NOT EXISTS jpatoscarequirement_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_dataTypesName ON toscaservicetemplate(dataTypesName, dataTypesVersion)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 410-jpatoscarequirement_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_nodeTypesName ON toscaservicetemplate(nodeTypesName, nodeTypesVersion)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_policyTypesName ON toscaservicetemplate(policyTypesName, policyTypesVersionTABLE IF NOT EXISTS jpatoscarequirement_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_relationshipTypesName ON toscaservicetemplate(relationshipTypesName, relationshipTypesVersion)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 420-jpatoscaservicetemplate_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaTopologyTemplate_nodeTemplatesName ON toscatopologytemplate(nodeTemplatesName, nodeTemplatessVersion)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaTopologyTemplate_policyName ON toscatopologytemplate(policyName, policyVersionTABLE IF NOT EXISTS jpatoscaservicetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX IDX_TSIDX1 ON pdpstatistics(TIMESTAMP, name, version)SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 430-jpatoscatopologytemplate_inputs.sql
drools-db-migration | --------------
drools-db-migration | CREATE INDEX PdpPolicyStatus_PdpGroup ON pdppolicystatus(PDPGROUP)SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX TscaServiceTemplatetopologyTemplateParentLocalName ON toscaservicetemplate(topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyNameTABLE IF NOT EXISTS jpatoscatopologytemplate_inputs (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, INPUTS LONGBLOB DEFAULT NULL NULL, INPUTS_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools -db-migration | > upgrade 02-istanbul.upgrade.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapolicyaudit (ACTION INT DEFAULT NULL NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, TIMESTAMP datetime DEFAULT NULL NULL, USER VARCHAR(255) NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID, name, version))SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 440-pdpgroup_pdpsubgroup.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL NULL, CONSTRAINT PK_SEQUENCE PRIMARY KEY (SEQ_NAME))SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMPTABLE IF NOT EXISTS pdpgroup_pdpsubgroup (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDPGROUP_PDPSUBGROUP PRIMARY KEY (name, version, parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | policyadmin: OK: upgrade (02)
drools-db-migration | name version
drools-db-migration | policyadmin 02
drools-db-migration | script operation success atTime--------------
drools-db-migration | 01-honolulu.upgrade.sql upgrade 1 2021-07-06 14:05:04SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | 02-istanbul.upgrade.sql upgrade 1 2021-07-06 14:05:04
drools-db-migration | policyadmin: OK @ 02
drools-db-migration | Preparing 01-honolulu.downgrade.sql
drools-db-migration | Preparing 02-istanbul.downgrade.sql
drools-db-migration | Done--------------
drools-db-migration | downgrade: 2 -> 1
drools-db-migration |
drools-db-migration | > downgrade 02-istanbul.downgradeupgrade 450-pdpgroup.sql
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `sequence`SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpapolicyaudit`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | policyadmin: OK: downgrade (1)
drools-db-migration | name version
drools-db-migration | policyadmin 1
drools-db-migration | script operation success atTime
drools-db-migration | 01-honolulu.upgrade.sql upgrade 1 2021-07-06 14:05:04
drools-db-migration | 02-istanbul.downgrade.sql downgrade 1 2021-07-06 14:05:04
drools-db-migration | 02-istanbul.upgrade.sql upgrade 1 2021-07-06 14:05:04CREATE TABLE IF NOT EXISTS pdpgroup (`DESCRIPTION` VARCHAR(255) NULL, PDPGROUPSTATE INT DEFAULT NULL NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPGROUP PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 460-pdppolicystatus.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdppolicystatus (DEPLOY BIT DEFAULT 0 NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, STATE INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_PDPPOLICYSTATUS PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 470-pdp.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdp (HEALTHY INT DEFAULT NULL NULL, MESSAGE VARCHAR(255) NULL, PDPSTATE INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDP PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 480-pdpstatistics.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpstatistics (PDPGROUPNAME VARCHAR(120) NULL, PDPSUBGROUPNAME VARCHAR(120) NULL, POLICYDEPLOYCOUNT BIGINT DEFAULT NULL NULL, POLICYDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, POLICYDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDFAILCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDSUCCESSCOUNT BIGINT DEFAULT NULL NULL, TIMESTAMP datetime DEFAULT NULL NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 490-pdpsubgroup_pdp.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpsubgroup_pdp (pdpParentKeyName VARCHAR(120) NOT NULL, pdpParentKeyVersion VARCHAR(15) NOT NULL, pdpParentLocalName VARCHAR(120) NOT NULL, pdpLocalName VARCHAR(120) NOT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDPSUBGROUP_PDP PRIMARY KEY (pdpParentKeyName, pdpParentKeyVersion, pdpParentLocalName, pdpLocalName, parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 500-pdpsubgroup.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpsubgroup (CURRENTINSTANCECOUNT INT DEFAULT NULL NULL, DESIREDINSTANCECOUNT INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDPSUBGROUP PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 510-toscacapabilityassignment.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilityassignment (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENT PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 520-toscacapabilityassignments.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilityassignments (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENTS PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 530-toscacapabilityassignments_toscacapabilityassignment.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilityassignments_toscacapabilityassignment (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENTS_TOSCACAPABILITYASSIGNMENT PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 540-toscacapabilitytype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilitytype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYTYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 550-toscacapabilitytypes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilitytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYTYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 560-toscacapabilitytypes_toscacapabilitytype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilitytypes_toscacapabilitytype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCACAPABILITYTYPES_TOSCACAPABILITYTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 570-toscadatatype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscadatatype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCADATATYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 580-toscadatatypes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscadatatypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCADATATYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 590-toscadatatypes_toscadatatype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscadatatypes_toscadatatype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCADATATYPES_TOSCADATATYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 600-toscanodetemplate.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetemplate (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, capabilitiesName VARCHAR(120) NULL, capabilitiesVersion VARCHAR(20) NULL, requirementsVersion VARCHAR(20) NULL, requirementsName VARCHAR(120) NULL, CONSTRAINT PK_TOSCANODETEMPLATE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 610-toscanodetemplates.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetemplates (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETEMPLATES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 620-toscanodetemplates_toscanodetemplate.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetemplates_toscanodetemplate (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCANODETEMPLATES_TOSCANODETEMPLATE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 630-toscanodetype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, requirementsVersion VARCHAR(20) NULL, requirementsName VARCHAR(120) NULL, CONSTRAINT PK_TOSCANODETYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 640-toscanodetypes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 650-toscanodetypes_toscanodetype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetypes_toscanodetype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCANODETYPES_TOSCANODETYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 660-toscaparameter.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscaparameter (VALUE VARCHAR(255) NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPARAMETER PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 670-toscapolicies.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicies (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICIES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 680-toscapolicies_toscapolicy.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicies_toscapolicy (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPOLICIES_TOSCAPOLICY PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 690-toscapolicy.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicy (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCAPOLICY PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 700-toscapolicytype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicytype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICYTYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 710-toscapolicytypes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICYTYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 720-toscapolicytypes_toscapolicytype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicytypes_toscapolicytype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPOLICYTYPES_TOSCAPOLICYTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 730-toscaproperty.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscaproperty (DEFAULTVALUE VARCHAR(255) NULL, `DESCRIPTION` VARCHAR(255) NULL, ENTRYSCHEMA LONGBLOB DEFAULT NULL NULL, REQUIRED BIT DEFAULT 0 NULL, STATUS INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPROPERTY PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 740-toscarelationshiptype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarelationshiptype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 750-toscarelationshiptypes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarelationshiptypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 760-toscarelationshiptypes_toscarelationshiptype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarelationshiptypes_toscarelationshiptype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPES_TOSCARELATIONSHIPTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 770-toscarequirement.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarequirement (CAPABILITY VARCHAR(255) NULL, `DESCRIPTION` VARCHAR(255) NULL, NODE VARCHAR(255) NULL, RELATIONSHIP VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCAREQUIREMENT PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 780-toscarequirements.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarequirements (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAREQUIREMENTS PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 790-toscarequirements_toscarequirement.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarequirements_toscarequirement (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAREQUIREMENTS_TOSCAREQUIREMENT PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 800-toscaservicetemplate.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscaservicetemplate (`DESCRIPTION` VARCHAR(255) NULL, TOSCADEFINITIONSVERSION VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, capabilityTypesVersion VARCHAR(20) NULL, capabilityTypesName VARCHAR(120) NULL, dataTypesName VARCHAR(120) NULL, dataTypesVersion VARCHAR(20) NULL, nodeTypesVersion VARCHAR(20) NULL, nodeTypesName VARCHAR(120) NULL, policyTypesName VARCHAR(120) NULL, policyTypesVersion VARCHAR(20) NULL, relationshipTypesVersion VARCHAR(20) NULL, relationshipTypesName VARCHAR(120) NULL, topologyTemplateLocalName VARCHAR(120) NULL, topologyTemplateParentKeyName VARCHAR(120) NULL, topologyTemplateParentKeyVersion VARCHAR(15) NULL, topologyTemplateParentLocalName VARCHAR(120) NULL, CONSTRAINT PK_TOSCASERVICETEMPLATE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 810-toscatopologytemplate.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscatopologytemplate (`description` VARCHAR(255) NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, nodeTemplatessVersion VARCHAR(20) NULL, nodeTemplatesName VARCHAR(120) NULL, policyVersion VARCHAR(20) NULL, policyName VARCHAR(120) NULL, CONSTRAINT PK_TOSCATOPOLOGYTEMPLATE PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 820-toscatrigger.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscatrigger (ACTION VARCHAR(255) NULL, toscaCondition LONGBLOB DEFAULT NULL NULL, toscaConstraint LONGBLOB DEFAULT NULL NULL, `DESCRIPTION` VARCHAR(255) NULL, EVALUATIONS INT DEFAULT NULL NULL, EVENTTYPE VARCHAR(255) NULL, METHOD VARCHAR(255) NULL, `PERIOD` LONGBLOB DEFAULT NULL NULL, SCHEDULE LONGBLOB DEFAULT NULL NULL, TARGETFILTER LONGBLOB DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_TOSCATRIGGER PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 830-FK_ToscaNodeTemplate_capabilitiesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES toscacapabilityassignments (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 840-FK_ToscaNodeTemplate_requirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 850-FK_ToscaNodeType_requirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscanodetype ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 860-FK_ToscaServiceTemplate_capabilityTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_capabilityTypesName FOREIGN KEY (capabilityTypesName, capabilityTypesVersion) REFERENCES toscacapabilitytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 870-FK_ToscaServiceTemplate_dataTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES toscadatatypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 880-FK_ToscaServiceTemplate_nodeTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_nodeTypesName FOREIGN KEY (nodeTypesName, nodeTypesVersion) REFERENCES toscanodetypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 890-FK_ToscaServiceTemplate_policyTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_policyTypesName FOREIGN KEY (policyTypesName, policyTypesVersion) REFERENCES toscapolicytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 900-FK_ToscaServiceTemplate_relationshipTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_relationshipTypesName FOREIGN KEY (relationshipTypesName, relationshipTypesVersion) REFERENCES toscarelationshiptypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_nodeTemplatesName FOREIGN KEY (nodeTemplatesName, nodeTemplatessVersion) REFERENCES toscanodetemplates (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 920-FK_ToscaTopologyTemplate_policyName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES toscapolicies (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 930-TscaServiceTemplatetopologyTemplateParentLocalName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT TscaServiceTemplatetopologyTemplateParentLocalName FOREIGN KEY (topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName) REFERENCES toscatopologytemplate (parentLocalName, localName, parentKeyVersion, parentKeyName) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 940-FK_ToscaNodeTemplate_capabilitiesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaNodeTemplate_capabilitiesName ON toscanodetemplate(capabilitiesName, capabilitiesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 950-FK_ToscaNodeTemplate_requirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaNodeTemplate_requirementsName ON toscanodetemplate(requirementsName, requirementsVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 960-FK_ToscaNodeType_requirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaNodeType_requirementsName ON toscanodetype(requirementsName, requirementsVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 970-FK_ToscaServiceTemplate_capabilityTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_capabilityTypesName ON toscaservicetemplate(capabilityTypesName, capabilityTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 980-FK_ToscaServiceTemplate_dataTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_dataTypesName ON toscaservicetemplate(dataTypesName, dataTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 990-FK_ToscaServiceTemplate_nodeTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_nodeTypesName ON toscaservicetemplate(nodeTypesName, nodeTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1000-FK_ToscaServiceTemplate_policyTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_policyTypesName ON toscaservicetemplate(policyTypesName, policyTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_relationshipTypesName ON toscaservicetemplate(relationshipTypesName, relationshipTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaTopologyTemplate_nodeTemplatesName ON toscatopologytemplate(nodeTemplatesName, nodeTemplatessVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1030-FK_ToscaTopologyTemplate_policyName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaTopologyTemplate_policyName ON toscatopologytemplate(policyName, policyVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1040-IDX_TSIDX1.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX IDX_TSIDX1 ON pdpstatistics(TIMESTAMP, name, version)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1050-PdpPolicyStatus_PdpGroup.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX PdpPolicyStatus_PdpGroup ON pdppolicystatus(PDPGROUP)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX TscaServiceTemplatetopologyTemplateParentLocalName ON toscaservicetemplate(topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 100-jpapolicyaudit.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapolicyaudit (ACTION INT DEFAULT NULL NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, TIMESTAMP datetime DEFAULT NULL NULL, USER VARCHAR(255) NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID, name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 110-sequence.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL NULL, CONSTRAINT PK_SEQUENCE PRIMARY KEY (SEQ_NAME))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 120-JpaPolicyAuditIndex_timestamp.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | policyadmin: OK: upgrade (0900)
drools-db-migration | name version
drools-db-migration | policyadmin 0900
drools-db-migration | script operation success atTime
drools-db-migration | 100-jpapdpgroup_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 150-jpatoscacapabilityassignment_attributes.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 160-jpatoscacapabilityassignment_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 170-jpatoscacapabilityassignment_occurrences.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 180-jpatoscacapabilityassignment_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 190-jpatoscacapabilitytype_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 200-jpatoscacapabilitytype_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 210-jpatoscadatatype_constraints.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 220-jpatoscadatatype_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 230-jpatoscadatatype_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 130-jpapdpsubgroup_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 240-jpatoscanodetemplate_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 120-jpapdpsubgroup_policies.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 110-jpapdpstatistics_enginestats.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 450-pdpgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 440-pdpgroup_pdpsubgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 430-jpatoscatopologytemplate_inputs.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 420-jpatoscaservicetemplate_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 410-jpatoscarequirement_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 400-jpatoscarequirement_occurrences.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 390-jpatoscarequirement_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 380-jpatoscarelationshiptype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 370-jpatoscarelationshiptype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 460-pdppolicystatus.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 470-pdp.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 480-pdpstatistics.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 490-pdpsubgroup_pdp.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 500-pdpsubgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 510-toscacapabilityassignment.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 520-toscacapabilityassignments.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 540-toscacapabilitytype.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 550-toscacapabilitytypes.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 360-jpatoscaproperty_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 350-jpatoscaproperty_constraints.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 250-jpatoscanodetemplate_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 260-jpatoscanodetype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 270-jpatoscanodetype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 280-jpatoscapolicy_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 290-jpatoscapolicy_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 300-jpatoscapolicy_targets.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 310-jpatoscapolicytype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 320-jpatoscapolicytype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 330-jpatoscapolicytype_targets.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 340-jpatoscapolicytype_triggers.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 770-toscarequirement.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 750-toscarelationshiptypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 740-toscarelationshiptype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 730-toscaproperty.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 720-toscapolicytypes_toscapolicytype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 710-toscapolicytypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 700-toscapolicytype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 690-toscapolicy.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 780-toscarequirements.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 790-toscarequirements_toscarequirement.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 850-FK_ToscaNodeType_requirementsName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 820-toscatrigger.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 810-toscatopologytemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 800-toscaservicetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 680-toscapolicies_toscapolicy.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 670-toscapolicies.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 570-toscadatatype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 580-toscadatatypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 590-toscadatatypes_toscadatatype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 600-toscanodetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 610-toscanodetemplates.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 620-toscanodetemplates_toscanodetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 630-toscanodetype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 640-toscanodetypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 650-toscanodetypes_toscanodetype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 660-toscaparameter.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 920-FK_ToscaTopologyTemplate_policyName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 930-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 960-FK_ToscaNodeType_requirementsName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 980-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 120-JpaPolicyAuditIndex_timestamp.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 100-jpapolicyaudit.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1030-FK_ToscaTopologyTemplate_policyName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1040-IDX_TSIDX1.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1050-PdpPolicyStatus_PdpGroup.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 110-sequence.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | policyadmin: OK @ 0900
drools-db-migration | Preparing downgrade version: 0800
drools-db-migration | Preparing downgrade version: 0900
drools-db-migration | Done
drools-db-migration | downgrade: 0900 -> 0800
drools-db-migration |
drools-db-migration | > downgrade 120-JpaPolicyAuditIndex_timestamp.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > downgrade 110-sequence.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `sequence`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > downgrade 100-jpapolicyaudit.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpapolicyaudit`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | policyadmin: OK: downgrade (0800)
drools-db-migration | name version
drools-db-migration | policyadmin 0800
drools-db-migration | script operation success atTime
drools-db-migration | 100-jpapdpgroup_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 150-jpatoscacapabilityassignment_attributes.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 160-jpatoscacapabilityassignment_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 170-jpatoscacapabilityassignment_occurrences.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 180-jpatoscacapabilityassignment_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 190-jpatoscacapabilitytype_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 200-jpatoscacapabilitytype_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 210-jpatoscadatatype_constraints.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 220-jpatoscadatatype_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 230-jpatoscadatatype_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 130-jpapdpsubgroup_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 240-jpatoscanodetemplate_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 120-jpapdpsubgroup_policies.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 110-jpapdpstatistics_enginestats.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 450-pdpgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 440-pdpgroup_pdpsubgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 430-jpatoscatopologytemplate_inputs.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 420-jpatoscaservicetemplate_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 410-jpatoscarequirement_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 400-jpatoscarequirement_occurrences.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 390-jpatoscarequirement_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 380-jpatoscarelationshiptype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 370-jpatoscarelationshiptype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 460-pdppolicystatus.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 470-pdp.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 480-pdpstatistics.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 490-pdpsubgroup_pdp.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 500-pdpsubgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 510-toscacapabilityassignment.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 520-toscacapabilityassignments.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 540-toscacapabilitytype.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 550-toscacapabilitytypes.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 360-jpatoscaproperty_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 350-jpatoscaproperty_constraints.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 250-jpatoscanodetemplate_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 260-jpatoscanodetype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 270-jpatoscanodetype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 280-jpatoscapolicy_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 290-jpatoscapolicy_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 300-jpatoscapolicy_targets.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 310-jpatoscapolicytype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 320-jpatoscapolicytype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 330-jpatoscapolicytype_targets.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 340-jpatoscapolicytype_triggers.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 770-toscarequirement.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 750-toscarelationshiptypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 740-toscarelationshiptype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 730-toscaproperty.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 720-toscapolicytypes_toscapolicytype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 710-toscapolicytypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 700-toscapolicytype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 690-toscapolicy.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 780-toscarequirements.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 790-toscarequirements_toscarequirement.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 850-FK_ToscaNodeType_requirementsName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 820-toscatrigger.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 810-toscatopologytemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 800-toscaservicetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 680-toscapolicies_toscapolicy.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 670-toscapolicies.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 570-toscadatatype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 580-toscadatatypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 590-toscadatatypes_toscadatatype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 600-toscanodetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 610-toscanodetemplates.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 620-toscanodetemplates_toscanodetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 630-toscanodetype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 640-toscanodetypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 650-toscanodetypes_toscanodetype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 660-toscaparameter.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 920-FK_ToscaTopologyTemplate_policyName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 930-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 960-FK_ToscaNodeType_requirementsName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 980-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1030-FK_ToscaTopologyTemplate_policyName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1040-IDX_TSIDX1.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1050-PdpPolicyStatus_PdpGroup.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 110-sequence.sql downgrade 1 2021-07-08 14:50:20
drools-db-migration | 100-jpapolicyaudit.sql downgrade 1 2021-07-08 14:50:20
drools-db-migration | 120-JpaPolicyAuditIndex_timestamp.sql downgrade 1 2021-07-08 14:50:20
drools-db-migration | policyadmin: downgrade available: 1 0800 -> 0