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 ;