Re: [Phpgroupware-developers] Account/Address DB proposal

[Brian Johnson]

I haven't reviewed this db model yet, but the current proposed db model could
provide two methods to achieve your goal

1. have the code set the record id from the input form, if one is not provided,
insert one higher than the maximum.  The code would also have to check that an
inserted id was not already used and issue an error message to the user

2. the db is set up to allow the user to create "fields" for whatever type of 
info
you want to enter (multiple phone numbers, fax numbers, emails, etc), you could 
just
create one to track the record id's from your other app


Sigurd Nes (address@hidden) wrote:
>
>Kai Hofmann wrote:
>
>>As an addendum to
>>
>>http://www.phpgroupware.org/devteam/wiki/index.php?page=DBStuff
>>http://www.phpgroupware.org/devteam/wiki/index.php?page=AddressBook
>>
>>I would like to make a proposal for the following (3 pages)
>>database model (the naming has not yet been changed to phpgw_).
>>Please feel free to add this to the wiki pages.
>>
>>http://www.probusiness.de/projekte/phpgroupware/pdf/phpGW_addr.pdf
>>
>>Greetings
>>
>>   Kai
>>
>>
>>
>Would it be possible to include the ability to controle the ID's (to not
>use 'auto_increment') ?
>I think that would be nice in order to be able to import contacts fom
>other systems - or let the external system (in my case - an accounting
>system) maintain the contacts
>
>Sigurd
>
>
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>

--
Brian Johnson
* This is where my witty signature line would be if I bothered to edit this 
line :) *