/
Drools Docker Compose Testing

Drools Docker Compose Testing

Owned by Kevin Timoney
Last updated: Jun 30, 2021

docker-compose-test.yml


docker-compose-test.yml
#
# ===========LICENSE_START====================================================
#  Copyright (C) 2020-2021 AT&T Intellectual Property. All rights reserved.
#  Modifications Copyright (C) 2021 Bell Canada. All rights reserved.
# ============================================================================
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#      http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
# ============LICENSE_END=====================================================
#
version: '2'
services:
   mariadb:
      image: nexus3.onap.org:10001/mariadb:10.5.8
      container_name: mariadb
      hostname: mariadb
      command: ['--lower-case-table-names=1', '--wait_timeout=28800']
      env_file: config/db/db.conf
      environment:
        MYSQL_DB: policyadmin
      volumes:
         - ./config/db:/docker-entrypoint-initdb.d:ro
      expose:
       - 3306
   drools-db-migration:
      image:  nexus3.onap.org:10001/onap/policy-drools:1.9-SNAPSHOT-latest
      container_name: drools-db-migration
      depends_on:
        - mariadb
      hostname: drools-db-migration
      expose:
       - 6824
      env_file: config/db/db.conf
      environment:
        SQL_DB: policyadmin
        SQL_HOST: mariadb
      volumes:
         - ./config/db/db.conf:/home/policy/db.conf:ro
         - ./config/sql:/home/policy/sql
         - ./drools_policy_init.sh:/opt/app/policy/bin/drools_policy_init.sh:ro
         - ./wait_for_port.sh:/opt/app/policy/bin/wait_for_port.sh:ro
      entrypoint: /opt/app/policy/bin/wait_for_port.sh
      command: [
              '-c',
                '/opt/app/policy/bin/drools_policy_init.sh',
                'mariadb', '3306'
               ]


drools_policy_init.sh


drools_policy_init.sh
#!/bin/sh
# ============LICENSE_START====================================================
#  Copyright (C) 2021. Nordix Foundation. All rights reserved.
# =============================================================================
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#      http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
# SPDX-License-Identifier: Apache-2.0
# ============LICENSE_END======================================================

export POLICY_HOME=/opt/app/policy
export SQL_USER=${MYSQL_USER}
export SQL_PASSWORD=${MYSQL_PASSWORD}
mkdir -p /opt/app/policy/etc/db/migration/${SQL_DB}/sql/
cp /home/policy/sql/*.sql /opt/app/policy/etc/db/migration/${SQL_DB}/sql/

/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o report

/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o upgrade

/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o report

nc -lk -p 6824

exit 0



Creating network "csit_default" with the default driver
Creating mariadb ... done
Creating drools-db-migration ... done
Attaching to mariadb, drools-db-migration
drools-db-migration | Waiting for mariadb port 3306...
drools-db-migration | nc: connect to mariadb port 3306 (tcp) failed: Connection refused
mariadb | 2021-06-28 15:11:26+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.8+maria~focal started.
mariadb | 2021-06-28 15:11:26+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mariadb | 2021-06-28 15:11:26+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.8+maria~focal started.
mariadb | 2021-06-28 15:11:26+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-06-28 15:11:28+00:00 [Note] [Entrypoint]: Database files initialized
mariadb | 2021-06-28 15:11:28+00:00 [Note] [Entrypoint]: Starting temporary server
mariadb | 2021-06-28 15:11:28+00:00 [Note] [Entrypoint]: Waiting for server startup
mariadb | 2021-06-28 15:11:28 0 [Note] mysqld (mysqld 10.5.8-MariaDB-1:10.5.8+maria~focal) starting as process 113 ...
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Using Linux native AIO
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Uses event mutexes
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Number of pools: 1
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mariadb | 2021-06-28 15:11:28 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Completed initialization of buffer pool
mariadb | 2021-06-28 15:11:28 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-06-28 15:11:28 0 [Note] InnoDB: 128 rollback segments are active.
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: 10.5.8 started; log sequence number 45118; transaction id 20
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mariadb | 2021-06-28 15:11:28 0 [Note] Plugin 'FEEDBACK' is disabled.
mariadb | 2021-06-28 15:11:28 0 [Note] InnoDB: Buffer pool(s) load completed at 210628 15:11:28
mariadb | 2021-06-28 15:11:28 0 [Warning] 'user' entry 'root@mariadb' ignored in --skip-name-resolve mode.
mariadb | 2021-06-28 15:11:28 0 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode.
mariadb | 2021-06-28 15:11:28 0 [Note] Reading of all Master_info entries succeeded
mariadb | 2021-06-28 15:11:28 0 [Note] Added new Master_info '' to hash table
mariadb | 2021-06-28 15:11:28 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-06-28 15:11:29+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.
drools-db-migration | .nc: connect to mariadb port 3306 (tcp) failed: Connection refused
mariadb | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
mariadb | 2021-06-28 15:11:31 5 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode.
mariadb | 2021-06-28 15:11:31+00:00 [Note] [Entrypoint]: Creating user policy_user
mariadb |
mariadb |
mariadb | 2021-06-28 15:11:31+00:00 [Warn] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/db.conf
mariadb | 2021-06-28 15:11:31+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 support onap_sdk log migration operationshistory10 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 support onap_sdk log migration operationshistory10 pooling policyadmin operationshistory
mariadb | + mysql -uroot -p****** --execute 'CREATE DATABASE IF NOT EXISTS support;'
mariadb | + mysql -uroot -p****** --execute 'GRANT ALL PRIVILEGES ON `support`.* TO '\''policy_user'\''@'\''%'\'' ;'
mariadb | + for db in support onap_sdk log migration operationshistory10 pooling policyadmin operationshistory
mariadb | + mysql -uroot -p****** --execute 'CREATE DATABASE IF NOT EXISTS onap_sdk;'
mariadb | + mysql -uroot -p****** --execute 'GRANT ALL PRIVILEGES ON `onap_sdk`.* TO '\''policy_user'\''@'\''%'\'' ;'
mariadb | + for db in support onap_sdk log migration operationshistory10 pooling policyadmin operationshistory
mariadb | + mysql -uroot -p****** --execute 'CREATE DATABASE IF NOT EXISTS log;'
mariadb | + mysql -uroot -p****** --execute 'GRANT ALL PRIVILEGES ON `log`.* TO '\''policy_user'\''@'\''%'\'' ;'
mariadb | + for db in support onap_sdk log migration operationshistory10 pooling policyadmin operationshistory
mariadb | + mysql -uroot -p****** --execute 'CREATE DATABASE IF NOT EXISTS migration;'
mariadb | + mysql -uroot -p****** --execute 'GRANT ALL PRIVILEGES ON `migration`.* TO '\''policy_user'\''@'\''%'\'' ;'
mariadb | + for db in support onap_sdk log migration operationshistory10 pooling policyadmin operationshistory
mariadb | + mysql -uroot -p****** --execute 'CREATE DATABASE IF NOT EXISTS operationshistory10;'
mariadb | + mysql -uroot -p****** --execute 'GRANT ALL PRIVILEGES ON `operationshistory10`.* TO '\''policy_user'\''@'\''%'\'' ;'
mariadb | + for db in support onap_sdk log migration operationshistory10 pooling policyadmin operationshistory
mariadb | + mysql -uroot -p****** --execute 'CREATE DATABASE IF NOT EXISTS pooling;'
mariadb | + mysql -uroot -p****** --execute 'GRANT ALL PRIVILEGES ON `pooling`.* TO '\''policy_user'\''@'\''%'\'' ;'
mariadb | + for db in support onap_sdk log migration operationshistory10 pooling policyadmin operationshistory
mariadb | + mysql -uroot -p****** --execute 'CREATE DATABASE IF NOT EXISTS policyadmin;'
mariadb | + mysql -uroot -p****** --execute 'GRANT ALL PRIVILEGES ON `policyadmin`.* TO '\''policy_user'\''@'\''%'\'' ;'
mariadb | + for db in support onap_sdk log migration operationshistory10 pooling policyadmin operationshistory
mariadb | + mysql -uroot -p****** --execute 'CREATE DATABASE IF NOT EXISTS operationshistory;'
mariadb | + mysql -uroot -p****** --execute 'GRANT ALL PRIVILEGES ON `operationshistory`.* TO '\''policy_user'\''@'\''%'\'' ;'
mariadb |
mariadb | mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "FLUSH PRIVILEGES;"
mariadb | + mysql -uroot -p****** --execute 'FLUSH PRIVILEGES;'
mariadb | 2021-06-28 15:11:31 23 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode.
mariadb |
mariadb | 2021-06-28 15:11:31+00:00 [Note] [Entrypoint]: Stopping temporary server
mariadb | 2021-06-28 15:11:31 0 [Note] mysqld (initiated by: root[root] @ localhost []): Normal shutdown
mariadb | 2021-06-28 15:11:31 0 [Note] Event Scheduler: Purging the queue. 0 events
mariadb | 2021-06-28 15:11:31 0 [Note] InnoDB: FTS optimize thread exiting.
drools-db-migration | .nc: connect to mariadb port 3306 (tcp) failed: Connection refused
mariadb | 2021-06-28 15:11:31 0 [Note] InnoDB: Starting shutdown...
mariadb | 2021-06-28 15:11:31 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
mariadb | 2021-06-28 15:11:31 0 [Note] InnoDB: Buffer pool(s) dump completed at 210628 15:11:31
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Shutdown completed; log sequence number 45130; transaction id 21
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
mariadb | 2021-06-28 15:11:32 0 [Note] mysqld: Shutdown complete
mariadb |
mariadb | 2021-06-28 15:11:32+00:00 [Note] [Entrypoint]: Temporary server stopped
mariadb |
mariadb | 2021-06-28 15:11:32+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
mariadb |
drools-db-migration | .nc: connect to mariadb port 3306 (tcp) failed: Connection refused
mariadb | 2021-06-28 15:11:32 0 [Note] mysqld (mysqld 10.5.8-MariaDB-1:10.5.8+maria~focal) starting as process 1 ...
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Using Linux native AIO
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Uses event mutexes
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Number of pools: 1
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mariadb | 2021-06-28 15:11:32 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Completed initialization of buffer pool
mariadb | 2021-06-28 15:11:32 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-06-28 15:11:32 0 [Note] InnoDB: 128 rollback segments are active.
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: 10.5.8 started; log sequence number 45130; transaction id 20
mariadb | 2021-06-28 15:11:32 0 [Note] Plugin 'FEEDBACK' is disabled.
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mariadb | 2021-06-28 15:11:32 0 [Note] InnoDB: Buffer pool(s) load completed at 210628 15:11:32
mariadb | 2021-06-28 15:11:32 0 [Note] Server socket created on IP: '::'.
mariadb | 2021-06-28 15:11:32 0 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode.
mariadb | 2021-06-28 15:11:32 0 [Note] Reading of all Master_info entries succeeded
mariadb | 2021-06-28 15:11:32 0 [Note] Added new Master_info '' to hash table
mariadb | 2021-06-28 15:11:32 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-06-28 15:11:33 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '192.168.176.3' (This connection closed normally without authentication)
drools-db-migration | +-------------+---------+
drools-db-migration | | name | version |
drools-db-migration | +-------------+---------+
drools-db-migration | | policyadmin | 0 |
drools-db-migration | +-------------+---------+
drools-db-migration | policyadmin: upgrade available: 0 -> 01
drools-db-migration | upgrade: 0 -> 01
drools-db-migration |
drools-db-migration | > upgrade 01-policyadmin.upgrade.sql
drools-db-migration | --------------
drools-db-migration | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40101 SET NAMES utf8 */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!50503 SET NAMES utf8mb4 */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `clelementstatistics` (
drools-db-migration | `CLELEMENTUPTIME` bigint(20) DEFAULT NULL,
drools-db-migration | `STATE` int(11) DEFAULT NULL,
drools-db-migration | `timeStamp` datetime(3) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `participant_name` varchar(255) DEFAULT NULL,
drools-db-migration | `participant_version` varchar(255) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`timeStamp`,`parentKeyName`,`localName`,`parentLocalName`,`parentKeyVersion`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `clelementstatistics` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `clelementstatistics` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `controlloop` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `ORDEREDSTATE` int(11) DEFAULT NULL,
drools-db-migration | `STATE` int(11) DEFAULT NULL,
drools-db-migration | `definition_name` varchar(255) DEFAULT NULL,
drools-db-migration | `definition_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `controlloop` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `controlloop` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `controlloopelement` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `ORDEREDSTATE` int(11) DEFAULT NULL,
drools-db-migration | `STATE` int(11) DEFAULT NULL,
drools-db-migration | `definition_name` varchar(255) DEFAULT NULL,
drools-db-migration | `definition_version` varchar(255) DEFAULT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | `participant_name` varchar(255) DEFAULT NULL,
drools-db-migration | `participant_version` varchar(255) DEFAULT NULL,
drools-db-migration | `participant_type_name` varchar(255) DEFAULT NULL,
drools-db-migration | `participant_type_version` varchar(255) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `controlloopelement` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `controlloopelement` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `controlloop_controlloopelement` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | `ELEMENTS_KEY` longblob DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`,`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `controlloop_controlloopelement` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `controlloop_controlloopelement` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpapdpgroup_properties` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `PROPERTIES` varchar(255) DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapdpgroup_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapdpgroup_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpapdpstatistics_enginestats` (
drools-db-migration | `AVERAGEEXECUTIONTIME` double DEFAULT NULL,
drools-db-migration | `ENGINEID` varchar(255) DEFAULT NULL,
drools-db-migration | `ENGINETIMESTAMP` bigint(20) DEFAULT NULL,
drools-db-migration | `ENGINEWORKERSTATE` int(11) DEFAULT NULL,
drools-db-migration | `EVENTCOUNT` bigint(20) DEFAULT NULL,
drools-db-migration | `LASTENTERTIME` bigint(20) DEFAULT NULL,
drools-db-migration | `LASTEXECUTIONTIME` bigint(20) DEFAULT NULL,
drools-db-migration | `LASTSTART` bigint(20) DEFAULT NULL,
drools-db-migration | `UPTIME` bigint(20) DEFAULT NULL,
drools-db-migration | `ID` bigint(20) DEFAULT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapdpstatistics_enginestats` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapdpstatistics_enginestats` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpapdpsubgroup_policies` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `parentLocalName` varchar(120) DEFAULT NULL,
drools-db-migration | `localName` varchar(120) DEFAULT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) DEFAULT NULL,
drools-db-migration | `parentKeyName` varchar(120) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapdpsubgroup_policies` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapdpsubgroup_policies` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpapdpsubgroup_properties` (
drools-db-migration | `parentLocalName` varchar(120) DEFAULT NULL,
drools-db-migration | `localName` varchar(120) DEFAULT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) DEFAULT NULL,
drools-db-migration | `parentKeyName` varchar(120) DEFAULT NULL,
drools-db-migration | `PROPERTIES` varchar(255) DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapdpsubgroup_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapdpsubgroup_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpapdpsubgroup_supportedpolicytypes` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `parentLocalName` varchar(120) DEFAULT NULL,
drools-db-migration | `localName` varchar(120) DEFAULT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) DEFAULT NULL,
drools-db-migration | `parentKeyName` varchar(120) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapdpsubgroup_supportedpolicytypes` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapdpsubgroup_supportedpolicytypes` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpapolicyaudit` (
drools-db-migration | `ACTION` int(11) DEFAULT NULL,
drools-db-migration | `PDPGROUP` varchar(255) DEFAULT NULL,
drools-db-migration | `PDPTYPE` varchar(255) DEFAULT NULL,
drools-db-migration | `TIMESTAMP` datetime DEFAULT NULL,
drools-db-migration | `USER` varchar(255) DEFAULT NULL,
drools-db-migration | `ID` bigint(20) NOT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`ID`,`name`,`version`),
drools-db-migration | KEY `JpaPolicyAuditIndex_timestamp` (`TIMESTAMP`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapolicyaudit` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpapolicyaudit` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscacapabilityassignment_attributes` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `ATTRIBUTES` longtext DEFAULT NULL,
drools-db-migration | `ATTRIBUTES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilityassignment_attributes` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilityassignment_attributes` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscacapabilityassignment_metadata` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilityassignment_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilityassignment_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscacapabilityassignment_occurrences` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `OCCURRENCES` int(11) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilityassignment_occurrences` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilityassignment_occurrences` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscacapabilityassignment_properties` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `PROPERTIES` longtext DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilityassignment_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilityassignment_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscacapabilitytype_metadata` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilitytype_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilitytype_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscacapabilitytype_properties` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `PROPERTIES` longblob DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilitytype_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscacapabilitytype_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscadatatype_constraints` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `CONSTRAINTS` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscadatatype_constraints` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscadatatype_constraints` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscadatatype_metadata` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscadatatype_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscadatatype_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscadatatype_properties` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `PROPERTIES` longblob DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscadatatype_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscadatatype_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscanodetemplate_metadata` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscanodetemplate_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscanodetemplate_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscanodetemplate_properties` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `PROPERTIES` longtext DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscanodetemplate_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscanodetemplate_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscanodetype_metadata` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscanodetype_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscanodetype_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscanodetype_properties` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `PROPERTIES` longblob DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscanodetype_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscanodetype_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscapolicytype_metadata` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicytype_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicytype_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscapolicytype_properties` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `PROPERTIES` longblob DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicytype_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicytype_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscapolicytype_targets` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicytype_targets` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicytype_targets` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscapolicytype_triggers` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `TRIGGERS` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicytype_triggers` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicytype_triggers` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscapolicy_metadata` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicy_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicy_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscapolicy_properties` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `PROPERTIES` longtext DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicy_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicy_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscapolicy_targets` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicy_targets` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscapolicy_targets` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscaproperty_constraints` (
drools-db-migration | `parentLocalName` varchar(120) DEFAULT NULL,
drools-db-migration | `localName` varchar(120) DEFAULT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) DEFAULT NULL,
drools-db-migration | `parentKeyName` varchar(120) DEFAULT NULL,
drools-db-migration | `CONSTRAINTS` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscaproperty_constraints` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscaproperty_constraints` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscaproperty_metadata` (
drools-db-migration | `parentLocalName` varchar(120) DEFAULT NULL,
drools-db-migration | `localName` varchar(120) DEFAULT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) DEFAULT NULL,
drools-db-migration | `parentKeyName` varchar(120) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscaproperty_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscaproperty_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscarelationshiptype_metadata` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscarelationshiptype_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscarelationshiptype_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscarelationshiptype_properties` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `PROPERTIES` longblob DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscarelationshiptype_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscarelationshiptype_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscarequirement_metadata` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscarequirement_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscarequirement_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscarequirement_occurrences` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `OCCURRENCES` int(11) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscarequirement_occurrences` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscarequirement_occurrences` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscarequirement_properties` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `PROPERTIES` longtext DEFAULT NULL,
drools-db-migration | `PROPERTIES_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscarequirement_properties` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscarequirement_properties` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscaservicetemplate_metadata` (
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | `METADATA` varchar(255) DEFAULT NULL,
drools-db-migration | `METADATA_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscaservicetemplate_metadata` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscaservicetemplate_metadata` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `jpatoscatopologytemplate_inputs` (
drools-db-migration | `parentLocalName` varchar(120) DEFAULT NULL,
drools-db-migration | `localName` varchar(120) DEFAULT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) DEFAULT NULL,
drools-db-migration | `parentKeyName` varchar(120) DEFAULT NULL,
drools-db-migration | `INPUTS` longblob DEFAULT NULL,
drools-db-migration | `INPUTS_KEY` varchar(255) DEFAULT NULL
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscatopologytemplate_inputs` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `jpatoscatopologytemplate_inputs` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `participant` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `HEALTHSTATUS` int(11) DEFAULT NULL,
drools-db-migration | `PARTICIPANTSTATE` int(11) DEFAULT NULL,
drools-db-migration | `definition_name` varchar(255) DEFAULT NULL,
drools-db-migration | `definition_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `participant` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `participant` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `participantstatistics` (
drools-db-migration | `AVERAGEEXECUTIONTIME` double DEFAULT NULL,
drools-db-migration | `EVENTCOUNT` bigint(20) DEFAULT NULL,
drools-db-migration | `HEALTHSTATUS` int(11) DEFAULT NULL,
drools-db-migration | `LASTENTERTIME` bigint(20) DEFAULT NULL,
drools-db-migration | `LASTEXECUTIONTIME` bigint(20) DEFAULT NULL,
drools-db-migration | `LASTSTART` bigint(20) DEFAULT NULL,
drools-db-migration | `STATE` int(11) DEFAULT NULL,
drools-db-migration | `UPTIME` bigint(20) DEFAULT NULL,
drools-db-migration | `timeStamp` datetime(3) NOT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | `participant_name` varchar(255) DEFAULT NULL,
drools-db-migration | `participant_version` varchar(255) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`timeStamp`,`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `participantstatistics` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `participantstatistics` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `pdp` (
drools-db-migration | `HEALTHY` int(11) DEFAULT NULL,
drools-db-migration | `MESSAGE` varchar(255) DEFAULT NULL,
drools-db-migration | `PDPSTATE` int(11) DEFAULT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | PRIMARY KEY (`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdp` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdp` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `pdpgroup` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `PDPGROUPSTATE` int(11) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdpgroup` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdpgroup` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `pdpgroup_pdpsubgroup` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`,`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdpgroup_pdpsubgroup` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdpgroup_pdpsubgroup` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `pdppolicystatus` (
drools-db-migration | `DEPLOY` tinyint(1) DEFAULT 0,
drools-db-migration | `PDPGROUP` varchar(255) DEFAULT NULL,
drools-db-migration | `PDPTYPE` varchar(255) DEFAULT NULL,
drools-db-migration | `STATE` int(11) DEFAULT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`),
drools-db-migration | KEY `PdpPolicyStatus_PdpGroup` (`PDPGROUP`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdppolicystatus` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdppolicystatus` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `pdpstatistics` (
drools-db-migration | `PDPGROUPNAME` varchar(120) DEFAULT NULL,
drools-db-migration | `PDPSUBGROUPNAME` varchar(120) DEFAULT NULL,
drools-db-migration | `POLICYDEPLOYCOUNT` bigint(20) DEFAULT NULL,
drools-db-migration | `POLICYDEPLOYFAILCOUNT` bigint(20) DEFAULT NULL,
drools-db-migration | `POLICYDEPLOYSUCCESSCOUNT` bigint(20) DEFAULT NULL,
drools-db-migration | `POLICYEXECUTEDCOUNT` bigint(20) DEFAULT NULL,
drools-db-migration | `POLICYEXECUTEDFAILCOUNT` bigint(20) DEFAULT NULL,
drools-db-migration | `POLICYEXECUTEDSUCCESSCOUNT` bigint(20) DEFAULT NULL,
drools-db-migration | `TIMESTAMP` datetime(3) DEFAULT NULL,
drools-db-migration | `ID` bigint(20) NOT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`ID`,`name`,`version`),
drools-db-migration | KEY `IDX_TSIDX1` (`TIMESTAMP`,`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdpstatistics` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdpstatistics` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `pdpsubgroup` (
drools-db-migration | `CURRENTINSTANCECOUNT` int(11) DEFAULT NULL,
drools-db-migration | `DESIREDINSTANCECOUNT` int(11) DEFAULT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | PRIMARY KEY (`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdpsubgroup` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdpsubgroup` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `pdpsubgroup_pdp` (
drools-db-migration | `pdpParentKeyName` varchar(120) NOT NULL,
drools-db-migration | `pdpParentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `pdpParentLocalName` varchar(120) NOT NULL,
drools-db-migration | `pdpLocalName` varchar(120) NOT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | PRIMARY KEY (`pdpParentKeyName`,`pdpParentKeyVersion`,`pdpParentLocalName`,`pdpLocalName`,`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdpsubgroup_pdp` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `pdpsubgroup_pdp` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `sequence` (
drools-db-migration | `SEQ_NAME` varchar(50) NOT NULL,
drools-db-migration | `SEQ_COUNT` decimal(38,0) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`SEQ_NAME`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `sequence` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | INSERT INTO `sequence` (`SEQ_NAME`, `SEQ_COUNT`) VALUES
drools-db-migration | ('SEQ_GEN', 0)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `sequence` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscacapabilityassignment` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_name` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | `type_name` varchar(255) DEFAULT NULL,
drools-db-migration | `type_version` varchar(255) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilityassignment` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilityassignment` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscacapabilityassignments` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilityassignments` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilityassignments` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscacapabilityassignments_toscacapabilityassignment` (
drools-db-migration | `conceptContainerMapName` varchar(120) NOT NULL,
drools-db-migration | `concpetContainerMapVersion` varchar(20) NOT NULL,
drools-db-migration | `conceptContainerName` varchar(120) NOT NULL,
drools-db-migration | `conceptContainerVersion` varchar(20) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`conceptContainerMapName`,`concpetContainerMapVersion`,`conceptContainerName`,`conceptContainerVersion`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilityassignments_toscacapabilityassignment` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilityassignments_toscacapabilityassignment` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscacapabilitytype` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_name` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilitytype` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilitytype` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscacapabilitytypes` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilitytypes` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilitytypes` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscacapabilitytypes_toscacapabilitytype` (
drools-db-migration | `conceptContainerMapName` varchar(120) NOT NULL,
drools-db-migration | `concpetContainerMapVersion` varchar(20) NOT NULL,
drools-db-migration | `conceptContainerName` varchar(120) NOT NULL,
drools-db-migration | `conceptContainerVersion` varchar(20) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`conceptContainerMapName`,`concpetContainerMapVersion`,`conceptContainerName`,`conceptContainerVersion`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilitytypes_toscacapabilitytype` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscacapabilitytypes_toscacapabilitytype` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscadatatype` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_name` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscadatatype` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | INSERT INTO `toscadatatype` (`DESCRIPTION`, `derived_from_name`, `derived_from_version`, `name`, `version`) VALUES
drools-db-migration | ('An actor/operation/target definition', 'tosca.datatypes.Root', '0.0.0', 'onap.datatype.controlloop.Actor', '0.0.0'),
drools-db-migration | ('An operation supported by an actor', 'tosca.datatypes.Root', '0.0.0', 'onap.datatype.controlloop.Operation', '0.0.0'),
drools-db-migration | ('Definition for a entity in A&AI to perform a control loop operation on', 'tosca.datatypes.Root', '0.0.0', 'onap.datatype.controlloop.Target', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.dmaap.custom_serialization', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.dmaap.events', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.dmaap.topic', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.drools.controller.relation', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'onap.datatypes.guard.filter', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.filters', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.managedObjectDNsBasic', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.managedObjectDNsBasics', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.measurementGroup', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.measurementGroups', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.measurementType', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.measurementTypes', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.metricsPerEventName', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.nfFilter', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.pm-mapper-filter', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.rcc_event_details', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.rcc_policy', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.subscription', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.tca_policy', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.monitoring.thresholds', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.native.apex.CarrierTechnology', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.native.apex.EngineService', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.native.apex.engineservice.Engine', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.native.apex.engineservice.engine.Context', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.native.apex.Environment', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.native.apex.EventHandler', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.native.apex.EventProtocol', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.native.apex.Plugin', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'onap.datatypes.native.rules_artifact', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.affinityProperties_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.capacityProperties_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.directives_attributes_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.directives_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.distanceProperties_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.distance_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.flavorFeatures_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.flavorProperties_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.hpa-feature-attributes_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'policy.data.increment-sequence', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'policy.data.naming-model-entity', '0.0.0'),
drools-db-migration | (NULL, 'tosca.datatypes.Root', '0.0.0', 'policy.data.naming-property', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.objectiveParameter_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.parameterAttributes_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.pciProperties_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.queryProperties_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.subscriberProperties_properties', '0.0.0'),
drools-db-migration | (NULL, 'tosca.nodes.Root', '0.0.0', 'policy.data.vnfProperties_properties', '0.0.0')
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscadatatype` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscadatatypes` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscadatatypes` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | INSERT INTO `toscadatatypes` (`name`, `version`) VALUES
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0')
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscadatatypes` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscadatatypes_toscadatatype` (
drools-db-migration | `conceptContainerMapName` varchar(120) NOT NULL,
drools-db-migration | `concpetContainerMapVersion` varchar(20) NOT NULL,
drools-db-migration | `conceptContainerName` varchar(120) NOT NULL,
drools-db-migration | `conceptContainerVersion` varchar(20) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`conceptContainerMapName`,`concpetContainerMapVersion`,`conceptContainerName`,`conceptContainerVersion`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscadatatypes_toscadatatype` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | INSERT INTO `toscadatatypes_toscadatatype` (`conceptContainerMapName`, `concpetContainerMapVersion`, `conceptContainerName`, `conceptContainerVersion`, `name`, `version`) VALUES
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatype.controlloop.Actor', '0.0.0', 'onap.datatype.controlloop.Actor', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatype.controlloop.Operation', '0.0.0', 'onap.datatype.controlloop.Operation', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatype.controlloop.Target', '0.0.0', 'onap.datatype.controlloop.Target', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.dmaap.custom_serialization', '0.0.0', 'onap.datatypes.dmaap.custom_serialization', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.dmaap.events', '0.0.0', 'onap.datatypes.dmaap.events', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.dmaap.topic', '0.0.0', 'onap.datatypes.dmaap.topic', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.drools.controller.relation', '0.0.0', 'onap.datatypes.drools.controller.relation', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.guard.filter', '0.0.0', 'onap.datatypes.guard.filter', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.filters', '0.0.0', 'onap.datatypes.monitoring.filters', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.managedObjectDNsBasic', '0.0.0', 'onap.datatypes.monitoring.managedObjectDNsBasic', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.managedObjectDNsBasics', '0.0.0', 'onap.datatypes.monitoring.managedObjectDNsBasics', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.measurementGroup', '0.0.0', 'onap.datatypes.monitoring.measurementGroup', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.measurementGroups', '0.0.0', 'onap.datatypes.monitoring.measurementGroups', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.measurementType', '0.0.0', 'onap.datatypes.monitoring.measurementType', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.measurementTypes', '0.0.0', 'onap.datatypes.monitoring.measurementTypes', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.metricsPerEventName', '0.0.0', 'onap.datatypes.monitoring.metricsPerEventName', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.nfFilter', '0.0.0', 'onap.datatypes.monitoring.nfFilter', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.pm-mapper-filter', '0.0.0', 'onap.datatypes.monitoring.pm-mapper-filter', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.rcc_event_details', '0.0.0', 'onap.datatypes.monitoring.rcc_event_details', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.rcc_policy', '0.0.0', 'onap.datatypes.monitoring.rcc_policy', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.subscription', '0.0.0', 'onap.datatypes.monitoring.subscription', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.tca_policy', '0.0.0', 'onap.datatypes.monitoring.tca_policy', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.monitoring.thresholds', '0.0.0', 'onap.datatypes.monitoring.thresholds', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.native.apex.CarrierTechnology', '0.0.0', 'onap.datatypes.native.apex.CarrierTechnology', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.native.apex.EngineService', '0.0.0', 'onap.datatypes.native.apex.EngineService', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.native.apex.engineservice.Engine', '0.0.0', 'onap.datatypes.native.apex.engineservice.Engine', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.native.apex.engineservice.engine.Context', '0.0.0', 'onap.datatypes.native.apex.engineservice.engine.Context', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.native.apex.Environment', '0.0.0', 'onap.datatypes.native.apex.Environment', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.native.apex.EventHandler', '0.0.0', 'onap.datatypes.native.apex.EventHandler', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.native.apex.EventProtocol', '0.0.0', 'onap.datatypes.native.apex.EventProtocol', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.native.apex.Plugin', '0.0.0', 'onap.datatypes.native.apex.Plugin', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'onap.datatypes.native.rules_artifact', '0.0.0', 'onap.datatypes.native.rules_artifact', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.affinityProperties_properties', '0.0.0', 'policy.data.affinityProperties_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.capacityProperties_properties', '0.0.0', 'policy.data.capacityProperties_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.directives_attributes_properties', '0.0.0', 'policy.data.directives_attributes_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.directives_properties', '0.0.0', 'policy.data.directives_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.distanceProperties_properties', '0.0.0', 'policy.data.distanceProperties_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.distance_properties', '0.0.0', 'policy.data.distance_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.flavorFeatures_properties', '0.0.0', 'policy.data.flavorFeatures_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.flavorProperties_properties', '0.0.0', 'policy.data.flavorProperties_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.hpa-feature-attributes_properties', '0.0.0', 'policy.data.hpa-feature-attributes_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.increment-sequence', '0.0.0', 'policy.data.increment-sequence', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.naming-model-entity', '0.0.0', 'policy.data.naming-model-entity', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.naming-property', '0.0.0', 'policy.data.naming-property', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.objectiveParameter_properties', '0.0.0', 'policy.data.objectiveParameter_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.parameterAttributes_properties', '0.0.0', 'policy.data.parameterAttributes_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.pciProperties_properties', '0.0.0', 'policy.data.pciProperties_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.queryProperties_properties', '0.0.0', 'policy.data.queryProperties_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.subscriberProperties_properties', '0.0.0', 'policy.data.subscriberProperties_properties', '0.0.0'),
drools-db-migration | ('ToscaDataTypesSimple', '1.0.0', 'policy.data.vnfProperties_properties', '0.0.0', 'policy.data.vnfProperties_properties', '0.0.0')
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscadatatypes_toscadatatype` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscanodetemplate` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_name` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | `type_name` varchar(255) DEFAULT NULL,
drools-db-migration | `type_version` varchar(255) DEFAULT NULL,
drools-db-migration | `capabilitiesName` varchar(120) DEFAULT NULL,
drools-db-migration | `capabilitiesVersion` varchar(20) DEFAULT NULL,
drools-db-migration | `requirementsVersion` varchar(20) DEFAULT NULL,
drools-db-migration | `requirementsName` varchar(120) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`),
drools-db-migration | KEY `FK_ToscaNodeTemplate_capabilitiesName` (`capabilitiesName`,`capabilitiesVersion`),
drools-db-migration | KEY `FK_ToscaNodeTemplate_requirementsName` (`requirementsName`,`requirementsVersion`),
drools-db-migration | CONSTRAINT `FK_ToscaNodeTemplate_capabilitiesName` FOREIGN KEY (`capabilitiesName`, `capabilitiesVersion`) REFERENCES `toscacapabilityassignments` (`name`, `version`),
drools-db-migration | CONSTRAINT `FK_ToscaNodeTemplate_requirementsName` FOREIGN KEY (`requirementsName`, `requirementsVersion`) REFERENCES `toscarequirements` (`name`, `version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetemplate` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetemplate` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscanodetemplates` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetemplates` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetemplates` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscanodetemplates_toscanodetemplate` (
drools-db-migration | `conceptContainerMapName` varchar(120) NOT NULL,
drools-db-migration | `concpetContainerMapVersion` varchar(20) NOT NULL,
drools-db-migration | `conceptContainerName` varchar(120) NOT NULL,
drools-db-migration | `conceptContainerVersion` varchar(20) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`conceptContainerMapName`,`concpetContainerMapVersion`,`conceptContainerName`,`conceptContainerVersion`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetemplates_toscanodetemplate` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetemplates_toscanodetemplate` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscanodetype` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_name` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | `requirementsVersion` varchar(20) DEFAULT NULL,
drools-db-migration | `requirementsName` varchar(120) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`),
drools-db-migration | KEY `FK_ToscaNodeType_requirementsName` (`requirementsName`,`requirementsVersion`),
drools-db-migration | CONSTRAINT `FK_ToscaNodeType_requirementsName` FOREIGN KEY (`requirementsName`, `requirementsVersion`) REFERENCES `toscarequirements` (`name`, `version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetype` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetype` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscanodetypes` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetypes` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetypes` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscanodetypes_toscanodetype` (
drools-db-migration | `conceptContainerMapName` varchar(120) NOT NULL,
drools-db-migration | `concpetContainerMapVersion` varchar(20) NOT NULL,
drools-db-migration | `conceptContainerName` varchar(120) NOT NULL,
drools-db-migration | `conceptContainerVersion` varchar(20) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`conceptContainerMapName`,`concpetContainerMapVersion`,`conceptContainerName`,`conceptContainerVersion`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetypes_toscanodetype` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscanodetypes_toscanodetype` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscaparameter` (
drools-db-migration | `VALUE` varchar(255) DEFAULT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscaparameter` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscaparameter` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscapolicies` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicies` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicies` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscapolicies_toscapolicy` (
drools-db-migration | `conceptContainerMapName` varchar(120) NOT NULL,
drools-db-migration | `concpetContainerMapVersion` varchar(20) NOT NULL,
drools-db-migration | `conceptContainerName` varchar(120) NOT NULL,
drools-db-migration | `conceptContainerVersion` varchar(20) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`conceptContainerMapName`,`concpetContainerMapVersion`,`conceptContainerName`,`conceptContainerVersion`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicies_toscapolicy` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicies_toscapolicy` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscapolicy` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_name` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | `type_name` varchar(255) DEFAULT NULL,
drools-db-migration | `type_version` varchar(255) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicy` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicy` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscapolicytype` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_name` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicytype` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicytype` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscapolicytypes` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicytypes` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | INSERT INTO `toscapolicytypes` (`name`, `version`) VALUES
drools-db-migration | ('ToscaPolicyTypesSimple', '1.0.0')
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicytypes` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscapolicytypes_toscapolicytype` (
drools-db-migration | `conceptContainerMapName` varchar(120) NOT NULL,
drools-db-migration | `concpetContainerMapVersion` varchar(20) NOT NULL,
drools-db-migration | `conceptContainerName` varchar(120) NOT NULL,
drools-db-migration | `conceptContainerVersion` varchar(20) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`conceptContainerMapName`,`concpetContainerMapVersion`,`conceptContainerName`,`conceptContainerVersion`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicytypes_toscapolicytype` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscapolicytypes_toscapolicytype` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscaproperty` (
drools-db-migration | `DEFAULTVALUE` varchar(255) DEFAULT NULL,
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `ENTRYSCHEMA` longblob DEFAULT NULL,
drools-db-migration | `REQUIRED` tinyint(1) DEFAULT 0,
drools-db-migration | `STATUS` int(11) DEFAULT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscaproperty` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscaproperty` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscarelationshiptype` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_name` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarelationshiptype` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarelationshiptype` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscarelationshiptypes` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarelationshiptypes` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarelationshiptypes` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscarelationshiptypes_toscarelationshiptype` (
drools-db-migration | `conceptContainerMapName` varchar(120) NOT NULL,
drools-db-migration | `concpetContainerMapVersion` varchar(20) NOT NULL,
drools-db-migration | `conceptContainerName` varchar(120) NOT NULL,
drools-db-migration | `conceptContainerVersion` varchar(20) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`conceptContainerMapName`,`concpetContainerMapVersion`,`conceptContainerName`,`conceptContainerVersion`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarelationshiptypes_toscarelationshiptype` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarelationshiptypes_toscarelationshiptype` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscarequirement` (
drools-db-migration | `CAPABILITY` varchar(255) DEFAULT NULL,
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `NODE` varchar(255) DEFAULT NULL,
drools-db-migration | `RELATIONSHIP` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_name` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | `type_name` varchar(255) DEFAULT NULL,
drools-db-migration | `type_version` varchar(255) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarequirement` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarequirement` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscarequirements` (
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarequirements` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarequirements` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscarequirements_toscarequirement` (
drools-db-migration | `conceptContainerMapName` varchar(120) NOT NULL,
drools-db-migration | `concpetContainerMapVersion` varchar(20) NOT NULL,
drools-db-migration | `conceptContainerName` varchar(120) NOT NULL,
drools-db-migration | `conceptContainerVersion` varchar(20) NOT NULL,
drools-db-migration | `name` varchar(120) DEFAULT NULL,
drools-db-migration | `version` varchar(20) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`conceptContainerMapName`,`concpetContainerMapVersion`,`conceptContainerName`,`conceptContainerVersion`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarequirements_toscarequirement` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscarequirements_toscarequirement` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscaservicetemplate` (
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `TOSCADEFINITIONSVERSION` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_name` varchar(255) DEFAULT NULL,
drools-db-migration | `derived_from_version` varchar(255) DEFAULT NULL,
drools-db-migration | `name` varchar(120) NOT NULL,
drools-db-migration | `version` varchar(20) NOT NULL,
drools-db-migration | `capabilityTypesVersion` varchar(20) DEFAULT NULL,
drools-db-migration | `capabilityTypesName` varchar(120) DEFAULT NULL,
drools-db-migration | `dataTypesName` varchar(120) DEFAULT NULL,
drools-db-migration | `dataTypesVersion` varchar(20) DEFAULT NULL,
drools-db-migration | `nodeTypesVersion` varchar(20) DEFAULT NULL,
drools-db-migration | `nodeTypesName` varchar(120) DEFAULT NULL,
drools-db-migration | `policyTypesName` varchar(120) DEFAULT NULL,
drools-db-migration | `policyTypesVersion` varchar(20) DEFAULT NULL,
drools-db-migration | `relationshipTypesVersion` varchar(20) DEFAULT NULL,
drools-db-migration | `relationshipTypesName` varchar(120) DEFAULT NULL,
drools-db-migration | `topologyTemplateLocalName` varchar(120) DEFAULT NULL,
drools-db-migration | `topologyTemplateParentKeyName` varchar(120) DEFAULT NULL,
drools-db-migration | `topologyTemplateParentKeyVersion` varchar(15) DEFAULT NULL,
drools-db-migration | `topologyTemplateParentLocalName` varchar(120) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`name`,`version`),
drools-db-migration | KEY `FK_ToscaServiceTemplate_dataTypesName` (`dataTypesName`,`dataTypesVersion`),
drools-db-migration | KEY `FK_ToscaServiceTemplate_relationshipTypesName` (`relationshipTypesName`,`relationshipTypesVersion`),
drools-db-migration | KEY `FK_ToscaServiceTemplate_capabilityTypesName` (`capabilityTypesName`,`capabilityTypesVersion`),
drools-db-migration | KEY `FK_ToscaServiceTemplate_policyTypesName` (`policyTypesName`,`policyTypesVersion`),
drools-db-migration | KEY `FK_ToscaServiceTemplate_nodeTypesName` (`nodeTypesName`,`nodeTypesVersion`),
drools-db-migration | KEY `TscaServiceTemplatetopologyTemplateParentLocalName` (`topologyTemplateParentLocalName`,`topologyTemplateLocalName`,`topologyTemplateParentKeyVersion`,`topologyTemplateParentKeyName`),
drools-db-migration | CONSTRAINT `FK_ToscaServiceTemplate_capabilityTypesName` FOREIGN KEY (`capabilityTypesName`, `capabilityTypesVersion`) REFERENCES `toscacapabilitytypes` (`name`, `version`),
drools-db-migration | CONSTRAINT `FK_ToscaServiceTemplate_dataTypesName` FOREIGN KEY (`dataTypesName`, `dataTypesVersion`) REFERENCES `toscadatatypes` (`name`, `version`),
drools-db-migration | CONSTRAINT `FK_ToscaServiceTemplate_nodeTypesName` FOREIGN KEY (`nodeTypesName`, `nodeTypesVersion`) REFERENCES `toscanodetypes` (`name`, `version`),
drools-db-migration | CONSTRAINT `FK_ToscaServiceTemplate_policyTypesName` FOREIGN KEY (`policyTypesName`, `policyTypesVersion`) REFERENCES `toscapolicytypes` (`name`, `version`),
drools-db-migration | CONSTRAINT `FK_ToscaServiceTemplate_relationshipTypesName` FOREIGN KEY (`relationshipTypesName`, `relationshipTypesVersion`) REFERENCES `toscarelationshiptypes` (`name`, `version`),
drools-db-migration | CONSTRAINT `TscaServiceTemplatetopologyTemplateParentLocalName` FOREIGN KEY (`topologyTemplateParentLocalName`, `topologyTemplateLocalName`, `topologyTemplateParentKeyVersion`, `topologyTemplateParentKeyName`) REFERENCES `toscatopologytemplate` (`parentLocalName`, `localName`, `parentKeyVersion`, `parentKeyName`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscaservicetemplate` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | INSERT INTO `toscaservicetemplate` (`DESCRIPTION`, `TOSCADEFINITIONSVERSION`, `derived_from_name`, `derived_from_version`, `name`, `version`, `capabilityTypesVersion`, `capabilityTypesName`, `dataTypesName`, `dataTypesVersion`, `nodeTypesVersion`, `nodeTypesName`, `policyTypesName`, `policyTypesVersion`, `relationshipTypesVersion`, `relationshipTypesName`, `topologyTemplateLocalName`, `topologyTemplateParentKeyName`, `topologyTemplateParentKeyVersion`, `topologyTemplateParentLocalName`) VALUES
drools-db-migration | (NULL, 'tosca_simple_yaml_1_1_0', NULL, NULL, 'ToscaServiceTemplateSimple', '1.0.0', NULL, NULL, 'ToscaDataTypesSimple', '1.0.0', NULL, NULL, 'ToscaPolicyTypesSimple', '1.0.0', NULL, NULL, NULL, NULL, NULL, NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscaservicetemplate` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscatopologytemplate` (
drools-db-migration | `description` varchar(255) DEFAULT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | `nodeTemplatessVersion` varchar(20) DEFAULT NULL,
drools-db-migration | `nodeTemplatesName` varchar(120) DEFAULT NULL,
drools-db-migration | `policyVersion` varchar(20) DEFAULT NULL,
drools-db-migration | `policyName` varchar(120) DEFAULT NULL,
drools-db-migration | PRIMARY KEY (`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`),
drools-db-migration | KEY `FK_ToscaTopologyTemplate_policyName` (`policyName`,`policyVersion`),
drools-db-migration | KEY `FK_ToscaTopologyTemplate_nodeTemplatesName` (`nodeTemplatesName`,`nodeTemplatessVersion`),
drools-db-migration | CONSTRAINT `FK_ToscaTopologyTemplate_nodeTemplatesName` FOREIGN KEY (`nodeTemplatesName`, `nodeTemplatessVersion`) REFERENCES `toscanodetemplates` (`name`, `version`),
drools-db-migration | CONSTRAINT `FK_ToscaTopologyTemplate_policyName` FOREIGN KEY (`policyName`, `policyVersion`) REFERENCES `toscapolicies` (`name`, `version`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscatopologytemplate` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscatopologytemplate` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS `toscatrigger` (
drools-db-migration | `ACTION` varchar(255) DEFAULT NULL,
drools-db-migration | `toscaCondition` longblob DEFAULT NULL,
drools-db-migration | `toscaConstraint` longblob DEFAULT NULL,
drools-db-migration | `DESCRIPTION` varchar(255) DEFAULT NULL,
drools-db-migration | `EVALUATIONS` int(11) DEFAULT NULL,
drools-db-migration | `EVENTTYPE` varchar(255) DEFAULT NULL,
drools-db-migration | `METHOD` varchar(255) DEFAULT NULL,
drools-db-migration | `PERIOD` longblob DEFAULT NULL,
drools-db-migration | `SCHEDULE` longblob DEFAULT NULL,
drools-db-migration | `TARGETFILTER` longblob DEFAULT NULL,
drools-db-migration | `parentLocalName` varchar(120) NOT NULL,
drools-db-migration | `localName` varchar(120) NOT NULL,
drools-db-migration | `parentKeyVersion` varchar(15) NOT NULL,
drools-db-migration | `parentKeyName` varchar(120) NOT NULL,
drools-db-migration | PRIMARY KEY (`parentLocalName`,`localName`,`parentKeyVersion`,`parentKeyName`)
drools-db-migration | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscatrigger` DISABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40000 ALTER TABLE `toscatrigger` ENABLE KEYS */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | policyadmin: OK: upgrade (01)
drools-db-migration | +-------------+---------+
drools-db-migration | | name | version |
drools-db-migration | +-------------+---------+
drools-db-migration | | policyadmin | 01 |
drools-db-migration | +-------------+---------+
drools-db-migration | +----------------------------+-----------+---------+---------------------+
drools-db-migration | | script | operation | success | atTime |
drools-db-migration | +----------------------------+-----------+---------+---------------------+
drools-db-migration | | 01-policyadmin.upgrade.sql | upgrade | 1 | 2021-06-28 15:11:34 |
drools-db-migration | +----------------------------+-----------+---------+---------------------+
drools-db-migration | policyadmin: OK @ 01


Upgrade/Downgrade testing

These have to be done separately.

For upgrade copy your .upgrade.sql scripts to /opt/app/policy/etc/db/migration/${SQL_DB}/sql/

and run /opt/app/policy/bin/db-migrator -s ${SQL_DB} -o upgrade


For downgrading (rollback) copy your .downgrade.sql scripts to /opt/app/policy/etc/db/migration/${SQL_DB}/sql/

and run /opt/app/policy/bin/db-migrator -s ${SQL_DB} -o downgrade


Update config/sql directory:

01-honolulu.upgrade.sql 02-istanbul.downgrade.sql 02-istanbul.upgrade.sql downgrade upgrade

ls upgrade/
01-controlloop.upgrade.sql 02-jpatoscacapabilityassignment_occurrences.upgrade.sql
01-pdpgroup.upgrade.sql 02-jpatoscacapabilityassignment_properties.upgrade.sql
01-pdppolicystatus.upgrade.sql 02-jpatoscacapabilitytype_metadata.upgrade.sql
01-pdpstatistics.upgrade.sql 02-jpatoscacapabilitytype_properties.upgrade.sql
01-pdpsubgroup.upgrade.sql 02-jpatoscadatatype_constraints.upgrade.sql
01-pdp.upgrade.sql 02-jpatoscadatatype_metadata.upgrade.sql
01-sequence.upgrade.sql 02-jpatoscadatatype_properties.upgrade.sql
01-toscacapabilityassignments.upgrade.sql 02-jpatoscanodetemplate_metadata.upgrade.sql
01-toscacapabilityassignment.upgrade.sql 02-jpatoscanodetemplate_properties.upgrade.sql
01-toscacapabilitytypes.upgrade.sql 02-jpatoscanodetype_metadata.upgrade.sql
01-toscacapabilitytype.upgrade.sql 02-jpatoscanodetype_properties.upgrade.sql
01-toscadatatypes.upgrade.sql 02-jpatoscapolicy_metadata.upgrade.sql
01-toscadatatype.upgrade.sql 02-jpatoscapolicy_properties.upgrade.sql
01-toscanodetemplates.upgrade.sql 02-jpatoscapolicy_targets.upgrade.sql
01-toscanodetemplate.upgrade.sql 02-jpatoscapolicytype_metadata.upgrade.sql
01-toscanodetypes.upgrade.sql 02-jpatoscapolicytype_properties.upgrade.sql
01-toscanodetype.upgrade.sql 02-jpatoscapolicytype_targets.upgrade.sql
01-toscaparameter.upgrade.sql 02-jpatoscapolicytype_triggers.upgrade.sql
01-toscapolicies.upgrade.sql 02-jpatoscaproperty_constraints.upgrade.sql
01-toscapolicytypes.upgrade.sql 02-jpatoscaproperty_metadata.upgrade.sql
01-toscapolicytype.upgrade.sql 02-jpatoscarelationshiptype_metadata.upgrade.sql
01-toscapolicy.upgrade.sql 02-jpatoscarelationshiptype_properties.upgrade.sql
01-toscaproperty.upgrade.sql 02-jpatoscarequirement_metadata.upgrade.sql
01-toscarelationshiptypes.upgrade.sql 02-jpatoscarequirement_occurrences.upgrade.sql
01-toscarelationshiptype.upgrade.sql 02-jpatoscarequirement_properties.upgrade.sql
01-toscarequirements.upgrade.sql 02-jpatoscaservicetemplate_metadata.upgrade.sql
01-toscarequirement.upgrade.sql 02-jpatoscatopologytemplate_inputs.upgrade.sql
01-toscaservicetemplate.upgrade.sql 02-participantstatistics.upgrade.sql
01-toscatopologytemplate.upgrade.sql 02-participant.upgrade.sql
01-toscatrigger.upgrade.sql 02-pdpgroup_pdpsubgroup.upgrade.sql
02-clelementstatistics.upgrade.sql 02-pdpsubgroup_pdp.upgrade.sql
02-controlloop_controlloopelement.upgrade.sql 02-toscacapabilityassignments_toscacapabilityassignment.upgrade.sql
02-controlloopelement.upgrade.sql 02-toscacapabilitytypes_toscacapabilitytype.upgrade.sql
02-jpapdpgroup_properties.upgrade.sql 02-toscadatatypes_toscadatatype.upgrade.sql
02-jpapdpstatistics_enginestats.upgrade.sql 02-toscanodetemplates_toscanodetemplate.upgrade.sql
02-jpapdpsubgroup_policies.upgrade.sql 02-toscanodetypes_toscanodetype.upgrade.sql
02-jpapdpsubgroup_properties.upgrade.sql 02-toscapolicies_toscapolicy.upgrade.sql
02-jpapdpsubgroup_supportedpolicytypes.upgrade.sql 02-toscapolicytypes_toscapolicytype.upgrade.sql
02-jpapolicyaudit.upgrade.sql 02-toscarelationshiptypes_toscarelationshiptype.upgrade.sql
02-jpatoscacapabilityassignment_attributes.upgrade.sql 02-toscarequirements_toscarequirement.upgrade.sql
02-jpatoscacapabilityassignment_metadata.upgrade.sql


ls downgrade/
01-controlloop.downgrade.sql 02-jpatoscacapabilityassignment_occurrences.downgrade.sql
01-pdp.downgrade.sql 02-jpatoscacapabilityassignment_properties.downgrade.sql
01-pdpgroup.downgrade.sql 02-jpatoscacapabilitytype_metadata.downgrade.sql
01-pdppolicystatus.downgrade.sql 02-jpatoscacapabilitytype_properties.downgrade.sql
01-pdpstatistics.downgrade.sql 02-jpatoscadatatype_constraints.downgrade.sql
01-pdpsubgroup.downgrade.sql 02-jpatoscadatatype_metadata.downgrade.sql
01-sequence.downgrade.sql 02-jpatoscadatatype_properties.downgrade.sql
01-toscacapabilityassignment.downgrade.sql 02-jpatoscanodetemplate_metadata.downgrade.sql
01-toscacapabilityassignments.downgrade.sql 02-jpatoscanodetemplate_properties.downgrade.sql
01-toscacapabilitytype.downgrade.sql 02-jpatoscanodetype_metadata.downgrade.sql
01-toscacapabilitytypes.downgrade.sql 02-jpatoscanodetype_properties.downgrade.sql
01-toscadatatype.downgrade.sql 02-jpatoscapolicy_metadata.downgrade.sql
01-toscadatatypes.downgrade.sql 02-jpatoscapolicy_properties.downgrade.sql
01-toscanodetemplate.downgrade.sql 02-jpatoscapolicy_targets.downgrade.sql
01-toscanodetemplates.downgrade.sql 02-jpatoscapolicytype_metadata.downgrade.sql
01-toscanodetype.downgrade.sql 02-jpatoscapolicytype_properties.downgrade.sql
01-toscanodetypes.downgrade.sql 02-jpatoscapolicytype_targets.downgrade.sql
01-toscaparameter.downgrade.sql 02-jpatoscapolicytype_triggers.downgrade.sql
01-toscapolicies.downgrade.sql 02-jpatoscaproperty_constraints.downgrade.sql
01-toscapolicy.downgrade.sql 02-jpatoscaproperty_metadata.downgrade.sql
01-toscapolicytype.downgrade.sql 02-jpatoscarelationshiptype_metadata.downgrade.sql
01-toscapolicytypes.downgrade.sql 02-jpatoscarelationshiptype_properties.downgrade.sql
01-toscaproperty.downgrade.sql 02-jpatoscarequirement_metadata.downgrade.sql
01-toscarelationshiptype.downgrade.sql 02-jpatoscarequirement_occurrences.downgrade.sql
01-toscarelationshiptypes.downgrade.sql 02-jpatoscarequirement_properties.downgrade.sql
01-toscarequirement.downgrade.sql 02-jpatoscaservicetemplate_metadata.downgrade.sql
01-toscarequirements.downgrade.sql 02-jpatoscatopologytemplate_inputs.downgrade.sql
01-toscaservicetemplate.downgrade.sql 02-participant.downgrade.sql
01-toscatopologytemplate.downgrade.sql 02-participantstatistics.downgrade.sql
01-toscatrigger.downgrade.sql 02-pdpgroup_pdpsubgroup.downgrade.sql
02-clelementstatistics.downgrade.sql 02-pdpsubgroup_pdp.downgrade.sql
02-controlloop_controlloopelement.downgrade.sql 02-toscacapabilityassignments_toscacapabilityassignment.downgrade.sql
02-controlloopelement.downgrade.sql 02-toscacapabilitytypes_toscacapabilitytype.downgrade.sql
02-jpapdpgroup_properties.downgrade.sql 02-toscadatatypes_toscadatatype.downgrade.sql
02-jpapdpstatistics_enginestats.downgrade.sql 02-toscanodetemplates_toscanodetemplate.downgrade.sql
02-jpapdpsubgroup_policies.downgrade.sql 02-toscanodetypes_toscanodetype.downgrade.sql
02-jpapdpsubgroup_properties.downgrade.sql 02-toscapolicies_toscapolicy.downgrade.sql
02-jpapdpsubgroup_supportedpolicytypes.downgrade.sql 02-toscapolicytypes_toscapolicytype.downgrade.sql
02-jpapolicyaudit.downgrade.sql 02-toscarelationshiptypes_toscarelationshiptype.downgrade.sql
02-jpatoscacapabilityassignment_attributes.downgrade.sql 02-toscarequirements_toscarequirement.downgrade.sql
02-jpatoscacapabilityassignment_metadata.downgrade.sql


01-honolulu.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-controlloop.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-pdp.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-pdpgroup.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-pdppolicystatus.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-pdpstatistics.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-pdpsubgroup.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-sequence.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscacapabilityassignment.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscacapabilityassignments.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscacapabilitytype.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscacapabilitytypes.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscadatatype.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscadatatypes.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscanodetemplates.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscanodetypes.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscaparameter.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscapolicies.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscapolicy.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscapolicytype.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscapolicytypes.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscaproperty.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscarelationshiptype.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscarelationshiptypes.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscarequirement.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscarequirements.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscatopologytemplate.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscatrigger.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscanodetemplate.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscanodetype.upgrade.sql
\. /opt/app/policy/etc/db/migration/policyadmin/sql/upgrade/01-toscaservicetemplate.upgrade.sql



Update drools_policy_init.sh


drools_policy_init.sh
#!/bin/sh
# ============LICENSE_START====================================================
#  Copyright (C) 2021 Nordix Foundation.
# =============================================================================
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#      http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
# SPDX-License-Identifier: Apache-2.0
# ============LICENSE_END======================================================

export POLICY_HOME=/opt/app/policy
export SQL_USER=${MYSQL_USER}
export SQL_PASSWORD=${MYSQL_PASSWORD}
mkdir -p /opt/app/policy/etc/db/migration/${SQL_DB}/sql/
cp /home/policy/sql/*upgrade.sql /opt/app/policy/etc/db/migration/${SQL_DB}/sql/
cp -r /home/policy/sql/upgrade /opt/app/policy/etc/db/migration/${SQL_DB}/sql/

/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o report

/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o upgrade

/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o report

rm -rf /opt/app/policy/etc/db/migration/${SQL_DB}/sql/* >/dev/null 2>/dev/null
cp /home/policy/sql/*downgrade.sql /opt/app/policy/etc/db/migration/${SQL_DB}/sql/
cp -r /home/policy/sql/downgrade /opt/app/policy/etc/db/migration/${SQL_DB}/sql/

/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o downgrade -f 2 -t 1

/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o report

nc -lk -p 6824

exit 0


drools-db-migration |
drools-db-migration | policyadmin: OK: upgrade (02)
drools-db-migration | name version
drools-db-migration | policyadmin 02
drools-db-migration | script operation success atTime
drools-db-migration | 01-honolulu.upgrade.sql upgrade 1 2021-06-30 10:48:15
drools-db-migration | 02-istanbul.upgrade.sql upgrade 1 2021-06-30 10:48:15
drools-db-migration | policyadmin: OK @ 02
drools-db-migration | downgrade: 2 -> 1
drools-db-migration |
drools-db-migration | > downgrade 02-istanbul.downgrade.sql
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `clelementstatistics`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `controlloop_controlloopelement`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `controlloopelement`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpapdpgroup_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpapdpstatistics_enginestats`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpapdpsubgroup_policies`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpapdpsubgroup_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpapdpsubgroup_supportedpolicytypes`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpapolicyaudit`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscacapabilityassignment_attributes`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscacapabilityassignment_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscacapabilityassignment_occurrences`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscacapabilityassignment_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscacapabilitytype_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscacapabilitytype_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscadatatype_constraints`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscadatatype_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscadatatype_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscanodetemplate_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscanodetemplate_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscanodetype_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscanodetype_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscapolicy_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscapolicy_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscapolicy_targets`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscapolicytype_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscapolicytype_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscapolicytype_targets`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscapolicytype_triggers`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscaproperty_constraints`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscaproperty_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscarelationshiptype_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscarelationshiptype_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscarequirement_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscarequirement_occurrences`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscarequirement_properties`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscaservicetemplate_metadata`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpatoscatopologytemplate_inputs`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `participant`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `participantstatistics`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `pdpgroup_pdpsubgroup`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `pdpsubgroup_pdp`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `toscacapabilityassignments_toscacapabilityassignment`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `toscacapabilitytypes_toscacapabilitytype`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `toscadatatypes_toscadatatype`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `toscanodetemplates_toscanodetemplate`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `toscanodetypes_toscanodetype`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `toscapolicies_toscapolicy`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `toscapolicytypes_toscapolicytype`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `toscarelationshiptypes_toscarelationshiptype`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `toscarequirements_toscarequirement`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | policyadmin: OK: downgrade (1)
drools-db-migration | name version
drools-db-migration | policyadmin 1
drools-db-migration | script operation success atTime
drools-db-migration | 01-honolulu.upgrade.sql upgrade 1 2021-06-30 10:48:15
drools-db-migration | 02-istanbul.upgrade.sql upgrade 1 2021-06-30 10:48:15
drools-db-migration | 02-istanbul.downgrade.sql downgrade 1 2021-06-30 10:48:16
drools-db-migration | policyadmin: downgrade available: 1 -> 0


MariaDB [(none)]> use migration;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [migration]> select * from policyadmin_history;
+---------------------------+-----------+---------+---------------------+
| script | operation | success | atTime |
+---------------------------+-----------+---------+---------------------+
| 01-honolulu.upgrade.sql | upgrade | 1 | 2021-06-30 10:48:15 |
| 02-istanbul.downgrade.sql | downgrade | 1 | 2021-06-30 10:48:16 |
| 02-istanbul.upgrade.sql | upgrade | 1 | 2021-06-30 10:48:15 |
+---------------------------+-----------+---------+---------------------+
3 rows in set (0.000 sec)

MariaDB [migration]> select * from metadata_versions;
+-------------+---------+
| name | version |
+-------------+---------+
| policyadmin | 1 |
+-------------+---------+
1 row in set (0.001 sec)


https://docs.onap.org/projects/onap-policy-parent/en/guilin/drools/pdpdEngine.html#data-migration