000022_create_default_board_role.up.sql

TLDR

This SQL file adds a new column "minimum_role" to the "boards" and "boards_history" tables in a database and updates the values of the "minimum_role" column to 'editor' for any null or empty values.

Methods

N/A

Classes

N/A

{{- /* addColumnIfNeeded tableName columnName datatype constraint */ -}}
{{ addColumnIfNeeded "boards" "minimum_role" "varchar(36)" "NOT NULL DEFAULT ''"}}
{{ addColumnIfNeeded "boards_history" "minimum_role" "varchar(36)" "NOT NULL DEFAULT ''"}}

UPDATE {{.prefix}}boards SET minimum_role = 'editor' WHERE minimum_role IS NULL OR minimum_role='';
UPDATE {{.prefix}}boards_history SET minimum_role = 'editor' WHERE minimum_role IS NULL OR minimum_role='';