CREATE TABLE `tasks` (
  `IDLNK` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(100) NOT NULL,
  `User_ID_LNK` int(11) NOT NULL,
  `Object_Type` varchar(25) DEFAULT NULL,
  `Object_ID_LNK` int(11) DEFAULT NULL,
  `Description` text NOT NULL,
  `TargetDate` varchar(18) NOT NULL,
  `Completed` tinyint(1) NOT NULL,
  `CompletedDate` varchar(25) DEFAULT NULL,
  `Note` text DEFAULT NULL,
  `Owner_ID_LNK` int(11) NOT NULL,
  `PreviousTask` int(11) DEFAULT NULL,
  `Archived` tinyint(4) NOT NULL,
  `Deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`IDLNK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1