000008_teams.up.sql

TLDR

This SQL file contains migration scripts to add new columns to existing tables and update values in the blocks table.

Methods

This file does not contain any methods.

Classes

This file does not contain any classes.

{{- /* addColumnIfNeeded tableName columnName datatype constraint */ -}}
{{ addColumnIfNeeded "blocks" "workspace_id" "varchar(36)" ""}}

{{ addColumnIfNeeded "sharing" "workspace_id" "varchar(36)" ""}}

{{ addColumnIfNeeded "sessions" "auth_service" "varchar(20)" ""}}

UPDATE {{.prefix}}blocks SET workspace_id = '0' WHERE workspace_id = '' OR workspace_id IS NULL;