--1.tbl_lab_setup_Test — ปรับ Test_Seq และ flag ที่จำเป็น
sql
Insert Into tbl_lab_setup_Test(
    Test_Code,Test_Group_Code,Test_Seq,Test_Name,Test_Display_Name,
    Test_Display_Name_Hide_Print_Flag,Test_Type_Code,Test_Order_Status_Flag,
    Test_Data_Type_Code,Specimen_Type_Code,Test_His_Code,Test_Checkup_Code,
    Test_Send_Out_Flag,Test_Preliminary_Enable_Flag,Test_Inactive,
    Test_Method_Code,Test_Profile_Option_Flag,Test_Checkup_Flag,
    Test_Profile_Option_Share_Code_Flag
)
Values(
    'SP0000','OL','1000',      -- ★ ใส่ลำดับเพื่อให้แสดงใน view
    N'SPXXX',N'SPXXX','0',
    '0','1',
    '02',                     -- ★ Short Text
    '17','XXX','',
    '0','0','0',
    '', '0','0','0'
)

--2.2) tbl_lab_setup_Test_Control — ปรับ flag ให้เหมาะกับ Short Text

Insert Into tbl_lab_setup_Test_Control(
    Test_Code,Test_Auto_Test_Comment,Test_Auto_Result_Text,Test_Send_HIS_Text,
    Test_Default_Value_Text,Test_TAT_R_Days,Test_TAT_R_Hours,Test_TAT_R_Minutes,
    Test_TAT_S_Days,Test_TAT_S_Hours,Test_TAT_S_Minutes,Comment_Type_Code,
    Test_Share_Code_Flag,Test_Default_Value_Flag,Test_Comment_Type_Flag,
    Test_Send_HIS_Flag,Test_Limit_Result_Access_Flag,Test_Blind_Result_Display_Flag,
    Test_Auto_Result_Flag,Test_Scan_File_Flag,Test_Text_Keyin_Flag,
    Test_Text_Column_Print_Flag,Test_Critical_Flag,Test_Blank_Result_Flag,
    Test_Sp_Barcode_Flag,Test_Routine_Flag,Test_Ref_Text_Flag,Test_Ref_Text_Value,
    Test_Countable,Test_Package_Flag,Test_Package_Price,
    Test_Blind_Result_Display_Authen_Flag,Test_Pending_Time_Flag,
    Test_Pending_Time_Day,Test_Pending_Time_Hours,Test_Pending_Time_Miniutes,
    Test_Report_Flag,Test_Report,Test_Block_Result,Test_Block_Result_Flag,
    Test_Barcode_Copy_Flag,Test_Barcode_Copy,Test_Cost,Test_OutLab_Flag,
    Test_OutLab_Code,Test_Result_Equal_Pre1_Flag,Test_Click_Formula_Flag,
    Test_Blood_Group_Color,Test_OutLab_Specimen_Code,
    Test_Report_Show_Dialog_Print_On_App,Test_Limit_Order_Flag,
    Test_Limit_Order_Day,Test_Alert_Result_From_ANA
)
Values(
    'SP0000',N'',N'',N'',N'',
    '0','00','00','0','00','00','000',
    '0','0','0','0','0','0',
    '0','0',
    '0',     -- ★ ปิด key-in (Short Text เลือกจากรายการ)
    '0','0','0','0','0','0',N'',
    '0',     -- ★ ปิด Countable
    '0','0.00','0','0','0','00','00',
    '0',N'',N'','0','0','',
    '0.00','0','000000','0','0','0','',
    '0','0','0','0'
)

--3.3) tbl_lab_setup_Test_Result_Short_Text — เพิ่มรายการผล
    
Insert Into tbl_lab_setup_Test_Result_Short_Text(
    Test_Code,Short_Text_Result_Code,Test_Abnormal_Flag,
    Test_Alert_Flag,Not_Show_Flag,Test_AlertResult_Flag,
    ResultFlag_Condition,Short_Text_Seq
)
Values(
    'SP0000','000000','0','0','0','0','E','001'
)


--4) tbl_lab_setup_Test_Result_Short_Text_Control — ปรับ Unit ให้ถูกต้อง

    Insert Into tbl_lab_setup_Test_Result_Short_Text_Control(
    Test_Code,Unit_Code,Formula_Code,Test_Formula_Enable_Flag
)
Values(
    'SP0000','',   -- ★ Short Text ส่วนใหญ่ไม่ใช้หน่วย
    '', '0'
)