[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/updater updatedatabase [rel_3_0]
From: |
Antoine Farnault |
Subject: |
[Koha-cvs] koha/updater updatedatabase [rel_3_0] |
Date: |
Wed, 18 Oct 2006 13:31:13 +0000 |
CVSROOT: /sources/koha
Module name: koha
Branch: rel_3_0
Changes by: Antoine Farnault <toins> 06/10/18 13:31:13
Modified files:
updater : updatedatabase
Log message:
Borrowers.categorycode must have 10 chars lenght &
categories.categorycode must be a primary key.
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&only_with_tag=rel_3_0&r1=1.157.2.10&r2=1.157.2.11
Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.157.2.10
retrieving revision 1.157.2.11
diff -u -b -r1.157.2.10 -r1.157.2.11
--- updatedatabase 17 Oct 2006 16:18:14 -0000 1.157.2.10
+++ updatedatabase 18 Oct 2006 13:31:13 -0000 1.157.2.11
@@ -1,6 +1,6 @@
#!/usr/bin/perl
-# $Id: updatedatabase,v 1.157.2.10 2006/10/17 16:18:14 hdl Exp $
+# $Id: updatedatabase,v 1.157.2.11 2006/10/18 13:31:13 toins Exp $
# Database Updater
# This script checks for required updates to the database.
@@ -489,6 +489,12 @@
null => 'NOT NULL',
extra => '',
},
+ {
+ field => 'categorycode',
+ type => 'varchar(10)',
+ null => 'NOT NULL',
+ extra => '',
+ }
],
biblioitems => [
@@ -547,8 +553,8 @@
{
field => 'categorycode',
type => 'varchar(10)',
- null => 'not null',
- key => '',
+ null => 'NOT NULL',
+ key => 'PRI',
default => '',
extra => '',
},
@@ -1625,9 +1631,9 @@
print "\r$totaldone / $totaltodo" unless ($totaldone % 100);
}
print "\rdone\n";
+#}
}
-
# at last, remove useless fields
foreach $table ( keys %uselessfields ) {
my @fields = split /,/,$uselessfields{$table};
@@ -1848,6 +1854,9 @@
exit;
# $Log: updatedatabase,v $
+# Revision 1.157.2.11 2006/10/18 13:31:13 toins
+# Borrowers.categorycode must have 10 chars lenght & categories.categorycode
must be a primary key.
+#
# Revision 1.157.2.10 2006/10/17 16:18:14 hdl
# Changing primary key in aqbookfund.
# Making it branchcode+aqbookfundid rather than simple aqbookfundid.
- [Koha-cvs] koha/updater updatedatabase [rel_3_0], paul poulain, 2006/10/11
- [Koha-cvs] koha/updater updatedatabase [rel_3_0], Antoine Farnault, 2006/10/16
- [Koha-cvs] koha/updater updatedatabase [rel_3_0], Antoine Farnault, 2006/10/16
- [Koha-cvs] koha/updater updatedatabase [rel_3_0],
Antoine Farnault <=
- [Koha-cvs] koha/updater updatedatabase [rel_3_0], Antoine Farnault, 2006/10/19
- [Koha-cvs] koha/updater updatedatabase [rel_3_0], Bruno Toumi, 2006/10/30
- [Koha-cvs] koha/updater updatedatabase [rel_3_0], Antoine Farnault, 2006/10/31