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