2 ALTER TABLE private_message
3 DROP CONSTRAINT idx_private_message_ap_id;
6 DROP CONSTRAINT idx_post_ap_id;
9 DROP CONSTRAINT idx_comment_ap_id;
12 DROP CONSTRAINT idx_user_actor_id;
15 DROP CONSTRAINT idx_community_actor_id;
17 ALTER TABLE private_message
18 ALTER COLUMN ap_id SET NOT NULL;
20 ALTER TABLE private_message
21 ALTER COLUMN ap_id SET DEFAULT 'http://fake.com';
24 ALTER COLUMN ap_id SET NOT NULL;
27 ALTER COLUMN ap_id SET DEFAULT 'http://fake.com';
30 ALTER COLUMN ap_id SET NOT NULL;
33 ALTER COLUMN ap_id SET DEFAULT 'http://fake.com';
38 ap_id = 'http://fake.com'
40 ap_id LIKE 'changeme_%';
45 ap_id = 'http://fake.com'
47 ap_id LIKE 'changeme_%';
52 ap_id = 'http://fake.com'
54 ap_id LIKE 'changeme_%';