[Policy-24,Policy-27] Resolved PushPolicy Issue

[policy/engine.git] / packages / base / src / files / install / mysql / data / 170701_upgrade_script.sql

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 45b4361..9091d9f 100644 (file)
--- 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,