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` mediumtext NOT NULL,
  `Published` tinyint(1) NOT NULL,
  `PublishedDate` timestamp NOT NULL DEFAULT '1970-01-01 00:00:01',
  `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,
  `ExpiryDate` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`IDLNK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8