# HG changeset patch # User jbe # Date 1581363190 -3600 # Node ID 617ac1725557abefb02d8c80523364322a471bdf # Parent 9570aeabf4fc75a1270aaee7a868e4d0a2a5c3e7 Removed column "content_type" from table "draft_attachment" (Content type is stored in "file" table instead) diff -r 9570aeabf4fc -r 617ac1725557 core.sql --- a/core.sql Fri Feb 07 10:52:37 2020 +0100 +++ b/core.sql Mon Feb 10 20:33:10 2020 +0100 @@ -1018,7 +1018,6 @@ "id" SERIAL8 PRIMARY KEY, "draft_id" INT8 REFERENCES "draft" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "file_id" INT8 REFERENCES "file" ("id") ON DELETE RESTRICT ON UPDATE CASCADE, - "content_type" TEXT, "title" TEXT, "description" TEXT ); diff -r 9570aeabf4fc -r 617ac1725557 update/core-update.v4.1.0-v4.2.0.sql --- a/update/core-update.v4.1.0-v4.2.0.sql Fri Feb 07 10:52:37 2020 +0100 +++ b/update/core-update.v4.1.0-v4.2.0.sql Mon Feb 10 20:33:10 2020 +0100 @@ -97,7 +97,6 @@ "id" SERIAL8 PRIMARY KEY, "draft_id" INT8 REFERENCES "draft" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "file_id" INT8 REFERENCES "file" ("id") ON DELETE RESTRICT ON UPDATE CASCADE, - "content_type" TEXT, "title" TEXT, "description" TEXT );