downloads table

CREATE TABLE `downloads` (
   `id` INT(11) NOT NULL AUTO_INCREMENT,
   `document_id` INT(11) NOT NULL,
   `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   `user_ip` VARCHAR(40),
   PRIMARY KEY (`id`),
   UNIQUE KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;