Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
785 B · 14 lines
SQL
at dev
123456789101112131415-- The scripts and dead_letter_scripts tables were created with TIMESTAMPTZ-- columns, but sqlx's AnyPool driver does not support Postgres TIMESTAMPTZ.-- Convert to TEXT to match every other table (see 20260318, 20260325).
-- scriptsALTER TABLE scripts ALTER COLUMN created_at DROP DEFAULT;ALTER TABLE scripts ALTER COLUMN created_at TYPE TEXT USING created_at::text;ALTER TABLE scripts ALTER COLUMN updated_at DROP DEFAULT;ALTER TABLE scripts ALTER COLUMN updated_at TYPE TEXT USING updated_at::text;
-- dead_letter_scriptsALTER TABLE dead_letter_scripts ALTER COLUMN created_at DROP DEFAULT;ALTER TABLE dead_letter_scripts ALTER COLUMN created_at TYPE TEXT USING created_at::text;ALTER TABLE dead_letter_scripts ALTER COLUMN resolved_at TYPE TEXT USING resolved_at::text;