2 alter table community alter column actor_id set not null;
3 alter table community alter column actor_id set default 'http://fake.com';
4 alter table user_ alter column actor_id set not null;
5 alter table user_ alter column actor_id set default 'http://fake.com';
7 drop function generate_unique_changeme;
10 set actor_id = 'http://fake.com'
11 where actor_id like 'changeme_%';
14 set actor_id = 'http://fake.com'
15 where actor_id like 'changeme_%';
17 drop index idx_user_lower_actor_id;
18 create unique index idx_user_name_lower_actor_id on user_ (lower(name), lower(actor_id));
20 drop index idx_community_lower_actor_id;