Re: A Question of design.


Rik wrote:
I have told you several times an index on 2 columns is perfectly possible.
Make the index:
ALTER TABLE `user_books` ADD UNIQUE (
`user_id` ,
`book_id`
)

Voilá.

Hi Rick. Sorry, I believe that I have also mentioned several times that
I can't, as each user has one row per book, meaning there won't be any
unique uids, and if there were, it wouldn't be for very long at all.
The book_ids in the user table will also be duplicated, as more than
one user is likely to have the same book.

Thanks for your help. :)

Daz.

.

Relevant Pages