[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.
|
From: |
skwashd |
|
Subject: |
[Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1 |
|
Date: |
Thu, 5 May 2005 02:56:00 +0200 |
Update of old/cdb/setup
Added Files:
Branch: MAIN
phpgw_en.lang
default_records.inc.php
phpgw_fr.lang
setup.inc.php
tables_update.inc.php
tables_current.inc.php
tables_baseline.inc.php
Log Message:
cvs clean up
====================================================
Index: phpgw_en.lang
cdb common en CDB
changes saved. cdb en Changes saved.
contact database common en Contact Database
no changes saved. cdb en No changes saved.
====================================================
Index: default_records.inc.php
<?php
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (1,'Business Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (2,'Business Phone2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (3,'Business Pager')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (4,'Business Fax')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (5,'Home Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (6,'Home Phone2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (7,'Home Pager')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (8,'Home Fax')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (9,'Other Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (10,'Other Pager')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (11,'Other Fax')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (12,'Call Back')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (13,'Car Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (14,'ISDN')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (15,'Mobile Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (16,'Primary Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (17,'Radio Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (18,'Telex')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (19,'TTY/TDD Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (20,'Family Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (21,'Vacation Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (22,'School Phone')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat
(phone_category_id, phone_category_name) VALUES (23,'Answering Service')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_followup
(followup_id, followup_name, followup_color) VALUES (1,'Follow Up',
'FF2222')"); //red
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_followup
(followup_id, followup_name, followup_color) VALUES (2,'For Your Information',
'6699cc')"); //blue
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_followup
(followup_id, followup_name, followup_color) VALUES (3,'Review', '83d8a4')");
//green
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_followup
(followup_id, followup_name, followup_color) VALUES (4,'Call', 'cccc99')");
//gold
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_followup
(followup_id, followup_name, followup_color) VALUES (5,'Arrange Meeting',
'CC99CC')"); //purple
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_followup
(followup_id, followup_name, followup_color) VALUES (6,'Send E-mail',
'FF9966')"); //orange
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_followup
(followup_id, followup_name, followup_color) VALUES (7,'Send Letter',
'FFFF33')"); //yellow
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_addr_cat
(address_category_id, address_category_name) VALUES (1,'Business Address')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_addr_cat
(address_category_id, address_category_name) VALUES (2,'Home Address')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_addr_cat
(address_category_id, address_category_name) VALUES (3,'Other Address')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_addr_cat
(address_category_id, address_category_name) VALUES (4,'Family Address')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cdb_contact_addr_cat
(address_category_id, address_category_name) VALUES (5,'Vacation Address')");
====================================================
Index: phpgw_fr.lang
cdb common fr CDB
changes saved. cdb fr Modifications enregistrées.
contact database common fr Base de données de contacts
no changes saved. cdb fr Aucune modification enregistrée.
====================================================
Index: setup.inc.php
<?php
/**************************************************************************\
* phpGroupWare - Contact DataBase
*
* http://www.phpgroupware.org
*
* --------------------------------------------
*
* This program is free software; you can redistribute it and/or modify
it *
* under the terms of the GNU General Public License as published by
the *
* Free Software Foundation; either version 2 of the License, or (at
your *
* option) any later version.
*
\**************************************************************************/
/* $Id: setup.inc.php,v 1.1 2005/05/05 00:56:39 skwashd Exp $ */
/* Basic information about this app */
$setup_info['cdb']['name'] = 'cdb';
$setup_info['cdb']['version'] = '0.9.13.004';
$setup_info['cdb']['app_order'] = 4;
$setup_info['cdb']['enable'] = 1;
$setup_info['cdb']['author'] = 'Patrick Walsh';
$setup_info['cdb']['note'] = 'THIS APP IS NOT YET WORKING';
$setup_info['cdb']['license'] = 'GPL';
$setup_info['cdb']['description'] =
'Contact DataBase management system.';
$setup_info['cdb']['maintainer'] = 'Patrick Walsh';
$setup_info['cdb']['maintainer_email'] = 'address@hidden';
$setup_info['cdb']['tables'] = array(
'phpgw_cdb_entity_id',
'phpgw_cdb_contact_main',
'phpgw_cdb_contact_phone',
'phpgw_cdb_contact_phone_cat',
'phpgw_cdb_org',
'phpgw_cdb_org_location',
'phpgw_cdb_org_client',
'phpgw_cdb_entity_notes',
'phpgw_cdb_contact_org',
'phpgw_cdb_contact_client',
'phpgw_cdb_contact_personal',
'phpgw_cdb_language',
'phpgw_cdb_category',
'phpgw_cdb_category_link',
'phpgw_cdb_entity_meta',
'phpgw_cdb_contact_flag',
'phpgw_cdb_contact_flag_link',
'phpgw_cdb_contact_followup',
'phpgw_cdb_contact_internet',
'phpgw_cdb_contact_addr_cat',
'phpgw_cdb_contact_addr',
'phpgw_cdb_views',
'phpgw_cdb_recent'
);
/* The hooks this app includes, needed for hooks registration */
$setup_info['cdb']['hooks'][] = 'admin';
$setup_info['cdb']['hooks'][] = 'preferences';
/* Dependencies for this app to work */
$setup_info['cdb']['depends'][] = array(
'appname' => 'phpgwapi',
'versions' => Array('0.9.13', '0.9.14','0.9.15')
);
?>
====================================================
Index: tables_update.inc.php
<?php
/**************************************************************************\
* phpGroupWare - Setup *
* http://www.phpgroupware.org *
* -------------------------------------------- *
* This program is free software; you can redistribute it and/or modify it *
* under the terms of the GNU General Public License as published by the *
* Free Software Foundation; either version 2 of the License, or (at your *
* option) any later version. *
\**************************************************************************/
/* $Id: tables_update.inc.php,v 1.1 2005/05/05 00:56:39 skwashd Exp $ */
$test[] = '0.9.13.002';
function cdb_upgrade0_9_13_002()
{
$GLOBALS['phpgw_setup']->oProc->CreateTable('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()
)
);
$GLOBALS['phpgw_setup']->oProc->CreateTable('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(),
'uc' => array()
)
);
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_cdb_contact_notes');
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_cdb_org_notes');
$GLOBALS['phpgw_setup']->oProc->CreateTable('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'),
'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),
'ldap_sync' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'ldap_dn' => array('type' => 'varchar',
'precision' => 100,'nullable' => False)
),
'pk' => array('entity_id'),
'fk' => array(),
'ix' => array('file_as'),
'uc' => array()
)
);
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_cdb_contact_meta');
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_cdb_org_meta');
$GLOBALS['phpgw_setup']->oProc->RenameColumn('phpgw_cdb_contact_phone',
'contact_id', 'entity_id');
$GLOBALS['phpgw_setup']->oProc->RenameColumn('phpgw_cdb_org',
'organization_org_id', 'organization_gov_id');
$GLOBALS['phpgw_setup']->oProc->RenameColumn('phpgw_cdb_contact_addr',
'contact_id', 'entity_id');
$GLOBALS['setup_info']['cdb']['currentver'] = '0.9.13.003';
return $GLOBALS['setup_info']['cdb']['currentver'];
}
$test[] = '0.9.13.003';
function cdb_upgrade0_9_13_003()
{
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_cdb_views',
array(
'fd' => array(
'view_id' => array('type' => 'auto'),
'cache_date' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'owner' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'group_owner' => array('type' =>
'varchar', 'precision' => 255,'nullable' => False),
'view_public' => array('type' =>
'char', 'precision' => 32,'nullable' => False),
'name' => array('type' => 'varchar',
'precision' => 30,'nullable' => False),
'type' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'view_fields' => array('type' =>
'varchar', 'precision' => 255,'nullable' => False),
'view_filter' => array('type' =>
'text','nullable' => False, 'default' => ''),
'sort' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
'view_group' => array('type' =>
'varchar', 'precision' => 100,'nullable' => False)
),
'pk' => array('view_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
)
);
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_cdb_recent',
array(
'fd' => array(
'account_id' => array('type' => 'auto'),
'orgs' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'contacts' => array('type' =>
'varchar', 'precision' => 20,'nullable' => False),
'views' => array('type' => 'varchar',
'precision' => 20,'nullable' => False)
),
'pk' => array('account_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
)
);
$newtbldef = array(
'fd' => array(
'category_link_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'category_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0')
),
'pk' => array('category_link_id'),
'fk' => array(),
'ix' => array('entity_id', 'category_id',
'contact_type'),
'uc' => array()
);
$GLOBALS['phpgw_setup']->oProc->DropColumn('phpgw_cdb_category_link',
$newtbldef, 'contact_type');
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cdb_org',
'main_location', array('type' => 'int', 'precision' => 4,'nullable' => False) );
$GLOBALS['setup_info']['cdb']['currentver'] = '0.9.13.003';
return $GLOBALS['setup_info']['cdb']['currentver'];
}
?>
====================================================
Index: tables_current.inc.php
<?php
/**************************************************************************\
* phpGroupWare - Setup *
* http://www.phpgroupware.org *
* -------------------------------------------- *
* This program is free software; you can redistribute it and/or modify it *
* under the terms of the GNU General Public License as published by the *
* Free Software Foundation; either version 2 of the License, or (at your *
* option) any later version. *
\**************************************************************************/
/***************************************************************************\
* This file should be generated for you. It should rarely be edited by hand *
\***************************************************************************/
/* $Id: tables_current.inc.php,v 1.1 2005/05/05 00:56:39 skwashd Exp $ */
/* table array for cdb */
/* TODO - Adjust classes to match shorter table names (due to 32 char limit
in Pgsql) */
$phpgw_baseline = array(
'phpgw_cdb_contact_main' => array(
'fd' => array(
'contact_id' => array('type' => 'auto'),
'main_organization_location_sele' =>
array('type' => 'int', 'precision' => 4,'nullable' => False,'default' => '0'),
'first_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'middle_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'last_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'last_name_prefix' => array('type' =>
'varchar', 'precision' => 10,'nullable' => False),
'initials' => array('type' => 'char',
'precision' => 6,'nullable' => False),
'location' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'nickname' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'profession' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'suffix' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'title' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'email_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'web_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'mailing_address_selector' => array('type' =>
'int', 'precision' => 4,'nullable' => False,'default' => '0'),
'phone1_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone2_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone3_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone4_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone5_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone6_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone7_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'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()
),
'phpgw_cdb_contact_phone_cat' => array(
'fd' => array(
'phone_category_id' => array('type' => 'auto'),
'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(
'fd' => array(
'organization_id' => array('type' => 'auto'),
'organization_name' => array('type' =>
'varchar', 'precision' => 100,'nullable' => False),
'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),
'main_location' => array('type' => 'int',
'precision' => 4,'nullable' => False)
),
'pk' => array('organization_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_org_location' => array(
'fd' => array(
'location_id' => array('type' => 'auto'),
'organization_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'location' => array('type' => 'text','nullable'
=> False),
'address_city' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'address_country' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'postal_code' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'address_street' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'number' => array('type' => 'varchar',
'precision' => 100,'nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array('organization_id'),
'uc' => array('location_id')
),
'phpgw_cdb_org_client' => array(
'fd' => array(
'organization_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'account' => array('type' => 'text','nullable'
=> False),
'billing_info' => array('type' =>
'text','nullable' => False),
'customer_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'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(),
'uc' => array()
),
'phpgw_cdb_contact_org' => array(
'fd' => array(
'organization_link_id' => array('type' =>
'int', 'precision' => 4,'nullable' => False,'default' => '0'),
'organization_location_id' => array('type' =>
'int', 'precision' => 4,'nullable' => False,'default' => '0'),
'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'assistant_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'assistant_phone' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
'assistant_email' => array('type' => 'varchar',
'precision' => 50,'nullable' => False),
'department' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'job_title' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'manager_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False)
),
'pk' => array('organization_link_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_contact_client' => array(
'fd' => array(
'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'account' => array('type' => 'text','nullable'
=> False),
'billing_info' => array('type' =>
'text','nullable' => False),
'customer_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'referred_by' => array('type' =>
'text','nullable' => False)
),
'pk' => array('contact_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_contact_personal' => array(
'fd' => array(
'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'birthday' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'children' => array('type' => 'text','nullable'
=> False),
'gender' => array('type' => 'char', 'precision'
=> 32,'nullable' => False),
'gov_id_num' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'hobbies' => array('type' => 'text','nullable'
=> False),
'language' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'spouse' => array('type' => 'text','nullable'
=> False),
'anniversary' => array('type' => 'int',
'precision' => 4,'nullable' => False)
),
'pk' => array('contact_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_language' => array(
'fd' => array(
'language_id' => array('type' => 'auto'),
'language_name' => array('type' => 'char',
'precision' => 40,'nullable' => False),
'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(
'fd' => array(
'category_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'name' => array('type' => 'char', 'precision'
=> 40,'nullable' => False)
),
'pk' => array('category_id'),
'fk' => array(),
'ix' => array(),
'uc' => array('name')
),
'phpgw_cdb_category_link' => array(
'fd' => array(
'category_link_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'category_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0')
),
'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'),
'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),
'ldap_sync' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'ldap_dn' => array('type' => 'varchar',
'precision' => 100,'nullable' => False)
),
'pk' => array('entity_id'),
'fk' => array(),
'ix' => array('file_as'),
'uc' => array()
),
'phpgw_cdb_contact_flag' => array(
'fd' => array(
'flag_id' => array('type' => 'auto'),
'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
'flag_name' => array('type' => 'char',
'precision' => 40,'nullable' => False),
'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(
'fd' => array(
'flag_link_id' => array('type' => 'auto'),
'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'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(
'fd' => array(
'followup_id' => array('type' => 'auto'),
'followup_name' => array('type' => 'char',
'precision' => 20,'nullable' => False),
'followup_color' => array('type' => 'char',
'precision' => 6,'nullable' => False)
),
'pk' => array('followup_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_contact_internet' => array(
'fd' => array(
'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'email_home' => array('type' => 'char',
'precision' => 50,'nullable' => False),
'email_home_display' => array('type' => 'char',
'precision' => 50,'nullable' => False),
'email_business' => array('type' => 'char',
'precision' => 50,'nullable' => False),
'email_business_display' => array('type' =>
'char', 'precision' => 50,'nullable' => False),
'email_other' => array('type' => 'char',
'precision' => 50,'nullable' => False),
'email_other_display' => array('type' =>
'char', 'precision' => 50,'nullable' => False),
'ftp' => array('type' => 'char', 'precision' =>
100,'nullable' => False),
'free_busy_address' => array('type' => 'char',
'precision' => 100,'nullable' => False),
'personal_home_page' => array('type' => 'char',
'precision' => 100,'nullable' => False),
'business_home_page' => array('type' => 'char',
'precision' => 100,'nullable' => False),
'other_home_page' => array('type' => 'char',
'precision' => 100,'nullable' => False),
'send_as_plain_text' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '1'),
'icq' => array('type' => 'char', 'precision' =>
20,'nullable' => False)
),
'pk' => array('contact_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_contact_addr_cat' => array(
'fd' => array(
'address_category_id' => array('type' =>
'auto'),
'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),
'address_country' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'postal_code' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'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()
),
'phpgw_cdb_views' => array(
'fd' => array(
'view_id' => array('type' => 'auto'),
'cache_date' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'owner' => array('type' => 'int', 'precision'
=> 4,'nullable' => False),
'group_owner' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'view_public' => array('type' => 'char',
'precision' => 32,'nullable' => False),
'name' => array('type' => 'varchar',
'precision' => 30,'nullable' => False),
'type' => array('type' => 'int', 'precision' =>
4,'nullable' => False),
'view_fields' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'view_filter' => array('type' =>
'text','nullable' => False),
'sort' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
'view_group' => array('type' => 'varchar',
'precision' => 100,'nullable' => False)
),
'pk' => array('view_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_recent' => array(
'fd' => array(
'account_id' => array('type' => 'auto'),
'orgs' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'contacts' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'views' => array('type' => 'varchar',
'precision' => 20,'nullable' => False)
),
'pk' => array('account_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
)
);
?>
====================================================
Index: tables_baseline.inc.php
<?php
/**************************************************************************\
* phpGroupWare - Setup *
* http://www.phpgroupware.org *
* -------------------------------------------- *
* This program is free software; you can redistribute it and/or modify it *
* under the terms of the GNU General Public License as published by the *
* Free Software Foundation; either version 2 of the License, or (at your *
* option) any later version. *
\**************************************************************************/
/***************************************************************************\
* This file should be generated for you. It should rarely be edited by hand *
\***************************************************************************/
/* $Id: tables_baseline.inc.php,v 1.1 2005/05/05 00:56:39 skwashd Exp $ */
/* table array for cdb */
/* TODO - Adjust classes to match shorter table names (due to 32 char limit
in Pgsql) */
/* TODO - If you have baseline, you must also have tables_update - Milosch */
$phpgw_baseline = array(
'phpgw_cdb_contact_main' => array(
'fd' => array(
'contact_id' => array('type' => 'auto'),
'main_organization_location_sele' =>
array('type' => 'int', 'precision' => 4,'nullable' => False,'default' => '0'),
'first_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'middle_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'last_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'last_name_prefix' => array('type' =>
'varchar', 'precision' => 10,'nullable' => False),
'initials' => array('type' => 'char',
'precision' => 6,'nullable' => False),
'location' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'nickname' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'profession' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'suffix' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'title' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'email_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'web_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'mailing_address_selector' => array('type' =>
'int', 'precision' => 4,'nullable' => False,'default' => '0'),
'phone1_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone2_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone3_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone4_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone5_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone6_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'phone7_selector' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'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()
),
'phpgw_cdb_contact_phone_cat' => array(
'fd' => array(
'phone_category_id' => array('type' => 'auto'),
'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(
'fd' => array(
'organization_id' => array('type' => 'auto'),
'organization_name' => array('type' =>
'varchar', 'precision' => 100,'nullable' => False),
'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(
'fd' => array(
'location_id' => array('type' => 'auto'),
'organization_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'location' => array('type' => 'text','nullable'
=> False),
'address_city' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'address_country' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'postal_code' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'address_street' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'number' => array('type' => 'varchar',
'precision' => 100,'nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array('location_id')
),
'phpgw_cdb_org_client' => array(
'fd' => array(
'organization_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'account' => array('type' => 'text','nullable'
=> False),
'billing_info' => array('type' =>
'text','nullable' => False),
'customer_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'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(),
'uc' => array()
),
'phpgw_cdb_contact_org' => array(
'fd' => array(
'organization_link_id' => array('type' =>
'int', 'precision' => 4,'nullable' => False,'default' => '0'),
'organization_location_id' => array('type' =>
'int', 'precision' => 4,'nullable' => False,'default' => '0'),
'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'assistant_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'assistant_phone' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
'assistant_email' => array('type' => 'varchar',
'precision' => 50,'nullable' => False),
'department' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'job_title' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'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(),
'uc' => array()
),
'phpgw_cdb_contact_client' => array(
'fd' => array(
'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'account' => array('type' => 'text','nullable'
=> False),
'billing_info' => array('type' =>
'text','nullable' => False),
'customer_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'referred_by' => array('type' =>
'text','nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_contact_personal' => array(
'fd' => array(
'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'birthday' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'children' => array('type' => 'text','nullable'
=> False),
'gender' => array('type' => 'char', 'precision'
=> 32,'nullable' => False),
'gov_id_num' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'hobbies' => array('type' => 'text','nullable'
=> False),
'language' => array('type' => 'int',
'precision' => 4,'nullable' => False),
'spouse' => array('type' => 'text','nullable'
=> False),
'anniversary' => array('type' => 'int',
'precision' => 4,'nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_language' => array(
'fd' => array(
'language_id' => array('type' => 'auto'),
'language_name' => array('type' => 'char',
'precision' => 40,'nullable' => False),
'language_code' => array('type' => 'char',
'precision' => 10,'nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array('language_id')
),
'phpgw_cdb_category' => array(
'fd' => array(
'category_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'name' => array('type' => 'char', 'precision'
=> 40,'nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_category_link' => array(
'fd' => array(
'category_link_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'category_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'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'),
'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),
'ldap_sync' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'ldap_dn' => array('type' => 'varchar',
'precision' => 100,'nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_contact_flag' => array(
'fd' => array(
'flag_id' => array('type' => 'auto'),
'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
'flag_name' => array('type' => 'char',
'precision' => 40,'nullable' => False),
'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(
'fd' => array(
'flag_link_id' => array('type' => 'auto'),
'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'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(
'fd' => array(
'followup_id' => array('type' => 'auto'),
'followup_name' => array('type' => 'char',
'precision' => 20,'nullable' => False),
'followup_color' => array('type' => 'char',
'precision' => 6,'nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array('followup_id')
),
'phpgw_cdb_contact_internet' => array(
'fd' => array(
'contact_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'email_home' => array('type' => 'char',
'precision' => 50,'nullable' => False),
'email_home_display' => array('type' => 'char',
'precision' => 50,'nullable' => False),
'email_business' => array('type' => 'char',
'precision' => 50,'nullable' => False),
'email_business_display' => array('type' =>
'char', 'precision' => 50,'nullable' => False),
'email_other' => array('type' => 'char',
'precision' => 50,'nullable' => False),
'email_other_display' => array('type' =>
'char', 'precision' => 50,'nullable' => False),
'ftp' => array('type' => 'char', 'precision' =>
100,'nullable' => False),
'free_busy_address' => array('type' => 'char',
'precision' => 100,'nullable' => False),
'personal_home_page' => array('type' => 'char',
'precision' => 100,'nullable' => False),
'business_home_page' => array('type' => 'char',
'precision' => 100,'nullable' => False),
'other_home_page' => array('type' => 'char',
'precision' => 100,'nullable' => False),
'send_as_plain_text' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '1'),
'icq' => array('type' => 'char', 'precision' =>
20,'nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'phpgw_cdb_contact_addr_cat' => array(
'fd' => array(
'address_category_id' => array('type' =>
'auto'),
'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),
'address_country' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'postal_code' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
'address_street' => array('type' => 'varchar',
'precision' => 255,'nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array('contact_address_id')
)
);
?>
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, (continued)
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1,
skwashd <=
- Prev by Date:
[Phpgroupware-cvs] timetrack/debian changelog, 1.2 control, 1.2 rules, 1.2 copyright, 1.2
- Next by Date:
[Phpgroupware-cvs] cdb/doc/examples/sql cdb_language.sql, 1.2 cdb.sql, 1.2
- Previous by thread:
[Phpgroupware-cvs] old/cdb/setup phpgw_en.lang, 1.1 default_records.inc.php, 1.1 phpgw_fr.lang, 1.1 setup.inc.php, 1.1 tables_update.inc.php, 1.1 tables_current.inc.php, 1.1 tables_baseline.inc.php, 1.1
- Next by thread:
[Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1
- Index(es):