DIR : /home/kozerus/public_html/cr_ko_coffeeshop.sql

/home/kozerus/public_html

DROP TABLE IF EXISTS ko_coffeeshop;
DROP TABLE IF EXISTS host_list;
DROP TABLE IF EXISTS host_list_ka;
DROP TABLE IF EXISTS media_list;
DROP TABLE IF EXISTS media_list_ka;
DROP TABLE IF EXISTS coffeec_list;
DROP TABLE IF EXISTS coffee_list;
DROP TABLE IF EXISTS coffee_list_ka;

CREATE TABLE IF NOT EXISTS host_list ( 
	hostid varchar,
	host varchar
	);


CREATE TABLE IF NOT EXISTS media_list (
	hostid varchar,
	host varchar,
	url varchar,
	tn varchar
	);



CREATE TABLE IF NOT EXISTS coffeec_list (
	hostid varchar,
	host varchar
	);


CREATE TABLE IF NOT EXISTS ko_coffeeshop (
	hostid varchar,
	host varchar,
	status varchar,
	grp varchar,
	coffee_id varchar,
	coffee_url varchar,	
	coffee_tn varchar,
	home varchar,
	pdf varchar,
	pdftxt varchar,
	mp3 varchar,
	mp3txt varchar,
	mp4 varchar,
	mp4txt varchar,
	gif varchar,
	giftxt varchar,
	txt varchar,
	txttxt varchar,
	yt varchar,
	yttxt varchar,
	bc varchar,
	bctxt varchar,
	fb varchar,
	fbtxt varchar,
	fab varchar,
	pl varchar,
	ss varchar,
	tw varchar,
	jitsi varchar,
	chat varchar,
	pn varchar,
	pntxt varchar,
	sl varchar,
	sltxt varchar,
	tl varchar,
	tltxt varchar,
	zm varchar,
	zmtxt varchar,
	email varchar,
	phn varchar,
	logo varchar,
	note varchar
	);


CREATE TABLE IF NOT EXISTS files ( 
	rid varchar,
	status varchar, 
	progid varchar,
	effdt varchar, 
	id varchar,
	grp 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
	seq varchar,
	avid varchar,
	bcid varchar,
	fbid varchar,
	htid varchar,
	pdid varchar,
	pnid varchar,
	slid varchar,
	tlid varchar,
	ytid varchar,
	zmid 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,

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

-- interaction
	usrcmd varchar,
	page varchar,
	pagelim varchar
	step varchar


-- tl_json timeline
	startdate varchar,
	starttime varchar,
	enddate varchar,
	endtime varchar,
	headline varchar,
	text varchar,
	assets varchar,
	media varchar,
	credit varchar,
	caption varchar,
	href varchar,
	note varchar,
	txtcnt varchar,


-- workvars
	i varchar,
	j varchar,
	k varchar,
	l varchar,
	m varchar,
	n varchar,
	p varchar,
	q 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 );





insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","royal1","buymeacoffee.com/royal1","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","jhf","buymeacoffee.com/jhf","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","konet","buymeacoffee.com/konet","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","iperms","buymeacoffee.com/iperms","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","ko0","buymeacoffee.com/ko0","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","ko1","buymeacoffee.com/ko1","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","ko2","buymeacoffee.com/ko2","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","ka1","buymeacoffee.com/ka1","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","jk","buymeacoffee.com/jk","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","sk","buymeacoffee.com/sk","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","jkwii","buymeacoffee.com/jkwii","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","skwii","buymeacoffee.com/skwii","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","jak1","buymeacoffee.com/jak1","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","jak2","buymeacoffee.com/jak2","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","jak3","buymeacoffee.com/jak3","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","med","buymeacoffee.com/med","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","law","buymeacoffee.com/law","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","koed","buymeacoffee.com/koed","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","jtfdc","buymeacoffee.com/jtfdc","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","jtfinc","buymeacoffee.com/jtfinc","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","hamamoto","buymeacoffee.com/hamamoto","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","georgewebb","buymeacoffee.com/georgewebb","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","housatonic","buymeacoffee.com/housatonic","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","polly","buymeacoffee.com/polly","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","couey","buymeacoffee.com/couey","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");
insert into ko_coffeeshop (hostid,host,status,grp,coffee_id,coffee_url,coffee_tn )
values ("hostid","host","status","grp","mcduff","buymeacoffee.com/mcduff","/imgs/gif/us/tn/tn_giphy_coffee_drip.gif");