Mine

public text v1 · immutable

#185329

·published 2006-09-28 20:59 UTC


CREATE TABLE `indextable` (
  `ID` int(11) NOT NULL auto_increment,
  `DIR` text collate utf8_unicode_ci NOT NULL,
  `FILENAME` text collate utf8_unicode_ci NOT NULL,
  `FILESIZE` int(11) NOT NULL,
  `ACCESSTIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `DATA` longtext collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=738775 ;