summaryrefslogtreecommitdiffstats
path: root/packages/base/src/files/install/mysql/data
diff options
context:
space:
mode:
authorrb7147 <rb7147@att.com>2017-06-20 19:14:14 -0400
committerrb7147 <rb7147@att.com>2017-06-20 19:17:06 -0400
commit4fe8e3866576d86c36157466e349edd45af6db39 (patch)
tree46897bc80535f1a07860cc4af6de2196b666f86b /packages/base/src/files/install/mysql/data
parent620d69f26cbbea1deb5000c7a341e8012a5ad080 (diff)
[Policy-24,Policy-27] Resolved PushPolicy Issue
Autowired the Hibernate Session Factory. Removed the Wait timeout and interactive timeout variables from sql script. Updated the fwTagpicker sql error. Change-Id: I567e845f7ba3153241178687310cb734095e8771 Signed-off-by: rb7147 <rb7147@att.com>
Diffstat (limited to 'packages/base/src/files/install/mysql/data')
-rw-r--r--packages/base/src/files/install/mysql/data/170701_upgrade_script.sql2
1 files changed, 1 insertions, 1 deletions
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,