1 -- Add the admin_purge tables
3 create table admin_purge_person (
5 admin_person_id int references person on update cascade on delete cascade not null,
7 when_ timestamp not null default now()
10 create table admin_purge_community (
11 id serial primary key,
12 admin_person_id int references person on update cascade on delete cascade not null,
14 when_ timestamp not null default now()
17 create table admin_purge_post (
18 id serial primary key,
19 admin_person_id int references person on update cascade on delete cascade not null,
20 community_id int references community on update cascade on delete cascade not null,
22 when_ timestamp not null default now()
25 create table admin_purge_comment (
26 id serial primary key,
27 admin_person_id int references person on update cascade on delete cascade not null,
28 post_id int references post on update cascade on delete cascade not null,
30 when_ timestamp not null default now()