clear
mysql --user=mike --password=*********** <<krapola
connect mike;
show tables;
drop table mudpies;
create table mudpies (
la_agent_id text not null,
ss_item_bought text not null,
ss_date_bought_mo tinyint unsigned not null,
ss_date_bought_day tinyint unsigned not null,
ss_date_bought_year int unsigned not null,
ss_sales_rep_name text not null,
ss_qty bigint unsigned not null,
ss_dollars bigint unsigned not null,
ss_fulfillment text,
ss_leads_type text,
ss_date_fulfilled_mo tinyint unsigned not null,
ss_date_fulfilled_day tinyint unsigned not null,
ss_date_fulfilled_year int unsigned not null,
ss_date_shipped_mo tinyint unsigned not null,
ss_date_shipped_day tinyint unsigned not null,
ss_date_shipped_year int unsigned not null,
ss_date_received_mo tinyint unsigned not null,
ss_date_received_day tinyint unsigned not null,
ss_date_received_year int unsigned not null,
ss_tracking_no text
);
show tables;
desc mudpies;
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
show tables;
drop table sales_reps;
create table sales_reps (
sr_id int unsigned auto_increment key not null,
sr_dialer_code char(5) not null,
sr_name text not null
);
desc sales_reps;
krapola
mysql --user=mike --password=*********** <<krapola
connect mike;
show tables;
alter table trade_references add tr_address_cell_area text;
alter table trade_references add tr_address_cell_exchange text;
alter table trade_references add tr_address_cell_ext text;
alter table trade_references add tr_address_cell_number text;
alter table trade_references add tr_address_city text;
alter table trade_references add tr_address_comments text;
alter table trade_references add tr_address_country text;
alter table trade_references add tr_address_county text;
alter table trade_references add tr_address_direction text;
alter table trade_references add tr_address_direction_other text;
alter table trade_references add tr_address_email text;
alter table trade_references add tr_address_fax_area text;
alter table trade_references add tr_address_fax_exchange text;
alter table trade_references add tr_address_fax_ext text;
alter table trade_references add tr_address_fax_number text;
alter table trade_references add tr_address_land_area text;
alter table trade_references add tr_address_land_exchange text;
alter table trade_references add tr_address_land_ext text;
alter table trade_references add tr_address_land_number text;
alter table trade_references add tr_address_name text;
alter table trade_references add tr_address_number text;
alter table trade_references add tr_address_other_area text;
alter table trade_references add tr_address_other_exchange text;
alter table trade_references add tr_address_other_ext text;
alter table trade_references add tr_address_other_number text;
alter table trade_references add tr_address_pager_area text;
alter table trade_references add tr_address_pager_exchange text;
alter table trade_references add tr_address_pager_ext text;
alter table trade_references add tr_address_pager_number text;
alter table trade_references add tr_address_state text;
alter table trade_references add tr_address_type text;
alter table trade_references add tr_address_type_other text;
alter table trade_references add tr_address_unit text;
alter table trade_references add tr_address_unit_number text;
alter table trade_references add tr_address_unit_other text;
alter table trade_references add tr_address_website text;
alter table trade_references add tr_address_zip1 text;
alter table trade_references add tr_address_zip2 text;
alter table trade_references add tr_name_first text;
alter table trade_references add tr_name_last text;
alter table trade_references add tr_name_middle text;
alter table trade_references add tr_name_prefix text;
alter table trade_references add tr_name_suffix text;
alter table trade_references add tr_trade_name text;
krapola
mysql --user=mike --password=*********** <<krapola
connect mike;
show tables;
alter table bank_references add br_deposit_account_number text;
alter table bank_references add br_dob_month text;
alter table bank_references add br_dob_year text;
alter table bank_references add br_transit_aba_number text;
alter table bank_references add br_address_cell_area text;
alter table bank_references add br_address_cell_exchange text;
alter table bank_references add br_address_cell_ext text;
alter table bank_references add br_address_cell_number text;
alter table bank_references add br_address_city text;
alter table bank_references add br_address_comments text;
alter table bank_references add br_address_country text;
alter table bank_references add br_address_county text;
alter table bank_references add br_address_direction text;
alter table bank_references add br_address_direction_other text;
alter table bank_references add br_address_email text;
alter table bank_references add br_address_fax_area text;
alter table bank_references add br_address_fax_exchange text;
alter table bank_references add br_address_fax_ext text;
alter table bank_references add br_address_fax_number text;
alter table bank_references add br_address_land_area text;
alter table bank_references add br_address_land_exchange text;
alter table bank_references add br_address_land_ext text;
alter table bank_references add br_address_land_number text;
alter table bank_references add br_address_name text;
alter table bank_references add br_address_number text;
alter table bank_references add br_address_other_area text;
alter table bank_references add br_address_other_exchange text;
alter table bank_references add br_address_other_ext text;
alter table bank_references add br_address_other_number text;
alter table bank_references add br_address_pager_area text;
alter table bank_references add br_address_pager_exchange text;
alter table bank_references add br_address_pager_ext text;
alter table bank_references add br_address_pager_number text;
alter table bank_references add br_address_state text;
alter table bank_references add br_address_type text;
alter table bank_references add br_address_type_other text;
alter table bank_references add br_address_unit text;
alter table bank_references add br_address_unit_number text;
alter table bank_references add br_address_unit_other text;
alter table bank_references add br_address_website text;
alter table bank_references add br_address_zip1 text;
alter table bank_references add br_address_zip2 text;
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
desc agent_login_info;
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
desc agent_login_info;
alter table agent_login_info add ( la_purchase_date_day tinyint unsigned);
alter table agent_login_info add ( la_purchase_date_month tinyint unsigned);
alter table agent_login_info add ( la_leads_date_fulfilled_day tinyint unsigned);
alter table agent_login_info add ( la_leads_date_fulfilled_mo tinyint unsigned);
alter table agent_login_info add ( la_leads_date_received_day tinyint unsigned);
alter table agent_login_info add ( la_leads_date_received_mo tinyint unsigned);
alter table agent_login_info add ( la_leads_date_shipped_day tinyint unsigned);
alter table agent_login_info add ( la_leads_date_shipped_mo tinyint unsigned);
alter table agent_login_info add ( la_train_date_fulfilled_day tinyint unsigned);
alter table agent_login_info add ( la_train_date_fulfilled_mo tinyint unsigned);
alter table agent_login_info add ( la_train_date_received_day tinyint unsigned);
alter table agent_login_info add ( la_train_date_received_mo tinyint unsigned);
alter table agent_login_info add ( la_train_date_shipped_day tinyint unsigned);
alter table agent_login_info add ( la_train_date_shipped_mo tinyint unsigned);
alter table agent_login_info add ( la_web_date_fulfilled_day tinyint unsigned);
alter table agent_login_info add ( la_web_date_fulfilled_mo tinyint unsigned);
alter table agent_login_info add ( la_web_date_received_day tinyint unsigned);
alter table agent_login_info add ( la_web_date_received_mo tinyint unsigned);
alter table agent_login_info add ( la_web_date_shipped_day tinyint unsigned);
alter table agent_login_info add ( la_web_date_shipped_mo tinyint unsigned);
alter table agent_login_info add ( la_web_date_shipped_year int unsigned);
alter table agent_login_info add ( la_web_date_received_year int unsigned);
alter table agent_login_info add ( la_web_date_fulfilled_year int unsigned);
alter table agent_login_info add ( la_train_date_shipped_year int unsigned);
alter table agent_login_info add ( la_train_date_received_year int unsigned);
alter table agent_login_info add ( la_train_date_fulfilled_year int unsigned);
alter table agent_login_info add ( la_leads_date_shipped_year int unsigned);
alter table agent_login_info add ( la_leads_date_received_year int unsigned);
alter table agent_login_info add ( la_leads_date_fulfilled_year int unsigned);
alter table agent_login_info add ( la_purchase_date_year int unsigned);
alter table agent_login_info add ( la_leads_qty bigint unsigned);
alter table agent_login_info add ( la_train_qty bigint unsigned);
alter table agent_login_info add ( la_web_qty bigint unsigned);
alter table agent_login_info add ( la_web_dollars bigint unsigned);
alter table agent_login_info add ( la_train_dollars bigint unsigned);
alter table agent_login_info add ( la_leads_dollars bigint unsigned);
alter table agent_login_info add ( la_best_time1_hour tinyint unsigned);
alter table agent_login_info add ( la_best_time1_minute tinyint unsigned);
alter table agent_login_info add ( la_best_time2_hour tinyint unsigned);
alter table agent_login_info add ( la_best_time2_minute tinyint unsigned);
alter table agent_login_info add ( la_sales_rep_name char(5));
alter table agent_login_info add ( la_type_leads_plan text);
alter table agent_login_info add ( la_participating_agent text);
alter table agent_login_info add ( la_best_day_mon text);
alter table agent_login_info add ( la_best_day_tue text);
alter table agent_login_info add ( la_best_day_wed text);
alter table agent_login_info add ( la_best_day_thu text);
alter table agent_login_info add ( la_best_day_fri text);
alter table agent_login_info add ( la_best_day_sat text);
alter table agent_login_info add ( la_best_day_sun text);
alter table agent_login_info add ( la_best_time1_ampm text);
alter table agent_login_info add ( la_best_time2_ampm text);
alter table agent_login_info add ( la_best_time_comments text);
alter table agent_login_info add ( la_eps_agent_id_num text);
alter table agent_login_info add ( la_who_walked_thru_docs text);
alter table agent_login_info add ( la_web_fulfilment text);
alter table agent_login_info add ( la_web_tracking_no text);
alter table agent_login_info add ( la_train_fulfilment text);
alter table agent_login_info add ( la_train_tracking_no text);
alter table agent_login_info add ( la_leads_fulfilment text);
alter table agent_login_info add ( la_leads_tracking_no text);
alter table agent_login_info add ( la_leads_leads_type text);
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
show tables;
create table agent_login_info (la_agent_add_cell_area text,
la_agent_add_cell_exchange text,
la_agent_add_cell_ext text,
la_agent_add_cell_number text,
la_agent_add_city text,
la_agent_add_comments text,
la_agent_add_country text,
la_agent_add_direction text,
la_agent_add_direction_other text,
la_agent_add_email text,
la_agent_add_fax_area text,
la_agent_add_fax_exchange text,
la_agent_add_fax_ext text,
la_agent_add_fax_number text,
la_agent_add_land_area text,
la_agent_add_land_exchange text,
la_agent_add_land_ext text,
la_agent_add_land_number text,
la_agent_add_name text,
la_agent_add_number text,
la_agent_add_other_area text,
la_agent_add_other_exchange text,
la_agent_add_other_ext text,
la_agent_add_other_number text,
la_agent_add_pager_area text,
la_agent_add_pager_exchange text,
la_agent_add_pager_ext text,
la_agent_add_pager_number text,
la_agent_add_state text,
la_agent_add_type text,
la_agent_add_type_other text,
la_agent_add_unit text,
la_agent_add_unit_number text,
la_agent_add_unit_other text,
la_agent_add_website text,
la_agent_add_zip1 text,
la_agent_add_zip2 text,
la_agent_id text,
la_agent_name text,
la_doc_received_date_day tinyint,
la_doc_received_date_month tinyint,
la_doc_received_date_year int,
la_doc_walk_date_day tinyint,
la_doc_walk_date_month tinyint,
la_doc_walk_date_year int,
la_front_end_purchase text,
la_leads_per_month int,
la_pass_code text,
la_reload_amount bigint,
la_ship_date_day tinyint,
la_ship_date_month tinyint,
la_ship_date_year int,
la_what_bought text,
la_what_reloaded text,
la_purchase_promise_details text,
la_agent_add_city_code int,
la_agent_add_country_code int )
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
show tables;
alter table agent_login_info add
(la_agent_add_cell_area text,
la_agent_add_cell_exchange text,
la_agent_add_cell_ext text,
la_agent_add_cell_number text,
la_agent_add_city text,
la_agent_add_comments text,
la_agent_add_country text,
la_agent_add_direction text,
la_agent_add_direction_other text,
la_agent_add_email text,
la_agent_add_fax_area text,
la_agent_add_fax_exchange text,
la_agent_add_fax_ext text,
la_agent_add_fax_number text,
la_agent_add_land_area text,
la_agent_add_land_exchange text,
la_agent_add_land_ext text,
la_agent_add_land_number text,
la_agent_add_name text,
la_agent_add_number text,
la_agent_add_other_area text,
la_agent_add_other_exchange text,
la_agent_add_other_ext text,
la_agent_add_other_number text,
la_agent_add_pager_area text,
la_agent_add_pager_exchange text,
la_agent_add_pager_ext text,
la_agent_add_pager_number text,
la_agent_add_state text,
la_agent_add_type text,
la_agent_add_type_other text,
la_agent_add_unit text,
la_agent_add_unit_number text,
la_agent_add_unit_other text,
la_agent_add_website text,
la_agent_add_zip1 text,
la_agent_add_zip2 text,
la_agent_name text,
la_doc_received_date_day tinyint,
la_doc_received_date_month tinyint,
la_doc_received_date_year int,
la_doc_walk_date_day tinyint,
la_doc_walk_date_month tinyint,
la_doc_walk_date_year int,
la_front_end_purchase text,
la_leads_per_month int,
la_pass_code text,
la_reload_amount bigint,
la_ship_date_day tinyint,
la_ship_date_month tinyint,
la_ship_date_year int,
la_what_bought text,
la_what_reloaded text,
la_purchase_promise_details text,
la_agent_add_city_code int,
la_agent_add_country_code int
)
krapola
mysql --user=mike --password=*********** <<krapola
connect mike;
desc test1;
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
show tables;
desc agent_login_info;
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
desc agent_login_info;
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
desc agent_login_info;
exit
krapola
sql table agent_login_info
Field Type Null Key Default Extra
la_agent_id text MUL
la_agent_add_cell_area text YES NULL
la_agent_add_cell_exchange text YES NULL
la_agent_add_cell_ext text YES NULL
la_agent_add_cell_number text YES NULL
la_agent_add_city text YES NULL
la_agent_add_comments text YES NULL
la_agent_add_country text YES NULL
la_agent_add_direction text YES NULL
la_agent_add_direction_other text YES NULL
la_agent_add_email text YES NULL
la_agent_add_fax_area text YES NULL
la_agent_add_fax_exchange text YES NULL
la_agent_add_fax_ext text YES NULL
la_agent_add_fax_number text YES NULL
la_agent_add_land_area text YES NULL
la_agent_add_land_exchange text YES NULL
la_agent_add_land_ext text YES NULL
la_agent_add_land_number text YES NULL
la_agent_add_name text YES NULL
la_agent_add_number text YES NULL
la_agent_add_other_area text YES NULL
la_agent_add_other_exchange text YES NULL
la_agent_add_other_ext text YES NULL
la_agent_add_other_number text YES NULL
la_agent_add_pager_area text YES NULL
la_agent_add_pager_exchange text YES NULL
la_agent_add_pager_ext text YES NULL
la_agent_add_pager_number text YES NULL
la_agent_add_state text YES NULL
la_agent_add_type text YES NULL
la_agent_add_type_other text YES NULL
la_agent_add_unit text YES NULL
la_agent_add_unit_number text YES NULL
la_agent_add_unit_other text YES NULL
la_agent_add_website text YES NULL
la_agent_add_zip1 text YES NULL
la_agent_add_zip2 text YES NULL
la_doc_received_date_day tinyint(4) YES NULL
la_doc_received_date_month tinyint(4) YES NULL
la_doc_received_date_year int(11) YES NULL
la_doc_walk_date_day tinyint(4) YES NULL
la_doc_walk_date_month tinyint(4) YES NULL
la_doc_walk_date_year int(11) YES NULL
la_leads_per_month int(11) YES NULL
la_pass_code text YES NULL
la_reload_amount bigint(20) YES NULL
la_ship_date_day tinyint(4) YES NULL
la_ship_date_month tinyint(4) YES NULL
la_ship_date_year int(11) YES NULL
la_what_bought text YES NULL
la_what_reloaded text YES NULL
la_purchase_promise_details text YES NULL
la_agent_add_city_code int(11) YES NULL
la_agent_add_country_code int(11) YES NULL
la_name_prefix text YES NULL
la_name_first text YES NULL
la_name_middle text YES NULL
la_name_last text YES NULL
la_name_suffix text YES NULL
la_leads_remaining_this_month bigint(20) YES NULL
la_purchase_date_day tinyint(3) unsigned YES NULL
la_purchase_date_month tinyint(3) unsigned YES NULL
la_leads_date_fulfilled_day tinyint(3) unsigned YES NULL
la_leads_date_fulfilled_mo tinyint(3) unsigned YES NULL
la_leads_date_received_day tinyint(3) unsigned YES NULL
la_leads_date_received_mo tinyint(3) unsigned YES NULL
la_leads_date_shipped_day tinyint(3) unsigned YES NULL
la_leads_date_shipped_mo tinyint(3) unsigned YES NULL
la_train_date_fulfilled_day tinyint(3) unsigned YES NULL
la_train_date_fulfilled_mo tinyint(3) unsigned YES NULL
la_train_date_received_day tinyint(3) unsigned YES NULL
la_train_date_received_mo tinyint(3) unsigned YES NULL
la_train_date_shipped_day tinyint(3) unsigned YES NULL
la_train_date_shipped_mo tinyint(3) unsigned YES NULL
la_web_date_fulfilled_day tinyint(3) unsigned YES NULL
la_web_date_fulfilled_mo tinyint(3) unsigned YES NULL
la_web_date_received_day tinyint(3) unsigned YES NULL
la_web_date_received_mo tinyint(3) unsigned YES NULL
la_web_date_shipped_day tinyint(3) unsigned YES NULL
la_web_date_shipped_mo tinyint(3) unsigned YES NULL
la_web_date_shipped_year int(10) unsigned YES NULL
la_web_date_received_year int(10) unsigned YES NULL
la_web_date_fulfilled_year int(10) unsigned YES NULL
la_train_date_shipped_year int(10) unsigned YES NULL
la_train_date_received_year int(10) unsigned YES NULL
la_train_date_fulfilled_year int(10) unsigned YES NULL
la_leads_date_shipped_year int(10) unsigned YES NULL
la_leads_date_received_year int(10) unsigned YES NULL
la_leads_date_fulfilled_year int(10) unsigned YES NULL
la_purchase_date_year int(10) unsigned YES NULL
la_leads_qty bigint(20) unsigned YES NULL
la_train_qty bigint(20) unsigned YES NULL
la_web_qty bigint(20) unsigned YES NULL
la_web_dollars bigint(20) unsigned YES NULL
la_train_dollars bigint(20) unsigned YES NULL
la_leads_dollars bigint(20) unsigned YES NULL
la_best_time1_hour tinyint(3) unsigned YES NULL
la_best_time1_minute tinyint(3) unsigned YES NULL
la_best_time2_hour tinyint(3) unsigned YES NULL
la_best_time2_minute tinyint(3) unsigned YES NULL
la_type_leads_plan text YES NULL
la_participating_agent text YES NULL
la_best_day_mon text YES NULL
la_best_day_tue text YES NULL
la_best_day_wed text YES NULL
la_best_day_thu text YES NULL
la_best_day_fri text YES NULL
la_best_day_sat text YES NULL
la_best_day_sun text YES NULL
la_best_time1_ampm text YES NULL
la_best_time2_ampm text YES NULL
la_best_time_comments text YES NULL
la_eps_agent_id_num text YES NULL
la_who_walked_thru_docs text YES NULL
la_web_fulfilment text YES NULL
la_web_tracking_no text YES NULL
la_train_fulfilment text YES NULL
la_train_tracking_no text YES NULL
la_leads_fulfilment text YES NULL
la_leads_tracking_no text YES NULL
la_leads_leads_type text YES NULL
la_sales_rep_name int(10) unsigned 0
la_bad_passwords_entered int(11) 0
la_bad_passwords_allowed int(11) 0
la_front_end_purchase decimal(12,2) 0.00
mysql --user=leads --password=connect <<krapola
connect leads;
desc agent_login_info;
desc leads;
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
create table leads_selected (
la_agent_id text not null,
ls_ID int not null
);
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
create table supp_sales_types (
sst_id int unsigned auto_increment primary key,
sst_name text not null
);
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
drop table supp_sales_items;
create table supp_sales_items (
ssi_id int unsigned auto_increment primary key,
ssi_type int unsigned not null,
ssi_name text not null
);
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
drop table supp_sales_purchases;
create table supp_sales_purchases (
ss_agent_id text not null,
ss_id int unsigned auto_increment primary key,
ss_purchase_date_month tinyint unsigned not null,
ss_purchase_date_day tinyint unsigned not null,
ss_purchase_date_year int unsigned not null,
ss_sales_rep_name int unsigned unsigned not null,
ss_leads_sale_type int unsigned not null,
ss_leads_qty int unsigned not null,
ss_leads_dollars decimal(12,2) not null,
ss_leads_fulfilment text,
ss_leads_date_shipped_mo tinyint unsigned not null,
ss_leads_date_shipped_day tinyint unsigned not null,
ss_leads_date_shipped_year int unsigned not null,
ss_leads_date_received_mo tinyint unsigned not null,
ss_leads_date_received_day tinyint unsigned not null,
ss_leads_date_received_year int unsigned not null,
ss_leads_date_fulfilled_mo tinyint unsigned not null,
ss_leads_date_fulfilled_day tinyint unsigned not null,
ss_leads_date_fulfilled_year int unsigned not null,
ss_leads_tracking_no text
);
krapola
mysql --user=leads --password=connect <<krapola
connect leads;
insert into supp_sales_items (ssi_type, ssi_name) values ('1','Leads, Monthly');
insert into supp_sales_items (ssi_type, ssi_name) values ('1','Leads, One Shot');
insert into supp_sales_items (ssi_type, ssi_name) values ('2','Tri Fold Brochure');
insert into supp_sales_items (ssi_type, ssi_name) values ('2','4 x 6 Post Card Mailer');
insert into supp_sales_items (ssi_type, ssi_name) values ('2','5.5 x 8.5 Post Card Mailer');
insert into supp_sales_items (ssi_type, ssi_name) values ('2','6 x 11 Post Card');
insert into supp_sales_items (ssi_type, ssi_name) values ('2','Per Seat Call Blast');
insert into supp_sales_items (ssi_type, ssi_name) values ('2','HTML Newsletter e-mail Blast');
insert into supp_sales_items (ssi_type, ssi_name) values ('2','Unique Impressions');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG Business Cards - SQ Cnrs');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG Business Cards - Rnd Cnrs');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG BW Letterhead');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG COL Letterhead');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG COL BW Envelopes');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG COL COL Envelopes');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG Fax Cover Sheet Doc');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG E-Mail Signature');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG Camera Ready Art');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG Stock Images');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','MRG Customize');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','Customize');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','Set Up');
insert into supp_sales_items (ssi_type, ssi_name) values ('3','Production');
insert into supp_sales_items (ssi_type, ssi_name) values ('4','Additional Training Manuals');
insert into supp_sales_items (ssi_type, ssi_name) values ('4','Seminar');
insert into supp_sales_items (ssi_type, ssi_name) values ('4','Onsite');
insert into supp_sales_items (ssi_type, ssi_name) values ('4','Coaching');
insert into supp_sales_items (ssi_type, ssi_name) values ('4','Teleconference');
insert into supp_sales_items (ssi_type, ssi_name) values ('4','Boot Camp (Days)');
insert into supp_sales_items (ssi_type, ssi_name) values ('4','University Tuition');
insert into supp_sales_items (ssi_type, ssi_name) values ('4','Webinair');
insert into supp_sales_items (ssi_type, ssi_name) values ('4','Other - Specify (ISO)');
krapola
mv bb bb.sh
mv filesize filesize.sh
mv filesize.pl filesize.sh
mv fix fix.sh
mv krud krud.sh
mv leads leads.sh
mv mike mike.sh
mv mike_path mike_path.sh
mv ss ss.sh
mysql --user=leads --password=connect
#!/bin/bash
echo "<h2>$1</h2>"
echo "<table border=1>"
#mysql --user=leads --password=connect <<krapola >ykrud$$
#mysql --user=leads --password=connect <<krapola >ykrud$$
mysql --user=leads --password=connect <<krapola | sed "s# #\ </td><td>#g;s/^/<tr><td>/;s#\$#\ </td></tr>#;"
connect leads;
desc $1;
krapola
cat ykrud$$
#mysql --user=leads --password=connect <<krapola | sed "s# #\ </td><td>#g;s/^/<tr><td>/;s#\$#\ </td></tr>#;"
echo "</table>"
rm ykrud$$
#!/bin/bash
echo "Content-type: text/html"
echo ""
echo "<html>"
echo "it works up to here"
/usr/bin/mysql --user=leads --password=connect <<krapola | sed "s/^/leads2.sh /;" >krud$$
connect leads;
show tables;
krapola
chmod +x krud$$
krud$$
rm krud$$
#!/bin/bash
echo "<h2>$1</h2>"
echo "<table border=1>"
mysql --user=leads --password=connect <<krapola | sed "s# #\ </td><td>#g;s/^/<tr><td>/;s#\$#\ </td></tr>#;"
connect leads;
desc $1;
krapola
echo "</table>"
#!/bin/bash
#
# we have to tell it to search the current subdirectory for scripts
#
PATH=$PATH:.
export PATH
#
# run the mySQL program and list all the tables we have
# pass them to the script leads2.sh which will lists all
# the fields in each mySQL table
#
echo "<h1>supp_sales_types</ht>"
echo "<table border=1>"
/usr/bin/mysql --user=leads --password=connect <<krapola | sed "s# #\ </td><td>#g;s#^#<tr><td>#;s#\$#</td></tr>#;"
connect leads;
select sst_id, sst_name from supp_sales_types;
krapola
echo "</table>"
echo "<h1>supp_sales_items</ht>"
echo "<table border=1>"
/usr/bin/mysql --user=leads --password=connect <<krapola | sed "s# #\ </td><td>#g;s#^#<tr><td>#;s#\$#</td></tr>#;"
connect leads;
#select ssi_id,ssi_type,ssi_name from supp_sales_items;
select ssi_id,ssi_type,sst_name,ssi_name from supp_sales_items,supp_sales_types where sst_id=ssi_type;
krapola
echo "</table>"
#!/bin/bash
echo "<h2>$1</h2>"
echo "<table border=1>"
mysql --user=mike --password=*********** <<krapola | sed "s# #\ </td><td>#g;s/^/<tr><td>/;s#\$#\ </td></tr>#;"
connect mike;
desc $1;
krapola
cat ykrud$$
echo "</table>"
rm ykrud$$
#!/bin/bash
echo "Content-type: text/html"
echo ""
echo "<html>"
#
# we have to tell it to search the current subdirectory for scripts
#
PATH=$PATH:.
export PATH
#
# run the mySQL program and list all the tables we have
# pass them to the script leads2.sh which will lists all
# the fields in each mySQL table
#
/usr/bin/mysql --user=leads --password=connect <<krapola | sed "/Tables_in_leads/d;s/^/leads2.sh /;" >krud$$
connect leads;
show tables;
krapola
chmod +x krud$$
krud$$
rm krud$$
leads77.sh
#
# we have to do a
# chown mike:psacln file
# chmod +x file
#on all the perl scripts to get them to work
if [[ -z $1 ]] ; then
echo "ERROR you must enter a file name"
exit
fi
if [[ ! -a $1 ]] ; then
echo "ERROR file '$1' does not exist"
exit
fi
if [[ -d $1 ]] ; then
echo "ERROR file '$1' is a directory"
exit
fi
if [[ ! -f $1 ]] ; then
echo "ERROR file '$1' is not a regular file"
exit
fi
chown mike:psacln $1
chmod +x $1
mysql --user=mike --password=***********
#
# convert this to only display the last part of my prompt
#
#
# get the end of my prompt after the
#
# /var/www/vhosts/emerchant-direct.com/subdomains/
#
# ie:
# /mike/cgi-bin/....
#
mel=$PWD
#echo me=$mel
mel=${mel#/var/www/vhosts/emerchant-direct.com/subdomains/}
#
# get the front of my prompt
#
# if i am on this path it will return this part
#
# /var/www/vhosts/emerchant-direct.com/subdomains
#
# if i am on some other path it will return the full path name
# like
# /
# /root
#
mer=$PWD
#echo me=$mer
mer=${mer%$mel}
#echo FRONT=$mer
#
# if my prompt or my path begins with
#
# /www/vhosts/emerchant-direct.com/subdomains/
#
# remove it and replace it with
# ...//
#
if [[ $mer = '/var/www/vhosts/emerchant-direct.com/subdomains/' ]] ; then
#echo "its me in my web sites"
mel=".../$mel"
echo "$mel"
else
echo "$PWD"
fi
vim /var/www/vhosts/emerchant-direct.com/subdomains/mike/mikes_scripts/$1
if [[ -z $1 ]] ; then
echo "ERROR you must enter a file name to backup"
exit
fi
if [[ ! -a $1 ]] ; then
echo "ERROR file '$1' does not exist"
exit
fi
if [[ -d $1 ]] ; then
echo "ERROR file '$1' is a directory"
exit
fi
if [[ ! -f $1 ]] ; then
echo "ERROR file '$1' is not a regular file"
exit
fi
backbase=$1_back
k=0
kf=000
while ( test -a /var/www/vhosts/emerchant-direct.com/subdomains/mike/backed_up_files/$backbase$kf )
do
k=`expr $k + 1`
kf=$k
while (test ${#kf} -lt 3 )
do
kf=0$kf
done
done
echo $1 backed up as $backbase$kf
cp $1 /var/www/vhosts/emerchant-direct.com/subdomains/mike/backed_up_files/$backbase$kf
#open(IN,"krud");
$b=0;
while(<STDIN>) {
@in=split(' ',$_);
$b+=$in[0];
#print "$b $in[0]\n";
}
print "$b blocks\n";
#close(IN);
#!/bin/bash
echo "Content-type: text/html"
echo ""
echo "<html>"
#
# we have to tell it to search the current subdirectory for scripts
#
PATH=$PATH:.
export PATH
#
# run the mySQL program and list all the tables we have
# pass them to the script leads2.sh which will lists all
# the fields in each mySQL table
#
/usr/bin/mysql --user=mike --password=*********** <<krapola | sed "/Tables_in_mike/d;s/^/leads2m.sh /;" >krud$$
connect mike;
show tables;
krapola
chmod +x krud$$
krud$$
rm krud$$