I've developed a bookmarking application, and it's become apparent that I need to deal with duplicate bookmarks in a sensible way.
The long-term aim is to have a way of "scoring" bookmarks, so that when someone adds a bookmark that already exists, the score for the original is incremented.
The reasons for doing this are, I no doubt, obvious.
So far, the bookmarks table looks like this:
I have a few ideas in my mind how I might build a scoring system, but I'd much prefer to run this by you guys first, before committing to something that's either not practical or scales poorly over time.
CREATE TABLE `bookmarks` (
`id` int(11) NOT NULL auto_increment,
`user_id` mediumint(11) NOT NULL,
`datetime` datetime default NULL,
`status` enum('public','private') NOT NULL default 'public',
PRIMARY KEY (`id`),
KEY `datetime` (`datetime`),
FULLTEXT KEY `title` (`title`,`snippet`)
Any help would be much appreciated!