protected override void Up(MigrationBuilder migrationBuilder) { dataUtils.AddSqlScripts(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_4_1")); migrationBuilder.AlterColumn <Guid>( name: "PublishingStatusId", schema: "public", table: "StatutoryServiceGeneralDescriptionVersioned", nullable: false, oldClrType: typeof(Guid), oldNullable: true); migrationBuilder.AlterColumn <Guid>( name: "PublishingStatusId", schema: "public", table: "ServiceVersioned", nullable: false, oldClrType: typeof(Guid), oldNullable: true); migrationBuilder.AlterColumn <Guid>( name: "PublishingStatusId", schema: "public", table: "ServiceChannelVersioned", nullable: false, oldClrType: typeof(Guid), oldNullable: true); migrationBuilder.AlterColumn <Guid>( name: "PublishingStatusId", schema: "public", table: "OrganizationVersioned", nullable: false, oldClrType: typeof(Guid), oldNullable: true); }
protected override void Up(MigrationBuilder migrationBuilder) { dataUtils.AddSqlScripts(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_35")); migrationBuilder.DropForeignKey( name: "FK_IndustrialClassName_IndustrialClass_IndustrialClassId", schema: "public", table: "IndustrialClassName"); migrationBuilder.DropForeignKey( name: "FK_LifeEventName_LifeEvent_LifeEventId", schema: "public", table: "LifeEventName"); migrationBuilder.DropForeignKey( name: "FK_OntologyTermName_OntologyTerm_OntologyTermId", schema: "public", table: "OntologyTermName"); migrationBuilder.DropForeignKey( name: "FK_ServiceClassName_ServiceClass_ServiceClassId", schema: "public", table: "ServiceClassName"); migrationBuilder.DropForeignKey( name: "FK_TargetGroupName_TargetGroup_TargetGroupId", schema: "public", table: "TargetGroupName"); migrationBuilder.DropColumn( name: "Name", schema: "public", table: "Municipality"); migrationBuilder.AlterColumn <Guid>( name: "TargetGroupId", schema: "public", table: "TargetGroupName", nullable: false, oldClrType: typeof(Guid), oldNullable: true); migrationBuilder.AlterColumn <string>( name: "Requirement", schema: "public", table: "ServiceRequirement", maxLength: 2500, nullable: true, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AlterColumn <string>( name: "Description", schema: "public", table: "ServiceChannelDescription", maxLength: 2500, nullable: true, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AlterColumn <string>( name: "Description", schema: "public", table: "ServiceDescription", maxLength: 2500, nullable: true, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AlterColumn <Guid>( name: "ServiceClassId", schema: "public", table: "ServiceClassName", nullable: false, oldClrType: typeof(Guid), oldNullable: true); migrationBuilder.AlterColumn <Guid>( name: "OntologyTermId", schema: "public", table: "OntologyTermName", nullable: false, oldClrType: typeof(Guid), oldNullable: true); migrationBuilder.AlterColumn <Guid>( name: "LifeEventId", schema: "public", table: "LifeEventName", nullable: false, oldClrType: typeof(Guid), oldNullable: true); migrationBuilder.AddColumn <int>( name: "Order", schema: "public", table: "Language", nullable: false, defaultValue: 0); migrationBuilder.AlterColumn <Guid>( name: "IndustrialClassId", schema: "public", table: "IndustrialClassName", nullable: false, oldClrType: typeof(Guid), oldNullable: true); migrationBuilder.CreateTable( name: "DigitalAuthorization", schema: "public", columns: table => new { Id = table.Column <Guid>(nullable: false), Code = table.Column <string>(nullable: true), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), Label = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), OntologyType = table.Column <string>(nullable: true), OrderNumber = table.Column <int>(nullable: true), ParentId = table.Column <Guid>(nullable: true), ParentUri = table.Column <string>(nullable: true), Uri = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_DigitalAuthorization", x => x.Id); table.ForeignKey( name: "FK_DigitalAuthorization_DigitalAuthorization_ParentId", column: x => x.ParentId, principalSchema: "public", principalTable: "DigitalAuthorization", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "MunicipalityName", schema: "public", columns: table => new { MunicipalityId = table.Column <Guid>(nullable: false), LocalizationId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), Name = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_MunicipalityName", x => new { x.MunicipalityId, x.LocalizationId }); table.ForeignKey( name: "FK_MunicipalityName_Language_LocalizationId", column: x => x.LocalizationId, principalSchema: "public", principalTable: "Language", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_MunicipalityName_Municipality_MunicipalityId", column: x => x.MunicipalityId, principalSchema: "public", principalTable: "Municipality", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "DigitalAuthorizationName", schema: "public", columns: table => new { Id = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), DigitalAuthorizationId = table.Column <Guid>(nullable: false), LocalizationId = table.Column <Guid>(nullable: false), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), Name = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_DigitalAuthorizationName", x => x.Id); table.ForeignKey( name: "FK_DigitalAuthorizationName_DigitalAuthorization_DigitalAuthorizationId", column: x => x.DigitalAuthorizationId, principalSchema: "public", principalTable: "DigitalAuthorization", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_DigitalAuthorizationName_Language_LocalizationId", column: x => x.LocalizationId, principalSchema: "public", principalTable: "Language", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "ServiceServiceChannelDigitalAuthorization", schema: "public", columns: table => new { DigitalAuthorizationId = table.Column <Guid>(nullable: false), ServiceId = table.Column <Guid>(nullable: false), ServiceChannelId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_ServiceServiceChannelDigitalAuthorization", x => new { x.DigitalAuthorizationId, x.ServiceId, x.ServiceChannelId }); table.ForeignKey( name: "FK_ServiceServiceChannelDigitalAuthorization_DigitalAuthorization_DigitalAuthorizationId", column: x => x.DigitalAuthorizationId, principalSchema: "public", principalTable: "DigitalAuthorization", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelDigitalAuthorization_ServiceServiceChannel_ServiceId_ServiceChannelId", columns: x => new { x.ServiceId, x.ServiceChannelId }, principalSchema: "public", principalTable: "ServiceServiceChannel", principalColumns: new[] { "ServiceId", "ServiceChannelId" }, onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_DigitalAuthorization_Id", schema: "public", table: "DigitalAuthorization", column: "Id"); migrationBuilder.CreateIndex( name: "IX_DigitalAuthorization_ParentId", schema: "public", table: "DigitalAuthorization", column: "ParentId"); migrationBuilder.CreateIndex( name: "IX_DigitalAuthorizationName_DigitalAuthorizationId", schema: "public", table: "DigitalAuthorizationName", column: "DigitalAuthorizationId"); migrationBuilder.CreateIndex( name: "IX_DigitalAuthorizationName_Id", schema: "public", table: "DigitalAuthorizationName", column: "Id"); migrationBuilder.CreateIndex( name: "IX_DigitalAuthorizationName_LocalizationId", schema: "public", table: "DigitalAuthorizationName", column: "LocalizationId"); migrationBuilder.CreateIndex( name: "IX_MunicipalityName_LocalizationId", schema: "public", table: "MunicipalityName", column: "LocalizationId"); migrationBuilder.CreateIndex( name: "IX_MunicipalityName_MunicipalityId", schema: "public", table: "MunicipalityName", column: "MunicipalityId"); migrationBuilder.CreateIndex( name: "IX_ServiceServiceChannelDigitalAuthorization_DigitalAuthorizationId", schema: "public", table: "ServiceServiceChannelDigitalAuthorization", column: "DigitalAuthorizationId"); migrationBuilder.CreateIndex( name: "IX_ServiceServiceChannelDigitalAuthorization_ServiceId_ServiceChannelId", schema: "public", table: "ServiceServiceChannelDigitalAuthorization", columns: new[] { "ServiceId", "ServiceChannelId" }); migrationBuilder.AddForeignKey( name: "FK_IndustrialClassName_IndustrialClass_IndustrialClassId", schema: "public", table: "IndustrialClassName", column: "IndustrialClassId", principalSchema: "public", principalTable: "IndustrialClass", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_LifeEventName_LifeEvent_LifeEventId", schema: "public", table: "LifeEventName", column: "LifeEventId", principalSchema: "public", principalTable: "LifeEvent", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_OntologyTermName_OntologyTerm_OntologyTermId", schema: "public", table: "OntologyTermName", column: "OntologyTermId", principalSchema: "public", principalTable: "OntologyTerm", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_ServiceClassName_ServiceClass_ServiceClassId", schema: "public", table: "ServiceClassName", column: "ServiceClassId", principalSchema: "public", principalTable: "ServiceClass", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_TargetGroupName_TargetGroup_TargetGroupId", schema: "public", table: "TargetGroupName", column: "TargetGroupId", principalSchema: "public", principalTable: "TargetGroup", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }