Index: llx_contrat_contact.key.sql
===================================================================
RCS file: llx_contrat_contact.key.sql
diff -N llx_contrat_contact.key.sql
0a1,30
> -- ============================================================================
> -- Copyright (C) 2005 patrick Rouillon <patrick@rouillon.net>
> --
> -- 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 program is distributed in the hope that it will be useful,
> -- but WITHOUT ANY WARRANTY; without even the implied warranty of
> -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> -- GNU General Public License for more details.
> --
> -- You should have received a copy of the GNU General Public License
> -- along with this program; if not, write to the Free Software
> -- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
> --
> -- $Id:  $
> -- $Source:  $
> --
> -- ============================================================================
> 
> 
> ALTER TABLE llx_contrat_contact 
> 	ADD INDEX idx_contrat_contact_fk_contrat (fk_contrat);
> 	
> ALTER TABLE llx_contrat_contact 
> 	ADD CONSTRAINT idx_contrat_contact_fk_contrat		
> 	FOREIGN KEY (fk_contrat)     REFERENCES llx_contrat(rowid);
> 
Index: llx_contrat_contact.sql
===================================================================
RCS file: llx_contrat_contact.sql
diff -N llx_contrat_contact.sql
0a1,37
> -- ============================================================================
> -- Copyright (C) 2005 patrick Rouillon <patrick@rouillon.net>
> --
> -- 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 program is distributed in the hope that it will be useful,
> -- but WITHOUT ANY WARRANTY; without even the implied warranty of
> -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> -- GNU General Public License for more details.
> --
> -- You should have received a copy of the GNU General Public License
> -- along with this program; if not, write to the Free Software
> -- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
> --
> -- $Id:  $
> -- $Source:  $
> --
> -- Association de personnes/societes avec un contrat.
> -- Permet de definir plusieur type d'intervenant sur un contrat.
> -- i.e. commercial, adresse de facturation, prestataire...
> -- ============================================================================
> 
> create table llx_contrat_contact
> (
>   rowid           integer AUTO_INCREMENT PRIMARY KEY,  
>   datecreate      datetime, 			-- date de creation de l'enregistrement
>   statut          smallint DEFAULT 0, -- 5 inactif, 4 actif
>   nature			varchar(80),			-- nature du contact.
> 
>   fk_contrat		 integer NOT NULL,
>   fk_socpeople     integer NOT NULL
>   
> )type=innodb;
>