From c59b34d0693d8dfd241598346d7049e98094f10b Mon Sep 17 00:00:00 2001
From: rangi <rangi>
Date: Sat, 17 Jun 2006 22:12:01 +0000
Subject: [PATCH] Adding id field to reviews table

---
 updater/updatedatabase | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

diff --git a/updater/updatedatabase b/updater/updatedatabase
index acb6e6e938..76aadef3f1 100755
--- a/updater/updatedatabase
+++ b/updater/updatedatabase
@@ -167,11 +167,13 @@ my %requiretables = (
                            	PRIMARY KEY  (id)
                            	)",
        reviews                  => "(
+	                        reviewid integer NOT NULL auto_increment,
 	                        borrowernumber integer,
 	                        biblionumber integer,
 	                        review text,
 	                        approved tinyint,
-	                        datereviewed datetime
+	                        datereviewed datetime,
+	                        PRIMARY KEY (reviewid)
 	                        )",
 
 );
@@ -1791,6 +1793,9 @@ sub MARCgetitem {
 exit;
 
 # $Log$
+# Revision 1.148  2006/06/17 22:12:01  rangi
+# Adding id field to reviews table
+#
 # Revision 1.147  2006/06/17 03:36:41  rangi
 # Table definition for the reviews table
 #
-- 
2.20.1