Location: PHPKode > projects > Site Sift Listings > db/table2.txt
CREATE TABLE `categories` (
  `id` int(11) NOT NULL auto_increment,
  `fatherID` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `description` text,
  `active` char(3) NOT NULL default '',
  `frontpage` char(1) default '0',
  `lastUpdate` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
)
Return current item: Site Sift Listings