5707bd4c31
Introduced StoreCreditMovement entity and migration to track store credit usage and settlements. Updated payment flow to enforce credit limits and record credit movements. Modified outstanding balance calculation to use credit movements. Enhanced frontend to display real-time credit info and prevent over-credit payments. Updated API types, seed data, and DI registrations accordingly.
779 lines
43 KiB
C#
779 lines
43 KiB
C#
using System;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
|
|
#nullable disable
|
|
|
|
namespace Distribution.Migrations
|
|
{
|
|
/// <inheritdoc />
|
|
public partial class credittable : Migration
|
|
{
|
|
/// <inheritdoc />
|
|
protected override void Up(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.CreateTable(
|
|
name: "StoreCreditMovements",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
|
|
FK_StoreId = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
|
|
Direction = table.Column<int>(type: "int", nullable: false),
|
|
Amount = table.Column<decimal>(type: "decimal(18,2)", precision: 18, scale: 2, nullable: false),
|
|
FK_InvoiceId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
|
|
FK_PaymentId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
|
|
OccurredAt = table.Column<DateTime>(type: "datetime(6)", nullable: false),
|
|
RecordedBy = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
|
|
Notes = table.Column<string>(type: "longtext", nullable: true)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false),
|
|
IsActive = table.Column<bool>(type: "tinyint(1)", nullable: false)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_StoreCreditMovements", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_StoreCreditMovements_Invoices_FK_InvoiceId",
|
|
column: x => x.FK_InvoiceId,
|
|
principalTable: "Invoices",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Restrict);
|
|
table.ForeignKey(
|
|
name: "FK_StoreCreditMovements_Payments_FK_PaymentId",
|
|
column: x => x.FK_PaymentId,
|
|
principalTable: "Payments",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Restrict);
|
|
table.ForeignKey(
|
|
name: "FK_StoreCreditMovements_Stores_FK_StoreId",
|
|
column: x => x.FK_StoreId,
|
|
principalTable: "Stores",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Restrict);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000001"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("be712eda-98a5-4a30-820a-1737e84d1e4b"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000002"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("47ea9420-d6a0-4376-a2b8-211639d95b27"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000003"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("369eed1f-df4c-4131-a3c6-ebbe63d2dc91"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000004"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("14b6944f-2d4a-4378-a974-c6fc0f9dfb81"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000005"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("14a01e0b-7be5-4c65-ae6a-899f9aa7ad28"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000006"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("5d486ccd-3866-4e7d-8ef1-fb177fb637c1"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000007"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("d830e59b-f451-4bde-9a77-78daea5f9a61"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000008"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("096d3837-a649-4184-8987-2ea0dfa2d4a1"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000009"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("5e43bbde-689b-4d07-baf9-0764078b5586"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000010"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("f317d30c-1644-44f0-b0aa-6bcf1fa66f44"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000011"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("31ffac6f-2aa8-48ee-bc87-213f35933de4"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000012"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("fb525bc4-9f16-455a-bfd5-ca6f3e7ad141"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000013"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("2388918f-6392-4384-b269-0a1469f5bf4c"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000014"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("7159012e-5f25-4881-b5e8-5300e382332e"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000015"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("cc4b2e82-ad42-4440-92ba-9b2100bb5f84"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000016"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("6b15c133-ea0e-473d-b58a-7f140e9f03bf"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000017"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("c2dd52a9-380f-479f-8e5e-6b56bfc4738f"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000018"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("bf5f6c7a-2fde-4a01-83f4-aacf91333c4c"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000019"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("162a0346-c4c0-4c4e-96e9-aa8154d25b39"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000020"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("5cc76807-25d1-45e5-9da3-cfd6d6f3ad7c"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000021"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("51a2653e-4b1a-4f6f-80c2-f533b26109ea"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000022"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("e2a382e2-d712-4a97-a7ec-cd6232d77a78"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000023"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("b60260b5-70b0-4f9e-9ab9-ba4abbbdfb02"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000024"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("a73fe794-383c-4157-89cf-227c4e487a6d"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000025"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("a9743e96-15b2-4c1d-b410-698cd6db0b7b"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000026"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("a94d92ab-66d8-4dd9-8ba3-c242eb450e68"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000027"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("9cb1a028-a98e-492a-aafc-70456fe46c96"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000028"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("5bc99a62-f5d7-48fe-b25c-518e4774614c"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000029"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("eceee678-5cee-4ee9-b16d-8d8d21fbb5ea"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000030"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("3a049ed7-75b7-4b1d-b3bb-402ca77c350f"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000031"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("aeaab85c-5b02-4bc2-b0e3-318c0f5b07d3"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000032"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("b79800e0-baa6-4add-9374-7d1e2ed650e8"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000033"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("0da6bf0b-26ff-46b9-bb8c-f9c641b37a89"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000034"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("ff84aeeb-93c0-465d-9a4a-8b686ba7bc75"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000035"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("921f8073-7a66-49bb-ae23-cf8fcde12c9c"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000036"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("bff05501-4988-4c8a-b61d-e32389e795a8"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000037"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("2c4f7432-e697-4d65-97df-069f8913a662"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000038"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("18d27746-3178-4c57-afd5-b75f0061637f"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000039"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("a5d1978b-c497-4314-857b-a7e3b8323a53"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000040"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("88300763-b8c3-4bd2-803b-df0e43bc691e"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000041"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("7aaad5a9-4497-429f-b3dc-9b59664e2e19"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000042"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("2db130c1-4b6f-4719-b3bb-7bd8a0662d75"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000043"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("be349d14-38b5-4a13-a152-9ea055de26b1"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000044"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("5292e02d-9a7d-4a18-be14-86c2f3351cac"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000045"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("97021474-1218-4d21-9115-4b9b2726e38b"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000046"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("56f68355-7b1b-49e4-829c-1a4d47fc93de"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000047"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("3017c8cb-f9e4-41c8-ac2e-f03d23fe944a"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000048"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("619a08e5-f6cb-4515-8b4d-a094d19277d8"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000049"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("cb8b4e96-7026-4485-8b52-3145b5289350"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000050"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("f0f57dfd-21a5-4a0b-a77e-e641f00300fa"));
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_StoreCreditMovements_FK_InvoiceId",
|
|
table: "StoreCreditMovements",
|
|
column: "FK_InvoiceId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_StoreCreditMovements_FK_PaymentId",
|
|
table: "StoreCreditMovements",
|
|
column: "FK_PaymentId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_StoreCreditMovements_FK_StoreId_OccurredAt",
|
|
table: "StoreCreditMovements",
|
|
columns: new[] { "FK_StoreId", "OccurredAt" });
|
|
}
|
|
|
|
/// <inheritdoc />
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.DropTable(
|
|
name: "StoreCreditMovements");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000001"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("30f658ac-2c92-4cd8-ad47-10b0def2699c"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000002"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("42ab2c52-eaf8-4a17-b67a-ccd66569e56a"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000003"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("8afec825-27b3-4153-ad06-f8bcdbf93da8"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000004"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("4b427620-e99d-4068-a416-c3788d5bd9b5"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000005"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("361f44ef-1cd1-48a9-be4d-4c068aacef1e"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000006"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("11fc03ae-92ee-4336-ae57-29aac731ad51"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000007"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("0b1f2b73-ef60-4634-864f-22a6c0cd1373"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000008"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("2380abf3-2bcd-4a9f-b447-5f1685df2fc8"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000009"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("240e4d6a-8306-40ba-aaec-8e05cd0347db"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000010"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("cfde0aa6-e859-4f9c-8291-b0d886fcd4c9"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000011"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("dae772c8-26ec-4b5c-8d7a-f3196510bf2c"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000012"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("3512c0a4-a5ae-4002-a779-7d3cc600ab61"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000013"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("f9e2a348-159e-47a2-b7be-a60f0254873f"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000014"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("c8b4c181-5b08-45d2-818b-74bceeab78a8"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000015"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("8fb4ff4c-c5bd-4afd-a08e-02861d63cb7b"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000016"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("edb3b711-d623-439d-811e-afaef8d0680d"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000017"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("f33e4c62-d69f-4a91-8b62-acbd5351ea2a"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000018"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("c7c9d16c-e343-43e9-9e27-f38f903a5d00"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000019"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("f5f4760a-8a45-46ca-8093-743c95b0313f"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000020"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("c5434801-146a-4fd9-9c29-a1145e7f7f00"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000021"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("6c085135-78a5-4e65-a380-ee090b07e2bb"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000022"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("bbde2785-a3df-4f81-bad1-0bc5afe5de57"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000023"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("4421a0fb-bdd4-45a9-8dc0-d9b70f775e97"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000024"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("dba9dcb4-3b94-4ddc-89f3-552cfc109478"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000025"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("d8f74160-c150-4d9c-aba6-e45e628c684e"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000026"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("495fb68b-9f01-4538-9561-fefce0d39558"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000027"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("3bdece9b-a798-4223-a23c-9c9dd10d042d"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000028"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("6fa616eb-99fe-46b9-8305-908765d037fd"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000029"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("7a07148a-1327-4e97-befc-b2045eacad21"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000030"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("852e86d7-aa57-4a77-81c0-054f3fb4d7f7"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000031"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("3b767929-c973-41fb-a340-4ee5feb65619"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000032"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("63619bbd-0352-41bd-9e1c-a3f7908fb5d2"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000033"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("f6b4c8bf-a9b3-4179-9f57-a8584678c0d1"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000034"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("bb47b8ca-f7cf-40fe-8945-fc532a439b53"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000035"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("52126271-ae3b-4b58-a9d2-50e2dd894087"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000036"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("981e3358-85bb-47fe-a1f5-3a3a02cf47b1"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000037"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("749408da-fcee-458d-9144-8d8dee928ba0"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000038"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("c157857c-fb0e-41fd-a414-c0f57a44b120"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000039"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("3217cdbc-76c9-4505-b9f3-23de91a6212b"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000040"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("63526c52-18ba-40e0-9889-3bd3b7fc8161"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000041"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("260cf2fa-1ca6-4cd5-92ae-8c479a80e2f0"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000042"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("130ab09c-8a36-4705-8235-9d00f75dd684"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000043"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("41794774-e919-4f4e-a42a-5ae408d3407f"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000044"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("2ff23d04-d1f6-4aa3-a48e-1c82bb9ad12a"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000045"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("d36c81c0-8e9b-41ea-8e09-464a327a16d2"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000046"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("6c51dfc1-63e0-46a6-b2bb-27c21c708b51"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000047"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("076333d5-b1f3-4b89-86fd-5a61a4451c88"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000048"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("7e834f3e-1424-4aaa-816e-d62da6df672b"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000049"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("699fa06b-a7ff-4dbd-98a7-a29c2c361665"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "RolePermissions",
|
|
keyColumns: new[] { "FK_PermissionId", "FK_RoleId" },
|
|
keyValues: new object[] { new Guid("20000000-0000-0000-0000-000000000050"), new Guid("10000000-0000-0000-0000-000000000007") },
|
|
column: "Id",
|
|
value: new Guid("00df5735-54c6-4cdf-8e2c-a64cd90ede15"));
|
|
}
|
|
}
|
|
}
|