   KEY `JobCategoryID` (`JobCategoryID`),
   KEY `AuthorID` (`AuthorID`),
   KEY `ClassName` (`ClassName`)
-) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-
-LOCK TABLES `Job` WRITE;
-/*!40000 ALTER TABLE `Job` DISABLE KEYS */;
-INSERT INTO `Job` (`ID`,`ClassName`,`Created`,`LastEdited`,`Title`,`Description`,`Location`,`ExpiryDate`,`JobCategoryID`,`AuthorID`)
-VALUES
-	(1,'Job','2009-01-17 17:45:56','2009-07-10 14:48:09','Social Network Data Model','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Morbi commodo, ipsum sed pharetra gravida, orci magna rhoncus neque, id pulvinar odio lorem non turpis. Nullam sit amet enim. Suspendisse id velit vitae ligula volutpat condimentum. Aliquam erat volutpat. Sed quis velit. Nulla facilisi. Nulla libero. Vivamus pharetra posuere sapien. Nam consectetuer. Sed aliquam, nunc eget euismod ullamcorper, lectus nunc ullamcorper orci, fermentum bibendum enim nibh eget ipsum. Donec porttitor ligula eu dolor. Maecenas vitae nulla consequat libero cursus venenatis.','London','2010-10-12',9,1),
-	(2,'Job','2009-01-17 17:46:24','2009-07-10 14:48:00','Weather Widget Programming','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Morbi commodo, ipsum sed pharetra gravida, orci magna rhoncus neque, id pulvinar odio lorem non turpis. Nullam sit amet enim. ','Paris',NULL,9,1),
-	(3,'Job','2009-01-17 17:49:24','2009-07-10 14:48:53','Interface for Membership Management','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Morbi commodo, ipsum sed pharetra gravida, orci magna rhoncus neque, id pulvinar odio lorem non turpis. Nullam sit amet enim. Suspendisse id velit vitae ligula volutpat condimentum. Aliquam erat volutpat. Sed quis velit. Nulla facilisi. Nulla libero. Vivamus pharetra posuere sapien. Nam consectetuer. Sed aliquam, nunc eget euismod ullamcorper, lectus nunc ullamcorper orci, fermentum bibendum enim nibh eget ipsum. Donec porttitor ligula eu dolor. Maecenas vitae nulla consequat libero cursus venenatis.\r\n\r\n','Auckland',NULL,10,1),
-	(4,'Job','2009-07-10 14:49:37','2009-07-10 14:51:10','Forum expert','Expert at building online communities','Wellington, New Zealand','2010-01-01',9,1),
-	(5,'Job','2009-07-10 14:50:07','2009-07-10 14:50:07','ORM guru','Expert at creating object-relational mappings','Melbourne, Australia',NULL,9,1);
-
-/*!40000 ALTER TABLE `Job` ENABLE KEYS */;
-UNLOCK TABLES;
-
-
-# Dump of table JobCategory_Subscribers
-# ------------------------------------------------------------
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
+
+--
+-- Dumping data for table `Job`
+--
+
+INSERT INTO `Job` (`ID`, `ClassName`, `Created`, `LastEdited`, `Title`, `Description`, `Location`, `ExpiryDate`, `JobCategoryID`, `AuthorID`) VALUES
+(1, 'Job', '2009-01-17 17:45:56', '2009-07-10 14:48:09', 'Social Network Data Model', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Morbi commodo, ipsum sed pharetra gravida, orci magna rhoncus neque, id pulvinar odio lorem non turpis. Nullam sit amet enim. Suspendisse id velit vitae ligula volutpat condimentum. Aliquam erat volutpat. Sed quis velit. Nulla facilisi. Nulla libero. Vivamus pharetra posuere sapien. Nam consectetuer. Sed aliquam, nunc eget euismod ullamcorper, lectus nunc ullamcorper orci, fermentum bibendum enim nibh eget ipsum. Donec porttitor ligula eu dolor. Maecenas vitae nulla consequat libero cursus venenatis.', 'London', '2010-10-12', 9, 1),
+(2, 'Job', '2009-01-17 17:46:24', '2009-07-10 14:48:00', 'Weather Widget Programming', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Morbi commodo, ipsum sed pharetra gravida, orci magna rhoncus neque, id pulvinar odio lorem non turpis. Nullam sit amet enim. ', 'Paris', NULL, 9, 1),
+(3, 'Job', '2009-01-17 17:49:24', '2009-07-10 14:48:53', 'Interface for Membership Management', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Morbi commodo, ipsum sed pharetra gravida, orci magna rhoncus neque, id pulvinar odio lorem non turpis. Nullam sit amet enim. Suspendisse id velit vitae ligula volutpat condimentum. Aliquam erat volutpat. Sed quis velit. Nulla facilisi. Nulla libero. Vivamus pharetra posuere sapien. Nam consectetuer. Sed aliquam, nunc eget euismod ullamcorper, lectus nunc ullamcorper orci, fermentum bibendum enim nibh eget ipsum. Donec porttitor ligula eu dolor. Maecenas vitae nulla consequat libero cursus venenatis.\r\n\r\n', 'Auckland', NULL, 10, 1),
+(4, 'Job', '2009-07-10 14:49:37', '2009-07-10 14:51:10', 'Forum expert', 'Expert at building online communities', 'Wellington, New Zealand', '2010-01-01', 9, 1),
+(5, 'Job', '2009-07-10 14:50:07', '2009-07-10 14:50:07', 'ORM guru', 'Expert at creating object-relational mappings', 'Melbourne, Australia', NULL, 9, 1);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `JobCategory_Subscribers`
+--
 
 DROP TABLE IF EXISTS `JobCategory_Subscribers`;
-
-CREATE TABLE `JobCategory_Subscribers` (
+CREATE TABLE IF NOT EXISTS `JobCategory_Subscribers` (
   `ID` int(11) NOT NULL auto_increment,
   `JobCategoryID` int(11) NOT NULL default '0',
   `MemberID` int(11) NOT NULL default '0',
   PRIMARY KEY  (`ID`),
   KEY `JobCategoryID` (`JobCategoryID`),
   KEY `MemberID` (`MemberID`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-
-LOCK TABLES `JobCategory_Subscribers` WRITE;
-/*!40000 ALTER TABLE `JobCategory_Subscribers` DISABLE KEYS */;
-INSERT INTO `JobCategory_Subscribers` (`ID`,`JobCategoryID`,`MemberID`)
-VALUES
-	(1,10,1);
-
-/*!40000 ALTER TABLE `JobCategory_Subscribers` ENABLE KEYS */;
-UNLOCK TABLES;
-
-
-# Dump of table LoginAttempt
-# ------------------------------------------------------------
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
+
+--
+-- Dumping data for table `JobCategory_Subscribers`
+--
+
+INSERT INTO `JobCategory_Subscribers` (`ID`, `JobCategoryID`, `MemberID`) VALUES
+(1, 10, 1);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `LoginAttempt`
+--
 
 DROP TABLE IF EXISTS `LoginAttempt`;
-
-CREATE TABLE `LoginAttempt` (
+CREATE TABLE IF NOT EXISTS `LoginAttempt` (
   `ID` int(11) NOT NULL auto_increment,
   `ClassName` enum('LoginAttempt') character set utf8 default 'LoginAttempt',
   `Created` datetime default NULL,

  KEY `Version` (`Version`),
  KEY `AuthorID` (`AuthorID`),
  KEY `PublisherID` (`PublisherID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table SiteTree
# ------------------------------------------------------------

DROP TABLE IF EXISTS `SiteTree`;

CREATE TABLE `SiteTree` (
  `ID` int(11) NOT NULL auto_increment,
  `ClassName` enum('SiteTree','Page','GhostPage','BlogEntry','BlogHolder','JobCategory','JobCategoryHolder','ErrorPage','RedirectorPage','VirtualPage','UserDefinedForm') character set utf8 default 'SiteTree',
  `Created` datetime default NULL,

  KEY `GroupID` (`GroupID`),
  KEY `Code` (`Code`),
  KEY `ClassName` (`ClassName`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `Permission`
--

INSERT INTO `Permission` (`ID`, `ClassName`, `Created`, `LastEdited`, `Code`, `Arg`, `Type`, `GroupID`) VALUES
(1, 'Permission', '2009-01-17 17:20:32', '2009-01-17 17:20:32', 'ADMIN', 0, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `QueuedEmail`
--

DROP TABLE IF EXISTS `QueuedEmail`;
CREATE TABLE IF NOT EXISTS `QueuedEmail` (
  `ID` int(11) NOT NULL auto_increment,
  `ClassName` enum('QueuedEmail') character set utf8 default 'QueuedEmail',
  `Created` datetime default NULL,
