Files
tsumugu/backend/migrations/20261017T080000Z_content_order.sql
LarsandCursor 52bda91aad
Deploy Development / deploy (push) Successful in 22s
Test Suite / pytest-backend (push) Successful in 51s
Test Suite / smoke-dev (push) Successful in 1s
Test Suite / frontend-build (push) Successful in 6s
Ordne Akten und Vorgaenge nach fachlichem Datum oder eigener Reihenfolge und mache den Inhalt zur Arbeitsansicht.
Co-authored-by: Cursor <cursoragent@cursor.com>
2026-10-17 09:36:48 +02:00

16 lines
683 B
SQL

ALTER TABLE cases
ADD COLUMN content_order text NOT NULL DEFAULT 'position',
ADD COLUMN content_order_dir text NOT NULL DEFAULT 'asc';
ALTER TABLE cases
ADD CONSTRAINT cases_content_order CHECK (content_order IN ('date', 'position')),
ADD CONSTRAINT cases_content_order_dir CHECK (content_order_dir IN ('asc', 'desc'));
ALTER TABLE matters
ADD COLUMN content_order text NOT NULL DEFAULT 'position',
ADD COLUMN content_order_dir text NOT NULL DEFAULT 'asc';
ALTER TABLE matters
ADD CONSTRAINT matters_content_order CHECK (content_order IN ('date', 'position')),
ADD CONSTRAINT matters_content_order_dir CHECK (content_order_dir IN ('asc', 'desc'));