PREFIX afn: <http://jena.hpl.hp.com/ARQ/function#>
PREFIX fn: <http://www.w3.org/2005/xpath-functions#>

WITH <http://imeji.org/user>
DELETE {?s ?pr ?g . ?g ?p ?o}
USING <http://imeji.org/user>
USING <http://imeji.org/collection>
USING <http://imeji.org/metadataProfile>
USING <http://imeji.org/album>
WHERE {?g <http://imeji.org/terms/grantFor> ?for . not exists{?for ?prop ?obj} . filter (?for!= <http://imeji.org/> &&  ?for != <XXX_BASE_URI_XXX>) . ?s ?pr ?g . ?g ?p ?o};

WITH <http://imeji.org/user>
DELETE {?g <http://imeji.org/terms/grantFor> ?for
 . ?g <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#SYSADMIN>}
INSERT {?g <http://imeji.org/terms/grantFor> <XXX_BASE_URI_XXX>
. ?g <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#ADMIN>}
USING <http://imeji.org/user>
WHERE {?g <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#SYSADMIN>
 . ?g <http://imeji.org/terms/grantFor> ?for};

WITH <http://imeji.org/user>
DELETE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#VIEWER>}
INSERT {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#READ>}
USING <http://imeji.org/user>
WHERE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#VIEWER>};

WITH <http://imeji.org/user>
DELETE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#PRIVILEGED_VIEWER>}
INSERT {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#READ>}
USING <http://imeji.org/user>
WHERE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#PRIVILEGED_VIEWER>};

WITH <http://imeji.org/user>
DELETE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#IMAGE_EDITOR>}
INSERT {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#READ>
 . ?user <http://imeji.org/terms/grant> ?g1 . ?g1 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#UPDATE_CONTENT> .  ?g1 <http://imeji.org/terms/grantFor> ?for}
USING <http://imeji.org/user>
WHERE {?user <http://imeji.org/terms/grant> ?s
 . ?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#IMAGE_EDITOR>
 . ?s <http://imeji.org/terms/grantFor> ?for
 . let(?g1 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))};

WITH <http://imeji.org/user>
DELETE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#CONTAINER_EDITOR>}
INSERT {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#READ>
 . ?user <http://imeji.org/terms/grant> ?g1 . ?g1 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#UPDATE> .  ?g1 <http://imeji.org/terms/grantFor> ?for}
USING <http://imeji.org/user>
WHERE {?user <http://imeji.org/terms/grant> ?s
 . ?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#CONTAINER_EDITOR>
 . ?s <http://imeji.org/terms/grantFor> ?for
 . let(?g1 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))};

WITH <http://imeji.org/user>
DELETE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#PROFILE_VIEWER>}
INSERT {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#READ>}
USING <http://imeji.org/user>
WHERE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#PROFILE_VIEWER>};

WITH <http://imeji.org/user>
DELETE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#PROFILE_EDITOR>}
INSERT {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#READ>
 . ?user <http://imeji.org/terms/grant> ?g1 . ?g1 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#UPDATE> . ?g1 <http://imeji.org/terms/grantFor> ?for}
USING <http://imeji.org/user>
WHERE {?user <http://imeji.org/terms/grant> ?s 
 . ?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#PROFILE_EDITOR>
 . ?s <http://imeji.org/terms/grantFor> ?for
 . let(?g1 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))};

WITH <http://imeji.org/user>
DELETE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#PROFILE_ADMIN>}
INSERT {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#READ>
 . ?user <http://imeji.org/terms/grant> ?g1 . ?g1 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#UPDATE> . ?g1 <http://imeji.org/terms/grantFor> ?for}
USING <http://imeji.org/user>
WHERE {?user <http://imeji.org/terms/grant> ?s 
 . ?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#PROFILE_ADMIN>
 . ?s <http://imeji.org/terms/grantFor> ?for
 . let(?g1 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))};

WITH <http://imeji.org/user>
DELETE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#CONTAINER_ADMIN>}
INSERT{?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#READ>
 . ?user <http://imeji.org/terms/grant> ?g1 . ?g1 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#ADMIN> .  ?g1 <http://imeji.org/terms/grantFor> ?for
 . ?user <http://imeji.org/terms/grant> ?g2 . ?g2 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#ADMIN_CONTENT> . ?g2 <http://imeji.org/terms/grantFor> ?for
 . ?user <http://imeji.org/terms/grant> ?g3 . ?g3 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#CREATE> . ?g3 <http://imeji.org/terms/grantFor> ?for
 . ?user <http://imeji.org/terms/grant> ?g4 . ?g4 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#DELETE> . ?g4 <http://imeji.org/terms/grantFor> ?for
 . ?user <http://imeji.org/terms/grant> ?g5 . ?g5 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#DELETE_CONTENT> . ?g5 <http://imeji.org/terms/grantFor> ?for
 . ?user <http://imeji.org/terms/grant> ?g6 . ?g6 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#UPDATE> . ?g6 <http://imeji.org/terms/grantFor> ?for
 . ?user <http://imeji.org/terms/grant> ?g7 . ?g7 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#UPDATE_CONTENT> . ?g7 <http://imeji.org/terms/grantFor> ?for}
USING <http://imeji.org/user>
USING <http://imeji.org/collection>
WHERE {?user <http://imeji.org/terms/grant> ?s
 . ?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#CONTAINER_ADMIN> 
 . ?s <http://imeji.org/terms/grantFor> ?for
 . let(?g1 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))
 . let(?g2 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))
 . let(?g3 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))
 . let(?g4 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))
 . let(?g5 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))
 . let(?g6 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))
 . let(?g7 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))};

WITH <http://imeji.org/user>
DELETE {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#CONTAINER_ADMIN>}
INSERT {?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#READ>
 . ?user <http://imeji.org/terms/grant> ?g1 . ?g1 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#ADMIN> .  ?g1 <http://imeji.org/terms/grantFor> ?for
 . ?user <http://imeji.org/terms/grant> ?g2 . ?g2 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#UPDATE> . ?g2 <http://imeji.org/terms/grantFor> ?for
 . ?user <http://imeji.org/terms/grant> ?g3 . ?g3 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#CREATE> . ?g3 <http://imeji.org/terms/grantFor> ?for
 . ?user <http://imeji.org/terms/grant> ?g4 . ?g4 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#DELETE> . ?g4 <http://imeji.org/terms/grantFor> ?for
}
USING <http://imeji.org/user>
USING <http://imeji.org/album>
WHERE {?user <http://imeji.org/terms/grant> ?s
 . ?s <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#CONTAINER_ADMIN>
 . ?s <http://imeji.org/terms/grantFor> ?for
 . let(?g1 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))
 . let(?g2 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))
 . let(?g3 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))
 . let(?g4 := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX',afn:sha1sum(?for))))};

WITH <http://imeji.org/user>
INSERT{?user <http://imeji.org/terms/grant> ?g . ?g <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#READ> . ?g <http://imeji.org/terms/grantFor> ?user
 . ?user <http://imeji.org/terms/grant> ?g1 . ?g1 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#ADMIN> . ?g1 <http://imeji.org/terms/grantFor> ?user
 . ?user <http://imeji.org/terms/grant> ?g2 . ?g2 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#CREATE> . ?g2 <http://imeji.org/terms/grantFor> ?user
 . ?user <http://imeji.org/terms/grant> ?g3 . ?g3 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#DELETE> . ?g3 <http://imeji.org/terms/grantFor> ?user
 . ?user <http://imeji.org/terms/grant> ?g4 . ?g4 <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#UPDATE> . ?g4 <http://imeji.org/terms/grantFor> ?user}
USING <http://imeji.org/user>
WHERE {?user a <http://imeji.org/terms/user> 
 . let(?g := uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX', afn:sha1sum(?user))))
 . let(?g1 :=  uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX', afn:sha1sum(?user))))
 . let(?g2 :=  uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX', afn:sha1sum(?user))))
 . let(?g3 :=  uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX', afn:sha1sum(?user))))
 . let(?g4 :=  uri(fn:concat('http://imeji.org/terms/grant/XXX_NEW_ID_XXX', afn:sha1sum(?user))))};

WITH <http://imeji.org/user>
INSERT{?user <http://imeji.org/terms/grant> ?g
 . ?g <http://imeji.org/terms/grantFor> <XXX_BASE_URI_XXX>
 . ?g <http://imeji.org/terms/grantType> <http://imeji.org/terms/grantType#CREATE>}
USING <http://imeji.org/user>
WHERE {?user a <http://imeji.org/terms/user> .let(?g:= <http://imeji.org/terms/grant/XXX_NEW_ID_XXX>)};