
 CREATE  INDEX IND2_acl_entry_acl ON dbo.acl_entries(acl_id)
GO

 CREATE  INDEX IND_alias_entry_alias ON dbo.alias_entries(user_alias)
GO

 CREATE  INDEX IND_events_passu ON dbo.events(passive_user_id)
GO

 CREATE  INDEX IND_events_resource ON dbo.events(resource_id)
GO

 CREATE  INDEX IND_events_time ON dbo.events(event_time)
GO

 CREATE  INDEX IND_members_group ON dbo.members(group_id)
GO

 CREATE  INDEX IND_members_user ON dbo.members(user_id)
GO

 CREATE  INDEX IND_message_left ON dbo.messages(left_index)
GO

 CREATE  INDEX IND_message_messaging_room ON dbo.messages(messaging_room_id)
GO

 CREATE  INDEX IND_message_right ON dbo.messages(right_index)
GO

 CREATE  INDEX IND_messaging_event_message ON dbo.messaging_events(message_id)
GO

 CREATE  UNIQUE  INDEX IND_pass_user_name ON dbo.pass_phrases(user_name)
GO

 CREATE  INDEX IND_resource_left ON dbo.resources(left_index)
GO

 CREATE  INDEX IND_resource_parent ON dbo.resources(parent_resource_id)
GO

 CREATE  INDEX IND_resource_right ON dbo.resources(right_index)
GO

