[Phpgroupware-tracker] [bugs #8615] phpgw_contact_org_person - 2 primary keys - no auto increment

[Dirk Schaller]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.




/**************************************************************************/
[bugs #8615] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=8615>
Project: phpGroupWare
Submitted by: Dirk Schaller
On: Mon 04/19/04 at 09:20

Category:  API - phpGWapi
Item Group:  devel cvs
Severity:  7 - Major
Priority:  7 - High
Resolution:  None
Assigned to:  jarg
Status:  Open
Component Version:  CVS
Platform Version:  None
Reproducibility:  None


Summary:  phpgw_contact_org_person - 2 primary keys - no auto increment

Original Submission:  The phpgw_contact_org_person contains two primary keys 
(org_id and person_id) and no unique auto increment primary key. That has the 
effect that one person can be assigned only to one organization. When assigning 
a person to a secound org I get the message:

Database error: Invalid SQL: INSERT INTO phpgw_contact_org_person
(person_id, created_on, created_by, preferred, org_id) VALUES (940,
1082362689, 5013, 'N', 11)
MySQL Error: 1062 (Duplicate entry '11-940' for key 1)

File: /srv/www/htdocs/pbgroupware/phpgwapi/inc/class.sql_entity.inc.php
Line: 515

Session halted.


I would use a auto increment pk. The person_id and org_id should be foreign 
keys. Or if there shouldn't be the possibility to assign a person to more than 
one orgs, it should be tested and a messege should be shown.











For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=8615>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/