000002_system_settings_table.up.sql

TLDR

This file creates a table called system_settings if it doesn't already exist in the database, with columns id (VARCHAR) and value (TEXT).

CREATE TABLE IF NOT EXISTS {{.prefix}}system_settings (
	id VARCHAR(100),
	value TEXT,
	PRIMARY KEY (id)
) {{if .mysql}}DEFAULT CHARACTER SET utf8mb4{{end}};