using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace IOL.BookmarkThing.Server.Migrations { public partial class AccessTokens : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AlterColumn( name: "created", table: "users", type: "timestamp with time zone", nullable: false, oldClrType: typeof(DateTime), oldType: "timestamp without time zone"); migrationBuilder.AlterColumn( name: "created", table: "entries", type: "timestamp with time zone", nullable: false, oldClrType: typeof(DateTime), oldType: "timestamp without time zone"); migrationBuilder.CreateTable( name: "access_tokens", columns: table => new { id = table.Column(type: "uuid", nullable: false), user_id = table.Column(type: "uuid", nullable: true), expiry_date = table.Column(type: "timestamp with time zone", nullable: false), allow_read = table.Column(type: "boolean", nullable: false), allow_create = table.Column(type: "boolean", nullable: false), allow_update = table.Column(type: "boolean", nullable: false), allow_delete = table.Column(type: "boolean", nullable: false), created = table.Column(type: "timestamp with time zone", nullable: false) }, constraints: table => { table.PrimaryKey("pk_access_tokens", x => x.id); table.ForeignKey( name: "fk_access_tokens_users_user_id", column: x => x.user_id, principalTable: "users", principalColumn: "id"); }); migrationBuilder.CreateIndex( name: "ix_access_tokens_user_id", table: "access_tokens", column: "user_id"); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "access_tokens"); migrationBuilder.AlterColumn( name: "created", table: "users", type: "timestamp without time zone", nullable: false, oldClrType: typeof(DateTime), oldType: "timestamp with time zone"); migrationBuilder.AlterColumn( name: "created", table: "entries", type: "timestamp without time zone", nullable: false, oldClrType: typeof(DateTime), oldType: "timestamp with time zone"); } } }