Commit5e44303

committed

migrate existing templates

1 parentc5ecbf4 commit5e44303Copy full SHA for 5e44303

File tree

+26

-0

lines changed

+26

-0

lines changed

Lines changed: 26 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -19,4 +19,30 @@ CREATE TABLE group_members (`
`19`	`19`	`UNIQUE(user_id, group_id)`
`20`	`20`	`);`
`21`	`21`
	`22`	`+-- Insert a group for every organization (which should just be 1).`
	`23`	`+INSERT INTO groups (`
	`24`	`+id,`
	`25`	`+name,`
	`26`	`+organization_id`
	`27`	`+)SELECT`
	`28`	`+id,'allUsers'as name, id`
	`29`	`+FROM`
	`30`	`+organizations;`
	`31`	`+`
	`32`	`+-- Insert allUsers groups into every existing template to avoid breaking`
	`33`	`+-- existing deployments.`
	`34`	`+UPDATE`
	`35`	`+templates`
	`36`	`+SET`
	`37`	`+group_acl= (`
	`38`	`+SELECT`
	`39`	`+json_build_object(`
	`40`	`+organizations.id, array_to_json('{"read"}'::text[])`
	`41`	`+)`
	`42`	`+FROM`
	`43`	`+organizations`
	`44`	`+WHERE`
	`45`	`+templates.organization_id=organizations.id`
	`46`	`+);`
	`47`	`+`
`22`	`48`	`COMMIT;`

Comments

(0)