X-Git-Url: https://gerrit.akraino.org/r/gitweb?p=validation.git;a=blobdiff_plain;f=ui%2Fdb-scripts%2FEcompSdkDMLMySql_2_4_Common.sql;fp=ui%2Fdb-scripts%2FEcompSdkDMLMySql_2_4_Common.sql;h=69146dd3b36057f2ad7b2dc67bdb2d2721cd4839;hp=bf18eabcd3b3569e2ccb2b27f8de21d365c11bbf;hb=0a46c82e91de6d98c02bd67f70f024bd95751a64;hpb=bac41a9d7cbc4464d5cd502641f78ccb8d66aab1

diff --git a/ui/db-scripts/EcompSdkDMLMySql_2_4_Common.sql b/ui/db-scripts/EcompSdkDMLMySql_2_4_Common.sql
index bf18eab..69146dd 100644
--- 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