diff options
| author |   Sudarshan Kumar <sudarshan.kumar@att.com> | 2020-05-20 12:10:04 +0530 |
|---|---|---|
| committer | Sudarshan Kumar <sudarshan.kumar@att.com> | 2020-05-26 11:47:41 +0000 |
| commit | 1d0bd99862dac4afe29b329b8778abf35b15957b (patch) | |
| tree | 636b887efd7cc64a3a119aac1692f9934c544c57 /ecomp-sdk/epsdk-app-os/db-scripts | |
| parent | cce0f0aad94690b67024dab191988814ded1fb74 (diff) | |
Integrating Raptor Sql Changes
Integrating Raptor Sql Changes
Issue-ID: PORTAL-902
Change-Id: Ia8e71561fb7451e9ab2b1d5bdce28b9b8707a715
Signed-off-by: Sudarshan Kumar <sudarshan.kumar@att.com>
Diffstat (limited to 'ecomp-sdk/epsdk-app-os/db-scripts')
3 files changed, 79 insertions, 1 deletions
diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_3_3_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_3_3_OS.sql new file mode 100644 index 00000000..cdf257b0 --- /dev/null +++ b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_3_3_OS.sql @@ -0,0 +1,12 @@ +-- --------------------------------------------------------------------------------------------------------------- +-- This script adds tables for the OPEN-SOURCE version 3.2.0 of the ECOMP SDK application database. +-- The DDL COMMON script must be executed first! +-- --------------------------------------------------------------------------------------------------------------- + +SET FOREIGN_KEY_CHECKS=1; + +USE ecomp_sdk; + +-- No additional tables required at this time + +commit; diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_2_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_2_OS.sql index f7726b79..b8fba42a 100644 --- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_2_OS.sql +++ b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_2_OS.sql @@ -40,7 +40,7 @@ UPDATE fn_menu SET `IMAGE_SRC`='ion-md-person' WHERE `LABEL`='Profile'; UPDATE fn_menu SET `IMAGE_SRC`='icon ion-md-star' WHERE `LABEL`='Admin'; -- updating fn_menu ACTION url -UPDATE fn_menu SET ACTION='v2/welcome' WHERE LABEL='Home'; +UPDATE fn_menu SET ACTION='welcome' WHERE LABEL='Home'; UPDATE fn_menu SET ACTION='v2/userProfile' WHERE LABEL='Search'; UPDATE fn_menu SET ACTION='v2/userProfile/post_search' WHERE LABEL='Import from WEBPHONE'; UPDATE fn_menu SET ACTION='v2/userProfile/self_profile' WHERE LABEL='Self'; @@ -49,6 +49,8 @@ UPDATE fn_menu SET ACTION='v2/admin/role_function_list' WHERE LABEL='Role Functi UPDATE fn_menu SET ACTION='v2/admin/usage_list' WHERE LABEL='Usage'; UPDATE fn_menu SET ACTION='v2/admin/cache_admin' WHERE LABEL='Cache Admin'; UPDATE fn_menu SET ACTION='v2/admin/admin_menu_edit' WHERE LABEL='Menus'; +UPDATE fn_menu SET ACTION='v2/create' WHERE LABEL='Create Reports'; +UPDATE fn_menu SET ACTION='v2/report-list' WHERE LABEL='All Reports'; -- fn_user Insert into fn_user (USER_ID,ORG_ID,MANAGER_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_ID,CREATED_DATE,MODIFIED_ID,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) values (1,null,null,'Demo',null,'User',null,null,null,'demo@email.com',null,null,null,'demo',null,'demo','demo',str_to_date('24-OCT-16','%d-%M-%Y'),'Y',null,str_to_date('17-OCT-16','%d-%M-%Y'),1,str_to_date('24-OCT-16','%d-%M-%Y'),'N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null); diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_3_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_3_OS.sql new file mode 100644 index 00000000..b8fba42a --- /dev/null +++ b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_3_OS.sql @@ -0,0 +1,64 @@ +-- --------------------------------------------------------------------------------------------------------------- +-- This script populates tables in the OPEN-SOURCE version 3.2.0 of the ECOMP SDK application database. +-- The DML COMMON script must be executed first! +-- --------------------------------------------------------------------------------------------------------------- + +SET FOREIGN_KEY_CHECKS=1; +USE ecomp_sdk; + +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 +(1,'Demo Report - chart','this report show chart config','N','<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n<customReport pageSize=\"50\" reportType=\"Linear\">\n <reportName>Demo Report - chart</reportName>\n <reportDescr>this report show chart config</reportDescr>\n <dbInfo>local</dbInfo>\n <dbType>mysql</dbType>\n <chartType>BarChart3D</chartType>\n <chartMultiSeries>N</chartMultiSeries>\n <chartLeftAxisLabel>Counts</chartLeftAxisLabel>\n <chartWidth>1200</chartWidth>\n <chartHeight>420</chartHeight>\n <showChartTitle>true</showChartTitle>\n <public>false</public>\n <hideFormFieldAfterRun>false</hideFormFieldAfterRun>\n <createId>1</createId>\n <createDate>2019-09-25-04:00</createDate>\n <reportSQL>SELECT \n date_format(create_date,\'%Y-%m-%d\') Create_date, \n count(*) num_rpt \nfrom cr_report\ngroup by date_format(create_date,\'%Y-%m-%d\')\norder by 1</reportSQL>\n <reportTitle>Put Chart Title Here</reportTitle>\n <reportSubTitle></reportSubTitle>\n <frozenColumns>0</frozenColumns>\n <emptyMessage>Your Search didn\'t yield any results.</emptyMessage>\n <dataGridAlign>left</dataGridAlign>\n <numFormCols>100</numFormCols>\n <displayOptions>NNNNNNN</displayOptions>\n <allowSchedule>N</allowSchedule>\n <sizedByContent>N</sizedByContent>\n <comment>N|</comment>\n <dataSourceList>\n <dataSource tableId=\"du0\">\n <tableName>DUAL</tableName>\n <tablePK></tablePK>\n <displayName>DUAL</displayName>\n <dataColumnList>\n <dataColumn colId=\"Create_date\">\n <tableId>du0</tableId>\n <dbColName>VARCHAR2</dbColName>\n <colName>date_format(create_date,\'%Y-%m-%d\')</colName>\n <displayName>Create Date</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>0pxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <displayHeaderAlignment></displayHeaderAlignment>\n <orderSeq>1</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupByPos>0</groupByPos>\n <subTotalCustomText></subTotalCustomText>\n <hideRepeatedKey>false</hideRepeatedKey>\n <groupBreak>false</groupBreak>\n <displayTotal></displayTotal>\n <colOnChart>LEGEND</colOnChart>\n <chartSeq>-1</chartSeq>\n <chartColor></chartColor>\n <chartLineType></chartLineType>\n <chartSeries>false</chartSeries>\n <isSortable>false</isSortable>\n <drillDownType></drillDownType>\n <drillDownURL></drillDownURL>\n <drillDownParams></drillDownParams>\n <semaphoreId></semaphoreId>\n <dbColType>VARCHAR2</dbColType>\n <chartGroup></chartGroup>\n <yAxis></yAxis>\n <dependsOnFormField></dependsOnFormField>\n <nowrap>N</nowrap>\n <indentation>0</indentation>\n <level>0</level>\n <colspan>0</colspan>\n </dataColumn>\n <dataColumn colId=\"num_rpt\">\n <tableId>du0</tableId>\n <dbColName>VARCHAR2</dbColName>\n <colName>count(*)</colName>\n <displayName>Report Count</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>0pxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <displayHeaderAlignment></displayHeaderAlignment>\n <orderSeq>2</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupByPos>0</groupByPos>\n <subTotalCustomText></subTotalCustomText>\n <hideRepeatedKey>false</hideRepeatedKey>\n <groupBreak>false</groupBreak>\n <displayTotal></displayTotal>\n <colOnChart>0</colOnChart>\n <chartSeq>1</chartSeq>\n <chartColor>#FF0000</chartColor>\n <chartLineType>default</chartLineType>\n <chartSeries>false</chartSeries>\n <isSortable>false</isSortable>\n <drillDownType></drillDownType>\n <drillDownURL></drillDownURL>\n <drillDownParams></drillDownParams>\n <semaphoreId></semaphoreId>\n <dbColType>VARCHAR2</dbColType>\n <chartGroup></chartGroup>\n <yAxis></yAxis>\n <dependsOnFormField></dependsOnFormField>\n <nowrap>N</nowrap>\n <indentation>0</indentation>\n <level>0</level>\n <colspan>0</colspan>\n </dataColumn>\n </dataColumnList>\n </dataSource>\n </dataSourceList>\n <formFieldList>\n <formField fieldId=\"ff1\">\n <colId></colId>\n <fieldName>From Date</fieldName>\n <fieldType>Select Field Type</fieldType>\n <visible>Y</visible>\n <validationType>DATE</validationType>\n <mandatory>N</mandatory>\n <defaultValue></defaultValue>\n <orderBySeq>1</orderBySeq>\n <fieldSQL>select date_format(sysdate(),\'%m/%d/%Y\') id, date_format(sysdate(),\'%m/%d/%Y\') name from dual</fieldSQL>\n <fieldDefaultSQL></fieldDefaultSQL>\n <rangeStartDate>0001-02-07+00:15</rangeStartDate>\n <rangeStartDateSQL></rangeStartDateSQL>\n <rangeEndDateSQL></rangeEndDateSQL>\n <groupFormField>false</groupFormField>\n <lastUpdatedFieldId>N</lastUpdatedFieldId>\n </formField>\n <formField fieldId=\"ff2\">\n <colId></colId>\n <fieldName>TO Date</fieldName>\n <fieldType>Select Field Type</fieldType>\n <visible>Y</visible>\n <validationType>DATE</validationType>\n <mandatory>N</mandatory>\n <defaultValue></defaultValue>\n <orderBySeq>2</orderBySeq>\n <fieldSQL>select date_format(sysdate(),\'%m/%d/%Y\') id, date_format(sysdate(),\'%m/%d/%Y\') name from dual</fieldSQL>\n <fieldDefaultSQL></fieldDefaultSQL>\n <rangeStartDate>0001-02-07+00:15</rangeStartDate>\n <rangeStartDateSQL></rangeStartDateSQL>\n <rangeEndDateSQL></rangeEndDateSQL>\n <groupFormField>false</groupFormField>\n <lastUpdatedFieldId>N</lastUpdatedFieldId>\n </formField>\n </formFieldList>\n <semaphoreList/>\n <maxRowsInExcelDownload>500</maxRowsInExcelDownload>\n <chartAdditionalOptions>\n <chartOrientation>vertical</chartOrientation>\n <hidechartLegend>N</hidechartLegend>\n <legendPosition>top</legendPosition>\n <labelAngle>up45</labelAngle>\n <rangeAxisUpperLimit></rangeAxisUpperLimit>\n <rangeAxisLowerLimit></rangeAxisLowerLimit>\n <animate>true</animate>\n <animateAnimatedChart>true</animateAnimatedChart>\n <stacked>false</stacked>\n <barControls>false</barControls>\n <xAxisDateType>false</xAxisDateType>\n <lessXaxisTickers>false</lessXaxisTickers>\n <timeAxis>false</timeAxis>\n <timeSeriesRender>line</timeSeriesRender>\n <multiSeries>false</multiSeries>\n <showXAxisLabel>false</showXAxisLabel>\n <addXAxisTickers>false</addXAxisTickers>\n <logScale>false</logScale>\n <topMargin>100</topMargin>\n <bottomMargin>100</bottomMargin>\n <rightMargin>100</rightMargin>\n <leftMargin>100</leftMargin>\n </chartAdditionalOptions>\n <isOneTimeScheduleAllowed>N</isOneTimeScheduleAllowed>\n <isHourlyScheduleAllowed>N</isHourlyScheduleAllowed>\n <isDailyScheduleAllowed>N</isDailyScheduleAllowed>\n <isDailyMFScheduleAllowed>N</isDailyMFScheduleAllowed>\n <isWeeklyScheduleAllowed>N</isWeeklyScheduleAllowed>\n <isMonthlyScheduleAllowed>N</isMonthlyScheduleAllowed>\n</customReport>\n',1,'2019-09-25 17:46:18',1,'2020-05-05 04:31:07','HOME','N',1,NULL,'N','N'), +(2,'Demo Report - drilldown with formfield','Demo Report - drilldown with formfield','N','<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n<customReport pageSize=\"50\" reportType=\"Linear\">\n <reportName>Demo Report - drilldown with formfield</reportName>\n <reportDescr>Demo Report - drilldown with formfield</reportDescr>\n <dbInfo>local</dbInfo>\n <chartType></chartType>\n <showChartTitle>false</showChartTitle>\n <public>false</public>\n <hideFormFieldAfterRun>false</hideFormFieldAfterRun>\n <createId>1</createId>\n <createDate>2019-09-25-04:00</createDate>\n <reportSQL>SELECT \n c.role_name ROLE_NAME, \n a.FIRST_NAME FIRST_NAME, \n a.LAST_NAME LAST_NAME, \n a.EMAIL EMAIL \nfrom fn_user a, fn_user_role b, fn_role c\nwhere c.role_id=b.role_id and b.user_id=a.user_id and c.role_id in [ROLE]</reportSQL>\n <frozenColumns>0</frozenColumns>\n <emptyMessage>Your Search didn\'t yield any results.</emptyMessage>\n <dataGridAlign>left</dataGridAlign>\n <numFormCols>100</numFormCols>\n <displayOptions>NYNNNNN</displayOptions>\n <allowSchedule>N</allowSchedule>\n <sizedByContent>N</sizedByContent>\n <comment>N|</comment>\n <dataSourceList>\n <dataSource tableId=\"du0\">\n <tableName>DUAL</tableName>\n <tablePK></tablePK>\n <displayName>DUAL</displayName>\n <dataColumnList>\n <dataColumn colId=\"ROLE_NAME\">\n <tableId>du0</tableId>\n <dbColName>c.role_name</dbColName>\n <colName>c.role_name</colName>\n <displayName>ROLE_NAME</displayName>\n <displayWidth>10</displayWidth>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>1</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <dbColType>VARCHAR2</dbColType>\n </dataColumn>\n <dataColumn colId=\"FIRST_NAME\">\n <tableId>du0</tableId>\n <dbColName>a.FIRST_NAME</dbColName>\n <colName>a.FIRST_NAME</colName>\n <displayName>FIRST_NAME</displayName>\n <displayWidth>10</displayWidth>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>2</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <dbColType>VARCHAR2</dbColType>\n </dataColumn>\n <dataColumn colId=\"LAST_NAME\">\n <tableId>du0</tableId>\n <dbColName>a.LAST_NAME</dbColName>\n <colName>a.LAST_NAME</colName>\n <displayName>LAST_NAME</displayName>\n <displayWidth>10</displayWidth>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>3</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <dbColType>VARCHAR2</dbColType>\n </dataColumn>\n <dataColumn colId=\"EMAIL\">\n <tableId>du0</tableId>\n <dbColName>a.EMAIL</dbColName>\n <colName>a.EMAIL</colName>\n <displayName>EMAIL</displayName>\n <displayWidth>10</displayWidth>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>4</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <dbColType>VARCHAR2</dbColType>\n </dataColumn>\n </dataColumnList>\n </dataSource>\n </dataSourceList>\n <formFieldList>\n <formField fieldId=\"ff1\">\n <colId></colId>\n <fieldName>ROLE</fieldName>\n <fieldType>LIST_MULTI_SELECT</fieldType>\n <visible>Y</visible>\n <validationType></validationType>\n <mandatory>N</mandatory>\n <defaultValue></defaultValue>\n <orderBySeq>1</orderBySeq>\n <fieldSQL>select role_id id, role_name name from fn_role order by 2</fieldSQL>\n <fieldDefaultSQL></fieldDefaultSQL>\n <rangeStartDate>0001-02-07+00:15</rangeStartDate>\n <rangeStartDateSQL></rangeStartDateSQL>\n <rangeEndDateSQL></rangeEndDateSQL>\n <groupFormField>false</groupFormField>\n <lastUpdatedFieldId>N</lastUpdatedFieldId>\n </formField>\n </formFieldList>\n <maxRowsInExcelDownload>500</maxRowsInExcelDownload>\n <isOneTimeScheduleAllowed>N</isOneTimeScheduleAllowed>\n <isHourlyScheduleAllowed>N</isHourlyScheduleAllowed>\n <isDailyScheduleAllowed>N</isDailyScheduleAllowed>\n <isDailyMFScheduleAllowed>N</isDailyMFScheduleAllowed>\n <isWeeklyScheduleAllowed>N</isWeeklyScheduleAllowed>\n <isMonthlyScheduleAllowed>N</isMonthlyScheduleAllowed>\n</customReport>\n',1,'2019-09-25 18:25:02',1,'2020-05-05 04:04:01','','N',1,NULL,'N','N'), +(3,'Demo Report - parent','this report show how many users for each ROLE. click Counts number to see USER details.','N','<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n<customReport pageSize=\"50\" reportType=\"Linear\">\n <reportName>Demo Report - parent</reportName>\n <reportDescr>this report show how many users for each ROLE. click Counts number to see USER details.</reportDescr>\n <dbInfo>local</dbInfo>\n <chartType></chartType>\n <showChartTitle>false</showChartTitle>\n <public>false</public>\n <hideFormFieldAfterRun>false</hideFormFieldAfterRun>\n <createId>1</createId>\n <createDate>2019-12-06-05:00</createDate>\n <reportSQL>SELECT \n count(*) co3, \n a.role_id ar5, \n a.role_name ar4 \nfrom fn_role a, fn_user_role b, fn_user c \n where a.role_id=b.role_id and b.user_id=c.user_id\n group by a.role_name</reportSQL>\n <reportTitle></reportTitle>\n <frozenColumns>0</frozenColumns>\n <emptyMessage>Your Search didn\'t yield any results.</emptyMessage>\n <dataGridAlign>left</dataGridAlign>\n <numFormCols>100</numFormCols>\n <displayOptions>NYNNNNN</displayOptions>\n <allowSchedule>N</allowSchedule>\n <sizedByContent>N</sizedByContent>\n <comment>N|Test Report Demo</comment>\n <dataSourceList>\n <dataSource tableId=\"du0\">\n <tableName>DUAL</tableName>\n <tablePK></tablePK>\n <displayName>DUAL</displayName>\n <dataColumnList>\n <dataColumn colId=\"co3\">\n <tableId>du0</tableId>\n <dbColName>VARCHAR2</dbColName>\n <colName>count(*)</colName>\n <displayName>Counts </displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>0pxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <displayHeaderAlignment></displayHeaderAlignment>\n <orderSeq>1</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupByPos>0</groupByPos>\n <subTotalCustomText></subTotalCustomText>\n <hideRepeatedKey>false</hideRepeatedKey>\n <groupBreak>false</groupBreak>\n <displayTotal></displayTotal>\n <isSortable>false</isSortable>\n <drillDownType></drillDownType>\n <drillDownURL>28</drillDownURL>\n <drillDownParams>ff1=[ar5]</drillDownParams>\n <semaphoreId></semaphoreId>\n <dbColType>VARCHAR2</dbColType>\n <dependsOnFormField></dependsOnFormField>\n <nowrap>N</nowrap>\n <indentation>0</indentation>\n <level>0</level>\n <colspan>0</colspan>\n </dataColumn>\n <dataColumn colId=\"ar5\">\n <tableId>du0</tableId>\n <dbColName>VARCHAR2</dbColName>\n <colName>a.role_id</colName>\n <displayName>Role ID</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>0pxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <displayHeaderAlignment></displayHeaderAlignment>\n <orderSeq>2</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupByPos>0</groupByPos>\n <subTotalCustomText></subTotalCustomText>\n <hideRepeatedKey>false</hideRepeatedKey>\n <groupBreak>false</groupBreak>\n <displayTotal></displayTotal>\n <isSortable>false</isSortable>\n <drillDownType></drillDownType>\n <drillDownURL></drillDownURL>\n <drillDownParams></drillDownParams>\n <semaphoreId></semaphoreId>\n <dbColType>VARCHAR2</dbColType>\n <dependsOnFormField></dependsOnFormField>\n <nowrap>N</nowrap>\n <indentation>0</indentation>\n <level>0</level>\n <colspan>0</colspan>\n </dataColumn>\n <dataColumn colId=\"ar4\">\n <tableId>du0</tableId>\n <dbColName>VARCHAR2</dbColName>\n <colName>a.role_name</colName>\n <displayName>Role Name</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>0pxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <displayHeaderAlignment></displayHeaderAlignment>\n <orderSeq>3</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupByPos>0</groupByPos>\n <subTotalCustomText></subTotalCustomText>\n <hideRepeatedKey>false</hideRepeatedKey>\n <groupBreak>false</groupBreak>\n <displayTotal></displayTotal>\n <isSortable>false</isSortable>\n <drillDownType></drillDownType>\n <drillDownURL></drillDownURL>\n <drillDownParams></drillDownParams>\n <semaphoreId>sem1</semaphoreId>\n <dbColType>VARCHAR2</dbColType>\n <dependsOnFormField></dependsOnFormField>\n <nowrap>N</nowrap>\n <indentation>0</indentation>\n <level>0</level>\n <colspan>0</colspan>\n </dataColumn>\n </dataColumnList>\n </dataSource>\n </dataSourceList>\n <semaphoreList>\n <semaphore semaphoreId=\"sem1\">\n <semaphoreName>Display Formatting 1</semaphoreName>\n <semaphoreType>CELL</semaphoreType>\n <comment>ar4</comment>\n <formatList>\n <format formatId=\"sem1_fmt1\">\n <lessThanValue></lessThanValue>\n <expression></expression>\n <bold>false</bold>\n <italic>false</italic>\n <underline>false</underline>\n <bgColor></bgColor>\n <fontColor></fontColor>\n <fontFace></fontFace>\n <fontSize>18</fontSize>\n </format>\n <format formatId=\"sem1_fmt2\">\n <lessThanValue> System Administrator</lessThanValue>\n <expression>=</expression>\n <bold>true</bold>\n <italic>false</italic>\n <underline>false</underline>\n <bgColor>#FF0000</bgColor>\n <fontColor></fontColor>\n <fontFace></fontFace>\n <fontSize>18</fontSize>\n </format>\n </formatList>\n </semaphore>\n </semaphoreList>\n <maxRowsInExcelDownload>500</maxRowsInExcelDownload>\n <isOneTimeScheduleAllowed>N</isOneTimeScheduleAllowed>\n <isHourlyScheduleAllowed>N</isHourlyScheduleAllowed>\n <isDailyScheduleAllowed>N</isDailyScheduleAllowed>\n <isDailyMFScheduleAllowed>N</isDailyMFScheduleAllowed>\n <isWeeklyScheduleAllowed>N</isWeeklyScheduleAllowed>\n <isMonthlyScheduleAllowed>N</isMonthlyScheduleAllowed>\n</customReport>\n',1,'2019-12-06 19:29:51',1,'2020-05-05 04:07:08','HOME','N',1,NULL,'N','N'), +(4,'Demo Report - Dashboard type','Compose several sub-reports into one view, Drag report from Data section and Chart section.','N','<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n<customReport pageSize=\"50\" reportType=\"Dashboard\">\n <reportName>Demo Report - Dashboard type</reportName>\n <reportDescr>Compose several sub-reports into one view, Drag report from Data section and Chart section.</reportDescr>\n <dashboardLayoutHTML></dashboardLayoutHTML>\n <dashboardLayoutJSON>[{\"x\":0,\"y\":0,\"cols\":7,\"rows\":1,\"hasContent\":{\"name\":\"Demo Report - chart\",\"id\":\"Data#27\",\"hideDisplay\":false}},{\"x\":0,\"y\":1,\"cols\":7,\"rows\":1,\"hasContent\":{\"name\":\"Demo Report - chart\",\"id\":\"Chart#27\",\"hideDisplay\":false}},{\"x\":0,\"y\":2,\"cols\":7,\"rows\":1,\"hasContent\":{\"name\":\"Demo Report - parent\",\"id\":\"Data#29\",\"hideDisplay\":false}}]</dashboardLayoutJSON>\n <chartType></chartType>\n <showChartTitle>false</showChartTitle>\n <public>false</public>\n <createId>1</createId>\n <createDate>2020-05-06-04:00</createDate>\n <allowSchedule>N</allowSchedule>\n <dataSourceList/>\n</customReport>\n',1,'2020-05-06 14:40:27',1,'2020-05-06 14:59:50','','N',1,NULL,'N','Y'); + +-- 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', 'N', NULL, NULL, NULL, NULL, 'APP', 'N', NULL); -- we need even though it's inactive +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 (5000, 'Sample Pages', 1, 30, 'sample.htm', 'menu_sample', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-documents-book'); +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 (2, 'Home', 1, 10, 'welcome', 'menu_home', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-building-home'); +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 (8, 'Reports', 1, 40, 'report.htm', 'menu_reports', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-misc-piechart'); +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 (9, 'Profile', 1, 90, 'userProfile', 'menu_profile', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-people-oneperson'); +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 (10, 'Admin', 1, 110, 'role_list.htm', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-content-star'); +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 (84, 'All Reports', 8, 50, 'report', 'menu_reports', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/reports.png'); +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 (87, 'Create Reports', 8, 120, 'report#/report_wizard', 'menu_reports', 'Y', NULL, 'r_action=report.create', NULL, NULL, 'APP', 'N', NULL); +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 (88, 'Sample Dashboard', 8, 130, 'report_dashboard', 'menu_reports', 'N', NULL, NULL, NULL, NULL, 'APP', 'N', NULL); +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 (89, 'Import', 8, 140, 'report#/report_import', 'menu_reports', 'N', null, null, null, null, 'APP', 'N', null); +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 (94, 'Self', 9, 40,'userProfile#/self_profile', 'menu_profile', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/profile.png'); +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 (101, 'Roles', 10, 20, 'admin#/admin', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/users.png'); +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 (102, 'Role Functions', 10, 30, 'admin#/role_function_list', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', NULL); +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 (105, 'Cache Admin', 10, 40, 'admin#/jcs_admin', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/cache.png'); +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 (108, 'Usage', 10, 80, 'admin#/usage_list', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/users.png'); +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 (121, 'Collaboration', 5000, 100, 'samplePage#/collaborate_list', 'menu_sample', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/bubble.png'); +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 (930, 'Search', 9, 15, 'userProfile', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/search_profile.png'); +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 (150022, 'Menus', 10, 60, 'admin#/admin_menu_edit', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', NULL); +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 (150038,'Notebook',5000,135,'samplePage#/notebook','menu_sample','Y',NULL,NULL,NULL,NULL,'APP','N',NULL); + +-- fn_menu - update menu icon +UPDATE fn_menu SET `IMAGE_SRC`='icon ion-ios-home' WHERE `LABEL`='Home'; +UPDATE fn_menu SET `IMAGE_SRC`='icon ion-md-pie' WHERE `LABEL`='Reports'; +UPDATE fn_menu SET `IMAGE_SRC`='ion-md-person' WHERE `LABEL`='Profile'; +UPDATE fn_menu SET `IMAGE_SRC`='icon ion-md-star' WHERE `LABEL`='Admin'; + +-- updating fn_menu ACTION url +UPDATE fn_menu SET ACTION='welcome' WHERE LABEL='Home'; +UPDATE fn_menu SET ACTION='v2/userProfile' WHERE LABEL='Search'; +UPDATE fn_menu SET ACTION='v2/userProfile/post_search' WHERE LABEL='Import from WEBPHONE'; +UPDATE fn_menu SET ACTION='v2/userProfile/self_profile' WHERE LABEL='Self'; +UPDATE fn_menu SET ACTION='v2/admin/admin' WHERE LABEL='Roles'; +UPDATE fn_menu SET ACTION='v2/admin/role_function_list' WHERE LABEL='Role Functions'; +UPDATE fn_menu SET ACTION='v2/admin/usage_list' WHERE LABEL='Usage'; +UPDATE fn_menu SET ACTION='v2/admin/cache_admin' WHERE LABEL='Cache Admin'; +UPDATE fn_menu SET ACTION='v2/admin/admin_menu_edit' WHERE LABEL='Menus'; +UPDATE fn_menu SET ACTION='v2/create' WHERE LABEL='Create Reports'; +UPDATE fn_menu SET ACTION='v2/report-list' WHERE LABEL='All Reports'; + +-- fn_user +Insert into fn_user (USER_ID,ORG_ID,MANAGER_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_ID,CREATED_DATE,MODIFIED_ID,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) values (1,null,null,'Demo',null,'User',null,null,null,'demo@email.com',null,null,null,'demo',null,'demo','demo',str_to_date('24-OCT-16','%d-%M-%Y'),'Y',null,str_to_date('17-OCT-16','%d-%M-%Y'),1,str_to_date('24-OCT-16','%d-%M-%Y'),'N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null); + +-- fn_app +Insert into fn_app (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,THUMBNAIL,APP_USERNAME,UEB_KEY,UEB_SECRET,UEB_TOPIC_NAME) VALUES (1,'Default',null,'Some Default Description','Some Default Note',null,null,null,'ECPP','?','1','JuCerIRKt/faEcx8QdgncLEEv+IOZjpHe7Pi5DEPqKs=','N','N',null,'Default',null,null,'ECOMP-PORTAL-INBOX'); + +-- fn_user_role +Insert into fn_user_role (USER_ID,ROLE_ID,PRIORITY,APP_ID) values (1,1,null,1); + +commit; |