phpgroupware-cvs
[Top][All Lists]
Advanced

[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')
                )
        );
?>






reply via email to

[Prev in Thread] Current Thread [Next in Thread]