diff options
author | Dessalines <tyhou13@gmx.com> | 2020-06-26 21:12:41 -0400 |
---|---|---|
committer | Dessalines <tyhou13@gmx.com> | 2020-06-26 21:12:41 -0400 |
commit | 86dc50f9f0f6ea98273eb3845d5486d2fad8c1ff (patch) | |
tree | 7925b5768db7fd7c53115d99a40d6bdf638c27ef /server/migrations/2020-03-26-192410_add_activitypub_tables | |
parent | 7d1c6e9a402c14833b94cd33f7f170ffcbc820ed (diff) |
Some fixes to federation.
- Advanced code migrations now disable then re-enable triggers.
Brings run time down to < 15 seconds, no need to thread them.
- Changing ap_ids and actor_ids in migrations to a fake url,
so it doesn't break XsdAnyUri in activitystreams.
Diffstat (limited to 'server/migrations/2020-03-26-192410_add_activitypub_tables')
-rw-r--r-- | server/migrations/2020-03-26-192410_add_activitypub_tables/up.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/server/migrations/2020-03-26-192410_add_activitypub_tables/up.sql b/server/migrations/2020-03-26-192410_add_activitypub_tables/up.sql index 8fe3b8ed..06db580e 100644 --- a/server/migrations/2020-03-26-192410_add_activitypub_tables/up.sql +++ b/server/migrations/2020-03-26-192410_add_activitypub_tables/up.sql @@ -15,7 +15,7 @@ create unique index idx_activity_unique_apid on activity ((data ->> 'id'::text)) -- Add federation columns to the two actor tables alter table user_ -- TODO uniqueness constraints should be added on these 3 columns later -add column actor_id character varying(255) not null default 'changeme', -- This needs to be checked and updated in code, building from the site url if local +add column actor_id character varying(255) not null default 'http://fake.com', -- This needs to be checked and updated in code, building from the site url if local add column bio text, -- not on community, already has description add column local boolean not null default true, add column private_key text, -- These need to be generated from code @@ -25,7 +25,7 @@ add column last_refreshed_at timestamp not null default now() -- Used to re-fetc -- Community alter table community -add column actor_id character varying(255) not null default 'changeme', -- This needs to be checked and updated in code, building from the site url if local +add column actor_id character varying(255) not null default 'http://fake.com', -- This needs to be checked and updated in code, building from the site url if local add column local boolean not null default true, add column private_key text, -- These need to be generated from code add column public_key text, |