866 lines
35 KiB
C#
866 lines
35 KiB
C#
using Microsoft.EntityFrameworkCore.Migrations;
|
|
|
|
#nullable disable
|
|
|
|
namespace BMA.EHR.Recurit.Exam.Service.Migrations
|
|
{
|
|
/// <inheritdoc />
|
|
public partial class updatetableCandidatefeildnull : Migration
|
|
{
|
|
/// <inheritdoc />
|
|
protected override void Up(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "Telephone",
|
|
table: "Candidates",
|
|
type: "varchar(20)",
|
|
maxLength: 20,
|
|
nullable: true,
|
|
comment: "โทรศัพท์",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(20)",
|
|
oldMaxLength: 20,
|
|
oldComment: "โทรศัพท์")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "RegistZipCode",
|
|
table: "Candidates",
|
|
type: "varchar(10)",
|
|
maxLength: 10,
|
|
nullable: true,
|
|
comment: "รหัสไปรษณีย์ที่อยู่ตามทะเบียนบ้าน",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(10)",
|
|
oldMaxLength: 10,
|
|
oldComment: "รหัสไปรษณีย์ที่อยู่ตามทะเบียนบ้าน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<bool>(
|
|
name: "RegistSame",
|
|
table: "Candidates",
|
|
type: "tinyint(1)",
|
|
nullable: true,
|
|
comment: "ที่อยู่ปัจจุบันเหมือนที่อยู่ตามทะเบียนบ้าน",
|
|
oldClrType: typeof(bool),
|
|
oldType: "tinyint(1)",
|
|
oldComment: "ที่อยู่ปัจจุบันเหมือนที่อยู่ตามทะเบียนบ้าน");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "RegistAddress",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: true,
|
|
comment: "ที่อยู่ตามทะเบียนบ้าน",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldComment: "ที่อยู่ตามทะเบียนบ้าน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "OccupationType",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: true,
|
|
comment: "ประเภทอาชีพที่ทำงานมาก่อน",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldComment: "ประเภทอาชีพที่ทำงานมาก่อน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "OccupationTelephone",
|
|
table: "Candidates",
|
|
type: "varchar(20)",
|
|
maxLength: 20,
|
|
nullable: true,
|
|
comment: "โทรศัพท์ บริษัท",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(20)",
|
|
oldMaxLength: 20,
|
|
oldComment: "โทรศัพท์ บริษัท")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "OccupationEmail",
|
|
table: "Candidates",
|
|
type: "varchar(200)",
|
|
maxLength: 200,
|
|
nullable: true,
|
|
comment: "อีเมล บริษัท",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(200)",
|
|
oldMaxLength: 200,
|
|
oldComment: "อีเมล บริษัท")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "OccupationDepartment",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: true,
|
|
comment: "กอง/ฝ่าย บริษัท",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldComment: "กอง/ฝ่าย บริษัท")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "OccupationCompany",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: true,
|
|
comment: "สำนัก/บริษัท บริษัท",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldComment: "สำนัก/บริษัท บริษัท")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "Nationality",
|
|
table: "Candidates",
|
|
type: "varchar(40)",
|
|
maxLength: 40,
|
|
nullable: true,
|
|
comment: "สัญชาติ",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(40)",
|
|
oldMaxLength: 40,
|
|
oldComment: "สัญชาติ")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "MotherLastName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: true,
|
|
comment: "นามสกุลมารดา",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldComment: "นามสกุลมารดา")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "MotherFirstName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: true,
|
|
comment: "ชื่อจริงมารดา",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldComment: "ชื่อจริงมารดา")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "MobilePhone",
|
|
table: "Candidates",
|
|
type: "varchar(20)",
|
|
maxLength: 20,
|
|
nullable: true,
|
|
comment: "โทรศัพท์มือถือ",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(20)",
|
|
oldMaxLength: 20,
|
|
oldComment: "โทรศัพท์มือถือ")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "MarryLastName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: true,
|
|
comment: "นามสกุลคู่สมรส",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldComment: "นามสกุลคู่สมรส")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "MarryFirstName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: true,
|
|
comment: "ชื่อจริงคู่สมรส",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldComment: "ชื่อจริงคู่สมรส")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<bool>(
|
|
name: "Marry",
|
|
table: "Candidates",
|
|
type: "tinyint(1)",
|
|
nullable: true,
|
|
comment: "คู่สมรส",
|
|
oldClrType: typeof(bool),
|
|
oldType: "tinyint(1)",
|
|
oldComment: "คู่สมรส");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "LastName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: true,
|
|
comment: "นามสกุล",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldComment: "นามสกุล")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "Knowledge",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: true,
|
|
comment: "ความสามารถพิเศษ",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldComment: "ความสามารถพิเศษ")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "FirstName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: true,
|
|
comment: "ชื่อจริง",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldComment: "ชื่อจริง")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "FatherLastName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: true,
|
|
comment: "นามสกุลบิดา",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldComment: "นามสกุลบิดา")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "FatherFirstName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: true,
|
|
comment: "ชื่อจริงบิดา",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldComment: "ชื่อจริงบิดา")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "Email",
|
|
table: "Candidates",
|
|
type: "varchar(200)",
|
|
maxLength: 200,
|
|
nullable: true,
|
|
comment: "อีเมล",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(200)",
|
|
oldMaxLength: 200,
|
|
oldComment: "อีเมล")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "CurrentZipCode",
|
|
table: "Candidates",
|
|
type: "varchar(10)",
|
|
maxLength: 10,
|
|
nullable: true,
|
|
comment: "รหัสไปรษณีย์ที่อยู่ปัจจุบัน",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(10)",
|
|
oldMaxLength: 10,
|
|
oldComment: "รหัสไปรษณีย์ที่อยู่ปัจจุบัน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "CurrentAddress",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: true,
|
|
comment: "ที่อยู่ปัจจุบัน",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldComment: "ที่อยู่ปัจจุบัน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "CitizenId",
|
|
table: "Candidates",
|
|
type: "varchar(20)",
|
|
maxLength: 20,
|
|
nullable: true,
|
|
comment: "เลขประจำตัวประชาชน",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(20)",
|
|
oldMaxLength: 20,
|
|
oldComment: "เลขประจำตัวประชาชน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
}
|
|
|
|
/// <inheritdoc />
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "Telephone",
|
|
keyValue: null,
|
|
column: "Telephone",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "Telephone",
|
|
table: "Candidates",
|
|
type: "varchar(20)",
|
|
maxLength: 20,
|
|
nullable: false,
|
|
comment: "โทรศัพท์",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(20)",
|
|
oldMaxLength: 20,
|
|
oldNullable: true,
|
|
oldComment: "โทรศัพท์")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "RegistZipCode",
|
|
keyValue: null,
|
|
column: "RegistZipCode",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "RegistZipCode",
|
|
table: "Candidates",
|
|
type: "varchar(10)",
|
|
maxLength: 10,
|
|
nullable: false,
|
|
comment: "รหัสไปรษณีย์ที่อยู่ตามทะเบียนบ้าน",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(10)",
|
|
oldMaxLength: 10,
|
|
oldNullable: true,
|
|
oldComment: "รหัสไปรษณีย์ที่อยู่ตามทะเบียนบ้าน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<bool>(
|
|
name: "RegistSame",
|
|
table: "Candidates",
|
|
type: "tinyint(1)",
|
|
nullable: false,
|
|
defaultValue: false,
|
|
comment: "ที่อยู่ปัจจุบันเหมือนที่อยู่ตามทะเบียนบ้าน",
|
|
oldClrType: typeof(bool),
|
|
oldType: "tinyint(1)",
|
|
oldNullable: true,
|
|
oldComment: "ที่อยู่ปัจจุบันเหมือนที่อยู่ตามทะเบียนบ้าน");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "RegistAddress",
|
|
keyValue: null,
|
|
column: "RegistAddress",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "RegistAddress",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: false,
|
|
comment: "ที่อยู่ตามทะเบียนบ้าน",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldNullable: true,
|
|
oldComment: "ที่อยู่ตามทะเบียนบ้าน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "OccupationType",
|
|
keyValue: null,
|
|
column: "OccupationType",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "OccupationType",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: false,
|
|
comment: "ประเภทอาชีพที่ทำงานมาก่อน",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldNullable: true,
|
|
oldComment: "ประเภทอาชีพที่ทำงานมาก่อน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "OccupationTelephone",
|
|
keyValue: null,
|
|
column: "OccupationTelephone",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "OccupationTelephone",
|
|
table: "Candidates",
|
|
type: "varchar(20)",
|
|
maxLength: 20,
|
|
nullable: false,
|
|
comment: "โทรศัพท์ บริษัท",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(20)",
|
|
oldMaxLength: 20,
|
|
oldNullable: true,
|
|
oldComment: "โทรศัพท์ บริษัท")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "OccupationEmail",
|
|
keyValue: null,
|
|
column: "OccupationEmail",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "OccupationEmail",
|
|
table: "Candidates",
|
|
type: "varchar(200)",
|
|
maxLength: 200,
|
|
nullable: false,
|
|
comment: "อีเมล บริษัท",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(200)",
|
|
oldMaxLength: 200,
|
|
oldNullable: true,
|
|
oldComment: "อีเมล บริษัท")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "OccupationDepartment",
|
|
keyValue: null,
|
|
column: "OccupationDepartment",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "OccupationDepartment",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: false,
|
|
comment: "กอง/ฝ่าย บริษัท",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldNullable: true,
|
|
oldComment: "กอง/ฝ่าย บริษัท")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "OccupationCompany",
|
|
keyValue: null,
|
|
column: "OccupationCompany",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "OccupationCompany",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: false,
|
|
comment: "สำนัก/บริษัท บริษัท",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldNullable: true,
|
|
oldComment: "สำนัก/บริษัท บริษัท")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "Nationality",
|
|
keyValue: null,
|
|
column: "Nationality",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "Nationality",
|
|
table: "Candidates",
|
|
type: "varchar(40)",
|
|
maxLength: 40,
|
|
nullable: false,
|
|
comment: "สัญชาติ",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(40)",
|
|
oldMaxLength: 40,
|
|
oldNullable: true,
|
|
oldComment: "สัญชาติ")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "MotherLastName",
|
|
keyValue: null,
|
|
column: "MotherLastName",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "MotherLastName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: false,
|
|
comment: "นามสกุลมารดา",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldNullable: true,
|
|
oldComment: "นามสกุลมารดา")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "MotherFirstName",
|
|
keyValue: null,
|
|
column: "MotherFirstName",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "MotherFirstName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: false,
|
|
comment: "ชื่อจริงมารดา",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldNullable: true,
|
|
oldComment: "ชื่อจริงมารดา")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "MobilePhone",
|
|
keyValue: null,
|
|
column: "MobilePhone",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "MobilePhone",
|
|
table: "Candidates",
|
|
type: "varchar(20)",
|
|
maxLength: 20,
|
|
nullable: false,
|
|
comment: "โทรศัพท์มือถือ",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(20)",
|
|
oldMaxLength: 20,
|
|
oldNullable: true,
|
|
oldComment: "โทรศัพท์มือถือ")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "MarryLastName",
|
|
keyValue: null,
|
|
column: "MarryLastName",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "MarryLastName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: false,
|
|
comment: "นามสกุลคู่สมรส",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldNullable: true,
|
|
oldComment: "นามสกุลคู่สมรส")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "MarryFirstName",
|
|
keyValue: null,
|
|
column: "MarryFirstName",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "MarryFirstName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: false,
|
|
comment: "ชื่อจริงคู่สมรส",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldNullable: true,
|
|
oldComment: "ชื่อจริงคู่สมรส")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AlterColumn<bool>(
|
|
name: "Marry",
|
|
table: "Candidates",
|
|
type: "tinyint(1)",
|
|
nullable: false,
|
|
defaultValue: false,
|
|
comment: "คู่สมรส",
|
|
oldClrType: typeof(bool),
|
|
oldType: "tinyint(1)",
|
|
oldNullable: true,
|
|
oldComment: "คู่สมรส");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "LastName",
|
|
keyValue: null,
|
|
column: "LastName",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "LastName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: false,
|
|
comment: "นามสกุล",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldNullable: true,
|
|
oldComment: "นามสกุล")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "Knowledge",
|
|
keyValue: null,
|
|
column: "Knowledge",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "Knowledge",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: false,
|
|
comment: "ความสามารถพิเศษ",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldNullable: true,
|
|
oldComment: "ความสามารถพิเศษ")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "FirstName",
|
|
keyValue: null,
|
|
column: "FirstName",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "FirstName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: false,
|
|
comment: "ชื่อจริง",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldNullable: true,
|
|
oldComment: "ชื่อจริง")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "FatherLastName",
|
|
keyValue: null,
|
|
column: "FatherLastName",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "FatherLastName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: false,
|
|
comment: "นามสกุลบิดา",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldNullable: true,
|
|
oldComment: "นามสกุลบิดา")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "FatherFirstName",
|
|
keyValue: null,
|
|
column: "FatherFirstName",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "FatherFirstName",
|
|
table: "Candidates",
|
|
type: "varchar(100)",
|
|
maxLength: 100,
|
|
nullable: false,
|
|
comment: "ชื่อจริงบิดา",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(100)",
|
|
oldMaxLength: 100,
|
|
oldNullable: true,
|
|
oldComment: "ชื่อจริงบิดา")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "Email",
|
|
keyValue: null,
|
|
column: "Email",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "Email",
|
|
table: "Candidates",
|
|
type: "varchar(200)",
|
|
maxLength: 200,
|
|
nullable: false,
|
|
comment: "อีเมล",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(200)",
|
|
oldMaxLength: 200,
|
|
oldNullable: true,
|
|
oldComment: "อีเมล")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "CurrentZipCode",
|
|
keyValue: null,
|
|
column: "CurrentZipCode",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "CurrentZipCode",
|
|
table: "Candidates",
|
|
type: "varchar(10)",
|
|
maxLength: 10,
|
|
nullable: false,
|
|
comment: "รหัสไปรษณีย์ที่อยู่ปัจจุบัน",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(10)",
|
|
oldMaxLength: 10,
|
|
oldNullable: true,
|
|
oldComment: "รหัสไปรษณีย์ที่อยู่ปัจจุบัน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "CurrentAddress",
|
|
keyValue: null,
|
|
column: "CurrentAddress",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "CurrentAddress",
|
|
table: "Candidates",
|
|
type: "longtext",
|
|
nullable: false,
|
|
comment: "ที่อยู่ปัจจุบัน",
|
|
oldClrType: typeof(string),
|
|
oldType: "longtext",
|
|
oldNullable: true,
|
|
oldComment: "ที่อยู่ปัจจุบัน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Candidates",
|
|
keyColumn: "CitizenId",
|
|
keyValue: null,
|
|
column: "CitizenId",
|
|
value: "");
|
|
|
|
migrationBuilder.AlterColumn<string>(
|
|
name: "CitizenId",
|
|
table: "Candidates",
|
|
type: "varchar(20)",
|
|
maxLength: 20,
|
|
nullable: false,
|
|
comment: "เลขประจำตัวประชาชน",
|
|
oldClrType: typeof(string),
|
|
oldType: "varchar(20)",
|
|
oldMaxLength: 20,
|
|
oldNullable: true,
|
|
oldComment: "เลขประจำตัวประชาชน")
|
|
.Annotation("MySql:CharSet", "utf8mb4")
|
|
.OldAnnotation("MySql:CharSet", "utf8mb4");
|
|
}
|
|
}
|
|
}
|