# tmp

sql:
  CREATE TABLE files ( 
  	progid varchar,
  	dttm varchar, 
  	status varchar, 
  	krow varchar, 

  -- kupinfo
  	f_name varchar, 
  	f_type varchar, 
  	f_size varchar, 
  	f_error varchar, 
  	f_tmp varchar, 
  	t_name varchar, 
  	referer varchar, 
  	query_string varchar, 
  	user_agent varchar, 
  	remote_addr varchar, 
  	remote_port varchar, 
  	server_addr varchar, 
  	server_port varchar, 


  -- groups
  	grp varchar,
  	ord varchar,
  	avid varchar,
  	fbid varchar,
  	tlid varchar,

  -- fileinfo
  	pathfile varchar,
  	path varchar,
  	file varchar,
  	base varchar,
  	ext varchar,
  	size varchar,
  	ctime varchar,
  	mtime varchar,
  	fpathfile varchar,
  	tpathfile varchar,


  -- filename_dttm
  	fn_dttm varchar,
  	fn_dt varchar,
  	fn_tm varchar,

  -- exiftool
  	exif_dttm varchar,
  	exif_dt varchar,
  	exif_tm varchar,
  	exif_zm varchar,
  	exif_path varchar,
  	exif_file varchar,
  	exif_imgsize varchar,
  	exif_ctime varchar,
  	exif_duration varchar,
  	starttime varchar,
  	endtime varchar,

  -- av_json audiovideo gallery h5g
  	title varchar,
  	thumbnail varchar,
  	alt varchar,
  	link varchar,
  	linktarget varchar,
  	src varchar,
  	tn varchar,
  	tn1 varchar,
  	tn2 varchar,


  -- tl_json timeline
  	startdate varchar,
  	enddate varchar,
  	headline varchar,
  	text varchar,
  	assets varchar,
  	media varchar,
  	credit varchar,
  	caption varchar,

  -- workvars
  	i varchar,
  	j varchar,
  	k varchar,
  	l varchar,
  	w varchar,
  	h varchar,
  	t varchar,
  	x varchar,
  	y varchar,
  	z varchar,
  	t1 varchar,
  	x1 varchar,
  	y1 varchar,
  	z1 varchar,
  	t2 varchar,
  	x2 varchar,
  	y2 varchar,
  	z2 varchar,

  -- tailinfo
  	temp varchar,
  	desc varchar )


