 );
 
 CREATE INDEX idx_role_name ON role (name);
+CREATE INDEX idx_role_privilege ON role USING GIN (privilege);
 CREATE INDEX idx_role_active ON role (active);
 CREATE INDEX idx_role_system ON role (system);
 CREATE INDEX idx_role_project ON role (project_id);

CREATE INDEX idx_content_name ON content (name);
CREATE INDEX idx_content_entity ON content (entity_id);
CREATE INDEX idx_content_active ON content (active);
CREATE INDEX idx_content_created ON content (created);
CREATE INDEX idx_content_creator ON content (creator);
CREATE INDEX idx_content_modified ON content (modified);
CREATE INDEX idx_content_modifier ON content (modifier);
CREATE INDEX idx_content_project ON content (project_id);
CREATE INDEX idx_content_search ON content USING GIN (search);

CREATE FUNCTION content_update_before() RETURNS trigger AS
$$

CREATE INDEX idx_node_rgt ON node (rgt);
CREATE INDEX idx_node_level ON node (level);
CREATE INDEX idx_node_project ON node (project_id);

-- ---------------------------------------------------------------------------------------------------------------------
-- URL
