DB create - Build Control Table

Access denied for user 'allen712_saccapp'@'localhost' (using password: YES)

Access denied for user 'apache'@'localhost' (using password: NO)
create table control ( id int(11) not null, co_name varchar(40) not null, co_name_short varchar(20) not null, co_address varchar(40) not null, co_city varchar(20) not null, co_provstate varchar(3) not null, co_pcode varchar(11) not null, co_phone varchar(20) not null, co_fax varchar(20) not null, co_phone_alt1 varchar(20) not null, co_phone_alt1_type varchar(30) not null, co_phone_alt2 varchar(20) not null, co_phone_alt2_type varchar(30) not null, co_url varchar(80) not null, co_main_email varchar(80) not null, co_notify_email1 varchar(80) not null, co_notifyevent1_email1 char(1) not null, co_notifyevent2_email1 char(1) not null, co_notifyevent3_email1 char(1) not null, co_notifyevent4_email1 char(1) not null, co_mcon_opp1 int(3) not null, co_notify_email2 varchar(80) not null, co_notifyevent1_email2 char(1) not null, co_notifyevent2_email2 char(1) not null, co_notifyevent3_email2 char(1) not null, co_notifyevent4_email2 char(1) not null, co_mcon_opp2 int(3) not null, co_pord_form_field_size int(1) not null, co_notify_email3 varchar(80) not null, co_notifyevent1_email3 char(1) not null, co_notifyevent2_email3 char(1) not null, co_notifyevent3_email3 char(1) not null, co_notifyevent4_email3 char(1) not null, co_mcon_opp3 int(3) not null, co_security_emails text not null, co_from_email varchar(80) not null, co_download_filename varchar(30) not null, co_customer_download_filename varchar(30) not null, co_language char(1) not null, co_service1 varchar(24) not null, co_service2 varchar(24) not null, co_service3 varchar(24) not null, co_service4 varchar(24) not null, co_service5 varchar(24) not null, co_service6 varchar(24) not null, co_service7 varchar(24) not null, co_service8 varchar(24) not null, co_service9 varchar(24) not null, co_service1_desc text not null, co_service2_desc text not null, co_service3_desc text not null, co_service4_desc text not null, co_service5_desc text not null, co_service6_desc text not null, co_service7_desc text not null, co_service8_desc text not null, co_order_checkbox1 varchar(24) not null, co_order_checkbox2 varchar(24) not null, co_order_checkbox3 varchar(24) not null, co_order_checkbox1_price varchar(12) not null, co_order_checkbox2_price varchar(12) not null, co_order_checkbox3_price varchar(12) not null, co_service1_short varchar(6) not null, co_service2_short varchar(6) not null, co_service3_short varchar(6) not null, co_service4_short varchar(6) not null, co_service5_short varchar(6) not null, co_service6_short varchar(6) not null, co_service7_short varchar(6) not null, co_service8_short varchar(6) not null, co_service9_short varchar(6) not null, co_order_checkbox1_short varchar(6) not null, co_order_checkbox2_short varchar(6) not null, co_order_checkbox3_short varchar(6) not null, co_service1_cutoff varchar(7) not null, co_service2_cutoff varchar(7) not null, co_service3_cutoff varchar(7) not null, co_service4_cutoff varchar(7) not null, co_service5_cutoff varchar(7) not null, co_service6_cutoff varchar(7) not null, co_service7_cutoff varchar(7) not null, co_service8_cutoff varchar(7) not null, co_nosig varchar(30) not null, co_minwaybills int(1) not null, co_next_tempacctno int(6) not null, co_category1 varchar(12) not null, co_category2 varchar(12) not null, co_category3 varchar(12) not null, co_category4 varchar(12) not null, co_category5 varchar(12) not null, co_category6 varchar(12) not null, co_category7 varchar(12) not null, co_category8 varchar(12) not null, co_category9 varchar(12) not null, co_location1 varchar(12) not null, co_location2 varchar(12) not null, co_location3 varchar(12) not null, co_location4 varchar(12) not null, co_location5 varchar(12) not null, co_location6 varchar(12) not null, co_location7 varchar(12) not null, co_location8 varchar(12) not null, co_location9 varchar(12) not null, co_uom_distance int(1) not null, co_uom_weight varchar(20) not null, co_uom_volume varchar(20) not null, co_delchart1_name varchar(20) not null, co_delchart2_name varchar(20) not null, co_addtnl_svc1 varchar(24) not null, co_addtnl_svc2 varchar(24) not null, co_addtnl_svc3 varchar(24) not null, co_addtnl_svc4 varchar(24) not null, co_addtnl_svc5 varchar(24) not null, co_returntrip_charge1 char(1) not null, co_returntrip_charge2 char(1) not null, co_returntrip_charge3 char(1) not null, co_returntrip_charge4 char(1) not null, co_returntrip_charge5 char(1) not null, co_returntrip_charge6 char(1) not null, co_returntrip_charge7 char(1) not null, co_returntrip_charge8 char(1) not null, co_returntrip_charge9 char(1) not null, co_returntrip_charge10 char(1) not null, co_returntrip_charge11 char(1) not null, co_returntrip_charge12 char(1) not null, co_returntrip_charge13 char(1) not null, co_round_price varchar(24) not null, co_pricing_opt_1 char(1) not null, co_pricing_opt_2 char(1) not null, co_pricing_opt_3 char(1) not null, co_pricing_opt_4 char(1) not null, co_pricing_opt_5 char(1) not null, co_pricing_opt_rb1 int(1) not null, co_pricing_opt_rb2 int(1) not null, co_pricing_opt_rb3 int(1) not null, co_pricing_opt_rb4 int(1) not null, co_pricing_opt_rb5 int(1) not null, co_pieces_measure1 varchar(12) not null, co_pieces_measure2 varchar(12) not null, co_pieces_measure3 varchar(12) not null, co_pieces_measure4 varchar(12) not null, co_pieces_measure5 varchar(12) not null, co_pieces_measure6 varchar(12) not null, co_pieces_measure7 varchar(12) not null, co_pieces_measure8 varchar(12) not null, co_pieces_measure9 varchar(12) not null, co_pieces_measure10 varchar(12) not null, co_pieces_measure11 varchar(12) not null, co_pieces_measure12 varchar(12) not null, co_pieces_measure1_short varchar(4) not null, co_pieces_measure2_short varchar(4) not null, co_pieces_measure3_short varchar(4) not null, co_pieces_measure4_short varchar(4) not null, co_pieces_measure5_short varchar(4) not null, co_pieces_measure6_short varchar(4) not null, co_pieces_measure7_short varchar(4) not null, co_pieces_measure8_short varchar(4) not null, co_pieces_measure9_short varchar(4) not null, co_pieces_measure10_short varchar(4) not null, co_pieces_measure11_short varchar(4) not null, co_pieces_measure12_short varchar(4) not null, co_consolecolor int(2) not null, co_textcolor int(2) not null, co_console_bkgcolor_light char(6) not null, co_console_bkgcolor_dark char(6) not null, co_pkg_1 char(1) not null, co_pkg_2 char(1) not null, co_pkg_3 char(1) not null, co_pkg_4 char(1) not null, co_pkg_5 char(1) not null, co_pkg_6 char(1) not null, co_pkg_7 char(1) not null, co_pkg_8 char(1) not null, co_pkg_9 char(1) not null, co_pkg_10 char(1) not null, co_pkg_11 char(1) not null, co_pkg_12 char(1) not null, co_pkg_13 char(1) not null, co_pkg_14 char(1) not null, co_pkg_15 char(1) not null, co_pkg_16 char(1) not null, co_pkg_17 char(1) not null, co_pkg_18 char(1) not null, co_pkg_19 char(1) not null, co_pkg_20 char(1) not null, co_taxtype1 varchar(10) not null, co_taxtype1_desc varchar(35) not null, co_taxtype1_rate varchar(8) not null, co_taxtype2 varchar(10) not null, co_taxtype2_desc varchar(35) not null, co_taxtype2_rate varchar(8) not null, co_taxtype3 varchar(10) not null, co_taxtype3_desc varchar(35) not null, co_taxtype3_rate varchar(8) not null, co_taxtype4 varchar(10) not null, co_taxtype4_desc varchar(35) not null, co_taxtype4_rate varchar(8) not null, co_taxtype5 varchar(10) not null, co_taxtype5_desc varchar(35) not null, co_taxtype5_rate varchar(8) not null, co_taxgroup1 varchar(30) not null, co_taxgroup1_type1 varchar(10) not null, co_taxgroup1_type2 varchar(10) not null, co_taxgroup1_tax2_on_tax1 char(1) not null, co_taxgroup1_fs_rate varchar(12) not null, co_taxgroup1_tax1_on_fs char(1) not null, co_taxgroup1_tax2_on_fs char(1) not null, co_taxgroup1_sc_on_wb char(1) not null, co_taxgroup1_sc_on_wt char(1) not null, co_taxgroup1_sc_on_ot char(1) not null, co_taxgroup2 varchar(30) not null, co_taxgroup2_type1 varchar(10) not null, co_taxgroup2_type2 varchar(10) not null, co_taxgroup2_tax2_on_tax1 char(1) not null, co_taxgroup2_fs_rate varchar(12) not null, co_taxgroup2_tax1_on_fs char(1) not null, co_taxgroup2_tax2_on_fs char(1) not null, co_taxgroup2_sc_on_wb char(1) not null, co_taxgroup2_sc_on_wt char(1) not null, co_taxgroup2_sc_on_ot char(1) not null, co_taxgroup3 varchar(30) not null, co_taxgroup3_type1 varchar(10) not null, co_taxgroup3_type2 varchar(10) not null, co_taxgroup3_tax2_on_tax1 char(1) not null, co_taxgroup3_fs_rate varchar(12) not null, co_taxgroup3_tax1_on_fs char(1) not null, co_taxgroup3_tax2_on_fs char(1) not null, co_taxgroup3_sc_on_wb char(1) not null, co_taxgroup3_sc_on_wt char(1) not null, co_taxgroup3_sc_on_ot char(1) not null, co_taxgroup4 varchar(30) not null, co_taxgroup4_type1 varchar(10) not null, co_taxgroup4_type2 varchar(10) not null, co_taxgroup4_tax2_on_tax1 char(1) not null, co_taxgroup4_fs_rate varchar(12) not null, co_taxgroup4_tax1_on_fs char(1) not null, co_taxgroup4_tax2_on_fs char(1) not null, co_taxgroup4_sc_on_wb char(1) not null, co_taxgroup4_sc_on_wt char(1) not null, co_taxgroup4_sc_on_ot char(1) not null, co_taxgroup5 varchar(30) not null, co_taxgroup5_type1 varchar(10) not null, co_taxgroup5_type2 varchar(10) not null, co_taxgroup5_tax2_on_tax1 char(1) not null, co_taxgroup5_fs_rate varchar(12) not null, co_taxgroup5_tax1_on_fs char(1) not null, co_taxgroup5_tax2_on_fs char(1) not null, co_taxgroup5_sc_on_wb char(1) not null, co_taxgroup5_sc_on_wt char(1) not null, co_taxgroup5_sc_on_ot char(1) not null, co_invoice_message tinytext not null, co_terms_1 varchar(8) not null, co_terms_2 varchar(8) not null, co_terms_3 varchar(8) not null, co_terms_4 varchar(8) not null, co_terms_5 varchar(8) not null, co_terms_6 varchar(8) not null, co_terms_7 varchar(8) not null, co_terms_8 varchar(8) not null, co_terms_9 varchar(8) not null, co_terms_desc_1 varchar(30) not null, co_terms_desc_2 varchar(30) not null, co_terms_desc_3 varchar(30) not null, co_terms_desc_4 varchar(30) not null, co_terms_desc_5 varchar(30) not null, co_terms_desc_6 varchar(30) not null, co_terms_desc_7 varchar(30) not null, co_terms_desc_8 varchar(30) not null, co_terms_desc_9 varchar(30) not null, co_terms_days_1 varchar(3) not null, co_terms_days_2 varchar(3) not null, co_terms_days_3 varchar(3) not null, co_terms_days_4 varchar(3) not null, co_terms_days_5 varchar(3) not null, co_terms_days_6 varchar(3) not null, co_terms_days_7 varchar(3) not null, co_terms_days_8 varchar(3) not null, co_terms_days_9 varchar(3) not null, co_paymethod_1 varchar(20) not null, co_paymethod_2 varchar(20) not null, co_paymethod_3 varchar(20) not null, co_paymethod_4 varchar(20) not null, co_paymethod_5 varchar(20) not null, co_paymethod_6 varchar(20) not null, co_paymethod_7 varchar(20) not null, co_paymethod_8 varchar(20) not null, co_paymethod_9 varchar(20) not null, co_billingfreq_1 varchar(20) not null, co_billingfreq_2 varchar(20) not null, co_billingfreq_3 varchar(20) not null, co_billingfreq_4 varchar(20) not null, co_billingfreq_5 varchar(20) not null, co_billingfreq_6 varchar(20) not null, co_billingfreq_7 varchar(20) not null, co_billingfreq_8 varchar(20) not null, co_billingfreq_9 varchar(20) not null, co_billingcode_1 varchar(20) not null, co_billingcode_2 varchar(20) not null, co_billingcode_3 varchar(20) not null, co_billingcode_4 varchar(20) not null, co_billingcode_5 varchar(20) not null, co_billingcode_6 varchar(20) not null, co_billingcode_7 varchar(20) not null, co_billingcode_8 varchar(20) not null, co_billingcode_9 varchar(20) not null, co_billingcode_1_short varchar(8) not null, co_billingcode_2_short varchar(8) not null, co_billingcode_3_short varchar(8) not null, co_billingcode_4_short varchar(8) not null, co_billingcode_5_short varchar(8) not null, co_billingcode_6_short varchar(8) not null, co_billingcode_7_short varchar(8) not null, co_billingcode_8_short varchar(8) not null, co_billingcode_9_short varchar(8) not null, co_invoice_copies int(1) not null, co_line_fontsize int(1) not null, co_lines_perpage int(7) not null, co_taxmessage1 varchar(40) not null, co_taxmessage2 varchar(40) not null, co_taxmessage3 varchar(40) not null, co_taxmessage4 varchar(40) not null, co_invoiceoption_1 char(1) not null, co_invoiceoption_2 char(1) not null, co_invoiceoption_3 char(1) not null, co_invoiceoption_4 char(1) not null, co_invoiceoption_5 char(1) not null, co_invoiceoption_6 char(1) not null, co_invoiceoption_7 char(1) not null, co_invoiceoption_8 char(1) not null, co_invoiceoption_9 char(1) not null, co_invoiceoption_rb1 int(1) not null, co_invoiceoption_rb2 int(1) not null, co_invoiceoption_rb3 int(1) not null, co_invoiceoption_rb4 int(1) not null, co_invoiceoption_rb5 int(1) not null, co_invoiceoption_rb6 int(1) not null, co_invoiceoption_rb7 int(1) not null, co_invoiceoption_rb8 int(1) not null, co_invoiceoption_rb9 int(1) not null, co_msg_neworder_content1 char(1) not null, co_msg_neworder_content2 char(1) not null, co_msg_neworder_content3 char(1) not null, co_msg_neworder_content4 char(1) not null, co_msg_neworder_content5 char(1) not null, co_msg_neworder_content6 char(1) not null, co_msg_neworder_content7 char(1) not null, co_msg_neworder_content8 char(1) not null, co_msg_neworder_content9 char(1) not null, co_msg_neworder_content10 char(1) not null, co_msg_neworder_content11 char(1) not null, co_msg_neworder_content12 char(1) not null, co_msg_neworder_content13 char(1) not null, co_msg_neworder_content14 char(1) not null, co_msg_neworder_content15 char(1) not null, co_msg_neworder_content16 char(1) not null, co_msg_neworder_content17 char(1) not null, co_msg_neworder_content18 char(1) not null, co_msg_neworder_content19 char(1) not null, co_msg_neworder_content20 char(1) not null, co_msg_neworder_content21 char(1) not null, co_msg_neworder_content22 char(1) not null, co_msg_neworder_content23 char(1) not null, co_msg_neworder_content24 char(1) not null, co_msg_neworder_content25 char(1) not null, co_online_invoicing char(1) not null, co_online_invoice_email_copy1 varchar(80) not null, co_online_invoice_email_copy2 varchar(80) not null, co_online_payments char(1) not null, co_online_payments_currency int(1) not null, co_online_payments_email varchar(80) not null, co_invoicing_goodtogo char(1) not null, co_nag_repreive date not null, co_nag_suspend date not null, co_loginmessage_subject varchar(80) not null, co_loginmessage_body blob not null, co_startmessage date not null, co_endmessage date not null, co_orderform_option_rb1 int(1) not null, co_orderform_option_rb2 int(1) not null, co_orderform_option_rb3 int(1) not null, co_orderform_option_rb4 int(1) not null, co_orderform_option_rb5 int(1) not null, co_orderform_option_1 char(1) not null, co_orderform_option_2 char(1) not null, co_orderform_option_3 char(1) not null, co_orderform_option_4 char(1) not null, co_orderform_option_5 char(1) not null, co_last_presched_load date not null, co_qbar varchar(40) not null, co_qbsales varchar(40) not null, co_qbtax varchar(40) not null, co_qbinv_prefix varchar(40) not null, primary key(id) )

create table control ( id int(11) not null, co_name varchar(40) not null, co_name_short varchar(20) not null, co_address varchar(40) not null, co_city varchar(20) not null, co_provstate varchar(3) not null, co_pcode varchar(11) not null, co_phone varchar(20) not null, co_fax varchar(20) not null, co_phone_alt1 varchar(20) not null, co_phone_alt1_type varchar(30) not null, co_phone_alt2 varchar(20) not null, co_phone_alt2_type varchar(30) not null, co_url varchar(80) not null, co_main_email varchar(80) not null, co_notify_email1 varchar(80) not null, co_notifyevent1_email1 char(1) not null, co_notifyevent2_email1 char(1) not null, co_notifyevent3_email1 char(1) not null, co_notifyevent4_email1 char(1) not null, co_mcon_opp1 int(3) not null, co_notify_email2 varchar(80) not null, co_notifyevent1_email2 char(1) not null, co_notifyevent2_email2 char(1) not null, co_notifyevent3_email2 char(1) not null, co_notifyevent4_email2 char(1) not null, co_mcon_opp2 int(3) not null, co_pord_form_field_size int(1) not null, co_notify_email3 varchar(80) not null, co_notifyevent1_email3 char(1) not null, co_notifyevent2_email3 char(1) not null, co_notifyevent3_email3 char(1) not null, co_notifyevent4_email3 char(1) not null, co_mcon_opp3 int(3) not null, co_security_emails text not null, co_from_email varchar(80) not null, co_download_filename varchar(30) not null, co_customer_download_filename varchar(30) not null, co_language char(1) not null, co_service1 varchar(24) not null, co_service2 varchar(24) not null, co_service3 varchar(24) not null, co_service4 varchar(24) not null, co_service5 varchar(24) not null, co_service6 varchar(24) not null, co_service7 varchar(24) not null, co_service8 varchar(24) not null, co_service9 varchar(24) not null, co_service1_desc text not null, co_service2_desc text not null, co_service3_desc text not null, co_service4_desc text not null, co_service5_desc text not null, co_service6_desc text not null, co_service7_desc text not null, co_service8_desc text not null, co_order_checkbox1 varchar(24) not null, co_order_checkbox2 varchar(24) not null, co_order_checkbox3 varchar(24) not null, co_order_checkbox1_price varchar(12) not null, co_order_checkbox2_price varchar(12) not null, co_order_checkbox3_price varchar(12) not null, co_service1_short varchar(6) not null, co_service2_short varchar(6) not null, co_service3_short varchar(6) not null, co_service4_short varchar(6) not null, co_service5_short varchar(6) not null, co_service6_short varchar(6) not null, co_service7_short varchar(6) not null, co_service8_short varchar(6) not null, co_service9_short varchar(6) not null, co_order_checkbox1_short varchar(6) not null, co_order_checkbox2_short varchar(6) not null, co_order_checkbox3_short varchar(6) not null, co_service1_cutoff varchar(7) not null, co_service2_cutoff varchar(7) not null, co_service3_cutoff varchar(7) not null, co_service4_cutoff varchar(7) not null, co_service5_cutoff varchar(7) not null, co_service6_cutoff varchar(7) not null, co_service7_cutoff varchar(7) not null, co_service8_cutoff varchar(7) not null, co_nosig varchar(30) not null, co_minwaybills int(1) not null, co_next_tempacctno int(6) not null, co_category1 varchar(12) not null, co_category2 varchar(12) not null, co_category3 varchar(12) not null, co_category4 varchar(12) not null, co_category5 varchar(12) not null, co_category6 varchar(12) not null, co_category7 varchar(12) not null, co_category8 varchar(12) not null, co_category9 varchar(12) not null, co_location1 varchar(12) not null, co_location2 varchar(12) not null, co_location3 varchar(12) not null, co_location4 varchar(12) not null, co_location5 varchar(12) not null, co_location6 varchar(12) not null, co_location7 varchar(12) not null, co_location8 varchar(12) not null, co_location9 varchar(12) not null, co_uom_distance int(1) not null, co_uom_weight varchar(20) not null, co_uom_volume varchar(20) not null, co_delchart1_name varchar(20) not null, co_delchart2_name varchar(20) not null, co_addtnl_svc1 varchar(24) not null, co_addtnl_svc2 varchar(24) not null, co_addtnl_svc3 varchar(24) not null, co_addtnl_svc4 varchar(24) not null, co_addtnl_svc5 varchar(24) not null, co_returntrip_charge1 char(1) not null, co_returntrip_charge2 char(1) not null, co_returntrip_charge3 char(1) not null, co_returntrip_charge4 char(1) not null, co_returntrip_charge5 char(1) not null, co_returntrip_charge6 char(1) not null, co_returntrip_charge7 char(1) not null, co_returntrip_charge8 char(1) not null, co_returntrip_charge9 char(1) not null, co_returntrip_charge10 char(1) not null, co_returntrip_charge11 char(1) not null, co_returntrip_charge12 char(1) not null, co_returntrip_charge13 char(1) not null, co_round_price varchar(24) not null, co_pricing_opt_1 char(1) not null, co_pricing_opt_2 char(1) not null, co_pricing_opt_3 char(1) not null, co_pricing_opt_4 char(1) not null, co_pricing_opt_5 char(1) not null, co_pricing_opt_rb1 int(1) not null, co_pricing_opt_rb2 int(1) not null, co_pricing_opt_rb3 int(1) not null, co_pricing_opt_rb4 int(1) not null, co_pricing_opt_rb5 int(1) not null, co_pieces_measure1 varchar(12) not null, co_pieces_measure2 varchar(12) not null, co_pieces_measure3 varchar(12) not null, co_pieces_measure4 varchar(12) not null, co_pieces_measure5 varchar(12) not null, co_pieces_measure6 varchar(12) not null, co_pieces_measure7 varchar(12) not null, co_pieces_measure8 varchar(12) not null, co_pieces_measure9 varchar(12) not null, co_pieces_measure10 varchar(12) not null, co_pieces_measure11 varchar(12) not null, co_pieces_measure12 varchar(12) not null, co_pieces_measure1_short varchar(4) not null, co_pieces_measure2_short varchar(4) not null, co_pieces_measure3_short varchar(4) not null, co_pieces_measure4_short varchar(4) not null, co_pieces_measure5_short varchar(4) not null, co_pieces_measure6_short varchar(4) not null, co_pieces_measure7_short varchar(4) not null, co_pieces_measure8_short varchar(4) not null, co_pieces_measure9_short varchar(4) not null, co_pieces_measure10_short varchar(4) not null, co_pieces_measure11_short varchar(4) not null, co_pieces_measure12_short varchar(4) not null, co_consolecolor int(2) not null, co_textcolor int(2) not null, co_console_bkgcolor_light char(6) not null, co_console_bkgcolor_dark char(6) not null, co_pkg_1 char(1) not null, co_pkg_2 char(1) not null, co_pkg_3 char(1) not null, co_pkg_4 char(1) not null, co_pkg_5 char(1) not null, co_pkg_6 char(1) not null, co_pkg_7 char(1) not null, co_pkg_8 char(1) not null, co_pkg_9 char(1) not null, co_pkg_10 char(1) not null, co_pkg_11 char(1) not null, co_pkg_12 char(1) not null, co_pkg_13 char(1) not null, co_pkg_14 char(1) not null, co_pkg_15 char(1) not null, co_pkg_16 char(1) not null, co_pkg_17 char(1) not null, co_pkg_18 char(1) not null, co_pkg_19 char(1) not null, co_pkg_20 char(1) not null, co_taxtype1 varchar(10) not null, co_taxtype1_desc varchar(35) not null, co_taxtype1_rate varchar(8) not null, co_taxtype2 varchar(10) not null, co_taxtype2_desc varchar(35) not null, co_taxtype2_rate varchar(8) not null, co_taxtype3 varchar(10) not null, co_taxtype3_desc varchar(35) not null, co_taxtype3_rate varchar(8) not null, co_taxtype4 varchar(10) not null, co_taxtype4_desc varchar(35) not null, co_taxtype4_rate varchar(8) not null, co_taxtype5 varchar(10) not null, co_taxtype5_desc varchar(35) not null, co_taxtype5_rate varchar(8) not null, co_taxgroup1 varchar(30) not null, co_taxgroup1_type1 varchar(10) not null, co_taxgroup1_type2 varchar(10) not null, co_taxgroup1_tax2_on_tax1 char(1) not null, co_taxgroup1_fs_rate varchar(12) not null, co_taxgroup1_tax1_on_fs char(1) not null, co_taxgroup1_tax2_on_fs char(1) not null, co_taxgroup1_sc_on_wb char(1) not null, co_taxgroup1_sc_on_wt char(1) not null, co_taxgroup1_sc_on_ot char(1) not null, co_taxgroup2 varchar(30) not null, co_taxgroup2_type1 varchar(10) not null, co_taxgroup2_type2 varchar(10) not null, co_taxgroup2_tax2_on_tax1 char(1) not null, co_taxgroup2_fs_rate varchar(12) not null, co_taxgroup2_tax1_on_fs char(1) not null, co_taxgroup2_tax2_on_fs char(1) not null, co_taxgroup2_sc_on_wb char(1) not null, co_taxgroup2_sc_on_wt char(1) not null, co_taxgroup2_sc_on_ot char(1) not null, co_taxgroup3 varchar(30) not null, co_taxgroup3_type1 varchar(10) not null, co_taxgroup3_type2 varchar(10) not null, co_taxgroup3_tax2_on_tax1 char(1) not null, co_taxgroup3_fs_rate varchar(12) not null, co_taxgroup3_tax1_on_fs char(1) not null, co_taxgroup3_tax2_on_fs char(1) not null, co_taxgroup3_sc_on_wb char(1) not null, co_taxgroup3_sc_on_wt char(1) not null, co_taxgroup3_sc_on_ot char(1) not null, co_taxgroup4 varchar(30) not null, co_taxgroup4_type1 varchar(10) not null, co_taxgroup4_type2 varchar(10) not null, co_taxgroup4_tax2_on_tax1 char(1) not null, co_taxgroup4_fs_rate varchar(12) not null, co_taxgroup4_tax1_on_fs char(1) not null, co_taxgroup4_tax2_on_fs char(1) not null, co_taxgroup4_sc_on_wb char(1) not null, co_taxgroup4_sc_on_wt char(1) not null, co_taxgroup4_sc_on_ot char(1) not null, co_taxgroup5 varchar(30) not null, co_taxgroup5_type1 varchar(10) not null, co_taxgroup5_type2 varchar(10) not null, co_taxgroup5_tax2_on_tax1 char(1) not null, co_taxgroup5_fs_rate varchar(12) not null, co_taxgroup5_tax1_on_fs char(1) not null, co_taxgroup5_tax2_on_fs char(1) not null, co_taxgroup5_sc_on_wb char(1) not null, co_taxgroup5_sc_on_wt char(1) not null, co_taxgroup5_sc_on_ot char(1) not null, co_invoice_message tinytext not null, co_terms_1 varchar(8) not null, co_terms_2 varchar(8) not null, co_terms_3 varchar(8) not null, co_terms_4 varchar(8) not null, co_terms_5 varchar(8) not null, co_terms_6 varchar(8) not null, co_terms_7 varchar(8) not null, co_terms_8 varchar(8) not null, co_terms_9 varchar(8) not null, co_terms_desc_1 varchar(30) not null, co_terms_desc_2 varchar(30) not null, co_terms_desc_3 varchar(30) not null, co_terms_desc_4 varchar(30) not null, co_terms_desc_5 varchar(30) not null, co_terms_desc_6 varchar(30) not null, co_terms_desc_7 varchar(30) not null, co_terms_desc_8 varchar(30) not null, co_terms_desc_9 varchar(30) not null, co_terms_days_1 varchar(3) not null, co_terms_days_2 varchar(3) not null, co_terms_days_3 varchar(3) not null, co_terms_days_4 varchar(3) not null, co_terms_days_5 varchar(3) not null, co_terms_days_6 varchar(3) not null, co_terms_days_7 varchar(3) not null, co_terms_days_8 varchar(3) not null, co_terms_days_9 varchar(3) not null, co_paymethod_1 varchar(20) not null, co_paymethod_2 varchar(20) not null, co_paymethod_3 varchar(20) not null, co_paymethod_4 varchar(20) not null, co_paymethod_5 varchar(20) not null, co_paymethod_6 varchar(20) not null, co_paymethod_7 varchar(20) not null, co_paymethod_8 varchar(20) not null, co_paymethod_9 varchar(20) not null, co_billingfreq_1 varchar(20) not null, co_billingfreq_2 varchar(20) not null, co_billingfreq_3 varchar(20) not null, co_billingfreq_4 varchar(20) not null, co_billingfreq_5 varchar(20) not null, co_billingfreq_6 varchar(20) not null, co_billingfreq_7 varchar(20) not null, co_billingfreq_8 varchar(20) not null, co_billingfreq_9 varchar(20) not null, co_billingcode_1 varchar(20) not null, co_billingcode_2 varchar(20) not null, co_billingcode_3 varchar(20) not null, co_billingcode_4 varchar(20) not null, co_billingcode_5 varchar(20) not null, co_billingcode_6 varchar(20) not null, co_billingcode_7 varchar(20) not null, co_billingcode_8 varchar(20) not null, co_billingcode_9 varchar(20) not null, co_billingcode_1_short varchar(8) not null, co_billingcode_2_short varchar(8) not null, co_billingcode_3_short varchar(8) not null, co_billingcode_4_short varchar(8) not null, co_billingcode_5_short varchar(8) not null, co_billingcode_6_short varchar(8) not null, co_billingcode_7_short varchar(8) not null, co_billingcode_8_short varchar(8) not null, co_billingcode_9_short varchar(8) not null, co_invoice_copies int(1) not null, co_line_fontsize int(1) not null, co_lines_perpage int(7) not null, co_taxmessage1 varchar(40) not null, co_taxmessage2 varchar(40) not null, co_taxmessage3 varchar(40) not null, co_taxmessage4 varchar(40) not null, co_invoiceoption_1 char(1) not null, co_invoiceoption_2 char(1) not null, co_invoiceoption_3 char(1) not null, co_invoiceoption_4 char(1) not null, co_invoiceoption_5 char(1) not null, co_invoiceoption_6 char(1) not null, co_invoiceoption_7 char(1) not null, co_invoiceoption_8 char(1) not null, co_invoiceoption_9 char(1) not null, co_invoiceoption_rb1 int(1) not null, co_invoiceoption_rb2 int(1) not null, co_invoiceoption_rb3 int(1) not null, co_invoiceoption_rb4 int(1) not null, co_invoiceoption_rb5 int(1) not null, co_invoiceoption_rb6 int(1) not null, co_invoiceoption_rb7 int(1) not null, co_invoiceoption_rb8 int(1) not null, co_invoiceoption_rb9 int(1) not null, co_msg_neworder_content1 char(1) not null, co_msg_neworder_content2 char(1) not null, co_msg_neworder_content3 char(1) not null, co_msg_neworder_content4 char(1) not null, co_msg_neworder_content5 char(1) not null, co_msg_neworder_content6 char(1) not null, co_msg_neworder_content7 char(1) not null, co_msg_neworder_content8 char(1) not null, co_msg_neworder_content9 char(1) not null, co_msg_neworder_content10 char(1) not null, co_msg_neworder_content11 char(1) not null, co_msg_neworder_content12 char(1) not null, co_msg_neworder_content13 char(1) not null, co_msg_neworder_content14 char(1) not null, co_msg_neworder_content15 char(1) not null, co_msg_neworder_content16 char(1) not null, co_msg_neworder_content17 char(1) not null, co_msg_neworder_content18 char(1) not null, co_msg_neworder_content19 char(1) not null, co_msg_neworder_content20 char(1) not null, co_msg_neworder_content21 char(1) not null, co_msg_neworder_content22 char(1) not null, co_msg_neworder_content23 char(1) not null, co_msg_neworder_content24 char(1) not null, co_msg_neworder_content25 char(1) not null, co_online_invoicing char(1) not null, co_online_invoice_email_copy1 varchar(80) not null, co_online_invoice_email_copy2 varchar(80) not null, co_online_payments char(1) not null, co_online_payments_currency int(1) not null, co_online_payments_email varchar(80) not null, co_invoicing_goodtogo char(1) not null, co_nag_repreive date not null, co_nag_suspend date not null, co_loginmessage_subject varchar(80) not null, co_loginmessage_body blob not null, co_startmessage date not null, co_endmessage date not null, co_orderform_option_rb1 int(1) not null, co_orderform_option_rb2 int(1) not null, co_orderform_option_rb3 int(1) not null, co_orderform_option_rb4 int(1) not null, co_orderform_option_rb5 int(1) not null, co_orderform_option_1 char(1) not null, co_orderform_option_2 char(1) not null, co_orderform_option_3 char(1) not null, co_orderform_option_4 char(1) not null, co_orderform_option_5 char(1) not null, co_last_presched_load date not null, co_qbar varchar(40) not null, co_qbsales varchar(40) not null, co_qbtax varchar(40) not null, co_qbinv_prefix varchar(40) not null, primary key(id) )