CREATE TABLE `news` (
  `IDLNK` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(255) NOT NULL,
  `URL` varchar(100) NOT NULL,
  `Tags` varchar(255) NOT NULL,
  `Content` text NOT NULL,
  `Published` tinyint(1) NOT NULL,
  `PublishedDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `EditedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `PublishedByIDLNK` int(11) NOT NULL,
  `Public` tinyint(1) NOT NULL,
  `Deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`IDLNK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1