diff options
Diffstat (limited to 'code/api/Migrations')
7 files changed, 689 insertions, 63 deletions
diff --git a/code/api/Migrations/20221221214429_InitialYay.Designer.cs b/code/api/Migrations/20221221214429_InitialYay.Designer.cs index e368363..a773078 100644 --- a/code/api/Migrations/20221221214429_InitialYay.Designer.cs +++ b/code/api/Migrations/20221221214429_InitialYay.Designer.cs @@ -1,15 +1,11 @@ // <auto-generated /> -using System; -using I2R.Storage.Api.Database; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Migrations; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; #nullable disable -namespace I2R.Storage.Api.Migrations +using Microsoft.EntityFrameworkCore.Infrastructure; +using Microsoft.EntityFrameworkCore.Migrations; + +namespace Quality.Storage.Api.Migrations { [DbContext(typeof(AppDatabase))] [Migration("20221221214429_InitialYay")] diff --git a/code/api/Migrations/20221221214429_InitialYay.cs b/code/api/Migrations/20221221214429_InitialYay.cs index 122e3d9..e66d8ff 100644 --- a/code/api/Migrations/20221221214429_InitialYay.cs +++ b/code/api/Migrations/20221221214429_InitialYay.cs @@ -1,9 +1,8 @@ -using System; -using Microsoft.EntityFrameworkCore.Migrations; +#nullable disable -#nullable disable +using Microsoft.EntityFrameworkCore.Migrations; -namespace I2R.Storage.Api.Migrations +namespace Quality.Storage.Api.Migrations { /// <inheritdoc /> public partial class InitialYay : Migration diff --git a/code/api/Migrations/20221222153132_FolderParent.Designer.cs b/code/api/Migrations/20221222153132_FolderParent.Designer.cs index 0ad7936..d670c93 100644 --- a/code/api/Migrations/20221222153132_FolderParent.Designer.cs +++ b/code/api/Migrations/20221222153132_FolderParent.Designer.cs @@ -1,15 +1,11 @@ // <auto-generated /> -using System; -using I2R.Storage.Api.Database; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Migrations; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; #nullable disable -namespace I2R.Storage.Api.Migrations +using Microsoft.EntityFrameworkCore.Infrastructure; +using Microsoft.EntityFrameworkCore.Migrations; + +namespace Quality.Storage.Api.Migrations { [DbContext(typeof(AppDatabase))] [Migration("20221222153132_FolderParent")] @@ -25,7 +21,7 @@ namespace I2R.Storage.Api.Migrations NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.File", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() @@ -93,7 +89,7 @@ namespace I2R.Storage.Api.Migrations b.ToTable("files", (string)null); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.Folder", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() @@ -153,7 +149,7 @@ namespace I2R.Storage.Api.Migrations b.ToTable("folders", (string)null); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.Permission", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.Permission", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() @@ -231,7 +227,7 @@ namespace I2R.Storage.Api.Migrations b.ToTable("permissions", (string)null); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.PermissionGroup", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.PermissionGroup", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() @@ -280,7 +276,7 @@ namespace I2R.Storage.Api.Migrations b.ToTable("permission_groups", (string)null); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.User", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.User", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() @@ -352,9 +348,9 @@ namespace I2R.Storage.Api.Migrations b.ToTable("users", (string)null); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.File", b => { - b.HasOne("I2R.Storage.Api.Database.Models.Folder", "Folder") + b.HasOne("Quality.Storage.Api.Database.Models.Folder", "Folder") .WithMany("Files") .HasForeignKey("FolderId") .OnDelete(DeleteBehavior.Cascade) @@ -364,9 +360,9 @@ namespace I2R.Storage.Api.Migrations b.Navigation("Folder"); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.Folder", b => { - b.HasOne("I2R.Storage.Api.Database.Models.Folder", "Parent") + b.HasOne("Quality.Storage.Api.Database.Models.Folder", "Parent") .WithMany() .HasForeignKey("ParentId") .HasConstraintName("fk_folders_folders_parent_id"); @@ -374,19 +370,19 @@ namespace I2R.Storage.Api.Migrations b.Navigation("Parent"); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.Permission", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.Permission", b => { - b.HasOne("I2R.Storage.Api.Database.Models.File", null) + b.HasOne("Quality.Storage.Api.Database.Models.File", null) .WithMany("Permissions") .HasForeignKey("FileId") .HasConstraintName("fk_permissions_files_file_id"); - b.HasOne("I2R.Storage.Api.Database.Models.Folder", null) + b.HasOne("Quality.Storage.Api.Database.Models.Folder", null) .WithMany("Permissions") .HasForeignKey("FolderId") .HasConstraintName("fk_permissions_folders_folder_id"); - b.HasOne("I2R.Storage.Api.Database.Models.PermissionGroup", "Group") + b.HasOne("Quality.Storage.Api.Database.Models.PermissionGroup", "Group") .WithMany() .HasForeignKey("GroupId") .OnDelete(DeleteBehavior.Cascade) @@ -396,27 +392,27 @@ namespace I2R.Storage.Api.Migrations b.Navigation("Group"); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.User", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.User", b => { - b.HasOne("I2R.Storage.Api.Database.Models.PermissionGroup", null) + b.HasOne("Quality.Storage.Api.Database.Models.PermissionGroup", null) .WithMany("Users") .HasForeignKey("PermissionGroupId") .HasConstraintName("fk_users_permission_groups_permission_group_id"); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.File", b => { b.Navigation("Permissions"); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.Folder", b => { b.Navigation("Files"); b.Navigation("Permissions"); }); - modelBuilder.Entity("I2R.Storage.Api.Database.Models.PermissionGroup", b => + modelBuilder.Entity("Quality.Storage.Api.Database.Models.PermissionGroup", b => { b.Navigation("Users"); }); diff --git a/code/api/Migrations/20221222153132_FolderParent.cs b/code/api/Migrations/20221222153132_FolderParent.cs index c88bd81..baa85d7 100644 --- a/code/api/Migrations/20221222153132_FolderParent.cs +++ b/code/api/Migrations/20221222153132_FolderParent.cs @@ -1,9 +1,8 @@ -using System; -using Microsoft.EntityFrameworkCore.Migrations; - #nullable disable -namespace I2R.Storage.Api.Migrations +using Microsoft.EntityFrameworkCore.Migrations; + +namespace Quality.Storage.Api.Migrations { /// <inheritdoc /> public partial class FolderParent : Migration diff --git a/code/api/Migrations/20240224160817_UpdateFeb2024.Designer.cs b/code/api/Migrations/20240224160817_UpdateFeb2024.Designer.cs new file mode 100644 index 0000000..7544195 --- /dev/null +++ b/code/api/Migrations/20240224160817_UpdateFeb2024.Designer.cs @@ -0,0 +1,427 @@ +// <auto-generated /> + +#nullable disable + +using Microsoft.EntityFrameworkCore.Infrastructure; +using Microsoft.EntityFrameworkCore.Migrations; + +namespace Quality.Storage.Api.Migrations +{ + [DbContext(typeof(AppDatabase))] + [Migration("20240224160817_UpdateFeb2024")] + partial class UpdateFeb2024 + { + /// <inheritdoc /> + protected override void BuildTargetModel(ModelBuilder modelBuilder) + { +#pragma warning disable 612, 618 + modelBuilder + .HasAnnotation("ProductVersion", "8.0.2") + .HasAnnotation("Relational:MaxIdentifierLength", 63); + + NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uuid") + .HasColumnName("id"); + + b.Property<DateTime>("CreatedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("created_at"); + + b.Property<Guid?>("CreatedBy") + .HasColumnType("uuid") + .HasColumnName("created_by"); + + b.Property<Guid>("FolderId") + .HasColumnType("uuid") + .HasColumnName("folder_id"); + + b.Property<bool>("IsBinned") + .HasColumnType("boolean") + .HasColumnName("is_binned"); + + b.Property<bool>("IsEncrypted") + .HasColumnType("boolean") + .HasColumnName("is_encrypted"); + + b.Property<DateTime?>("LastDeletedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_deleted_at"); + + b.Property<Guid?>("LastDeletedBy") + .HasColumnType("uuid") + .HasColumnName("last_deleted_by"); + + b.Property<DateTime?>("LastModifiedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_modified_at"); + + b.Property<Guid?>("LastModifiedBy") + .HasColumnType("uuid") + .HasColumnName("last_modified_by"); + + b.Property<string>("MimeType") + .HasMaxLength(100) + .HasColumnType("character varying(100)") + .HasColumnName("mime_type"); + + b.Property<string>("Name") + .HasMaxLength(200) + .HasColumnType("character varying(200)") + .HasColumnName("name"); + + b.Property<Guid?>("OwningUserId") + .HasColumnType("uuid") + .HasColumnName("owning_user_id"); + + b.Property<long>("SizeInBytes") + .HasColumnType("bigint") + .HasColumnName("size_in_bytes"); + + b.HasKey("Id") + .HasName("pk_files"); + + b.HasIndex("FolderId") + .HasDatabaseName("ix_files_folder_id"); + + b.ToTable("files", (string)null); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uuid") + .HasColumnName("id"); + + b.Property<DateTime>("CreatedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("created_at"); + + b.Property<Guid?>("CreatedBy") + .HasColumnType("uuid") + .HasColumnName("created_by"); + + b.Property<bool>("IsBinned") + .HasColumnType("boolean") + .HasColumnName("is_binned"); + + b.Property<bool>("IsEncrypted") + .HasColumnType("boolean") + .HasColumnName("is_encrypted"); + + b.Property<DateTime?>("LastDeletedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_deleted_at"); + + b.Property<Guid?>("LastDeletedBy") + .HasColumnType("uuid") + .HasColumnName("last_deleted_by"); + + b.Property<DateTime?>("LastModifiedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_modified_at"); + + b.Property<Guid?>("LastModifiedBy") + .HasColumnType("uuid") + .HasColumnName("last_modified_by"); + + b.Property<string>("Name") + .HasMaxLength(200) + .HasColumnType("character varying(200)") + .HasColumnName("name"); + + b.Property<Guid?>("OwningUserId") + .HasColumnType("uuid") + .HasColumnName("owning_user_id"); + + b.Property<Guid?>("ParentId") + .HasColumnType("uuid") + .HasColumnName("parent_id"); + + b.HasKey("Id") + .HasName("pk_folders"); + + b.HasIndex("ParentId") + .HasDatabaseName("ix_folders_parent_id"); + + b.ToTable("folders", (string)null); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.Permission", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uuid") + .HasColumnName("id"); + + b.Property<bool>("CanRead") + .HasColumnType("boolean") + .HasColumnName("can_read"); + + b.Property<bool>("CanWrite") + .HasColumnType("boolean") + .HasColumnName("can_write"); + + b.Property<Guid>("ContentId") + .HasColumnType("uuid") + .HasColumnName("content_id"); + + b.Property<DateTime>("CreatedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("created_at"); + + b.Property<Guid?>("CreatedBy") + .HasColumnType("uuid") + .HasColumnName("created_by"); + + b.Property<Guid?>("FileId") + .HasColumnType("uuid") + .HasColumnName("file_id"); + + b.Property<Guid?>("FolderId") + .HasColumnType("uuid") + .HasColumnName("folder_id"); + + b.Property<Guid>("GroupId") + .HasColumnType("uuid") + .HasColumnName("group_id"); + + b.Property<bool>("IsFile") + .HasColumnType("boolean") + .HasColumnName("is_file"); + + b.Property<DateTime?>("LastDeletedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_deleted_at"); + + b.Property<Guid?>("LastDeletedBy") + .HasColumnType("uuid") + .HasColumnName("last_deleted_by"); + + b.Property<DateTime?>("LastModifiedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_modified_at"); + + b.Property<Guid?>("LastModifiedBy") + .HasColumnType("uuid") + .HasColumnName("last_modified_by"); + + b.Property<Guid?>("OwningUserId") + .HasColumnType("uuid") + .HasColumnName("owning_user_id"); + + b.HasKey("Id") + .HasName("pk_permissions"); + + b.HasIndex("FileId") + .HasDatabaseName("ix_permissions_file_id"); + + b.HasIndex("FolderId") + .HasDatabaseName("ix_permissions_folder_id"); + + b.HasIndex("GroupId") + .HasDatabaseName("ix_permissions_group_id"); + + b.ToTable("permissions", (string)null); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.PermissionGroup", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uuid") + .HasColumnName("id"); + + b.Property<DateTime>("CreatedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("created_at"); + + b.Property<Guid?>("CreatedBy") + .HasColumnType("uuid") + .HasColumnName("created_by"); + + b.Property<string>("Description") + .HasMaxLength(450) + .HasColumnType("character varying(450)") + .HasColumnName("description"); + + b.Property<DateTime?>("LastDeletedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_deleted_at"); + + b.Property<Guid?>("LastDeletedBy") + .HasColumnType("uuid") + .HasColumnName("last_deleted_by"); + + b.Property<DateTime?>("LastModifiedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_modified_at"); + + b.Property<Guid?>("LastModifiedBy") + .HasColumnType("uuid") + .HasColumnName("last_modified_by"); + + b.Property<string>("Name") + .HasMaxLength(100) + .HasColumnType("character varying(100)") + .HasColumnName("name"); + + b.Property<Guid?>("OwningUserId") + .HasColumnType("uuid") + .HasColumnName("owning_user_id"); + + b.HasKey("Id") + .HasName("pk_permission_groups"); + + b.ToTable("permission_groups", (string)null); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.User", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uuid") + .HasColumnName("id"); + + b.Property<DateTime>("CreatedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("created_at"); + + b.Property<Guid?>("CreatedBy") + .HasColumnType("uuid") + .HasColumnName("created_by"); + + b.Property<string>("FirstName") + .HasMaxLength(100) + .HasColumnType("character varying(100)") + .HasColumnName("first_name"); + + b.Property<DateTime?>("LastDeletedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_deleted_at"); + + b.Property<Guid?>("LastDeletedBy") + .HasColumnType("uuid") + .HasColumnName("last_deleted_by"); + + b.Property<DateTime?>("LastLoggedOn") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_logged_on"); + + b.Property<DateTime?>("LastModifiedAt") + .HasColumnType("timestamp with time zone") + .HasColumnName("last_modified_at"); + + b.Property<Guid?>("LastModifiedBy") + .HasColumnType("uuid") + .HasColumnName("last_modified_by"); + + b.Property<string>("LastName") + .HasMaxLength(100) + .HasColumnType("character varying(100)") + .HasColumnName("last_name"); + + b.Property<string>("Password") + .HasMaxLength(100) + .HasColumnType("character varying(100)") + .HasColumnName("password"); + + b.Property<Guid?>("PermissionGroupId") + .HasColumnType("uuid") + .HasColumnName("permission_group_id"); + + b.Property<int>("Role") + .HasColumnType("integer") + .HasColumnName("role"); + + b.Property<string>("Username") + .HasMaxLength(100) + .HasColumnType("character varying(100)") + .HasColumnName("username"); + + b.HasKey("Id") + .HasName("pk_users"); + + b.HasIndex("PermissionGroupId") + .HasDatabaseName("ix_users_permission_group_id"); + + b.ToTable("users", (string)null); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b => + { + b.HasOne("I2R.Storage.Api.Database.Models.Folder", "Folder") + .WithMany("Files") + .HasForeignKey("FolderId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired() + .HasConstraintName("fk_files_folders_folder_id"); + + b.Navigation("Folder"); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b => + { + b.HasOne("I2R.Storage.Api.Database.Models.Folder", "Parent") + .WithMany() + .HasForeignKey("ParentId") + .HasConstraintName("fk_folders_folders_parent_id"); + + b.Navigation("Parent"); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.Permission", b => + { + b.HasOne("I2R.Storage.Api.Database.Models.File", null) + .WithMany("Permissions") + .HasForeignKey("FileId") + .HasConstraintName("fk_permissions_files_file_id"); + + b.HasOne("I2R.Storage.Api.Database.Models.Folder", null) + .WithMany("Permissions") + .HasForeignKey("FolderId") + .HasConstraintName("fk_permissions_folders_folder_id"); + + b.HasOne("I2R.Storage.Api.Database.Models.PermissionGroup", "Group") + .WithMany() + .HasForeignKey("GroupId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired() + .HasConstraintName("fk_permissions_permission_groups_group_id"); + + b.Navigation("Group"); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.User", b => + { + b.HasOne("I2R.Storage.Api.Database.Models.PermissionGroup", null) + .WithMany("Users") + .HasForeignKey("PermissionGroupId") + .HasConstraintName("fk_users_permission_groups_permission_group_id"); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b => + { + b.Navigation("Permissions"); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b => + { + b.Navigation("Files"); + + b.Navigation("Permissions"); + }); + + modelBuilder.Entity("I2R.Storage.Api.Database.Models.PermissionGroup", b => + { + b.Navigation("Users"); + }); +#pragma warning restore 612, 618 + } + } +} diff --git a/code/api/Migrations/20240224160817_UpdateFeb2024.cs b/code/api/Migrations/20240224160817_UpdateFeb2024.cs new file mode 100644 index 0000000..71432c5 --- /dev/null +++ b/code/api/Migrations/20240224160817_UpdateFeb2024.cs @@ -0,0 +1,208 @@ +#nullable disable + +using Microsoft.EntityFrameworkCore.Migrations; + +namespace Quality.Storage.Api.Migrations +{ + /// <inheritdoc /> + public partial class UpdateFeb2024 : Migration + { + /// <inheritdoc /> + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropColumn( + name: "owning_user_id", + table: "users"); + + migrationBuilder.AlterColumn<string>( + name: "username", + table: "users", + type: "character varying(100)", + maxLength: 100, + nullable: true, + oldClrType: typeof(string), + oldType: "text", + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "password", + table: "users", + type: "character varying(100)", + maxLength: 100, + nullable: true, + oldClrType: typeof(string), + oldType: "text", + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "last_name", + table: "users", + type: "character varying(100)", + maxLength: 100, + nullable: true, + oldClrType: typeof(string), + oldType: "text", + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "first_name", + table: "users", + type: "character varying(100)", + maxLength: 100, + nullable: true, + oldClrType: typeof(string), + oldType: "text", + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "name", + table: "permission_groups", + type: "character varying(100)", + maxLength: 100, + nullable: true, + oldClrType: typeof(string), + oldType: "text", + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "description", + table: "permission_groups", + type: "character varying(450)", + maxLength: 450, + nullable: true, + oldClrType: typeof(string), + oldType: "text", + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "name", + table: "folders", + type: "character varying(200)", + maxLength: 200, + nullable: true, + oldClrType: typeof(string), + oldType: "text", + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "name", + table: "files", + type: "character varying(200)", + maxLength: 200, + nullable: true, + oldClrType: typeof(string), + oldType: "text", + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "mime_type", + table: "files", + type: "character varying(100)", + maxLength: 100, + nullable: true, + oldClrType: typeof(string), + oldType: "text", + oldNullable: true); + } + + /// <inheritdoc /> + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.AlterColumn<string>( + name: "username", + table: "users", + type: "text", + nullable: true, + oldClrType: typeof(string), + oldType: "character varying(100)", + oldMaxLength: 100, + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "password", + table: "users", + type: "text", + nullable: true, + oldClrType: typeof(string), + oldType: "character varying(100)", + oldMaxLength: 100, + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "last_name", + table: "users", + type: "text", + nullable: true, + oldClrType: typeof(string), + oldType: "character varying(100)", + oldMaxLength: 100, + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "first_name", + table: "users", + type: "text", + nullable: true, + oldClrType: typeof(string), + oldType: "character varying(100)", + oldMaxLength: 100, + oldNullable: true); + + migrationBuilder.AddColumn<Guid>( + name: "owning_user_id", + table: "users", + type: "uuid", + nullable: true); + + migrationBuilder.AlterColumn<string>( + name: "name", + table: "permission_groups", + type: "text", + nullable: true, + oldClrType: typeof(string), + oldType: "character varying(100)", + oldMaxLength: 100, + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "description", + table: "permission_groups", + type: "text", + nullable: true, + oldClrType: typeof(string), + oldType: "character varying(450)", + oldMaxLength: 450, + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "name", + table: "folders", + type: "text", + nullable: true, + oldClrType: typeof(string), + oldType: "character varying(200)", + oldMaxLength: 200, + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "name", + table: "files", + type: "text", + nullable: true, + oldClrType: typeof(string), + oldType: "character varying(200)", + oldMaxLength: 200, + oldNullable: true); + + migrationBuilder.AlterColumn<string>( + name: "mime_type", + table: "files", + type: "text", + nullable: true, + oldClrType: typeof(string), + oldType: "character varying(100)", + oldMaxLength: 100, + oldNullable: true); + } + } +} diff --git a/code/api/Migrations/AppDatabaseModelSnapshot.cs b/code/api/Migrations/AppDatabaseModelSnapshot.cs index 4d471ce..c159966 100644 --- a/code/api/Migrations/AppDatabaseModelSnapshot.cs +++ b/code/api/Migrations/AppDatabaseModelSnapshot.cs @@ -1,14 +1,10 @@ // <auto-generated /> -using System; -using I2R.Storage.Api.Database; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; #nullable disable -namespace I2R.Storage.Api.Migrations +using Microsoft.EntityFrameworkCore.Infrastructure; + +namespace Quality.Storage.Api.Migrations { [DbContext(typeof(AppDatabase))] partial class AppDatabaseModelSnapshot : ModelSnapshot @@ -17,7 +13,7 @@ namespace I2R.Storage.Api.Migrations { #pragma warning disable 612, 618 modelBuilder - .HasAnnotation("ProductVersion", "7.0.1") + .HasAnnotation("ProductVersion", "8.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 63); NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); @@ -66,11 +62,13 @@ namespace I2R.Storage.Api.Migrations .HasColumnName("last_modified_by"); b.Property<string>("MimeType") - .HasColumnType("text") + .HasMaxLength(100) + .HasColumnType("character varying(100)") .HasColumnName("mime_type"); b.Property<string>("Name") - .HasColumnType("text") + .HasMaxLength(200) + .HasColumnType("character varying(200)") .HasColumnName("name"); b.Property<Guid?>("OwningUserId") @@ -130,7 +128,8 @@ namespace I2R.Storage.Api.Migrations .HasColumnName("last_modified_by"); b.Property<string>("Name") - .HasColumnType("text") + .HasMaxLength(200) + .HasColumnType("character varying(200)") .HasColumnName("name"); b.Property<Guid?>("OwningUserId") @@ -244,7 +243,8 @@ namespace I2R.Storage.Api.Migrations .HasColumnName("created_by"); b.Property<string>("Description") - .HasColumnType("text") + .HasMaxLength(450) + .HasColumnType("character varying(450)") .HasColumnName("description"); b.Property<DateTime?>("LastDeletedAt") @@ -264,7 +264,8 @@ namespace I2R.Storage.Api.Migrations .HasColumnName("last_modified_by"); b.Property<string>("Name") - .HasColumnType("text") + .HasMaxLength(100) + .HasColumnType("character varying(100)") .HasColumnName("name"); b.Property<Guid?>("OwningUserId") @@ -293,7 +294,8 @@ namespace I2R.Storage.Api.Migrations .HasColumnName("created_by"); b.Property<string>("FirstName") - .HasColumnType("text") + .HasMaxLength(100) + .HasColumnType("character varying(100)") .HasColumnName("first_name"); b.Property<DateTime?>("LastDeletedAt") @@ -317,15 +319,13 @@ namespace I2R.Storage.Api.Migrations .HasColumnName("last_modified_by"); b.Property<string>("LastName") - .HasColumnType("text") + .HasMaxLength(100) + .HasColumnType("character varying(100)") .HasColumnName("last_name"); - b.Property<Guid?>("OwningUserId") - .HasColumnType("uuid") - .HasColumnName("owning_user_id"); - b.Property<string>("Password") - .HasColumnType("text") + .HasMaxLength(100) + .HasColumnType("character varying(100)") .HasColumnName("password"); b.Property<Guid?>("PermissionGroupId") @@ -337,7 +337,8 @@ namespace I2R.Storage.Api.Migrations .HasColumnName("role"); b.Property<string>("Username") - .HasColumnType("text") + .HasMaxLength(100) + .HasColumnType("character varying(100)") .HasColumnName("username"); b.HasKey("Id") |