| Foxmask 2005-03-26, 3:57 pm |
| i think, we have to use table_* when we use multiple base that own the
same table name, if not you can just enter :
[DB_DataObject]
; PEAR::DB DSN
database_hardware = mysql://xxxxxx:xxxxxx@localhost/hardware
database_userdb = mysql://xxxxxx:xxxxxx@localhost/userdb
database_supportdb = mysql://xxxxxx:xxxxxx@localhost/supportdb
schema_location = /srv/www/htdocs/prj/DataObject
class_location = /srv/www/htdocs/prj/DataObject
require_prefix = DataObjects/
class_prefix = DataObjects_
proxy = FULL
dont_die = false
regards.
Ian a écrit :
>I've tried it in the following two ways...........
>
>[DB_DataObject]
>; PEAR::DB DSN
>database_hardware =
>mysql://xxxxxx:xxxxxx@localhost/hardware
>table_hardware_catagory = hardware
>sequence_hardware_catagory = hw_cat_id
>table_hardware_index = hardware
>sequence_hardware_index = hardware_index_id
>table_hardware_models = hardware
>sequence_hardware_models = hardware_model_id
>table_hardware_manufacturer = hardware
>sequence_hardware_manufacturer = manufacturer_id
>
>
>database_userdb =
>mysql://xxxxxx:xxxxxx@localhost/userdb
>table_users = userdb
>sequence_users = user_id
>table_user_locations = userdb
>sequence_user_locations = user_location_id
>table_locations = userdb
>sequence_location_id = location_id
>table_assigned_hardware = userdb
>sequence_assigned_hardware = assigned_hardware_id
>
>
>database_supportdb =
>mysql://xxxxxx:xxxxxx@localhost/supportdb
>table_user_issues = supportdb
>sequence_user_issues = user_issue_id
>table_support_type = supportdb
>sequence_support_type = support_type_id
>table_support_index = supportdb
>sequence_support_index = support_index
>table_module_index = supportdb
>sequence_module_index = modules_id
>table_issue_index = supportdb
>sequence_issue_index = issue_log_id
>
>
>schema_location =
>/srv/www/htdocs/prj/DataObject
>class_location =
>/srv/www/htdocs/prj/DataObject
>require_prefix = DataObjects/
>class_prefix = DataObjects_
>proxy = FULL
>dont_die = false
>
>
> ========================================
===========================
>
>And this way..........
>
>
>[DB_DataObject]
>; PEAR::DB DSN
>database_hardware =
>mysql://xxxxxx:xxxxxx@localhost/hardware
>database_userdb =
>mysql://xxxxxx:xxxxxx@localhost/userdb
>database_supportdb =
>mysql://xxxxxx:xxxxxx@localhost/supportdb
>
>table_hardware_catagory = hardware
>sequence_hardware_catagory = hw_cat_id
>
>table_hardware_index = hardware
>sequence_hardware_index = hardware_index_id
>
>table_hardware_models = hardware
>sequence_hardware_models = hardware_model_id
>
>table_hardware_manufacturer = hardware
>sequence_hardware_manufacturer = manufacturer_id
>
>table_users = userdb
>sequence_users = user_id
>
>table_user_locations = userdb
>sequence_user_locations = user_location_id
>
>table_locations = userdb
>sequence_location_id = location_id
>
>table_assigned_hardware = userdb
>sequence_assigned_hardware = assigned_hardware_id
>
>table_user_issues = supportdb
>sequence_user_issues = user_issue_id
>
>table_support_type = supportdb
>sequence_support_type = support_type_id
>
>table_support_index = supportdb
>sequence_support_index = support_index
>
>table_module_index = supportdb
>sequence_module_index = modules_id
>
>table_issue_index = supportdb
>sequence_issue_index = issue_log_id
>
>schema_location =
>/srv/www/htdocs/prj/DataObject
>class_location =
>/srv/www/htdocs/prj/DataObject
>require_prefix = DataObjects/
>class_prefix = DataObjects_
>proxy = FULL
>
>
>(sorry about the mess!)
>
>
>
>-----Original Message-----
>From: foxmask [mailto:foxmask@gmail.com]
>Sent: 26 March 2005 18:05
>To: Ian
>Subject: Re: [PEAR] More DB_DataObject problems...
>
>what does the ini file look like ?
>
>
>On Sat, 26 Mar 2005 18:05:03 -0000, Ian <zen54565@zen.co.uk> wrote:
>
>
>data
>
>
>
>
>
>
--
|