summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-os/db-scripts
diff options
context:
space:
mode:
authorSudarshan Kumar <sudarshan.kumar@att.com>2020-09-09 13:01:19 +0530
committerSudarshan Kumar <sudarshan.kumar@att.com>2020-09-09 13:03:09 +0530
commit6fe6cea27308b610fbc4d1a33629881debe32108 (patch)
tree18d90610f64a8faf110a6de0a840328be550c81f /ecomp-sdk/epsdk-app-os/db-scripts
parentcd2441d21cad8776e0c9230d66cd2d04920c4a13 (diff)
Fixed SQL Script - Missed semicolon
Added semicolon to fix SQL Script Issue-ID: PORTAL-995 Change-Id: I77711bea001294ef1c93f7bab1054e9218004a04 Signed-off-by: Sudarshan Kumar <sudarshan.kumar@att.com>
Diffstat (limited to 'ecomp-sdk/epsdk-app-os/db-scripts')
-rw-r--r--ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_3_OS.sql2
1 files changed, 1 insertions, 1 deletions
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
index 90e23bcf..f13a4bb5 100644
--- 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
@@ -50,7 +50,7 @@ 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/app/create' WHERE LABEL='Create Reports';
-UPDATE fn_menu SET ACTION='v2/app/report-list' WHERE LABEL='All Reports'
+UPDATE fn_menu SET ACTION='v2/app/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);