 
 	alter table cf_temp_zipfiles add new_filename varchar2(255);
 	alter table cf_temp_zipfiles add preview_filename varchar2(255);
+	alter table cf_temp_zipfiles add md5 varchar2(255);
+	alter table cf_temp_zipfiles add mime_type varchar2(255);
+	alter table cf_temp_zipfiles add media_type varchar2(255);
+	alter table cf_temp_zipfiles add remote_preview varchar2(255);
 --->
 <cfset goodExtensions="jpg,png">
 <cfset baseWebDir="#application.serverRootURL#/mediaUploads/#session.username#/#dateformat(now(),'yyyy-mm-dd')#">

					<cfset fName=REReplace(fName,"[^A-Za-z0-9_$]","_","all")>
					<cfset fName=replace(fName,'__','_','all')>
					<cfset nfileName=fName & '.' & fext>
					<cffile action = "rename"
						source = "#Application.webDirectory#/temp/#d.zid#/#filename#"
						destination = "#Application.webDirectory#/temp/#d.zid#/#nfileName#">

			select * from cf_temp_zipload where status='unzipped' and rownum=1
		</cfquery>
		<cfdump var=#d#>
		<cfset utilities = CreateObject("component","component.utilities")>



		<cfloop query="d">
			<cfquery name="f" datasource="uam_god">
				select * from cf_temp_zipfiles where zid=#d.zid#
