Make use of GetUserCommand in the PropertiesCommand

[pithos] / database / createIndexes.sql

diff --git a/database/createIndexes.sql b/database/createIndexes.sql
index fb5e2b5..f6f9edb 100644 (file)
--- a/database/createIndexes.sql
+++ b/database/createIndexes.sql
@@ -17,3 +17,31 @@ create index idx_fileheader_folder_id on fileheader(folder_id);
 create index idx_fileheader_currentbody_id on fileheader(currentbody_id);
 create index idx_fileheader_createdby_id on fileheader(createdby_id);
 create index idx_fileheader_owner_id on fileheader(owner_id);
+
+CREATE INDEX idx_accountinginfo_user_id ON accountinginfo(user_id);
+
+CREATE INDEX idx_fileheader_permission_fileheader_id ON fileheader_permission(fileheader_id);
+CREATE INDEX idx_fileheader_permission_permissions_id ON fileheader_permission(permissions_id);
+
+CREATE INDEX idx_fileuploadstatus_owner_id ON fileuploadstatus(owner_id);
+
+CREATE INDEX idx_folder_permission_folder_id ON folder_permission(folder_id);
+CREATE INDEX idx_folder_permission_permissions_id ON folder_permission(permissions_id);
+
+CREATE INDEX idx_gss_user_userclass_id ON gss_user(userclass_id);
+CREATE INDEX idx_gss_user_createdby_id ON gss_user(createdby_id);
+CREATE INDEX idx_gss_user_modifiedby_id ON gss_user(modifiedby_id);
+
+CREATE INDEX idx_gss_group_owner_id ON gss_group(owner_id);
+CREATE INDEX idx_gss_group_modifiedby_id ON gss_group(modifiedby_id);
+CREATE INDEX idx_gss_group_createdby_id ON gss_group(createdby_id);
+
+CREATE INDEX idx_gss_group_gss_user_members_id ON gss_group_gss_user(members_id);
+CREATE INDEX idx_gss_group_gss_user_groupsMember_id ON gss_group_gss_user(groupsmember_id);
+
+CREATE INDEX idx_invitation_user_id ON invitation(user_id);
+
+CREATE INDEX idx_nonce_userid ON nonce(userid);
+
+CREATE INDEX idx_permission_group_id ON permission(group_id);
+CREATE INDEX idx_permission_user_id ON permission(user_id);