Stuff

use 'gazelle';



CREATE TABLE IF NOT EXISTS `newsblog` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(200) NOT NULL,
  `ShortBody` text NOT NULL,
  `LongBody` text NOT NULL,
  `DateCreated` datetime NOT NULL,
  `AuthorID` int(11) NOT NULL,
  `Hidden` enum('0','1') NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `newsblog`
--

INSERT INTO `newsblog` (`ID`, `Title`, `ShortBody`, `LongBody`, `DateCreated`, `AuthorID`, `Hidden`) VALUES
(1, 'osadinfas', '', 'sladkfnmasdfa', '0000-00-00 00:00:00', 1, '0');





CREATE TABLE IF NOT EXISTS `newsblog_comments` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `PostID` int(11) NOT NULL,
  `UserID` int(11) NOT NULL,
  `Comment` text NOT NULL,
  `TimeStamp` datetime NOT NULL,
  `EditedByID` int(11) NOT NULL,
  `EditedTime` datetime NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `newsblog_comments`
--

INSERT INTO `newsblog_comments` (`ID`, `PostID`, `UserID`, `Comment`, `TimeStamp`, `EditedByID`, `EditedTime`) VALUES
(1, 1, 1, 'this is my comment', '2011-05-26 00:00:00', 0, '0000-00-00 00:00:00');