Problems with relationships without Auto increment

I have the following relationships

Contact HABTM List

list HABTM Contact

Only I had to take my auto_increment primaryKey ID field from the contact table, I'm having problem when using INSERT IGNORE.

To replace the auto_incremente created the following trigger:

  DECLARE AUTOI int UNSIGNED DEFAULT 0;

  SELECT max(id) into AUTOI from contacts;

  

  IF (AUTOI IS NULL) THEN

      SET new.id=1;

  ELSE

      SET new.id=AUTOI+1;

  END IF;

When I save a new record in the table contacts is all right, more on the table contacts_lists the field contat_id is always with value 0

Would anyone know tell me how can I fix this?

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.