2007-08-13 13:31:18,006 INFO MysqlHandler - db admin connection: user=root, password=***, , connection=mysql:host=localhost
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0742, sql=show databases
2007-08-13 13:31:18,006 DEBUG MysqlHandler - database: array (
'Database' => 'information_schema',
0 => 'information_schema',
)
2007-08-13 13:31:18,006 DEBUG MysqlHandler - database: array (
'Database' => 'mysql',
0 => 'mysql',
)
2007-08-13 13:31:18,006 DEBUG MysqlHandler - database: array (
'Database' => 'test',
0 => 'test',
)
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0105, sql=CREATE DATABASE IF NOT EXISTS calemeam CHARACTER SET utf8 COLLATE utf8_general_ci
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0099, sql=CREATE USER 'calemeam'@'localhost' IDENTIFIED BY 'calemeam'
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0017, sql=GRANT SELECT, UPDATE, INSERT, DELETE, CREATE, ALTER, INDEX ON `calemeam`.* TO 'calemeam'@'localhost'
2007-08-13 13:31:18,006 INFO MysqlHandler - calem db connection: user=calemeam, password=***, , connection=mysql:host=localhost;dbname=calemeam, persistent connection=Array
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.098, sql=CREATE TABLE acl_group (id varchar (36),
acl_group varchar (30) ,
parent_group_id varchar (36),
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0751, sql=ALTER TABLE acl_group ADD PRIMARY KEY (id)
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0415, sql=CREATE UNIQUE INDEX uidx_acl_group_acl_group ON acl_group (acl_group)
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0162, sql=CREATE TABLE asset (id varchar (36),
asset_no varchar (30) ,
note varchar (76) ,
priority_id varchar (36),
status_id varchar (36),
parent_id varchar (36),
type_id varchar (36),
template_id varchar (36),
category_id varchar (36),
location_id varchar (36),
weight double,
weight_uom_id varchar (36),
serial_no varchar (30) ,
owner_user_id varchar (36),
start_date date ,
purchase_date date ,
original_cost double,
manufacturer_id varchar (36),
vendor_id varchar (36),
warranty_start_date date ,
warranty_end_date date ,
maint_labor_hours double,
maint_labor_cost double,
maint_material_cost double,
maint_cost double,
rollup_cost tinyint (1),
costcode_id varchar (36),
dept_id varchar (36),
in_id varchar (36),
depreciation_type_id varchar (36),
depreciation_start date ,
depreciation_time_id varchar (36),
depreciation_rate double,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.042, sql=ALTER TABLE asset ADD PRIMARY KEY (id)
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0418, sql=CREATE UNIQUE INDEX uidx_asset_asset_no ON asset (asset_no)
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE asset_comment (id varchar (36),
asset_id varchar (36),
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE asset_comment ADD PRIMARY KEY (id)
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0499, sql=CREATE INDEX idx_asset_comment_asset_id ON asset_comment (asset_id)
2007-08-13 13:31:18,006 DEBUG CalemPdo - query() time:0.0583, sql=CREATE INDEX idx_asset_comment_modified_time ON asset_comment (modified_time)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.1005, sql=CREATE TABLE asset_depreciation (id varchar (36),
asset_id varchar (36),
start_date date ,
end_date date ,
depreciation_rate double,
start_value double,
end_value double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0419, sql=ALTER TABLE asset_depreciation ADD PRIMARY KEY (id)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0415, sql=CREATE INDEX idx_asset_depreciation_start ON asset_depreciation (start_date)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_asset_depreciation ON asset_depreciation (asset_id)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0167, sql=CREATE TABLE asset_downtime (id varchar (36),
asset_id varchar (36),
downtime_type_id varchar (36),
downtime_cause_id varchar (36),
start_time datetime ,
shift_id varchar (36),
end_time datetime ,
hours double,
wo_id varchar (36),
reported_by_id varchar (36),
reported_time datetime ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE asset_downtime ADD PRIMARY KEY (id)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_asset_downtime_start ON asset_downtime (start_time)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_asset_downtime ON asset_downtime (asset_id)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0245, sql=CREATE TABLE asset_meter (id varchar (36),
asset_id varchar (36),
meter_no varchar (30) ,
type_id varchar (36),
reading_uom_id varchar (36),
reading double,
is_rollover tinyint (1),
time_taken datetime ,
rollup_type_id varchar (36),
rollover_reading double,
rollover_count int ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0585, sql=ALTER TABLE asset_meter ADD PRIMARY KEY (id)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0834, sql=CREATE INDEX idx_asset_meter_meter_no ON asset_meter (meter_no)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.3347, sql=CREATE INDEX idx_asset_meter ON asset_meter (asset_id)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE asset_part (id varchar (36),
asset_id varchar (36),
in_id varchar (36),
type_id varchar (36),
qty double,
uom_id varchar (36),
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE asset_part ADD PRIMARY KEY (id)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_asset_in ON asset_part (in_id)
2007-08-13 13:31:19,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_asset_asset ON asset_part (asset_id)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE asset_type (id varchar (36),
type varchar (30) ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0417, sql=ALTER TABLE asset_type ADD PRIMARY KEY (id)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_asset_type ON asset_type (type)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE budget (id varchar (36),
title_id varchar (36),
budget varchar (30) ,
state_id varchar (36),
start_date date ,
end_date date ,
budgeted double,
app double,
accounting double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0418, sql=CREATE UNIQUE INDEX uidx_budget ON budget (budget)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0584, sql=CREATE INDEX idx_budget_start_date ON budget (start_date)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0834, sql=ALTER TABLE budget ADD PRIMARY KEY (id)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0917, sql=CREATE TABLE budget_status_log (id varchar (36),
budget_id varchar (36),
to_state_id varchar (36),
from_state_id varchar (36),
changed_by_id varchar (36),
created_time datetime ,
comment text )
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE budget_status_log ADD PRIMARY KEY (id)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_budget_status_log ON budget_status_log (budget_id)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_budget_status_log_time ON budget_status_log (created_time)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE budget_title (id varchar (36),
title varchar (30) ,
start_date date ,
end_date date ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE budget_title ADD PRIMARY KEY (id)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE UNIQUE INDEX uidx_costcode_costcode ON budget_title (title)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_budget_title_start_date ON budget_title (start_date)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE contact (id varchar (36),
full_name varchar (50) ,
job_title varchar (30) ,
type_id varchar (36),
note varchar (76) ,
phone_work varchar (24) ,
phone_home varchar (16) ,
phone_mobile varchar (16) ,
email_work varchar (50) ,
email_other varchar (50) ,
im1_type_id varchar (36),
im1_id varchar (30) ,
im2_type_id varchar (36),
im2_id varchar (30) ,
fax varchar (16) ,
company varchar (50) ,
street1 varchar (50) ,
street2 varchar (50) ,
city varchar (50) ,
state varchar (50) ,
zip varchar (16) ,
country varchar (50) ,
asset_id varchar (36),
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0502, sql=ALTER TABLE contact ADD PRIMARY KEY (id)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0583, sql=CREATE UNIQUE INDEX uidx_contact_full_name ON contact (full_name)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0328, sql=CREATE TABLE contractor (id varchar (36),
contractor varchar (30) ,
note varchar (76) ,
start_date date ,
end_date date ,
contact_id varchar (36),
costcode_id varchar (36),
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.118, sql=ALTER TABLE contractor ADD PRIMARY KEY (id)
2007-08-13 13:31:20,006 DEBUG CalemPdo - query() time:0.0419, sql=CREATE UNIQUE INDEX uidx_contractor_contractor ON contractor (contractor)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE costcode (id varchar (36),
costcode varchar (30) ,
note varchar (76) ,
dept_id varchar (36),
parent_id varchar (36),
rollup_cost tinyint (1),
cost_type_id varchar (36),
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE costcode ADD PRIMARY KEY (id)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_costcode_costcode ON costcode (costcode)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE craft (id varchar (36),
craft varchar (30) ,
note varchar (76) ,
rate double,
ot_factor double,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE craft ADD PRIMARY KEY (id)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_craft_craft ON craft (craft)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE dept (id varchar (36),
dept varchar (30) ,
note varchar (76) ,
manager_id varchar (36),
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0501, sql=ALTER TABLE dept ADD PRIMARY KEY (id)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0583, sql=CREATE UNIQUE INDEX uidx_dept_dept ON dept (dept)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0328, sql=CREATE TABLE document (id varchar (36),
document varchar (30) ,
url text ,
type_id varchar (36),
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.1679, sql=ALTER TABLE document ADD PRIMARY KEY (id)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_document ON document (document)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE doc_type (id varchar (36),
type varchar (30) ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE doc_type ADD PRIMARY KEY (id)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_in_type ON doc_type (type)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE downtime_unit_cost (id varchar (36),
asset_id varchar (36),
downtime_type_id varchar (36),
hourly_rate double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0419, sql=ALTER TABLE downtime_unit_cost ADD PRIMARY KEY (id)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_downtime_unit_cost ON downtime_unit_cost (asset_id)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE inspection (id varchar (36),
inspection varchar (50) ,
type_id varchar (36),
inspect_contact_id varchar (36),
inspect_user_id varchar (36),
owner_user_id varchar (36),
start_time datetime ,
end_time datetime ,
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0417, sql=ALTER TABLE inspection ADD PRIMARY KEY (id)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0499, sql=CREATE UNIQUE INDEX uidx_inspection ON inspection (inspection)
2007-08-13 13:31:21,006 DEBUG CalemPdo - query() time:0.0751, sql=CREATE INDEX idx_inspection_start ON inspection (start_time)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.1004, sql=CREATE TABLE ins_citation (id varchar (36),
citation varchar (50) ,
inspection_id varchar (36),
severity_id varchar (36),
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0423, sql=ALTER TABLE ins_citation ADD PRIMARY KEY (id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_citation_citation ON ins_citation (citation)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_citation_inspection ON ins_citation (inspection_id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE inventory (id varchar (36),
in_no varchar (30) ,
note varchar (76) ,
type_id varchar (36),
category_id varchar (36),
stock_type_id varchar (36),
valuation_type_id varchar (36),
uom_id varchar (36),
avg_unit_cost double,
rent_uom_id varchar (36),
rent_rate double,
qty_in_stock double,
qty_on_order double,
qty_reserved double,
qty_to_order double,
order_gen_id varchar (36),
order_type_id varchar (36),
min_level double,
max_level double,
reorder_point double,
reorder_qty double,
owner_user_id varchar (36),
notification_id varchar (36),
costcode_id varchar (36),
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE inventory ADD PRIMARY KEY (id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0418, sql=CREATE UNIQUE INDEX uidx_inventory ON inventory (in_no)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_inventory_costcode ON inventory (costcode_id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0243, sql=CREATE TABLE in_audit (id varchar (36),
in_id varchar (36),
audit_user_id varchar (36),
start_date date ,
end_date date ,
hours double,
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0585, sql=ALTER TABLE in_audit ADD PRIMARY KEY (id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0834, sql=CREATE INDEX idx_in_audit ON in_audit (in_id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.1085, sql=CREATE TABLE in_comment (id varchar (36),
in_id varchar (36),
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.042, sql=ALTER TABLE in_comment ADD PRIMARY KEY (id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_in_comment_in_id ON in_comment (in_id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_in_comment_modified_time ON in_comment (modified_time)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE in_doc (id varchar (36),
in_id varchar (36),
doc_id varchar (36),
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE in_doc ADD PRIMARY KEY (id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_in_doc ON in_doc (in_id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE in_location (id varchar (36),
location varchar (30) ,
parent_id varchar (36),
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE in_location ADD PRIMARY KEY (id)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_in_location ON in_location (location)
2007-08-13 13:31:22,006 DEBUG CalemPdo - query() time:0.0503, sql=CREATE INDEX idx_in_location_parent ON in_location (parent_id)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0327, sql=CREATE TABLE in_reserved (id varchar (36),
in_id varchar (36),
wo_id varchar (36),
qty double,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.1522, sql=ALTER TABLE in_reserved ADD PRIMARY KEY (id)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0501, sql=CREATE INDEX idx_in_reserved ON in_reserved (in_id)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0418, sql=CREATE INDEX idx_in_reserved_wo_id ON in_reserved (wo_id)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE in_stock (id varchar (36),
in_id varchar (36),
location_id varchar (36),
qty double,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE in_stock ADD PRIMARY KEY (id)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_in_stock ON in_stock (in_id)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0415, sql=CREATE INDEX idx_in_in_location ON in_stock (location_id)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0245, sql=CREATE TABLE in_tran (id varchar (36),
in_id varchar (36),
type_id varchar (36),
location_id varchar (36),
qty double,
unit_cost double,
costcode_id varchar (36),
checkout_type_id varchar (36),
checkout_to_id varchar (36),
receive_type_id varchar (36),
receive_from_id varchar (36),
qty_available double,
qty_orig double,
orig_loc_id varchar (36),
checkout_tran_id varchar (36),
rent_duration double,
rent_rate double,
tran_total double,
note varchar (76) ,
tran_time datetime ,
tran_user_id varchar (36),
store_user_id varchar (36),
voided tinyint (1),
authorized_by_id varchar (36),
void_by_id varchar (36),
void_time datetime ,
void_note varchar (76) ,
new_tran_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0586, sql=ALTER TABLE in_tran ADD PRIMARY KEY (id)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0834, sql=CREATE INDEX idx_in_tran_in ON in_tran (in_id, type_id, voided)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.1509, sql=CREATE INDEX idx_in_tran_checkout_to_id ON in_tran (checkout_to_id, checkout_type_id, voided)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0418, sql=CREATE INDEX idx_in_tran_receive_from ON in_tran (receive_from_id, receive_type_id, voided)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0418, sql=CREATE INDEX idx_in_tran_tran_time ON in_tran (tran_time)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE in_tran_worksheet (id varchar (36),
in_tran_id varchar (36),
src_tran_id varchar (36),
qty double,
unit_cost double,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE in_tran_worksheet ADD PRIMARY KEY (id)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_in_tran_worksheet ON in_tran_worksheet (in_tran_id)
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE in_type (id varchar (36),
type varchar (30) ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:23,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE in_type ADD PRIMARY KEY (id)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0501, sql=CREATE UNIQUE INDEX uidx_in_type ON in_type (type)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0244, sql=CREATE TABLE in_vendor (id varchar (36),
in_id varchar (36),
vendor_id varchar (36),
vendor_part_no varchar (30) ,
is_primary tinyint (1),
uom_id varchar (36),
unit_cost double,
lead_time_days double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0753, sql=ALTER TABLE in_vendor ADD PRIMARY KEY (id)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.126, sql=CREATE UNIQUE INDEX uidx_in_vendor ON in_vendor (in_id, vendor_id)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_in_vendor_vendor ON in_vendor (vendor_id)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0244, sql=CREATE TABLE manufacturer (id varchar (36),
manufacturer varchar (30) ,
note varchar (76) ,
contact_id varchar (36),
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0419, sql=ALTER TABLE manufacturer ADD PRIMARY KEY (id)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_manufacturer ON manufacturer (manufacturer)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0162, sql=CREATE TABLE meter_transaction (id varchar (36),
meter_id varchar (36),
read_by_id varchar (36),
time_taken datetime ,
reading double,
is_rollover tinyint (1),
wo_id varchar (36),
note varchar (76) ,
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0417, sql=ALTER TABLE meter_transaction ADD PRIMARY KEY (id)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_meter_transaction_time ON meter_transaction (time_taken)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_meter_transaction ON meter_transaction (meter_id)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.084, sql=CREATE INDEX idx_meter_transaction_wo ON meter_transaction (wo_id)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0753, sql=CREATE TABLE meter_type (id varchar (36),
type varchar (30) ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0419, sql=ALTER TABLE meter_type ADD PRIMARY KEY (id)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_meter_type ON meter_type (type)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0162, sql=CREATE TABLE pm (id varchar (36),
pm_no varchar (30) ,
description text ,
status_id varchar (36),
asset_type_id varchar (36),
rcm_action_id varchar (36),
category_id varchar (36),
priority_id varchar (36),
origin_id varchar (36),
origin_user_id varchar (36),
assigned_to_id varchar (36),
assigned_team_id varchar (36),
duration_hours double,
release_type_id varchar (36),
schedule_type_id varchar (36),
release_schedule varchar (1024) ,
labor_hours double,
downtime_hours double,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0419, sql=ALTER TABLE pm ADD PRIMARY KEY (id)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE UNIQUE INDEX uidx_pm_pm_no ON pm (pm_no)
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE pm_asset (id varchar (36),
pm_id varchar (36),
asset_id varchar (36),
last_released date ,
last_closed date ,
next_due_date date ,
release_count int ,
costcode_id varchar (36),
dept_id varchar (36),
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:24,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE pm_asset ADD PRIMARY KEY (id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0418, sql=CREATE INDEX idx_pm_asset_pm ON pm_asset (pm_id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.05, sql=CREATE INDEX idx_pm_asset_asset ON pm_asset (asset_id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0244, sql=CREATE TABLE pm_audit (id varchar (36),
pm_id varchar (36),
audit_user_id varchar (36),
start_date date ,
end_date date ,
hours double,
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0835, sql=ALTER TABLE pm_audit ADD PRIMARY KEY (id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.1175, sql=CREATE INDEX idx_pm_audit ON pm_audit (pm_id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE pm_comment (id varchar (36),
pm_id varchar (36),
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE pm_comment ADD PRIMARY KEY (id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_pm_comment_pm_id ON pm_comment (pm_id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_pm_comment_modified_time ON pm_comment (modified_time)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE pm_dependency (id varchar (36),
pm_id varchar (36),
child_pm_id varchar (36),
type_id varchar (36),
scope_id varchar (36),
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE pm_dependency ADD PRIMARY KEY (id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_pm_dependency_pm ON pm_dependency (pm_id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_pm_dependency_child ON pm_dependency (child_pm_id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0243, sql=CREATE TABLE pm_doc (id varchar (36),
pm_id varchar (36),
seq int ,
doc_id varchar (36),
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0585, sql=ALTER TABLE pm_doc ADD PRIMARY KEY (id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0834, sql=CREATE INDEX idx_pm_doc ON pm_doc (pm_id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0919, sql=CREATE TABLE pm_downtime (id varchar (36),
pm_id varchar (36),
hours double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0419, sql=ALTER TABLE pm_downtime ADD PRIMARY KEY (id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0422, sql=CREATE INDEX idx_pm_downtime_pm ON pm_downtime (pm_id)
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE pm_labor (id varchar (36),
pm_id varchar (36),
craft_id varchar (36),
hours double,
crew_size int ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:25,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE pm_labor ADD PRIMARY KEY (id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0753, sql=CREATE INDEX idx_pm_labor_pm ON pm_labor (pm_id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0415, sql=CREATE INDEX idx_pm_labor_craft ON pm_labor (craft_id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE pm_meter (id varchar (36),
pm_asset_id varchar (36),
meter_id varchar (36),
release_by_meter tinyint (1),
reading_released double,
rollover_count int ,
reading_interval double,
copy_to_wo tinyint (1),
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE pm_meter ADD PRIMARY KEY (id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.05, sql=CREATE INDEX idx_pm_meter_asset ON pm_meter (pm_asset_id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0834, sql=CREATE INDEX idx_pm_meter_meter ON pm_meter (meter_id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.1086, sql=CREATE TABLE pm_part (id varchar (36),
pm_id varchar (36),
in_id varchar (36),
qty double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0419, sql=ALTER TABLE pm_part ADD PRIMARY KEY (id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_pm_part_pm ON pm_part (pm_id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_pm_part_in ON pm_part (in_id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0162, sql=CREATE TABLE pm_safety (id varchar (36),
pm_id varchar (36),
seq int ,
description text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE pm_safety ADD PRIMARY KEY (id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_pm_safety ON pm_safety (pm_id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE pm_season (id varchar (36),
pm_asset_id varchar (36),
start_date date ,
end_date date ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE pm_season ADD PRIMARY KEY (id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0499, sql=CREATE INDEX idx_pm_season ON pm_season (pm_asset_id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0244, sql=CREATE TABLE pm_step (id varchar (36),
pm_id varchar (36),
seq int ,
description text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0668, sql=ALTER TABLE pm_step ADD PRIMARY KEY (id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.1342, sql=CREATE INDEX idx_pm_step ON pm_step (pm_id)
2007-08-13 13:31:26,006 DEBUG CalemPdo - query() time:0.0163, sql=CREATE TABLE pm_tool (id varchar (36),
pm_id varchar (36),
in_id varchar (36),
qty double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0417, sql=ALTER TABLE pm_tool ADD PRIMARY KEY (id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_pm_tool_pm ON pm_tool (pm_id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_pm_tool_in ON pm_tool (in_id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE po (id varchar (36),
po_no varchar (30) ,
status_id varchar (36),
state_id varchar (36),
buyer_id varchar (36),
buyer_name varchar (50) ,
buyer_phone varchar (24) ,
po_date date ,
vendor_id varchar (36),
vendor_addr varchar (512) ,
vendor_contact_id varchar (36),
vendor_contact_phone varchar (24) ,
payment_term_id varchar (36),
shipping_type_id varchar (36),
shipping_term_id varchar (36),
shipping_addr_id varchar (36),
billing_addr_id varchar (36),
po_item_total double,
tax_rate_total double,
tax_charge double,
total_charge double,
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0419, sql=ALTER TABLE po ADD PRIMARY KEY (id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE UNIQUE INDEX uidx_po ON po (po_no)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE po_address (id varchar (36),
address varchar (512) ,
type_id varchar (36),
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE po_address ADD PRIMARY KEY (id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0244, sql=CREATE TABLE po_item (id varchar (36),
line_no int ,
po_id varchar (36),
in_id varchar (36),
vendor_part_no varchar (50) ,
note varchar (76) ,
unit_cost double,
qty double,
qty_received double,
uom_id varchar (36),
due_date date ,
line_cost double,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0585, sql=ALTER TABLE po_item ADD PRIMARY KEY (id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.1593, sql=CREATE INDEX idx_po_items_po ON po_item (po_id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_po_items_in ON po_item (in_id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_po_items_line_no ON po_item (line_no)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE po_seq (id int )
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0164, sql=CREATE TABLE po_status_log (id varchar (36),
po_id varchar (36),
from_status_id varchar (36),
to_status_id varchar (36),
from_state_id varchar (36),
to_state_id varchar (36),
changed_by_id varchar (36),
created_time datetime ,
comment text )
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0758, sql=ALTER TABLE po_status_log ADD PRIMARY KEY (id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_po_status_log ON po_status_log (po_id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE project (id varchar (36),
project_no varchar (30) ,
parent_id varchar (36),
note varchar (76) ,
status_id varchar (36),
priority_id varchar (36),
type_id varchar (36),
owner_user_id varchar (36),
sched_start_time datetime ,
sched_end_time datetime ,
actual_start_time datetime ,
actual_end_time datetime ,
sched_hours double,
actual_hours double,
percent_done double,
dept_id varchar (36),
costcode_id varchar (36),
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE project ADD PRIMARY KEY (id)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.05, sql=CREATE UNIQUE INDEX uidx_project_project_no ON project (project_no)
2007-08-13 13:31:27,006 DEBUG CalemPdo - query() time:0.0835, sql=CREATE INDEX idx_project_start_time ON project (sched_start_time)
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.1129, sql=CREATE INDEX idx_project_parent_id ON project (parent_id)
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE project_type (id varchar (36),
type varchar (30) ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.0419, sql=ALTER TABLE project_type ADD PRIMARY KEY (id)
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_project_type ON project_type (type)
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.0244, sql=CREATE TABLE rcm_action (id varchar (36),
failure_id varchar (36),
cause varchar (50) ,
action varchar (50) ,
cause_type_id varchar (36),
description text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.0668, sql=ALTER TABLE rcm_action ADD PRIMARY KEY (id)
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.1927, sql=CREATE INDEX idx_rcm_action ON rcm_action (failure_id)
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.0163, sql=CREATE TABLE rcm_action_part (id varchar (36),
action_id varchar (36),
in_id varchar (36),
qty double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE rcm_action_part ADD PRIMARY KEY (id)
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.0418, sql=CREATE INDEX idx_rcm_action_part ON rcm_action_part (action_id)
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE rcm_consequence (id varchar (36),
failure_id varchar (36),
consequence varchar (50) ,
type_id varchar (36),
pm_policy_id varchar (36),
description text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.0509, sql=ALTER TABLE rcm_consequence ADD PRIMARY KEY (id)
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.0687, sql=CREATE INDEX idx_rcm_consequence ON rcm_consequence (failure_id)
2007-08-13 13:31:28,006 DEBUG CalemPdo - query() time:0.2762, sql=CREATE TABLE rcm_failure (id varchar (36),
failure varchar (50) ,
is_evident tinyint (1),
function_id varchar (36),
template_id varchar (36),
description text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0576, sql=ALTER TABLE rcm_failure ADD PRIMARY KEY (id)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0415, sql=CREATE UNIQUE INDEX uidx_rcm_failure ON rcm_failure (failure)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE rcm_function (id varchar (36),
fn_name varchar (50) ,
template_id varchar (36),
description text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE rcm_function ADD PRIMARY KEY (id)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE UNIQUE INDEX uidx_rcm_function ON rcm_function (fn_name)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE rcm_template (id varchar (36),
template varchar (30) ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0417, sql=ALTER TABLE rcm_template ADD PRIMARY KEY (id)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_rcm_template ON rcm_template (template)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE recycle_bin (id varchar (36),
parent_id varchar (36),
description varchar (256) ,
table_name varchar (30) ,
rec_id varchar (36),
value_deleted TEXT ,
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0502, sql=ALTER TABLE recycle_bin ADD PRIMARY KEY (id)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0667, sql=CREATE INDEX idx_recycle_bin_table_name ON recycle_bin (table_name)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.151, sql=CREATE INDEX idx_recycle_bin_rec_id ON recycle_bin (rec_id)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE requisition (id varchar (36),
req_no varchar (30) ,
description text ,
priority_id varchar (36),
status_id varchar (36),
req_on_po_id varchar (36),
source_id varchar (36),
state_id varchar (36),
due_date date ,
shipping_type_id varchar (36),
wo_id varchar (36),
request_user_id varchar (36),
request_time datetime ,
req_total double,
costcode_id varchar (36),
dept_id varchar (36),
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE requisition ADD PRIMARY KEY (id)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE UNIQUE INDEX uidx_requisition ON requisition (req_no)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX uidx_req_due_date ON requisition (due_date)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE req_item (id varchar (36),
req_id varchar (36),
in_id varchar (36),
vendor_id varchar (36),
vendor_part_no varchar (50) ,
unit_cost double,
qty double,
uom_id varchar (36),
line_cost double,
po_id varchar (36),
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE req_item ADD PRIMARY KEY (id)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_requisition ON req_item (req_id, in_id)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_req_item_in ON req_item (in_id)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.05, sql=CREATE INDEX idx_req_item_vendor ON req_item (vendor_id)
2007-08-13 13:31:29,006 DEBUG CalemPdo - query() time:0.0836, sql=CREATE INDEX idx_req_item_po ON req_item (po_id)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.1002, sql=CREATE TABLE req_seq (id int )
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0164, sql=CREATE TABLE req_status_log (id varchar (36),
req_id varchar (36),
from_status_id varchar (36),
to_status_id varchar (36),
from_state_id varchar (36),
to_state_id varchar (36),
changed_by_id varchar (36),
created_time datetime ,
comment text )
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE req_status_log ADD PRIMARY KEY (id)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_req_status_log ON req_status_log (req_id)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_req_status_time ON req_status_log (created_time)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0162, sql=CREATE TABLE sched_shutdown (id varchar (36),
shutdown varchar (30) ,
start_time datetime ,
end_time datetime ,
hours double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE sched_shutdown ADD PRIMARY KEY (id)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0422, sql=CREATE UNIQUE INDEX uidx_sched_shutdown ON sched_shutdown (shutdown)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.05, sql=CREATE INDEX idx_sched_shutdown_start ON sched_shutdown (start_time)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0244, sql=CREATE TABLE sched_user (id varchar (36),
user_id varchar (36),
sched_date date ,
shift_id varchar (36),
total_hours double,
sched_hours double,
hours_sched double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0753, sql=ALTER TABLE sched_user ADD PRIMARY KEY (id)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.1176, sql=CREATE UNIQUE INDEX uidx_sched_user ON sched_user (user_id, sched_date, shift_id)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_sched_user_date ON sched_user (sched_date)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE tax_code (id varchar (36),
tax_code varchar (30) ,
tax_rate_total double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE tax_code ADD PRIMARY KEY (id)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_tax_code ON tax_code (tax_code)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE tax_rate (id varchar (36),
tax_code_id varchar (36),
tax_rate double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE tax_rate ADD PRIMARY KEY (id)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_tax_code ON tax_rate (tax_code_id)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE team (id varchar (36),
team varchar (30) ,
note varchar (76) ,
lead_id varchar (36),
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0423, sql=ALTER TABLE team ADD PRIMARY KEY (id)
2007-08-13 13:31:30,006 DEBUG CalemPdo - query() time:0.0583, sql=CREATE UNIQUE INDEX uidx_team_team ON team (team)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.033, sql=CREATE TABLE training (id varchar (36),
training varchar (50) ,
course_id varchar (36),
instructor_user_id varchar (36),
instructor_contact_id varchar (36),
start_time datetime ,
end_time datetime ,
certificate_id varchar (36),
description text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.1259, sql=ALTER TABLE training ADD PRIMARY KEY (id)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE UNIQUE INDEX uidx_training ON training (training)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_training_course ON training (course_id)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_training_start ON training (start_time)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE training_certificate (id varchar (36),
certificate varchar (30) ,
description text ,
days_valid int ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0419, sql=ALTER TABLE training_certificate ADD PRIMARY KEY (id)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_certificate ON training_certificate (certificate)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE training_course (id varchar (36),
course varchar (30) ,
description text ,
type_id varchar (36),
hours double,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE training_course ADD PRIMARY KEY (id)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.05, sql=CREATE UNIQUE INDEX uidx_course ON training_course (course)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0244, sql=CREATE TABLE training_course_type (id varchar (36),
type varchar (30) ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0835, sql=ALTER TABLE training_course_type ADD PRIMARY KEY (id)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.1091, sql=CREATE UNIQUE INDEX uidx_course_type ON training_course_type (type)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE training_user (id varchar (36),
training_id varchar (36),
user_id varchar (36),
status_id varchar (36),
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE training_user ADD PRIMARY KEY (id)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE INDEX idx_training_user_user ON training_user (user_id)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_training_user_training ON training_user (training_id)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE uom (id varchar (36),
uom varchar (30) ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE uom ADD PRIMARY KEY (id)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_uom ON uom (uom)
2007-08-13 13:31:31,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE uom_map (id varchar (36),
uom_src_id varchar (36),
uom_dst_id varchar (36),
qty double,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.042, sql=ALTER TABLE uom_map ADD PRIMARY KEY (id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0583, sql=CREATE INDEX idx_uom_src ON uom_map (uom_src_id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0834, sql=CREATE INDEX idx_uom_dst ON uom_map (uom_dst_id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.1003, sql=CREATE TABLE users (id varchar (36),
username varchar (30) ,
status_id varchar (36),
password varchar (32) ,
user_type_id varchar (36),
emp_no varchar (30) ,
contractor_id varchar (36),
job_role_id varchar (36),
login_allowed tinyint (1)default '1' ,
full_name varchar (30) ,
job_title varchar (30) ,
note varchar (76) ,
acl_group_id varchar (36),
admin_type_id varchar (36)default 'search_admin_none' ,
team_id varchar (36),
supervisor_id varchar (36),
dept_id varchar (36),
costcode_id varchar (36),
req_approval_id varchar (36),
po_approval_id varchar (36),
craft_id varchar (36),
phone_work varchar (24) ,
phone_home varchar (16) ,
phone_mobile varchar (16) ,
email_work varchar (30) ,
email_other varchar (30) ,
im1_type_id varchar (36),
im1_id varchar (30) ,
im2_type_id varchar (36),
im2_id varchar (30) ,
fax varchar (16) ,
company varchar (30) ,
street1 varchar (50) ,
street2 varchar (50) ,
city varchar (30) ,
state varchar (30) ,
zip varchar (16) ,
country varchar (30) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0422, sql=ALTER TABLE users ADD PRIMARY KEY (id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0419, sql=CREATE UNIQUE INDEX uidx_users_username ON users (username)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0161, sql=CREATE TABLE vendor (id varchar (36),
vendor varchar (30) ,
tax_code_id varchar (36),
note varchar (76) ,
contact_id varchar (36),
address varchar (512) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE vendor ADD PRIMARY KEY (id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0416, sql=CREATE UNIQUE INDEX uidx_vendor ON vendor (vendor)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0162, sql=CREATE TABLE workorder (id varchar (36),
wo_no varchar (30) ,
description text ,
asset_id varchar (36),
pm_id varchar (36),
asset_note varchar (76) ,
category_id varchar (36),
status_id varchar (36),
priority_id varchar (36),
resolution_id varchar (36),
duplicate_wo_id varchar (36),
rcm_action_id varchar (36),
parent_wo_id varchar (36),
origin_id varchar (36),
rework_wo_id varchar (36),
orig_contact_id varchar (36),
orig_user_id varchar (36),
orig_time datetime ,
assigned_team_id varchar (36),
assigned_to_id varchar (36),
assigned_by_id varchar (36),
assigned_time datetime ,
time_needed datetime ,
planned_start_time datetime ,
sched_start_time datetime ,
sched_start_shift_id varchar (36),
actual_start_time datetime ,
actual_start_shift_id varchar (36),
planned_finish_time datetime ,
sched_finish_time datetime ,
sched_finish_shift_id varchar (36),
actual_finish_time datetime ,
actual_finish_shift_id varchar (36),
costcode_id varchar (36),
project_id varchar (36),
dept_id varchar (36),
planned_labor_hours double,
sched_labor_hours double,
actual_labor_hours double,
labor_cost double,
material_cost double,
total_cost double,
planned_downtime_hours double,
actual_downtime_hours double,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.042, sql=ALTER TABLE workorder ADD PRIMARY KEY (id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0503, sql=CREATE UNIQUE INDEX uidx_workorder_wo_no ON workorder (wo_no)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0836, sql=CREATE INDEX idx_wo_sched_completion_time ON workorder (sched_finish_time)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.1177, sql=CREATE INDEX idx_wo_asset ON workorder (asset_id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.042, sql=CREATE INDEX idx_wo_pm ON workorder (pm_id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0421, sql=CREATE INDEX idx_wo_costcode ON workorder (costcode_id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0421, sql=CREATE INDEX idx_wo_orig_user ON workorder (orig_contact_id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0422, sql=CREATE INDEX idx_wo_assigned_to ON workorder (assigned_to_id)
2007-08-13 13:31:32,006 DEBUG CalemPdo - query() time:0.0674, sql=CREATE INDEX idx_wo_assigned_team ON workorder (assigned_team_id)
2007-08-13 13:31:33,006 DEBUG CalemPdo - query() time:0.0327, sql=CREATE TABLE wo_attachment (id varchar (36),
wo_id varchar (36),
file_url varchar (1000) ,
note varchar (76) ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:33,006 DEBUG CalemPdo - query() time:0.1177, sql=ALTER TABLE wo_attachment ADD PRIMARY KEY (id)
2007-08-13 13:31:33,006 DEBUG CalemPdo - query() time:0.0417, sql=CREATE INDEX idx_wo_attachment_wo_id ON wo_attachment (wo_id)
2007-08-13 13:31:33,006 DEBUG CalemPdo - query() time:0.016, sql=CREATE TABLE wo_comment (id varchar (36),
wo_id varchar (36),
comment text ,
modified_time datetime ,
modified_id varchar (36),
created_time datetime ,
created_id varchar (36))
2007-08-13 13:31:33,006 DEBUG CalemPdo - query() time:0.0418, sql=ALTER TABLE wo_comment ADD PRIMARY KEY (id)
2007-08-13 13:31:33,006 DEBUG CalemPdo - query() time:0.0415, sql=CREATE INDEX idx_wo_comment_wo_id ON wo_comment (wo_id)
2007-08-13 13:31:33,006 DEBUG CalemPdo - query() time:0.0418, sql=CREATE INDEX idx_wo_comment_modified_time ON wo_comment (modified_time)
2007-08-13 13:31:33,006 DEB