ForgeFlux/migrations/20241021065709_ap_person_objects.sql

8 lines
286 B
SQL

--- Add migration script here
CREATE TABLE IF NOT EXISTS ap_person_objects (
readable TEXT[][] NOT NULL, -- public/specific-actor
activity INTEGER REFERENCES ap_objects (ID) NOT NULL,
person_id INTEGER REFERENCES persons (ID) NOT NULL,
ID SERIAL PRIMARY KEY NOT NULL
);