public void Up(MigrationBuilder migrationBuilder) { dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_4_5", "Fixed", "6ServiceMunicipality.sql")); migrationBuilder.DropForeignKey( name: "FK_Service_ServiceCoverageType_ServiceCoverageTypeId", schema: "public", table: "ServiceVersioned"); migrationBuilder.DropTable( name: "ServiceCoverageTypeName", schema: "public"); migrationBuilder.DropTable( name: "ServiceMunicipality", schema: "public"); migrationBuilder.DropTable( name: "ServiceCoverageType", schema: "public"); migrationBuilder.DropIndex( name: "IX_Ser_ServiceCoverageTypeId", schema: "public", table: "ServiceVersioned"); migrationBuilder.DropColumn( name: "ServiceCoverageTypeId", schema: "public", table: "ServiceVersioned"); }
public void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn <Guid>( name: "OrganizationId", schema: "public", table: "ServiceVersioned", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); migrationBuilder.CreateIndex( name: "IX_SerVer_OrganizationId", schema: "public", table: "ServiceVersioned", column: "OrganizationId"); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_6", "2ServiceResponsibleOrganization.sql")); migrationBuilder.AddForeignKey( name: "FK_ServiceVersioned_Organization_OrganizationId", schema: "public", table: "ServiceVersioned", column: "OrganizationId", principalSchema: "public", principalTable: "Organization", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
public void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "PostOfficeBoxName", schema: "public", columns: table => new { Id = table.Column <Guid>(nullable: false), AddressId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LocalizationId = table.Column <Guid>(nullable: false), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), Text = table.Column <string>(maxLength: 100, nullable: true) }, constraints: table => { table.PrimaryKey("PK_PostOfficeBoxName", x => x.Id); table.ForeignKey( name: "FK_PostOfficeBoxName_Address_AddressId", column: x => x.AddressId, principalSchema: "public", principalTable: "Address", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_PostOfficeBoxName_Language_LocalizationId", column: x => x.LocalizationId, principalSchema: "public", principalTable: "Language", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_PosOffBoxNam_AddressId", schema: "public", table: "PostOfficeBoxName", column: "AddressId"); migrationBuilder.CreateIndex( name: "IX_PosOffBoxNam_Id", schema: "public", table: "PostOfficeBoxName", column: "Id"); migrationBuilder.CreateIndex( name: "IX_PosOffBoxNam_LocalizationId", schema: "public", table: "PostOfficeBoxName", column: "LocalizationId"); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_4_5", "Fixed", "1PostOfficeBoxName.sql")); migrationBuilder.DropColumn( name: "PostOfficeBox", schema: "public", table: "Address"); }
public void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn <int>( name: "OrderNumber", schema: "public", table: "ServiceChannelServiceHours", nullable: true); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_5", "4ServiceHoursOrder.sql")); }
public void Up(MigrationBuilder migrationBuilder) { migrationBuilder.Sql(@"DELETE FROM ""UserOrganization"" WHERE (""OrganizationId"" IS NULL) OR (""OrganizationId"" = '00000000-0000-0000-0000-000000000000') OR (""OrganizationId"" NOT IN (SELECT ""Id"" FROM ""Organization""))"); migrationBuilder.DropForeignKey( name: "FK_UserOrganization_Organization_OrganizationId", schema: "public", table: "UserOrganization"); migrationBuilder.DropColumn( name: "RelationId", schema: "public", table: "UserOrganization"); migrationBuilder.DropColumn( name: "UserName", schema: "public", table: "UserOrganization"); migrationBuilder.AlterColumn <Guid>( name: "OrganizationId", schema: "public", table: "UserOrganization", nullable: false, oldClrType: typeof(Guid), oldNullable: true); migrationBuilder.AddColumn <bool>( name: "IsMain", schema: "public", table: "UserOrganization", nullable: false, defaultValue: false); migrationBuilder.AddColumn <Guid>( name: "RoleId", schema: "public", table: "UserOrganization", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); migrationBuilder.AddForeignKey( name: "FK_UserOrganization_Organization_OrganizationId", schema: "public", table: "UserOrganization", column: "OrganizationId", principalSchema: "public", principalTable: "Organization", principalColumn: "Id", onDelete: ReferentialAction.Cascade); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_5_5", "FK_ServiceServiceChannel.sql")); }
public void Up(MigrationBuilder migrationBuilder) { dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_4_5", "Fixed", "7ServiceLocationChannelServiceAreas.sql")); migrationBuilder.DropTable( name: "ServiceLocationChannelServiceArea", schema: "public"); migrationBuilder.DropColumn( name: "ServiceAreaRestricted", schema: "public", table: "ServiceLocationChannel"); }
public void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "ServiceWebPage", schema: "public", columns: table => new { ServiceVersionedId = table.Column <Guid>(nullable: false), WebPageId = 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_ServiceWebPage", x => new { x.ServiceVersionedId, x.WebPageId }); table.ForeignKey( name: "FK_ServiceWebPage_ServiceVersioned_ServiceVersionedId", column: x => x.ServiceVersionedId, principalSchema: "public", principalTable: "ServiceVersioned", principalColumn: "Id", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_ServiceWebPage_WebPage_WebPageId", column: x => x.WebPageId, principalSchema: "public", principalTable: "WebPage", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_5", "3ServiceVoucher.sql")); migrationBuilder.CreateIndex( name: "IX_ServiceWebPage_ServiceVersionedId", schema: "public", table: "ServiceWebPage", column: "ServiceVersionedId"); migrationBuilder.CreateIndex( name: "IX_ServiceWebPage_WebPageId", schema: "public", table: "ServiceWebPage", column: "WebPageId"); }
public void Up(MigrationBuilder migrationBuilder) { dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_5", "1ServiceServiceChannelChanges.sql")); migrationBuilder.CreateIndex( name: "IX_ServiceServiceChannel_ServiceId", schema: "public", table: "ServiceServiceChannel", column: "ServiceId"); migrationBuilder.AddForeignKey( name: "FK_ServiceServiceChannel_Service_ServiceId", schema: "public", table: "ServiceServiceChannel", column: "ServiceId", principalSchema: "public", principalTable: "Service", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
public void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropPrimaryKey( name: "PK_DailyOpeningTime", schema: "public", table: "DailyOpeningTime"); migrationBuilder.DropIndex( name: "IX_DaiOpeTim_OpeningHourId_DayFrom_IsExtra", schema: "public", table: "DailyOpeningTime"); migrationBuilder.AddColumn <int>( name: "Order", schema: "public", table: "DailyOpeningTime", nullable: false, defaultValue: 0); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_7", "3OpenningHoursPKchange.sql")); migrationBuilder.DropColumn( name: "IsExtra", schema: "public", table: "DailyOpeningTime"); migrationBuilder.AddPrimaryKey( name: "PK_DailyOpeningTime", schema: "public", table: "DailyOpeningTime", columns: new[] { "OpeningHourId", "DayFrom", "Order" }); migrationBuilder.CreateIndex( name: "IX_DaiOpeTim_OpeningHourId_DayFrom_Order", schema: "public", table: "DailyOpeningTime", columns: new[] { "OpeningHourId", "DayFrom", "Order" }); }
public void Up(MigrationBuilder migrationBuilder) { dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_5", "5KeywordMaxLengthRule.sql")); }
public void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "ServiceHours", schema: "public", columns: table => new { Id = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), IsClosed = table.Column <bool>(nullable: false), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), OpeningHoursFrom = table.Column <DateTime>(nullable: true), OpeningHoursTo = table.Column <DateTime>(nullable: true), OrderNumber = table.Column <int>(nullable: true), ServiceHourTypeId = table.Column <Guid>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_ServiceHours", x => x.Id); table.ForeignKey( name: "FK_ServiceHours_ServiceHourType_ServiceHourTypeId", column: x => x.ServiceHourTypeId, principalSchema: "public", principalTable: "ServiceHourType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_7", "2ServiceHours.sql")); migrationBuilder.DropForeignKey( name: "FK_DailyOpeningTime_ServiceChannelServiceHours_OpeningHourId", schema: "public", table: "DailyOpeningTime"); migrationBuilder.DropForeignKey( name: "FK_ServiceChannelServiceHours_ServiceHourType_ServiceHourTypeId", schema: "public", table: "ServiceChannelServiceHours"); migrationBuilder.DropForeignKey( name: "FK_ServiceHoursAdditionalInformation_ServiceChannelServiceHours_ServiceChannelServiceHoursId", schema: "public", table: "ServiceHoursAdditionalInformation"); migrationBuilder.DropPrimaryKey( name: "PK_ServiceChannelServiceHours", schema: "public", table: "ServiceChannelServiceHours"); migrationBuilder.DropIndex( name: "IX_SerChaSerHou_Id", schema: "public", table: "ServiceChannelServiceHours"); migrationBuilder.DropColumn( name: "ServiceHourTypeId", schema: "public", table: "ServiceChannelServiceHours"); migrationBuilder.DropColumn( name: "IsClosed", schema: "public", table: "ServiceChannelServiceHours"); migrationBuilder.DropColumn( name: "OpeningHoursFrom", schema: "public", table: "ServiceChannelServiceHours"); migrationBuilder.DropColumn( name: "OpeningHoursTo", schema: "public", table: "ServiceChannelServiceHours"); migrationBuilder.DropColumn( name: "OrderNumber", schema: "public", table: "ServiceChannelServiceHours"); migrationBuilder.RenameColumn( name: "ServiceChannelServiceHoursId", schema: "public", table: "ServiceHoursAdditionalInformation", newName: "ServiceHoursId"); migrationBuilder.RenameIndex( name: "IX_SerHouAddInf_ServiceChannelServiceHoursId", schema: "public", table: "ServiceHoursAdditionalInformation", newName: "IX_SerHouAddInf_ServiceHoursId"); migrationBuilder.RenameColumn( name: "Id", schema: "public", table: "ServiceChannelServiceHours", newName: "ServiceHoursId"); migrationBuilder.AddPrimaryKey( name: "PK_ServiceChannelServiceHours", schema: "public", table: "ServiceChannelServiceHours", columns: new[] { "ServiceChannelVersionedId", "ServiceHoursId" }); migrationBuilder.CreateTable( name: "ServiceServiceChannelAddress", schema: "public", columns: table => new { ServiceId = table.Column <Guid>(nullable: false), ServiceChannelId = table.Column <Guid>(nullable: false), AddressId = table.Column <Guid>(nullable: false), CharacterId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_ServiceServiceChannelAddress", x => new { x.ServiceId, x.ServiceChannelId, x.AddressId }); table.ForeignKey( name: "FK_ServiceServiceChannelAddress_Address_AddressId", column: x => x.AddressId, principalSchema: "public", principalTable: "Address", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelAddress_AddressCharacter_CharacterId", column: x => x.CharacterId, principalSchema: "public", principalTable: "AddressCharacter", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelAddress_ServiceChannel_ServiceChannelId", column: x => x.ServiceChannelId, principalSchema: "public", principalTable: "ServiceChannel", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelAddress_Service_ServiceId", column: x => x.ServiceId, principalSchema: "public", principalTable: "Service", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "ServiceServiceChannelEmail", schema: "public", columns: table => new { ServiceId = table.Column <Guid>(nullable: false), ServiceChannelId = table.Column <Guid>(nullable: false), EmailId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_ServiceServiceChannelEmail", x => new { x.ServiceId, x.ServiceChannelId, x.EmailId }); table.ForeignKey( name: "FK_ServiceServiceChannelEmail_Email_EmailId", column: x => x.EmailId, principalSchema: "public", principalTable: "Email", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelEmail_ServiceChannel_ServiceChannelId", column: x => x.ServiceChannelId, principalSchema: "public", principalTable: "ServiceChannel", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelEmail_Service_ServiceId", column: x => x.ServiceId, principalSchema: "public", principalTable: "Service", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "ServiceServiceChannelPhone", schema: "public", columns: table => new { ServiceId = table.Column <Guid>(nullable: false), ServiceChannelId = table.Column <Guid>(nullable: false), PhoneId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_ServiceServiceChannelPhone", x => new { x.ServiceId, x.ServiceChannelId, x.PhoneId }); table.ForeignKey( name: "FK_ServiceServiceChannelPhone_Phone_PhoneId", column: x => x.PhoneId, principalSchema: "public", principalTable: "Phone", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelPhone_ServiceChannel_ServiceChannelId", column: x => x.ServiceChannelId, principalSchema: "public", principalTable: "ServiceChannel", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelPhone_Service_ServiceId", column: x => x.ServiceId, principalSchema: "public", principalTable: "Service", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "ServiceServiceChannelWebPage", schema: "public", columns: table => new { ServiceId = table.Column <Guid>(nullable: false), ServiceChannelId = table.Column <Guid>(nullable: false), WebPageId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_ServiceServiceChannelWebPage", x => new { x.ServiceId, x.ServiceChannelId, x.WebPageId }); table.ForeignKey( name: "FK_ServiceServiceChannelWebPage_ServiceChannel_ServiceChannelId", column: x => x.ServiceChannelId, principalSchema: "public", principalTable: "ServiceChannel", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelWebPage_Service_ServiceId", column: x => x.ServiceId, principalSchema: "public", principalTable: "Service", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelWebPage_WebPage_WebPageId", column: x => x.WebPageId, principalSchema: "public", principalTable: "WebPage", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "ServiceServiceChannelServiceHours", schema: "public", columns: table => new { ServiceId = table.Column <Guid>(nullable: false), ServiceChannelId = table.Column <Guid>(nullable: false), ServiceHoursId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_ServiceServiceChannelServiceHours", x => new { x.ServiceId, x.ServiceChannelId, x.ServiceHoursId }); table.ForeignKey( name: "FK_ServiceServiceChannelServiceHours_ServiceChannel_ServiceChannelId", column: x => x.ServiceChannelId, principalSchema: "public", principalTable: "ServiceChannel", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelServiceHours_ServiceHours_ServiceHoursId", column: x => x.ServiceHoursId, principalSchema: "public", principalTable: "ServiceHours", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceServiceChannelServiceHours_Service_ServiceId", column: x => x.ServiceId, principalSchema: "public", principalTable: "Service", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_SerHou_Id", schema: "public", table: "ServiceHours", column: "Id"); migrationBuilder.CreateIndex( name: "IX_SerHou_ServiceHourTypeId", schema: "public", table: "ServiceHours", column: "ServiceHourTypeId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaAdd_AddressId", schema: "public", table: "ServiceServiceChannelAddress", column: "AddressId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaAdd_CharacterId", schema: "public", table: "ServiceServiceChannelAddress", column: "CharacterId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaAdd_ServiceChannelId", schema: "public", table: "ServiceServiceChannelAddress", column: "ServiceChannelId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaAdd_ServiceId", schema: "public", table: "ServiceServiceChannelAddress", column: "ServiceId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaEma_EmailId", schema: "public", table: "ServiceServiceChannelEmail", column: "EmailId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaEma_ServiceChannelId", schema: "public", table: "ServiceServiceChannelEmail", column: "ServiceChannelId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaEma_ServiceId", schema: "public", table: "ServiceServiceChannelEmail", column: "ServiceId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaPho_PhoneId", schema: "public", table: "ServiceServiceChannelPhone", column: "PhoneId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaPho_ServiceChannelId", schema: "public", table: "ServiceServiceChannelPhone", column: "ServiceChannelId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaPho_ServiceId", schema: "public", table: "ServiceServiceChannelPhone", column: "ServiceId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaSerHou_ServiceChannelId", schema: "public", table: "ServiceServiceChannelServiceHours", column: "ServiceChannelId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaSerHou_ServiceHoursId", schema: "public", table: "ServiceServiceChannelServiceHours", column: "ServiceHoursId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaSerHou_ServiceId", schema: "public", table: "ServiceServiceChannelServiceHours", column: "ServiceId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaWebPag_ServiceChannelId", schema: "public", table: "ServiceServiceChannelWebPage", column: "ServiceChannelId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaWebPag_ServiceId", schema: "public", table: "ServiceServiceChannelWebPage", column: "ServiceId"); migrationBuilder.CreateIndex( name: "IX_SerSerChaWebPag_WebPageId", schema: "public", table: "ServiceServiceChannelWebPage", column: "WebPageId"); migrationBuilder.AddForeignKey( name: "FK_DailyOpeningTime_ServiceHours_OpeningHourId", schema: "public", table: "DailyOpeningTime", column: "OpeningHourId", principalSchema: "public", principalTable: "ServiceHours", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_ServiceChannelServiceHours_ServiceHours_ServiceHoursId", schema: "public", table: "ServiceChannelServiceHours", column: "ServiceHoursId", principalSchema: "public", principalTable: "ServiceHours", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_ServiceHoursAdditionalInformation_ServiceHours_ServiceHoursId", schema: "public", table: "ServiceHoursAdditionalInformation", column: "ServiceHoursId", principalSchema: "public", principalTable: "ServiceHours", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
public void Up(MigrationBuilder migrationBuilder) { dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_6", "4QuartzInit.sql")); }
public void Up(MigrationBuilder migrationBuilder) { dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_4_5", "Fixed", "2AreaInformationType.sql")); migrationBuilder.CreateTable( name: "AreaInformationType", 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), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), OrderNumber = table.Column <int>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_AreaInformationType", x => x.Id); }); migrationBuilder.AddColumn <Guid>( name: "AreaInformationTypeId", schema: "public", table: "OrganizationVersioned", nullable: false, defaultValueSql: @"GetOrCreateDefaultAreaInformationTypeId('WholeCountry')" ); migrationBuilder.CreateTable( name: "AreaInformationTypeName", schema: "public", columns: table => new { Id = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LocalizationId = table.Column <Guid>(nullable: false), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), Name = table.Column <string>(nullable: true), TypeId = table.Column <Guid>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_AreaInformationTypeName", x => x.Id); table.ForeignKey( name: "FK_AreaInformationTypeName_Language_LocalizationId", column: x => x.LocalizationId, principalSchema: "public", principalTable: "Language", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_AreaInformationTypeName_AreaInformationType_TypeId", column: x => x.TypeId, principalSchema: "public", principalTable: "AreaInformationType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_OrgVer_AreaInformationTypeId", schema: "public", table: "OrganizationVersioned", column: "AreaInformationTypeId"); migrationBuilder.CreateIndex( name: "IX_AreInfTyp_Id", schema: "public", table: "AreaInformationType", column: "Id"); migrationBuilder.CreateIndex( name: "IX_AreInfTypNam_Id", schema: "public", table: "AreaInformationTypeName", column: "Id"); migrationBuilder.CreateIndex( name: "IX_AreInfTypNam_LocalizationId", schema: "public", table: "AreaInformationTypeName", column: "LocalizationId"); migrationBuilder.CreateIndex( name: "IX_AreInfTypNam_TypeId", schema: "public", table: "AreaInformationTypeName", column: "TypeId"); migrationBuilder.AddForeignKey( name: "FK_OrganizationVersioned_AreaInformationType_AreaInformationTypeId", schema: "public", table: "OrganizationVersioned", column: "AreaInformationTypeId", principalSchema: "public", principalTable: "AreaInformationType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
public void Up(MigrationBuilder migrationBuilder) { dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_7", "4UpdateDeliveryAddressNoAddress.sql")); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_OrganizationType_OrganizationType_ParentTypeId", schema: "public", table: "OrganizationType"); migrationBuilder.DropForeignKey( name: "FK_OrganizationTypeName_OrganizationType_TypeId", schema: "public", table: "OrganizationTypeName"); migrationBuilder.RenameColumn( name: "TypeId", schema: "public", table: "OrganizationTypeName", newName: "OrganizationTypeId"); migrationBuilder.RenameIndex( name: "IX_OrgTypNam_TypeId", schema: "public", table: "OrganizationTypeName", newName: "IX_OrgTypNam_OrganizationTypeId"); migrationBuilder.RenameColumn( name: "ParentTypeId", schema: "public", table: "OrganizationType", newName: "ParentId"); migrationBuilder.RenameIndex( name: "IX_OrgTyp_ParentTypeId", schema: "public", table: "OrganizationType", newName: "IX_OrgTyp_ParentId"); migrationBuilder.AddColumn <string>( name: "Label", schema: "public", table: "OrganizationType", nullable: true); migrationBuilder.AddColumn <string>( name: "OntologyType", schema: "public", table: "OrganizationType", nullable: true); migrationBuilder.AddColumn <string>( name: "ParentUri", schema: "public", table: "OrganizationType", nullable: true); migrationBuilder.AddColumn <string>( name: "Uri", schema: "public", table: "OrganizationType", nullable: true); migrationBuilder.AddForeignKey( name: "FK_OrganizationType_OrganizationType_ParentId", schema: "public", table: "OrganizationType", column: "ParentId", principalSchema: "public", principalTable: "OrganizationType", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_OrganizationTypeName_OrganizationType_OrganizationTypeId", schema: "public", table: "OrganizationTypeName", column: "OrganizationTypeId", principalSchema: "public", principalTable: "OrganizationType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_4", "Fixed", "4OrganizationTypeUriSetting.sql")); }
public void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "OrganizationServiceWebPage", schema: "public"); migrationBuilder.DropForeignKey( name: "FK_OrganizationServiceAdditionalInformation_OrganizationService", schema: "public", table: "OrganizationServiceAdditionalInformation"); migrationBuilder.DropForeignKey( name: "FK_OrganizationService_ProvisionType_ProvisionTypeId", schema: "public", table: "OrganizationService"); migrationBuilder.DropForeignKey( name: "FK_OrganizationService_RoleType_RoleTypeId", schema: "public", table: "OrganizationService"); migrationBuilder.DropPrimaryKey( name: "PK_OrganizationService", schema: "public", table: "OrganizationService"); migrationBuilder.DropIndex( name: "IX_OrgSer_Id", schema: "public", table: "OrganizationService"); migrationBuilder.DropIndex( name: "IX_OrgSer_ProvisionTypeId", schema: "public", table: "OrganizationService"); migrationBuilder.DropIndex( name: "IX_OrgSer_RoleTypeId", schema: "public", table: "OrganizationService"); migrationBuilder.CreateTable( name: "ServiceProducer", schema: "public", columns: table => new { Id = 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), ProvisionTypeId = table.Column <Guid>(nullable: false), ServiceVersionedId = table.Column <Guid>(nullable: false), LastOperationId = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_ServiceProducer", x => x.Id); table.ForeignKey( name: "FK_ServiceProducer_ProvisionType_ProvisionTypeId", column: x => x.ProvisionTypeId, principalSchema: "public", principalTable: "ProvisionType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceProducer_ServiceVersioned_ServiceVersionedId", column: x => x.ServiceVersionedId, principalSchema: "public", principalTable: "ServiceVersioned", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_ServiceProducer_Id", schema: "public", table: "ServiceProducer", column: "Id"); migrationBuilder.CreateIndex( name: "IX_ServiceProducer_ProvisionTypeId", schema: "public", table: "ServiceProducer", column: "ProvisionTypeId"); migrationBuilder.CreateIndex( name: "IX_ServiceProducer_ServiceVersionedId", schema: "public", table: "ServiceProducer", column: "ServiceVersionedId"); migrationBuilder.CreateTable( name: "ServiceProducerOrganization", schema: "public", columns: table => new { OrganizationId = table.Column <Guid>(nullable: false), ServiceProducerId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_ServiceProducerOrganization", x => new { x.OrganizationId, x.ServiceProducerId }); table.ForeignKey( name: "FK_ServiceProducerOrganization_Organization_OrganizationId", column: x => x.OrganizationId, principalSchema: "public", principalTable: "Organization", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceProducerOrganization_ServiceProducer_ServiceProducerId", column: x => x.ServiceProducerId, principalSchema: "public", principalTable: "ServiceProducer", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_SerProOrg_OrganizationId", schema: "public", table: "ServiceProducerOrganization", column: "OrganizationId"); migrationBuilder.CreateIndex( name: "IX_SerProOrg_ServiceProducerId", schema: "public", table: "ServiceProducerOrganization", column: "ServiceProducerId"); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_6", "1ServiceProducer.sql")); migrationBuilder.DropColumn( name: "Id", schema: "public", table: "OrganizationService"); migrationBuilder.DropColumn( name: "ProvisionTypeId", schema: "public", table: "OrganizationService"); migrationBuilder.DropColumn( name: "RoleTypeId", schema: "public", table: "OrganizationService"); migrationBuilder.AlterColumn <Guid>( name: "OrganizationId", schema: "public", table: "OrganizationService", nullable: false, oldClrType: typeof(Guid), oldNullable: true); migrationBuilder.AddPrimaryKey( name: "PK_OrganizationService", schema: "public", table: "OrganizationService", columns: new[] { "OrganizationId", "ServiceVersionedId" }); migrationBuilder.DropTable( name: "RoleTypeName", schema: "public"); migrationBuilder.DropTable( name: "RoleType", schema: "public"); migrationBuilder.RenameTable( name: "OrganizationServiceAdditionalInformation", newName: "ServiceProducerAdditionalInformation", schema: "public" ); migrationBuilder.RenameColumn( name: "OrganizationServiceId", newName: "ServiceProducerId", table: "ServiceProducerAdditionalInformation", schema: "public"); migrationBuilder.CreateIndex( name: "IX_SerProAddInf_ServiceProducerId", schema: "public", table: "ServiceProducerAdditionalInformation", column: "ServiceProducerId"); }
public void Up(MigrationBuilder migrationBuilder) { dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_4_5", "Fixed", "2AreaInformationType.sql")); migrationBuilder.AddColumn <Guid>( name: "AreaInformationTypeId", schema: "public", table: "ServiceVersioned", nullable: false, defaultValueSql: @"GetOrCreateDefaultAreaInformationTypeId('WholeCountry')"); migrationBuilder.AddColumn <Guid>( name: "AreaInformationTypeId", schema: "public", table: "ServiceChannelVersioned", nullable: true); migrationBuilder.CreateTable( name: "Area", schema: "public", columns: table => new { Id = table.Column <Guid>(nullable: false), AreaTypeId = 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_Area", x => x.Id); table.ForeignKey( name: "FK_Area_AreaType_AreaTypeId", column: x => x.AreaTypeId, principalSchema: "public", principalTable: "AreaType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "OrganizationAreaMunicipality", schema: "public", columns: table => new { OrganizationVersionedId = table.Column <Guid>(nullable: false), MunicipalityId = 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_OrganizationAreaMunicipality", x => new { x.OrganizationVersionedId, x.MunicipalityId }); table.ForeignKey( name: "FK_OrganizationAreaMunicipality_Municipality_MunicipalityId", column: x => x.MunicipalityId, principalSchema: "public", principalTable: "Municipality", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_OrganizationAreaMunicipality_OrganizationVersioned_OrganizationVersionedId", column: x => x.OrganizationVersionedId, principalSchema: "public", principalTable: "OrganizationVersioned", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "ServiceAreaMunicipality", schema: "public", columns: table => new { ServiceVersionedId = table.Column <Guid>(nullable: false), MunicipalityId = 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_ServiceAreaMunicipality", x => new { x.ServiceVersionedId, x.MunicipalityId }); table.ForeignKey( name: "FK_ServiceAreaMunicipality_Municipality_MunicipalityId", column: x => x.MunicipalityId, principalSchema: "public", principalTable: "Municipality", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceAreaMunicipality_ServiceVersioned_ServiceVersionedId", column: x => x.ServiceVersionedId, principalSchema: "public", principalTable: "ServiceVersioned", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "ServiceChannelAreaMunicipality", schema: "public", columns: table => new { ServiceChannelVersionedId = table.Column <Guid>(nullable: false), MunicipalityId = 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_ServiceChannelAreaMunicipality", x => new { x.ServiceChannelVersionedId, x.MunicipalityId }); table.ForeignKey( name: "FK_ServiceChannelAreaMunicipality_Municipality_MunicipalityId", column: x => x.MunicipalityId, principalSchema: "public", principalTable: "Municipality", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceChannelAreaMunicipality_ServiceChannelVersioned_ServiceChannelVersionedId", column: x => x.ServiceChannelVersionedId, principalSchema: "public", principalTable: "ServiceChannelVersioned", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AreaMunicipality", schema: "public", columns: table => new { AreaId = table.Column <Guid>(nullable: false), MunicipalityId = 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_AreaMunicipality", x => new { x.AreaId, x.MunicipalityId }); table.ForeignKey( name: "FK_AreaMunicipality_Area_AreaId", column: x => x.AreaId, principalSchema: "public", principalTable: "Area", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_AreaMunicipality_Municipality_MunicipalityId", column: x => x.MunicipalityId, principalSchema: "public", principalTable: "Municipality", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AreaName", schema: "public", columns: table => new { AreaId = table.Column <Guid>(nullable: false), LocalizationId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), Id = 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_AreaName", x => new { x.AreaId, x.LocalizationId }); table.ForeignKey( name: "FK_AreaName_Area_AreaId", column: x => x.AreaId, principalSchema: "public", principalTable: "Area", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_AreaName_Language_LocalizationId", column: x => x.LocalizationId, principalSchema: "public", principalTable: "Language", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "OrganizationArea", schema: "public", columns: table => new { OrganizationVersionedId = table.Column <Guid>(nullable: false), AreaId = 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_OrganizationArea", x => new { x.OrganizationVersionedId, x.AreaId }); table.ForeignKey( name: "FK_OrganizationArea_Area_AreaId", column: x => x.AreaId, principalSchema: "public", principalTable: "Area", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_OrganizationArea_OrganizationVersioned_OrganizationVersionedId", column: x => x.OrganizationVersionedId, principalSchema: "public", principalTable: "OrganizationVersioned", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "ServiceArea", schema: "public", columns: table => new { ServiceVersionedId = table.Column <Guid>(nullable: false), AreaId = 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_ServiceArea", x => new { x.ServiceVersionedId, x.AreaId }); table.ForeignKey( name: "FK_ServiceArea_Area_AreaId", column: x => x.AreaId, principalSchema: "public", principalTable: "Area", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceArea_ServiceVersioned_ServiceVersionedId", column: x => x.ServiceVersionedId, principalSchema: "public", principalTable: "ServiceVersioned", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "ServiceChannelArea", schema: "public", columns: table => new { ServiceChannelVersionedId = table.Column <Guid>(nullable: false), AreaId = 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_ServiceChannelArea", x => new { x.ServiceChannelVersionedId, x.AreaId }); table.ForeignKey( name: "FK_ServiceChannelArea_Area_AreaId", column: x => x.AreaId, principalSchema: "public", principalTable: "Area", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ServiceChannelArea_ServiceChannelVersioned_ServiceChannelVersionedId", column: x => x.ServiceChannelVersionedId, principalSchema: "public", principalTable: "ServiceChannelVersioned", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_SerVer_AreaInformationTypeId", schema: "public", table: "ServiceVersioned", column: "AreaInformationTypeId"); migrationBuilder.CreateIndex( name: "IX_SerChaVer_AreaInformationTypeId", schema: "public", table: "ServiceChannelVersioned", column: "AreaInformationTypeId"); migrationBuilder.CreateIndex( name: "IX_Are_AreaTypeId", schema: "public", table: "Area", column: "AreaTypeId"); migrationBuilder.CreateIndex( name: "IX_Are_Id", schema: "public", table: "Area", column: "Id"); migrationBuilder.CreateIndex( name: "IX_AreMun_AreaId", schema: "public", table: "AreaMunicipality", column: "AreaId"); migrationBuilder.CreateIndex( name: "IX_AreMun_MunicipalityId", schema: "public", table: "AreaMunicipality", column: "MunicipalityId"); migrationBuilder.CreateIndex( name: "IX_AreNam_AreaId", schema: "public", table: "AreaName", column: "AreaId"); migrationBuilder.CreateIndex( name: "IX_AreNam_LocalizationId", schema: "public", table: "AreaName", column: "LocalizationId"); migrationBuilder.CreateIndex( name: "IX_OrgAre_AreaId", schema: "public", table: "OrganizationArea", column: "AreaId"); migrationBuilder.CreateIndex( name: "IX_OrgAre_OrganizationVersionedId", schema: "public", table: "OrganizationArea", column: "OrganizationVersionedId"); migrationBuilder.CreateIndex( name: "IX_OrgAreMun_MunicipalityId", schema: "public", table: "OrganizationAreaMunicipality", column: "MunicipalityId"); migrationBuilder.CreateIndex( name: "IX_OrgAreMun_OrganizationVersionedId", schema: "public", table: "OrganizationAreaMunicipality", column: "OrganizationVersionedId"); migrationBuilder.CreateIndex( name: "IX_SerAre_AreaId", schema: "public", table: "ServiceArea", column: "AreaId"); migrationBuilder.CreateIndex( name: "IX_SerAre_ServiceVersionedId", schema: "public", table: "ServiceArea", column: "ServiceVersionedId"); migrationBuilder.CreateIndex( name: "IX_SerAreMun_MunicipalityId", schema: "public", table: "ServiceAreaMunicipality", column: "MunicipalityId"); migrationBuilder.CreateIndex( name: "IX_SerAreMun_ServiceVersionedId", schema: "public", table: "ServiceAreaMunicipality", column: "ServiceVersionedId"); migrationBuilder.CreateIndex( name: "IX_SerChaAre_AreaId", schema: "public", table: "ServiceChannelArea", column: "AreaId"); migrationBuilder.CreateIndex( name: "IX_SerChaAre_ServiceChannelVersionedId", schema: "public", table: "ServiceChannelArea", column: "ServiceChannelVersionedId"); migrationBuilder.CreateIndex( name: "IX_SerChaAreMun_MunicipalityId", schema: "public", table: "ServiceChannelAreaMunicipality", column: "MunicipalityId"); migrationBuilder.CreateIndex( name: "IX_SerChaAreMun_ServiceChannelVersionedId", schema: "public", table: "ServiceChannelAreaMunicipality", column: "ServiceChannelVersionedId"); migrationBuilder.AddForeignKey( name: "FK_ServiceChannelVersioned_AreaInformationType_AreaInformationTypeId", schema: "public", table: "ServiceChannelVersioned", column: "AreaInformationTypeId", principalSchema: "public", principalTable: "AreaInformationType", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_ServiceVersioned_AreaInformationType_AreaInformationTypeId", schema: "public", table: "ServiceVersioned", column: "AreaInformationTypeId", principalSchema: "public", principalTable: "AreaInformationType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
public void Up(MigrationBuilder migrationBuilder) { migrationBuilder.RenameTable( name: "AddressType", newName: "AddressCharacter", schema: "public"); migrationBuilder.CreateTable( name: "AddressType", 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), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), OrderNumber = table.Column <int>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_AddressTypeId", x => x.Id); }); migrationBuilder.CreateTable( name: "AddressForeign", schema: "public", columns: table => new { AddressId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_AddressForeign", x => x.AddressId); table.ForeignKey( name: "FK_AddressForeign_Address_AddressId", column: x => x.AddressId, principalSchema: "public", principalTable: "Address", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AddressPostOfficeBox", schema: "public", columns: table => new { AddressId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), MunicipalityId = table.Column <Guid>(nullable: true), PostalCodeId = table.Column <Guid>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_AddressPostOfficeBox", x => x.AddressId); table.ForeignKey( name: "FK_AddressPostOfficeBox_Address_AddressId", column: x => x.AddressId, principalSchema: "public", principalTable: "Address", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_AddressPostOfficeBox_Municipality_MunicipalityId", column: x => x.MunicipalityId, principalSchema: "public", principalTable: "Municipality", principalColumn: "Id", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_AddressPostOfficeBox_PostalCode_PostalCodeId", column: x => x.PostalCodeId, principalSchema: "public", principalTable: "PostalCode", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AddressStreet", schema: "public", columns: table => new { AddressId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), MunicipalityId = table.Column <Guid>(nullable: true), PostalCodeId = table.Column <Guid>(nullable: false), StreetNumber = table.Column <string>(maxLength: 30, nullable: true) }, constraints: table => { table.PrimaryKey("PK_AddressStreet", x => x.AddressId); table.ForeignKey( name: "FK_AddressStreet_Address_AddressId", column: x => x.AddressId, principalSchema: "public", principalTable: "Address", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_AddressStreet_Municipality_MunicipalityId", column: x => x.MunicipalityId, principalSchema: "public", principalTable: "Municipality", principalColumn: "Id", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_AddressStreet_PostalCode_PostalCodeId", column: x => x.PostalCodeId, principalSchema: "public", principalTable: "PostalCode", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AddressForeignTextName", schema: "public", columns: table => new { AddressForeignId = table.Column <Guid>(nullable: false), LocalizationId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = 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_AddressForeignTextName", x => new { x.AddressForeignId, x.LocalizationId }); table.ForeignKey( name: "FK_AddressForeignTextName_AddressForeign_AddressForeignId", column: x => x.AddressForeignId, principalSchema: "public", principalTable: "AddressForeign", principalColumn: "AddressId", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_AddressForeignTextName_Language_LocalizationId", column: x => x.LocalizationId, principalSchema: "public", principalTable: "Language", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); foreach (AddressTypeEnum addressType in Enum.GetValues(typeof(AddressTypeEnum))) { migrationBuilder.Sql($@"INSERT INTO ""AddressType""(""Id"", ""Code"", ""Created"", ""Modified"") VALUES ('{addressType.ToString().GetGuid()}','{addressType.ToString()}','2017-01-01 01:01:01','2017-01-01 01:01:01');"); } migrationBuilder.AddColumn <Guid>( name: "TypeId", schema: "public", table: "Address", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_6", "3AddressThirdType.sql")); migrationBuilder.DropForeignKey( name: "FK_Address_Municipality_MunicipalityId", schema: "public", table: "Address"); migrationBuilder.DropForeignKey( name: "FK_Address_PostalCode_PostalCodeId", schema: "public", table: "Address"); migrationBuilder.DropForeignKey( name: "FK_OrganizationAddress_AddressType_TypeId", schema: "public", table: "OrganizationAddress"); migrationBuilder.DropForeignKey( name: "FK_PostOfficeBoxName_Address_AddressId", schema: "public", table: "PostOfficeBoxName"); migrationBuilder.DropForeignKey( name: "FK_ServiceLocationChannelAddress_AddressType_TypeId", schema: "public", table: "ServiceLocationChannelAddress"); migrationBuilder.DropForeignKey( name: "FK_StreetAddress_Address_AddressId", schema: "public", table: "StreetName"); migrationBuilder.DropPrimaryKey( name: "PK_StreetName", schema: "public", table: "StreetName"); migrationBuilder.DropIndex( name: "IX_StrNam_Id", schema: "public", table: "StreetName"); migrationBuilder.DropPrimaryKey( name: "PK_PostOfficeBoxName", schema: "public", table: "PostOfficeBoxName"); migrationBuilder.DropIndex( name: "IX_PosOffBoxNam_Id", schema: "public", table: "PostOfficeBoxName"); migrationBuilder.DropIndex( name: "IX_Add_MunicipalityId", schema: "public", table: "Address"); migrationBuilder.DropColumn( name: "Id", schema: "public", table: "StreetName"); migrationBuilder.DropColumn( name: "Id", schema: "public", table: "PostOfficeBoxName"); migrationBuilder.DropColumn( name: "MunicipalityId", schema: "public", table: "Address"); migrationBuilder.DropColumn( name: "PostalCodeId", schema: "public", table: "Address"); migrationBuilder.DropColumn( name: "StreetNumber", schema: "public", table: "Address"); migrationBuilder.RenameColumn( name: "Text", schema: "public", table: "StreetName", newName: "Name"); migrationBuilder.RenameColumn( name: "AddressId", schema: "public", table: "StreetName", newName: "AddressStreetId"); migrationBuilder.RenameIndex( name: "IX_StrNam_AddressId", schema: "public", table: "StreetName", newName: "IX_StrNam_AddressStreetId"); migrationBuilder.RenameColumn( name: "TypeId", schema: "public", table: "ServiceLocationChannelAddress", newName: "CharacterId"); migrationBuilder.RenameIndex( name: "IX_SerLocChaAdd_TypeId", schema: "public", table: "ServiceLocationChannelAddress", newName: "IX_SerLocChaAdd_CharacterId"); migrationBuilder.RenameColumn( name: "Text", schema: "public", table: "PostOfficeBoxName", newName: "Name"); migrationBuilder.RenameColumn( name: "AddressId", schema: "public", table: "PostOfficeBoxName", newName: "AddressPostOfficeBoxId"); migrationBuilder.RenameIndex( name: "IX_PosOffBoxNam_AddressId", schema: "public", table: "PostOfficeBoxName", newName: "IX_PosOffBoxNam_AddressPostOfficeBoxId"); migrationBuilder.RenameColumn( name: "TypeId", schema: "public", table: "OrganizationAddress", newName: "CharacterId"); migrationBuilder.RenameIndex( name: "IX_OrgAdd_TypeId", schema: "public", table: "OrganizationAddress", newName: "IX_OrgAdd_CharacterId"); // migrationBuilder.AlterColumn<Guid>( // name: "PostalCodeId", // schema: "public", // table: "Address", // nullable: true, // oldClrType: typeof(Guid)); migrationBuilder.AddColumn <int>( name: "OrderNumber", schema: "public", table: "Address", nullable: true); migrationBuilder.AddPrimaryKey( name: "PK_StreetName", schema: "public", table: "StreetName", columns: new[] { "AddressStreetId", "LocalizationId" }); migrationBuilder.AddPrimaryKey( name: "PK_PostOfficeBoxName", schema: "public", table: "PostOfficeBoxName", columns: new[] { "AddressPostOfficeBoxId", "LocalizationId" }); migrationBuilder.CreateTable( name: "AddressCharacterName", schema: "public", columns: table => new { Id = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), LocalizationId = table.Column <Guid>(nullable: false), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), Name = table.Column <string>(nullable: true), TypeId = table.Column <Guid>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_AddressCharacterName", x => x.Id); table.ForeignKey( name: "FK_AddressCharacterName_Language_LocalizationId", column: x => x.LocalizationId, principalSchema: "public", principalTable: "Language", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_AddressCharacterName_AddressCharacter_TypeId", column: x => x.TypeId, principalSchema: "public", principalTable: "AddressCharacter", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.DropTable(name: "AddressTypeName", schema: "public"); migrationBuilder.CreateTable( name: "AddressTypeName", schema: "public", columns: table => new { Id = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), LastOperationId = table.Column <string>(nullable: true), LocalizationId = table.Column <Guid>(nullable: false), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true), Name = table.Column <string>(nullable: true), TypeId = table.Column <Guid>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_AddressTypeName", x => x.Id); table.ForeignKey( name: "FK_AddressTypeName_Language_LocalizationId", column: x => x.LocalizationId, principalSchema: "public", principalTable: "Language", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_AddressTypeName_AddressType_TypeId", column: x => x.TypeId, principalSchema: "public", principalTable: "AddressType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_AddTypNam_Id", schema: "public", table: "AddressTypeName", column: "Id"); migrationBuilder.CreateIndex( name: "IX_Add_TypeId", schema: "public", table: "Address", column: "TypeId"); migrationBuilder.CreateIndex( name: "IX_AddFor_AddressId", schema: "public", table: "AddressForeign", column: "AddressId"); migrationBuilder.CreateIndex( name: "IX_AddForTexNam_AddressForeignId", schema: "public", table: "AddressForeignTextName", column: "AddressForeignId"); migrationBuilder.CreateIndex( name: "IX_AddForTexNam_LocalizationId", schema: "public", table: "AddressForeignTextName", column: "LocalizationId"); migrationBuilder.CreateIndex( name: "IX_AddCha_Id", schema: "public", table: "AddressCharacter", column: "Id"); migrationBuilder.CreateIndex( name: "IX_AddChaNam_Id", schema: "public", table: "AddressCharacterName", column: "Id"); migrationBuilder.CreateIndex( name: "IX_AddChaNam_LocalizationId", schema: "public", table: "AddressCharacterName", column: "LocalizationId"); migrationBuilder.CreateIndex( name: "IX_AddChaNam_TypeId", schema: "public", table: "AddressCharacterName", column: "TypeId"); migrationBuilder.CreateIndex( name: "IX_AddPosOffBox_AddressId", schema: "public", table: "AddressPostOfficeBox", column: "AddressId"); migrationBuilder.CreateIndex( name: "IX_AddPosOffBox_MunicipalityId", schema: "public", table: "AddressPostOfficeBox", column: "MunicipalityId"); migrationBuilder.CreateIndex( name: "IX_AddPosOffBox_PostalCodeId", schema: "public", table: "AddressPostOfficeBox", column: "PostalCodeId"); migrationBuilder.CreateIndex( name: "IX_AddStr_AddressId", schema: "public", table: "AddressStreet", column: "AddressId"); migrationBuilder.CreateIndex( name: "IX_AddStr_MunicipalityId", schema: "public", table: "AddressStreet", column: "MunicipalityId"); migrationBuilder.CreateIndex( name: "IX_AddStr_PostalCodeId", schema: "public", table: "AddressStreet", column: "PostalCodeId"); // migrationBuilder.AddForeignKey( // name: "FK_Address_PostalCode_PostalCodeId", // schema: "public", // table: "Address", // column: "PostalCodeId", // principalSchema: "public", // principalTable: "PostalCode", // principalColumn: "Id", // onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Address_AddressType_TypeId", schema: "public", table: "Address", column: "TypeId", principalSchema: "public", principalTable: "AddressType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_OrganizationAddress_AddressCharacter_CharacterId", schema: "public", table: "OrganizationAddress", column: "CharacterId", principalSchema: "public", principalTable: "AddressCharacter", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_PostOfficeBoxName_AddressPostOfficeBox_AddressPostOfficeBoxId", schema: "public", table: "PostOfficeBoxName", column: "AddressPostOfficeBoxId", principalSchema: "public", principalTable: "AddressPostOfficeBox", principalColumn: "AddressId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_ServiceLocationChannelAddress_AddressCharacter_CharacterId", schema: "public", table: "ServiceLocationChannelAddress", column: "CharacterId", principalSchema: "public", principalTable: "AddressCharacter", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_StreetName_AddressStreet_AddressStreetId", schema: "public", table: "StreetName", column: "AddressStreetId", principalSchema: "public", principalTable: "AddressStreet", principalColumn: "AddressId", onDelete: ReferentialAction.Cascade); }
public void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "OrganizationDisplayNameType", schema: "public", columns: table => new { OrganizationVersionedId = table.Column <Guid>(nullable: false), LocalizationId = table.Column <Guid>(nullable: false), Created = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <string>(nullable: true), DisplayNameTypeId = table.Column <Guid>(nullable: false), Modified = table.Column <DateTime>(nullable: false), ModifiedBy = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_OrganizationDisplayNameType", x => new { x.OrganizationVersionedId, x.LocalizationId }); table.ForeignKey( name: "FK_OrganizationDisplayNameType_NameType_DisplayNameTypeId", column: x => x.DisplayNameTypeId, principalSchema: "public", principalTable: "NameType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_OrganizationDisplayNameType_Language_LocalizationId", column: x => x.LocalizationId, principalSchema: "public", principalTable: "Language", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_OrganizationDisplayNameType_OrganizationVersioned_OrganizationVersionedId", column: x => x.OrganizationVersionedId, principalSchema: "public", principalTable: "OrganizationVersioned", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_OrgDisNamTyp_DisplayNameTypeId", schema: "public", table: "OrganizationDisplayNameType", column: "DisplayNameTypeId"); migrationBuilder.CreateIndex( name: "IX_OrgDisNamTyp_LocalizationId", schema: "public", table: "OrganizationDisplayNameType", column: "LocalizationId"); migrationBuilder.CreateIndex( name: "IX_OrgDisNamTyp_OrganizationVersionedId", schema: "public", table: "OrganizationDisplayNameType", column: "OrganizationVersionedId"); dataUtils.AddSqlScript(migrationBuilder, Path.Combine("SqlMigrations", "PTV_1_4_5", "Fixed", "5OrganizationDisplayNameType.sql")); migrationBuilder.DropForeignKey( name: "FK_Organization_NameType_DisplayNameTypeId", schema: "public", table: "OrganizationVersioned"); migrationBuilder.DropIndex( name: "IX_Org_DisplayNameTypeId", schema: "public", table: "OrganizationVersioned"); migrationBuilder.DropColumn( name: "DisplayNameTypeId", schema: "public", table: "OrganizationVersioned"); }