Access denied for user 'allen712_saccapp'@'localhost' (using password: YES) Access denied for user 'apache'@'localhost' (using password: NO) create table adminusers (
id int(11) not null auto_increment,
userid char(12) not null,
password char(12) not null,
name varchar(30) not null,
phone varchar(20) not null,
email varchar(80) not null,
dispatchuser char(1) not null,
adminuser char(1) not null,
financeuser char(1) not null,
administrator char(1) not null,
last_login_date date not null,
language char(2) not null,
ucp_id int(5) not null,
ucp_cols int(1) not null,
ucp_rows int(2) not null,
ucp_svc1 char(1) not null,
ucp_svc2 char(1) not null,
ucp_svc3 char(1) not null,
ucp_svc4 char(1) not null,
ucp_svc5 char(1) not null,
ucp_svc6 char(1) not null,
ucp_svc7 char(1) not null,
ucp_svc8 char(1) not null,
ucp_svc9 char(1) not null,
ucp_status1 char(1) not null,
ucp_status2 char(1) not null,
ucp_status3 char(1) not null,
ucp_status4 char(1) not null,
ucp_status5 char(1) not null,
ucp_status6 char(1) not null,
ucp_status7 char(1) not null,
ucp_status8 char(1) not null,
ucp_status9 char(1) not null,
ucp_cat1 char(1) not null,
ucp_cat2 char(1) not null,
ucp_cat3 char(1) not null,
ucp_cat4 char(1) not null,
ucp_cat5 char(1) not null,
ucp_cat6 char(1) not null,
ucp_cat7 char(1) not null,
ucp_cat8 char(1) not null,
ucp_cat9 char(1) not null,
ucp_loc1 char(1) not null,
ucp_loc2 char(1) not null,
ucp_loc3 char(1) not null,
ucp_loc4 char(1) not null,
ucp_loc5 char(1) not null,
ucp_loc6 char(1) not null,
ucp_loc7 char(1) not null,
ucp_loc8 char(1) not null,
ucp_loc9 char(1) not null,
ucp_dates1 char(1) not null,
ucp_dates2 char(1) not null,
ucp_source1 char(1) not null,
ucp_source2 char(1) not null,
ucp_driver varchar(12) not null,
ucp_sort int(1) not null,
prev_ucp_svc1 char(1) not null,
prev_ucp_svc2 char(1) not null,
prev_ucp_svc3 char(1) not null,
prev_ucp_svc4 char(1) not null,
prev_ucp_svc5 char(1) not null,
prev_ucp_svc6 char(1) not null,
prev_ucp_svc7 char(1) not null,
prev_ucp_svc8 char(1) not null,
prev_ucp_svc9 char(1) not null,
prev_ucp_status1 char(1) not null,
prev_ucp_status2 char(1) not null,
prev_ucp_status3 char(1) not null,
prev_ucp_status4 char(1) not null,
prev_ucp_status5 char(1) not null,
prev_ucp_status6 char(1) not null,
prev_ucp_status7 char(1) not null,
prev_ucp_status8 char(1) not null,
prev_ucp_status9 char(1) not null,
prev_ucp_cat1 char(1) not null,
prev_ucp_cat2 char(1) not null,
prev_ucp_cat3 char(1) not null,
prev_ucp_cat4 char(1) not null,
prev_ucp_cat5 char(1) not null,
prev_ucp_cat6 char(1) not null,
prev_ucp_cat7 char(1) not null,
prev_ucp_cat8 char(1) not null,
prev_ucp_cat9 char(1) not null,
prev_ucp_loc1 char(1) not null,
prev_ucp_loc2 char(1) not null,
prev_ucp_loc3 char(1) not null,
prev_ucp_loc4 char(1) not null,
prev_ucp_loc5 char(1) not null,
prev_ucp_loc6 char(1) not null,
prev_ucp_loc7 char(1) not null,
prev_ucp_loc8 char(1) not null,
prev_ucp_loc9 char(1) not null,
prev_ucp_dates1 char(1) not null,
prev_ucp_dates2 char(1) not null,
prev_ucp_source1 char(1) not null,
prev_ucp_source2 char(1) not null,
prev_ucp_driver varchar(12) not null,
ucp2_id int(5) not null,
ucp2_cols int(1) not null,
ucp2_rows int(2) not null,
ucp2_svc1 char(1) not null,
ucp2_svc2 char(1) not null,
ucp2_svc3 char(1) not null,
ucp2_svc4 char(1) not null,
ucp2_svc5 char(1) not null,
ucp2_svc6 char(1) not null,
ucp2_svc7 char(1) not null,
ucp2_svc8 char(1) not null,
ucp2_svc9 char(1) not null,
ucp2_status1 char(1) not null,
ucp2_status2 char(1) not null,
ucp2_status3 char(1) not null,
ucp2_status4 char(1) not null,
ucp2_status5 char(1) not null,
ucp2_status6 char(1) not null,
ucp2_status7 char(1) not null,
ucp2_status8 char(1) not null,
ucp2_status9 char(1) not null,
ucp2_cat1 char(1) not null,
ucp2_cat2 char(1) not null,
ucp2_cat3 char(1) not null,
ucp2_cat4 char(1) not null,
ucp2_cat5 char(1) not null,
ucp2_cat6 char(1) not null,
ucp2_cat7 char(1) not null,
ucp2_cat8 char(1) not null,
ucp2_cat9 char(1) not null,
ucp2_loc1 char(1) not null,
ucp2_loc2 char(1) not null,
ucp2_loc3 char(1) not null,
ucp2_loc4 char(1) not null,
ucp2_loc5 char(1) not null,
ucp2_loc6 char(1) not null,
ucp2_loc7 char(1) not null,
ucp2_loc8 char(1) not null,
ucp2_loc9 char(1) not null,
ucp2_dates1 char(1) not null,
ucp2_dates2 char(1) not null,
ucp2_source1 char(1) not null,
ucp2_source2 char(1) not null,
ucp2_driver varchar(12) not null,
ucp2_sort int(1) not null,
prev_ucp2_svc1 char(1) not null,
prev_ucp2_svc2 char(1) not null,
prev_ucp2_svc3 char(1) not null,
prev_ucp2_svc4 char(1) not null,
prev_ucp2_svc5 char(1) not null,
prev_ucp2_svc6 char(1) not null,
prev_ucp2_svc7 char(1) not null,
prev_ucp2_svc8 char(1) not null,
prev_ucp2_svc9 char(1) not null,
prev_ucp2_status1 char(1) not null,
prev_ucp2_status2 char(1) not null,
prev_ucp2_status3 char(1) not null,
prev_ucp2_status4 char(1) not null,
prev_ucp2_status5 char(1) not null,
prev_ucp2_status6 char(1) not null,
prev_ucp2_status7 char(1) not null,
prev_ucp2_status8 char(1) not null,
prev_ucp2_status9 char(1) not null,
prev_ucp2_cat1 char(1) not null,
prev_ucp2_cat2 char(1) not null,
prev_ucp2_cat3 char(1) not null,
prev_ucp2_cat4 char(1) not null,
prev_ucp2_cat5 char(1) not null,
prev_ucp2_cat6 char(1) not null,
prev_ucp2_cat7 char(1) not null,
prev_ucp2_cat8 char(1) not null,
prev_ucp2_cat9 char(1) not null,
prev_ucp2_loc1 char(1) not null,
prev_ucp2_loc2 char(1) not null,
prev_ucp2_loc3 char(1) not null,
prev_ucp2_loc4 char(1) not null,
prev_ucp2_loc5 char(1) not null,
prev_ucp2_loc6 char(1) not null,
prev_ucp2_loc7 char(1) not null,
prev_ucp2_loc8 char(1) not null,
prev_ucp2_loc9 char(1) not null,
prev_ucp2_dates1 char(1) not null,
prev_ucp2_dates2 char(1) not null,
prev_ucp2_source1 char(1) not null,
prev_ucp2_source2 char(1) not null,
prev_ucp2_driver varchar(12) not null,
console_std_lightcolor char(6) not null,
console_std_darkcolor char(6) not null,
console_std_textcolor varchar(6) not null,
console_std_boldtext char(1) not null,
console_os1_lightcolor char(6) not null,
console_os1_darkcolor char(6) not null,
console_os1_textcolor varchar(6) not null,
console_os1_boldtext char(1) not null,
console_os2_lightcolor char(6) not null,
console_os2_darkcolor char(6) not null,
console_os2_textcolor varchar(6) not null,
console_os2_boldtext char(1) not null,
console_os3_lightcolor char(6) not null,
console_os3_darkcolor char(6) not null,
console_os3_textcolor varchar(6) not null,
console_os3_boldtext char(1) not null,
console_os4_lightcolor char(6) not null,
console_os4_darkcolor char(6) not null,
console_os4_textcolor varchar(6) not null,
console_os4_boldtext char(1) not null,
console_os5_lightcolor char(6) not null,
console_os5_darkcolor char(6) not null,
console_os5_textcolor varchar(6) not null,
console_os5_boldtext char(1) not null,
console_os6_lightcolor char(6) not null,
console_os6_darkcolor char(6) not null,
console_os6_textcolor varchar(6) not null,
console_os6_boldtext char(1) not null,
console_sv0_lightcolor char(6) not null,
console_sv0_darkcolor char(6) not null,
console_sv0_textcolor varchar(6) not null,
console_sv0_boldtext char(1) not null,
console_sv1_lightcolor char(6) not null,
console_sv1_darkcolor char(6) not null,
console_sv1_textcolor varchar(6) not null,
console_sv1_boldtext char(1) not null,
console_sv2_lightcolor char(6) not null,
console_sv2_darkcolor char(6) not null,
console_sv2_textcolor varchar(6) not null,
console_sv2_boldtext char(1) not null,
console_sv3_lightcolor char(6) not null,
console_sv3_darkcolor char(6) not null,
console_sv3_textcolor varchar(6) not null,
console_sv3_boldtext char(1) not null,
console_sv4_lightcolor char(6) not null,
console_sv4_darkcolor char(6) not null,
console_sv4_textcolor varchar(6) not null,
console_sv4_boldtext char(1) not null,
console_sv5_lightcolor char(6) not null,
console_sv5_darkcolor char(6) not null,
console_sv5_textcolor varchar(6) not null,
console_sv5_boldtext char(1) not null,
console_sv6_lightcolor char(6) not null,
console_sv6_darkcolor char(6) not null,
console_sv6_textcolor varchar(6) not null,
console_sv6_boldtext char(1) not null,
console_sv7_lightcolor char(6) not null,
console_sv7_darkcolor char(6) not null,
console_sv7_textcolor varchar(6) not null,
console_sv7_boldtext char(1) not null,
console_sv8_lightcolor char(6) not null,
console_sv8_darkcolor char(6) not null,
console_sv8_textcolor varchar(6) not null,
console_sv8_boldtext char(1) not null,
console_req_textcolor varchar(6) not null,
console_req_boldtext char(1) not null,
console_fd_textcolor varchar(6) not null,
console_fd_boldtext char(1) not null,
primary key(id) )
create table adminusers (
id int(11) not null auto_increment,
userid char(12) not null,
password char(12) not null,
name varchar(30) not null,
phone varchar(20) not null,
email varchar(80) not null,
dispatchuser char(1) not null,
adminuser char(1) not null,
financeuser char(1) not null,
administrator char(1) not null,
last_login_date date not null,
language char(2) not null,
ucp_id int(5) not null,
ucp_cols int(1) not null,
ucp_rows int(2) not null,
ucp_svc1 char(1) not null,
ucp_svc2 char(1) not null,
ucp_svc3 char(1) not null,
ucp_svc4 char(1) not null,
ucp_svc5 char(1) not null,
ucp_svc6 char(1) not null,
ucp_svc7 char(1) not null,
ucp_svc8 char(1) not null,
ucp_svc9 char(1) not null,
ucp_status1 char(1) not null,
ucp_status2 char(1) not null,
ucp_status3 char(1) not null,
ucp_status4 char(1) not null,
ucp_status5 char(1) not null,
ucp_status6 char(1) not null,
ucp_status7 char(1) not null,
ucp_status8 char(1) not null,
ucp_status9 char(1) not null,
ucp_cat1 char(1) not null,
ucp_cat2 char(1) not null,
ucp_cat3 char(1) not null,
ucp_cat4 char(1) not null,
ucp_cat5 char(1) not null,
ucp_cat6 char(1) not null,
ucp_cat7 char(1) not null,
ucp_cat8 char(1) not null,
ucp_cat9 char(1) not null,
ucp_loc1 char(1) not null,
ucp_loc2 char(1) not null,
ucp_loc3 char(1) not null,
ucp_loc4 char(1) not null,
ucp_loc5 char(1) not null,
ucp_loc6 char(1) not null,
ucp_loc7 char(1) not null,
ucp_loc8 char(1) not null,
ucp_loc9 char(1) not null,
ucp_dates1 char(1) not null,
ucp_dates2 char(1) not null,
ucp_source1 char(1) not null,
ucp_source2 char(1) not null,
ucp_driver varchar(12) not null,
ucp_sort int(1) not null,
prev_ucp_svc1 char(1) not null,
prev_ucp_svc2 char(1) not null,
prev_ucp_svc3 char(1) not null,
prev_ucp_svc4 char(1) not null,
prev_ucp_svc5 char(1) not null,
prev_ucp_svc6 char(1) not null,
prev_ucp_svc7 char(1) not null,
prev_ucp_svc8 char(1) not null,
prev_ucp_svc9 char(1) not null,
prev_ucp_status1 char(1) not null,
prev_ucp_status2 char(1) not null,
prev_ucp_status3 char(1) not null,
prev_ucp_status4 char(1) not null,
prev_ucp_status5 char(1) not null,
prev_ucp_status6 char(1) not null,
prev_ucp_status7 char(1) not null,
prev_ucp_status8 char(1) not null,
prev_ucp_status9 char(1) not null,
prev_ucp_cat1 char(1) not null,
prev_ucp_cat2 char(1) not null,
prev_ucp_cat3 char(1) not null,
prev_ucp_cat4 char(1) not null,
prev_ucp_cat5 char(1) not null,
prev_ucp_cat6 char(1) not null,
prev_ucp_cat7 char(1) not null,
prev_ucp_cat8 char(1) not null,
prev_ucp_cat9 char(1) not null,
prev_ucp_loc1 char(1) not null,
prev_ucp_loc2 char(1) not null,
prev_ucp_loc3 char(1) not null,
prev_ucp_loc4 char(1) not null,
prev_ucp_loc5 char(1) not null,
prev_ucp_loc6 char(1) not null,
prev_ucp_loc7 char(1) not null,
prev_ucp_loc8 char(1) not null,
prev_ucp_loc9 char(1) not null,
prev_ucp_dates1 char(1) not null,
prev_ucp_dates2 char(1) not null,
prev_ucp_source1 char(1) not null,
prev_ucp_source2 char(1) not null,
prev_ucp_driver varchar(12) not null,
ucp2_id int(5) not null,
ucp2_cols int(1) not null,
ucp2_rows int(2) not null,
ucp2_svc1 char(1) not null,
ucp2_svc2 char(1) not null,
ucp2_svc3 char(1) not null,
ucp2_svc4 char(1) not null,
ucp2_svc5 char(1) not null,
ucp2_svc6 char(1) not null,
ucp2_svc7 char(1) not null,
ucp2_svc8 char(1) not null,
ucp2_svc9 char(1) not null,
ucp2_status1 char(1) not null,
ucp2_status2 char(1) not null,
ucp2_status3 char(1) not null,
ucp2_status4 char(1) not null,
ucp2_status5 char(1) not null,
ucp2_status6 char(1) not null,
ucp2_status7 char(1) not null,
ucp2_status8 char(1) not null,
ucp2_status9 char(1) not null,
ucp2_cat1 char(1) not null,
ucp2_cat2 char(1) not null,
ucp2_cat3 char(1) not null,
ucp2_cat4 char(1) not null,
ucp2_cat5 char(1) not null,
ucp2_cat6 char(1) not null,
ucp2_cat7 char(1) not null,
ucp2_cat8 char(1) not null,
ucp2_cat9 char(1) not null,
ucp2_loc1 char(1) not null,
ucp2_loc2 char(1) not null,
ucp2_loc3 char(1) not null,
ucp2_loc4 char(1) not null,
ucp2_loc5 char(1) not null,
ucp2_loc6 char(1) not null,
ucp2_loc7 char(1) not null,
ucp2_loc8 char(1) not null,
ucp2_loc9 char(1) not null,
ucp2_dates1 char(1) not null,
ucp2_dates2 char(1) not null,
ucp2_source1 char(1) not null,
ucp2_source2 char(1) not null,
ucp2_driver varchar(12) not null,
ucp2_sort int(1) not null,
prev_ucp2_svc1 char(1) not null,
prev_ucp2_svc2 char(1) not null,
prev_ucp2_svc3 char(1) not null,
prev_ucp2_svc4 char(1) not null,
prev_ucp2_svc5 char(1) not null,
prev_ucp2_svc6 char(1) not null,
prev_ucp2_svc7 char(1) not null,
prev_ucp2_svc8 char(1) not null,
prev_ucp2_svc9 char(1) not null,
prev_ucp2_status1 char(1) not null,
prev_ucp2_status2 char(1) not null,
prev_ucp2_status3 char(1) not null,
prev_ucp2_status4 char(1) not null,
prev_ucp2_status5 char(1) not null,
prev_ucp2_status6 char(1) not null,
prev_ucp2_status7 char(1) not null,
prev_ucp2_status8 char(1) not null,
prev_ucp2_status9 char(1) not null,
prev_ucp2_cat1 char(1) not null,
prev_ucp2_cat2 char(1) not null,
prev_ucp2_cat3 char(1) not null,
prev_ucp2_cat4 char(1) not null,
prev_ucp2_cat5 char(1) not null,
prev_ucp2_cat6 char(1) not null,
prev_ucp2_cat7 char(1) not null,
prev_ucp2_cat8 char(1) not null,
prev_ucp2_cat9 char(1) not null,
prev_ucp2_loc1 char(1) not null,
prev_ucp2_loc2 char(1) not null,
prev_ucp2_loc3 char(1) not null,
prev_ucp2_loc4 char(1) not null,
prev_ucp2_loc5 char(1) not null,
prev_ucp2_loc6 char(1) not null,
prev_ucp2_loc7 char(1) not null,
prev_ucp2_loc8 char(1) not null,
prev_ucp2_loc9 char(1) not null,
prev_ucp2_dates1 char(1) not null,
prev_ucp2_dates2 char(1) not null,
prev_ucp2_source1 char(1) not null,
prev_ucp2_source2 char(1) not null,
prev_ucp2_driver varchar(12) not null,
console_std_lightcolor char(6) not null,
console_std_darkcolor char(6) not null,
console_std_textcolor varchar(6) not null,
console_std_boldtext char(1) not null,
console_os1_lightcolor char(6) not null,
console_os1_darkcolor char(6) not null,
console_os1_textcolor varchar(6) not null,
console_os1_boldtext char(1) not null,
console_os2_lightcolor char(6) not null,
console_os2_darkcolor char(6) not null,
console_os2_textcolor varchar(6) not null,
console_os2_boldtext char(1) not null,
console_os3_lightcolor char(6) not null,
console_os3_darkcolor char(6) not null,
console_os3_textcolor varchar(6) not null,
console_os3_boldtext char(1) not null,
console_os4_lightcolor char(6) not null,
console_os4_darkcolor char(6) not null,
console_os4_textcolor varchar(6) not null,
console_os4_boldtext char(1) not null,
console_os5_lightcolor char(6) not null,
console_os5_darkcolor char(6) not null,
console_os5_textcolor varchar(6) not null,
console_os5_boldtext char(1) not null,
console_os6_lightcolor char(6) not null,
console_os6_darkcolor char(6) not null,
console_os6_textcolor varchar(6) not null,
console_os6_boldtext char(1) not null,
console_sv0_lightcolor char(6) not null,
console_sv0_darkcolor char(6) not null,
console_sv0_textcolor varchar(6) not null,
console_sv0_boldtext char(1) not null,
console_sv1_lightcolor char(6) not null,
console_sv1_darkcolor char(6) not null,
console_sv1_textcolor varchar(6) not null,
console_sv1_boldtext char(1) not null,
console_sv2_lightcolor char(6) not null,
console_sv2_darkcolor char(6) not null,
console_sv2_textcolor varchar(6) not null,
console_sv2_boldtext char(1) not null,
console_sv3_lightcolor char(6) not null,
console_sv3_darkcolor char(6) not null,
console_sv3_textcolor varchar(6) not null,
console_sv3_boldtext char(1) not null,
console_sv4_lightcolor char(6) not null,
console_sv4_darkcolor char(6) not null,
console_sv4_textcolor varchar(6) not null,
console_sv4_boldtext char(1) not null,
console_sv5_lightcolor char(6) not null,
console_sv5_darkcolor char(6) not null,
console_sv5_textcolor varchar(6) not null,
console_sv5_boldtext char(1) not null,
console_sv6_lightcolor char(6) not null,
console_sv6_darkcolor char(6) not null,
console_sv6_textcolor varchar(6) not null,
console_sv6_boldtext char(1) not null,
console_sv7_lightcolor char(6) not null,
console_sv7_darkcolor char(6) not null,
console_sv7_textcolor varchar(6) not null,
console_sv7_boldtext char(1) not null,
console_sv8_lightcolor char(6) not null,
console_sv8_darkcolor char(6) not null,
console_sv8_textcolor varchar(6) not null,
console_sv8_boldtext char(1) not null,
console_req_textcolor varchar(6) not null,
console_req_boldtext char(1) not null,
console_fd_textcolor varchar(6) not null,
console_fd_boldtext char(1) not null,
primary key(id) )