CREATE TABLE `documents` (
  `IDLNK` int(11) NOT NULL AUTO_INCREMENT,
  `SectionIDLNK` int(11) DEFAULT NULL,
  `Filename` varchar(255) NOT NULL,
  `URL` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `DateCreated` varchar(12) NOT NULL,
  `CreatedByIDLNK` int(11) NOT NULL,
  `DateModified` varchar(12) DEFAULT NULL,
  `ModifiedByIDLNK` int(11) NOT NULL,
  `FileSize` int(50) NOT NULL,
  `FileType` varchar(50) NOT NULL,
  `FileMime` char(50) NOT NULL,
  `Public` tinyint(1) NOT NULL,
  `Parent` int(11) NOT NULL,
  `Archived` tinyint(1) NOT NULL,
  `NoShare` int(1) NOT NULL,
  `DocumentOrder` int(11) NOT NULL,
  `Deleted` int(1) NOT NULL,
  PRIMARY KEY (`IDLNK`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1