[SOLVED]How do you get_dir_file_info date into mysql?

[eluser]zimco[/eluser]
Tried your suggestion like this:

Code:

DROP TABLE IF EXISTS `html_racefiles`;
CREATE TABLE IF NOT EXISTS `html_racefiles` (
  `file_id` int(11) NOT NULL auto_increment,
  `file_name` varchar(255),
  `server_path` varchar(255),
  `size` int(11),
  `date` unix_timestamp,
  `relative_path` varchar(255),
  PRIMARY KEY  (`file_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

and it errors out with:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unix_timestamp,
`relative_path` varchar(255),
PRIMARY KEY (`file_id`)
) ENG' at line 6

Any other suggestions?