--
-- Table structure for table `packages`
--

DROP TABLE IF EXISTS `packages`;

CREATE TABLE `packages` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(80) NOT NULL default '',
  `category` int(11) default NULL,
  `stablerelease` varchar(20) default NULL,
  `develrelease` varchar(20) default NULL,
  `license` varchar(50) default NULL,
  `summary` text,
  `description` text,
  `homepage` varchar(255) default NULL,
  `package_type` enum('pear','pecl') NOT NULL default 'pear',
  `doc_link` varchar(255) default NULL,
  `cvs_link` varchar(255) default NULL,
  `bug_link` varchar(255) default NULL,
  `approved` tinyint(4) NOT NULL default '0',
  `wiki_area` tinyint(1) NOT NULL default '0',
  `unmaintained` tinyint(1) NOT NULL default '0',
  `newpk_id` int(11) default NULL,
  `blocktrackbacks` tinyint(4) NOT NULL default '0',
  `newpackagename` varchar(100) default NULL,
  `newchannel` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE INDEX (`name`),
  INDEX (`category`)
);