Author Topic: Installation walkthrough  (Read 13257 times)

jbernard

  • Newbie
  • *
  • Posts: 7
    • http://jnkbernardcomputerservices.no-ip.biz
Installation walkthrough
« on: August 13, 2007, 08:05:19 am »
I currently have the following installed:
Windows 2003 Standard SP1 installed
IIS6
PHP 5.2.3
Mysql 5.0.45
Pear with Soap and XML Serializer

I have edited the env.bat file to match the correct directories.
After running the files to setup the db i get an error:
Unable to find PDO blah blah

It installed the DB and Load default just fine. So i continue and run the Deploy.bat file. Log into to web browser and after typing in the admin admin_password it tries to roll to a https url. I do not have ssl enabled. nor do i want it since this will be running inside the network and the demo i tested did not roll to a secure http.

I have CalemEAM Beta r1.0.2 downloaded
Any ehlp would be appreciated

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Installation walkthrough
« Reply #1 on: August 13, 2007, 10:21:14 am »
It's not clear to me what was the problem.

Take a look at logs. It might tell us more.
- php error logs
- calem logs (under CalemEAM/logs/calem.log)
Calem Community Forum Admin

jbernard

  • Newbie
  • *
  • Posts: 7
    • http://jnkbernardcomputerservices.no-ip.biz
Help
« Reply #2 on: August 13, 2007, 12:52:18 pm »
Since the last posting i have redone my server. Not to worry it is in a VM so i had to revert back to a snapshot before i installed php and made sure i had everything sertup correctly. ok here is the break down of what i have done:
1. Installed php 5.2.3 to c:\php with following extension:imagick,imap,java,mysql,mysqli,pdflib,pdo->mysql,soap,stats,timezonedb,upload progress,win32ps, win32schedule, win32service,zip and zlib
2. under extras added pear and the php manual
3. ran go-pear and install soap and XML Serializer - installed ok
4. added the isapi module to IIS web site under ISAPI filters
5. changed php to limit GET,POST,HEAD
6. created a phpinfo.php file and loaded followinginto it: <?php phpinfo(); <?> tested just fine
7.edited the php.ini file in c:\php and changed following values
error_log c:\phplog.txt
include_path = .;c:\php\include;c:\php\pear
uploadtemp = c:\php\uploadtemp
sessiondata = c:\php\sessiondata
uploadmax = 8m from 2m
uncommented following extensions:
php_mysql
php_mysqli
php_pdo.dll
php_pdo.mysql.dll
php_soap.dll
php_xmlrpc.dll
8. Downloaded CalemEAM and dropped into c:\inetpub\wwwroot
9. went through the steps in the setup guide and when i get to the login screen i do not see any grapic like i do for the demo and when i tr and log in it sends me to an http://mwintranet/calemeam/index.php page. I can send you my logs because i havnt a clue how to read them.

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Installation walkthrough
« Reply #3 on: August 13, 2007, 01:26:39 pm »
It looks like you're using PHP with IIS. I saw some tips on http://www.php.net/install.windows about making PHP working with IIS.

Would it make sense for you to use WAMP install to have CalemEAM installed and working before you try it with IIS?
Calem Community Forum Admin

jbernard

  • Newbie
  • *
  • Posts: 7
    • http://jnkbernardcomputerservices.no-ip.biz
WAMP
« Reply #4 on: August 13, 2007, 02:03:37 pm »
I have just finished installing b2evolution without a hitch so i know my iis and php are correct along with mysql. Whant is in the deploy file that would cause it to switch from http to https?

Also i have never used WAMP. I know this works cause i run same setup at home : http://johnandkatie.no-ip.info

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Installation walkthrough
« Reply #5 on: August 13, 2007, 02:23:58 pm »
I don't know why it switches to https. Send me the logs I might see something.

BTW, your home site looks great!
Calem Community Forum Admin

jbernard

  • Newbie
  • *
  • Posts: 7
    • http://jnkbernardcomputerservices.no-ip.biz
phpinfo file
« Reply #6 on: August 14, 2007, 02:41:46 pm »
[13-Aug-2007 13:28:45] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_xmlrpc.dll' - The specified module could not be found.
 in Unknown on line 0
[13-Aug-2007 13:28:45] PHP Warning:  Module 'mysql' already loaded in Unknown on line 0
[13-Aug-2007 13:28:45] PHP Warning:  Module 'mysqli' already loaded in Unknown on line 0
[13-Aug-2007 13:28:45] PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
[13-Aug-2007 13:28:45] PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
[13-Aug-2007 13:28:45] PHP Warning:  Module 'soap' already loaded in Unknown on line 0
[13-Aug-2007 13:31:17] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_xmlrpc.dll' - The specified module could not be found.
 in Unknown on line 0
[13-Aug-2007 13:31:17] PHP Warning:  Module 'mysql' already loaded in Unknown on line 0
[13-Aug-2007 13:31:17] PHP Warning:  Module 'mysqli' already loaded in Unknown on line 0
[13-Aug-2007 13:31:17] PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
[13-Aug-2007 13:31:17] PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
[13-Aug-2007 13:31:17] PHP Warning:  Module 'soap' already loaded in Unknown on line 0
[13-Aug-2007 13:31:17] PHP Notice:  Use of undefined constant CUSTOM_SYSTEM - assumed 'CUSTOM_SYSTEM' in C:\Inetpub\wwwroot\CalemEAM\server\conf\calem.php on line 257
[13-Aug-2007 13:31:17] PHP Notice:  Only variable references should be returned by reference in C:\Inetpub\wwwroot\CalemEAM\server\include\log4php\LoggerAppender.php on line 73
[13-Aug-2007 13:31:17] PHP Notice:  Only variable references should be returned by reference in C:\Inetpub\wwwroot\CalemEAM\server\include\log4php\LoggerPropertyConfigurator.php on line 565
[13-Aug-2007 13:32:10] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_xmlrpc.dll' - The specified module could not be found.
 in Unknown on line 0
[13-Aug-2007 13:32:10] PHP Warning:  Module 'mysql' already loaded in Unknown on line 0
[13-Aug-2007 13:32:10] PHP Warning:  Module 'mysqli' already loaded in Unknown on line 0
[13-Aug-2007 13:32:10] PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
[13-Aug-2007 13:32:10] PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
[13-Aug-2007 13:32:10] PHP Warning:  Module 'soap' already loaded in Unknown on line 0
[13-Aug-2007 13:32:10] PHP Notice:  Use of undefined constant CUSTOM_SYSTEM - assumed 'CUSTOM_SYSTEM' in C:\Inetpub\wwwroot\CalemEAM\server\conf\calem.php on line 257
[13-Aug-2007 13:32:10] PHP Notice:  Only variable references should be returned by reference in C:\Inetpub\wwwroot\CalemEAM\server\include\log4php\LoggerAppender.php on line 73
[13-Aug-2007 13:32:10] PHP Notice:  Only variable references should be returned by reference in C:\Inetpub\wwwroot\CalemEAM\server\include\log4php\LoggerPropertyConfigurator.php on line 565
[13-Aug-2007 13:32:21] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_xmlrpc.dll' - The specified module could not be found.
 in Unknown on line 0
[13-Aug-2007 13:32:21] PHP Warning:  Module 'mysql' already loaded in Unknown on line 0
[13-Aug-2007 13:32:21] PHP Warning:  Module 'mysqli' already loaded in Unknown on line 0
[13-Aug-2007 13:32:21] PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
[13-Aug-2007 13:32:21] PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
[13-Aug-2007 13:32:21] PHP Warning:  Module 'soap' already loaded in Unknown on line 0
[13-Aug-2007 13:32:22] PHP Notice:  Use of undefined constant CUSTOM_SYSTEM - assumed 'CUSTOM_SYSTEM' in C:\Inetpub\wwwroot\CalemEAM\server\conf\calem.php on line 257
[13-Aug-2007 13:32:22] PHP Notice:  Only variable references should be returned by reference in C:\Inetpub\wwwroot\CalemEAM\server\include\log4php\LoggerAppender.php on line 73
[13-Aug-2007 13:32:22] PHP Notice:  Only variable references should be returned by reference in C:\Inetpub\wwwroot\CalemEAM\server\include\log4php\LoggerPropertyConfigurator.php on line 565
[13-Aug-2007 13:32:47] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_xmlrpc.dll' - The specified module could not be found.
 in Unknown on line 0
[13-Aug-2007 13:32:47] PHP Warning:  Module 'mysql' already loaded in Unknown on line 0
[13-Aug-2007 13:32:47] PHP Warning:  Module 'mysqli' already loaded in Unknown on line 0
[13-Aug-2007 13:32:47] PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
[13-Aug-2007 13:32:47] PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
[13-Aug-2007 13:32:47] PHP Warning:  Module 'soap' already loaded in Unknown on line 0
[13-Aug-2007 13:32:47] PHP Notice:  Only variable references should be returned by reference in C:\Inetpub\wwwroot\CalemEAM\server\include\log4php\LoggerAppender.php on line 73
[13-Aug-2007 13:32:47] PHP Notice:  Only variable references should be returned by reference in C:\Inetpub\wwwroot\CalemEAM\server\include\log4php\LoggerPropertyConfigurator.php on line 565
[13-Aug-2007 13:32:47] PHP Notice:  Use of undefined constant CUSTOM_SYSTEM - assumed 'CUSTOM_SYSTEM' in C:\Inetpub\wwwroot\CalemEAM\server\conf\calem.php on line 257

jbernard

  • Newbie
  • *
  • Posts: 7
    • http://jnkbernardcomputerservices.no-ip.biz
calem log
« Reply #7 on: August 14, 2007, 02:42:57 pm »
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

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Installation walkthrough
« Reply #8 on: August 14, 2007, 03:34:32 pm »
Based on the logs the database creation looks good. You may upload the calem log files or email them to calemadmin.
Calem Community Forum Admin

jbernard

  • Newbie
  • *
  • Posts: 7
    • http://jnkbernardcomputerservices.no-ip.biz
Caleam Log
« Reply #9 on: August 15, 2007, 06:56:01 am »
is there another log file i shoudl be aware of? Ive pasted them both. not sure what else i need to do.

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Installation walkthrough
« Reply #10 on: August 15, 2007, 10:01:09 am »
So far both logs look good. calem.log was cut off. You may paste the later portions of calem log again.
Calem Community Forum Admin

jbernard

  • Newbie
  • *
  • Posts: 7
    • http://jnkbernardcomputerservices.no-ip.biz
Calem Log file
« Reply #11 on: August 15, 2007, 10:10:36 am »
Ill email the file. There is allot there

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Installation walkthrough
« Reply #12 on: August 15, 2007, 11:19:04 am »
You may email the logs to forum.admin@calemeam.com
Calem Community Forum Admin