Sending build context to Docker daemon 424.4kB Step 1/14 : FROM onap/policy-jdk-alpine:2.2.1 ---> 5eb5fe287a10 Step 2/14 : LABEL maintainer="Policy Team" ---> Using cache ---> 3e6f40d0ca17 Step 3/14 : ENV JAVA_HOME /usr/lib/jvm/java-11-openjdk ---> Using cache ---> 7b2215fb36dd Step 4/14 : ENV POLICY_ETC /opt/app/policy/etc ---> Using cache ---> d4ff6ac7a4ba Step 5/14 : ENV POLICY_PROFILE /opt/app/policy/etc/profile.d ---> Using cache ---> fe45514efd9f Step 6/14 : ENV POLICY_BIN /opt/app/policy/bin ---> Using cache ---> a2368356c9cd Step 7/14 : RUN apk update && apk add --no-cache mariadb-client net-tools netcat-openbsd sudo less vim && mkdir -p $POLICY_PROFILE $POLICY_BIN && chown -R policy:policy $POLICY_ETC $POLICY_BIN ---> Using cache ---> 84108c1feb7e Step 8/14 : COPY --chown=policy:policy ./env.sh $POLICY_PROFILE/ ---> Using cache ---> 5f836c5e7787 Step 9/14 : COPY --chown=policy:policy ./db-migrator $POLICY_BIN/ ---> Using cache ---> e45d0702dd99 Step 10/14 : COPY --chown=policy:policy ./prepare_upgrade.sh $POLICY_BIN/ ---> Using cache ---> e45b85c09fc5 Step 11/14 : COPY --chown=policy:policy ./prepare_downgrade.sh $POLICY_BIN/ ---> Using cache ---> 4000cc27cfd8 Step 12/14 : COPY --chown=policy:policy ./config/policyadmin/sql /home/policy/sql ---> Using cache ---> f0900cc09900 Step 13/14 : WORKDIR $POLICY_BIN ---> Using cache ---> 219147d4e99e Step 14/14 : USER policy:policy ---> Using cache ---> 4c6f60ce20b7 Successfully built 4c6f60ce20b7 Successfully tagged test_drools-db-migration:latest Attaching to mariadb, drools-db-migration mariadb | 2021-08-16 13:00:43+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.8+maria~focal started. drools-db-migration | Waiting for mariadb port 3306... drools-db-migration | nc: connect to mariadb port 3306 (tcp) failed: Connection refused mariadb | 2021-08-16 13:00:44+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' mariadb | 2021-08-16 13:00:44+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.8+maria~focal started. mariadb | 2021-08-16 13:00:44+00:00 [Note] [Entrypoint]: Initializing database files drools-db-migration | .nc: connect to mariadb port 3306 (tcp) failed: Connection refused mariadb | mariadb | mariadb | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! mariadb | To do so, start the server, then issue the following commands: mariadb | mariadb | '/usr/bin/mysqladmin' -u root password 'new-password' mariadb | '/usr/bin/mysqladmin' -u root -h password 'new-password' mariadb | mariadb | Alternatively you can run: mariadb | '/usr/bin/mysql_secure_installation' mariadb | mariadb | which will also give you the option of removing the test mariadb | databases and anonymous user created by default. This is mariadb | strongly recommended for production servers. mariadb | mariadb | See the MariaDB Knowledgebase at https://mariadb.com/kb or the mariadb | MySQL manual for more instructions. mariadb | mariadb | Please report any problems at https://mariadb.org/jira mariadb | mariadb | The latest information about MariaDB is available at https://mariadb.org/. mariadb | You can find additional information about the MySQL part at: mariadb | https://dev.mysql.com mariadb | Consider joining MariaDB's strong and vibrant community: mariadb | https://mariadb.org/get-involved/ mariadb | mariadb | 2021-08-16 13:00:45+00:00 [Note] [Entrypoint]: Database files initialized mariadb | 2021-08-16 13:00:45+00:00 [Note] [Entrypoint]: Starting temporary server mariadb | 2021-08-16 13:00:45+00:00 [Note] [Entrypoint]: Waiting for server startup mariadb | 2021-08-16 13:00:45 0 [Note] mysqld (mysqld 10.5.8-MariaDB-1:10.5.8+maria~focal) starting as process 112 ... mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: Using Linux native AIO mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: Uses event mutexes mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: Number of pools: 1 mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions mariadb | 2021-08-16 13:00:45 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: Completed initialization of buffer pool mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: 128 rollback segments are active. mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: 10.5.8 started; log sequence number 45118; transaction id 20 mariadb | 2021-08-16 13:00:45 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool mariadb | 2021-08-16 13:00:45 0 [Note] Plugin 'FEEDBACK' is disabled. mariadb | 2021-08-16 13:00:46 0 [Note] InnoDB: Buffer pool(s) load completed at 210816 13:00:45 mariadb | 2021-08-16 13:00:46 0 [Warning] 'user' entry 'root@mariadb' ignored in --skip-name-resolve mode. mariadb | 2021-08-16 13:00:46 0 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode. mariadb | 2021-08-16 13:00:46 0 [Note] Reading of all Master_info entries succeeded mariadb | 2021-08-16 13:00:46 0 [Note] Added new Master_info '' to hash table mariadb | 2021-08-16 13:00:46 0 [Note] mysqld: ready for connections. mariadb | Version: '10.5.8-MariaDB-1:10.5.8+maria~focal' socket: '/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution drools-db-migration | .nc: connect to mariadb port 3306 (tcp) failed: Connection refused mariadb | 2021-08-16 13:00:46+00:00 [Note] [Entrypoint]: Temporary server started. drools-db-migration | .nc: connect to mariadb port 3306 (tcp) failed: Connection refused mariadb | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. mariadb | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it. mariadb | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it. drools-db-migration | .nc: connect to mariadb port 3306 (tcp) failed: Connection refused mariadb | 2021-08-16 13:00:49 5 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode. mariadb | 2021-08-16 13:00:49+00:00 [Note] [Entrypoint]: Creating user policy_user mariadb | mariadb | mariadb | 2021-08-16 13:00:49+00:00 [Warn] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/db.conf mariadb | 2021-08-16 13:00:49+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/db.sh mariadb | #!/bin/bash -xv mariadb | # Copyright 2019,2021 AT&T Intellectual Property. All rights reserved mariadb | # mariadb | # Licensed under the Apache License, Version 2.0 (the "License"); mariadb | # you may not use this file except in compliance with the License. mariadb | # You may obtain a copy of the License at mariadb | # mariadb | # http://www.apache.org/licenses/LICENSE-2.0 mariadb | # mariadb | # Unless required by applicable law or agreed to in writing, software mariadb | # distributed under the License is distributed on an "AS IS" BASIS, mariadb | # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. mariadb | # See the License for the specific language governing permissions and mariadb | # limitations under the License. mariadb | mariadb | for db in migration pooling policyadmin operationshistory mariadb | do mariadb | mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "CREATE DATABASE IF NOT EXISTS ${db};" mariadb | mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "GRANT ALL PRIVILEGES ON \`${db}\`.* TO '${MYSQL_USER}'@'%' ;" mariadb | done mariadb | + for db in migration pooling policyadmin operationshistory mariadb | + mysql -uroot -psecret --execute 'CREATE DATABASE IF NOT EXISTS migration;' mariadb | + mysql -uroot -psecret --execute 'GRANT ALL PRIVILEGES ON `migration`.* TO '\''policy_user'\''@'\''%'\'' ;' mariadb | + for db in migration pooling policyadmin operationshistory mariadb | + mysql -uroot -psecret --execute 'CREATE DATABASE IF NOT EXISTS pooling;' mariadb | + mysql -uroot -psecret --execute 'GRANT ALL PRIVILEGES ON `pooling`.* TO '\''policy_user'\''@'\''%'\'' ;' mariadb | + for db in migration pooling policyadmin operationshistory mariadb | + mysql -uroot -psecret --execute 'CREATE DATABASE IF NOT EXISTS policyadmin;' mariadb | + mysql -uroot -psecret --execute 'GRANT ALL PRIVILEGES ON `policyadmin`.* TO '\''policy_user'\''@'\''%'\'' ;' mariadb | + for db in migration pooling policyadmin operationshistory mariadb | + mysql -uroot -psecret --execute 'CREATE DATABASE IF NOT EXISTS operationshistory;' mariadb | + mysql -uroot -psecret --execute 'GRANT ALL PRIVILEGES ON `operationshistory`.* TO '\''policy_user'\''@'\''%'\'' ;' mariadb | mariadb | mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "FLUSH PRIVILEGES;" mariadb | + mysql -uroot -psecret --execute 'FLUSH PRIVILEGES;' mariadb | 2021-08-16 13:00:49 15 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode. mariadb | mariadb | 2021-08-16 13:00:49+00:00 [Note] [Entrypoint]: Stopping temporary server mariadb | 2021-08-16 13:00:49 0 [Note] mysqld (initiated by: root[root] @ localhost []): Normal shutdown mariadb | 2021-08-16 13:00:49 0 [Note] Event Scheduler: Purging the queue. 0 events mariadb | 2021-08-16 13:00:49 0 [Note] InnoDB: FTS optimize thread exiting. mariadb | 2021-08-16 13:00:49 0 [Note] InnoDB: Starting shutdown... mariadb | 2021-08-16 13:00:49 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool mariadb | 2021-08-16 13:00:49 0 [Note] InnoDB: Buffer pool(s) dump completed at 210816 13:00:49 drools-db-migration | .nc: connect to mariadb port 3306 (tcp) failed: Connection refused mariadb | 2021-08-16 13:00:49 0 [Note] InnoDB: Shutdown completed; log sequence number 45130; transaction id 21 mariadb | 2021-08-16 13:00:49 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" mariadb | 2021-08-16 13:00:49 0 [Note] mysqld: Shutdown complete mariadb | mariadb | 2021-08-16 13:00:50+00:00 [Note] [Entrypoint]: Temporary server stopped mariadb | mariadb | 2021-08-16 13:00:50+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up. mariadb | mariadb | 2021-08-16 13:00:50 0 [Note] mysqld (mysqld 10.5.8-MariaDB-1:10.5.8+maria~focal) starting as process 1 ... mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Using Linux native AIO mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Uses event mutexes mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Number of pools: 1 mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions mariadb | 2021-08-16 13:00:50 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Completed initialization of buffer pool mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: 128 rollback segments are active. mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: 10.5.8 started; log sequence number 45130; transaction id 20 mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool mariadb | 2021-08-16 13:00:50 0 [Note] Plugin 'FEEDBACK' is disabled. mariadb | 2021-08-16 13:00:50 0 [Note] InnoDB: Buffer pool(s) load completed at 210816 13:00:50 mariadb | 2021-08-16 13:00:50 0 [Note] Server socket created on IP: '::'. mariadb | 2021-08-16 13:00:50 0 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode. mariadb | 2021-08-16 13:00:50 0 [Note] Reading of all Master_info entries succeeded mariadb | 2021-08-16 13:00:50 0 [Note] Added new Master_info '' to hash table mariadb | 2021-08-16 13:00:50 0 [Note] mysqld: ready for connections. mariadb | Version: '10.5.8-MariaDB-1:10.5.8+maria~focal' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution drools-db-migration | .Connection to mariadb 3306 port [tcp/mysql] succeeded! mariadb | 2021-08-16 13:00:50 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.22.0.3' (This connection closed normally without authentication) drools-db-migration | 278 blocks drools-db-migration | Preparing upgrade release version: 0800 drools-db-migration | Preparing upgrade release version: 0900 drools-db-migration | Done drools-db-migration | upgrade: 0 -> 0900 drools-db-migration | drools-db-migration | > upgrade 0100-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-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0110-jpapdpstatistics_enginestats.sql 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, timeStamp datetime DEFAULT NULL NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0120-jpapdpsubgroup_policies.sql 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 | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0130-jpapdpsubgroup_properties.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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpsubgroup_supportedpolicytypes (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 | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0150-jpatoscacapabilityassignment_attributes.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0160-jpatoscacapabilityassignment_metadata.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0170-jpatoscacapabilityassignment_occurrences.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0180-jpatoscacapabilityassignment_properties.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_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 | > upgrade 0190-jpatoscacapabilitytype_metadata.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0200-jpatoscacapabilitytype_properties.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0210-jpatoscadatatype_constraints.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0220-jpatoscadatatype_metadata.sql 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 | > upgrade 0230-jpatoscadatatype_properties.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0240-jpatoscanodetemplate_metadata.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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0250-jpatoscanodetemplate_properties.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_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 | > upgrade 0260-jpatoscanodetype_metadata.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0270-jpatoscanodetype_properties.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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0280-jpatoscapolicy_metadata.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicy_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 | > upgrade 0290-jpatoscapolicy_properties.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0300-jpatoscapolicy_targets.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicy_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0310-jpatoscapolicytype_metadata.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_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 | > upgrade 0320-jpatoscapolicytype_properties.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0330-jpatoscapolicytype_targets.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0340-jpatoscapolicytype_triggers.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_triggers (name VARCHAR(120) NULL, version VARCHAR(20) NULL, TRIGGERS VARCHAR(255) NULL) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0350-jpatoscaproperty_constraints.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0360-jpatoscaproperty_metadata.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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0370-jpatoscarelationshiptype_metadata.sql drools-db-migration | -------------- drools-db-migration | CREATE 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 | > upgrade 0380-jpatoscarelationshiptype_properties.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0390-jpatoscarequirement_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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0400-jpatoscarequirement_occurrences.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE 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 | > upgrade 0410-jpatoscarequirement_properties.sql 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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0420-jpatoscaservicetemplate_metadata.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) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0430-jpatoscatopologytemplate_inputs.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE 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 0440-pdpgroup_pdpsubgroup.sql drools-db-migration | -------------- drools-db-migration | CREATE TABLE 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 | drools-db-migration | > upgrade 0450-pdpgroup.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0460-pdppolicystatus.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0470-pdp.sql 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 | > upgrade 0480-pdpstatistics.sql 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 NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0490-pdpsubgroup_pdp.sql 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 | > upgrade 0500-pdpsubgroup.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 | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0510-toscacapabilityassignment.sql 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 | > upgrade 0520-toscacapabilityassignments.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql 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 | > upgrade 0540-toscacapabilitytype.sql 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 | > upgrade 0550-toscacapabilitytypes.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql 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 | > upgrade 0570-toscadatatype.sql 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 | > upgrade 0580-toscadatatypes.sql 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 | > upgrade 0590-toscadatatypes_toscadatatype.sql 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 | > upgrade 0600-toscanodetemplate.sql 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 | > upgrade 0610-toscanodetemplates.sql 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 | > upgrade 0620-toscanodetemplates_toscanodetemplate.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 | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0630-toscanodetype.sql 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 | > upgrade 0640-toscanodetypes.sql 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 | > upgrade 0650-toscanodetypes_toscanodetype.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0660-toscaparameter.sql 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 | > upgrade 0670-toscapolicies.sql 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 | > upgrade 0680-toscapolicies_toscapolicy.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 | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0690-toscapolicy.sql 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 | > upgrade 0700-toscapolicytype.sql 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 | > upgrade 0710-toscapolicytypes.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0720-toscapolicytypes_toscapolicytype.sql 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 | > upgrade 0730-toscaproperty.sql 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 | > upgrade 0740-toscarelationshiptype.sql 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 | > upgrade 0750-toscarelationshiptypes.sql 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 | > upgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql 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 | > upgrade 0770-toscarequirement.sql 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 | > upgrade 0780-toscarequirements.sql 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 | > upgrade 0790-toscarequirements_toscarequirement.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0800-toscaservicetemplate.sql 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 | > upgrade 0810-toscatopologytemplate.sql 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 | > upgrade 0820-toscatrigger.sql 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 | > upgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql 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 | > upgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql 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 | > upgrade 0850-FK_ToscaNodeType_requirementsName.sql 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 | > upgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql 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 | > upgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql 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 | > upgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql 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 | > upgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql 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 | > upgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql 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 | > upgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql 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 | > upgrade 0920-FK_ToscaTopologyTemplate_policyName.sql 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 | > upgrade 0940-PdpPolicyStatus_PdpGroup.sql 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 | > upgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql 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 | > upgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql 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 | > upgrade 0970-FK_ToscaNodeTemplate_requirementsName.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-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0980-FK_ToscaNodeType_requirementsName.sql 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 | > upgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql 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 | > upgrade 1000-FK_ToscaServiceTemplate_dataTypesName.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 RESTRICT drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql 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 | > upgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql 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 | > upgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.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 RESTRICT drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql 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 | > upgrade 1050-FK_ToscaTopologyTemplate_policyName.sql 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 | > upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.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 RESTRICT drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime DEFAULT NULL NULL AFTER HEALTHY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0130-idx_tsidx1.sql 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 | > upgrade 0140-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP PRIMARY KEY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0150-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0160-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0180-jpapolicyaudit.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0190-JpaPolicyAuditIndex_timestamp.sql 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 | > upgrade 0200-sequence.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', 0) drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: upgrade (0900) drools-db-migration | drools-db-migration | check_results: status:1, operation:upgrade, from:0, to:0900, new records:108, sqlFiles:108 drools-db-migration | *** Test 1: PASS , Successful upgrade, current version: 0900 *** drools-db-migration | 239 blocks drools-db-migration | Preparing downgrade release version: 0800 drools-db-migration | Preparing downgrade release version: 0900 drools-db-migration | Done drools-db-migration | downgrade: 0900 -> 0800 drools-db-migration | drools-db-migration | > downgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | DELETE from sequence drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0200-sequence.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `sequence` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0190-JpaPolicyAuditIndex_timestamp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0180-jpapolicyaudit.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `jpapolicyaudit` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0160-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0150-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0140-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0130-idx_tsidx1.sql drools-db-migration | -------------- drools-db-migration | DROP INDEX IDX_TSIDX1 ON pdpstatistics drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp DROP COLUMN LASTUPDATE drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | check_results: status:1, operation:downgrade, from:0900, to:0800, new records:12, sqlFiles:12 drools-db-migration | *** Test 2: PASS , Successful downgrade, current version: 0800 *** drools-db-migration | 278 blocks drools-db-migration | Preparing upgrade release version: 0800 drools-db-migration | Preparing upgrade release version: 0900 drools-db-migration | Done drools-db-migration | upgrade: 0800 -> 0900 drools-db-migration | drools-db-migration | > upgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime DEFAULT NULL NULL AFTER HEALTHY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0130-idx_tsidx1.sql 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 | > upgrade 0140-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP PRIMARY KEY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0150-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0160-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0180-jpapolicyaudit.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0190-JpaPolicyAuditIndex_timestamp.sql 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 | > upgrade 0200-sequence.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', 0) drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: upgrade (0900) drools-db-migration | drools-db-migration | check_results: status:1, operation:upgrade, from:0800, to:0900, new records:12, sqlFiles:12 drools-db-migration | *** Test 3: PASS , Successful upgrade, current version: 0900 *** drools-db-migration | 239 blocks drools-db-migration | Preparing downgrade release version: 0800 drools-db-migration | Preparing downgrade release version: 0900 drools-db-migration | Done drools-db-migration | downgrade: 0900 -> 0800 drools-db-migration | drools-db-migration | > downgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | DELETE from sequence drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0200-sequence.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `sequence` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0190-JpaPolicyAuditIndex_timestamp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0180-jpapolicyaudit.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `jpapolicyaudit` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0160-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0150-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0140-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0130-idx_tsidx1.sql drools-db-migration | -------------- drools-db-migration | DROP INDEX IDX_TSIDX1 ON pdpstatistics drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp DROP COLUMN LASTUPDATE drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: downgrade (0800) drools-db-migration | 278 blocks drools-db-migration | Preparing upgrade release version: 0800 drools-db-migration | Preparing upgrade release version: 0900 drools-db-migration | Done drools-db-migration | upgrade: 0800 -> 0900 drools-db-migration | drools-db-migration | > upgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime DEFAULT NULL NULL AFTER HEALTHY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0130-idx_tsidx1.sql 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 | > upgrade 0140-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP PRIMARY KEY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0150-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0160-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0180-jpapolicyaudit.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0190-JpaPolicyAuditIndex_timestamp.sql 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 | > upgrade 0200-sequence.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', 0) drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: upgrade (0900) drools-db-migration | drools-db-migration | check_results: status:1, operation:upgrade, from:0800, to:0900, new records:12, sqlFiles:12 drools-db-migration | *** Test 4: PASS , Successful upgrade, current version: 0900 *** drools-db-migration | 239 blocks drools-db-migration | Preparing downgrade release version: 0800 drools-db-migration | Preparing downgrade release version: 0900 drools-db-migration | Done drools-db-migration | downgrade: 0900 -> 0800 drools-db-migration | drools-db-migration | > downgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | DELETE from sequence drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0200-sequence.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `sequence` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0190-JpaPolicyAuditIndex_timestamp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0180-jpapolicyaudit.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `jpapolicyaudit` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ERROR 1146 (42S02) at line 20: Table 'policyadmin.pdpstatistics' doesn't exist drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: downgrade aborted at 0900 by script 0170-pdpstatistics.sql drools-db-migration | policyadmin: failure: downgrade to release 0800 (0900) drools-db-migration | 278 blocks drools-db-migration | Preparing upgrade release version: 0800 drools-db-migration | Preparing upgrade release version: 0900 drools-db-migration | Done drools-db-migration | upgrade: 0900 -> 0900 drools-db-migration | Partial downgrade detected drools-db-migration | Upgrade will attempt to resume after 0170-pdpstatistics.sql drools-db-migration | drools-db-migration | > upgrade 0180-jpapolicyaudit.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0190-JpaPolicyAuditIndex_timestamp.sql 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 | > upgrade 0200-sequence.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', 0) drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: upgrade (0900) drools-db-migration | drools-db-migration | check_results: status:1, operation:upgrade, from:0900, to:0900, new records:9, sqlFiles:9 drools-db-migration | *** Test 5: PASS , Successful upgrade, current version: 0900 *** drools-db-migration | 239 blocks drools-db-migration | Preparing downgrade release version: 0800 drools-db-migration | Preparing downgrade release version: 0900 drools-db-migration | Done drools-db-migration | downgrade: 0900 -> 0800 drools-db-migration | drools-db-migration | > downgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | DELETE from sequence drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0200-sequence.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `sequence` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0190-JpaPolicyAuditIndex_timestamp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0180-jpapolicyaudit.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `jpapolicyaudit` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ERROR 1146 (42S02) at line 20: Table 'policyadmin.pdpstatistics' doesn't exist drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: downgrade aborted at 0900 by script 0170-pdpstatistics.sql drools-db-migration | policyadmin: failure: downgrade to release 0800 (0900) drools-db-migration | downgrade: 0900 -> 0800 drools-db-migration | Partial downgrade detected drools-db-migration | Downgrade will attempt to resume at 0170-pdpstatistics.sql drools-db-migration | drools-db-migration | > downgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0160-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0150-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0140-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0130-idx_tsidx1.sql drools-db-migration | -------------- drools-db-migration | DROP INDEX IDX_TSIDX1 ON pdpstatistics drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp DROP COLUMN LASTUPDATE drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: downgrade (0800) drools-db-migration | drools-db-migration | check_results: status:1, operation:downgrade, from:0900, to:0800, new records:13, sqlFiles:13 drools-db-migration | *** Test 6: PASS , Successful downgrade, current version: 0800 *** drools-db-migration | 278 blocks drools-db-migration | Preparing upgrade release version: 0800 drools-db-migration | Preparing upgrade release version: 0900 drools-db-migration | Done drools-db-migration | upgrade: 0800 -> 0900 drools-db-migration | drools-db-migration | > upgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime DEFAULT NULL NULL AFTER HEALTHY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0130-idx_tsidx1.sql drools-db-migration | -------------- drools-db-migration | ERROR 1146 (42S02) at line 20: Table 'policyadmin.pdpstatistics' doesn't exist drools-db-migration | CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: upgrade aborted at 0900 by script 0130-idx_tsidx1.sql drools-db-migration | policyadmin: failure: upgrade to release 0900 (0900) drools-db-migration | 239 blocks drools-db-migration | Preparing downgrade release version: 0800 drools-db-migration | Preparing downgrade release version: 0900 drools-db-migration | Done drools-db-migration | downgrade: 0900 -> 0800 drools-db-migration | Partial upgrade detected drools-db-migration | Downgrade will attempt to resume before 0130-idx_tsidx1.sql drools-db-migration | drools-db-migration | > downgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp DROP COLUMN LASTUPDATE drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: downgrade (0800) drools-db-migration | drools-db-migration | check_results: status:1, operation:downgrade, from:0800, to:0800, new records:7, sqlFiles:7 drools-db-migration | *** Test 7: PASS , Successful downgrade, current version: 0800 *** drools-db-migration | 278 blocks drools-db-migration | Preparing upgrade release version: 0800 drools-db-migration | Preparing upgrade release version: 0900 drools-db-migration | Done drools-db-migration | upgrade: 0800 -> 0900 drools-db-migration | drools-db-migration | > upgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime DEFAULT NULL NULL AFTER HEALTHY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0130-idx_tsidx1.sql drools-db-migration | -------------- drools-db-migration | ERROR 1146 (42S02) at line 20: Table 'policyadmin.pdpstatistics' doesn't exist drools-db-migration | CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: upgrade aborted at 0900 by script 0130-idx_tsidx1.sql drools-db-migration | policyadmin: failure: upgrade to release 0900 (0900) drools-db-migration | upgrade: 0900 -> 0900 drools-db-migration | Partial upgrade detected drools-db-migration | Upgrade will attempt to resume at 0130-idx_tsidx1.sql drools-db-migration | drools-db-migration | > upgrade 0130-idx_tsidx1.sql 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 | > upgrade 0140-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP PRIMARY KEY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0150-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0160-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0180-jpapolicyaudit.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0190-JpaPolicyAuditIndex_timestamp.sql 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 | > upgrade 0200-sequence.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', 0) drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: upgrade (0900) drools-db-migration | drools-db-migration | check_results: status:1, operation:upgrade, from:0800, to:0900, new records:13, sqlFiles:13 drools-db-migration | *** Test 8: PASS , Successful upgrade, current version: 0900 *** drools-db-migration | 239 blocks drools-db-migration | Preparing downgrade release version: 0800 drools-db-migration | Preparing downgrade release version: 0900 drools-db-migration | Done drools-db-migration | downgrade: 0900 -> 0800 drools-db-migration | drools-db-migration | > downgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | DELETE from sequence drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0200-sequence.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `sequence` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0190-JpaPolicyAuditIndex_timestamp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0180-jpapolicyaudit.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `jpapolicyaudit` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0160-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0150-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0140-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0130-idx_tsidx1.sql drools-db-migration | -------------- drools-db-migration | DROP INDEX IDX_TSIDX1 ON pdpstatistics drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp DROP COLUMN LASTUPDATE drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: downgrade (0800) drools-db-migration | 278 blocks drools-db-migration | Preparing upgrade release version: 0800 drools-db-migration | Preparing upgrade release version: 0900 drools-db-migration | Done drools-db-migration | upgrade: 0800 -> 0900 drools-db-migration | drools-db-migration | > upgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime DEFAULT NULL NULL AFTER HEALTHY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0130-idx_tsidx1.sql 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 | > upgrade 0140-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP PRIMARY KEY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0150-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0160-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0180-jpapolicyaudit.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0190-JpaPolicyAuditIndex_timestamp.sql 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 | > upgrade 0200-sequence.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)) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > upgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', 0) drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: upgrade (0900) drools-db-migration | drools-db-migration | check_results: status:1, operation:upgrade, from:0800, to:0900, new records:12, sqlFiles:12 drools-db-migration | *** Test 9: PASS , Successful upgrade, current version: 0900 *** drools-db-migration | 239 blocks drools-db-migration | Preparing downgrade release version: 0800 drools-db-migration | Preparing downgrade release version: 0900 drools-db-migration | Done drools-db-migration | downgrade: 0900 -> 0800 drools-db-migration | drools-db-migration | > downgrade 0210-sequence.sql drools-db-migration | -------------- drools-db-migration | DELETE from sequence drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0200-sequence.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `sequence` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0190-JpaPolicyAuditIndex_timestamp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0180-jpapolicyaudit.sql drools-db-migration | -------------- drools-db-migration | DROP TABLE IF EXISTS `jpapolicyaudit` drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0170-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NOT NULL drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0160-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0150-pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0140-pk_pdpstatistics.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0130-idx_tsidx1.sql drools-db-migration | -------------- drools-db-migration | DROP INDEX IDX_TSIDX1 ON pdpstatistics drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0120-pdp.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE pdp DROP COLUMN LASTUPDATE drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0110-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID drools-db-migration | -------------- drools-db-migration | drools-db-migration | drools-db-migration | > downgrade 0100-jpapdpstatistics_enginestats.sql drools-db-migration | -------------- drools-db-migration | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime DEFAULT NULL NULL AFTER UPTIME drools-db-migration | -------------- drools-db-migration | drools-db-migration | policyadmin: OK: downgrade (0800) drools-db-migration | drools-db-migration | check_results: status:1, operation:downgrade, from:0900, to:0800, new records:12, sqlFiles:12 drools-db-migration | *** Test 10: PASS , Successful downgrade, current version: 0800 *** drools-db-migration | drools-db-migration | ----------------------------------------------------------------------- drools-db-migration | Number of Tests: 10, Tests Passed: 10, Tests Failed: 0 drools-db-migration | Date: 2021-08-16-13:00:50 drools-db-migration | ----------------------------------------------------------------------- drools-db-migration exited with code 0 Gracefully stopping... (press Ctrl+C again to force)