>I cannot insert values into the tables
What is the error message? Has the smallint key run out of values?
>and I cannot alter or delete the primary key (which should not exist)
Eh? Without a PK, it ain't a table.
>or delete the foreign keys nor remove the constraint. G search doesn't
help.
If the pk referenced by the fk is full, I think you need to drop the fk,
then drop the pk in the table referenced by the fk, then recreate that
pk as an int, then recreate the fk.
PB
-----
PJ wrote:
I have a seemingly impossible situation. I cannot insert values into the
tables and I cannot alter or delete the primary key (which should not
exist) or delete the foreign keys nor remove the constraint. G search
doesn't help.
CREATE TABLE `book_categories` (
`bookID` smallint(6) unsigned NOT NULL,
`categories_id` int(2) unsigned NOT NULL,
PRIMARY KEY (`bookID`,`categories_id`),
KEY `fk_book_categories_books` (`bookID`),
KEY `fk_book_categories_categories` (`categories_id`),
CONSTRAINT `book_categories_ibfk_1` FOREIGN KEY (`book_id`) REFERENCES
`book` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1
Anybody out there still up? I'm rather desperate to fix this this evening...
Thanks in advance.
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.36/2126 - Release Date: 05/21/09 06:22:00