about summary refs log tree commit diff
path: root/migrations/2018-04-08-182319_add_authors/up.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/2018-04-08-182319_add_authors/up.sql')
-rw-r--r--migrations/2018-04-08-182319_add_authors/up.sql10
1 files changed, 0 insertions, 10 deletions
diff --git a/migrations/2018-04-08-182319_add_authors/up.sql b/migrations/2018-04-08-182319_add_authors/up.sql
deleted file mode 100644
index ad5beb9f67..0000000000
--- a/migrations/2018-04-08-182319_add_authors/up.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- This migration adds an 'author' column to the thread & post table.
--- Authors don't currently exist as independent objects in the
--- database as most user management is simply delegated to the OIDC
--- provider.
-
-ALTER TABLE threads ADD COLUMN author_name VARCHAR NOT NULL DEFAULT 'anonymous';
-ALTER TABLE threads ADD COLUMN author_email VARCHAR NOT NULL DEFAULT 'unknown@example.org';
-
-ALTER TABLE posts ADD COLUMN author_name VARCHAR NOT NULL DEFAULT 'anonymous';
-ALTER TABLE posts ADD COLUMN author_email VARCHAR NOT NULL DEFAULT 'unknown@example.org';