Code Review / policy / docker.git / commit
? search:
summary | shortlog | log | commit | commitdiff | review | tree
(parent: 475cb56) | patch
Remove statistics tables 12/136412/1
authoradheli.tavares <adheli.tavares@est.tech>
Wed, 8 Nov 2023 15:52:05 +0000 (15:52 +0000)
committeradheli.tavares <adheli.tavares@est.tech>
Wed, 8 Nov 2023 16:48:57 +0000 (16:48 +0000)
commit9fb99a6f5fcc90649342350d7beedd8d4d349012
treeb8265753157f9cdbf1a64f7485c2c44b7b5227f2tree | snapshot
parent475cb560f95f37abe84cf3c2c75aa1ff28ee7ba9commit | diff
Remove statistics tables

- added scripts with removal of statistics tables and
indexes for upgrade;
- added scripts with creation of tables and indexes for downgrade;
- fixed the leftover of sequence table when not using it for indexing
primary keys.

Issue-ID: POLICY-4109
Change-Id: Ic643df87a149d3c27eaa846bd4b46db5d61eda22
Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
14 files changed:
policy-db-migrator/smoke-test/mariadb-tests.sh diff | blob | history
policy-db-migrator/src/main/docker/config/policyadmin/postgres/1300/downgrade/0100-statistics_sequence.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/postgres/1300/downgrade/0110-jpapdpstatistics_enginestats.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/postgres/1300/downgrade/0120-pdpstatistics.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/postgres/1300/upgrade/0100-pdpstatistics.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/postgres/1300/upgrade/0110-jpapdpstatistics_enginestats.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/postgres/1300/upgrade/0120-statistics_sequence.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/sql/1200/upgrade/0130-statistics_sequence.sql diff | blob | history
policy-db-migrator/src/main/docker/config/policyadmin/sql/1300/downgrade/0100-pdpstatistics.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/sql/1300/downgrade/0110-jpapdpstatistics_enginestats.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/sql/1300/downgrade/0120-statistics_sequence.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/sql/1300/upgrade/0100-pdpstatistics.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/sql/1300/upgrade/0110-jpapdpstatistics_enginestats.sql [new file with mode: 0644] blob
policy-db-migrator/src/main/docker/config/policyadmin/sql/1300/upgrade/0120-statistics_sequence.sql [new file with mode: 0644] blob
Policy docker image