diff options
Diffstat (limited to 'ecomp-sdk/epsdk-app-os/db-scripts')
| -rw-r--r-- | ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql index 685d1784..a397f2d0 100644 --- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql +++ b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql @@ -36,4 +36,60 @@ Insert into fn_app (APP_ID,APP_NAME,APP_IMAGE_URL,APP_DESCRIPTION,APP_NOTES,APP_ -- fn_user_role Insert into fn_user_role (USER_ID,ROLE_ID,PRIORITY,APP_ID) values (1,1,null,1); +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, 'test report', 'test report', 'Y', '<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<customReport pageSize="50" reportType="Linear"> + <reportName>test report</reportName> + <reportDescr>test report</reportDescr> + <dbInfo>local</dbInfo> + <chartType></chartType> + <showChartTitle>false</showChartTitle> + <public>false</public> + <hideFormFieldAfterRun>false</hideFormFieldAfterRun> + <createId>1</createId> + <createDate>2019-09-11-04:00</createDate> + <reportSQL>SELECT + first_name fi1 +from fn_user</reportSQL> + <frozenColumns>0</frozenColumns> + <emptyMessage>Your Search didn''t yield any results.</emptyMessage> + <dataGridAlign>left</dataGridAlign> + <numFormCols>100</numFormCols> + <displayOptions>NNNNNNN</displayOptions> + <allowSchedule>N</allowSchedule> + <sizedByContent>N</sizedByContent> + <comment>N|</comment> + <dataSourceList> + <dataSource tableId="du0"> + <tableName>DUAL</tableName> + <tablePK></tablePK> + <displayName>DUAL</displayName> + <dataColumnList> + <dataColumn colId="fi1"> + <tableId>du0</tableId> + <dbColName>first_name</dbColName> + <colName>first_name</colName> + <displayName>first_name</displayName> + <displayWidth>10</displayWidth> + <displayAlignment>Left</displayAlignment> + <orderSeq>1</orderSeq> + <visible>true</visible> + <calculated>true</calculated> + <colType>VARCHAR2</colType> + <groupBreak>false</groupBreak> + <dbColType>VARCHAR2</dbColType> + </dataColumn> + </dataColumnList> + </dataSource> + </dataSourceList> + <maxRowsInExcelDownload>500</maxRowsInExcelDownload> + <isOneTimeScheduleAllowed>N</isOneTimeScheduleAllowed> + <isHourlyScheduleAllowed>N</isHourlyScheduleAllowed> + <isDailyScheduleAllowed>N</isDailyScheduleAllowed> + <isDailyMFScheduleAllowed>N</isDailyMFScheduleAllowed> + <isWeeklyScheduleAllowed>N</isWeeklyScheduleAllowed> + <isMonthlyScheduleAllowed>N</isMonthlyScheduleAllowed> +</customReport>', 1, sysdate(), 1, sysdate(), 'HOME', 'N', 1, NULL, 'N', 'N'); + + commit;
\ No newline at end of file |