Adding SQL format checking via `pg_format` / pgFormatter (#3740)

[lemmy.git] / migrations / 2020-03-26-192410_add_activitypub_tables / up.sql

diff --git a/migrations/2020-03-26-192410_add_activitypub_tables/up.sql b/migrations/2020-03-26-192410_add_activitypub_tables/up.sql
index 06db580e80dd6c94059f33a0e5475129531dac4d..1359fa4948878bb9e7b6dfe172286ebc1b8d0e2a 100644 (file)
--- a/migrations/2020-03-26-192410_add_activitypub_tables/up.sql
+++ b/migrations/2020-03-26-192410_add_activitypub_tables/up.sql
@@ -1,36 +1,35 @@
 -- The Activitypub activity table
 -- All user actions must create a row here.
-create table activity (
-  id serial primary key,
-  user_id int references user_ on update cascade on delete cascade not null, -- Ensures that the user is set up here.
-  data jsonb not null,
-  local boolean not null default true,
-  published timestamp not null default now(),
-  updated timestamp
+CREATE TABLE activity (
+    id serial PRIMARY KEY,
+    user_id int REFERENCES user_ ON UPDATE CASCADE ON DELETE CASCADE NOT NULL, -- Ensures that the user is set up here.
+    data jsonb NOT NULL,
+    local boolean NOT NULL DEFAULT TRUE,
+    published timestamp NOT NULL DEFAULT now(),
+    updated timestamp
 );
 
 -- Making sure that id is unique
-create unique index idx_activity_unique_apid on activity ((data ->> 'id'::text));
+CREATE UNIQUE INDEX idx_activity_unique_apid ON activity ((data ->> 'id'::text));
 
 -- Add federation columns to the two actor tables
-alter table user_ 
+ALTER TABLE user_
 -- TODO uniqueness constraints should be added on these 3 columns later
-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
-add column public_key text,
-add column last_refreshed_at timestamp not null default now() -- Used to re-fetch federated actor periodically
+    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
+    ADD COLUMN public_key text,
+    ADD COLUMN last_refreshed_at timestamp NOT NULL DEFAULT now() -- Used to re-fetch federated actor periodically
 ;
 
 -- Community
-alter table community 
-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,
-add column last_refreshed_at timestamp not null default now() -- Used to re-fetch federated actor periodically
+ALTER TABLE community
+    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,
+    ADD COLUMN last_refreshed_at timestamp NOT NULL DEFAULT now() -- Used to re-fetch federated actor periodically
 ;
 
 -- Don't worry about rebuilding the views right now.
-