Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
817 B · 21 lines
12345678910111213141516171819202122-- Fix plugin tables to use TEXT instead of TIMESTAMPTZ.-- sqlx's AnyPool does not support native Postgres TIMESTAMPTZ, so all-- timestamp columns must be TEXT with RFC 3339 strings.
-- external_account_tokensALTER TABLE external_account_tokens ALTER COLUMN expires_at TYPE TEXT USING expires_at::text, ALTER COLUMN created_at TYPE TEXT USING created_at::text, ALTER COLUMN updated_at TYPE TEXT USING updated_at::text;
ALTER TABLE external_account_tokens ALTER COLUMN created_at SET DEFAULT '', ALTER COLUMN updated_at SET DEFAULT '';
-- external_auth_stateALTER TABLE external_auth_state ALTER COLUMN created_at TYPE TEXT USING created_at::text, ALTER COLUMN expires_at TYPE TEXT USING expires_at::text;
ALTER TABLE external_auth_state ALTER COLUMN created_at SET DEFAULT '';