# import pyodbc

# afc_sql = """
#     create table afc_contract
#     (
#        id bigint identity primary key,
#        application_id nvarchar(64) not null,
#        create_time datetime not null
#     );
    
#     create index afc_contract_application_id_index
#        on afc_contract (application_id);
# """

# hil_sql = """
#     create table hil_contract
#     (
#        id bigint identity primary key,
#        application_id nvarchar(64) not null,
#        create_time datetime not null
#     );
    
#     create index hil_contract_application_id_index
#        on hil_contract (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()