X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=packages%2Fbase%2Fsrc%2Ffiles%2Finstall%2Fmysql%2Fdata%2F170701_upgrade_script.sql;fp=packages%2Fbase%2Fsrc%2Ffiles%2Finstall%2Fmysql%2Fdata%2F170701_upgrade_script.sql;h=9091d9fa1edb831be4e3431eacf2aacb686ebfdf;hb=4fe8e3866576d86c36157466e349edd45af6db39;hp=45b4361fe992b88db0edfd0dd2b80e48bf6ced3e;hpb=620d69f26cbbea1deb5000c7a341e8012a5ad080;p=policy%2Fengine.git

diff --git a/packages/base/src/files/install/mysql/data/170701_upgrade_script.sql b/packages/base/src/files/install/mysql/data/170701_upgrade_script.sql
index 45b4361fe..9091d9fa1 100644
--- a/packages/base/src/files/install/mysql/data/170701_upgrade_script.sql
+++ b/packages/base/src/files/install/mysql/data/170701_upgrade_script.sql
@@ -18,7 +18,6 @@
 * ============LICENSE_END=========================================================
 */
 use ecomp_sdk;
-ALTER TABLE fwtagpicker add networkRole varchar(64);
 
 INSERT INTO policyeditorscopes (`id`, `scopename`, `created_date`, `created_by`, `modified_date`, `modified_by`) VALUES ('1', 'com', '2017-06-01 11:45:36', 'demo', '2017-06-01 11:45:36', 'demo');
 
@@ -47,6 +46,7 @@ ID INT NOT NULL AUTO_INCREMENT,
 tagPickerName VARCHAR(45) NOT NULL,
 DESCRIPTION VARCHAR(1024),
 tags VARCHAR(1024) NOT NULL,
+networkRole varchar(64),
 CREATED_DATE TIMESTAMP NOT NULL default current_timestamp,
 CREATED_BY VARCHAR(45) NOT NULL,
 MODIFIED_DATE TIMESTAMP NOT NULL,