Deploy Development / deploy (push) Successful in 22s
Erfassen liegt in Dialogen, Vorgaenge erscheinen als Kacheln in der Akte, und Quellen lassen Dokumente und IMAP-Nachrichten verknuepfen. Co-authored-by: Cursor <cursoragent@cursor.com>
20 lines
797 B
SQL
20 lines
797 B
SQL
ALTER TABLE external_references DROP CONSTRAINT external_references_source;
|
|
ALTER TABLE external_references
|
|
ADD CONSTRAINT external_references_source CHECK (source IN ('paperless', 'url', 'imap'));
|
|
ALTER TABLE external_references
|
|
ADD COLUMN detail jsonb NOT NULL DEFAULT '{}'::jsonb;
|
|
|
|
CREATE TABLE connectors (
|
|
id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
owner_id uuid NOT NULL REFERENCES auth_accounts (id),
|
|
kind text NOT NULL,
|
|
name text NOT NULL,
|
|
settings jsonb NOT NULL,
|
|
secret text NOT NULL,
|
|
created_at timestamptz NOT NULL DEFAULT now(),
|
|
CONSTRAINT connectors_kind CHECK (kind IN ('paperless', 'imap')),
|
|
CONSTRAINT connectors_name_len CHECK (char_length(name) BETWEEN 1 AND 120)
|
|
);
|
|
|
|
CREATE INDEX connectors_owner ON connectors (owner_id, kind);
|