websub-hub/db/04_timestamptz.sql
Peter Stuifzand 9ce5f6e6c6
All checks were successful
continuous-integration/drone/push Build is passing
Delete expired subscribers
2021-10-21 22:50:13 +02:00

5 lines
162 B
SQL

ALTER TABLE "subscribers"
ALTER COLUMN "created" TYPE timestamptz,
ALTER COLUMN "updated" TYPE timestamptz,
ADD COLUMN "last_subscribed" timestamptz;