[UI] Handling users and passwords

[validation.git] / ui / db-scripts / EcompSdkDMLMySql_2_4_Common.sql

diff --git a/ui/db-scripts/EcompSdkDMLMySql_2_4_Common.sql b/ui/db-scripts/EcompSdkDMLMySql_2_4_Common.sql
index bf18eab..69146dd 100644 (file)
--- a/ui/db-scripts/EcompSdkDMLMySql_2_4_Common.sql
+++ b/ui/db-scripts/EcompSdkDMLMySql_2_4_Common.sql
@@ -5,7 +5,7 @@
 
 SET FOREIGN_KEY_CHECKS=1;
 
-USE akraino;
+USE akraino_bluvalui;
 
 -- fn_function
 Insert into fn_function (FUNCTION_CD,FUNCTION_NAME,TYPE,ACTION) values ('menu_process','Process List','menu','*');
@@ -168,7 +168,8 @@ INSERT INTO fn_restricted_url VALUES('report/wizard/retrieve_data/true','menu_re
 -- fn_role
 Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (16,'Standard User','Y',5);
 Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (1,'System Administrator','Y',1);
-Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (17,'Blueprint Validation UI user','Y',5);
+Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (17,'TSC','Y',5);
+Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (18,'Lab Owner','Y',5);
 
 -- fn_role_composite
 Insert into fn_role_composite (PARENT_ROLE_ID,CHILD_ROLE_ID) values (1,16);
@@ -203,8 +204,11 @@ Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (16,'menu_map');
 Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (16,'menu_profile');
 Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (16,'menu_reports');
 Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (16,'menu_tab');
-Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (17,'menu_home');
 Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (17,'menu_tab');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (17,'menu_customer');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (17,'menu_home');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (18,'menu_customer');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (18,'menu_home');
 
 
 -- fn_tab