projects
/
pithos
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
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;