--
-- Table structure for table `events`
--
DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events` (
`eventid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`eventtypeid` int(10) DEFAULT NULL,
`folderid` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) DEFAULT NULL,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`imageid` int(10) unsigned NOT NULL DEFAULT '0',
`align` int(10) unsigned NOT NULL DEFAULT '1',
`eventdate` varchar(255) DEFAULT NULL,
`eventtime` varchar(255) DEFAULT NULL,
`listdate` int(11) DEFAULT '0',
`venueid` int(10) unsigned NOT NULL DEFAULT '0',
`body` blob,
`links` blob,
`extralink` varchar(255) DEFAULT NULL,
`publish` int(4) DEFAULT NULL,
`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=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `events`
--
INSERT INTO `events` VALUES (1,1,1,'Test Conference',1,1,1,'1-3 January 2011','all day',1293840000,1,'<p>This is a test','web links here',NULL,3,1);
--
-- Table structure for table `eventtypes`
--
DROP TABLE IF EXISTS `eventtypes`;
SET @saved_cs_client = @@character_set_client;
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;
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 `sponsors`
--
DROP TABLE IF EXISTS `sponsors`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sponsors` (
`sponsorid` int(10) unsigned NOT NULL auto_increment,
`sponsor` varchar(255) NOT NULL default '',
`sponsorlink` varchar(255) default NULL,
PRIMARY KEY (`sponsorid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `sponsors`
--
INSERT INTO `sponsors` VALUES (1,'Miss Barbell Productions','http://www.missbarbell.co.uk');
--
-- Table structure for table `techtalks`
--
DROP TABLE IF EXISTS `techtalks`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `techtalks` (
`talkid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`eventid` int(10) unsigned NOT NULL default '0',
`guest` int(2) default '0',
`talktitle` varchar(255) default NULL,
`abstract` blob,
`resource` blob,
PRIMARY KEY (`talkid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `techtalks`
--
INSERT INTO `techtalks` VALUES (1,1,1,1,'Title To Be Confirmed','<p>Abstract Here</p>','<p>No Resources</p>');
--
-- Table structure for table `venues`
--
DROP TABLE IF EXISTS `venues`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `venues` (
`venueid` int(10) unsigned NOT NULL auto_increment,
`venue` varchar(255) default NULL,
`venuelink` varchar(255) default NULL,
`address` varchar(255) default NULL,
`addresslink` varchar(255) default NULL,
`info` blob,
PRIMARY KEY (`venueid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `venues`
--
INSERT INTO `venues` VALUES (1,'To Be Confirmed','','More details soon','','');