import pyodbc

hil_sql = """
    create table hil_comparison_info
    (
       id bigint identity primary key,
       uniq_seq nvarchar(128) not null,
       application_id nvarchar(64) not null,
       customer_type nvarchar(16) not null,
       application_version tinyint default 0 not null,
       vehicle_status nvarchar(16) not null,
       individual_cus_info nvarchar(max) not null,
       usedcar_info nvarchar(max),
       corporate_cus_info nvarchar(max),
       update_time datetime not null,
       create_time datetime not null
    );

    create index hil_comparison_info_application_id_index
       on hil_comparison_info (application_id);

    create index hil_comparison_info_create_time_index
       on hil_comparison_info (create_time);

    create index hil_comparison_info_uniq_seq_index
       on hil_comparison_info (uniq_seq);

    create table hil_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_ocr_result_application_id_uindex
       on hil_ocr_result (application_id);

"""

afc_sql = """

    create table afc_comparison_info
    (
       id bigint identity primary key,
       uniq_seq nvarchar(128) not null,
       application_id nvarchar(64) not null,
       customer_type nvarchar(16) not null,
       application_version tinyint default 0 not null,
       vehicle_status nvarchar(16) not null,
       individual_cus_info nvarchar(max) not null,
       usedcar_info nvarchar(max),
       corporate_cus_info nvarchar(max),
       update_time datetime not null,
       create_time datetime not null
    );

    create index afc_comparison_info_application_id_index
       on afc_comparison_info (application_id);

    create index afc_comparison_info_create_time_index
       on afc_comparison_info (create_time);

    create index afc_comparison_info_uniq_seq_index
       on afc_comparison_info (uniq_seq);

    create table afc_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_ocr_result_application_id_uindex
       on afc_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()