DROP TABLE sluzby16;
CREATE TABLE sluzby16(id SERIAL PRIMARY KEY, cookieid bigint, service char(30), interaction char(15), datetime timestamp, url varchar(6100), href varchar(1000), query varchar(1500));
COPY sluzby16(cookieid,service,interaction,datetime,url,href,query) FROM '/1611/sluzby_out.csv' DELIMITER ';' CSV;


DROP TABLE zbozi16;
CREATE TABLE zbozi16(id SERIAL PRIMARY KEY, cookieid bigint, counter int, datetime timestamp, interaction char(15), url varchar(6100), sourcecategory varchar(46), firsturl varchar(6100), referrer varchar(6100), product varchar(500), category varchar(200), fee int);
COPY zbozi16(cookieid,counter,datetime,interaction,url,sourcecategory,firsturl,referrer,product,category,fee) FROM '/1611/zbozi_out.csv' DELIMITER ';' CSV;


DROP TABLE sluzby17;
CREATE TABLE sluzby17(id SERIAL PRIMARY KEY, cookieid bigint, service char(30), interaction char(15), datetime timestamp, url varchar(6100), href varchar(1000), query varchar(1500));
COPY sluzby17(cookieid,service,interaction,datetime,url,href,query) FROM '/1707/sluzby_out.csv' DELIMITER ';' CSV;


DROP TABLE zbozi17;
CREATE TABLE zbozi17 (id SERIAL PRIMARY KEY, cookieid bigint, counter int, datetime timestamp, interaction char(15), url varchar(6100), sourcecategory varchar(46), firsturl varchar(6100), referrer varchar(6100), product varchar(500), category varchar(200), fee int);
COPY zbozi17(cookieid,counter,datetime,interaction,url,sourcecategory,firsturl,referrer,product,category,fee) FROM '/1707/zbozi_out.csv' DELIMITER ';' CSV;