Access denied for user 'allen712_saccapp'@'localhost' (using password: YES) Access denied for user 'apache'@'localhost' (using password: NO) create table contractdeliveries (
id int(11) not null auto_increment,
contractno varchar(40) not null,
deliveryno int(5) not null,
clid int(11) not null,
acctno varchar(12) not null,
date_added date not null,
date_modified date not null,
active char(1) not null,
descn varchar(80) not null,
notes tinytext not null,
ovrd_price varchar(12) not null,
vehicle int(3) not null,
assignto_driver1 varchar(12) not null,
assignto_driver2 varchar(12) not null,
driver1_pay varchar(12) not null,
driver2_pay varchar(12) not null,
sms_driver1 char(1) not null,
order_puname varchar(30) not null,
order_puat tinytext not null,
order_pupc varchar(10) not null,
order_puzone varchar(12) not null,
order_pucontact varchar(30) not null,
order_puphone varchar(20) not null,
order_pickup_by char(1) not null,
order_pickup_time char(5) not null,
order_pickup_ampm char(2) not null,
order_delname varchar(30) not null,
order_delto tinytext not null,
order_delpc varchar(10) not null,
order_delzone varchar(12) not null,
order_delattn varchar(40) not null,
order_delphone varchar(20) not null,
order_deliver_by char(1) not null,
order_deliver_time char(5) not null,
order_deliver_ampm char(2) not null,
order_confemail varchar(80) not null,
order_inst tinytext not null,
order_desc tinytext not null,
chargecode varchar(50) not null,
weight_charge varchar(12) not null,
over_weight varchar(12) not null,
pieces_type int(3) not null,
pieces_charge varchar(12) not null,
over_pieces varchar(12) not null,
volume_charge varchar(12) not null,
over_volume varchar(12) not null,
order_checkbox1 char(1) not null,
order_checkbox2 char(1) not null,
order_checkbox3 char(1) not null,
order_xtra1 char(1) not null,
order_xtra2 char(1) not null,
order_xtra3 char(1) not null,
order_xtra4 char(1) not null,
order_xtra5 char(1) not null,
order_nosig char(1) not null,
order_return char(1) not null,
lastorder int(11) not null,
lastorder_date date not null,
lastorder_fromalt_sun int(11) not null,
lastorder_date_fromalt_sun date not null,
lastorder_fromalt_mon int(11) not null,
lastorder_date_fromalt_mon date not null,
lastorder_fromalt_tue int(11) not null,
lastorder_date_fromalt_tue date not null,
lastorder_fromalt_wed int(11) not null,
lastorder_date_fromalt_wed date not null,
lastorder_fromalt_thu int(11) not null,
lastorder_date_fromalt_thu date not null,
lastorder_fromalt_fri int(11) not null,
lastorder_date_fromalt_fri date not null,
lastorder_fromalt_sat int(11) not null,
lastorder_date_fromalt_sat date not null,
sched_daily_sun char(1) not null,
sched_daily_mon char(1) not null,
sched_daily_tue char(1) not null,
sched_daily_wed char(1) not null,
sched_daily_thu char(1) not null,
sched_daily_fri char(1) not null,
sched_daily_sat char(1) not null,
sched_weekly_1_sun char(1) not null,
sched_weekly_1_mon char(1) not null,
sched_weekly_1_tue char(1) not null,
sched_weekly_1_wed char(1) not null,
sched_weekly_1_thu char(1) not null,
sched_weekly_1_fri char(1) not null,
sched_weekly_1_sat char(1) not null,
sched_weekly_2_sun char(1) not null,
sched_weekly_2_mon char(1) not null,
sched_weekly_2_tue char(1) not null,
sched_weekly_2_wed char(1) not null,
sched_weekly_2_thu char(1) not null,
sched_weekly_2_fri char(1) not null,
sched_weekly_2_sat char(1) not null,
sched_weekly_3_sun char(1) not null,
sched_weekly_3_mon char(1) not null,
sched_weekly_3_tue char(1) not null,
sched_weekly_3_wed char(1) not null,
sched_weekly_3_thu char(1) not null,
sched_weekly_3_fri char(1) not null,
sched_weekly_3_sat char(1) not null,
sched_weekly_4_sun char(1) not null,
sched_weekly_4_mon char(1) not null,
sched_weekly_4_tue char(1) not null,
sched_weekly_4_wed char(1) not null,
sched_weekly_4_thu char(1) not null,
sched_weekly_4_fri char(1) not null,
sched_weekly_4_sat char(1) not null,
sched_weekly_last_sun char(1) not null,
sched_weekly_last_mon char(1) not null,
sched_weekly_last_tue char(1) not null,
sched_weekly_last_wed char(1) not null,
sched_weekly_last_thu char(1) not null,
sched_weekly_last_fri char(1) not null,
sched_weekly_last_sat char(1) not null,
sched_weekly_alt_sun char(1) not null,
sched_weekly_alt_mon char(1) not null,
sched_weekly_alt_tue char(1) not null,
sched_weekly_alt_wed char(1) not null,
sched_weekly_alt_thu char(1) not null,
sched_weekly_alt_fri char(1) not null,
sched_weekly_alt_sat char(1) not null,
sched_monthly_1 char(1) not null,
sched_monthly_2 char(1) not null,
sched_monthly_3 char(1) not null,
sched_monthly_4 char(1) not null,
sched_monthly_5 char(1) not null,
sched_monthly_6 char(1) not null,
sched_monthly_7 char(1) not null,
sched_monthly_8 char(1) not null,
sched_monthly_9 char(1) not null,
sched_monthly_10 char(1) not null,
sched_monthly_11 char(1) not null,
sched_monthly_12 char(1) not null,
sched_monthly_13 char(1) not null,
sched_monthly_14 char(1) not null,
sched_monthly_15 char(1) not null,
sched_monthly_16 char(1) not null,
sched_monthly_17 char(1) not null,
sched_monthly_18 char(1) not null,
sched_monthly_19 char(1) not null,
sched_monthly_20 char(1) not null,
sched_monthly_21 char(1) not null,
sched_monthly_22 char(1) not null,
sched_monthly_23 char(1) not null,
sched_monthly_24 char(1) not null,
sched_monthly_25 char(1) not null,
sched_monthly_26 char(1) not null,
sched_monthly_27 char(1) not null,
sched_monthly_28 char(1) not null,
sched_monthly_29 char(1) not null,
sched_monthly_30 char(1) not null,
sched_monthly_31 char(1) not null,
primary key(id) )
create table contractdeliveries (
id int(11) not null auto_increment,
contractno varchar(40) not null,
deliveryno int(5) not null,
clid int(11) not null,
acctno varchar(12) not null,
date_added date not null,
date_modified date not null,
active char(1) not null,
descn varchar(80) not null,
notes tinytext not null,
ovrd_price varchar(12) not null,
vehicle int(3) not null,
assignto_driver1 varchar(12) not null,
assignto_driver2 varchar(12) not null,
driver1_pay varchar(12) not null,
driver2_pay varchar(12) not null,
sms_driver1 char(1) not null,
order_puname varchar(30) not null,
order_puat tinytext not null,
order_pupc varchar(10) not null,
order_puzone varchar(12) not null,
order_pucontact varchar(30) not null,
order_puphone varchar(20) not null,
order_pickup_by char(1) not null,
order_pickup_time char(5) not null,
order_pickup_ampm char(2) not null,
order_delname varchar(30) not null,
order_delto tinytext not null,
order_delpc varchar(10) not null,
order_delzone varchar(12) not null,
order_delattn varchar(40) not null,
order_delphone varchar(20) not null,
order_deliver_by char(1) not null,
order_deliver_time char(5) not null,
order_deliver_ampm char(2) not null,
order_confemail varchar(80) not null,
order_inst tinytext not null,
order_desc tinytext not null,
chargecode varchar(50) not null,
weight_charge varchar(12) not null,
over_weight varchar(12) not null,
pieces_type int(3) not null,
pieces_charge varchar(12) not null,
over_pieces varchar(12) not null,
volume_charge varchar(12) not null,
over_volume varchar(12) not null,
order_checkbox1 char(1) not null,
order_checkbox2 char(1) not null,
order_checkbox3 char(1) not null,
order_xtra1 char(1) not null,
order_xtra2 char(1) not null,
order_xtra3 char(1) not null,
order_xtra4 char(1) not null,
order_xtra5 char(1) not null,
order_nosig char(1) not null,
order_return char(1) not null,
lastorder int(11) not null,
lastorder_date date not null,
lastorder_fromalt_sun int(11) not null,
lastorder_date_fromalt_sun date not null,
lastorder_fromalt_mon int(11) not null,
lastorder_date_fromalt_mon date not null,
lastorder_fromalt_tue int(11) not null,
lastorder_date_fromalt_tue date not null,
lastorder_fromalt_wed int(11) not null,
lastorder_date_fromalt_wed date not null,
lastorder_fromalt_thu int(11) not null,
lastorder_date_fromalt_thu date not null,
lastorder_fromalt_fri int(11) not null,
lastorder_date_fromalt_fri date not null,
lastorder_fromalt_sat int(11) not null,
lastorder_date_fromalt_sat date not null,
sched_daily_sun char(1) not null,
sched_daily_mon char(1) not null,
sched_daily_tue char(1) not null,
sched_daily_wed char(1) not null,
sched_daily_thu char(1) not null,
sched_daily_fri char(1) not null,
sched_daily_sat char(1) not null,
sched_weekly_1_sun char(1) not null,
sched_weekly_1_mon char(1) not null,
sched_weekly_1_tue char(1) not null,
sched_weekly_1_wed char(1) not null,
sched_weekly_1_thu char(1) not null,
sched_weekly_1_fri char(1) not null,
sched_weekly_1_sat char(1) not null,
sched_weekly_2_sun char(1) not null,
sched_weekly_2_mon char(1) not null,
sched_weekly_2_tue char(1) not null,
sched_weekly_2_wed char(1) not null,
sched_weekly_2_thu char(1) not null,
sched_weekly_2_fri char(1) not null,
sched_weekly_2_sat char(1) not null,
sched_weekly_3_sun char(1) not null,
sched_weekly_3_mon char(1) not null,
sched_weekly_3_tue char(1) not null,
sched_weekly_3_wed char(1) not null,
sched_weekly_3_thu char(1) not null,
sched_weekly_3_fri char(1) not null,
sched_weekly_3_sat char(1) not null,
sched_weekly_4_sun char(1) not null,
sched_weekly_4_mon char(1) not null,
sched_weekly_4_tue char(1) not null,
sched_weekly_4_wed char(1) not null,
sched_weekly_4_thu char(1) not null,
sched_weekly_4_fri char(1) not null,
sched_weekly_4_sat char(1) not null,
sched_weekly_last_sun char(1) not null,
sched_weekly_last_mon char(1) not null,
sched_weekly_last_tue char(1) not null,
sched_weekly_last_wed char(1) not null,
sched_weekly_last_thu char(1) not null,
sched_weekly_last_fri char(1) not null,
sched_weekly_last_sat char(1) not null,
sched_weekly_alt_sun char(1) not null,
sched_weekly_alt_mon char(1) not null,
sched_weekly_alt_tue char(1) not null,
sched_weekly_alt_wed char(1) not null,
sched_weekly_alt_thu char(1) not null,
sched_weekly_alt_fri char(1) not null,
sched_weekly_alt_sat char(1) not null,
sched_monthly_1 char(1) not null,
sched_monthly_2 char(1) not null,
sched_monthly_3 char(1) not null,
sched_monthly_4 char(1) not null,
sched_monthly_5 char(1) not null,
sched_monthly_6 char(1) not null,
sched_monthly_7 char(1) not null,
sched_monthly_8 char(1) not null,
sched_monthly_9 char(1) not null,
sched_monthly_10 char(1) not null,
sched_monthly_11 char(1) not null,
sched_monthly_12 char(1) not null,
sched_monthly_13 char(1) not null,
sched_monthly_14 char(1) not null,
sched_monthly_15 char(1) not null,
sched_monthly_16 char(1) not null,
sched_monthly_17 char(1) not null,
sched_monthly_18 char(1) not null,
sched_monthly_19 char(1) not null,
sched_monthly_20 char(1) not null,
sched_monthly_21 char(1) not null,
sched_monthly_22 char(1) not null,
sched_monthly_23 char(1) not null,
sched_monthly_24 char(1) not null,
sched_monthly_25 char(1) not null,
sched_monthly_26 char(1) not null,
sched_monthly_27 char(1) not null,
sched_monthly_28 char(1) not null,
sched_monthly_29 char(1) not null,
sched_monthly_30 char(1) not null,
sched_monthly_31 char(1) not null,
primary key(id) )