Two queries to be run when shared flag in Folder and FileHeader is first created.
[pithos] / database / initializeSharedFlag.sql
1 update fileheader 
2 set shared=true
3 where id in (
4 select fileheader_id
5 from fileheader_permission
6 group by fileheader_id
7 having count(permissions_id)>1
8 )
9 or readforall=true;
10
11
12 update folder 
13 set shared=true
14 where id in (
15 select folder_id
16 from folder_permission
17 group by folder_id
18 having count(permissions_id)>1
19 )
20 or readforall=true;