Michael Joyner wrote:According to the description of Path, the primary key on PathId still exists.
mysql> describe Path; +--------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+------------------+------+-----+---------+----------------+ | PathId | int(10) unsigned | | PRI | NULL | auto_increment | | Path | blob | | | | | +--------+------------------+------+-----+---------+----------------+ 2 rows in set (0.00 sec)
As it should... I think you removed the primary key from the *File* table, not the Path table.
What's describe File; look like?
Look at your two alter table statements more closely...
Ah, my mistake...
mysql> describe File; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra +------------+------------------+------+-----+---------+----------------+ | FileId | int(10) unsigned | | PRI | NULL | auto_increment | FileIndex | int(10) unsigned | | | 0 | | JobId | int(10) unsigned | | | 0 | | PathId | int(10) unsigned | | | 0 | | FilenameId | int(10) unsigned | | MUL | 0 | | MarkId | int(10) unsigned | | | 0 | | LStat | tinyblob | | | | | MD5 | tinyblob | | | | +------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.00 sec)
I thought FilenameId was the field that was the PRIMARY KEY, but it's FileId.
Sorry...
I'm still perplexed about your problem though. Dropping the index on FilenameId and Path shouldn't change the constraints on the tables at all...
Weird.
-- Jeff McCune OSU Department of Mathematics System Support (614) 292-4962 gpg --keyserver pgp.mit.edu --recv-key BAF3211A
signature.asc
Description: OpenPGP digital signature
