using System; using Microsoft.EntityFrameworkCore.Migrations; using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; #nullable disable namespace DugunSalonu.Migrations { /// public partial class mig12 : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "organizasyon", columns: table => new { id = table.Column(type: "integer", nullable: false) .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), rezervasyontarihi = table.Column(type: "date", nullable: false), sozlesmetarihi = table.Column(type: "date", nullable: false), organizasyontarihi = table.Column(type: "date", nullable: false), organizasyonsaati = table.Column(type: "text", nullable: false), adi = table.Column(type: "character varying(50)", maxLength: 50, nullable: false), soyadi = table.Column(type: "character varying(50)", maxLength: 50, nullable: false), ceptel = table.Column(type: "integer", maxLength: 10, nullable: false), ceptel2 = table.Column(type: "integer", maxLength: 10, nullable: true), gelinyore = table.Column(type: "character varying(30)", maxLength: 30, nullable: false), damatyore = table.Column(type: "character varying(30)", maxLength: 30, nullable: false), aciklama = table.Column(type: "character varying(400)", maxLength: 400, nullable: false), organizasyondurum = table.Column(type: "character varying(10)", maxLength: 10, nullable: false), fiyat = table.Column(type: "numeric(18,2)", nullable: false), kts = table.Column(type: "timestamp with time zone", nullable: false), kk = table.Column(type: "integer", nullable: false), sozlesme = table.Column(type: "bytea", nullable: true), iptal = table.Column(type: "integer", nullable: true), iptalkk = table.Column(type: "integer", nullable: true), iptalkts = table.Column(type: "timestamp with time zone", nullable: true), iptalaciklama = table.Column(type: "character varying(200)", maxLength: 200, nullable: true) }, constraints: table => { table.PrimaryKey("PK_organizasyon", x => x.id); }); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "organizasyon"); } } }