import pyodbc hil_sql = """ create table hil_se_comparison_info ( id bigint identity primary key, uniq_seq nvarchar(128) not null, application_id nvarchar(64) not null, application_version tinyint default 0 not null, customer_type nvarchar(16) not null, first_submmison_date nvarchar(16) not null, property_doc_policy nvarchar(16), individual_cus_info nvarchar(max) not null, corporate_cus_info nvarchar(max), vehicle_info nvarchar(max) not null, insurance_info nvarchar(max) not null, bank_info nvarchar(max) not null, quotationt_info nvarchar(max) not null, update_time datetime not null, create_time datetime not null ); create index hil_se_comparison_info_application_id_index on hil_se_comparison_info (application_id); create index hil_se_comparison_info_create_time_index on hil_se_comparison_info (create_time); create index hil_se_comparison_info_uniq_seq_index on hil_se_comparison_info (uniq_seq); 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); create table hil_ca_compare_result ( id int identity primary key, application_id nvarchar(64) not null, is_finish bit default 0 not null, compare_count smallint default 0 not null, failed_count smallint default 0 not null, reason1_count smallint default 0 not null, reason2_count smallint default 0 not null, reason3_count smallint default 0 not null, reason4_count smallint default 0 not null, reason5_count smallint default 0 not null, reason6_count smallint default 0 not null, reason7_count smallint default 0 not null, reason8_count smallint default 0 not null, reason9_count smallint default 0 not null, reason10_count smallint default 0 not null, result nvarchar(max), update_time datetime not null, create_time datetime not null ); create unique index hil_ca_compare_result_application_id_uindex on hil_ca_compare_result (application_id); create index hil_ca_compare_result_update_time_index on hil_ca_compare_result (update_time); create table hil_se_compare_result ( id int identity primary key, application_id nvarchar(64) not null, is_finish bit default 0 not null, compare_count smallint default 0 not null, failed_count smallint default 0 not null, reason1_count smallint default 0 not null, reason2_count smallint default 0 not null, reason3_count smallint default 0 not null, reason4_count smallint default 0 not null, reason5_count smallint default 0 not null, reason6_count smallint default 0 not null, reason7_count smallint default 0 not null, reason8_count smallint default 0 not null, reason9_count smallint default 0 not null, reason10_count smallint default 0 not null, result nvarchar(max), update_time datetime not null, create_time datetime not null ); create unique index hil_se_compare_result_application_id_uindex on hil_se_compare_result (application_id); create index hil_se_compare_result_update_time_index on hil_se_compare_result (update_time); """ afc_sql = """ create table afc_se_comparison_info ( id bigint identity primary key, uniq_seq nvarchar(128) not null, application_id nvarchar(64) not null, application_version tinyint default 0 not null, customer_type nvarchar(16) not null, first_submmison_date nvarchar(16) not null, property_doc_policy nvarchar(16), individual_cus_info nvarchar(max) not null, corporate_cus_info nvarchar(max), vehicle_info nvarchar(max) not null, insurance_info nvarchar(max) not null, bank_info nvarchar(max) not null, quotationt_info nvarchar(max) not null, update_time datetime not null, create_time datetime not null ); create index afc_se_comparison_info_application_id_index on afc_se_comparison_info (application_id); create index afc_se_comparison_info_create_time_index on afc_se_comparison_info (create_time); create index afc_se_comparison_info_uniq_seq_index on afc_se_comparison_info (uniq_seq); 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); create table afc_ca_compare_result ( id int identity primary key, application_id nvarchar(64) not null, is_finish bit default 0 not null, compare_count smallint default 0 not null, failed_count smallint default 0 not null, reason1_count smallint default 0 not null, reason2_count smallint default 0 not null, reason3_count smallint default 0 not null, reason4_count smallint default 0 not null, reason5_count smallint default 0 not null, reason6_count smallint default 0 not null, reason7_count smallint default 0 not null, reason8_count smallint default 0 not null, reason9_count smallint default 0 not null, reason10_count smallint default 0 not null, result nvarchar(max), update_time datetime not null, create_time datetime not null ); create unique index afc_ca_compare_result_application_id_uindex on afc_ca_compare_result (application_id); create index afc_ca_compare_result_update_time_index on afc_ca_compare_result (update_time); create table afc_se_compare_result ( id int identity primary key, application_id nvarchar(64) not null, is_finish bit default 0 not null, compare_count smallint default 0 not null, failed_count smallint default 0 not null, reason1_count smallint default 0 not null, reason2_count smallint default 0 not null, reason3_count smallint default 0 not null, reason4_count smallint default 0 not null, reason5_count smallint default 0 not null, reason6_count smallint default 0 not null, reason7_count smallint default 0 not null, reason8_count smallint default 0 not null, reason9_count smallint default 0 not null, reason10_count smallint default 0 not null, result nvarchar(max), update_time datetime not null, create_time datetime not null ); create unique index afc_se_compare_result_application_id_uindex on afc_se_compare_result (application_id); create index afc_se_compare_result_update_time_index on afc_se_compare_result (update_time); """ 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()