9 lines
324 B
SQL
9 lines
324 B
SQL
SET search_path TO atlas, public;
|
|
|
|
ALTER TABLE watermark_templates
|
|
ADD COLUMN IF NOT EXISTS is_default BOOLEAN NOT NULL DEFAULT false;
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS ux_watermark_templates_workspace_default
|
|
ON watermark_templates (workspace_id)
|
|
WHERE is_default AND status = 'active' AND deleted_at IS NULL;
|