000029_add_category_type_field.up.sql

TLDR

This file adds a new column called "type" to the "categories" table in the database. It sets the default value of the "type" column to 'custom' for any existing rows that have a NULL value for the "type" column.

{{- /* addColumnIfNeeded tableName columnName datatype constraint */ -}}
{{ addColumnIfNeeded "categories" "type" "varchar(64)" ""}}

UPDATE {{.prefix}}categories SET type = 'custom' WHERE type IS NULL;