PHP Code:
CREATE TABLE files ( id int(10) unsigned NOT NULL AUTO_INCREMENT, torrent int(10) unsigned NOT NULL DEFAULT '0', filename varchar(255) COLLATE utf8_unicode_ci NOT NULL, size bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY torrent (torrent), FULLTEXT KEY filename (filename) )