view release on metacpan or  search on metacpan

vhost/cgi-bin/db/cpanwiki-base.sql  view on Meta::CPAN

  `search` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,5,1,'','Master','barbie@cpantesters.org',NULL,'SECRET','http://wiki.cpantesters.org','Master Wiki Admin',0);
INSERT INTO `users` VALUES (2,1,1,'','Guest','GUEST','public','c8d6ea7f8e6850e9ed3b642900ca27683a257201','','',0);

--
-- Table structure for table `wikiindex`
--

DROP TABLE IF EXISTS `wikiindex`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wikiindex` (
  `pagename` varchar(255) NOT NULL DEFAULT '',
  `version` int(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`pagename`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wikiindex`
--

INSERT INTO `wikiindex` VALUES ('AdminRequests',1);
INSERT INTO `wikiindex` VALUES ('HomePage',1);
INSERT INTO `wikiindex` VALUES ('SandBox',1);
INSERT INTO `wikiindex` VALUES ('SiteCredits',1);
INSERT INTO `wikiindex` VALUES ('WikiFormat',1);

--
-- Table structure for table `wikipage`
--

DROP TABLE IF EXISTS `wikipage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wikipage` (
  `pagename` varchar(255) NOT NULL DEFAULT '',
  `version` int(4) NOT NULL DEFAULT '1',
  `locked` int(1) NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `createdate` int(10) DEFAULT '0',
  `comment` varchar(255) DEFAULT NULL,
  `content` blob,
  PRIMARY KEY (`pagename`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wikipage`
--

INSERT INTO `wikipage` VALUES ('AdminRequests',1,0,1,1179853525,'','Are there any feature requests, bug fixes or other items you would like the site admins to look at? We cannot guarantee a rapid response, but this will be a good place to record any ...
INSERT INTO `wikipage` VALUES ('SiteCredits',1,0,1,1179853525,'','== Site Credits ==\n\n=== Layout & Design ===\n\nSite layout by Barbie, from an original CSS/XHTML Template Design by Arcsin ([http://templates.arcsin.se] and [http://www.oswd.org/...
INSERT INTO `wikipage` VALUES ('WikiFormat',1,0,1,1179853525,'','== Wiki Format ==\n\n=== Headings ===\n\n  == Heading 1 / H1 ==\n  === Heading 2 / H2 ===\n  ==== Heading 3 / H3 ====\n  ===== Heading 4 / H4 =====\n  ====== Heading 5 / H5 ======\n  ==...
INSERT INTO `wikipage` VALUES ('HomePage',1,0,1,1179853525,'','== The CPAN Testers Wiki ==\n\nThis wiki is the online reference for everything related to CPAN Testing. HowTos, Tutorials, FAQs and Notes are all here to help both beginners and experien...
INSERT INTO `wikipage` VALUES ('SandBox',1,0,1,1179853525,'','Test of cpan link: [[cpan:Test-Unit]]');

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2014-02-22  9:27:36