[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/updater updatedatabase
From: |
Chris Cormack |
Subject: |
[Koha-cvs] koha/updater updatedatabase |
Date: |
Sat, 17 Jun 2006 22:12:01 +0000 |
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
#
- [Koha-cvs] koha/updater updatedatabase, Robert Lyon, 2006/06/06
- [Koha-cvs] koha/updater updatedatabase, Robert Lyon, 2006/06/06
- [Koha-cvs] koha/updater updatedatabase, Chris Cormack, 2006/06/16
- [Koha-cvs] koha/updater updatedatabase, Chris Cormack, 2006/06/16
- [Koha-cvs] koha/updater updatedatabase,
Chris Cormack <=
- [Koha-cvs] koha/updater updatedatabase, Bruno Toumi, 2006/06/22
- [Koha-cvs] koha/updater updatedatabase, Bruno Toumi, 2006/06/22
- [Koha-cvs] koha/updater updatedatabase, Bruno Toumi, 2006/06/27