[Koha-cvs] koha/updater updatedatabase

[Chris Cormack]

CVSROOT:	/sources/koha
Module name:	koha
Changes by:	Chris Cormack <rangi>	06/06/17 22:12:01

Modified files:
	updater        : updatedatabase 

Log message:
	Adding id field to reviews table

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&r1=1.147&r2=1.148

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.147
retrieving revision 1.148
diff -u -b -r1.147 -r1.148
--- updatedatabase	17 Jun 2006 03:36:41 -0000	1.147
+++ updatedatabase	17 Jun 2006 22:12:01 -0000	1.148
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.147 2006/06/17 03:36:41 rangi Exp $
+# $Id: updatedatabase,v 1.148 2006/06/17 22:12:01 rangi Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -167,11 +167,13 @@
                            	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 @@
 exit;
 
 # $Log: updatedatabase,v $
+# 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
 #