One more, sorry for this massive emails:

I have some tables that are a bit different from the create_tables.mysql,
especially on the columns order, can this have any kind of impact?

Showing them:

 

My table:

CREATE TABLE `dbmail_envelope` (

  `physmessage_id` bigint(20) NOT NULL default '0',

  `id` bigint(20) NOT NULL auto_increment,

  `envelope` text character set latin1 NOT NULL,

  PRIMARY KEY  (`id`),

  KEY `physmessage_id` (`physmessage_id`),

  CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`)
REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=3408890 DEFAULT CHARSET=utf8;

 

Create_tables.mysql:

 

CREATE TABLE `dbmail_envelope` (

  `id` bigint(20) NOT NULL auto_increment,

  `physmessage_id` bigint(20) NOT NULL default '0',

  `envelope` text NOT NULL,

  PRIMARY KEY  (`id`),

  UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`),

  CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`)
REFERENCES

`dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

Reply via email to