< Summary

Information
Class: Elsa.Persistence.EFCore.SqlServer.Migrations.Runtime.Initial
Assembly: Elsa.Persistence.EFCore.SqlServer
File(s): File 1: /home/runner/work/elsa-core/elsa-core/src/modules/Elsa.Persistence.EFCore.SqlServer/Migrations/Runtime/20231024160944_Initial.cs
File 2: /home/runner/work/elsa-core/elsa-core/src/modules/Elsa.Persistence.EFCore.SqlServer/Migrations/Runtime/20231024160944_Initial.Designer.cs
Line coverage
97%
Covered lines: 699
Uncovered lines: 16
Coverable lines: 715
Total lines: 820
Line coverage: 97.7%
Branch coverage
50%
Covered branches: 1
Total branches: 2
Branch coverage: 50%
Method coverage

Feature is only available for sponsors

Upgrade to PRO version

Metrics

MethodBranch coverage Crap Score Cyclomatic complexity Line coverage
File 1: .ctor(...)50%22100%
File 1: Up(...)100%11100%
File 1: Down(...)100%210%
File 2: BuildTargetModel(...)100%11100%

File(s)

/home/runner/work/elsa-core/elsa-core/src/modules/Elsa.Persistence.EFCore.SqlServer/Migrations/Runtime/20231024160944_Initial.cs

#LineLine coverage
 1using Elsa.Persistence.EFCore;
 2using Microsoft.EntityFrameworkCore.Migrations;
 3
 4#nullable disable
 5
 6namespace Elsa.Persistence.EFCore.SqlServer.Migrations.Runtime
 7{
 8    /// <inheritdoc />
 9    public partial class Initial : Migration
 10    {
 11        private readonly IElsaDbContextSchema _schema;
 112        public Initial(IElsaDbContextSchema schema)
 13        {
 114            _schema = schema ?? throw new ArgumentNullException(nameof(schema));
 115        }
 16        /// <inheritdoc />
 17        protected override void Up(MigrationBuilder migrationBuilder)
 18        {
 119            migrationBuilder.EnsureSchema(
 120                name: _schema.Schema);
 21
 122            migrationBuilder.CreateTable(
 123                name: "ActivityExecutionRecords",
 124                schema: _schema.Schema,
 125                columns: table => new
 126                {
 127                    Id = table.Column<string>(type: "nvarchar(450)", nullable: false),
 128                    WorkflowInstanceId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 129                    ActivityId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 130                    ActivityNodeId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 131                    ActivityType = table.Column<string>(type: "nvarchar(450)", nullable: false),
 132                    ActivityTypeVersion = table.Column<int>(type: "int", nullable: false),
 133                    ActivityName = table.Column<string>(type: "nvarchar(450)", nullable: true),
 134                    StartedAt = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
 135                    HasBookmarks = table.Column<bool>(type: "bit", nullable: false),
 136                    Status = table.Column<string>(type: "nvarchar(450)", nullable: false),
 137                    CompletedAt = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
 138                    SerializedActivityState = table.Column<string>(type: "nvarchar(max)", nullable: true),
 139                    SerializedException = table.Column<string>(type: "nvarchar(max)", nullable: true),
 140                    SerializedOutputs = table.Column<string>(type: "nvarchar(max)", nullable: true),
 141                    SerializedPayload = table.Column<string>(type: "nvarchar(max)", nullable: true)
 142                },
 143                constraints: table =>
 144                {
 145                    table.PrimaryKey("PK_ActivityExecutionRecords", x => x.Id);
 246                });
 47
 148            migrationBuilder.CreateTable(
 149                name: "Bookmarks",
 150                schema: _schema.Schema,
 151                columns: table => new
 152                {
 153                    BookmarkId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 154                    ActivityTypeName = table.Column<string>(type: "nvarchar(450)", nullable: false),
 155                    Hash = table.Column<string>(type: "nvarchar(450)", nullable: false),
 156                    WorkflowInstanceId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 157                    ActivityInstanceId = table.Column<string>(type: "nvarchar(450)", nullable: true),
 158                    CorrelationId = table.Column<string>(type: "nvarchar(max)", nullable: true),
 159                    CreatedAt = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
 160                    SerializedMetadata = table.Column<string>(type: "nvarchar(max)", nullable: true),
 161                    SerializedPayload = table.Column<string>(type: "nvarchar(max)", nullable: true)
 162                },
 163                constraints: table =>
 164                {
 165                    table.PrimaryKey("PK_Bookmarks", x => x.BookmarkId);
 266                });
 67
 168            migrationBuilder.CreateTable(
 169                name: "Triggers",
 170                schema: _schema.Schema,
 171                columns: table => new
 172                {
 173                    Id = table.Column<string>(type: "nvarchar(450)", nullable: false),
 174                    WorkflowDefinitionId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 175                    WorkflowDefinitionVersionId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 176                    Name = table.Column<string>(type: "nvarchar(450)", nullable: false),
 177                    ActivityId = table.Column<string>(type: "nvarchar(max)", nullable: false),
 178                    Hash = table.Column<string>(type: "nvarchar(450)", nullable: true),
 179                    SerializedPayload = table.Column<string>(type: "nvarchar(max)", nullable: true)
 180                },
 181                constraints: table =>
 182                {
 183                    table.PrimaryKey("PK_Triggers", x => x.Id);
 284                });
 85
 186            migrationBuilder.CreateTable(
 187                name: "WorkflowExecutionLogRecords",
 188                schema: _schema.Schema,
 189                columns: table => new
 190                {
 191                    Id = table.Column<string>(type: "nvarchar(450)", nullable: false),
 192                    WorkflowDefinitionId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 193                    WorkflowDefinitionVersionId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 194                    WorkflowInstanceId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 195                    WorkflowVersion = table.Column<int>(type: "int", nullable: false),
 196                    ActivityInstanceId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 197                    ParentActivityInstanceId = table.Column<string>(type: "nvarchar(450)", nullable: true),
 198                    ActivityId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 199                    ActivityType = table.Column<string>(type: "nvarchar(450)", nullable: false),
 1100                    ActivityTypeVersion = table.Column<int>(type: "int", nullable: false),
 1101                    ActivityName = table.Column<string>(type: "nvarchar(450)", nullable: true),
 1102                    ActivityNodeId = table.Column<string>(type: "nvarchar(450)", nullable: false),
 1103                    Timestamp = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
 1104                    Sequence = table.Column<long>(type: "bigint", nullable: false),
 1105                    EventName = table.Column<string>(type: "nvarchar(450)", nullable: true),
 1106                    Message = table.Column<string>(type: "nvarchar(max)", nullable: true),
 1107                    Source = table.Column<string>(type: "nvarchar(max)", nullable: true),
 1108                    SerializedActivityState = table.Column<string>(type: "nvarchar(max)", nullable: true),
 1109                    SerializedPayload = table.Column<string>(type: "nvarchar(max)", nullable: true)
 1110                },
 1111                constraints: table =>
 1112                {
 1113                    table.PrimaryKey("PK_WorkflowExecutionLogRecords", x => x.Id);
 2114                });
 115
 1116            migrationBuilder.CreateTable(
 1117                name: "WorkflowInboxMessages",
 1118                schema: _schema.Schema,
 1119                columns: table => new
 1120                {
 1121                    Id = table.Column<string>(type: "nvarchar(450)", nullable: false),
 1122                    ActivityTypeName = table.Column<string>(type: "nvarchar(450)", nullable: false),
 1123                    Hash = table.Column<string>(type: "nvarchar(450)", nullable: false),
 1124                    WorkflowInstanceId = table.Column<string>(type: "nvarchar(450)", nullable: true),
 1125                    CorrelationId = table.Column<string>(type: "nvarchar(450)", nullable: true),
 1126                    ActivityInstanceId = table.Column<string>(type: "nvarchar(450)", nullable: true),
 1127                    CreatedAt = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
 1128                    ExpiresAt = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
 1129                    SerializedBookmarkPayload = table.Column<string>(type: "nvarchar(max)", nullable: true),
 1130                    SerializedInput = table.Column<string>(type: "nvarchar(max)", nullable: true)
 1131                },
 1132                constraints: table =>
 1133                {
 1134                    table.PrimaryKey("PK_WorkflowInboxMessages", x => x.Id);
 2135                });
 136
 1137            migrationBuilder.CreateIndex(
 1138                name: "IX_ActivityExecutionRecord_ActivityId",
 1139                schema: _schema.Schema,
 1140                table: "ActivityExecutionRecords",
 1141                column: "ActivityId");
 142
 1143            migrationBuilder.CreateIndex(
 1144                name: "IX_ActivityExecutionRecord_ActivityName",
 1145                schema: _schema.Schema,
 1146                table: "ActivityExecutionRecords",
 1147                column: "ActivityName");
 148
 1149            migrationBuilder.CreateIndex(
 1150                name: "IX_ActivityExecutionRecord_ActivityNodeId",
 1151                schema: _schema.Schema,
 1152                table: "ActivityExecutionRecords",
 1153                column: "ActivityNodeId");
 154
 1155            migrationBuilder.CreateIndex(
 1156                name: "IX_ActivityExecutionRecord_ActivityType",
 1157                schema: _schema.Schema,
 1158                table: "ActivityExecutionRecords",
 1159                column: "ActivityType");
 160
 1161            migrationBuilder.CreateIndex(
 1162                name: "IX_ActivityExecutionRecord_ActivityType_ActivityTypeVersion",
 1163                schema: _schema.Schema,
 1164                table: "ActivityExecutionRecords",
 1165                columns: new[] { "ActivityType", "ActivityTypeVersion" });
 166
 1167            migrationBuilder.CreateIndex(
 1168                name: "IX_ActivityExecutionRecord_ActivityTypeVersion",
 1169                schema: _schema.Schema,
 1170                table: "ActivityExecutionRecords",
 1171                column: "ActivityTypeVersion");
 172
 1173            migrationBuilder.CreateIndex(
 1174                name: "IX_ActivityExecutionRecord_CompletedAt",
 1175                schema: _schema.Schema,
 1176                table: "ActivityExecutionRecords",
 1177                column: "CompletedAt");
 178
 1179            migrationBuilder.CreateIndex(
 1180                name: "IX_ActivityExecutionRecord_HasBookmarks",
 1181                schema: _schema.Schema,
 1182                table: "ActivityExecutionRecords",
 1183                column: "HasBookmarks");
 184
 1185            migrationBuilder.CreateIndex(
 1186                name: "IX_ActivityExecutionRecord_StartedAt",
 1187                schema: _schema.Schema,
 1188                table: "ActivityExecutionRecords",
 1189                column: "StartedAt");
 190
 1191            migrationBuilder.CreateIndex(
 1192                name: "IX_ActivityExecutionRecord_Status",
 1193                schema: _schema.Schema,
 1194                table: "ActivityExecutionRecords",
 1195                column: "Status");
 196
 1197            migrationBuilder.CreateIndex(
 1198                name: "IX_ActivityExecutionRecord_WorkflowInstanceId",
 1199                schema: _schema.Schema,
 1200                table: "ActivityExecutionRecords",
 1201                column: "WorkflowInstanceId");
 202
 1203            migrationBuilder.CreateIndex(
 1204                name: "IX_StoredBookmark_ActivityInstanceId",
 1205                schema: _schema.Schema,
 1206                table: "Bookmarks",
 1207                column: "ActivityInstanceId");
 208
 1209            migrationBuilder.CreateIndex(
 1210                name: "IX_StoredBookmark_ActivityTypeName",
 1211                schema: _schema.Schema,
 1212                table: "Bookmarks",
 1213                column: "ActivityTypeName");
 214
 1215            migrationBuilder.CreateIndex(
 1216                name: "IX_StoredBookmark_ActivityTypeName_Hash",
 1217                schema: _schema.Schema,
 1218                table: "Bookmarks",
 1219                columns: new[] { "ActivityTypeName", "Hash" });
 220
 1221            migrationBuilder.CreateIndex(
 1222                name: "IX_StoredBookmark_ActivityTypeName_Hash_WorkflowInstanceId",
 1223                schema: _schema.Schema,
 1224                table: "Bookmarks",
 1225                columns: new[] { "ActivityTypeName", "Hash", "WorkflowInstanceId" });
 226
 1227            migrationBuilder.CreateIndex(
 1228                name: "IX_StoredBookmark_CreatedAt",
 1229                schema: _schema.Schema,
 1230                table: "Bookmarks",
 1231                column: "CreatedAt");
 232
 1233            migrationBuilder.CreateIndex(
 1234                name: "IX_StoredBookmark_Hash",
 1235                schema: _schema.Schema,
 1236                table: "Bookmarks",
 1237                column: "Hash");
 238
 1239            migrationBuilder.CreateIndex(
 1240                name: "IX_StoredBookmark_WorkflowInstanceId",
 1241                schema: _schema.Schema,
 1242                table: "Bookmarks",
 1243                column: "WorkflowInstanceId");
 244
 1245            migrationBuilder.CreateIndex(
 1246                name: "IX_StoredTrigger_Hash",
 1247                schema: _schema.Schema,
 1248                table: "Triggers",
 1249                column: "Hash");
 250
 1251            migrationBuilder.CreateIndex(
 1252                name: "IX_StoredTrigger_Name",
 1253                schema: _schema.Schema,
 1254                table: "Triggers",
 1255                column: "Name");
 256
 1257            migrationBuilder.CreateIndex(
 1258                name: "IX_StoredTrigger_WorkflowDefinitionId",
 1259                schema: _schema.Schema,
 1260                table: "Triggers",
 1261                column: "WorkflowDefinitionId");
 262
 1263            migrationBuilder.CreateIndex(
 1264                name: "IX_StoredTrigger_WorkflowDefinitionVersionId",
 1265                schema: _schema.Schema,
 1266                table: "Triggers",
 1267                column: "WorkflowDefinitionVersionId");
 268
 1269            migrationBuilder.CreateIndex(
 1270                name: "IX_WorkflowExecutionLogRecord_ActivityId",
 1271                schema: _schema.Schema,
 1272                table: "WorkflowExecutionLogRecords",
 1273                column: "ActivityId");
 274
 1275            migrationBuilder.CreateIndex(
 1276                name: "IX_WorkflowExecutionLogRecord_ActivityInstanceId",
 1277                schema: _schema.Schema,
 1278                table: "WorkflowExecutionLogRecords",
 1279                column: "ActivityInstanceId");
 280
 1281            migrationBuilder.CreateIndex(
 1282                name: "IX_WorkflowExecutionLogRecord_ActivityName",
 1283                schema: _schema.Schema,
 1284                table: "WorkflowExecutionLogRecords",
 1285                column: "ActivityName");
 286
 1287            migrationBuilder.CreateIndex(
 1288                name: "IX_WorkflowExecutionLogRecord_ActivityNodeId",
 1289                schema: _schema.Schema,
 1290                table: "WorkflowExecutionLogRecords",
 1291                column: "ActivityNodeId");
 292
 1293            migrationBuilder.CreateIndex(
 1294                name: "IX_WorkflowExecutionLogRecord_ActivityType",
 1295                schema: _schema.Schema,
 1296                table: "WorkflowExecutionLogRecords",
 1297                column: "ActivityType");
 298
 1299            migrationBuilder.CreateIndex(
 1300                name: "IX_WorkflowExecutionLogRecord_ActivityType_ActivityTypeVersion",
 1301                schema: _schema.Schema,
 1302                table: "WorkflowExecutionLogRecords",
 1303                columns: new[] { "ActivityType", "ActivityTypeVersion" });
 304
 1305            migrationBuilder.CreateIndex(
 1306                name: "IX_WorkflowExecutionLogRecord_ActivityTypeVersion",
 1307                schema: _schema.Schema,
 1308                table: "WorkflowExecutionLogRecords",
 1309                column: "ActivityTypeVersion");
 310
 1311            migrationBuilder.CreateIndex(
 1312                name: "IX_WorkflowExecutionLogRecord_EventName",
 1313                schema: _schema.Schema,
 1314                table: "WorkflowExecutionLogRecords",
 1315                column: "EventName");
 316
 1317            migrationBuilder.CreateIndex(
 1318                name: "IX_WorkflowExecutionLogRecord_ParentActivityInstanceId",
 1319                schema: _schema.Schema,
 1320                table: "WorkflowExecutionLogRecords",
 1321                column: "ParentActivityInstanceId");
 322
 1323            migrationBuilder.CreateIndex(
 1324                name: "IX_WorkflowExecutionLogRecord_Sequence",
 1325                schema: _schema.Schema,
 1326                table: "WorkflowExecutionLogRecords",
 1327                column: "Sequence");
 328
 1329            migrationBuilder.CreateIndex(
 1330                name: "IX_WorkflowExecutionLogRecord_Timestamp",
 1331                schema: _schema.Schema,
 1332                table: "WorkflowExecutionLogRecords",
 1333                column: "Timestamp");
 334
 1335            migrationBuilder.CreateIndex(
 1336                name: "IX_WorkflowExecutionLogRecord_Timestamp_Sequence",
 1337                schema: _schema.Schema,
 1338                table: "WorkflowExecutionLogRecords",
 1339                columns: new[] { "Timestamp", "Sequence" });
 340
 1341            migrationBuilder.CreateIndex(
 1342                name: "IX_WorkflowExecutionLogRecord_WorkflowDefinitionId",
 1343                schema: _schema.Schema,
 1344                table: "WorkflowExecutionLogRecords",
 1345                column: "WorkflowDefinitionId");
 346
 1347            migrationBuilder.CreateIndex(
 1348                name: "IX_WorkflowExecutionLogRecord_WorkflowDefinitionVersionId",
 1349                schema: _schema.Schema,
 1350                table: "WorkflowExecutionLogRecords",
 1351                column: "WorkflowDefinitionVersionId");
 352
 1353            migrationBuilder.CreateIndex(
 1354                name: "IX_WorkflowExecutionLogRecord_WorkflowInstanceId",
 1355                schema: _schema.Schema,
 1356                table: "WorkflowExecutionLogRecords",
 1357                column: "WorkflowInstanceId");
 358
 1359            migrationBuilder.CreateIndex(
 1360                name: "IX_WorkflowExecutionLogRecord_WorkflowVersion",
 1361                schema: _schema.Schema,
 1362                table: "WorkflowExecutionLogRecords",
 1363                column: "WorkflowVersion");
 364
 1365            migrationBuilder.CreateIndex(
 1366                name: "IX_WorkflowInboxMessage_ActivityInstanceId",
 1367                schema: _schema.Schema,
 1368                table: "WorkflowInboxMessages",
 1369                column: "ActivityInstanceId");
 370
 1371            migrationBuilder.CreateIndex(
 1372                name: "IX_WorkflowInboxMessage_ActivityTypeName",
 1373                schema: _schema.Schema,
 1374                table: "WorkflowInboxMessages",
 1375                column: "ActivityTypeName");
 376
 1377            migrationBuilder.CreateIndex(
 1378                name: "IX_WorkflowInboxMessage_CorrelationId",
 1379                schema: _schema.Schema,
 1380                table: "WorkflowInboxMessages",
 1381                column: "CorrelationId");
 382
 1383            migrationBuilder.CreateIndex(
 1384                name: "IX_WorkflowInboxMessage_CreatedAt",
 1385                schema: _schema.Schema,
 1386                table: "WorkflowInboxMessages",
 1387                column: "CreatedAt");
 388
 1389            migrationBuilder.CreateIndex(
 1390                name: "IX_WorkflowInboxMessage_ExpiresAt",
 1391                schema: _schema.Schema,
 1392                table: "WorkflowInboxMessages",
 1393                column: "ExpiresAt");
 394
 1395            migrationBuilder.CreateIndex(
 1396                name: "IX_WorkflowInboxMessage_Hash",
 1397                schema: _schema.Schema,
 1398                table: "WorkflowInboxMessages",
 1399                column: "Hash");
 400
 1401            migrationBuilder.CreateIndex(
 1402                name: "IX_WorkflowInboxMessage_WorkflowInstanceId",
 1403                schema: _schema.Schema,
 1404                table: "WorkflowInboxMessages",
 1405                column: "WorkflowInstanceId");
 1406        }
 407
 408        /// <inheritdoc />
 409        protected override void Down(MigrationBuilder migrationBuilder)
 410        {
 0411            migrationBuilder.DropTable(
 0412                name: "ActivityExecutionRecords",
 0413                schema: _schema.Schema);
 414
 0415            migrationBuilder.DropTable(
 0416                name: "Bookmarks",
 0417                schema: _schema.Schema);
 418
 0419            migrationBuilder.DropTable(
 0420                name: "Triggers",
 0421                schema: _schema.Schema);
 422
 0423            migrationBuilder.DropTable(
 0424                name: "WorkflowExecutionLogRecords",
 0425                schema: _schema.Schema);
 426
 0427            migrationBuilder.DropTable(
 0428                name: "WorkflowInboxMessages",
 0429                schema: _schema.Schema);
 0430        }
 431    }
 432}

/home/runner/work/elsa-core/elsa-core/src/modules/Elsa.Persistence.EFCore.SqlServer/Migrations/Runtime/20231024160944_Initial.Designer.cs

#LineLine coverage
 1// <auto-generated />
 2using System;
 3using Elsa.Persistence.EFCore.Modules.Runtime;
 4using Microsoft.EntityFrameworkCore;
 5using Microsoft.EntityFrameworkCore.Infrastructure;
 6using Microsoft.EntityFrameworkCore.Metadata;
 7using Microsoft.EntityFrameworkCore.Migrations;
 8using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
 9
 10#nullable disable
 11
 12namespace Elsa.Persistence.EFCore.SqlServer.Migrations.Runtime
 13{
 14    [DbContext(typeof(RuntimeElsaDbContext))]
 15    [Migration("20231024160944_Initial")]
 16    partial class Initial
 17    {
 18        /// <inheritdoc />
 19        protected override void BuildTargetModel(ModelBuilder modelBuilder)
 20        {
 21#pragma warning disable 612, 618
 122            modelBuilder
 123                .HasDefaultSchema("Elsa")
 124                .HasAnnotation("ProductVersion", "7.0.11")
 125                .HasAnnotation("Relational:MaxIdentifierLength", 128);
 26
 127            SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);
 28
 129            modelBuilder.Entity("Elsa.Workflows.Runtime.Entities.ActivityExecutionRecord", b =>
 130                {
 131                    b.Property<string>("Id")
 132                        .HasColumnType("nvarchar(450)");
 133
 134                    b.Property<string>("ActivityId")
 135                        .IsRequired()
 136                        .HasColumnType("nvarchar(450)");
 137
 138                    b.Property<string>("ActivityName")
 139                        .HasColumnType("nvarchar(450)");
 140
 141                    b.Property<string>("ActivityNodeId")
 142                        .IsRequired()
 143                        .HasColumnType("nvarchar(450)");
 144
 145                    b.Property<string>("ActivityType")
 146                        .IsRequired()
 147                        .HasColumnType("nvarchar(450)");
 148
 149                    b.Property<int>("ActivityTypeVersion")
 150                        .HasColumnType("int");
 151
 152                    b.Property<DateTimeOffset?>("CompletedAt")
 153                        .HasColumnType("datetimeoffset");
 154
 155                    b.Property<bool>("HasBookmarks")
 156                        .HasColumnType("bit");
 157
 158                    b.Property<string>("SerializedActivityState")
 159                        .HasColumnType("nvarchar(max)");
 160
 161                    b.Property<string>("SerializedException")
 162                        .HasColumnType("nvarchar(max)");
 163
 164                    b.Property<string>("SerializedOutputs")
 165                        .HasColumnType("nvarchar(max)");
 166
 167                    b.Property<string>("SerializedPayload")
 168                        .HasColumnType("nvarchar(max)");
 169
 170                    b.Property<DateTimeOffset>("StartedAt")
 171                        .HasColumnType("datetimeoffset");
 172
 173                    b.Property<string>("Status")
 174                        .IsRequired()
 175                        .HasColumnType("nvarchar(450)");
 176
 177                    b.Property<string>("WorkflowInstanceId")
 178                        .IsRequired()
 179                        .HasColumnType("nvarchar(450)");
 180
 181                    b.HasKey("Id");
 182
 183                    b.HasIndex("ActivityId")
 184                        .HasDatabaseName("IX_ActivityExecutionRecord_ActivityId");
 185
 186                    b.HasIndex("ActivityName")
 187                        .HasDatabaseName("IX_ActivityExecutionRecord_ActivityName");
 188
 189                    b.HasIndex("ActivityNodeId")
 190                        .HasDatabaseName("IX_ActivityExecutionRecord_ActivityNodeId");
 191
 192                    b.HasIndex("ActivityType")
 193                        .HasDatabaseName("IX_ActivityExecutionRecord_ActivityType");
 194
 195                    b.HasIndex("ActivityTypeVersion")
 196                        .HasDatabaseName("IX_ActivityExecutionRecord_ActivityTypeVersion");
 197
 198                    b.HasIndex("CompletedAt")
 199                        .HasDatabaseName("IX_ActivityExecutionRecord_CompletedAt");
 1100
 1101                    b.HasIndex("HasBookmarks")
 1102                        .HasDatabaseName("IX_ActivityExecutionRecord_HasBookmarks");
 1103
 1104                    b.HasIndex("StartedAt")
 1105                        .HasDatabaseName("IX_ActivityExecutionRecord_StartedAt");
 1106
 1107                    b.HasIndex("Status")
 1108                        .HasDatabaseName("IX_ActivityExecutionRecord_Status");
 1109
 1110                    b.HasIndex("WorkflowInstanceId")
 1111                        .HasDatabaseName("IX_ActivityExecutionRecord_WorkflowInstanceId");
 1112
 1113                    b.HasIndex("ActivityType", "ActivityTypeVersion")
 1114                        .HasDatabaseName("IX_ActivityExecutionRecord_ActivityType_ActivityTypeVersion");
 1115
 1116                    b.ToTable("ActivityExecutionRecords", "Elsa");
 2117                });
 118
 1119            modelBuilder.Entity("Elsa.Workflows.Runtime.Entities.StoredBookmark", b =>
 1120                {
 1121                    b.Property<string>("BookmarkId")
 1122                        .HasColumnType("nvarchar(450)");
 1123
 1124                    b.Property<string>("ActivityInstanceId")
 1125                        .HasColumnType("nvarchar(450)");
 1126
 1127                    b.Property<string>("ActivityTypeName")
 1128                        .IsRequired()
 1129                        .HasColumnType("nvarchar(450)");
 1130
 1131                    b.Property<string>("CorrelationId")
 1132                        .HasColumnType("nvarchar(max)");
 1133
 1134                    b.Property<DateTimeOffset>("CreatedAt")
 1135                        .HasColumnType("datetimeoffset");
 1136
 1137                    b.Property<string>("Hash")
 1138                        .IsRequired()
 1139                        .HasColumnType("nvarchar(450)");
 1140
 1141                    b.Property<string>("SerializedMetadata")
 1142                        .HasColumnType("nvarchar(max)");
 1143
 1144                    b.Property<string>("SerializedPayload")
 1145                        .HasColumnType("nvarchar(max)");
 1146
 1147                    b.Property<string>("WorkflowInstanceId")
 1148                        .IsRequired()
 1149                        .HasColumnType("nvarchar(450)");
 1150
 1151                    b.HasKey("BookmarkId");
 1152
 1153                    b.HasIndex(new[] { "ActivityInstanceId" }, "IX_StoredBookmark_ActivityInstanceId");
 1154
 1155                    b.HasIndex(new[] { "ActivityTypeName" }, "IX_StoredBookmark_ActivityTypeName");
 1156
 1157                    b.HasIndex(new[] { "ActivityTypeName", "Hash" }, "IX_StoredBookmark_ActivityTypeName_Hash");
 1158
 1159                    b.HasIndex(new[] { "ActivityTypeName", "Hash", "WorkflowInstanceId" }, "IX_StoredBookmark_ActivityTy
 1160
 1161                    b.HasIndex(new[] { "CreatedAt" }, "IX_StoredBookmark_CreatedAt");
 1162
 1163                    b.HasIndex(new[] { "Hash" }, "IX_StoredBookmark_Hash");
 1164
 1165                    b.HasIndex(new[] { "WorkflowInstanceId" }, "IX_StoredBookmark_WorkflowInstanceId");
 1166
 1167                    b.ToTable("Bookmarks", "Elsa");
 2168                });
 169
 1170            modelBuilder.Entity("Elsa.Workflows.Runtime.Entities.StoredTrigger", b =>
 1171                {
 1172                    b.Property<string>("Id")
 1173                        .HasColumnType("nvarchar(450)");
 1174
 1175                    b.Property<string>("ActivityId")
 1176                        .IsRequired()
 1177                        .HasColumnType("nvarchar(max)");
 1178
 1179                    b.Property<string>("Hash")
 1180                        .HasColumnType("nvarchar(450)");
 1181
 1182                    b.Property<string>("Name")
 1183                        .IsRequired()
 1184                        .HasColumnType("nvarchar(450)");
 1185
 1186                    b.Property<string>("SerializedPayload")
 1187                        .HasColumnType("nvarchar(max)");
 1188
 1189                    b.Property<string>("WorkflowDefinitionId")
 1190                        .IsRequired()
 1191                        .HasColumnType("nvarchar(450)");
 1192
 1193                    b.Property<string>("WorkflowDefinitionVersionId")
 1194                        .IsRequired()
 1195                        .HasColumnType("nvarchar(450)");
 1196
 1197                    b.HasKey("Id");
 1198
 1199                    b.HasIndex("Hash")
 1200                        .HasDatabaseName("IX_StoredTrigger_Hash");
 1201
 1202                    b.HasIndex("Name")
 1203                        .HasDatabaseName("IX_StoredTrigger_Name");
 1204
 1205                    b.HasIndex("WorkflowDefinitionId")
 1206                        .HasDatabaseName("IX_StoredTrigger_WorkflowDefinitionId");
 1207
 1208                    b.HasIndex("WorkflowDefinitionVersionId")
 1209                        .HasDatabaseName("IX_StoredTrigger_WorkflowDefinitionVersionId");
 1210
 1211                    b.ToTable("Triggers", "Elsa");
 2212                });
 213
 1214            modelBuilder.Entity("Elsa.Workflows.Runtime.Entities.WorkflowExecutionLogRecord", b =>
 1215                {
 1216                    b.Property<string>("Id")
 1217                        .HasColumnType("nvarchar(450)");
 1218
 1219                    b.Property<string>("ActivityId")
 1220                        .IsRequired()
 1221                        .HasColumnType("nvarchar(450)");
 1222
 1223                    b.Property<string>("ActivityInstanceId")
 1224                        .IsRequired()
 1225                        .HasColumnType("nvarchar(450)");
 1226
 1227                    b.Property<string>("ActivityName")
 1228                        .HasColumnType("nvarchar(450)");
 1229
 1230                    b.Property<string>("ActivityNodeId")
 1231                        .IsRequired()
 1232                        .HasColumnType("nvarchar(450)");
 1233
 1234                    b.Property<string>("ActivityType")
 1235                        .IsRequired()
 1236                        .HasColumnType("nvarchar(450)");
 1237
 1238                    b.Property<int>("ActivityTypeVersion")
 1239                        .HasColumnType("int");
 1240
 1241                    b.Property<string>("EventName")
 1242                        .HasColumnType("nvarchar(450)");
 1243
 1244                    b.Property<string>("Message")
 1245                        .HasColumnType("nvarchar(max)");
 1246
 1247                    b.Property<string>("ParentActivityInstanceId")
 1248                        .HasColumnType("nvarchar(450)");
 1249
 1250                    b.Property<long>("Sequence")
 1251                        .HasColumnType("bigint");
 1252
 1253                    b.Property<string>("SerializedActivityState")
 1254                        .HasColumnType("nvarchar(max)");
 1255
 1256                    b.Property<string>("SerializedPayload")
 1257                        .HasColumnType("nvarchar(max)");
 1258
 1259                    b.Property<string>("Source")
 1260                        .HasColumnType("nvarchar(max)");
 1261
 1262                    b.Property<DateTimeOffset>("Timestamp")
 1263                        .HasColumnType("datetimeoffset");
 1264
 1265                    b.Property<string>("WorkflowDefinitionId")
 1266                        .IsRequired()
 1267                        .HasColumnType("nvarchar(450)");
 1268
 1269                    b.Property<string>("WorkflowDefinitionVersionId")
 1270                        .IsRequired()
 1271                        .HasColumnType("nvarchar(450)");
 1272
 1273                    b.Property<string>("WorkflowInstanceId")
 1274                        .IsRequired()
 1275                        .HasColumnType("nvarchar(450)");
 1276
 1277                    b.Property<int>("WorkflowVersion")
 1278                        .HasColumnType("int");
 1279
 1280                    b.HasKey("Id");
 1281
 1282                    b.HasIndex("ActivityId")
 1283                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_ActivityId");
 1284
 1285                    b.HasIndex("ActivityInstanceId")
 1286                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_ActivityInstanceId");
 1287
 1288                    b.HasIndex("ActivityName")
 1289                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_ActivityName");
 1290
 1291                    b.HasIndex("ActivityNodeId")
 1292                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_ActivityNodeId");
 1293
 1294                    b.HasIndex("ActivityType")
 1295                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_ActivityType");
 1296
 1297                    b.HasIndex("ActivityTypeVersion")
 1298                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_ActivityTypeVersion");
 1299
 1300                    b.HasIndex("EventName")
 1301                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_EventName");
 1302
 1303                    b.HasIndex("ParentActivityInstanceId")
 1304                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_ParentActivityInstanceId");
 1305
 1306                    b.HasIndex("Sequence")
 1307                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_Sequence");
 1308
 1309                    b.HasIndex("Timestamp")
 1310                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_Timestamp");
 1311
 1312                    b.HasIndex("WorkflowDefinitionId")
 1313                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_WorkflowDefinitionId");
 1314
 1315                    b.HasIndex("WorkflowDefinitionVersionId")
 1316                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_WorkflowDefinitionVersionId");
 1317
 1318                    b.HasIndex("WorkflowInstanceId")
 1319                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_WorkflowInstanceId");
 1320
 1321                    b.HasIndex("WorkflowVersion")
 1322                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_WorkflowVersion");
 1323
 1324                    b.HasIndex("ActivityType", "ActivityTypeVersion")
 1325                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_ActivityType_ActivityTypeVersion");
 1326
 1327                    b.HasIndex("Timestamp", "Sequence")
 1328                        .HasDatabaseName("IX_WorkflowExecutionLogRecord_Timestamp_Sequence");
 1329
 1330                    b.ToTable("WorkflowExecutionLogRecords", "Elsa");
 2331                });
 332
 1333            modelBuilder.Entity("Elsa.Workflows.Runtime.Entities.WorkflowInboxMessage", b =>
 1334                {
 1335                    b.Property<string>("Id")
 1336                        .HasColumnType("nvarchar(450)");
 1337
 1338                    b.Property<string>("ActivityInstanceId")
 1339                        .HasColumnType("nvarchar(450)");
 1340
 1341                    b.Property<string>("ActivityTypeName")
 1342                        .IsRequired()
 1343                        .HasColumnType("nvarchar(450)");
 1344
 1345                    b.Property<string>("CorrelationId")
 1346                        .HasColumnType("nvarchar(450)");
 1347
 1348                    b.Property<DateTimeOffset>("CreatedAt")
 1349                        .HasColumnType("datetimeoffset");
 1350
 1351                    b.Property<DateTimeOffset>("ExpiresAt")
 1352                        .HasColumnType("datetimeoffset");
 1353
 1354                    b.Property<string>("Hash")
 1355                        .IsRequired()
 1356                        .HasColumnType("nvarchar(450)");
 1357
 1358                    b.Property<string>("SerializedBookmarkPayload")
 1359                        .HasColumnType("nvarchar(max)");
 1360
 1361                    b.Property<string>("SerializedInput")
 1362                        .HasColumnType("nvarchar(max)");
 1363
 1364                    b.Property<string>("WorkflowInstanceId")
 1365                        .HasColumnType("nvarchar(450)");
 1366
 1367                    b.HasKey("Id");
 1368
 1369                    b.HasIndex(new[] { "ActivityInstanceId" }, "IX_WorkflowInboxMessage_ActivityInstanceId");
 1370
 1371                    b.HasIndex(new[] { "ActivityTypeName" }, "IX_WorkflowInboxMessage_ActivityTypeName");
 1372
 1373                    b.HasIndex(new[] { "CorrelationId" }, "IX_WorkflowInboxMessage_CorrelationId");
 1374
 1375                    b.HasIndex(new[] { "CreatedAt" }, "IX_WorkflowInboxMessage_CreatedAt");
 1376
 1377                    b.HasIndex(new[] { "ExpiresAt" }, "IX_WorkflowInboxMessage_ExpiresAt");
 1378
 1379                    b.HasIndex(new[] { "Hash" }, "IX_WorkflowInboxMessage_Hash");
 1380
 1381                    b.HasIndex(new[] { "WorkflowInstanceId" }, "IX_WorkflowInboxMessage_WorkflowInstanceId");
 1382
 1383                    b.ToTable("WorkflowInboxMessages", "Elsa");
 2384                });
 385#pragma warning restore 612, 618
 1386        }
 387    }
 388}
Generated by: ReportGenerator 5.5.1.0
01/07/2026 - 11:34:28
GitHub | reportgenerator.io

Methods/Properties

.ctor(Elsa.Persistence.EFCore.IElsaDbContextSchema)
Up(Microsoft.EntityFrameworkCore.Migrations.MigrationBuilder)
Down(Microsoft.EntityFrameworkCore.Migrations.MigrationBuilder)
BuildTargetModel(Microsoft.EntityFrameworkCore.ModelBuilder)