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()