import pyodbc


hil_sql = """
    create table hil_se_ocr_result
    (
       id int identity primary key,
       application_id nvarchar(64) not null,
       bs_ocr nvarchar(max),
       mvi_ocr nvarchar(max),
       ic_ocr nvarchar(max),
       rp_ocr nvarchar(max),
       bc_ocr nvarchar(max),
       bl_ocr nvarchar(max),
       uci_ocr nvarchar(max),
       eep_ocr nvarchar(max),
       dl_ocr nvarchar(max),
       pp_ocr nvarchar(max),
       mvc_ocr nvarchar(max),
       vat_ocr nvarchar(max),
       update_time datetime not null,
       create_time datetime not null
    );
    create unique index hil_se_ocr_result_application_id_uindex
       on hil_se_ocr_result (application_id);
"""

afc_sql = """
    create table afc_se_ocr_result
    (
       id int identity primary key,
       application_id nvarchar(64) not null,
       bs_ocr nvarchar(max),
       mvi_ocr nvarchar(max),
       ic_ocr nvarchar(max),
       rp_ocr nvarchar(max),
       bc_ocr nvarchar(max),
       bl_ocr nvarchar(max),
       uci_ocr nvarchar(max),
       eep_ocr nvarchar(max),
       dl_ocr nvarchar(max),
       pp_ocr nvarchar(max),
       mvc_ocr nvarchar(max),
       vat_ocr nvarchar(max),
       update_time datetime not null,
       create_time datetime not null
    );
    create unique index afc_se_ocr_result_application_id_uindex
       on afc_se_ocr_result (application_id);
"""

hil_cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};', autocommit=True)
hil_cursor = hil_cnxn.cursor()
hil_cursor.execute(hil_sql)
hil_cursor.close()
hil_cnxn.close()

afc_cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};', autocommit=True)
afc_cursor = afc_cnxn.cursor()
afc_cursor.execute(afc_sql)
afc_cursor.close()
afc_cnxn.close()