-- -- ============LICENSE_START========================================== -- ONAP Portal -- =================================================================== -- Copyright (C) 2019 AT&T Intellectual Property. All rights reserved. -- =================================================================== -- Modifications Copyright (c) 2019 Samsung -- =================================================================== -- -- Unless otherwise specified, all software contained herein is licensed -- under the Apache License, Version 2.0 (the "License"); -- you may not use this software except in compliance with the License. -- You may obtain a copy of the License at -- -- http://www.apache.org/licenses/LICENSE-2.0 -- -- Unless required by applicable law or agreed to in writing, software -- distributed under the License is distributed on an "AS IS" BASIS, -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -- See the License for the specific language governing permissions and -- limitations under the License. -- -- Unless otherwise specified, all documentation contained herein is licensed -- under the Creative Commons License, Attribution 4.0 Intl. (the "License"); -- you may not use this documentation except in compliance with the License. -- You may obtain a copy of the License at -- -- https://creativecommons.org/licenses/by/4.0/ -- -- Unless required by applicable law or agreed to in writing, documentation -- distributed under the License is distributed on an "AS IS" BASIS, -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -- See the License for the specific language governing permissions and -- limitations under the License. -- -- ============LICENSE_END============================================ -- -- -- MySQL dump 10.17 Distrib 10.3.14-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: portal -- ------------------------------------------------------ -- Server version 10.3.14-MariaDB-1:10.3.14+maria~bionic INSERT INTO `cr_report` (`rep_id`, `title`, `descr`, `public_yn`, `report_xml`, `create_id`, `create_date`, `maint_id`, `maint_date`, `menu_id`, `menu_approved_yn`, `owner_id`, `folder_id`, `dashboard_type_yn`, `dashboard_yn`) VALUES (15,'Application Usage Report Wid','',1,'\n\n Application Usage Report Wid\n \n local\n mysql\n BarChart3D\n 700\n 500\n false\n false\n false\n 27\n 2017-01-28-05:00\n SELECT \n l.date audit_date, \n app_id app_id, \n IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name) app_name, \n IFNULL(r.ct,0) ct \nfrom\n(\n select a.Date, app_id, app_name\n from (\n select curdate() - INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY as Date\n from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as a\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as b\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as c\n ) a, \n (\n SELECT \n app_id, app_name\n from\n (\n select @rn := @rn+1 AS rowId, app_id, app_name from \n (\n select app_id, app_name, ct from \n (\n select affected_record_id, count(*) ct\n from fn_audit_log l\n where audit_date > date_add( curdate(), interval -6 day)\n and affected_record_id not in ( 1, -1)\n and activity_cd in (\'tab_access\', \'app_access\')\n and user_id = [USER_ID]\n group by affected_record_id\n ) a, fn_app f\n where a.affected_record_id = f.app_id\n order by ct desc \n ) b,\n (SELECT @rn := 0) t2\n ) mm where rowId <= 4\n )b\n where a.Date between date_add( curdate(), interval -6 day) and curdate()\n) l left outer join\n(\n select app_name, DATE(audit_date) audit_date_1 ,count(*) ct from fn_audit_log a, fn_app b\n where user_id = [USER_ID]\n and audit_date > date_add( curdate(), interval -6 day)\n and activity_cd in (\'tab_access\', \'app_access\')\n and a.affected_record_id = b.app_id\n and b.app_id <> 1\n and b.app_id in \n (\n SELECT \n app_id\n from\n (\n select @rn := @rn+1 AS rowId, app_id from \n (\n select app_id, ct from \n (\n select affected_record_id app_id, count(*) ct\n from fn_audit_log \n where audit_date > date_add( curdate(), interval -6 day)\n and affected_record_id not in ( 1, -1)\n and activity_cd in (\'tab_access\', \'app_access\')\n and user_id = [USER_ID]\n group by affected_record_id\n ) a\n order by ct desc \n ) b,\n (SELECT @rn := 0) t2\n ) mm \n )\n group by app_name, DATE(audit_date)\n) r\non l.Date = r.audit_date_1\nand l.app_name = r.app_name\n \n \n \n 0\n Your Search didn\'t yield any results.\n left\n \n 1\n NNNNNNN\n 100\n 100\n N\n N\n N\n N\n N|\n \n \n DUAL\n \n DUAL\n \n \n du0\n l.date\n l.date\n audit_date_1\n 10\n nullpxpx\n Left\n 1\n true\n true\n VARCHAR2\n false\n LEGEND\n 1\n \n \n false\n VARCHAR2\n \n \n \n \n du0\n app_id\n app_id\n app_id\n 10\n Left\n 2\n true\n true\n VARCHAR2\n false\n VARCHAR2\n \n \n du0\n IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name)\n IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name)\n app_name\n 10\n nullpxpx\n Left\n 3\n true\n true\n VARCHAR2\n false\n 2\n \n \n true\n VARCHAR2\n \n \n \n \n du0\n IFNULL(r.ct,0)\n IFNULL(r.ct,0)\n ct\n 10\n nullpxpx\n Left\n 4\n true\n true\n VARCHAR2\n false\n 0\n 1\n \n \n false\n VARCHAR2\n \n \n \n \n \n \n false\n false\n 500\n \n vertical\n N\n bottom\n up90\n \n \n true\n true\n true\n false\n false\n false\n true\n false\n 30\n 50\n 60\n 100\n \n NULL\n N\n N\n N\n N\n N\n N\n\n',1,'2019-08-08 08:43:27',1,'2019-08-08 08:43:27','',0,1,NULL,0,0),(18,'Application Usage bar Wid','',1,'\n\n Application Usage Line Wid\n \n local\n mysql\n TimeSeriesChart\n N\n 700\n 300\n false\n false\n false\n 27\n 2017-01-28-05:00\n SELECT \n l.date audit_date, \n IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name) app_name, \n IFNULL(r.ct,0) ct \nfrom\n(\n select a.Date, app_id, app_name\n from (\n select curdate() - INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY as Date\n from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as a\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as b\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as c\n ) a, \n (\n SELECT \n app_id, app_name\n from\n (\n select @rn := @rn+1 AS rowId, app_id, app_name from \n (\n select app_id, app_name, ct from \n (\n select affected_record_id, count(*) ct\n from fn_audit_log l\n where audit_date > date_add( curdate(), interval -30 day)\n and affected_record_id not in ( 1, -1)\n and activity_cd in (\'tab_access\', \'app_access\')\n and user_id = [USER_ID]\n group by affected_record_id\n ) a, fn_app f\n where a.affected_record_id = f.app_id\n order by ct desc \n ) b,\n (SELECT @rn := 0) t2\n ) mm where rowId <= 4\n )b\n where a.Date between date_add( curdate(), interval -30 day) and curdate()\n) l left outer join\n(\n select app_name, DATE(audit_date) audit_date_1 ,count(*) ct from fn_audit_log a, fn_app b\n where user_id = [USER_ID]\n and audit_date > date_add( curdate(), interval -30 day)\n and activity_cd in (\'tab_access\', \'app_access\')\n and a.affected_record_id = b.app_id\n and b.app_id <> 1\n and b.app_id in \n (\n SELECT \n app_id\n from\n (\n select @rn := @rn+1 AS rowId, app_id from \n (\n select app_id, ct from \n (\n select affected_record_id app_id, count(*) ct\n from fn_audit_log \n where audit_date > date_add( curdate(), interval -30 day)\n and affected_record_id not in ( 1, -1)\n and activity_cd in (\'tab_access\', \'app_access\')\n and user_id = [USER_ID]\n group by affected_record_id\n ) a\n order by ct desc \n ) b,\n (SELECT @rn := 0) t2\n ) mm \n )\n group by app_name, DATE(audit_date)\n) r\non l.Date = r.audit_date_1\nand l.app_name = r.app_name\n \n \n \n 0\n Your Search didn\'t yield any results.\n left\n \n 1\n NNNNNNN\n 100\n 100\n N\n N\n N\n N\n N|\n \n \n DUAL\n \n DUAL\n \n \n du0\n l.date\n l.date\n audit_date_1\n 10\n nullpxpx\n Left\n 1\n true\n true\n VARCHAR2\n false\n LEGEND\n 1\n false\n false\n false\n VARCHAR2\n false\n \n \n du0\n IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name)\n IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name)\n app_name\n 10\n nullpxpx\n Left\n 2\n true\n true\n VARCHAR2\n false\n 0\n 2\n \n \n true\n false\n false\n VARCHAR2\n \n \n false\n \n \n du0\n IFNULL(r.ct,0)\n IFNULL(r.ct,0)\n ct\n 10\n nullpxpx\n Left\n 3\n true\n true\n VARCHAR2\n false\n 0\n 1\n \n \n false\n false\n false\n VARCHAR2\n \n \n false\n \n \n \n \n false\n false\n 500\n \n vertical\n N\n bottom\n down45\n true\n true\n true\n false\n false\n false\n true\n line\n false\n false\n false\n 30\n 50\n 60\n 100\n \n NULL\n false\n N\n N\n N\n N\n N\n N\n\n',1,'2019-08-08 08:43:27',1,'2019-08-08 08:43:27','',0,1,NULL,0,0),(20,'Average time spend on portal','',1,'\n\n Average time spend on portal\n \n local\n mysql\n TimeSeriesChart\n N\n 700\n 300\n false\n true\n false\n 27\n 2017-01-28-05:00\n SELECT \n d.dat audit_date, \n \'# of Minutes\' app, \n coalesce(diff, null, 0) mins \nfrom\n(\n select * from\n (\n select curdate() - INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY as dat\n from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as a\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as b\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as c \n ) d where d.dat between date_add( curdate(), interval -30 day) and curdate()\n) d left outer join\n(\n select dat, mi, mx, TIMESTAMPDIFF(MINUTE, coalesce(mi, null, 0), coalesce(mx, null, 0)) + 30 diff\n from\n (\n select DATE(audit_date) dat, coalesce(min(audit_date), null, 0) mi, coalesce(max(audit_date), null, 0) mx\n from fn_audit_log \n where user_id = [USER_ID] and DATE(audit_date) between CURDATE()-300 and CURDATE()\n group by DATE(audit_date)\n ) a\n) a\non a.dat = d.dat\norder by 1\n \n \n \n 0\n Your Search didn\'t yield any results.\n left\n \n 1\n NNNNNNN\n 100\n 100\n N\n N\n N\n N\n N|\n \n \n DUAL\n \n DUAL\n \n \n du0\n d.dat\n d.dat\n audit_date_1\n 10\n nullpxpx\n Left\n 1\n true\n true\n VARCHAR2\n false\n LEGEND\n 1\n false\n false\n false\n VARCHAR2\n false\n \n \n du0\n \'# of Minutes\'\n \'# of Minutes\'\n app\n 10\n nullpxpx\n Left\n 2\n true\n true\n VARCHAR2\n false\n true\n VARCHAR2\n \n \n du0\n coalesce(diff, null, 0)\n coalesce(diff, null, 0)\n mins\n 10\n nullpxpx\n Left\n 3\n true\n true\n VARCHAR2\n false\n 0\n 1\n \n \n false\n VARCHAR2\n \n \n \n \n \n \n false\n false\n 500\n \n vertical\n N\n bottom\n down45\n true\n true\n true\n false\n false\n false\n true\n line\n false\n false\n false\n 30\n 50\n 60\n 100\n \n NULL\n false\n N\n N\n N\n N\n N\n N\n\n',1,'2019-08-08 08:43:27',1,'2019-08-08 08:43:27','',0,1,NULL,0,0); INSERT INTO `fn_app` ( `id`, `app_name`, `app_image_url`, `app_description`, `app_notes`, `app_url`, `app_alternate_url`, `app_rest_endpoint`, `ml_app_name`, `ml_app_admin_id`, `mots_id`, `app_password`, `_open`, `_enabled`, `app_username`, `ueb_key`, `ueb_secret`, `ueb_topic_name`, `app_type`, `auth_central`, `auth_namespace` ) VALUES ( 1, 'Default', 'assets/images/tmp/portal1.png', 'Some Default Description', 'Some Default Note', 'http://localhost', 'http://localhost', 'http://localhost:8080/ecompportal', 'EcompPortal', '', NULL, 'dR2NABMkxPaFbIbym87ZwQ==', 0, 0, 'm00468@portal.onap.org', 'EkrqsjQqZt4ZrPh6', NULL, NULL, 1, 1, 'org.onap.portal' ),( 2, 'xDemo App', 'images/cache/portal-222865671_37476.png', NULL, NULL, 'http://portal-sdk.simpledemo.onap.org:30212/ONAPPORTALSDK/welcome.htm', NULL, 'http://portal-sdk:8080/ONAPPORTALSDK/api/v3', '', '', NULL, '2VxipM8Z3SETg32m3Gp0FvKS6zZ2uCbCw46WDyK6T5E=', 0, 1, 'Default', 'ueb_key', 'ueb_secret', 'ECOMP-PORTAL-OUTBOX', 1, 0, NULL ),( 3, 'DMaaP Bus Ctrl', 'images/cache/portal944583064_80711.png', NULL, NULL, 'http://dmaap-bc.simpledemo.onap.org:/ECOMPDBCAPP/dbc#/dmaap', NULL, 'http://dmaap-bc:8989/ECOMPDBCAPP/api/v2', '', '', NULL, 'okYTaDrhzibcbGVq5mjkVQ==', 0, 0, 'Default', 'ueb_key', 'ueb_secret', 'ECOMP-PORTAL-OUTBOX', 1, 0, NULL ),( 4, 'SDC', 'images/cache/portal956868231_53879.png', NULL, NULL, 'http://sdc.api.fe.simpledemo.onap.org:30206/sdc1/portal', NULL, 'http://sdc-be:8080/api/v3', '', '', NULL, 'j85yNhyIs7zKYbR1VlwEfNhS6b7Om4l0Gx5O8931sCI=', 0, 1, 'sdc', 'ueb_key', 'ueb_secret', 'ECOMP-PORTAL-OUTBOX', 1, 1, 'org.onap.sdc' ),( 5, 'Policy', 'images/cache/portal1470452815_67021.png', NULL, NULL, 'https://policy.api.simpledemo.onap.org:30219/onap/policy', NULL, 'https://pap:8443/onap/api/v3', '', '', NULL, '2VxipM8Z3SETg32m3Gp0FvKS6zZ2uCbCw46WDyK6T5E=', 0, 1, 'Default', 'ueb_key_5', 'ueb_secret', 'ECOMP-PORTAL-OUTBOX', 1, 1, 'org.onap.policy' ),( 6, 'Virtual Infrastructure Deployment', 'images/cache/portal-345993588_92550.png', NULL, NULL, 'https://vid.api.simpledemo.onap.org:30200/vid/welcome.htm', NULL, 'https://vid:8443/vid/api/v3', '', '', NULL, '2VxipM8Z3SETg32m3Gp0FvKS6zZ2uCbCw46WDyK6T5E=', 0, 1, 'Default', '2Re7Pvdkgw5aeAUD', 'S31PrbOzGgL4hg4owgtx47Da', 'ECOMP-PORTAL-OUTBOX-90', 1, 1, 'org.onap.vid' ),( 7, 'A&AI UI', 'images/cache/portal-345993588_92550.png', NULL, NULL, 'https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html#/viewInspect', NULL, 'https://aai-sparky-be.onap:8000/api/v2', '', '', NULL, '4LK69amiIFtuzcl6Gsv97Tt7MLhzo03aoOx7dTvdjKQ=', 0, 1, 'aaiui', 'ueb_key_7', 'ueb_secret', 'ECOMP-PORTAL-OUTBOX', 1, 1, 'org.onap.aai' ),( 8, 'CLI', 'images/cache/portal-345993588_92550.png', NULL, NULL, 'http://cli.api.simpledemo.onap.org:30260/', NULL, NULL, '', '', NULL, '', 1, 1, '', '', '', '', 1, 0, NULL ),( 9, 'MSB', 'images/cache/portal-345993588_92550.png', NULL, NULL, 'http://msb.api.simpledemo.onap.org:30280/iui/microservices/default.html', NULL, NULL, '', '', NULL, '', 1, 1, '', '', '', '', 2, 0, NULL ),( 10, 'SO-Monitoring', 'images/cache/portal-345993588_92550.png', NULL, NULL, 'http://so-monitoring:30224', NULL, 'http://so-monitoring:30224', '', '', NULL, 'password', 1, 1, 'user', '', '', '', 1, 0, 'SO-Monitoring' ), (11,'LF Acumos Marketplace','images/cache/portal_907838932_26954.png',NULL,NULL,'https://marketplace.acumos.org/#/home', NULL,NULL,'','',NULL,'',1,1,'','','','',2,0,NULL); -- -- Dumping data for table `ep_app_function` -- INSERT INTO `ep_app_function` (`id`,`app_id`, `function_cd`, `function_name`) VALUES (12, 1,'menu|menu_acc_admin|*','Admin Account Menu'), (13, 1,'menu|menu_admin|*','Admin Menu'), (14, 1,'menu|menu_home|*','Home Menu'), (15, 1,'menu|menu_logout|*','Logout Menu'), (16, 1,'menu|menu_web_analytics|*','Web Analytics'), (17, 1,'url|addWebAnalyticsReport|*','Add Web Analytics Report'), (18, 1,'url|appsFullList|*','Apps Full List'), (19, 1,'url|centralizedApps|*','Centralized Apps'), (20, 1,'url|edit_notification|*','User Notification'), (21, 1,'url|functionalMenu|*','Functional Menu'), (22, 1,'url|getAdminNotifications|*','Admin Notifications'), (23, 1,'url|getAllWebAnalytics|*','Get All Web Analytics'), (24, 1,'url|getFunctionalMenuRole|*','Get Functional Menu Role'), (25, 1,'url|getNotificationAppRoles|*','Get Notification App Roles'), (26, 1,'url|getUserAppsWebAnalytics|*','Get User Apps Web Analytics'), (27, 1,'url|getUserJourneyAnalyticsReport|*','Get User Journey Report'), (28, 1,'url|get_roles%2f%2a|*','getRolesOfApp'), (29, 1,'url|get_role_functions%2f%2a|*','Get Role Functions'), (30, 1,'url|login|*','Login'), (31, 1,'url|notification_code|*','Notification Code'), (32, 1,'url|role_function_list%2fsaveRoleFunction%2f%2a|*','Save Role Function'), (33, 1,'url|saveNotification|*','publish notifications'), (34, 1,'url|syncRoles|*','SyncRoles'), (35, 1,'url|url_role.htm|*','role page'), (36, 1,'url|url_welcome.htm|*','welcome page'), (37, 1,'url|userAppRoles|*','userAppRoles'), (38, 1,'url|userApps|*','User Apps'); -- -- Dumping data for table `fn_role` -- INSERT INTO `fn_role` (`id`, `role_name`, `active_yn`, `priority`, `app_id`, `app_role_id`) VALUES (1,'System_Administrator',1,1,NULL,NULL), (16,'Standard_User',1,5,NULL,NULL), (900,'Restricted_App_Role',1,1,NULL,NULL), (950,'Portal_Notification_Admin',1,1,NULL,NULL), (999,'Account_Administrator',1,1,NULL,NULL), (1000,'System_Administrator',1,1,2,1), (1001,'Standard_User',1,1,2,16), (1002,'System_Administrator',1,1,3,1), (1003,'Standard_User',1,1,3,16), (1004,'ADMIN',1,1,4,0), (1005,'TESTOR',1,1,4,1), (1006,'System_Administrator',1,1,5,1), (1007,'Standard_User',1,1,5,16), (1008,'System_Administrator',1,1,6,1), (1009,'Standard_User',1,1,6,16), (1010,'Usage_Analyst',1,1,NULL,NULL), (1011,'View',1,1,7,1), (1012,'Standard_User',1,1,7,16), (2115,'Portal_Usage_Analyst',1,6,NULL,NULL); -- -- Dumping data for table `ep_app_role_function` -- INSERT INTO `ep_app_role_function` (`id`, `app_id`, `role_id`, `function_cd`, `role_app_id`) VALUES (1,1,1,'url|login|*',NULL), (2,1,1,'menu|menu_admin|*',NULL), (3,1,1,'menu|menu_home|*',NULL), (4,1,1,'menu|menu_logout|*',NULL), (5,1,16,'url|login|*',NULL), (6,1,16,'menu|menu_home|*',NULL), (7,1,16,'menu|menu_logout|*',NULL), (8,1,950,'url|edit_notification|*',NULL), (9,1,950,'url|getAdminNotifications|*',NULL), (10,1,950,'url|saveNotification|*',NULL), (11,1,999,'url|userAppRoles|*',NULL), (12,1,999,'url|getAdminNotifications|*',NULL), (13,1,999,'url|userApps|*',NULL), (14,1,1010,'menu|menu_web_analytics|*',NULL), (15,1,2115,'menu|menu_web_analytics|*',NULL), (16,1,1,'menu|menu_acc_admin|*',NULL), (17,1,999,'menu|menu_acc_admin|*',NULL), (18,1,999,'url|centralizedApps|*',NULL), (19,1,999,'url|getAllWebAnalytics|*',NULL), (20,1,999,'url|getFunctionalMenuRole|*',NULL), (21,1,999,'url|getNotificationAppRoles|*',NULL), (22,1,999,'url|getUserAppsWebAnalytics|*',NULL), (23,1,999,'url|getUserJourneyAnalyticsReport|*',NULL), (24,1,999,'url|get_roles%2f%2a|*',NULL), (25,1,999,'url|get_role_functions%2f%2a|*',NULL), (26,1,999,'url|notification_code|*',NULL), (27,1,999,'url|role_function_list%2fsaveRoleFunction%2f%2a|*',NULL), (28,1,999,'url|syncRoles|*',NULL); -- -- Dumping data for table `ep_basic_auth_account` -- INSERT INTO `ep_basic_auth_account` (`id`, `ext_app_name`, `username`, `password`, `active_yn`) VALUES (1,'JIRA','jira','6APqvG4AU2rfLgCvMdySwQ==',1); -- -- Dumping data for table `ep_microservice` -- INSERT INTO `ep_microservice` (`id`, `name`, `description`, `app_Id`, `endpoint_url`, `security_type`, `username`, `password`, `active`) VALUES (1,'News Microservice','News',1,'http://portal-app:8989/ONAPPORTAL/commonWidgets','Basic Authentication','portal','6APqvG4AU2rfLgCvMdySwQ==',1), (2,'Events Microservice','Events',1,'http://portal-app:8989/ONAPPORTAL/commonWidgets','Basic Authentication','portal','6APqvG4AU2rfLgCvMdySwQ==',1), (3,'Resources Microservice','Resources',1,'http://portal-app:8989/ONAPPORTAL/commonWidgets','Basic Authentication','portal','6APqvG4AU2rfLgCvMdySwQ==',1), (4,'Portal-Common-Scheduler Microservice','Portal-Common-Scheduler',1,'http://portal-app:8989/ONAPPORTAL/commonWidgets','Basic Authentication','portal','6APqvG4AU2rfLgCvMdySwQ==',1); -- -- Dumping data for table `ep_microservice_parameter` -- INSERT INTO `ep_microservice_parameter` (`id`, `service_id`, `para_key`, `para_value`) VALUES (1,1,'resourceType','NEWS'), (2,2,'resourceType','EVENTS'), (3,3,'resourceType','IMPORTANTRESOURCES'), (4,4,'resourceType',NULL); -- -- Dumping data for table `ep_widget_catalog` -- INSERT INTO `ep_widget_catalog` (`wdg_name`, `service_id`, `wdg_desc`, `wdg_file_loc`, `all_user_flag`) VALUES ('News',1,'News','news-widget.zip',1), ('Events',2,'Events','events-widget.zip',1), ('Resources',3,'Resources','resources-widget.zip',1), ('Portal-Common-Scheduler',4,'Portal-Common-Scheduler','portal-common-scheduler-widget.zip',1); -- -- Dumping data for table `ep_widget_catalog_files` -- INSERT INTO `ep_widget_catalog_files` (`file_id`, `widget_id`, `widget_name`, `framework_js`, `controller_js`, `markup_html`, `widget_css`) VALUES (1,1,'News','var Portal1Widget = (function(window, undefined) {\n\n var Portal1Widget = Portal1Widget || {};\nfunction extractHostPortApp(src) {\n\nPortal1Widget.microserviceId = 1;\nPortal1Widget.pathArray = src.split( \'/\' );\n\n Portal1Widget.widgetName = 1;\n Portal1Widget.serviceSeperator = Portal1Widget.pathArray[Portal1Widget.pathArray.length - 4]; \n Portal1Widget.commonUrl = src.substring(0, src.lastIndexOf(\"/\" + Portal1Widget.pathArray[Portal1Widget.pathArray.length - 2])); \n \n Portal1Widget.recipientDivDataAttrib = \'data-\' + Portal1Widget.widgetName; \n Portal1Widget.controllerName = \'Portal1Ctrl\'; \n Portal1Widget.readyCssFlag = \'portal1-css-ready\'; \n Portal1Widget.readyCssFlagExpectedValue = \'#bada55\'; \n Portal1Widget.serviceURL = src.substring(0, src.lastIndexOf(\"/\" + Portal1Widget.serviceSeperator)) + \'/portalApi/microservice/proxy/parameter/\' + 1; \n } \n \n extractHostPortApp(document.getElementsByTagName(\'script\')[0].src);\n \n function loadStylesheet(url) { \n var link = document.createElement(\'link\'); \n link.rel = \'stylesheet\'; \n link.type = \'text/css\'; \n link.href = url; \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(link, entry); \n } \n \n function isCssReady(callback) { \n var testElem = document.createElement(\'span\'); \n testElem.id = Portal1Widget.readyCssFlag; \n testElem.style = \'color: #fff\'; \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(testElem, entry); \n \n (function poll() { \n var node = document.getElementById(\'css-ready\'); \n var value; \n if (window.getComputedStyle) { \n value = document.defaultView.getComputedStyle(testElem, null) \n .getPropertyValue(\'color\'); \n } \n else if (node.currentStyle) { \n value = node.currentStyle.color; \n } \n if (value && value === \'rgb(186, 218, 85)\' || value.toLowerCase() === Portal1Widget.readyCssFlagExpectedValue) { \n callback(); \n } else { \n setTimeout(poll, 500); \n } \n })(); \n } \n \n function injectCss(css) { \n var style = document.createElement(\'style\'); \n style.type = \'text/css\'; \n css = css.replace(/\\}/g, \"}\\n\"); \n \n if (style.styleSheet) { \n style.styleSheet.cssText = css; \n } else { \n style.appendChild(document.createTextNode(css)); \n } \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(style, entry); \n } \n \n function loadScript(url, callback) { \n var script = document.createElement(\'script\'); \n script.src = url; \n \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(script, entry); \n \n script.onload = script.onreadystatechange = function() { \n var rdyState = script.readyState; \n if (!rdyState || /complete|loaded/.test(script.readyState)) { \n callback(); \n script.onload = null; \n script.onreadystatechange = null; \n } \n }; \n } \n \n function loadSupportingFiles(callback) { \n callback(); \n } \n \n function getWidgetParams() { \n \n } \n \n function getWidgetData(widgetUrl, callback) { \n var responseData; \n try{ \n jQuery.ajax({ \n url: widgetUrl, \n method: \"GET\", \n xhrFields: { \n withCredentials: true \n }, \n crossDomain: true, \n success: function (result) { \n if (result.isOk == false){ \n \n }else{ \n callback(result); \n } \n } \n }); \n } \n catch(e){ \n \n } \n \n } \n \n function getMarkupContent(markupLocation, callback){ \n \n try{\n jQuery.ajax({ \n url: markupLocation,\n method: \"GET\", \n xhrFields: { \n withCredentials: true \n }, \n crossDomain: true, \n success: function (result) { \n if (result.isOk == false){ \n \n }else{ \n callback(result); \n } \n } \n }); \n }\n catch(e){\n \n }\n } \n \n function renderWidget(data, location, $controllerProvider) { \n var div = document.createElement(\'div\'); \n getMarkupContent(Portal1Widget.commonUrl + \"/markup/\" + Portal1Widget.widgetName, function(div){\n location.append(div); \n Portal1Widget.widgetData = data;\n app.controllerProvider.register(Portal1Widget.controllerName, Portal1Widget.controller); \n var mController = angular.element(document.getElementById(\"widgets\")); \n mController.scope().activateThis(location); \n });\n \n } \n \n function printAllArtifacts(moduleName, controllerName) { \n var queue = angular.module(moduleName)._invokeQueue; \n for(var i=0;i\n

\n \n

\n
\n
{{event.mon}}/{{event.day}}/{{event.year}}\n
\n
\n
\n
\n
\n
\n \n\n
\n
\n
\n
\n
\n
\n \n \n
\n
\n
\n

\n \n

\n\n','\n.portal-widget-panel-container {\n margin-left:150px;\n width:1500px;\n}\n\n\n.portal-widget-panel-fixed-panel {\n min-height: 300px;\n max-height: 1300px;\n overflow: auto;\n}\n\n.portal-widget-panel-double-middle {\n min-height: 660px;\n max-height: 660px;\n overflow: auto;\n}\n\n.portal-widget-panel-row {\n margin-right: 0px;\n margin-left: 0px;\n width: 2800px;\n}\n\n/*Increases the width of the card/panel */\n.portal-widget-panel-panel-default {\n width:450px\n}\n\n/*Controls the spacing between the cards */\n.portal-widget-panel-col-sm-3 {\n width:20.5%\n}\n\n.portal-widget-panel-top {\n top: 15px;\n left: 15px;\n}\n\n#portal3-css-ready {\ncolor: #bada55 !important;\n}'); -- -- Dumping data for table `fn_app_contact_us` -- INSERT INTO `fn_app_contact_us` (`app_id`, `contact_name`, `contact_email`, `url`, `active_yn`, `description`) VALUES (2,'Portal SDK Team','portal@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'xDemo Application'), (3,'DBC Team','portal@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'DBC.'), (4,'SDC Team','sdc@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'Service Design and Creation (SDC).'), (5,'Policy Team','policy@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'Policy.'), (6,'VID Team','vid@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'Virtual Infrastructure Design.'), (7,'AAI UI Team','aaiui@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'AAI UI Application'), (8,'CLI Team','onap-discuss@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'CLI Application'), (10,'SO Team','so@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'Service Orchestration (SO).'); -- -- Dumping data for table `fn_common_widget_data` -- INSERT INTO `fn_common_widget_data` (`id`, `category`, `href`, `title`, `content`, `event_date`, `sort_order`) VALUES (6,'NEWS','https://www.onap.org/announcement/2017/09/27/open-network-automation-platform-onap-project-continues-rapid-membership-growth','Open Network Automation Platform (ONAP) Project Continues Rapid Membership Growth',NULL,NULL,10), (7,'NEWS','https://www.onap.org/announcement/2017/02/23/the-linux-foundation-announces-the-formation-of-a-new-project-to-help-accelerate-innovation-in-open-networking-automation','The Linux Foundation Announces Merger of Open Source ECOMP and OPEN-O to Form New Open Network Automation Platform (ONAP) Project',NULL,NULL,20), (8,'NEWS','http://about.att.com/story/orange_testing_att_open_source_ecomp_platform.html','Orange Testing AT&Ts Open Source ECOMP Platform for Building Software-Defined Network Capabilities',NULL,NULL,30), (9,'NEWS','http://about.att.com/innovationblog/linux_foundation','Opening up ECOMP: Our Network Operating System for SDN',NULL,NULL,40), (10,'EVENTS','https://onapbeijing2017.sched.com/list/descriptions/','ONAP Beijing Release Developer Forum',NULL,'2017-12-11',1), (11,'EVENTS','https://events.linuxfoundation.org/events/open-networking-summit-north-america-2018','Open Networking Summit',NULL,'2018-03-26',2), (12,'IMPORTANTRESOURCES','http://onap.readthedocs.io/en/latest/guides/onap-developer/developing/index.html','Development Guides',NULL,NULL,1), (13,'IMPORTANTRESOURCES','https://wiki.onap.org/','ONAP Wiki',NULL,NULL,2), (14,'IMPORTANTRESOURCES','http://onap.readthedocs.io/en/latest/guides/onap-developer/developing/index.html#portal-platform','ONAP Portal Documentation',NULL,NULL,3), (15,'IMPORTANTRESOURCES','http://onap.readthedocs.io/en/latest/guides/onap-developer/architecture/index.html#architecture','ONAP Architecture',NULL,NULL,4); -- -- Dumping data for table `fn_display_text` -- INSERT INTO `fn_display_text` (`id`, `language_id`, `text_id`, `text_label`) VALUES (1,1,2,'Home'), (2,1,3,'Application Catalog'), (3,1,4,'Widget Catalog'), (4,1,5,'Admins'), (5,1,6,'Roles'), (6,1,7,'Users'), (7,1,8,'Portal Admins'), (8,1,9,'Application Onboarding'), (9,1,10,'Widget Onboarding'), (10,1,11,'Edit Functional Menu'), (11,1,12,'User Notifications'), (12,1,13,'Microservice Onboarding'), (13,1,15,'App Account Management'), (14,2,2,'ä¸»é¡µ'), (15,2,3,'åº”ç”¨ç›®å½•'), (16,2,4,'éƒ¨ä»¶ç›®å½•'), (17,2,5,'ç®¡ç†å‘˜'), (18,2,6,'è§’è‰²'), (19,2,7,'ç”¨æˆ·'), (20,2,8,'é—¨æˆ·ç®¡ç†å‘˜'), (21,2,9,'åº”ç”¨ç®¡ç†'), (22,2,10,'éƒ¨ä»¶ç®¡ç†'), (23,2,11,'ç¼–è¾‘åŠŸèƒ½èœå•'), (24,2,12,'ç”¨æˆ·é€šçŸ¥'), (25,2,13,'å¾®æœåŠ¡ç®¡ç†'), (26,2,15,'åº”ç”¨è´¦æˆ·ç®¡ç†'); -- -- Dumping data for table `fn_function` -- INSERT INTO `fn_function` (`function_cd`, `function_name`) VALUES ('edit_notification','User Notification'), ('getAdminNotifications','Admin Notifications'), ('login','Login'), ('menu_admin','Admin Menu'), ('menu_ajax','Ajax Menu'), ('menu_customer','Customer Menu'), ('menu_customer_create','Customer Create'), ('menu_feedback','Feedback Menu'), ('menu_help','Help Menu'), ('menu_home','Home Menu'), ('menu_job','Job Menu'), ('menu_job_create','Job Create'), ('menu_job_designer','Process in Designer view'), ('menu_logout','Logout Menu'), ('menu_map','Map Menu'), ('menu_notes','Notes Menu'), ('menu_process','Process List'), ('menu_profile','Profile Menu'), ('menu_profile_create','Profile Create'), ('menu_profile_import','Profile Import'), ('menu_reports','Reports Menu'), ('menu_sample','Sample Pages Menu'), ('menu_tab','Sample Tab Menu'), ('menu_task','Task Menu'), ('menu_task_search','Task Search'), ('menu_web_analytics','Web Analytics'), ('saveNotification','publish notifications'), ('view_reports','View Raptor reports'); -- -- Dumping data for table `fn_language` -- INSERT INTO `fn_language` (`language_name`, `language_alias`) VALUES ('English','EN'), ('ç®€ä½“ä¸æ–‡','CN'); -- -- Dumping data for table `fn_lu_activity` -- INSERT INTO `fn_lu_activity` (`activity_cd`, `activity`) VALUES ('add_child_role','add_child_role'), ('add_role','add_role'), ('add_role_function','add_role_function'), ('add_user_role','add_user_role'), ('apa','Add Portal Admin'), ('app_access','App Access'), ('dpa','Delete Portal Admin'), ('eaaf','External auth add function'), ('eaar','External auth add role'), ('eadf','External auth delete function'), ('eadr','External auth delete role'), ('eauf','External auth update function'), ('eaurf','External auth update role and function'), ('functional_access','Functional Access'), ('guest_login','Guest Login'), ('left_menu_access','Left Menu Access'), ('login','Login'), ('logout','Logout'), ('mobile_login','Mobile Login'), ('mobile_logout','Mobile Logout'), ('remove_child_role','remove_child_role'), ('remove_role','remove_role'), ('remove_role_function','remove_role_function'), ('remove_user_role','remove_user_role'), ('search','Search'), ('tab_access','Tab Access'), ('uaa','Update Account Admin'), ('uu','Update User'); -- -- Dumping data for table `fn_lu_alert_method` -- INSERT INTO `fn_lu_alert_method` (`alert_method_cd`, `alert_method`) VALUES ('EMAIL','Email'), ('FAX','Fax'), ('PAGER','Pager'), ('PHONE','Phone'), ('SMS','SMS'); -- -- Dumping data for table `fn_lu_menu_set` -- INSERT INTO `fn_lu_menu_set` (`menu_set_cd`, `menu_set_name`) VALUES ('APP','Application Menu'); -- -- Dumping data for table `fn_lu_priority` -- INSERT INTO `fn_lu_priority` (`priority_id`, `priority`, `active_yn`, `sort_order`) VALUES (10,'Low',1,10), (20,'Normal',1,20), (30,'High',1,30), (40,'Urgent',1,40), (50,'Fatal',1,50); -- -- Dumping data for table `fn_lu_tab_set` -- INSERT INTO `fn_lu_tab_set` (`tab_set_cd`, `tab_set_name`) VALUES ('APP','Application Tabs'); -- -- Dumping data for table `fn_lu_timezone` -- INSERT INTO `fn_lu_timezone` (`timezone_id`, `timezone_name`, `timezone_value`) VALUES (10,'US/Eastern','US/Eastern'), (20,'US/Central','US/Central'), (30,'US/Mountain','US/Mountain'), (40,'US/Arizona','America/Phoenix'), (50,'US/Pacific','US/Pacific'), (60,'US/Alaska','US/Alaska'), (70,'US/Hawaii','US/Hawaii'); -- -- Dumping data for table `fn_menu` -- INSERT INTO `fn_menu` (`menu_id`, `label`, `parent_id`, `sort_order`, `action`, `function_cd`, `active_yn`, `servlet`, `query_string`, `external_url`, `target`, `menu_set_cd`, `separator_yn`, `image_src`) VALUES (1,'root',NULL,10,NULL,'menu_home',0,NULL,NULL,NULL,NULL,'APP',0,NULL), (2,'Home',1,10,'root.applicationsHome','menu_home',1,NULL,NULL,NULL,NULL,'APP',0,'icon-building-home'), (3,'Application Catalog',1,15,'root.appCatalog','menu_home',1,NULL,NULL,NULL,NULL,'APP',0,'icon-retail-gallery'), (4,'Widget Catalog',1,20,'root.widgetCatalog','menu_home',1,NULL,NULL,NULL,NULL,'APP',0,'icon-retail-gallery'), (5,'Admins',1,40,'root.admins','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-content-star'), (6,'Roles',1,45,'root.roles','menu_acc_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-people-groupcollaboration'), (7,'Users',1,50,'root.users','menu_acc_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-people-groupcollaboration'), (8,'Portal Admins',1,60,'root.portalAdmins','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-controls-settingsconnectedactivity'), (9,'Application Onboarding',1,70,'root.applications','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-content-grid2'), (10,'Widget Onboarding',1,80,'root.widgetOnboarding','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-content-grid2'), (11,'Edit Functional Menu',1,90,'root.functionalMenu','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-misc-pen'), (12,'User Notifications',1,100,'root.userNotifications','edit_notification',1,NULL,NULL,NULL,NULL,'APP',0,'icon-controls-settingsconnectedactivity'), (13,'Microservice Onboarding',1,110,'root.microserviceOnboarding','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-content-grid2'), (15,'App Account Management',1,130,'root.accountOnboarding','menu_admin',1,NULL,NULL,NULL,NULL,'App',0,'icon-content-grid2'); -- -- Dumping data for table `fn_menu_functional` -- INSERT INTO `fn_menu_functional` ( `menu_id`, `column_num`, `text`, `parent_menu_id`, `url`, `active_yn`, `image_src` ) VALUES (175, 1, 'Manage', NULL, '', 1, NULL), (178, 2, 'Support', NULL, '', 1, NULL), (1, 2, 'Design', 175, '', 1, NULL), (2, 8, 'ECOMP Platform Management', 175, '', 0, NULL), (3, 5, 'Technology Insertion', 175, '', 1, NULL), (5, 7, 'Performance Management', 175, '', 0, NULL), (6, 6, 'Technology Management', 175, '', 1, NULL), (7, 4, 'Capacity Planning', 175, '', 0, NULL), (8, 3, 'Operations Planning', 175, '', 1, NULL), (11, 1, 'Product Design', 1, '', 1, NULL), (12, 2, 'Resource/Service Design & Onboarding', 1, '', 1, NULL), (13, 3, 'Orchestration (recipe/Process) Design', 1, '', 0, NULL), (14, 4, 'Service Graph visualizer', 1, '', 0, NULL), (15, 5, 'Distribution', 1, '', 1, NULL), (16, 6, 'Testing', 1, '', 1, NULL), (17, 7, 'Simulation', 1, '', 0, NULL), (18, 8, 'Certification', 1, '', 0, NULL), (19, 9, 'Policy Creation/Management', 1, 'http://policy.api.simpledemo.onap.org:8443/onap/policy', 1, NULL), (20, 10, 'Catalog Browser', 1, '', 1, NULL), (24, 5, 'Create/Manage Policy', 12, 'http://policy.api.simpledemo.onap.org:8443/onap/policy', 1, NULL), (56, 1, 'Policy Engineering', 8, 'http://policy.api.simpledemo.onap.org:8443/onap/policy', 1, NULL), (115, 1, 'Test/Approve a Resource or Service', 16, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/dashboard', 1, NULL), (130, 1, 'Favorites', 175, '', 1, NULL), (139, 2, 'Approve a Service for distribution', 12, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/dashboard', 1,NULL), (142, 3, 'Create a License model', 12, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/onboardVendor', 1, NULL), (145, 1, 'Distribute a Service', 15, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/dashboard', 1, NULL), (181, 1, 'Contact Us', 178, '', 1, NULL), (184, 2, 'Get Access', 178, '', 1, NULL), (301, 1, 'Create a Product', 11, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/dashboard', 1, NULL), (304, 2, 'Create a Vendor Software Product', 11, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/onboardVendor', 1, NULL), (307, 1, 'Manage a Resource/Service', 20, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/catalog', 1, NULL), (310, 2, 'Manage a Product', 20, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/catalog', 1, NULL), (313, 3, 'View a Resource/Service/Product', 20, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/catalog', 1, NULL), (316, 11, 'Administration', 1, '', 1, NULL), (148, 1, 'User Management / Category Management', 316, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/adminDashboard', 1, NULL), (317, 1, 'Message Bus Management', 6, 'http://portal.api.simpledemo.onap.org:8989/ECOMPDBCAPP/dbc#/dmaap', 1, NULL), (318, 1, 'Infrastructure Provisioning', 3, '', 1, NULL), (319, 1, 'Infrastructure VNF Provisioning', 318, 'https://vid.api.simpledemo.onap.org:8443/vid/welcome.htm', 1, NULL); -- -- Dumping data for table `fn_menu_functional_ancestors` -- INSERT INTO `fn_menu_functional_ancestors` (`id`, `menu_id`, `ancestor_menu_id`, `depth`) VALUES (1,175,175,0), (2,178,178,0), (3,11,11,0), (4,12,12,0), (5,13,13,0), (6,14,14,0), (7,15,15,0), (8,16,16,0), (9,17,17,0), (10,18,18,0), (11,19,19,0), (12,20,20,0), (13,316,316,0), (14,318,318,0), (15,317,317,0), (16,56,56,0), (17,301,301,0), (18,304,304,0), (19,24,24,0), (20,139,139,0), (21,142,142,0), (22,145,145,0), (23,115,115,0), (24,307,307,0), (25,310,310,0), (26,313,313,0), (27,1,1,0), (28,2,2,0), (29,3,3,0), (30,5,5,0), (31,6,6,0), (32,7,7,0), (33,8,8,0), (34,130,130,0), (35,181,181,0), (36,184,184,0), (37,148,148,0), (38,319,319,0), (64,11,1,1), (65,12,1,1), (66,13,1,1), (67,14,1,1), (68,15,1,1), (69,16,1,1), (70,17,1,1), (71,18,1,1), (72,19,1,1), (73,20,1,1), (74,316,1,1), (75,318,3,1), (76,317,6,1), (77,56,8,1), (78,301,11,1), (79,304,11,1), (80,24,12,1), (81,139,12,1), (82,142,12,1), (83,145,15,1), (84,115,16,1), (85,307,20,1), (86,310,20,1), (87,313,20,1), (88,1,175,1), (89,2,175,1), (90,3,175,1), (91,5,175,1), (92,6,175,1), (93,7,175,1), (94,8,175,1), (95,130,175,1), (96,181,178,1), (97,184,178,1), (98,148,316,1), (99,319,318,1), (127,301,1,2), (128,304,1,2), (129,24,1,2), (130,139,1,2), (131,142,1,2), (132,145,1,2), (133,115,1,2), (134,307,1,2), (135,310,1,2), (136,313,1,2), (137,148,1,2), (138,319,3,2), (139,11,175,2), (140,12,175,2), (141,13,175,2), (142,14,175,2), (143,15,175,2), (144,16,175,2), (145,17,175,2), (146,18,175,2), (147,19,175,2), (148,20,175,2), (149,316,175,2), (150,318,175,2), (151,317,175,2), (152,56,175,2), (158,301,175,3), (159,304,175,3), (160,24,175,3), (161,139,175,3), (162,142,175,3), (163,145,175,3), (164,115,175,3), (165,307,175,3), (166,310,175,3), (167,313,175,3), (168,148,175,3), (169,319,175,3); -- -- Dumping data for table `fn_menu_functional_roles` -- INSERT INTO `fn_menu_functional_roles` (`id`, `menu_id`, `app_id`, `role_id`) VALUES (1,19,5,1007), (2,19,5,1006), (3,24,5,1007), (4,24,5,1006), (5,56,5,1007), (6,56,5,1006), (8,115,4,1004), (9,115,4,1005), (10,139,4,1004), (11,139,4,1005), (12,142,4,1004), (13,142,4,1005), (14,145,4,1004), (15,145,4,1005), (16,148,4,1004), (17,148,4,1005), (18,301,4,1004), (19,301,4,1005), (20,304,4,1004), (21,304,4,1005), (22,307,4,1004), (23,307,4,1005), (24,310,4,1004), (25,310,4,1005), (26,313,4,1004), (27,313,4,1005), (39,319,6,1009), (40,319,6,1008), (42,317,3,1003), (43,317,3,1002); -- -- Dumping data for table `fn_qz_job_details` -- INSERT INTO `fn_qz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `JOB_CLASS_NAME`, `IS_DURABLE`, `IS_NONCONCURRENT`, `IS_UPDATE_DATA`, `REQUESTS_RECOVERY`, `JOB_DATA`) VALUES ('Scheduler_20190808_one','LogJob','AppGroup',NULL,'org.onap.portalapp.scheduler.LogJob','0','1','1','0','��\0sr\0org.quartz.JobDataMap��迩��\0\0xr\0&org.quartz.utils.StringKeyDirtyFlagMap��](\0Z\0allowsTransientDataxr\0org.quartz.utils.DirtyFlagMap�.�(v\n�\0Z\0dirtyL\0mapt\0Ljava/util/Map;xpsr\0java.util.HashMap��`�\0F\0\nloadFactorI\0 thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0unitst\0bytesx\0'), ('Scheduler_20190808_one','PortalSessionTimeoutFeedJob','AppGroup',NULL,'org.onap.portalapp.service.sessionmgt.TimeoutHandler','0','1','1','0','��\0sr\0org.quartz.JobDataMap��迩��\0\0xr\0&org.quartz.utils.StringKeyDirtyFlagMap��](\0Z\0allowsTransientDataxr\0org.quartz.utils.DirtyFlagMap�.�(v\n�\0Z\0dirtyL\0mapt\0Ljava/util/Map;xp\0sr\0java.util.HashMap��`�\0F\0\nloadFactorI\0 thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0\0x\0'); INSERT INTO `fn_qz_locks` (`SCHED_NAME`, `LOCK_NAME`) VALUES ('Scheduler_20190808_one','STATE_ACCESS'), ('Scheduler_20190808_one','TRIGGER_ACCESS'); -- -- Dumping data for table `fn_qz_scheduler_state` -- INSERT INTO `fn_qz_scheduler_state` (`SCHED_NAME`, `INSTANCE_NAME`, `LAST_CHECKIN_TIME`, `CHECKIN_INTERVAL`) VALUES ('Scheduler_20190808_one','portal-portal-app-76c9f7bfb5-s8rhd1565254283688',1565691615399,20000); -- -- Dumping data for table `fn_qz_triggers` -- INSERT INTO `fn_qz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `NEXT_FIRE_TIME`, `PREV_FIRE_TIME`, `PRIORITY`, `TRIGGER_STATE`, `TRIGGER_TYPE`, `START_TIME`, `END_TIME`, `CALENDAR_NAME`, `MISFIRE_INSTR`, `JOB_DATA`) VALUES ('Scheduler_20190808_one','LogTrigger','AppGroup','LogJob','AppGroup',NULL,1565691660000,1565691600000,0,'WAITING','CRON',1565254275000,0,NULL,0,''), ('Scheduler_20190808_one','PortalSessionTimeoutFeedTrigger','AppGroup','PortalSessionTimeoutFeedJob','AppGroup',NULL,1565691900000,1565691600000,0,'WAITING','CRON',1565254275000,0,NULL,0,''); -- -- Dumping data for table `fn_qz_cron_triggers` -- INSERT INTO `fn_qz_cron_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `CRON_EXPRESSION`, `TIME_ZONE_ID`) VALUES ('Scheduler_20190808_one','LogTrigger','AppGroup','0 * * * * ? *','GMT'), ('Scheduler_20190808_one','PortalSessionTimeoutFeedTrigger','AppGroup','0 0/5 * * * ? *','GMT'); -- -- Dumping data for table `fn_restricted_url` -- INSERT INTO `fn_restricted_url` (`restricted_url`, `function_cd`) VALUES ('async_test.htm','menu_home'), ('attachment.htm','menu_admin'), ('broadcast.htm','menu_admin'), ('chatWindow.htm','menu_home'), ('contact_list.htm','menu_home'), ('customer_dynamic_list.htm','menu_home'), ('event.htm','menu_home'), ('event_list.htm','menu_home'), ('file_upload.htm','menu_admin'), ('gauge.htm','menu_tab'), ('gmap_controller.htm','menu_tab'), ('gmap_frame.htm','menu_tab'), ('jbpm_designer.htm','menu_job_create'), ('jbpm_drools.htm','menu_job_create'), ('job.htm','menu_admin'), ('map.htm','menu_tab'), ('map_download.htm','menu_tab'), ('map_grid_search.htm','menu_tab'), ('mobile_welcome.htm','menu_home'), ('process_job.htm','menu_job_create'), ('profile.htm','menu_profile_create'), ('raptor.htm','menu_reports'), ('raptor.htm','view_reports'), ('raptor2.htm','menu_reports'), ('raptor_blob_extract.htm','menu_reports'), ('raptor_blob_extract.htm','view_reports'), ('raptor_email_attachment.htm','menu_reports'), ('raptor_search.htm','menu_reports'),('report_list.htm','menu_reports'), ('role.htm','menu_admin'), ('role_function.htm','menu_admin'), ('sample_animated_map.htm','menu_tab'), ('sample_map.htm','menu_home'), ('sample_map_2.htm','menu_tab'), ('sample_map_3.htm','menu_tab'), ('tab2_sub1.htm','menu_tab'), ('tab2_sub2_link1.htm','menu_tab'), ('tab2_sub2_link2.htm','menu_tab'), ('tab2_sub3.htm','menu_tab'), ('tab3.htm','menu_tab'), ('tab4.htm','menu_tab'), ('template.jsp','menu_home'), ('test.htm','menu_admin'); -- -- Dumping data for table `fn_role_composite` -- INSERT INTO `fn_role_composite` (`parent_role_id`, `child_role_id`) VALUES (1,16); -- -- Dumping data for table `fn_role_function` -- INSERT INTO `fn_role_function` (`id`, `function_cd`) VALUES (1,'login'), (1,'menu_admin'), (1,'menu_ajax'), (1,'menu_customer'), (1,'menu_customer_create'), (1,'menu_feedback'), (1,'menu_help'), (1,'menu_home'), (1,'menu_job'), (1,'menu_job_create'), (1,'menu_logout'), (1,'menu_notes'), (1,'menu_process'), (1,'menu_profile'), (1,'menu_profile_create'), (1,'menu_profile_import'), (1,'menu_reports'), (1,'menu_sample'), (1,'menu_tab'), (16,'login'), (16,'menu_ajax'), (16,'menu_customer'), (16,'menu_customer_create'), (16,'menu_home'), (16,'menu_logout'), (16,'menu_map'), (16,'menu_profile'), (16,'menu_reports'), (16,'menu_tab'), (950,'edit_notification'), (950,'getAdminNotifications'), (950,'saveNotification'), (1010,'menu_web_analytics'), (2115,'menu_web_analytics'); -- -- Dumping data for table `fn_shared_context` -- INSERT INTO `fn_shared_context` (`id`, `create_time`, `context_id`, `ckey`, `cvalue`) VALUES (1,'2019-08-08 10:11:18','b999771d~2d60~4638~a670~d47d17219157','USER_FIRST_NAME','Jimmy'), (2,'2019-08-08 10:11:18','b999771d~2d60~4638~a670~d47d17219157','USER_LAST_NAME','Hendrix'), (3,'2019-08-08 10:11:18','b999771d~2d60~4638~a670~d47d17219157','USER_EMAIL','admin@onap.org'), (4,'2019-08-08 10:11:18','b999771d~2d60~4638~a670~d47d17219157','USER_ORG_USERID','jh0003'), (5,'2019-08-08 10:17:47','29cc8f94~5a7d~41f8~b359~432bb903a718','USER_FIRST_NAME','Demo'), (6,'2019-08-08 10:17:47','29cc8f94~5a7d~41f8~b359~432bb903a718','USER_LAST_NAME','User'), (7,'2019-08-08 10:17:47','29cc8f94~5a7d~41f8~b359~432bb903a718','USER_EMAIL','demo@openecomp.org'), (8,'2019-08-08 10:17:47','29cc8f94~5a7d~41f8~b359~432bb903a718','USER_ORG_USERID','demo'), (9,'2019-08-08 11:01:02','7e3ced0a~52a3~492a~be53~2885d2df5a43','USER_FIRST_NAME','Demo'), (10,'2019-08-08 11:01:02','7e3ced0a~52a3~492a~be53~2885d2df5a43','USER_LAST_NAME','User'), (11,'2019-08-08 11:01:02','7e3ced0a~52a3~492a~be53~2885d2df5a43','USER_EMAIL','demo@openecomp.org'), (12,'2019-08-08 11:01:02','7e3ced0a~52a3~492a~be53~2885d2df5a43','USER_ORG_USERID','demo'); -- -- Dumping data for table `fn_tab` -- INSERT INTO `fn_tab` (`tab_cd`, `tab_name`, `tab_descr`, `action`, `function_cd`, `active_yn`, `sort_order`, `parent_tab_cd`, `tab_set_cd`) VALUES ('TAB1','Tab 1','Tab 1 Information','tab1.htm','menu_tab',1,10,NULL,'APP'), ('TAB2','Tab 2','Tab 2 Information','tab2_sub1.htm','menu_tab',1,20,NULL,'APP'), ('TAB2_SUB1','Sub Tab 1','Sub Tab 1 Information','tab2_sub1.htm','menu_tab',1,10,'TAB2','APP'), ('TAB2_SUB1_S1','Left Tab 1','Sub - Sub Tab 1 Information','tab2_sub1.htm','menu_tab',1,10,'TAB2_SUB1','APP'), ('TAB2_SUB2','Sub Tab 2','Sub Tab 2 Information','tab2_sub2.htm','menu_tab',1,20,'TAB2','APP'), ('TAB2_SUB3','Sub Tab 3','Sub Tab 3 Information','tab2_sub3.htm','menu_tab',1,30,'TAB2','APP'), ('TAB3','Tab 3','Tab 3 Information','tab3.htm','menu_tab',1,30,NULL,'APP'), ('TAB4','Tab 4','Tab 4 Information','tab4.htm','menu_tab',1,40,NULL,'APP'); -- -- Dumping data for table `fn_tab_selected` -- INSERT INTO `fn_tab_selected` (`selected_tab_cd`, `tab_uri`) VALUES ('TAB1','tab1'),('TAB2','tab2_sub1'), ('TAB2','tab2_sub2'), ('TAB2','tab2_sub3'), ('TAB2_SUB1','tab2_sub1'), ('TAB2_SUB1_S1','tab2_sub1'), ('TAB2_SUB2','tab2_sub2'), ('TAB2_SUB3','tab2_sub3'), ('TAB3','tab3'), ('TAB4','tab4'); -- -- Dumping data for table `fn_user` -- INSERT INTO `fn_user` ( `org_id`, `first_name`, `middle_name`, `last_name`, `phone`, `fax`, `cellular`, `email`, `address_id`, `alert_method_cd`, `hrid`, `org_user_id`, `org_code`, `login_id`, `login_pwd`, `last_login_date`, `active_yn`, `created_date`, `modified_date`, `is_internal_yn`, `address_line_1`, `address_line_2`, `city`, `state_cd`, `zip_code`, `country_cd`, `location_clli`, `org_manager_userid`, `company`, `department_name`, `job_title`, `timezone`, `department`, `business_unit`, `business_unit_name`, `cost_center`, `fin_loc_code`, `silo_status`, `language_id` ) VALUES ( NULL, 'Demo', NULL, 'User', NULL, NULL, NULL, 'demo@openecomp.org', NULL, NULL, NULL, 'demo', NULL, 'demo', 'demo123', '2019-08-08 12:18:17', 1, '2016-10-14 21:00:00', '2019-08-08 12:18:17', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'Jimmy', NULL, 'Hendrix', NULL, NULL, NULL, 'admin@onap.org', NULL, NULL, NULL, 'jh0003', NULL, 'jh0003', 'demo123', '2019-08-08 10:16:11', 1, '2016-10-14 21:00:00', '2019-08-08 10:16:11', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'Carlos', NULL, 'Santana', NULL, NULL, NULL, 'designer@onap.org', NULL, NULL, NULL, 'cs0008', NULL, 'cs0008', 'demo123', '2016-10-20 15:11:16', 1, '2016-10-14 21:00:00', '2016-10-20 15:11:16', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'Joni', NULL, 'Mitchell', NULL, NULL, NULL, 'tester@onap.org', NULL, NULL, NULL, 'jm0007', NULL, 'jm0007', 'demo123', '2016-10-20 15:11:16', 1, '2016-10-14 21:00:00', '2016-10-20 15:11:16', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'Steve', NULL, 'Regev', NULL, NULL, NULL, 'ops@onap.org', NULL, NULL, NULL, 'op0001', NULL, 'op0001', 'demo123', '2016-10-20 15:11:16', 1, '2016-10-14 21:00:00', '2016-10-20 15:11:16', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'David', NULL, 'Shadmi', NULL, NULL, NULL, 'governor@onap.org', NULL, NULL, NULL, 'gv0001', NULL, 'gv0001', 'demo123', '2016-10-20 15:11:16', 1, '2016-10-14 21:00:00', '2016-10-20 15:11:16', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'Teddy', NULL, 'Isashar', NULL, NULL, NULL, 'pm1@onap.org', NULL, NULL, NULL, 'pm0001', NULL, 'pm0001', 'demo123', '2016-10-20 15:11:16', 1, '2016-10-14 21:00:00', '2016-10-20 15:11:16', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'Eden', NULL, 'Rozin', NULL, NULL, NULL, 'ps1@onap.org', NULL, NULL, NULL, 'ps0001', NULL, 'ps0001', 'demo123', '2016-10-20 15:11:16', 1, '2016-10-14 21:00:00', '2016-10-20 15:11:16', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'vid1', NULL, 'user', NULL, NULL, NULL, 'vid1@onap.org', NULL, NULL, NULL, 'vid1', NULL, 'vid1', 'demo123', '2016-10-20 15:11:16', 1, '2016-10-14 21:00:00', '2016-10-20 15:11:16', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'vid2', NULL, 'user', NULL, NULL, NULL, 'vid2@onap.org', NULL, NULL, NULL, 'vid2', NULL, 'vid2', 'demo123', '2016-10-20 15:11:16', 1, '2016-10-14 21:00:00', '2016-10-20 15:11:16', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'vid3', NULL, 'user', NULL, NULL, NULL, 'vid3@onap.org', NULL, NULL, NULL, 'vid3', NULL, 'vid3', 'demo123', '2016-10-20 15:11:16', 1, '2016-10-14 21:00:00', '2016-10-20 15:11:16', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ),( NULL, 'steve', NULL, 'user', NULL, NULL, NULL, 'steve@onap.org', NULL, NULL, NULL, 'steve', NULL, 'steve', 'demo123', '2017-05-19 15:11:16', 1, '2017-05-19 21:00:00', '2017-05-19 15:11:16', 0, NULL, NULL, NULL, 'NJ', NULL, 'US', NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1 ); -- -- Dumping data for table `ep_pers_user_app_sort` -- INSERT INTO `ep_pers_user_app_sort` (`id`, `user_id`, `sort_pref`) VALUES (1,1,0); -- -- Dumping data for table `fn_pers_user_app_sel` -- INSERT INTO `fn_pers_user_app_sel` (`id`, `user_id`, `app_id`, `status_cd`) VALUES (1,1,7,'S'), (2,1,8,'S'), (10,1,10,'S'), (11,1,5,'S'); -- -- Dumping data for table `fn_audit_log` -- INSERT INTO `fn_audit_log` (`log_id`, `user_id`, `activity_cd`, `audit_date`, `comments`, `affected_record_id_bk`, `affected_record_id`) VALUES (1,1,'app_access','2019-08-08 10:18:52','https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html',NULL,'7'), (2,1,'tab_access','2019-08-08 10:18:52','https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html?cc=1565259532115',NULL,'7'), (3,1,'tab_access','2019-08-08 10:18:56','Home',NULL,'1'), (4,1,'tab_access','2019-08-08 10:18:59','https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html?cc=1565259538769',NULL,'7'), (5,1,'app_access','2019-08-08 10:18:59','https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html',NULL,'7'), (6,1,'tab_access','2019-08-08 10:18:59','https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html?cc=1565259538769',NULL,'7'), (7,1,'tab_access','2019-08-08 10:19:06','Home',NULL,'1'); -- -- Dumping data for table `fn_user_role` -- INSERT INTO `fn_user_role` (`user_id`, `role_id`, `priority`, `app_id`) VALUES (1,1,1,1), (1,950,1,1), (1,999,1,1), (1,999,1,2), (1,999,1,3), (1,999,1,4), (1,999,1,5), (1,999,1,6), (1,999,1,7), (1,1000,1,2), (1,1001,1,2), (1,1002,1,3), (1,1004,1,4), (1,1006,1,5), (1,1008,1,6), (2,999,1,4), (2,1004,1,4), (3,16,NULL,4), (3,1005,NULL,4), (4,16,NULL,4), (4,1005,NULL,4), (5,16,NULL,4), (5,1005,NULL,4), (6,16,NULL,4), (6,1005,NULL,4), (7,16,NULL,4), (7,1005,NULL,4), (8,16,NULL,4), (8,1005,NULL,4), (9,16,NULL,6), (9,999,NULL,1), (9,1008,NULL,6), (10,16,NULL,6), (10,1008,NULL,6), (10,1009,NULL,6), (11,16,NULL,6), (12,16,NULL,7), (12,1011,NULL,7), (12,1012,NULL,7); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2019-08-13 10:20:25