000007_workspaces_table.up.sql
TLDR
This file creates a table named "workspaces" in the database with specific columns and constraints.
Classes (if applicable)
No classes in this file.
Methods (if applicable)
No methods in this file.
CREATE TABLE IF NOT EXISTS {{.prefix}}workspaces (
id VARCHAR(36),
signup_token VARCHAR(100) NOT NULL,
settings {{if .postgres}}JSON{{else}}TEXT{{end}},
modified_by VARCHAR(36),
update_at BIGINT,
PRIMARY KEY (id)
) {{if .mysql}}DEFAULT CHARACTER SET utf8mb4{{end}};