view release on metacpan or  search on metacpan

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

  `sponsorid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`eventid`),
  KEY `IXTYPE` (`eventtypeid`),
  KEY `IXFOLDER` (`folderid`),
  KEY `IXDATE` (`listdate`),
  KEY `IXVENUE` (`venueid`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `events`
--

INSERT INTO `events` VALUES (1,1,1,'YAPC::Europe 2009',3,1,1,'3-5 August 2009','all day',1249426800,13,'<p>This will be the 10th YAPC::Europe, with the event returning to Portugal, although this time around it\'ll be in the capital, Lisbon.</p><p>Tes...
INSERT INTO `events` VALUES (2,1,1,'YAPC::NA 2009',3,1,1,'22-24 June 2009','all day',1245798000,12,'<p>This will be the 10th anniversary of YAPC::NA, with the event returning to Carnegie Mellon University in Pittsburgh, where it all started.</p><p>Te...
INSERT INTO `events` VALUES (11,3,1,'2008 QA Hackathon',3,1,0,'5-7 April 2008','all day',1207350000,0,'<p><a href=\"http://2008.qa-hackathon.org\">2008 QA Hackathon</a> will be in Oslo, Norway.</p>',NULL,NULL,3,0);
INSERT INTO `events` VALUES (10,1,1,'YAPC::Europe 2011',3,1,0,'15-17 August 2011','all day',1313362800,17,'<p><a href=\"http://yapceurope.lv/ye2011/\">YAPC::Europe 2011</a> will be in Riga, Latvia.</p>',NULL,NULL,3,0);
INSERT INTO `events` VALUES (8,1,1,'YAPC::NA 2010',3,1,0,'21-23 June 2010','all day',1277074800,15,'<p>YAPC::NA 2010 will be at <a href=\"http://yapc2010.com/yn2010/wiki?node=Location\">The Ohio State University, Columbus, Ohio</a>.</p>',NULL,NULL,3,...
INSERT INTO `events` VALUES (9,1,1,'YAPC::NA 2011',3,1,0,'27-29 june 2011','all day',1309129200,16,'<p><a href=\"http://www.yapc2011.us/yn2011/\">YAPC::NA 2011</a> will be in Asheville, North Carolina.</p>',NULL,NULL,3,0);
INSERT INTO `events` VALUES (7,1,1,'YAPC::Europe 2010',3,1,0,'4 -6 August 2010','all day',1280617200,14,'<p><a href=\"http://conferences.yapceurope.org/ye2010\">YAPC::Europe 2010</a> will take place in Pisa, Italy.</p>','<p><a href=\"http://conferenc...
INSERT INTO `events` VALUES (12,3,1,'2009 QA Hackathon',3,1,0,'28-30 March 2009','all day',1238198400,0,'<p><a href=\"http://2009.qa-hackathon.org\">2009 QA Hackathon</a> will be in Birmingham, UK</p>',NULL,NULL,3,0);
INSERT INTO `events` VALUES (13,3,1,'2010 QA Hackathon',3,1,0,'10-12 April 2010','all day',1270854000,0,'<p><a href=\"http://2010.qa-hackathon.org\">2010 QA Hackathon</a> will be in Vienna, Austria.</p>',NULL,NULL,3,0);
INSERT INTO `events` VALUES (14,3,1,'2011 QA Hackathon',3,1,0,'16-18 April 2011','all day',1302908400,0,'<p><a href=\"http://2011.qa-hackathon.org\">2011 QA Hackathon</a> will be in Amsterdam, The Netherlands.</p>',NULL,NULL,3,0);

--
-- Table structure for table `eventtypes`
--

DROP TABLE IF EXISTS `eventtypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eventtypes` (
  `eventtypeid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `eventtype` varchar(255) NOT NULL DEFAULT '',
  `talks` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`eventtypeid`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eventtypes`
--

INSERT INTO `eventtypes` VALUES (1,'Conference',1);
INSERT INTO `eventtypes` VALUES (2,'Workshop',1);
INSERT INTO `eventtypes` VALUES (3,'Hackathon',1);
INSERT INTO `eventtypes` VALUES (4,'User Group',1);
INSERT INTO `eventtypes` VALUES (5,'Social Meeting',0);
INSERT INTO `eventtypes` VALUES (6,'Technical Meeting',1);
INSERT INTO `eventtypes` VALUES (7,'Special',1);

--
-- Table structure for table `folders`
--

DROP TABLE IF EXISTS `folders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `folders` (
  `folderid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `parent` int(10) DEFAULT NULL,
  `accessid` int(10) NOT NULL DEFAULT '5',
  PRIMARY KEY (`folderid`),
  KEY `IXPATH` (`path`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `folders`
--

INSERT INTO `folders` VALUES (1,'public',0,1);

--
-- Table structure for table `groups`
--

DROP TABLE IF EXISTS `groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups` (
  `groupid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `groupname` varchar(255) DEFAULT NULL,
  `master` int(2) DEFAULT '0',
  `member` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`groupid`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` VALUES (1,'public',1,'Guest');
INSERT INTO `groups` VALUES (2,'users',1,'User');
INSERT INTO `groups` VALUES (3,'editors',1,'Author');
INSERT INTO `groups` VALUES (4,'sponsors',1,'Sponsor');
INSERT INTO `groups` VALUES (5,'admins',1,'Admin');
INSERT INTO `groups` VALUES (9,'masters',1,'Master');

--
-- Table structure for table `hits`
--

DROP TABLE IF EXISTS `hits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hits` (
  `pageid` int(11) NOT NULL DEFAULT '0',
  `area` varchar(32) DEFAULT '',
  `photoid` int(11) NOT NULL DEFAULT '0',
  `counter` int(11) DEFAULT NULL,
  `query` varchar(255) DEFAULT '',
  `createdate` int(11) DEFAULT '0',
  KEY `IXPAGE` (`pageid`,`photoid`),
  KEY `IXAREA` (`area`),
  KEY `IXQUERY` (`query`),
  KEY `IXDATE` (`createdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `images`
--