PhpDig.net - View Single Post

bsw114 · 03-04-2004, 05:16 PM

Since keywords.key_id is only a tinyint it will hit the end at 8.4 million. All entries after that will fail and autoincrement returns a 0 which puts many key_id=0 entries for the same spider_id which should be prevented with a composite unique constraint on spider_id/key_id.

To fix the key_id problem it should be made a bitint instead.

03-04-2004, 05:16 PM	#1
bsw114 Green Mole Join Date: Feb 2004 Posts: 3	keywords.key_id is too small Since keywords.key_id is only a tinyint it will hit the end at 8.4 million. All entries after that will fail and autoincrement returns a 0 which puts many key_id=0 entries for the same spider_id which should be prevented with a composite unique constraint on spider_id/key_id. To fix the key_id problem it should be made a bitint instead.