summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-os/db-scripts
diff options
context:
space:
mode:
Diffstat (limited to 'ecomp-sdk/epsdk-app-os/db-scripts')
-rw-r--r--ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql56
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