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
#!/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