Public feed #603508

Stuff

public text v1 · immutable
Raw Edit
·published 2007-07-04 21:03 UTC
rendered paste body
CREATE TABLE `awNews` (
  `NewsID` int(11) NOT NULL auto_increment,
  `PostTitle` varchar(64) default NULL,
  `PostBy` varchar(32) default NULL,
  `PostImage` varchar(32) NOT NULL,
  `PostImageAlt` varchar(32) NOT NULL,
  `PostTime` datetime default NULL,
  `Content` text,
  PRIMARY KEY  (`NewsID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

CREATE TABLE `awNewsComments` (
  `CommentID` int(11) NOT NULL auto_increment,
  `NewsID` int(11) default NULL,
  `CommentBy` varchar(32) default NULL,
  `CommentTitle` varchar(128) default NULL,
  `CommentTime` datetime default NULL,
  `Comment` text,
  PRIMARY KEY  (`CommentID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;