I had a corruption on my item db when adding some new things in SQL Express.
Somehow 2 rows had become joined.
Scrolling through the original Item DB that comes with Ruby, I notice a record is missing in the middle of the table. Items seem accessible before and after the missing record so just how important is the numeric ID field here ?
I had assumed it was a unique indexed key field but clearly it isn't.
Anyone had any issues with this ?
Somehow 2 rows had become joined.
Scrolling through the original Item DB that comes with Ruby, I notice a record is missing in the middle of the table. Items seem accessible before and after the missing record so just how important is the numeric ID field here ?
I had assumed it was a unique indexed key field but clearly it isn't.
Anyone had any issues with this ?