mysql.jorge at decimal
Jul 16, 2009, 3:58 PM
Post #1 of 1
(482 views)
Permalink
|
|
Different table's structure
|
|
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;
|
