using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace IOL.GreatOffice.Api.Migrations { public partial class ApiAccessTokens : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "api_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_at = table.Column(type: "timestamp with time zone", nullable: false), modified_at = table.Column(type: "timestamp with time zone", nullable: true) }, constraints: table => { table.PrimaryKey("pk_api_access_tokens", x => x.id); table.ForeignKey( name: "fk_api_access_tokens_users_user_id", column: x => x.user_id, principalTable: "users", principalColumn: "id"); }); migrationBuilder.CreateIndex( name: "ix_api_access_tokens_user_id", table: "api_access_tokens", column: "user_id"); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "api_access_tokens"); } } }