X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=ffzg_inventura.sql;h=7bbd382fa7b9a9c2d899a50e7f1c6b66a643d652;hb=HEAD;hp=e67a31c4b9641eb7ace6e3918440bb5688ce96ff;hpb=e8ba780365285ab12df5ff1163341ba0dea321e0;p=koha-dla

diff --git a/ffzg_inventura.sql b/ffzg_inventura.sql
index e67a31c..7bbd382 100644
--- a/ffzg_inventura.sql
+++ b/ffzg_inventura.sql
@@ -2,5 +2,8 @@ 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