create table ffzg_inventura (
	date_scanned date not null,
	barcode varchar(20) not null,
	source_id varchar(20) not null,
	timestamp datetime default now(),
	unique key ffzg_inventura_unique (barcode,date_scanned,source_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
-- this collate has to be same as barcode in items check it with:
-- show create table items
