X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=packages%2Fbase%2Fsrc%2Ffiles%2Finstall%2Fmysql%2Fdata%2F170701_downgrade_script.sql;h=d81fa1535df0794e2215a7abe4166333ae93991f;hb=a084c4de015521f842a3fef0d7f1f7c340237bc3;hp=657abadcc5a7fcad3b7e1b0188970b00bf1b0653;hpb=685ed1545ed28b777a3ba6e7d315b78f355154cb;p=policy%2Fengine.git

diff --git a/packages/base/src/files/install/mysql/data/170701_downgrade_script.sql b/packages/base/src/files/install/mysql/data/170701_downgrade_script.sql
index 657abadcc..d81fa1535 100644
--- a/packages/base/src/files/install/mysql/data/170701_downgrade_script.sql
+++ b/packages/base/src/files/install/mysql/data/170701_downgrade_script.sql
@@ -18,4 +18,10 @@
 * ============LICENSE_END=========================================================
 */
 use ecomp_sdk;
-ALTER TABLE fwtagpicker drop networkRole;
\ No newline at end of file
+ALTER TABLE fwtagpicker drop networkRole;
+alter table microservicemodels drop column enumValues, drop column annotation; 
+drop table if exists FWTag; 
+drop table if exists FWTagPicker; 
+drop table if exists brmsdependency;
+drop table if exists brmscontroller;
+drop table if exists microserviceattribute; 
\ No newline at end of file