19 lines
691 B
MySQL
19 lines
691 B
MySQL
|
-- Per-user Tandoor connection (URL + API token). Not a system-wide connector.
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS profile_tandoor_settings (
|
||
|
|
profile_id UUID PRIMARY KEY REFERENCES profiles(id) ON DELETE CASCADE,
|
||
|
|
base_url VARCHAR(300) NOT NULL,
|
||
|
|
api_token TEXT NOT NULL,
|
||
|
|
last_ok_at TIMESTAMPTZ,
|
||
|
|
last_error TEXT,
|
||
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
|
||
|
|
);
|
||
|
|
|
||
|
|
COMMENT ON TABLE profile_tandoor_settings IS 'Persönliche Tandoor-API (Familie); Token nie systemweit';
|
||
|
|
COMMENT ON COLUMN profile_tandoor_settings.api_token IS 'Tandoor Access Token; nur Backend, nie im JSON-Export';
|
||
|
|
|
||
|
|
DO $$
|
||
|
|
BEGIN
|
||
|
|
RAISE NOTICE 'Migration 067: profile_tandoor_settings';
|
||
|
|
END $$;
|