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:
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`)
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.
Any help would be much appreciated!