added collate same as barcode in items

diff --git a/ffzg_inventura.sql b/ffzg_inventura.sql
index 94109bb..7bbd382 100644 (file)
--- a/ffzg_inventura.sql
+++ b/ffzg_inventura.sql
@@ -4,4 +4,6 @@ create table ffzg_inventura (
        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