DB create - Build Client Table

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

Access denied for user 'apache'@'localhost' (using password: NO)
create table client ( id int(11) unsigned not null auto_increment, acctno varchar(12) not null, date_added date not null, company varchar(40) not null, shortname varchar(20) not null, addr tinyblob not null, city varchar(40) not null, pcode varchar(10) not null, phone varchar(40) not null, phone2 varchar(40) not null, phone3 varchar(40) not null, fax varchar(40) not null, loginmessage_subject varchar(80) not null, loginmessage_body blob not null, startmessage date not null, endmessage date not null, contact1 varchar(30) not null, contact2 varchar(30) not null, contact3 varchar(30) not null, contact1phone varchar(40) not null, contact2phone varchar(40) not null, contact3phone varchar(40) not null, email1 varchar(80) not null, email2 varchar(80) not null, email3 varchar(80) not null, email1_notify char(1) not null, email2_notify char(1) not null, email3_notify char(1) not null, credit_hold char(1) not null, credit_limit varchar(12) not null, zone varchar(12) not null, extra_waybills varchar(2) not null, waybills_perpage char(1) not null, online_invoicing_email varchar(80) not null, online_invoicing_email2 varchar(80) not null, online_invoicing_email3 varchar(80) not null, online_invoicing_userid1 varchar(12) not null, online_invoicing_userid2 varchar(12) not null, online_invoicing_userid3 varchar(12) not null, language char(1) not null, taxgroup int(3) not null, terms int(3) not null, fs_ovrd varchar(12) not null, ref_mandatory char(1) not null, invoice_lines int(3) not null, invoiceoption_1 int(1) not null, invoiceoption_2 int(1) not null, invoiceoption_3 int(1) not null, invoiceoption_4 int(1) not null, invoiceoption_5 int(1) not null, invoiceoption_6 int(1) not null, invoiceoption_7 int(1) not null, invoiceoption_8 int(1) not null, invoiceoption_9 int(1) not null, invoiceoption_rb1 int(1) not null, invoiceoption_rb2 int(1) not null, invoiceoption_rb3 int(1) not null, invoiceoption_rb4 int(1) not null, invoiceoption_rb5 int(1) not null, invoiceoption_rb6 int(1) not null, invoiceoption_rb7 int(1) not null, invoiceoption_rb8 int(1) not null, invoiceoption_rb9 int(1) not null, price_ovrd_quotes int(1) not null, price_ovrd_nocharge_weight varchar(12) not null, price_ovrd_nocharge_pieces1 varchar(12) not null, price_ovrd_nocharge_pieces2 varchar(12) not null, price_ovrd_nocharge_pieces3 varchar(12) not null, price_ovrd_nocharge_pieces4 varchar(12) not null, price_ovrd_nocharge_pieces5 varchar(12) not null, price_ovrd_nocharge_pieces6 varchar(12) not null, price_ovrd_nocharge_pieces7 varchar(12) not null, price_ovrd_nocharge_pieces8 varchar(12) not null, price_ovrd_nocharge_pieces9 varchar(12) not null, price_ovrd_nocharge_pieces10 varchar(12) not null, price_ovrd_nocharge_pieces11 varchar(12) not null, price_ovrd_nocharge_pieces12 varchar(12) not null, price_ovrd_nocharge_volume varchar(12) not null, price_ovrd_extra_weight varchar(12) not null, price_ovrd_extra_pieces1 varchar(12) not null, price_ovrd_extra_pieces2 varchar(12) not null, price_ovrd_extra_pieces3 varchar(12) not null, price_ovrd_extra_pieces4 varchar(12) not null, price_ovrd_extra_pieces5 varchar(12) not null, price_ovrd_extra_pieces6 varchar(12) not null, price_ovrd_extra_pieces7 varchar(12) not null, price_ovrd_extra_pieces8 varchar(12) not null, price_ovrd_extra_pieces9 varchar(12) not null, price_ovrd_extra_pieces10 varchar(12) not null, price_ovrd_extra_pieces11 varchar(12) not null, price_ovrd_extra_pieces12 varchar(12) not null, price_ovrd_extra_volume varchar(12) not null, price_ovrd_apply_overwt int(1) not null, price_ovrd_apply_overpcs int(1) not null, price_ovrd_apply_overvol int(1) not null, price_ovrd_del_fee varchar(12) not null, price_ovrd_apply_delfee int(1) not null, price_ovrd_volume_discount varchar(12) not null, price_ovrd_volume_threshold varchar(12) not null, price_ovrd_vol_disc_prior int(2) not null, price_ovrd_apply_volume_discount int(1) not null, price_ovrd_distance_fee_svc1_veh1 varchar(12) not null, price_ovrd_distance_fee_svc1_veh2 varchar(12) not null, price_ovrd_distance_fee_svc1_veh3 varchar(12) not null, price_ovrd_distance_fee_svc1_veh4 varchar(12) not null, price_ovrd_distance_fee_svc1_veh5 varchar(12) not null, price_ovrd_distance_fee_svc1_veh6 varchar(12) not null, price_ovrd_distance_fee_svc1_veh7 varchar(12) not null, price_ovrd_distance_fee_svc1_veh8 varchar(12) not null, price_ovrd_distance_fee_svc2_veh1 varchar(12) not null, price_ovrd_distance_fee_svc2_veh2 varchar(12) not null, price_ovrd_distance_fee_svc2_veh3 varchar(12) not null, price_ovrd_distance_fee_svc2_veh4 varchar(12) not null, price_ovrd_distance_fee_svc2_veh5 varchar(12) not null, price_ovrd_distance_fee_svc2_veh6 varchar(12) not null, price_ovrd_distance_fee_svc2_veh7 varchar(12) not null, price_ovrd_distance_fee_svc2_veh8 varchar(12) not null, price_ovrd_distance_fee_svc3_veh1 varchar(12) not null, price_ovrd_distance_fee_svc3_veh2 varchar(12) not null, price_ovrd_distance_fee_svc3_veh3 varchar(12) not null, price_ovrd_distance_fee_svc3_veh4 varchar(12) not null, price_ovrd_distance_fee_svc3_veh5 varchar(12) not null, price_ovrd_distance_fee_svc3_veh6 varchar(12) not null, price_ovrd_distance_fee_svc3_veh7 varchar(12) not null, price_ovrd_distance_fee_svc3_veh8 varchar(12) not null, price_ovrd_distance_fee_svc4_veh1 varchar(12) not null, price_ovrd_distance_fee_svc4_veh2 varchar(12) not null, price_ovrd_distance_fee_svc4_veh3 varchar(12) not null, price_ovrd_distance_fee_svc4_veh4 varchar(12) not null, price_ovrd_distance_fee_svc4_veh5 varchar(12) not null, price_ovrd_distance_fee_svc4_veh6 varchar(12) not null, price_ovrd_distance_fee_svc4_veh7 varchar(12) not null, price_ovrd_distance_fee_svc4_veh8 varchar(12) not null, price_ovrd_distance_fee_svc5_veh1 varchar(12) not null, price_ovrd_distance_fee_svc5_veh2 varchar(12) not null, price_ovrd_distance_fee_svc5_veh3 varchar(12) not null, price_ovrd_distance_fee_svc5_veh4 varchar(12) not null, price_ovrd_distance_fee_svc5_veh5 varchar(12) not null, price_ovrd_distance_fee_svc5_veh6 varchar(12) not null, price_ovrd_distance_fee_svc5_veh7 varchar(12) not null, price_ovrd_distance_fee_svc5_veh8 varchar(12) not null, price_ovrd_distance_fee_svc6_veh1 varchar(12) not null, price_ovrd_distance_fee_svc6_veh2 varchar(12) not null, price_ovrd_distance_fee_svc6_veh3 varchar(12) not null, price_ovrd_distance_fee_svc6_veh4 varchar(12) not null, price_ovrd_distance_fee_svc6_veh5 varchar(12) not null, price_ovrd_distance_fee_svc6_veh6 varchar(12) not null, price_ovrd_distance_fee_svc6_veh7 varchar(12) not null, price_ovrd_distance_fee_svc6_veh8 varchar(12) not null, price_ovrd_distance_fee_svc7_veh1 varchar(12) not null, price_ovrd_distance_fee_svc7_veh2 varchar(12) not null, price_ovrd_distance_fee_svc7_veh3 varchar(12) not null, price_ovrd_distance_fee_svc7_veh4 varchar(12) not null, price_ovrd_distance_fee_svc7_veh5 varchar(12) not null, price_ovrd_distance_fee_svc7_veh6 varchar(12) not null, price_ovrd_distance_fee_svc7_veh7 varchar(12) not null, price_ovrd_distance_fee_svc7_veh8 varchar(12) not null, price_ovrd_distance_fee_svc8_veh1 varchar(12) not null, price_ovrd_distance_fee_svc8_veh2 varchar(12) not null, price_ovrd_distance_fee_svc8_veh3 varchar(12) not null, price_ovrd_distance_fee_svc8_veh4 varchar(12) not null, price_ovrd_distance_fee_svc8_veh5 varchar(12) not null, price_ovrd_distance_fee_svc8_veh6 varchar(12) not null, price_ovrd_distance_fee_svc8_veh7 varchar(12) not null, price_ovrd_distance_fee_svc8_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh8 varchar(12) not null, price_ovrd_cb1 varchar(12) not null, price_ovrd_cb2 varchar(12) not null, price_ovrd_cb3 varchar(12) not null, price_ovrd_svc1 varchar(12) not null, price_ovrd_svc2 varchar(12) not null, price_ovrd_svc3 varchar(12) not null, price_ovrd_svc4 varchar(12) not null, price_ovrd_svc5 varchar(12) not null, price_ovrd_wpv_method varchar(12) not null, price_minimum_svc1 varchar(12) not null, price_minimum_svc2 varchar(12) not null, price_minimum_svc3 varchar(12) not null, price_minimum_svc4 varchar(12) not null, price_minimum_svc5 varchar(12) not null, price_minimum_svc6 varchar(12) not null, pymt_method int(3) not null, console_fmt int(1) not null, report_fmt int(1) not null, category int(3) not null, location int(3) not null, billing_freq int(3) not null, billing_code int(3) not null, billto_company varchar(40) not null, billto_addr tinyblob not null, billto_city varchar(40) not null, billto_pcode varchar(11) not null, billto_phone varchar(20) not null, billto_fax varchar(20) not null, billto_apcontact varchar(20) not null, billto_apcontact_email varchar(80) not null, notes text not null, primary key(id) )

create table client ( id int(11) unsigned not null auto_increment, acctno varchar(12) not null, date_added date not null, company varchar(40) not null, shortname varchar(20) not null, addr tinyblob not null, city varchar(40) not null, pcode varchar(10) not null, phone varchar(40) not null, phone2 varchar(40) not null, phone3 varchar(40) not null, fax varchar(40) not null, loginmessage_subject varchar(80) not null, loginmessage_body blob not null, startmessage date not null, endmessage date not null, contact1 varchar(30) not null, contact2 varchar(30) not null, contact3 varchar(30) not null, contact1phone varchar(40) not null, contact2phone varchar(40) not null, contact3phone varchar(40) not null, email1 varchar(80) not null, email2 varchar(80) not null, email3 varchar(80) not null, email1_notify char(1) not null, email2_notify char(1) not null, email3_notify char(1) not null, credit_hold char(1) not null, credit_limit varchar(12) not null, zone varchar(12) not null, extra_waybills varchar(2) not null, waybills_perpage char(1) not null, online_invoicing_email varchar(80) not null, online_invoicing_email2 varchar(80) not null, online_invoicing_email3 varchar(80) not null, online_invoicing_userid1 varchar(12) not null, online_invoicing_userid2 varchar(12) not null, online_invoicing_userid3 varchar(12) not null, language char(1) not null, taxgroup int(3) not null, terms int(3) not null, fs_ovrd varchar(12) not null, ref_mandatory char(1) not null, invoice_lines int(3) not null, invoiceoption_1 int(1) not null, invoiceoption_2 int(1) not null, invoiceoption_3 int(1) not null, invoiceoption_4 int(1) not null, invoiceoption_5 int(1) not null, invoiceoption_6 int(1) not null, invoiceoption_7 int(1) not null, invoiceoption_8 int(1) not null, invoiceoption_9 int(1) not null, invoiceoption_rb1 int(1) not null, invoiceoption_rb2 int(1) not null, invoiceoption_rb3 int(1) not null, invoiceoption_rb4 int(1) not null, invoiceoption_rb5 int(1) not null, invoiceoption_rb6 int(1) not null, invoiceoption_rb7 int(1) not null, invoiceoption_rb8 int(1) not null, invoiceoption_rb9 int(1) not null, price_ovrd_quotes int(1) not null, price_ovrd_nocharge_weight varchar(12) not null, price_ovrd_nocharge_pieces1 varchar(12) not null, price_ovrd_nocharge_pieces2 varchar(12) not null, price_ovrd_nocharge_pieces3 varchar(12) not null, price_ovrd_nocharge_pieces4 varchar(12) not null, price_ovrd_nocharge_pieces5 varchar(12) not null, price_ovrd_nocharge_pieces6 varchar(12) not null, price_ovrd_nocharge_pieces7 varchar(12) not null, price_ovrd_nocharge_pieces8 varchar(12) not null, price_ovrd_nocharge_pieces9 varchar(12) not null, price_ovrd_nocharge_pieces10 varchar(12) not null, price_ovrd_nocharge_pieces11 varchar(12) not null, price_ovrd_nocharge_pieces12 varchar(12) not null, price_ovrd_nocharge_volume varchar(12) not null, price_ovrd_extra_weight varchar(12) not null, price_ovrd_extra_pieces1 varchar(12) not null, price_ovrd_extra_pieces2 varchar(12) not null, price_ovrd_extra_pieces3 varchar(12) not null, price_ovrd_extra_pieces4 varchar(12) not null, price_ovrd_extra_pieces5 varchar(12) not null, price_ovrd_extra_pieces6 varchar(12) not null, price_ovrd_extra_pieces7 varchar(12) not null, price_ovrd_extra_pieces8 varchar(12) not null, price_ovrd_extra_pieces9 varchar(12) not null, price_ovrd_extra_pieces10 varchar(12) not null, price_ovrd_extra_pieces11 varchar(12) not null, price_ovrd_extra_pieces12 varchar(12) not null, price_ovrd_extra_volume varchar(12) not null, price_ovrd_apply_overwt int(1) not null, price_ovrd_apply_overpcs int(1) not null, price_ovrd_apply_overvol int(1) not null, price_ovrd_del_fee varchar(12) not null, price_ovrd_apply_delfee int(1) not null, price_ovrd_volume_discount varchar(12) not null, price_ovrd_volume_threshold varchar(12) not null, price_ovrd_vol_disc_prior int(2) not null, price_ovrd_apply_volume_discount int(1) not null, price_ovrd_distance_fee_svc1_veh1 varchar(12) not null, price_ovrd_distance_fee_svc1_veh2 varchar(12) not null, price_ovrd_distance_fee_svc1_veh3 varchar(12) not null, price_ovrd_distance_fee_svc1_veh4 varchar(12) not null, price_ovrd_distance_fee_svc1_veh5 varchar(12) not null, price_ovrd_distance_fee_svc1_veh6 varchar(12) not null, price_ovrd_distance_fee_svc1_veh7 varchar(12) not null, price_ovrd_distance_fee_svc1_veh8 varchar(12) not null, price_ovrd_distance_fee_svc2_veh1 varchar(12) not null, price_ovrd_distance_fee_svc2_veh2 varchar(12) not null, price_ovrd_distance_fee_svc2_veh3 varchar(12) not null, price_ovrd_distance_fee_svc2_veh4 varchar(12) not null, price_ovrd_distance_fee_svc2_veh5 varchar(12) not null, price_ovrd_distance_fee_svc2_veh6 varchar(12) not null, price_ovrd_distance_fee_svc2_veh7 varchar(12) not null, price_ovrd_distance_fee_svc2_veh8 varchar(12) not null, price_ovrd_distance_fee_svc3_veh1 varchar(12) not null, price_ovrd_distance_fee_svc3_veh2 varchar(12) not null, price_ovrd_distance_fee_svc3_veh3 varchar(12) not null, price_ovrd_distance_fee_svc3_veh4 varchar(12) not null, price_ovrd_distance_fee_svc3_veh5 varchar(12) not null, price_ovrd_distance_fee_svc3_veh6 varchar(12) not null, price_ovrd_distance_fee_svc3_veh7 varchar(12) not null, price_ovrd_distance_fee_svc3_veh8 varchar(12) not null, price_ovrd_distance_fee_svc4_veh1 varchar(12) not null, price_ovrd_distance_fee_svc4_veh2 varchar(12) not null, price_ovrd_distance_fee_svc4_veh3 varchar(12) not null, price_ovrd_distance_fee_svc4_veh4 varchar(12) not null, price_ovrd_distance_fee_svc4_veh5 varchar(12) not null, price_ovrd_distance_fee_svc4_veh6 varchar(12) not null, price_ovrd_distance_fee_svc4_veh7 varchar(12) not null, price_ovrd_distance_fee_svc4_veh8 varchar(12) not null, price_ovrd_distance_fee_svc5_veh1 varchar(12) not null, price_ovrd_distance_fee_svc5_veh2 varchar(12) not null, price_ovrd_distance_fee_svc5_veh3 varchar(12) not null, price_ovrd_distance_fee_svc5_veh4 varchar(12) not null, price_ovrd_distance_fee_svc5_veh5 varchar(12) not null, price_ovrd_distance_fee_svc5_veh6 varchar(12) not null, price_ovrd_distance_fee_svc5_veh7 varchar(12) not null, price_ovrd_distance_fee_svc5_veh8 varchar(12) not null, price_ovrd_distance_fee_svc6_veh1 varchar(12) not null, price_ovrd_distance_fee_svc6_veh2 varchar(12) not null, price_ovrd_distance_fee_svc6_veh3 varchar(12) not null, price_ovrd_distance_fee_svc6_veh4 varchar(12) not null, price_ovrd_distance_fee_svc6_veh5 varchar(12) not null, price_ovrd_distance_fee_svc6_veh6 varchar(12) not null, price_ovrd_distance_fee_svc6_veh7 varchar(12) not null, price_ovrd_distance_fee_svc6_veh8 varchar(12) not null, price_ovrd_distance_fee_svc7_veh1 varchar(12) not null, price_ovrd_distance_fee_svc7_veh2 varchar(12) not null, price_ovrd_distance_fee_svc7_veh3 varchar(12) not null, price_ovrd_distance_fee_svc7_veh4 varchar(12) not null, price_ovrd_distance_fee_svc7_veh5 varchar(12) not null, price_ovrd_distance_fee_svc7_veh6 varchar(12) not null, price_ovrd_distance_fee_svc7_veh7 varchar(12) not null, price_ovrd_distance_fee_svc7_veh8 varchar(12) not null, price_ovrd_distance_fee_svc8_veh1 varchar(12) not null, price_ovrd_distance_fee_svc8_veh2 varchar(12) not null, price_ovrd_distance_fee_svc8_veh3 varchar(12) not null, price_ovrd_distance_fee_svc8_veh4 varchar(12) not null, price_ovrd_distance_fee_svc8_veh5 varchar(12) not null, price_ovrd_distance_fee_svc8_veh6 varchar(12) not null, price_ovrd_distance_fee_svc8_veh7 varchar(12) not null, price_ovrd_distance_fee_svc8_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc1_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc2_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc3_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc4_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc5_veh8 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh1 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh2 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh3 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh4 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh5 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh6 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh7 varchar(12) not null, price_ovrd_flatrate_fee_svc6_veh8 varchar(12) not null, price_ovrd_cb1 varchar(12) not null, price_ovrd_cb2 varchar(12) not null, price_ovrd_cb3 varchar(12) not null, price_ovrd_svc1 varchar(12) not null, price_ovrd_svc2 varchar(12) not null, price_ovrd_svc3 varchar(12) not null, price_ovrd_svc4 varchar(12) not null, price_ovrd_svc5 varchar(12) not null, price_ovrd_wpv_method varchar(12) not null, price_minimum_svc1 varchar(12) not null, price_minimum_svc2 varchar(12) not null, price_minimum_svc3 varchar(12) not null, price_minimum_svc4 varchar(12) not null, price_minimum_svc5 varchar(12) not null, price_minimum_svc6 varchar(12) not null, pymt_method int(3) not null, console_fmt int(1) not null, report_fmt int(1) not null, category int(3) not null, location int(3) not null, billing_freq int(3) not null, billing_code int(3) not null, billto_company varchar(40) not null, billto_addr tinyblob not null, billto_city varchar(40) not null, billto_pcode varchar(11) not null, billto_phone varchar(20) not null, billto_fax varchar(20) not null, billto_apcontact varchar(20) not null, billto_apcontact_email varchar(80) not null, notes text not null, primary key(id) )