TagCloud Table Structure? Hi.
I need some help with a tag-cloud.
I am wondering a few things:
1) Should I be allowing repetition in my table inserts?
2) I am assuming yes, and, if this is the case, then I am
guessing that the count goes up for all tags of the same name?
How is that done?
Below is my table structure:
CREATE TABLE IF NOT EXISTS mcs.tagcloud (
TagID int(10) unsigned NOT NULL auto_increment,
ScheduleID int(10) unsigned NOT NULL,
Tag varchar(100) NOT NULL,
count int(11) NOT NULL default '0',
hits int(11) NOT NULL default '0',
PRIMARY KEY (TagID),
KEY ScheduleID (ScheduleID),
FOREIGN KEY (ScheduleID) references CommonSchedule(ScheduleID) on
delete cascade on update cascade
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |