mirror of
https://github.com/php/web-pecl.git
synced 2026-03-24 15:22:16 +01:00
32 lines
999 B
SQL
32 lines
999 B
SQL
--
|
|
-- 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`)
|
|
);
|