Draft: New: ResponsibleOrganization & ResponsibleInstitution

DO NOT MERGE YET! Compatibility issues with APIv2.

coscine/issues#2446

src/Migrations/Migrations/Migration202307041441ResponsibleOrganization.cs

+using FluentMigrator;
+
+namespace Coscine.Migrations.Migrations
+{
+    //yyyymmddhhmm
+    [Migration(202307041441)]
+    public class Migration202307041441ResponsibleOrganization : Migration
+    {
+        public override void Down()
+        {
+            Execute.EmbeddedScript("Migration202307041441ResponsibleOrganization_down.sql");
+
+            Delete
+                .Column("ResponsibleInstitution")
+                .FromTable("Projects");
+            Delete
+                .Column("ResponsibleOrganization")
+                .FromTable("Projects");
+        }
+
+        public override void Up()
+        {
+            Alter
+                .Table("Projects")
+                .AddColumn("ResponsibleOrganization")
+                .AsString()
+                .Nullable();
+
+            Execute.EmbeddedScript("Migration202307041441ResponsibleOrganization_up.sql");
+
+            Alter
+                .Table("Projects")
+                .AddColumn("ResponsibleInstitution")
+                .AsString()
+                .Nullable();
+
+            Alter
+                .Column("ResponsibleOrganization")
+                .OnTable("Projects")
+                .AsString()
+                .NotNullable();
+        }
+    }
+}