src/main/resources/db/specific/postgresql/V1.4__ActivityPub followers.sql


1
2
3
4
5

CREATE TABLE IF NOT EXISTS followers (
  user_id bigint REFERENCES users(id),
  acct character varying(64) NOT NULL UNIQUE,
  ts timestamp with time zone DEFAULT now() NOT NULL
);