-- AJOUT des droits sur les categories (sys_item_has_rights)
INSERT INTO sys_item_has_rights ("className","objectId","groupId",level)
	SELECT 'sys_category', id, GET_VAR('sys_group', 0), 1 FROM sys_category WHERE "thesaurusId" = GET_VAR('sys_thesaurus', 0);
INSERT INTO sys_item_has_rights ("className","objectId","groupId",level)
	SELECT 'sys_category', id, GET_VAR('sys_group', 0), 1 FROM sys_category WHERE "thesaurusId" = GET_VAR('sys_thesaurus', 10);
INSERT INTO sys_item_has_rights ("className","objectId","groupId",level)
	SELECT 'sys_category', id, GET_VAR('sys_group', 0), 1 FROM sys_category WHERE "thesaurusId" = GET_VAR('sys_thesaurus', 20);
INSERT INTO sys_item_has_rights ("className","objectId","groupId",level)
	SELECT 'sys_category', id, GET_VAR('sys_group', 0), 1 FROM sys_category WHERE "thesaurusId" = GET_VAR('sys_thesaurus', 30);
	
	
	
	
	
	
	
	
	
	
	
	
--------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------- SUPPRESSION DES VARIABLES --------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------	
DROP FUNCTION GET_VAR(variable varchar, addedValue int);
--------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------
