Re: [Fofredux-devel] Re: other issues / comments

[Kevin <ke...@dr...>]

Benjamin Stewart wrote:

>Update, 2 seconds later:  yes, the existing HEAD does not like not
>having any categories defined.  As soon as I defined one, panel started
>working (though view still has the problem defined below), and a second
>problem is that the panel immediately listed the feeds I had added
>without a category as belonging to the new category (obviously wrong).  
>
>Anyway, I'm just going to wait until tags land to worry about this too
>much.  
>
>Kevin, what database schema are you planning on using for tags?
>
>  
>
Here is my plan for the tag schema.  It adds 2 new tables.   One to hold 
the tag names, and the other to cross reference tags to items.   I am 
about 25% finished.  I probably won't have something worthy of a checkin 
until next week.

CREATE TABLE `$FOF_TAG_TABLE` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(250),
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `$FOF_X_TAG_ITEM_TABLE` (
  `id` int(11) NOT NULL auto_increment,
  `tag_id` int(11) NOT NULL default '0',
  `item_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--Kevin