From 90f46afd60af6830dc2e2e0ed82f101cd8095888 Mon Sep 17 00:00:00 2001
From: rangi <rangi>
Date: Sat, 17 Jun 2006 03:36:41 +0000
Subject: [PATCH] Table definition for the reviews table

---
 updater/updatedatabase | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/updater/updatedatabase b/updater/updatedatabase
index 43b0bbdaa1..acb6e6e938 100755
--- a/updater/updatedatabase
+++ b/updater/updatedatabase
@@ -166,6 +166,13 @@ my %requiretables = (
                            	startrow int(2) default NULL,
                            	PRIMARY KEY  (id)
                            	)",
+       reviews                  => "(
+	                        borrowernumber integer,
+	                        biblionumber integer,
+	                        review text,
+	                        approved tinyint,
+	                        datereviewed datetime
+	                        )",
 
 );
 
@@ -1784,6 +1791,9 @@ sub MARCgetitem {
 exit;
 
 # $Log$
+# Revision 1.147  2006/06/17 03:36:41  rangi
+# Table definition for the reviews table
+#
 # Revision 1.146  2006/06/17 03:29:41  rangi
 # Variable to allow librarians to switch reviews on or off
 #
-- 
2.39.5