| | | 1 | | using Microsoft.EntityFrameworkCore.Infrastructure; |
| | | 2 | | using Microsoft.EntityFrameworkCore.Migrations; |
| | | 3 | | |
| | | 4 | | #nullable disable |
| | | 5 | | |
| | | 6 | | namespace OzonRepositories.Migrations.OzonIdentityOrder |
| | | 7 | | { |
| | | 8 | | /// <summary> |
| | | 9 | | /// Догоняет таблицу AspNetUsers в боевой БД до baseline: связь с AccessProfiles |
| | | 10 | | /// там держалась только на колонке, без индекса и внешнего ключа. |
| | | 11 | | /// |
| | | 12 | | /// Идемпотентна за счёт IF EXISTS / IF NOT EXISTS (MariaDB): на чистой базе, |
| | | 13 | | /// где baseline отработал полностью, ничего не меняет. |
| | | 14 | | /// </summary> |
| | | 15 | | [DbContext(typeof(Context.Identity.OzonIdentityOrderContext))] |
| | | 16 | | [Migration("20260908110400_ReconcileProdSchema")] |
| | | 17 | | public partial class ReconcileProdSchema : Migration |
| | | 18 | | { |
| | | 19 | | /// <inheritdoc /> |
| | | 20 | | protected override void Up(MigrationBuilder migrationBuilder) |
| | | 21 | | { |
| | 0 | 22 | | migrationBuilder.Sql("CREATE INDEX IF NOT EXISTS `IX_AspNetUsers_AccessProfileId` ON `AspNetUsers` (`AccessP |
| | 0 | 23 | | migrationBuilder.Sql(@"ALTER TABLE `AspNetUsers` |
| | 0 | 24 | | ADD CONSTRAINT `FK_AspNetUsers_AccessProfiles_AccessProfileId` |
| | 0 | 25 | | FOREIGN KEY IF NOT EXISTS (`AccessProfileId`) REFERENCES `AccessProfiles` (`Id`) ON DELETE SET NULL;"); |
| | 0 | 26 | | } |
| | | 27 | | |
| | | 28 | | /// <inheritdoc /> |
| | | 29 | | protected override void Down(MigrationBuilder migrationBuilder) |
| | | 30 | | { |
| | 0 | 31 | | migrationBuilder.Sql("ALTER TABLE `AspNetUsers` DROP FOREIGN KEY IF EXISTS `FK_AspNetUsers_AccessProfiles_Ac |
| | 0 | 32 | | migrationBuilder.Sql("ALTER TABLE `AspNetUsers` DROP INDEX IF EXISTS `IX_AspNetUsers_AccessProfileId`;"); |
| | 0 | 33 | | } |
| | | 34 | | } |
| | | 35 | | } |