From 6cdd38eb3dd17ef7f448352a895d8c0856ad583d Mon Sep 17 00:00:00 2001 From: Dan Timoney Date: Tue, 17 Oct 2017 14:13:01 -0400 Subject: Fix table schema Table schema incorrectly changed, breaking admportal Change-Id: I41636888c6796cc6df067f1f18d83c7ce7f525e4 Issue-ID: SDNC-133 Signed-off-by: Dan Timoney Former-commit-id: 6571979096ef15b8b8b1cbebde5e22be3f8aec97 --- installation/sdnc/src/main/resources/sdnctl.dump | 16 +++++----------- 1 file changed, 5 insertions(+), 11 deletions(-) (limited to 'installation') diff --git a/installation/sdnc/src/main/resources/sdnctl.dump b/installation/sdnc/src/main/resources/sdnctl.dump index 4f9dc413..1ac22d28 100644 --- a/installation/sdnc/src/main/resources/sdnctl.dump +++ b/installation/sdnc/src/main/resources/sdnctl.dump @@ -92,7 +92,7 @@ CREATE TABLE `AIC_AVAIL_ZONE_POOL` ( `aic_site_id` varchar(100) NOT NULL, `status` varchar(40) NOT NULL, `availability_zone` varchar(100) NOT NULL, - `token` int(4) NOT NULL, + `token` varchar(5) NOT NULL, `vnf_id` varchar(80) DEFAULT NULL, `service_type` varchar(100) NOT NULL, `vnf_type` varchar(20) DEFAULT NULL, @@ -111,7 +111,6 @@ DROP TABLE IF EXISTS `AIC_HOSTNAME`; CREATE TABLE `AIC_HOSTNAME` ( `hostname` varchar(20) NOT NULL, `cust_id` int(11) NOT NULL, - `aic_site_id` varchar(100) DEFAULT NULL, `vendor_code` varchar(1) NOT NULL, `virtual_device_type` varchar(2) DEFAULT NULL, `device_sequence` varchar(3) NOT NULL, @@ -1770,13 +1769,10 @@ DROP TABLE IF EXISTS `PORTAL_USERS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PORTAL_USERS` ( - `attuid` varchar(6) NOT NULL, - `firstName` varchar(25) DEFAULT NULL, - `lastName` varchar(25) DEFAULT NULL, - `role` varchar(25) DEFAULT NULL, + `email` varchar(64) NOT NULL, + `password` varbinary(255) NOT NULL, `privilege` char(1) NOT NULL, - `last_login` timestamp NULL DEFAULT NULL, - PRIMARY KEY (`attuid`) + PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1816,7 +1812,6 @@ CREATE TABLE `PRE_LOAD_VNF_DATA` ( `svc_action` varchar(40) DEFAULT '', `status` varchar(10) NOT NULL DEFAULT 'pending', `filename` varchar(100) NOT NULL, - `attuid` varchar(8) NOT NULL, `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `preload_data` longblob, PRIMARY KEY (`id`) @@ -1836,7 +1831,6 @@ CREATE TABLE `PRE_LOAD_VNF_NETWORK_DATA` ( `svc_action` varchar(40) DEFAULT '', `status` varchar(10) NOT NULL DEFAULT 'pending', `filename` varchar(100) NOT NULL, - `attuid` varchar(8) NOT NULL, `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `preload_data` longblob, PRIMARY KEY (`id`) @@ -1861,7 +1855,7 @@ CREATE TABLE `PSERVER` ( `equip_model` varchar(255) DEFAULT '', `fqdn` varchar(255) DEFAULT '', `pserver_selflink` varchar(255) DEFAULT '', - `ipv4_oam_address` varchar(15) DEFAULT '', + `ipv4_oam_address` varchar(40) DEFAULT NULL, `serial_number` varchar(255) DEFAULT '', `pserver_id` varchar(255) DEFAULT '', `internet_topology` varchar(40) DEFAULT '', -- cgit 1.2.3-korg