Files
descrybe/apps/api/sql/schema/013_company_brand.sql
greeneclipse 8580c996c3 Initial commit of Descrybe v2 without local scratch artifacts.
Drop one-shot tmp/axe scripts and agent i18n scratch so the Gitea tree is deployable.
2026-08-09 22:47:43 +02:00

15 lines
502 B
SQL

-- +goose Up
CREATE TABLE company_brand (
company_id UUID PRIMARY KEY REFERENCES companies(id) ON DELETE CASCADE,
voice_tone TEXT NOT NULL DEFAULT '',
dos TEXT[] NOT NULL DEFAULT '{}',
donts TEXT[] NOT NULL DEFAULT '{}',
primary_color TEXT NOT NULL DEFAULT '',
secondary_color TEXT NOT NULL DEFAULT '',
logo_url TEXT NOT NULL DEFAULT '',
preferred_terms TEXT[] NOT NULL DEFAULT '{}',
updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
);
-- +goose Down
DROP TABLE IF EXISTS company_brand;