[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: cdb/setup tables_baseline.inc.php,NONE,1.1 table
From: |
Brian Morel <address@hidden> |
Subject: |
[Phpgroupware-cvs] CVS: cdb/setup tables_baseline.inc.php,NONE,1.1 tables_current.inc.php,1.1,1.2 setup.inc.php,1.3,1.4 |
Date: |
Wed, 20 Feb 2002 17:14:38 -0500 |
Update of /cvsroot/phpgroupware/cdb/setup
In directory subversions:/tmp/cvs-serv5133
Modified Files:
tables_current.inc.php setup.inc.php
Added Files:
tables_baseline.inc.php
Log Message:
update for new database setup
***** Error reading new file: [Errno 2] No such file or directory:
'tables_baseline.inc.php'
Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/cdb/setup/tables_current.inc.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** tables_current.inc.php 25 Aug 2001 09:47:56 -0000 1.1
--- tables_current.inc.php 20 Feb 2002 22:14:35 -0000 1.2
***************
*** 45,63 ****
'phone8_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0')
),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
! 'uc' => array('contact_id')
),
'phpgw_cdb_contact_phone' => array(
'fd' => array(
'contact_phone_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
! 'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone_category_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'number' => array('type' => 'char', 'precision'
=> 100,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
! 'ix' => array(),
'uc' => array()
),
--- 45,74 ----
'phone8_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0')
),
! 'pk' => array('contact_id'),
'fk' => array(),
'ix' => array(),
! 'uc' => array()
! ),
! 'phpgw_cdb_entity_id' => array(
! 'fd' => array(
! 'entity_id' => array('type' => 'auto'),
! 'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
! 'organization_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
! ),
! 'pk' => array('entity_id'),
! 'fk' => array(),
! 'ix' => array('contact_id', 'organization_id'),
! 'uc' => array()
),
'phpgw_cdb_contact_phone' => array(
'fd' => array(
'contact_phone_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
! 'entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone_category_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'number' => array('type' => 'char', 'precision'
=> 100,'nullable' => False)
),
! 'pk' => array('contact_phone_id'),
'fk' => array(),
! 'ix' => array('entity_id', 'phone_category_id'),
'uc' => array()
),
***************
*** 67,74 ****
'phone_category_name' => array('type' =>
'char', 'precision' => 20,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
! 'uc' => array('phone_category_id')
),
'phpgw_cdb_org' => array(
--- 78,85 ----
'phone_category_name' => array('type' =>
'char', 'precision' => 20,'nullable' => False)
),
! 'pk' => array('phone_category_id'),
'fk' => array(),
'ix' => array(),
! 'uc' => array()
),
'phpgw_cdb_org' => array(
***************
*** 78,87 ****
'organization_home_page' => array('type' =>
'text','nullable' => False),
'organization_network_name' => array('type' =>
'varchar', 'precision' => 100,'nullable' => False),
! 'organization_org_id_num' => array('type' =>
'varchar', 'precision' => 20,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
! 'uc' => array('organization_id')
),
'phpgw_cdb_org_location' => array(
--- 89,98 ----
'organization_home_page' => array('type' =>
'text','nullable' => False),
'organization_network_name' => array('type' =>
'varchar', 'precision' => 100,'nullable' => False),
! 'organization_gov_id_num' => array('type' =>
'varchar', 'precision' => 20,'nullable' => False)
),
! 'pk' => array('organization_id'),
'fk' => array(),
'ix' => array(),
! 'uc' => array()
),
'phpgw_cdb_org_location' => array(
***************
*** 98,102 ****
'pk' => array(),
'fk' => array(),
! 'ix' => array(),
'uc' => array('location_id')
),
--- 109,113 ----
'pk' => array(),
'fk' => array(),
! 'ix' => array('organization_id'),
'uc' => array('location_id')
),
***************
*** 109,141 ****
'referred_by' => array('type' =>
'text','nullable' => False)
),
! 'pk' => array(),
! 'fk' => array(),
! 'ix' => array(),
! 'uc' => array()
! ),
! 'phpgw_cdb_org_meta' => array(
! 'fd' => array(
! 'organization_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
! 'status' => array('type' => 'char', 'precision'
=> 16,'nullable' => False,'default' => 'pending'),
! 'created' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
! 'modified' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
! 'file_as' => array('type' => 'varchar',
'precision' => 50,'nullable' => False),
! 'followup_status' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
! 'created_by' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
! 'keywords' => array('type' => 'text','nullable'
=> False),
! 'group_access' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
! 'version' => array('type' => 'float',
'precision' => 4,'nullable' => False)
! ),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'phpgw_cdb_org_notes' => array(
'fd' => array(
! 'organization_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'note' => array('type' => 'text','nullable' =>
False)
),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
--- 120,134 ----
'referred_by' => array('type' =>
'text','nullable' => False)
),
! 'pk' => array('organization_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'phpgw_cdb_entity_notes' => array(
'fd' => array(
! 'entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'note' => array('type' => 'text','nullable' =>
False)
),
! 'pk' => array('entity_id'),
'fk' => array(),
'ix' => array(),
***************
*** 154,168 ****
'manager_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False)
),
! 'pk' => array(),
! 'fk' => array(),
! 'ix' => array(),
! 'uc' => array()
! ),
! 'phpgw_cdb_contact_notes' => array(
! 'fd' => array(
! 'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
! 'note' => array('type' => 'text','nullable' =>
False)
! ),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
--- 147,151 ----
'manager_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False)
),
! 'pk' => array('organization_link_id'),
'fk' => array(),
'ix' => array(),
***************
*** 177,181 ****
'referred_by' => array('type' =>
'text','nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
--- 160,164 ----
'referred_by' => array('type' =>
'text','nullable' => False)
),
! 'pk' => array('contact_id'),
'fk' => array(),
'ix' => array(),
***************
*** 194,198 ****
'anniversary' => array('type' => 'int',
'precision' => 4,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
--- 177,181 ----
'anniversary' => array('type' => 'int',
'precision' => 4,'nullable' => False)
),
! 'pk' => array('contact_id'),
'fk' => array(),
'ix' => array(),
***************
*** 205,212 ****
'language_code' => array('type' => 'char',
'precision' => 10,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
! 'ix' => array(),
! 'uc' => array('language_id')
),
'phpgw_cdb_category' => array(
--- 188,195 ----
'language_code' => array('type' => 'char',
'precision' => 10,'nullable' => False)
),
! 'pk' => array('language_id'),
'fk' => array(),
! 'ix' => array('language_code'),
! 'uc' => array('language_name')
),
'phpgw_cdb_category' => array(
***************
*** 215,222 ****
'name' => array('type' => 'char', 'precision'
=> 40,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
! 'uc' => array()
),
'phpgw_cdb_category_link' => array(
--- 198,205 ----
'name' => array('type' => 'char', 'precision'
=> 40,'nullable' => False)
),
! 'pk' => array('category_id'),
'fk' => array(),
'ix' => array(),
! 'uc' => array('name')
),
'phpgw_cdb_category_link' => array(
***************
*** 227,238 ****
'contact_type' => array('type' => 'char',
'precision' => 32,'nullable' => False,'default' => 'individual')
),
! 'pk' => array(),
'fk' => array(),
! 'ix' => array(),
'uc' => array()
),
! 'phpgw_cdb_contact_meta' => array(
'fd' => array(
! 'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'status' => array('type' => 'char', 'precision'
=> 16,'nullable' => False,'default' => 'pending'),
'created' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
--- 210,221 ----
'contact_type' => array('type' => 'char',
'precision' => 32,'nullable' => False,'default' => 'individual')
),
! 'pk' => array('category_link_id'),
'fk' => array(),
! 'ix' => array('entity_id', 'category_id',
'contact_type'),
'uc' => array()
),
! 'phpgw_cdb_entity_meta' => array(
'fd' => array(
! 'entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'status' => array('type' => 'char', 'precision'
=> 16,'nullable' => False,'default' => 'pending'),
'created' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
***************
*** 247,253 ****
'ldap_dn' => array('type' => 'varchar',
'precision' => 100,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
! 'ix' => array(),
'uc' => array()
),
--- 230,236 ----
'ldap_dn' => array('type' => 'varchar',
'precision' => 100,'nullable' => False)
),
! 'pk' => array('entity_id'),
'fk' => array(),
! 'ix' => array('file_as'),
'uc' => array()
),
***************
*** 259,266 ****
'flag_color' => array('type' => 'char',
'precision' => 6,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
! 'ix' => array(),
! 'uc' => array('flag_id')
),
'phpgw_cdb_contact_flag_link' => array(
--- 242,249 ----
'flag_color' => array('type' => 'char',
'precision' => 6,'nullable' => False)
),
! 'pk' => array('flag_id'),
'fk' => array(),
! 'ix' => array('user_id'),
! 'uc' => array()
),
'phpgw_cdb_contact_flag_link' => array(
***************
*** 271,278 ****
'flag_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0')
),
! 'pk' => array(),
'fk' => array(),
! 'ix' => array(),
! 'uc' => array('flag_link_id')
),
'phpgw_cdb_contact_followup' => array(
--- 254,261 ----
'flag_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0')
),
! 'pk' => array('flag_link_id'),
'fk' => array(),
! 'ix' => array('user_id', 'contact_id'),
! 'uc' => array()
),
'phpgw_cdb_contact_followup' => array(
***************
*** 282,289 ****
'followup_color' => array('type' => 'char',
'precision' => 6,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
! 'uc' => array('followup_id')
),
'phpgw_cdb_contact_internet' => array(
--- 265,272 ----
'followup_color' => array('type' => 'char',
'precision' => 6,'nullable' => False)
),
! 'pk' => array('followup_id'),
'fk' => array(),
'ix' => array(),
! 'uc' => array()
),
'phpgw_cdb_contact_internet' => array(
***************
*** 304,308 ****
'icq' => array('type' => 'char', 'precision' =>
20,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
--- 287,291 ----
'icq' => array('type' => 'char', 'precision' =>
20,'nullable' => False)
),
! 'pk' => array('contact_id'),
'fk' => array(),
'ix' => array(),
***************
*** 314,326 ****
'address_category_name' => array('type' =>
'char', 'precision' => 20,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
'ix' => array(),
! 'uc' => array('address_category_id')
),
'phpgw_cdb_contact_addr' => array(
'fd' => array(
'contact_address_id' => array('type' => 'auto'),
! 'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'address_category_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'address_city' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
--- 297,309 ----
'address_category_name' => array('type' =>
'char', 'precision' => 20,'nullable' => False)
),
! 'pk' => array('address_category_id'),
'fk' => array(),
'ix' => array(),
! 'uc' => array()
),
'phpgw_cdb_contact_addr' => array(
'fd' => array(
'contact_address_id' => array('type' => 'auto'),
! 'entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'address_category_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'address_city' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
***************
*** 329,336 ****
'address_street' => array('type' => 'varchar',
'precision' => 255,'nullable' => False)
),
! 'pk' => array(),
'fk' => array(),
! 'ix' => array(),
! 'uc' => array('contact_address_id')
)
);
--- 312,319 ----
'address_street' => array('type' => 'varchar',
'precision' => 255,'nullable' => False)
),
! 'pk' => array('contact_address_id'),
'fk' => array(),
! 'ix' => array('contact_id', 'address_category_id'),
! 'uc' => array()
)
);
Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/cdb/setup/setup.inc.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** setup.inc.php 13 Jan 2002 20:12:24 -0000 1.3
--- setup.inc.php 20 Feb 2002 22:14:35 -0000 1.4
***************
*** 15,19 ****
$setup_info['cdb']['name'] = 'cdb';
$setup_info['cdb']['title'] = 'CDB';
! $setup_info['cdb']['version'] = '0.9.13.002';
$setup_info['cdb']['app_order'] = 4;
$setup_info['cdb']['enable'] = 1;
--- 15,19 ----
$setup_info['cdb']['name'] = 'cdb';
$setup_info['cdb']['title'] = 'CDB';
! $setup_info['cdb']['version'] = '0.9.13.003';
$setup_info['cdb']['app_order'] = 4;
$setup_info['cdb']['enable'] = 1;
***************
*** 22,25 ****
--- 22,26 ----
$setup_info['cdb']['tables'] = array(
+ 'phpgw_cdb_entity_id',
'phpgw_cdb_contact_main',
'phpgw_cdb_contact_phone',
***************
*** 28,35 ****
'phpgw_cdb_org_location',
'phpgw_cdb_org_client',
! 'phpgw_cdb_org_meta',
! 'phpgw_cdb_org_notes',
'phpgw_cdb_contact_org',
- 'phpgw_cdb_contact_notes',
'phpgw_cdb_contact_client',
'phpgw_cdb_contact_personal',
--- 29,34 ----
'phpgw_cdb_org_location',
'phpgw_cdb_org_client',
! 'phpgw_cdb_entity_notes',
'phpgw_cdb_contact_org',
'phpgw_cdb_contact_client',
'phpgw_cdb_contact_personal',
***************
*** 37,41 ****
'phpgw_cdb_category',
'phpgw_cdb_category_link',
! 'phpgw_cdb_contact_meta',
'phpgw_cdb_contact_flag',
'phpgw_cdb_contact_flag_link',
--- 36,40 ----
'phpgw_cdb_category',
'phpgw_cdb_category_link',
! 'phpgw_cdb_entity_meta',
'phpgw_cdb_contact_flag',
'phpgw_cdb_contact_flag_link',
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: cdb/setup tables_baseline.inc.php,NONE,1.1 tables_current.inc.php,1.1,1.2 setup.inc.php,1.3,1.4,
Brian Morel <address@hidden> <=
- Prev by Date:
[Phpgroupware-cvs] CVS: cdb/inc class.cdb_phone.inc.php,1.5,1.6 class.cdb_organization_location.inc.php,1.3,1.4 class.cdb_organization_client.inc.php,1.1,1.2 class.cdb_organization.inc.php,1.1,1.2 class.cdb_generic.inc.php,1.4,1.5 class.cdb_entity_meta.inc.php,1.2,1.3 class.cdb_entity.inc.php,1.5,1.6 class.cdb_contact_phone.inc.php,1.3,1.4 class.cdb_contact_personal.inc.php,1.5,1.6 class.cdb_contact_internet.inc.php,1.1,1.2 class.cdb_contact_client.inc.php,1.1,1.2 class.cdb_contact_address.inc.php,1.2,1.3 class.cdb_contact.inc.php,1.6,1.7 class.cdb_address.inc.php,1.2,1.3
- Next by Date:
[Phpgroupware-cvs] CVS: cdb/setup default_records.inc.php,NONE,1.1
- Previous by thread:
[Phpgroupware-cvs] CVS: cdb/inc class.cdb_phone.inc.php,1.5,1.6 class.cdb_organization_location.inc.php,1.3,1.4 class.cdb_organization_client.inc.php,1.1,1.2 class.cdb_organization.inc.php,1.1,1.2 class.cdb_generic.inc.php,1.4,1.5 class.cdb_entity_meta.inc.php,1.2,1.3 class.cdb_entity.inc.php,1.5,1.6 class.cdb_contact_phone.inc.php,1.3,1.4 class.cdb_contact_personal.inc.php,1.5,1.6 class.cdb_contact_internet.inc.php,1.1,1.2 class.cdb_contact_client.inc.php,1.1,1.2 class.cdb_contact_address.inc.php,1.2,1.3 class.cdb_contact.inc.php,1.6,1.7 class.cdb_address.inc.php,1.2,1.3
- Next by thread:
[Phpgroupware-cvs] CVS: cdb/setup default_records.inc.php,NONE,1.1
- Index(es):