[Typo3-dev] [Typo3-tt-news] category tree for kickstarter?

Michiel Roos news at monosock.org
Mon Oct 3 17:35:19 CEST 2005


One more thing that took me a while to figure out. The treeview seems to
have been written for the pages table. So the treeview needs a 'title'
field. I could not find a way around this. The table structure I now use
for the category table is:

  `uid` int(11) unsigned NOT NULL auto_increment,
  `pid` int(11) unsigned NOT NULL default '0',
  `tstamp` int(11) unsigned NOT NULL default '0',
  `crdate` int(11) unsigned NOT NULL default '0',
  `cruser_id` int(11) unsigned NOT NULL default '0',
  `deleted` tinyint(4) unsigned NOT NULL default '0',
  `hidden` tinyint(4) unsigned NOT NULL default '0',
  `title` varchar(60) NOT NULL default '',
  `parent_category` int(11) unsigned NOT NULL default '0',

You can add anything you like, like 'description' or something else.

Good luck.

Michiel




More information about the TYPO3-dev mailing list