From a7bda7dad2a2f94d70a4152ddf5e7c1304a1fba1 Mon Sep 17 00:00:00 2001
From: rangi <rangi>
Date: Mon, 24 Jun 2002 22:01:26 +0000
Subject: [PATCH] Have added missing borrowernumber field to the statistics
 table

---
 koha.mysql             | 1 +
 updater/updatedatabase | 4 ++++
 2 files changed, 5 insertions(+)

diff --git a/koha.mysql b/koha.mysql
index 497c365c4a..f7532d6872 100644
--- a/koha.mysql
+++ b/koha.mysql
@@ -756,6 +756,7 @@ CREATE TABLE statistics (
   usercode varchar(10),
   itemnumber int(11),
   itemtype varchar(4),
+  borrowernumber int(11) default NULL,
   KEY timeidx (datetime)
 );
 
diff --git a/updater/updatedatabase b/updater/updatedatabase
index 36b4f19c61..52dd08c63b 100755
--- a/updater/updatedatabase
+++ b/updater/updatedatabase
@@ -84,6 +84,7 @@ my %requirefields=(
 		'url' => 'varchar(255)',
 		'marc' => 'text' },
     branchtransfers=>{ 'datearrived' => 'datetime' },
+    statistics=>{'borrowernumber' =>'int(11)'},
 );
 
 #-------------------
@@ -254,6 +255,9 @@ $dbh->disconnect;
 exit;
 
 # $Log$
+# Revision 1.4.2.7  2002/06/24 22:01:26  rangi
+# Have added missing borrowernumber field to the statistics table
+#
 # Revision 1.4.2.6  2002/06/20 15:07:08  amillar
 # Add table ethnicity
 #
-- 
2.20.1