display barcode for item

[koha-dla] / ffzg_inventura.sql

diff --git a/ffzg_inventura.sql b/ffzg_inventura.sql
index e67a31c..7bbd382 100644 (file)
--- 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