CPAN-Testers-WWW-Reports
view release on metacpan or search on metacpan
vhost/cgi-bin/db/cpanreps-base.sql view on Meta::CPAN
--
INSERT INTO `mxarticles` VALUES (1,'reports');
--
-- Table structure for table `optimages`
--
DROP TABLE IF EXISTS `optimages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `optimages` (
`optionid` int(10) unsigned NOT NULL DEFAULT '0',
`typeid` int(10) unsigned NOT NULL DEFAULT '1',
`imageid` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`optionid`,`typeid`),
KEY `IXTYPE` (`typeid`),
KEY `IXIMAGE` (`imageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `optimages`
--
--
-- Table structure for table `options`
--
DROP TABLE IF EXISTS `options`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `options` (
`optionid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`menuid` int(10) unsigned NOT NULL DEFAULT '0',
`orderno` int(2) DEFAULT '0',
`accessid` int(2) DEFAULT '0',
`name` varchar(255) DEFAULT NULL,
`text` varchar(255) DEFAULT NULL,
`href` varchar(255) DEFAULT NULL,
`section` varchar(255) DEFAULT '',
PRIMARY KEY (`optionid`),
KEY `IXMENU` (`menuid`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `options`
--
INSERT INTO `options` VALUES (1,1,1,1,NULL,'Home','/',NULL);
INSERT INTO `options` VALUES (2,1,2,1,NULL,'Status','/home/status',NULL);
INSERT INTO `options` VALUES (3,1,3,1,NULL,'Help','/page/help',NULL);
INSERT INTO `options` VALUES (4,1,4,1,NULL,'About','/page/about',NULL);
INSERT INTO `options` VALUES (5,1,5,1,NULL,'Admin','/user/login',NULL);
INSERT INTO `options` VALUES (11,2,1,1,NULL,'Administration','/home/admin',NULL);
INSERT INTO `options` VALUES (12,2,2,2,NULL,'Site Pages','/arts/admin',NULL);
INSERT INTO `options` VALUES (17,2,3,4,NULL,'Users','/user/admin',NULL);
INSERT INTO `options` VALUES (15,2,4,5,NULL,'Menus','/menu/admin',NULL);
INSERT INTO `options` VALUES (16,2,5,5,NULL,'Current Hits','/hits/admin',NULL);
INSERT INTO `options` VALUES (18,2,6,5,NULL,'Requests','/req/admin',NULL);
INSERT INTO `options` VALUES (19,2,7,1,NULL,'Logout','/user/logout',NULL);
--
-- Table structure for table `paragraphs`
--
DROP TABLE IF EXISTS `paragraphs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paragraphs` (
`paraid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`articleid` int(10) unsigned NOT NULL DEFAULT '0',
`orderno` int(4) DEFAULT NULL,
`type` int(4) DEFAULT NULL,
`imageid` int(10) unsigned NOT NULL DEFAULT '0',
`href` varchar(255) DEFAULT NULL,
`body` blob,
`align` int(4) DEFAULT NULL,
PRIMARY KEY (`paraid`),
KEY `IXART` (`articleid`),
KEY `IXIMG` (`imageid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `paragraphs`
--
INSERT INTO `paragraphs` VALUES (1,1,1,2,0,NULL,'<p>Test</p>',NULL);
INSERT INTO `paragraphs` VALUES (2,2,1,2,0,NULL,'<h2>Who, What, Why?</h2><p>CPAN Testers is a volunteer effort to test distributions as they are uploaded to CPAN, the Perl code repository. There are currently over 100 testers, who are able to test ac...
--
-- Table structure for table `realms`
--
DROP TABLE IF EXISTS `realms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `realms` (
`realmid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`realm` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`command` varchar(255) DEFAULT NULL,
PRIMARY KEY (`realmid`),
KEY `IXREALM` (`realm`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `realms`
--
INSERT INTO `realms` VALUES (1,'public','Public Interface','home-main');
INSERT INTO `realms` VALUES (2,'admin','Admin Interface','home-admin');
--
-- Table structure for table `requests`
--
DROP TABLE IF EXISTS `requests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `requests` (
`requestid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`section` varchar(15) NOT NULL,
`command` varchar(15) NOT NULL,
`actions` varchar(1000) DEFAULT NULL,
`layout` varchar(255) DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`onsuccess` varchar(32) DEFAULT NULL,
`onerror` varchar(32) DEFAULT NULL,
`onfailure` varchar(32) DEFAULT NULL,
`secure` enum('off','on','either','both') DEFAULT 'off',
`rewrite` varchar(255) DEFAULT NULL,
PRIMARY KEY (`requestid`),
KEY `sectcomm` (`section`,`command`)
) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `requests`
--
INSERT INTO `requests` VALUES (1,'link','admin','Links::Admin','','links/link_adminlist.html','','','','off','');
INSERT INTO `requests` VALUES (2,'link','csave',',Links::CatSave','','','link-cedit','link-cedit','','off','');
INSERT INTO `requests` VALUES (3,'link','cadmin','Links::CatAdmin','','links/cat_adminlist.html','','','','off','');
INSERT INTO `requests` VALUES (4,'link','add','Links::Add','','links/link_adminedit.html','','','','off','');
INSERT INTO `requests` VALUES (5,'link','edit','Links::Edit','','links/link_adminedit.html','','','','off','');
INSERT INTO `requests` VALUES (6,'link','cadd','','','links/cat_adminedit.html','','','','off','');
INSERT INTO `requests` VALUES (7,'link','main','Links::List','','links/link_list.html','','','','off','');
INSERT INTO `requests` VALUES (8,'link','cedit','Links::CatEdit','','links/cat_adminedit.html','','','','off','');
INSERT INTO `requests` VALUES (9,'link','save','Links::CheckLink,Links::Save','','','link-edit','link-edit','','off','');
INSERT INTO `requests` VALUES (10,'link','delete','Links::Delete','','','link-admin','','','off','');
INSERT INTO `requests` VALUES (11,'imgs','save','Images::Save','','','imgs-admin','','imgs-failure','off','');
INSERT INTO `requests` VALUES (12,'imgs','admin','Images::List','','images/image-list.html','','','','off','');
INSERT INTO `requests` VALUES (13,'imgs','failure','','','images/image-failure.html','','','','off','');
INSERT INTO `requests` VALUES (14,'imgs','add','Images::Add','','images/image-edit.html','','','','off','');
INSERT INTO `requests` VALUES (15,'imgs','delete','Images::Delete','','','imgs-admin','','imgs-failure','off','');
INSERT INTO `requests` VALUES (16,'imgs','edit','Images::Edit','','images/image-edit.html','','','','off','');
INSERT INTO `requests` VALUES (17,'cpan','distunk','','','cpan/distro-unknown.html','','','','off','');
INSERT INTO `requests` VALUES (18,'cpan','authors','CPAN::Authors::List','','cpan/author-list.html','','','','off','');
INSERT INTO `requests` VALUES (19,'cpan','report','CPAN::Report::View','','cpan/report-view.html','','','','off','');
INSERT INTO `requests` VALUES (20,'cpan','distro','CPAN::Distros::Reports','','cpan/distro-reports.html','','','','off','');
INSERT INTO `requests` VALUES (21,'cpan','authunk','','','cpan/author-unknown.html','','','','off','');
INSERT INTO `requests` VALUES (22,'cpan','distros','CPAN::Distros::List','','cpan/distro-list.html','','','','off','');
INSERT INTO `requests` VALUES (23,'cpan','author','CPAN::Authors::Reports','','cpan/author-reports.html','','','','off','');
INSERT INTO `requests` VALUES (24,'menu','save','Menus::Save','','','menu-edit','menu-edit','','off','');
INSERT INTO `requests` VALUES (25,'menu','admin','Menus::Admin','','menus/menu_adminlist.html','','','','off','');
INSERT INTO `requests` VALUES (26,'menu','add','Menus::Add','','menus/menu_adminedit.html','','','','off','');
INSERT INTO `requests` VALUES (27,'menu','delete','Menus::Delete','','','menu-admin','','','off','');
INSERT INTO `requests` VALUES (28,'menu','edit','Menus::Edit','','menus/menu_adminedit.html','','','','off','');
INSERT INTO `requests` VALUES (29,'arts','save','Articles::Site::Save','','','arts-edit','arts-edit','arts-failure','','');
INSERT INTO `requests` VALUES (30,'arts','admin','Articles::Site::Admin','','articles/arts-adminlist.html','','','','','');
INSERT INTO `requests` VALUES (31,'arts','failure','','','articles/arts-failure.html','','','','off','');
INSERT INTO `requests` VALUES (32,'arts','add','Articles::Site::Add','','articles/arts-adminedit.html','','','','','');
INSERT INTO `requests` VALUES (33,'arts','delete','Articles::Site::Delete','','','arts-admin','','arts-failure','','');
INSERT INTO `requests` VALUES (34,'arts','item','Articles::Site::Item','','articles/arts-item.html','','','','','');
INSERT INTO `requests` VALUES (35,'arts','edit','Articles::Site::Edit','','articles/arts-adminedit.html','','','','','');
INSERT INTO `requests` VALUES (36,'hits','admin','Hits::AdminHits','','hits/hits_admin.html','','','','','');
INSERT INTO `requests` VALUES (37,'user','add','Users::Add','','users/user-adminedit.html','','','','off','');
INSERT INTO `requests` VALUES (38,'user','acldel','Users::ACLDelete','','','user-acl','user-acl','user-acl','off','');
INSERT INTO `requests` VALUES (39,'user','item','Users::Item','','users/user-item.html','','','','off','');
INSERT INTO `requests` VALUES (40,'user','edit','Users::Edit','','users/user-edit.html','','','','off','');
INSERT INTO `requests` VALUES (41,'user','aclsave','Users::ACLSave','','','user-acl','user-acl','user-acl','off','');
INSERT INTO `requests` VALUES (42,'user','save','Users::Save','','','user-adminedit','user-adminedit','user-failure','off','');
INSERT INTO `requests` VALUES (43,'user','failure','','','users/user-failure.html','','','','off','');
INSERT INTO `requests` VALUES (44,'user','chng','Users::Password','','','user-edit','user-pass','','off','');
INSERT INTO `requests` VALUES (45,'user','logout','Users::Logout','','','home-main','','','off','');
INSERT INTO `requests` VALUES (46,'user','list','Users::UserLists','','users/user-list.html','','','','off','');
INSERT INTO `requests` VALUES (47,'user','admin','Users::Admin','','users/user-adminlist.html','','','','off','');
INSERT INTO `requests` VALUES (48,'user','pass','Users::Name','','users/user-pass.html','','','','off','');
INSERT INTO `requests` VALUES (49,'user','acl','Users::ACL','','users/user-acl.html','','','','off','');
INSERT INTO `requests` VALUES (50,'user','ban','Users::Ban','','','user-admin','','user-failure','off','');
INSERT INTO `requests` VALUES (51,'user','login','','','users/user-login.html','','','','off','');
INSERT INTO `requests` VALUES (52,'user','amend','Users::Save','','','user-edit','user-editerror','user-failure','off','');
INSERT INTO `requests` VALUES (53,'user','logged','Users::Login,Users::Retrieve','','','','user-login','user-login','off','');
INSERT INTO `requests` VALUES (54,'user','delete','Users::Delete','','','user-admin','','user-failure','off','');
INSERT INTO `requests` VALUES (55,'user','adminedit','Users::Edit','','users/user-adminedit.html','','','','off','');
INSERT INTO `requests` VALUES (56,'realm','admin','Content::GetVersion,Menus::LoadMenus','admin/layout.html','','','','','off','');
INSERT INTO `requests` VALUES (57,'realm','popup','','public/popup.html','','','','','off','');
INSERT INTO `requests` VALUES (58,'realm','public','Content::GetVersion,Hits::SetHits,Menus::LoadMenus','public/layout.html','','','','','off','');
INSERT INTO `requests` VALUES (59,'realm','wide','','public/layout-wide.html','','','','','off','');
INSERT INTO `requests` VALUES (60,'error','badmail','','','public/badmail.html','','','','off','');
INSERT INTO `requests` VALUES (61,'error','badcmd','','','public/badcommand.html','','','','off','');
INSERT INTO `requests` VALUES (62,'error','banuser','','','public/banuser.html','','','','off','');
INSERT INTO `requests` VALUES (63,'error','badaccess','Users::LoggedIn','','public/badaccess.html','','error-login','','off','');
INSERT INTO `requests` VALUES (64,'error','baduser','','','public/baduser.html','','','','off','');
INSERT INTO `requests` VALUES (65,'error','login','Users::Store','','users/user-login.html','','','','off','');
INSERT INTO `requests` VALUES (66,'error','message','','','public/error_message.html','','','','off','');
INSERT INTO `requests` VALUES (67,'home','admin','','','admin/backend_index.html','','','','off','');
INSERT INTO `requests` VALUES (68,'home','prefs','CPAN::Authors::Basic','','cpan/prefs.html','','','','off','');
INSERT INTO `requests` VALUES (69,'home','status','CPAN::Authors::Status','','content/status.html','','','','off','');
INSERT INTO `requests` VALUES (70,'home','main','CPAN::Authors::Status','','content/welcome.html','','','','off','');
INSERT INTO `requests` VALUES (71,'req','admin','Requests::Admin',NULL,'request/request_adminlist.html','','',NULL,'off',NULL);
INSERT INTO `requests` VALUES (72,'req','add','Requests::Add',NULL,'request/request_adminedit.html','','',NULL,'off',NULL);
INSERT INTO `requests` VALUES (73,'req','edit','Requests::Edit',NULL,'request/request_adminedit.html','','',NULL,'off',NULL);
INSERT INTO `requests` VALUES (74,'req','save','Requests::Save',NULL,'','req-edit','req-edit',NULL,'off',NULL);
INSERT INTO `requests` VALUES (75,'req','delete','Requests::Delete',NULL,'','req-admin','',NULL,'off',NULL);
INSERT INTO `requests` VALUES (76,'user','adminpass','Users::AdminPass',NULL,'users/user-adminpass.html','','',NULL,'off',NULL);
INSERT INTO `requests` VALUES (77,'user','adminchng','Users::AdminChng',NULL,'','user-adminedit','user-adminpass',NULL,'off',NULL);
INSERT INTO `requests` VALUES (78,'cpan','drss','CPAN::Report::DistroRSS',NULL,'public/blank.html','','',NULL,'off',NULL);
INSERT INTO `requests` VALUES (79,'cpan','arss','CPAN::Report::AuthorRSS',NULL,'public/blank.html','','',NULL,'off',NULL);
INSERT INTO `requests` VALUES (80,'realm','yaml','','public/layout.yaml','','','',NULL,'off',NULL);
INSERT INTO `requests` VALUES (81,'realm','rss','','public/layout.rss','','','',NULL,'off',NULL);
INSERT INTO `requests` VALUES (82,'cpan','dyml','CPAN::Report::DistroYAML',NULL,'public/blank.html','','',NULL,'off',NULL);
INSERT INTO `requests` VALUES (83,'cpan','ayml','CPAN::Report::AuthorYAML',NULL,'public/blank.html','','',NULL,'off',NULL);
--
-- Table structure for table `sessions`
--
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sessions` (
`sessionid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`labyrinth` varchar(255) DEFAULT NULL,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) DEFAULT NULL,
`realm` varchar(255) DEFAULT NULL,
`folderid` int(10) unsigned NOT NULL DEFAULT '0',
`optionid` int(10) unsigned NOT NULL DEFAULT '0',
`timeout` int(11) unsigned NOT NULL DEFAULT '0',
`langcode` char(2) NOT NULL DEFAULT 'en',
`query` blob,
PRIMARY KEY (`sessionid`),
KEY `IXLAB` (`labyrinth`),
KEY `IXTIMEOUT` (`timeout`),
KEY `IXUSER` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sponsors`
--
DROP TABLE IF EXISTS `sponsors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sponsors` (
`sponsorid` int(10) unsigned NOT NULL AUTO_INCREMENT,
( run in 0.664 second using v1.01-cache-2.11-cpan-97f6503c9c8 )