1 create table activity (
4 local boolean not null default true,
5 published timestamp not null default now(),
8 sensitive boolean not null default true
11 insert into activity(ap_id, data, sensitive, published)
12 select ap_id, data, sensitive, published
17 -- We cant copy received_activity entries back into activities table because we dont have data
18 -- which is mandatory.
20 drop table sent_activity;
21 drop table received_activity;