CREATE TABLE exp_files

CREATE TABLE `exp_files` ( `file_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned DEFAULT '1', `title` varchar(255) DEFAULT NULL, `upload_location_id` int(4) unsigned DEFAULT '0', `rel_path` varchar(255) DEFAULT NULL, `status` char(1) DEFAULT 'o', `mime_type` varchar(255) DEFAULT NULL, `file_name` varchar(255) DEFAULT NULL, `file_size` int(10) DEFAULT '0', `caption` text, `field_1` text, `field_1_fmt` tinytext, `field_2` text, `field_2_fmt` tinytext, `field_3` text, `field_3_fmt` tinytext, `field_4` text, `field_4_fmt` tinytext, `field_5` text, `field_5_fmt` tinytext, `field_6` text, `field_6_fmt` tinytext, `metadata` mediumtext, `uploaded_by_member_id` int(10) unsigned DEFAULT '0', `upload_date` int(10) DEFAULT NULL, `modified_by_member_id` int(10) unsigned DEFAULT '0', `modified_date` int(10) DEFAULT NULL, `file_hw_original` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`file_id`), KEY `upload_location_id` (`upload_location_id`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3920 DEFAULT CHARSET=utf8