[Koha-cvs] koha C4/AuthoritiesMarc.pm C4/Context.pm catalo...
Joshua Ferraro
jmf at liblime.com
Fri Mar 16 02:25:10 CET 2007
CVSROOT: /sources/koha
Module name: koha
Changes by: Joshua Ferraro <kados> 07/03/16 01:25:09
Modified files:
C4 : AuthoritiesMarc.pm Context.pm
catalogue : search.pl
installer : kohastructure.sql
koha-tmpl/intranet-tmpl/prog/en/admin: authtypes.tmpl
koha-tmpl/intranet-tmpl/prog/en/authorities:
blinddetail-biblio-search.tmpl
koha-tmpl/intranet-tmpl/prog/en/includes: doc-head-close.inc
menu-circ.inc
menu-members.inc
menus.inc
koha-tmpl/intranet-tmpl/prog/en/members: member.tmpl
memberentryA.tmpl
memberentryC.tmpl
memberentryI.tmpl
memberentryP.tmpl
moremember.tmpl
members : member.pl
misc/sql-datas/en/mandatory: 05_sysprefs.sql
opac : opac-search.pl
updater : updatedatabase
Added files:
koha-tmpl/intranet-tmpl/prog/en/includes: calendar.inc
members.js
Log message:
Using my precrash CVS copy I did the following:
cvs -z3 -d:ext:kados at cvs.savannah.nongnu.org:/sources/koha co -P koha
find koha.precrash -type d -name "CVS" -exec rm -v {} \;
cp -r koha.precrash/* koha/
cd koha/
cvs commit
This should in theory put us right back where we were before the crash
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/AuthoritiesMarc.pm?cvsroot=koha&r1=1.38&r2=1.39
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Context.pm?cvsroot=koha&r1=1.51&r2=1.52
http://cvs.savannah.gnu.org/viewcvs/koha/catalogue/search.pl?cvsroot=koha&r1=1.2&r2=1.3
http://cvs.savannah.gnu.org/viewcvs/koha/installer/kohastructure.sql?cvsroot=koha&r1=1.2&r2=1.3
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/admin/authtypes.tmpl?cvsroot=koha&r1=1.3&r2=1.4
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/authorities/blinddetail-biblio-search.tmpl?cvsroot=koha&r1=1.2&r2=1.3
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/includes/doc-head-close.inc?cvsroot=koha&r1=1.3&r2=1.4
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/includes/menu-circ.inc?cvsroot=koha&r1=1.6&r2=1.7
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/includes/menu-members.inc?cvsroot=koha&r1=1.4&r2=1.5
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/includes/menus.inc?cvsroot=koha&r1=1.10&r2=1.11
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/includes/calendar.inc?cvsroot=koha&rev=1.1
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/includes/members.js?cvsroot=koha&rev=1.1
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/members/member.tmpl?cvsroot=koha&r1=1.7&r2=1.8
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/members/memberentryA.tmpl?cvsroot=koha&r1=1.17&r2=1.18
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/members/memberentryC.tmpl?cvsroot=koha&r1=1.16&r2=1.17
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/members/memberentryI.tmpl?cvsroot=koha&r1=1.12&r2=1.13
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/members/memberentryP.tmpl?cvsroot=koha&r1=1.13&r2=1.14
http://cvs.savannah.gnu.org/viewcvs/koha/koha-tmpl/intranet-tmpl/prog/en/members/moremember.tmpl?cvsroot=koha&r1=1.18&r2=1.19
http://cvs.savannah.gnu.org/viewcvs/koha/members/member.pl?cvsroot=koha&r1=1.14&r2=1.15
http://cvs.savannah.gnu.org/viewcvs/koha/misc/sql-datas/en/mandatory/05_sysprefs.sql?cvsroot=koha&r1=1.3&r2=1.4
http://cvs.savannah.gnu.org/viewcvs/koha/opac/opac-search.pl?cvsroot=koha&r1=1.39&r2=1.40
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&r1=1.158&r2=1.159
Patches:
Index: C4/AuthoritiesMarc.pm
===================================================================
RCS file: /sources/koha/koha/C4/AuthoritiesMarc.pm,v
retrieving revision 1.38
retrieving revision 1.39
diff -u -b -r1.38 -r1.39
--- C4/AuthoritiesMarc.pm 9 Mar 2007 14:31:47 -0000 1.38
+++ C4/AuthoritiesMarc.pm 16 Mar 2007 01:25:08 -0000 1.39
@@ -637,7 +637,7 @@
# warn "record :".$record->as_formatted." authtattoreport :$auth_tag_to_report";
# build a request for authoritysearch
my $query='at='.$authtypecode.' ';
- map {$query.= " and he=\"".$_->[1]."\"" if ($_->[0]=~/[A-z]/)} $record->field($auth_tag_to_report)->subfields();
+ map {$query.= " and he=\"".$_->[1]."\"" if ($_->[0]=~/[A-z]/)} $record->field($auth_tag_to_report)->subfields() if $record->field($auth_tag_to_report);
my ($error,$results)=SimpleSearch($query,"authorityserver");
# there is at least 1 result => return the 1st one
if (@$results>0) {
@@ -948,8 +948,22 @@
=cut
-# $Id: AuthoritiesMarc.pm,v 1.38 2007/03/09 14:31:47 tipaul Exp $
+# $Id: AuthoritiesMarc.pm,v 1.39 2007/03/16 01:25:08 kados Exp $
# $Log: AuthoritiesMarc.pm,v $
+# Revision 1.39 2007/03/16 01:25:08 kados
+# Using my precrash CVS copy I did the following:
+#
+# cvs -z3 -d:ext:kados at cvs.savannah.nongnu.org:/sources/koha co -P koha
+# find koha.precrash -type d -name "CVS" -exec rm -v {} \;
+# cp -r koha.precrash/* koha/
+# cd koha/
+# cvs commit
+#
+# This should in theory put us right back where we were before the crash
+#
+# Revision 1.39 2007/03/12 22:16:31 kados
+# chcking for field before calling subfields
+#
# Revision 1.38 2007/03/09 14:31:47 tipaul
# rel_3_0 moved to HEAD
#
Index: C4/Context.pm
===================================================================
RCS file: /sources/koha/koha/C4/Context.pm,v
retrieving revision 1.51
retrieving revision 1.52
diff -u -b -r1.51 -r1.52
--- C4/Context.pm 9 Mar 2007 14:31:47 -0000 1.51
+++ C4/Context.pm 16 Mar 2007 01:25:08 -0000 1.52
@@ -16,7 +16,7 @@
# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
# Suite 330, Boston, MA 02111-1307 USA
-# $Id: Context.pm,v 1.51 2007/03/09 14:31:47 tipaul Exp $
+# $Id: Context.pm,v 1.52 2007/03/16 01:25:08 kados Exp $
use strict;
use DBI;
use ZOOM;
@@ -28,7 +28,7 @@
qw($context),
qw(@context_stack);
-$VERSION = do { my @v = '$Revision: 1.51 $' =~ /\d+/g;
+$VERSION = do { my @v = '$Revision: 1.52 $' =~ /\d+/g;
shift(@v) . "." . join("_", map {sprintf "%03d", $_ } @v); };
=head1 NAME
@@ -138,7 +138,7 @@
sub read_config_file {
my $fname = shift; # Config file to read
my $retval = {}; # Return value: ref-to-hash holding the configuration
- my $koha = XMLin($fname, keyattr => ['id'],forcearray => ['listen']);
+ my $koha = XMLin($fname, keyattr => ['id'],forcearray => ['listen', 'server', 'serverinfo']);
return $koha;
}
@@ -874,6 +874,20 @@
=cut
# $Log: Context.pm,v $
+# Revision 1.52 2007/03/16 01:25:08 kados
+# Using my precrash CVS copy I did the following:
+#
+# cvs -z3 -d:ext:kados at cvs.savannah.nongnu.org:/sources/koha co -P koha
+# find koha.precrash -type d -name "CVS" -exec rm -v {} \;
+# cp -r koha.precrash/* koha/
+# cd koha/
+# cvs commit
+#
+# This should in theory put us right back where we were before the crash
+#
+# Revision 1.52 2007/03/12 21:17:05 rych
+# add server, serverinfo as arrays from config
+#
# Revision 1.51 2007/03/09 14:31:47 tipaul
# rel_3_0 moved to HEAD
#
Index: catalogue/search.pl
===================================================================
RCS file: /sources/koha/koha/catalogue/search.pl,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -b -r1.2 -r1.3
--- catalogue/search.pl 9 Mar 2007 15:35:46 -0000 1.2
+++ catalogue/search.pl 16 Mar 2007 01:25:08 -0000 1.3
@@ -2,7 +2,7 @@
# Script to perform searching
# For documentation try 'perldoc /path/to/search'
#
-# $Header: /sources/koha/koha/catalogue/search.pl,v 1.2 2007/03/09 15:35:46 tipaul Exp $
+# $Header: /sources/koha/koha/catalogue/search.pl,v 1.3 2007/03/16 01:25:08 kados Exp $
#
# Copyright 2006 LibLime
#
@@ -437,8 +437,10 @@
my $this_offset = (($j*$results_per_page)-$results_per_page);
my $this_page_number = $j;
my $highlight = 1 if ($this_page_number == $current_page_number);
+ if ($this_page_number <= $pages) {
push @page_numbers, { offset => $this_offset, pg => $this_page_number, highlight => $highlight, sort_by => join " ", at sort_by };
}
+ }
$template->param(PAGE_NUMBERS => \@page_numbers,
previous_page_offset => $previous_page_offset,
next_page_offset => $next_page_offset) unless $pages < 2;
Index: installer/kohastructure.sql
===================================================================
RCS file: /sources/koha/koha/installer/kohastructure.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -b -r1.2 -r1.3
--- installer/kohastructure.sql 9 Mar 2007 15:37:25 -0000 1.2
+++ installer/kohastructure.sql 16 Mar 2007 01:25:08 -0000 1.3
@@ -1,25 +1,38 @@
--- phpMyAdmin SQL Dump
--- version 2.9.0.2
--- http://www.phpmyadmin.net
+-- MySQL dump 10.11
--
--- Serveur: localhost
--- Généré le : Mardi 06 Février 2007 à 15:21
--- Version du serveur: 4.1.12
--- Version de PHP: 5.0.4
+-- Host: localhost Database: rel3_edit
+-- ------------------------------------------------------
+-- Server version 5.0.32-Debian_3-log
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+-- Koha Database Structure
+-- 3.0 pre-release
+-- March 2007
--
--- Base de données: `Kohazebratest`
+-- IMPORTANT:
+-- Turning off foreign key checks for import speed.
+-- If you edit this file, run it with foreign key checks ON before committing!
--
--- --------------------------------------------------------
+-- SET AUTOCOMMIT = 0;
+-- SET FOREIGN_KEY_CHECKS=0;
--
--- Structure de la table `accountlines`
---
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `accountlines`
--
DROP TABLE IF EXISTS `accountlines`;
-CREATE TABLE IF NOT EXISTS `accountlines` (
+CREATE TABLE `accountlines` (
`borrowernumber` int(11) NOT NULL default '0',
`accountno` smallint(6) NOT NULL default '0',
`itemnumber` int(11) default NULL,
@@ -34,19 +47,17 @@
`notify_level` int(2) NOT NULL default '0',
KEY `acctsborridx` (`borrowernumber`),
KEY `timeidx` (`timestamp`),
- KEY `itemnumber` (`itemnumber`)
+ KEY `itemnumber` (`itemnumber`),
+ CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
+ CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `accountoffsets`
--
--- Création: Lundi 27 Novembre 2006 à 17:56
+-- Table structure for table `accountoffsets`
--
DROP TABLE IF EXISTS `accountoffsets`;
-CREATE TABLE IF NOT EXISTS `accountoffsets` (
+CREATE TABLE `accountoffsets` (
`borrowernumber` int(11) NOT NULL default '0',
`accountno` smallint(6) NOT NULL default '0',
`offsetaccount` smallint(6) NOT NULL default '0',
@@ -54,16 +65,12 @@
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `action_logs`
--
--- Création: Lundi 27 Novembre 2006 à 17:56
+-- Table structure for table `action_logs`
--
DROP TABLE IF EXISTS `action_logs`;
-CREATE TABLE IF NOT EXISTS `action_logs` (
+CREATE TABLE `action_logs` (
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`user` int(11) NOT NULL default '0',
`module` text,
@@ -73,16 +80,12 @@
PRIMARY KEY (`timestamp`,`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `alert`
--
--- Création: Lundi 27 Novembre 2006 à 17:56
+-- Table structure for table `alert`
--
DROP TABLE IF EXISTS `alert`;
-CREATE TABLE IF NOT EXISTS `alert` (
+CREATE TABLE `alert` (
`alertid` int(11) NOT NULL auto_increment,
`borrowernumber` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default '',
@@ -92,16 +95,12 @@
KEY `type` (`type`,`externalid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `aqbasket`
--
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `aqbasket`
--
DROP TABLE IF EXISTS `aqbasket`;
-CREATE TABLE IF NOT EXISTS `aqbasket` (
+CREATE TABLE `aqbasket` (
`basketno` int(11) NOT NULL auto_increment,
`creationdate` date default NULL,
`closedate` date default NULL,
@@ -109,19 +108,16 @@
`authorisedby` varchar(10) default NULL,
`booksellerinvoicenumber` text,
PRIMARY KEY (`basketno`),
- KEY `booksellerid` (`booksellerid`)
+ KEY `booksellerid` (`booksellerid`),
+ CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `aqbookfund`
--
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `aqbookfund`
--
DROP TABLE IF EXISTS `aqbookfund`;
-CREATE TABLE IF NOT EXISTS `aqbookfund` (
+CREATE TABLE `aqbookfund` (
`bookfundid` varchar(5) NOT NULL default '''''',
`bookfundname` text,
`bookfundgroup` varchar(5) default NULL,
@@ -129,16 +125,12 @@
PRIMARY KEY (`bookfundid`,`branchcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `aqbooksellers`
--
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `aqbooksellers`
--
DROP TABLE IF EXISTS `aqbooksellers`;
-CREATE TABLE IF NOT EXISTS `aqbooksellers` (
+CREATE TABLE `aqbooksellers` (
`id` int(11) NOT NULL default '0',
`name` text,
`address1` text,
@@ -178,19 +170,17 @@
`invoicedisc` float(6,4) default NULL,
PRIMARY KEY (`id`),
KEY `listprice` (`listprice`),
- KEY `invoiceprice` (`invoiceprice`)
+ KEY `invoiceprice` (`invoiceprice`),
+ CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `aqbudget`
--
--- Création: Lundi 27 Novembre 2006 à 17:56
+-- Table structure for table `aqbudget`
--
DROP TABLE IF EXISTS `aqbudget`;
-CREATE TABLE IF NOT EXISTS `aqbudget` (
+CREATE TABLE `aqbudget` (
`bookfundid` varchar(5) NOT NULL default '',
`startdate` date NOT NULL default '0000-00-00',
`enddate` date default NULL,
@@ -200,35 +190,29 @@
PRIMARY KEY (`aqbudgetid`,`branchcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `aqorderbreakdown`
--
--- Création: Lundi 27 Novembre 2006 à 18:41
+-- Table structure for table `aqorderbreakdown`
--
DROP TABLE IF EXISTS `aqorderbreakdown`;
-CREATE TABLE IF NOT EXISTS `aqorderbreakdown` (
+CREATE TABLE `aqorderbreakdown` (
`ordernumber` int(11) default NULL,
`linenumber` int(11) default NULL,
`branchcode` char(4) default NULL,
`bookfundid` char(5) NOT NULL default '',
`allocation` smallint(6) default NULL,
KEY `ordernumber` (`ordernumber`),
- KEY `bookfundid` (`bookfundid`)
+ KEY `bookfundid` (`bookfundid`),
+ CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `aqorderdelivery`
--
--- Création: Lundi 27 Novembre 2006 à 17:56
+-- Table structure for table `aqorderdelivery`
--
DROP TABLE IF EXISTS `aqorderdelivery`;
-CREATE TABLE IF NOT EXISTS `aqorderdelivery` (
+CREATE TABLE `aqorderdelivery` (
`ordernumber` date NOT NULL default '0000-00-00',
`deliverynumber` smallint(6) NOT NULL default '0',
`deliverydate` varchar(18) default NULL,
@@ -236,16 +220,12 @@
`deliverycomments` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `aqorders`
--
--- Création: Lundi 27 Novembre 2006 à 18:41
+-- Table structure for table `aqorders`
--
DROP TABLE IF EXISTS `aqorders`;
-CREATE TABLE IF NOT EXISTS `aqorders` (
+CREATE TABLE `aqorders` (
`ordernumber` int(11) NOT NULL auto_increment,
`biblionumber` int(11) default NULL,
`title` text,
@@ -277,19 +257,17 @@
`sort2` varchar(80) default NULL,
PRIMARY KEY (`ordernumber`),
KEY `basketno` (`basketno`),
- KEY `biblionumber` (`biblionumber`)
+ KEY `biblionumber` (`biblionumber`),
+ CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL,
+ CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `auth_header`
--
--- Création: Lundi 27 Novembre 2006 à 17:56
+-- Table structure for table `auth_header`
--
DROP TABLE IF EXISTS `auth_header`;
-CREATE TABLE IF NOT EXISTS `auth_header` (
+CREATE TABLE `auth_header` (
`authid` bigint(20) unsigned NOT NULL auto_increment,
`authtypecode` varchar(10) NOT NULL default '',
`datecreated` date NOT NULL default '0000-00-00',
@@ -303,16 +281,12 @@
KEY `origincode` (`origincode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `auth_subfield_structure`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `auth_subfield_structure`
--
DROP TABLE IF EXISTS `auth_subfield_structure`;
-CREATE TABLE IF NOT EXISTS `auth_subfield_structure` (
+CREATE TABLE `auth_subfield_structure` (
`authtypecode` varchar(10) NOT NULL default '',
`tagfield` varchar(3) NOT NULL default '',
`tagsubfield` char(1) NOT NULL default '',
@@ -334,16 +308,12 @@
KEY `tab` (`authtypecode`,`tab`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `auth_subfield_table`
---
--- Création: Lundi 27 Novembre 2006 à 17:56
+-- Table structure for table `auth_subfield_table`
--
DROP TABLE IF EXISTS `auth_subfield_table`;
-CREATE TABLE IF NOT EXISTS `auth_subfield_table` (
+CREATE TABLE `auth_subfield_table` (
`subfieldid` bigint(20) unsigned NOT NULL auto_increment,
`authid` bigint(20) unsigned NOT NULL default '0',
`tag` varchar(3) NOT NULL default '',
@@ -359,16 +329,12 @@
KEY `subfieldvalue` (`subfieldvalue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `auth_tag_structure`
---
--- Création: Lundi 27 Novembre 2006 à 18:41
+-- Table structure for table `auth_tag_structure`
--
DROP TABLE IF EXISTS `auth_tag_structure`;
-CREATE TABLE IF NOT EXISTS `auth_tag_structure` (
+CREATE TABLE `auth_tag_structure` (
`authtypecode` char(10) NOT NULL default '',
`tagfield` char(3) NOT NULL default '',
`liblibrarian` char(255) NOT NULL default '',
@@ -376,19 +342,16 @@
`repeatable` tinyint(4) NOT NULL default '0',
`mandatory` tinyint(4) NOT NULL default '0',
`authorised_value` char(10) default NULL,
- PRIMARY KEY (`authtypecode`,`tagfield`)
+ PRIMARY KEY (`authtypecode`,`tagfield`),
+ CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `auth_types`
---
--- Création: Lundi 27 Novembre 2006 à 17:56
+-- Table structure for table `auth_types`
--
DROP TABLE IF EXISTS `auth_types`;
-CREATE TABLE IF NOT EXISTS `auth_types` (
+CREATE TABLE `auth_types` (
`authtypecode` varchar(10) NOT NULL default '',
`authtypetext` varchar(255) NOT NULL default '',
`auth_tag_to_report` varchar(3) NOT NULL default '',
@@ -396,16 +359,12 @@
PRIMARY KEY (`authtypecode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `auth_word`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `auth_word`
--
DROP TABLE IF EXISTS `auth_word`;
-CREATE TABLE IF NOT EXISTS `auth_word` (
+CREATE TABLE `auth_word` (
`authid` bigint(20) NOT NULL default '0',
`tagsubfield` varchar(4) NOT NULL default '',
`tagorder` tinyint(4) NOT NULL default '1',
@@ -418,16 +377,12 @@
KEY `sndx_word` (`sndx_word`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `authorised_values`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `authorised_values`
--
DROP TABLE IF EXISTS `authorised_values`;
-CREATE TABLE IF NOT EXISTS `authorised_values` (
+CREATE TABLE `authorised_values` (
`id` int(11) NOT NULL auto_increment,
`category` char(10) NOT NULL default '',
`authorised_value` char(80) NOT NULL default '',
@@ -436,16 +391,12 @@
KEY `name` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `biblio`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `biblio`
--
DROP TABLE IF EXISTS `biblio`;
-CREATE TABLE IF NOT EXISTS `biblio` (
+CREATE TABLE `biblio` (
`biblionumber` int(11) NOT NULL default '0',
`author` text,
`title` text,
@@ -461,52 +412,40 @@
KEY `blbnoidx` (`biblionumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `biblio_framework`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `biblio_framework`
--
DROP TABLE IF EXISTS `biblio_framework`;
-CREATE TABLE IF NOT EXISTS `biblio_framework` (
+CREATE TABLE `biblio_framework` (
`frameworkcode` char(4) NOT NULL default '',
`frameworktext` char(255) NOT NULL default '',
PRIMARY KEY (`frameworkcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `biblioanalysis`
--
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `biblioanalysis`
--
DROP TABLE IF EXISTS `biblioanalysis`;
-CREATE TABLE IF NOT EXISTS `biblioanalysis` (
+CREATE TABLE `biblioanalysis` (
`analyticaltitle` text,
`biblionumber` int(11) NOT NULL default '0',
`analyticalauthor` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `biblioitems`
--
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `biblioitems`
--
DROP TABLE IF EXISTS `biblioitems`;
-CREATE TABLE IF NOT EXISTS `biblioitems` (
+CREATE TABLE `biblioitems` (
`biblioitemnumber` int(11) NOT NULL default '0',
`biblionumber` int(11) NOT NULL default '0',
`volume` text,
`number` text,
`classification` varchar(25) default NULL,
- `itemtype` varchar(4) default NULL,
+ `itemtype` varchar(10) default NULL,
`isbn` varchar(14) default NULL,
`issn` varchar(9) default NULL,
`dewey` varchar(30) default '',
@@ -532,46 +471,17 @@
KEY `bibnoidx` (`biblionumber`),
KEY `itemtype` (`itemtype`),
KEY `isbn` (`isbn`),
- KEY `publishercode` (`publishercode`)
+ KEY `publishercode` (`publishercode`),
+ CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
--
--- Structure de la table `bibliothesaurus`
---
--- Création: Mercredi 04 Octobre 2006 à 23:21
--- Dernière modification: Mercredi 04 Octobre 2006 à 23:21
--- Dernière vérification: Mercredi 04 Octobre 2006 à 23:21
---
-
-DROP TABLE IF EXISTS `bibliothesaurus`;
-CREATE TABLE IF NOT EXISTS `bibliothesaurus` (
- `id` bigint(20) NOT NULL auto_increment,
- `freelib` char(255) NOT NULL default '',
- `stdlib` char(255) NOT NULL default '',
- `category` char(10) NOT NULL default '',
- `level` tinyint(4) NOT NULL default '1',
- `hierarchy` char(80) NOT NULL default '',
- `father` char(80) NOT NULL default '',
- PRIMARY KEY (`id`),
- KEY `freelib` (`freelib`),
- KEY `stdlib` (`stdlib`),
- KEY `category` (`category`),
- KEY `hierarchy` (`hierarchy`),
- KEY `category_2` (`category`,`freelib`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Structure de la table `bookshelf`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `bookshelf`
--
DROP TABLE IF EXISTS `bookshelf`;
-CREATE TABLE IF NOT EXISTS `bookshelf` (
+CREATE TABLE `bookshelf` (
`shelfnumber` int(11) NOT NULL auto_increment,
`shelfname` char(255) default NULL,
`owner` char(80) default NULL,
@@ -579,30 +489,22 @@
PRIMARY KEY (`shelfnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `borexp`
--
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `borexp`
--
DROP TABLE IF EXISTS `borexp`;
-CREATE TABLE IF NOT EXISTS `borexp` (
+CREATE TABLE `borexp` (
`borrowernumber` int(11) default NULL,
`newexp` date default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `borrowers`
--
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `borrowers`
--
DROP TABLE IF EXISTS `borrowers`;
-CREATE TABLE IF NOT EXISTS `borrowers` (
+CREATE TABLE `borrowers` (
`borrowernumber` int(11) NOT NULL auto_increment,
`cardnumber` varchar(16) NOT NULL default '',
`surname` text NOT NULL,
@@ -658,49 +560,39 @@
UNIQUE KEY `cardnumber` (`cardnumber`),
KEY `borrowernumber` (`borrowernumber`),
KEY `categorycode` (`categorycode`),
- KEY `branchcode` (`branchcode`)
+ KEY `branchcode` (`branchcode`),
+ CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`),
+ CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `borrowers_to_borrowers`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `borrowers_to_borrowers`
--
DROP TABLE IF EXISTS `borrowers_to_borrowers`;
-CREATE TABLE IF NOT EXISTS `borrowers_to_borrowers` (
+CREATE TABLE `borrowers_to_borrowers` (
`borrower1` int(11) default NULL,
`borrower2` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `branchcategories`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `branchcategories`
--
DROP TABLE IF EXISTS `branchcategories`;
-CREATE TABLE IF NOT EXISTS `branchcategories` (
+CREATE TABLE `branchcategories` (
`categorycode` varchar(4) NOT NULL default '',
`categoryname` text,
`codedescription` text,
PRIMARY KEY (`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `branches`
---
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `branches`
--
DROP TABLE IF EXISTS `branches`;
-CREATE TABLE IF NOT EXISTS `branches` (
+CREATE TABLE `branches` (
`branchcode` varchar(10) NOT NULL default '',
`branchname` text NOT NULL,
`branchaddress1` text,
@@ -715,30 +607,22 @@
UNIQUE KEY `branchcode` (`branchcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `branchrelations`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `branchrelations`
--
DROP TABLE IF EXISTS `branchrelations`;
-CREATE TABLE IF NOT EXISTS `branchrelations` (
+CREATE TABLE `branchrelations` (
`branchcode` varchar(4) default NULL,
`categorycode` varchar(4) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `branchtransfers`
---
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `branchtransfers`
--
DROP TABLE IF EXISTS `branchtransfers`;
-CREATE TABLE IF NOT EXISTS `branchtransfers` (
+CREATE TABLE `branchtransfers` (
`itemnumber` int(11) NOT NULL default '0',
`datesent` datetime default NULL,
`frombranch` varchar(10) NOT NULL default '',
@@ -747,19 +631,18 @@
`comments` text,
KEY `frombranch` (`frombranch`),
KEY `tobranch` (`tobranch`),
- KEY `itemnumber` (`itemnumber`)
+ KEY `itemnumber` (`itemnumber`),
+ CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `catalogueentry`
--
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `catalogueentry`
--
DROP TABLE IF EXISTS `catalogueentry`;
-CREATE TABLE IF NOT EXISTS `catalogueentry` (
+CREATE TABLE `catalogueentry` (
`catalogueentry` text NOT NULL,
`entrytype` varchar(2) default NULL,
`see` text,
@@ -768,16 +651,12 @@
`biblionumber` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `categories`
--
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `categories`
--
DROP TABLE IF EXISTS `categories`;
-CREATE TABLE IF NOT EXISTS `categories` (
+CREATE TABLE `categories` (
`categorycode` varchar(10) NOT NULL default '',
`description` text,
`enrolmentperiod` smallint(6) default NULL,
@@ -794,32 +673,24 @@
UNIQUE KEY `categorycode` (`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `categorytable`
--
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `categorytable`
--
DROP TABLE IF EXISTS `categorytable`;
-CREATE TABLE IF NOT EXISTS `categorytable` (
+CREATE TABLE `categorytable` (
`categorycode` varchar(5) NOT NULL default '',
`description` text,
`itemtypecodes` text,
PRIMARY KEY (`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `charges`
--
--- Création: Vendredi 08 Décembre 2006 à 16:47
+-- Table structure for table `charges`
--
DROP TABLE IF EXISTS `charges`;
-CREATE TABLE IF NOT EXISTS `charges` (
+CREATE TABLE `charges` (
`charge_id` varchar(5) NOT NULL default '',
`description` text NOT NULL,
`amount` decimal(28,6) NOT NULL default '0.000000',
@@ -829,47 +700,35 @@
PRIMARY KEY (`charge_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `cities`
--
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `cities`
--
DROP TABLE IF EXISTS `cities`;
-CREATE TABLE IF NOT EXISTS `cities` (
+CREATE TABLE `cities` (
`cityid` int(11) NOT NULL auto_increment,
`city_name` char(100) NOT NULL default '',
`city_zipcode` char(20) default NULL,
PRIMARY KEY (`cityid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `currency`
--
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `currency`
--
DROP TABLE IF EXISTS `currency`;
-CREATE TABLE IF NOT EXISTS `currency` (
+CREATE TABLE `currency` (
`currency` varchar(10) NOT NULL default '',
`rate` float(7,5) default NULL,
PRIMARY KEY (`currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `deletedbiblio`
--
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `deletedbiblio`
--
DROP TABLE IF EXISTS `deletedbiblio`;
-CREATE TABLE IF NOT EXISTS `deletedbiblio` (
+CREATE TABLE `deletedbiblio` (
`biblionumber` int(11) NOT NULL default '0',
`author` text,
`title` text,
@@ -886,22 +745,18 @@
KEY `blbnoidx` (`biblionumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `deletedbiblioitems`
--
--- Création: Lundi 27 Novembre 2006 à 18:40
+-- Table structure for table `deletedbiblioitems`
--
DROP TABLE IF EXISTS `deletedbiblioitems`;
-CREATE TABLE IF NOT EXISTS `deletedbiblioitems` (
+CREATE TABLE `deletedbiblioitems` (
`biblioitemnumber` int(11) NOT NULL default '0',
`biblionumber` int(11) NOT NULL default '0',
`volume` text,
`number` text,
`classification` varchar(25) default NULL,
- `itemtype` varchar(4) default NULL,
+ `itemtype` varchar(10) default NULL,
`isbn` varchar(14) default NULL,
`issn` varchar(9) default NULL,
`dewey` double(8,6) default NULL,
@@ -927,16 +782,12 @@
KEY `bibnoidx` (`biblionumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `deletedborrowers`
---
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `deletedborrowers`
--
DROP TABLE IF EXISTS `deletedborrowers`;
-CREATE TABLE IF NOT EXISTS `deletedborrowers` (
+CREATE TABLE `deletedborrowers` (
`borrowernumber` int(11) NOT NULL default '0',
`cardnumber` varchar(9) NOT NULL default '',
`surname` text NOT NULL,
@@ -965,7 +816,7 @@
`B_phone` text,
`dateofbirth` date default NULL,
`branchcode` varchar(4) NOT NULL default '',
- `categorycode` varchar(2) default NULL,
+ `categorycode` varchar(10) default NULL,
`dateenrolled` date default NULL,
`dateexpiry` date default NULL,
`gonenoaddress` tinyint(1) default NULL,
@@ -995,16 +846,12 @@
KEY `branchcode` (`branchcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `deleteditems`
---
--- Création: Lundi 27 Novembre 2006 à 18:40
+-- Table structure for table `deleteditems`
--
DROP TABLE IF EXISTS `deleteditems`;
-CREATE TABLE IF NOT EXISTS `deleteditems` (
+CREATE TABLE `deleteditems` (
`itemnumber` int(11) NOT NULL default '0',
`biblionumber` int(11) NOT NULL default '0',
`multivolumepart` varchar(30) default NULL,
@@ -1048,31 +895,23 @@
KEY `itembibnoidx` (`biblionumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `ethnicity`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `ethnicity`
--
DROP TABLE IF EXISTS `ethnicity`;
-CREATE TABLE IF NOT EXISTS `ethnicity` (
+CREATE TABLE `ethnicity` (
`code` varchar(10) NOT NULL default '',
`name` varchar(255) default NULL,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `issues`
---
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `issues`
--
DROP TABLE IF EXISTS `issues`;
-CREATE TABLE IF NOT EXISTS `issues` (
+CREATE TABLE `issues` (
`borrowernumber` int(11) default '0',
`itemnumber` int(11) default '0',
`date_due` date default NULL,
@@ -1086,21 +925,19 @@
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
KEY `issuesborridx` (`borrowernumber`),
KEY `issuesitemidx` (`itemnumber`),
- KEY `bordate` (`borrowernumber`,`timestamp`)
+ KEY `bordate` (`borrowernumber`,`timestamp`),
+ CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
+ CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `issuingrules`
---
--- Création: Lundi 27 Novembre 2006 à 18:41
+-- Table structure for table `issuingrules`
--
DROP TABLE IF EXISTS `issuingrules`;
-CREATE TABLE IF NOT EXISTS `issuingrules` (
- `categorycode` varchar(2) NOT NULL default '',
- `itemtype` varchar(4) NOT NULL default '',
+CREATE TABLE `issuingrules` (
+ `categorycode` varchar(10) NOT NULL default '',
+ `itemtype` varchar(10) NOT NULL default '',
`restrictedtype` tinyint(1) default NULL,
`rentaldiscount` decimal(28,6) default NULL,
`reservecharge` decimal(28,6) default NULL,
@@ -1114,19 +951,17 @@
`branchcode` varchar(4) NOT NULL default '',
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
KEY `categorycode` (`categorycode`),
- KEY `itemtype` (`itemtype`)
+ KEY `itemtype` (`itemtype`),
+ CONSTRAINT `issuingrules_ibfk_2` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `issuingrules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `items`
--
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `items`
--
DROP TABLE IF EXISTS `items`;
-CREATE TABLE IF NOT EXISTS `items` (
+CREATE TABLE `items` (
`itemnumber` int(11) NOT NULL default '0',
`biblionumber` int(11) NOT NULL default '0',
`multivolumepart` varchar(30) default NULL,
@@ -1165,34 +1000,28 @@
KEY `itembinoidx` (`biblioitemnumber`),
KEY `itembibnoidx` (`biblionumber`),
KEY `homebranch` (`homebranch`),
- KEY `holdingbranch` (`holdingbranch`)
+ KEY `holdingbranch` (`holdingbranch`),
+ CONSTRAINT `items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
+ CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `itemsprices`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `itemsprices`
--
DROP TABLE IF EXISTS `itemsprices`;
-CREATE TABLE IF NOT EXISTS `itemsprices` (
+CREATE TABLE `itemsprices` (
`itemnumber` int(11) default NULL,
`price1` decimal(28,6) default NULL,
`price2` decimal(28,6) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `itemtypes`
---
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `itemtypes`
--
DROP TABLE IF EXISTS `itemtypes`;
-CREATE TABLE IF NOT EXISTS `itemtypes` (
+CREATE TABLE `itemtypes` (
`itemtype` varchar(10) NOT NULL default '',
`description` text,
`renewalsallowed` smallint(6) default NULL,
@@ -1204,32 +1033,24 @@
UNIQUE KEY `itemtype` (`itemtype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `labels`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `labels`
--
DROP TABLE IF EXISTS `labels`;
-CREATE TABLE IF NOT EXISTS `labels` (
+CREATE TABLE `labels` (
`labelid` int(11) NOT NULL auto_increment,
`itemnumber` varchar(100) NOT NULL default '',
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`labelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `labels_conf`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `labels_conf`
--
DROP TABLE IF EXISTS `labels_conf`;
-CREATE TABLE IF NOT EXISTS `labels_conf` (
+CREATE TABLE `labels_conf` (
`id` int(4) NOT NULL auto_increment,
`barcodetype` char(100) default '',
`title` tinyint(1) default '0',
@@ -1244,16 +1065,12 @@
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `letter`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `letter`
--
DROP TABLE IF EXISTS `letter`;
-CREATE TABLE IF NOT EXISTS `letter` (
+CREATE TABLE `letter` (
`module` varchar(20) NOT NULL default '',
`code` varchar(20) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
@@ -1262,16 +1079,12 @@
PRIMARY KEY (`module`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `marc_biblio`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `marc_biblio`
--
DROP TABLE IF EXISTS `marc_biblio`;
-CREATE TABLE IF NOT EXISTS `marc_biblio` (
+CREATE TABLE `marc_biblio` (
`bibid` bigint(20) unsigned NOT NULL auto_increment,
`biblionumber` int(11) NOT NULL default '0',
`datecreated` date NOT NULL default '0000-00-00',
@@ -1283,31 +1096,23 @@
KEY `biblionumber` (`biblionumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `marc_blob_subfield`
---
--- Création: Lundi 27 Novembre 2006 à 17:57
+-- Table structure for table `marc_blob_subfield`
--
DROP TABLE IF EXISTS `marc_blob_subfield`;
-CREATE TABLE IF NOT EXISTS `marc_blob_subfield` (
+CREATE TABLE `marc_blob_subfield` (
`blobidlink` bigint(20) NOT NULL auto_increment,
`subfieldvalue` longtext NOT NULL,
PRIMARY KEY (`blobidlink`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `marc_breeding`
--
--- Création: Lundi 27 Novembre 2006 à 17:58
+-- Table structure for table `marc_breeding`
--
DROP TABLE IF EXISTS `marc_breeding`;
-CREATE TABLE IF NOT EXISTS `marc_breeding` (
+CREATE TABLE `marc_breeding` (
`id` bigint(20) NOT NULL auto_increment,
`file` varchar(80) NOT NULL default '',
`isbn` varchar(10) NOT NULL default '',
@@ -1321,16 +1126,12 @@
KEY `isbn` (`isbn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `marc_subfield_structure`
--
--- Création: Lundi 27 Novembre 2006 à 17:58
+-- Table structure for table `marc_subfield_structure`
--
DROP TABLE IF EXISTS `marc_subfield_structure`;
-CREATE TABLE IF NOT EXISTS `marc_subfield_structure` (
+CREATE TABLE `marc_subfield_structure` (
`tagfield` varchar(3) NOT NULL default '',
`tagsubfield` char(1) NOT NULL default '',
`liblibrarian` varchar(255) NOT NULL default '',
@@ -1352,16 +1153,12 @@
KEY `kohafield` (`frameworkcode`,`kohafield`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `marc_subfield_table`
--
--- Création: Lundi 27 Novembre 2006 à 18:11
+-- Table structure for table `marc_subfield_table`
--
DROP TABLE IF EXISTS `marc_subfield_table`;
-CREATE TABLE IF NOT EXISTS `marc_subfield_table` (
+CREATE TABLE `marc_subfield_table` (
`subfieldid` bigint(20) unsigned NOT NULL auto_increment,
`bibid` bigint(20) unsigned NOT NULL default '0',
`tag` varchar(3) NOT NULL default '',
@@ -1381,16 +1178,12 @@
KEY `tagorder` (`tagorder`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `marc_tag_structure`
--
--- Création: Lundi 27 Novembre 2006 à 18:11
+-- Table structure for table `marc_tag_structure`
--
DROP TABLE IF EXISTS `marc_tag_structure`;
-CREATE TABLE IF NOT EXISTS `marc_tag_structure` (
+CREATE TABLE `marc_tag_structure` (
`tagfield` char(3) NOT NULL default '',
`liblibrarian` char(255) NOT NULL default '',
`libopac` char(255) NOT NULL default '',
@@ -1401,16 +1194,12 @@
PRIMARY KEY (`frameworkcode`,`tagfield`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `marc_word`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `marc_word`
--
DROP TABLE IF EXISTS `marc_word`;
-CREATE TABLE IF NOT EXISTS `marc_word` (
+CREATE TABLE `marc_word` (
`bibid` bigint(20) NOT NULL default '0',
`tagsubfield` varchar(4) NOT NULL default '',
`tagorder` tinyint(4) NOT NULL default '1',
@@ -1425,48 +1214,36 @@
KEY `Search_Marc` (`tagsubfield`,`word`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `marcrecorddone`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `marcrecorddone`
--
DROP TABLE IF EXISTS `marcrecorddone`;
-CREATE TABLE IF NOT EXISTS `marcrecorddone` (
+CREATE TABLE `marcrecorddone` (
`isbn` char(40) default NULL,
`issn` char(40) default NULL,
`lccn` char(40) default NULL,
`controlnumber` char(40) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `mediatypetable`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `mediatypetable`
--
DROP TABLE IF EXISTS `mediatypetable`;
-CREATE TABLE IF NOT EXISTS `mediatypetable` (
+CREATE TABLE `mediatypetable` (
`mediatypecode` varchar(5) NOT NULL default '',
`description` text,
`itemtypecodes` text,
PRIMARY KEY (`mediatypecode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `notifys`
--
--- Création: Vendredi 08 Décembre 2006 à 16:47
+-- Table structure for table `notifys`
--
DROP TABLE IF EXISTS `notifys`;
-CREATE TABLE IF NOT EXISTS `notifys` (
+CREATE TABLE `notifys` (
`notify_id` int(11) NOT NULL default '0',
`borrowernumber` int(11) NOT NULL default '0',
`itemnumber` int(11) NOT NULL default '0',
@@ -1476,16 +1253,12 @@
`method` varchar(20) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `opac_news`
--
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `opac_news`
--
DROP TABLE IF EXISTS `opac_news`;
-CREATE TABLE IF NOT EXISTS `opac_news` (
+CREATE TABLE `opac_news` (
`idnew` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`new` text NOT NULL,
@@ -1496,18 +1269,14 @@
PRIMARY KEY (`idnew`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `overduerules`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `overduerules`
--
DROP TABLE IF EXISTS `overduerules`;
-CREATE TABLE IF NOT EXISTS `overduerules` (
+CREATE TABLE `overduerules` (
`branchcode` varchar(255) NOT NULL default '',
- `categorycode` varchar(2) NOT NULL default '',
+ `categorycode` varchar(10) NOT NULL default '',
`delay1` int(4) default '0',
`letter1` varchar(20) default NULL,
`debarred1` char(1) default '0',
@@ -1520,16 +1289,12 @@
PRIMARY KEY (`branchcode`,`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `phrase_log`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `phrase_log`
--
DROP TABLE IF EXISTS `phrase_log`;
-CREATE TABLE IF NOT EXISTS `phrase_log` (
+CREATE TABLE `phrase_log` (
`phr_phrase` varchar(100) NOT NULL default '',
`phr_resultcount` int(11) NOT NULL default '0',
`phr_ip` varchar(30) NOT NULL default '',
@@ -1539,32 +1304,24 @@
KEY `phr_ip` (`phr_ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `printers`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `printers`
--
DROP TABLE IF EXISTS `printers`;
-CREATE TABLE IF NOT EXISTS `printers` (
+CREATE TABLE `printers` (
`printername` char(40) NOT NULL default '''''',
`printqueue` char(20) default NULL,
`printtype` char(20) default NULL,
PRIMARY KEY (`printername`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `repeatable_holidays`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `repeatable_holidays`
--
DROP TABLE IF EXISTS `repeatable_holidays`;
-CREATE TABLE IF NOT EXISTS `repeatable_holidays` (
+CREATE TABLE `repeatable_holidays` (
`id` int(11) NOT NULL auto_increment,
`branchcode` varchar(4) NOT NULL default '',
`weekday` smallint(6) default NULL,
@@ -1575,16 +1332,12 @@
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `reserveconstraints`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `reserveconstraints`
--
DROP TABLE IF EXISTS `reserveconstraints`;
-CREATE TABLE IF NOT EXISTS `reserveconstraints` (
+CREATE TABLE `reserveconstraints` (
`borrowernumber` int(11) NOT NULL default '0',
`reservedate` date NOT NULL default '0000-00-00',
`biblionumber` int(11) NOT NULL default '0',
@@ -1592,16 +1345,12 @@
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `reserves`
---
--- Création: Lundi 27 Novembre 2006 à 18:41
+-- Table structure for table `reserves`
--
DROP TABLE IF EXISTS `reserves`;
-CREATE TABLE IF NOT EXISTS `reserves` (
+CREATE TABLE `reserves` (
`borrowernumber` int(11) NOT NULL default '0',
`reservedate` date NOT NULL default '0000-00-00',
`biblionumber` int(11) NOT NULL default '0',
@@ -1619,19 +1368,19 @@
KEY `borrowernumber` (`borrowernumber`),
KEY `biblionumber` (`biblionumber`),
KEY `itemnumber` (`itemnumber`),
- KEY `branchcode` (`branchcode`)
+ KEY `branchcode` (`branchcode`),
+ CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `reviews`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `reviews`
--
DROP TABLE IF EXISTS `reviews`;
-CREATE TABLE IF NOT EXISTS `reviews` (
+CREATE TABLE `reviews` (
`reviewid` int(11) NOT NULL auto_increment,
`borrowernumber` int(11) default NULL,
`biblionumber` int(11) default NULL,
@@ -1641,31 +1390,23 @@
PRIMARY KEY (`reviewid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `roadtype`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `roadtype`
--
DROP TABLE IF EXISTS `roadtype`;
-CREATE TABLE IF NOT EXISTS `roadtype` (
+CREATE TABLE `roadtype` (
`roadtypeid` int(11) NOT NULL auto_increment,
`road_type` char(100) NOT NULL default '',
PRIMARY KEY (`roadtypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `serial`
---
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `serial`
--
DROP TABLE IF EXISTS `serial`;
-CREATE TABLE IF NOT EXISTS `serial` (
+CREATE TABLE `serial` (
`serialid` int(11) NOT NULL auto_increment,
`biblionumber` varchar(100) NOT NULL default '',
`subscriptionid` varchar(100) NOT NULL default '',
@@ -1680,32 +1421,24 @@
PRIMARY KEY (`serialid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `sessionqueries`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `sessionqueries`
--
DROP TABLE IF EXISTS `sessionqueries`;
-CREATE TABLE IF NOT EXISTS `sessionqueries` (
+CREATE TABLE `sessionqueries` (
`sessionID` varchar(255) NOT NULL default '',
`userid` varchar(100) NOT NULL default '',
`ip` varchar(18) NOT NULL default '',
`url` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `sessions`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `sessions`
--
DROP TABLE IF EXISTS `sessions`;
-CREATE TABLE IF NOT EXISTS `sessions` (
+CREATE TABLE `sessions` (
`sessionID` varchar(255) NOT NULL default '',
`userid` varchar(255) default NULL,
`ip` varchar(16) default NULL,
@@ -1713,34 +1446,28 @@
PRIMARY KEY (`sessionID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `shelfcontents`
---
--- Création: Lundi 27 Novembre 2006 à 18:41
+-- Table structure for table `shelfcontents`
--
DROP TABLE IF EXISTS `shelfcontents`;
-CREATE TABLE IF NOT EXISTS `shelfcontents` (
+CREATE TABLE `shelfcontents` (
`shelfnumber` int(11) NOT NULL default '0',
`itemnumber` int(11) NOT NULL default '0',
`flags` int(11) default NULL,
`dateadded` timestamp NULL default NULL,
KEY `shelfnumber` (`shelfnumber`),
- KEY `itemnumber` (`itemnumber`)
+ KEY `itemnumber` (`itemnumber`),
+ CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `shelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `bookshelf` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `special_holidays`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `special_holidays`
--
DROP TABLE IF EXISTS `special_holidays`;
-CREATE TABLE IF NOT EXISTS `special_holidays` (
+CREATE TABLE `special_holidays` (
`id` int(11) NOT NULL auto_increment,
`branchcode` varchar(4) NOT NULL default '',
`day` smallint(6) NOT NULL default '0',
@@ -1752,16 +1479,12 @@
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `statistics`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `statistics`
--
DROP TABLE IF EXISTS `statistics`;
-CREATE TABLE IF NOT EXISTS `statistics` (
+CREATE TABLE `statistics` (
`datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`branch` varchar(4) default NULL,
`proccode` varchar(4) default NULL,
@@ -1770,51 +1493,39 @@
`other` text,
`usercode` varchar(10) default NULL,
`itemnumber` int(11) default NULL,
- `itemtype` varchar(4) default NULL,
+ `itemtype` varchar(10) default NULL,
`borrowernumber` int(11) default NULL,
`associatedborrower` int(11) default NULL,
KEY `timeidx` (`datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `stopwords`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `stopwords`
--
DROP TABLE IF EXISTS `stopwords`;
-CREATE TABLE IF NOT EXISTS `stopwords` (
+CREATE TABLE `stopwords` (
`word` varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `subcategorytable`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `subcategorytable`
--
DROP TABLE IF EXISTS `subcategorytable`;
-CREATE TABLE IF NOT EXISTS `subcategorytable` (
+CREATE TABLE `subcategorytable` (
`subcategorycode` varchar(5) NOT NULL default '',
`description` text,
`itemtypecodes` text,
PRIMARY KEY (`subcategorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `subscription`
---
--- Création: Vendredi 26 Janvier 2007 à 12:44
+-- Table structure for table `subscription`
--
DROP TABLE IF EXISTS `subscription`;
-CREATE TABLE IF NOT EXISTS `subscription` (
+CREATE TABLE `subscription` (
`biblionumber` int(11) NOT NULL default '0',
`manualhistory` tinyint(1) NOT NULL default '0',
`subscriptionid` int(11) NOT NULL auto_increment,
@@ -1862,16 +1573,12 @@
PRIMARY KEY (`subscriptionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `subscriptionhistory`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `subscriptionhistory`
--
DROP TABLE IF EXISTS `subscriptionhistory`;
-CREATE TABLE IF NOT EXISTS `subscriptionhistory` (
+CREATE TABLE `subscriptionhistory` (
`biblionumber` int(11) NOT NULL default '0',
`subscriptionid` int(11) NOT NULL default '0',
`histstartdate` date NOT NULL default '0000-00-00',
@@ -1884,16 +1591,12 @@
KEY `biblionumber` (`biblionumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `subscriptionroutinglist`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `subscriptionroutinglist`
--
DROP TABLE IF EXISTS `subscriptionroutinglist`;
-CREATE TABLE IF NOT EXISTS `subscriptionroutinglist` (
+CREATE TABLE `subscriptionroutinglist` (
`routingid` int(11) NOT NULL auto_increment,
`borrowernumber` int(11) default NULL,
`ranking` int(11) default NULL,
@@ -1901,16 +1604,12 @@
PRIMARY KEY (`routingid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `suggestions`
---
--- Création: Lundi 27 Novembre 2006 à 18:40
+-- Table structure for table `suggestions`
--
DROP TABLE IF EXISTS `suggestions`;
-CREATE TABLE IF NOT EXISTS `suggestions` (
+CREATE TABLE `suggestions` (
`suggestionid` int(8) NOT NULL auto_increment,
`suggestedby` int(11) NOT NULL default '0',
`managedby` int(11) default NULL,
@@ -1933,16 +1632,12 @@
KEY `managedby` (`managedby`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `systempreferences`
--
--- Création: Lundi 27 Novembre 2006 à 18:40
+-- Table structure for table `systempreferences`
--
DROP TABLE IF EXISTS `systempreferences`;
-CREATE TABLE IF NOT EXISTS `systempreferences` (
+CREATE TABLE `systempreferences` (
`variable` varchar(50) NOT NULL default '',
`value` text,
`options` text,
@@ -1951,31 +1646,23 @@
PRIMARY KEY (`variable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `tags`
--
--- Création: Mardi 06 Février 2007 à 11:14
+-- Table structure for table `tags`
--
DROP TABLE IF EXISTS `tags`;
-CREATE TABLE IF NOT EXISTS `tags` (
+CREATE TABLE `tags` (
`entry` varchar(255) NOT NULL default '',
`weight` bigint(20) NOT NULL default '0',
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `uploadedmarc`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `uploadedmarc`
--
DROP TABLE IF EXISTS `uploadedmarc`;
-CREATE TABLE IF NOT EXISTS `uploadedmarc` (
+CREATE TABLE `uploadedmarc` (
`id` int(11) NOT NULL auto_increment,
`marc` longblob,
`hidden` smallint(6) default NULL,
@@ -1983,48 +1670,36 @@
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `userflags`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `userflags`
--
DROP TABLE IF EXISTS `userflags`;
-CREATE TABLE IF NOT EXISTS `userflags` (
+CREATE TABLE `userflags` (
`bit` int(11) NOT NULL default '0',
`flag` char(30) default NULL,
`flagdesc` char(255) default NULL,
`defaulton` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `users`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
-CREATE TABLE IF NOT EXISTS `users` (
+CREATE TABLE `users` (
`usercode` varchar(10) default NULL,
`username` text,
`password` text,
`level` smallint(6) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `websites`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `websites`
--
DROP TABLE IF EXISTS `websites`;
-CREATE TABLE IF NOT EXISTS `websites` (
+CREATE TABLE `websites` (
`websitenumber` int(11) NOT NULL auto_increment,
`biblionumber` int(11) NOT NULL default '0',
`title` text,
@@ -2033,16 +1708,12 @@
PRIMARY KEY (`websitenumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `z3950queue`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `z3950queue`
--
DROP TABLE IF EXISTS `z3950queue`;
-CREATE TABLE IF NOT EXISTS `z3950queue` (
+CREATE TABLE `z3950queue` (
`id` int(11) NOT NULL auto_increment,
`term` text,
`type` varchar(10) default NULL,
@@ -2056,16 +1727,12 @@
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
---
--- Structure de la table `z3950results`
--
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `z3950results`
--
DROP TABLE IF EXISTS `z3950results`;
-CREATE TABLE IF NOT EXISTS `z3950results` (
+CREATE TABLE `z3950results` (
`id` int(11) NOT NULL auto_increment,
`queryid` int(11) default NULL,
`server` varchar(255) default NULL,
@@ -2080,16 +1747,12 @@
UNIQUE KEY `query_server` (`queryid`,`server`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `z3950servers`
---
--- Création: Lundi 27 Novembre 2006 à 18:39
+-- Table structure for table `z3950servers`
--
DROP TABLE IF EXISTS `z3950servers`;
-CREATE TABLE IF NOT EXISTS `z3950servers` (
+CREATE TABLE `z3950servers` (
`host` varchar(255) default NULL,
`port` int(11) default NULL,
`db` varchar(255) default NULL,
@@ -2107,16 +1770,12 @@
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- --------------------------------------------------------
-
--
--- Structure de la table `zebraqueue`
---
--- Création: Mardi 16 Janvier 2007 à 14:19
+-- Table structure for table `zebraqueue`
--
DROP TABLE IF EXISTS `zebraqueue`;
-CREATE TABLE IF NOT EXISTS `zebraqueue` (
+CREATE TABLE `zebraqueue` (
`id` int(11) NOT NULL auto_increment,
`biblio_auth_number` int(11) NOT NULL default '0',
`operation` char(20) NOT NULL default '',
@@ -2124,118 +1783,18 @@
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
--- Contraintes pour les tables exportées
---
-
---
--- Contraintes pour la table `accountlines`
---
-ALTER TABLE `accountlines`
- ADD CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `accountlines`
- ADD CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL;
-
---
--- Contraintes pour la table `aqbasket`
---
-ALTER TABLE `aqbasket`
- ADD CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE;
-
---
--- Contraintes pour la table `aqbooksellers`
---
-ALTER TABLE `aqbooksellers`
- ADD CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `aqbooksellers`
- ADD CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE;
-
---
--- Contraintes pour la table `aqorderbreakdown`
---
-ALTER TABLE `aqorderbreakdown`
- ADD CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `aqorderbreakdown`
- ADD CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE;
-
---
--- Contraintes pour la table `aqorders`
---
-ALTER TABLE `aqorders`
- ADD CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `aqorders`
- ADD CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL;
-
---
--- Contraintes pour la table `auth_tag_structure`
---
-ALTER TABLE `auth_tag_structure`
- ADD CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE;
-
---
--- Contraintes pour la table `biblioitems`
---
-ALTER TABLE `biblioitems`
- ADD CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE;
-
---
--- Contraintes pour la table `borrowers`
---
-ALTER TABLE `borrowers`
- ADD CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`);
-ALTER TABLE `borrowers`
- ADD CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`);
-
---
--- Contraintes pour la table `branchtransfers`
---
-ALTER TABLE `branchtransfers`
- ADD CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `branchtransfers`
- ADD CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `branchtransfers`
- ADD CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
-
---
--- Contraintes pour la table `issues`
---
-ALTER TABLE `issues`
- ADD CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL;
-ALTER TABLE `issues`
- ADD CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL;
---
--- Contraintes pour la table `issuingrules`
---
-ALTER TABLE `issuingrules`
- ADD CONSTRAINT `issuingrules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `issuingrules`
- ADD CONSTRAINT `issuingrules_ibfk_2` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE;
+-- SET FOREIGN_KEY_CHECKS = 1;
+-- COMMIT;
+-- SET AUTOCOMMIT = 1;
+
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
---
--- Contraintes pour la table `items`
---
-ALTER TABLE `items`
- ADD CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `items`
- ADD CONSTRAINT `items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE;
-
---
--- Contraintes pour la table `reserves`
---
-ALTER TABLE `reserves`
- ADD CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `reserves`
- ADD CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `reserves`
- ADD CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `reserves`
- ADD CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
-
---
--- Contraintes pour la table `shelfcontents`
---
-ALTER TABLE `shelfcontents`
- ADD CONSTRAINT `shelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `bookshelf` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE `shelfcontents`
- ADD CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
+-- Dump completed on 2007-03-12 16:24:34
Index: koha-tmpl/intranet-tmpl/prog/en/admin/authtypes.tmpl
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/admin/authtypes.tmpl,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -b -r1.3 -r1.4
--- koha-tmpl/intranet-tmpl/prog/en/admin/authtypes.tmpl 11 Mar 2007 21:08:12 -0000 1.3
+++ koha-tmpl/intranet-tmpl/prog/en/admin/authtypes.tmpl 16 Mar 2007 01:25:08 -0000 1.4
@@ -120,15 +120,6 @@
<th>Edit</th>
<th>Delete</th>
</tr>
- <tr>
- <td> </td>
- <td>Default framework</td>
- <td> </td>
- <td> </td>
- <td><a href="auth_tag_structure.pl">MARC structure</td>
- <td> </td>
- <td> </td>
- </tr>
<!-- TMPL_LOOP NAME="loop" -->
<tr>
Index: koha-tmpl/intranet-tmpl/prog/en/authorities/blinddetail-biblio-search.tmpl
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/authorities/blinddetail-biblio-search.tmpl,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -b -r1.2 -r1.3
--- koha-tmpl/intranet-tmpl/prog/en/authorities/blinddetail-biblio-search.tmpl 9 Mar 2007 14:47:38 -0000 1.2
+++ koha-tmpl/intranet-tmpl/prog/en/authorities/blinddetail-biblio-search.tmpl 16 Mar 2007 01:25:09 -0000 1.3
@@ -1,13 +1,5 @@
-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
-<html>
-<!-- TMPL_IF NAME="TemplateEncoding" -->
- <meta http-equiv="Content-Type" content="text/html; charset=<!-- TMPL_VAR NAME="TemplateEncoding" -->">
-<!-- TMPL_ELSE -->
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
-<!-- /TMPL_IF -->
-
-<body>
-<script language="JavaScript" type="text/javascript">
+<!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
+<script type="text/javascript">
function go()
{
@@ -61,5 +53,4 @@
<script language="javascript" type="text/javascript">
window.onload = go();
</script>
-</body>
-</html>
+<!-- TMPL_INCLUDE NAME="intranet-bottom" -->
Index: koha-tmpl/intranet-tmpl/prog/en/includes/doc-head-close.inc
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/includes/doc-head-close.inc,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -b -r1.3 -r1.4
--- koha-tmpl/intranet-tmpl/prog/en/includes/doc-head-close.inc 9 Mar 2007 14:47:39 -0000 1.3
+++ koha-tmpl/intranet-tmpl/prog/en/includes/doc-head-close.inc 16 Mar 2007 01:25:09 -0000 1.4
@@ -1,4 +1,3 @@
-</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="<!-- TMPL_VAR NAME='themelang' -->/includes/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" media="print" href="<!-- TMPL_VAR name="themelang" -->/includes/intranet-print.css" />
@@ -13,5 +12,4 @@
<!-- /TMPL_IF -->
</style>
</head>
-
<body>
Index: koha-tmpl/intranet-tmpl/prog/en/includes/menu-circ.inc
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/includes/menu-circ.inc,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -b -r1.6 -r1.7
--- koha-tmpl/intranet-tmpl/prog/en/includes/menu-circ.inc 10 Mar 2007 17:56:35 -0000 1.6
+++ koha-tmpl/intranet-tmpl/prog/en/includes/menu-circ.inc 16 Mar 2007 01:25:09 -0000 1.7
@@ -1,23 +1,15 @@
<div id="submenu">
- <ul>
- <li>
<a href="/cgi-bin/koha/circ/circulation.pl">Issues</a>
<a href="/cgi-bin/koha/circ/returns.pl">Returns</a>
<a href="/cgi-bin/koha/circ/branchtransfers.pl">Transfers</a>
<a href="/cgi-bin/koha/circ/selectbranchprinter.pl">Set branch</a>
- </li>
- <li>
- Reserves <a href="/cgi-bin/koha/circ/reserve.pl">Pending</a>
+ <a href="/cgi-bin/koha/circ/reserve.pl">Pending</a>
<a href="/cgi-bin/koha/circ/branchreserves.pl">Waiting</a>
- Transfers <a href="/cgi-bin/koha/circ/waitingreservestransfers.pl">to do</a>
- <a href="/cgi-bin/koha/circ/currenttransfers.pl">to recieve</a>
- </li>
- <li>
+ <a href="/cgi-bin/koha/circ/waitingreservestransfers.pl">Transfers (waiting)</a>
+ <a href="/cgi-bin/koha/circ/currenttransfers.pl">Transfers(current)</a>
<a href="/cgi-bin/koha/circ/overdue.pl">Overdues</a>
<a href="/cgi-bin/koha/circ/branchoverdues.pl">Overdues by branch/department</a>
<a href="/cgi-bin/koha/circ/stats.pl?time=yesterday">Daily reconciliation</a>
- </li>
- </ul>
</div>
<div id="main">
Index: koha-tmpl/intranet-tmpl/prog/en/includes/menu-members.inc
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/includes/menu-members.inc,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -b -r1.4 -r1.5
--- koha-tmpl/intranet-tmpl/prog/en/includes/menu-members.inc 9 Mar 2007 14:47:39 -0000 1.4
+++ koha-tmpl/intranet-tmpl/prog/en/includes/menu-members.inc 16 Mar 2007 01:25:09 -0000 1.5
@@ -1,10 +1,9 @@
-<!-- TMPL_INCLUDE NAME="javascript/members.js" -->
<div id="submenu">
- <a href="/cgi-bin/koha/members/members-home.pl">Search</a>
- <a href="/cgi-bin/koha/members/memberentry.pl?op=add&category_type=A"/>Add adult</a>
- <a href="/cgi-bin/koha/members/memberentry.pl?op=add&category_type=C"/>Add child</a>
- <a href="/cgi-bin/koha/members/memberentry.pl?op=add&category_type=P"/>Add prof</a>
- <a href="/cgi-bin/koha/members/memberentry.pl?op=add&category_type=I"/>Add org</a>
+ <a href="/cgi-bin/koha/members/members-home.pl">Borrowers</a>
+ <a href="/cgi-bin/koha/members/memberentry.pl?op=add&category_type=A">Add adult</a>
+ <a href="/cgi-bin/koha/members/memberentry.pl?op=add&category_type=C">Add child</a>
+ <a href="/cgi-bin/koha/members/memberentry.pl?op=add&category_type=P">Add professional</a>
+ <a href="/cgi-bin/koha/members/memberentry.pl?op=add&category_type=I">Add organisation</a>
</div>
<div id="main">
Index: koha-tmpl/intranet-tmpl/prog/en/includes/menus.inc
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/includes/menus.inc,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -b -r1.10 -r1.11
--- koha-tmpl/intranet-tmpl/prog/en/includes/menus.inc 10 Mar 2007 06:22:52 -0000 1.10
+++ koha-tmpl/intranet-tmpl/prog/en/includes/menus.inc 16 Mar 2007 01:25:09 -0000 1.11
@@ -2,8 +2,7 @@
<a href="#" onclick="javascript:window.open('/cgi-bin/koha/help.pl','Koha_Help','width=600,height=600,toolbar=false,scrollbars=yes');">[?]</a>
</div>
<div id="mainmenu">
-<h3><a href="/cgi-bin/koha/mainpage.pl">Koha
-intranet</a></h3>
+<h3><a href="/cgi-bin/koha/mainpage.pl">Koha Staff Client</a></h3>
<!-- TMPL_IF NAME="CAN_user_circulate" -->
<a href="/cgi-bin/koha/circ/circulation.pl">Circulation</a>
<ul>
Index: koha-tmpl/intranet-tmpl/prog/en/members/member.tmpl
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/members/member.tmpl,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -b -r1.7 -r1.8
--- koha-tmpl/intranet-tmpl/prog/en/members/member.tmpl 11 Mar 2007 21:08:13 -0000 1.7
+++ koha-tmpl/intranet-tmpl/prog/en/members/member.tmpl 16 Mar 2007 01:25:09 -0000 1.8
@@ -1,22 +1,29 @@
<!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
<title>Koha › Borrowers › Search Results</title>
<!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
-
-<!-- TMPL_INCLUDE NAME="menus.inc" -->
+<div id="hd">
<!-- TMPL_INCLUDE NAME="menu-members.inc" -->
+</div>
+<div id="bd">
+<div class="yui-b">
+<!-- TMPL_INCLUDE NAME="menus.inc" -->
+</div>
+<div id="yui-main">
+<div class="yui-b">
-<h1>Borrowers › Search Results</h1>
+<a href="/cgi-bin/koha/mainpage.pl">Home</a> › <a href="/cgi-bin/koha/members/members-home.pl">Borrowers</a><!-- TMPL_IF NAME="searching" --> › <a>Search Results</a><!-- /TMPL_IF -->
- <form name="f" action="/cgi-bin/koha/members/member.pl" method="post">
+<form name="f" action="/cgi-bin/koha/members/member.pl" method="post">
<label for="member">Search by name or barcode:</label>
<input id="member" type="text" size="25" name="member" />
+ order by:
<select name="orderby" id="orderby">
- <option value="surname,firstname">Order by last name</option>
- <option value="cardnumber">Order by card number</option>
+ <option value="surname,firstname">Surname</option>
+ <option value="cardnumber">Cardnumber</option>
</select>
<input type="submit" value="Search" />
- </form>
- <div>
+</form>
+<div>
Browse by last name:
<a href="/cgi-bin/koha/members/member.pl?member=a">A</a>
<a href="/cgi-bin/koha/members/member.pl?member=b">B</a>
@@ -44,7 +51,8 @@
<a href="/cgi-bin/koha/members/member.pl?member=x">X</a>
<a href="/cgi-bin/koha/members/member.pl?member=y">Y</a>
<a href="/cgi-bin/koha/members/member.pl?member=z">Z</a>
- </div>
+</div>
+
<!-- TMPL_IF NAME="resultsloop" -->
<div class="searchresults">
<table>
@@ -63,25 +71,26 @@
<tr>
<!-- /TMPL_IF -->
<td><!-- TMPL_VAR NAME="cardnumber" --></td>
- <td><p><a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->"><!-- TMPL_VAR NAME="surname" -->, <!-- TMPL_VAR NAME="firstname" --></a></p>
- <p><!-- TMPL_VAR NAME="streetaddress" --> <!-- TMPL_VAR NAME=city --></p> </td>
+ <td><a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->"><!-- TMPL_VAR NAME="surname" -->, <!-- TMPL_VAR NAME="firstname" --></a>
+ <!-- TMPL_VAR NAME="streetaddress" --> <!-- TMPL_VAR NAME=city -->
+ </td>
<td><!-- TMPL_VAR NAME="category_description" --> (<!-- TMPL_VAR name="category_type" -->)</td>
<td><!-- TMPL_VAR NAME="odissue" --></td>
<td><!-- TMPL_VAR NAME="fines" --></td>
<td><!-- TMPL_VAR NAME="borrowernotes" --></td>
</tr>
<!-- /TMPL_LOOP -->
-</table>
+ </table>
</div>
<!-- TMPL_ELSE -->
- <!-- TMPL_IF NAME="searching" -->
- No results found
- <!-- /TMPL_IF -->
+<!-- TMPL_IF NAME="searching" -->
+No results found
<!-- /TMPL_IF -->
-
- <script type="text/javascript">
- //set the focus to the input text.
- document.f.member.focus();
- </script>
-
+<!-- /TMPL_IF -->
+<script type="text/javascript">
+//set the focus to the input text.
+document.f.member.focus();
+</script>
+</div>
+</div>
<!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->
Index: koha-tmpl/intranet-tmpl/prog/en/members/memberentryA.tmpl
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/members/memberentryA.tmpl,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -b -r1.17 -r1.18
--- koha-tmpl/intranet-tmpl/prog/en/members/memberentryA.tmpl 12 Mar 2007 01:23:04 -0000 1.17
+++ koha-tmpl/intranet-tmpl/prog/en/members/memberentryA.tmpl 16 Mar 2007 01:25:09 -0000 1.18
@@ -1,15 +1,9 @@
<!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
<title>Koha › Adult Borrower Management</title>
<script type="text/javascript" src="<!-- TMPL_VAR NAME='themelang' -->/includes/members.js"></script>
+<!-- TMPL_INCLUDE NAME="calendar.inc" -->
<!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
-<!-- Additions to enable Calendar system -->
-<link rel="stylesheet" type="text/css" href="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-system.css">
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar.js"></script>
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-en.js"></script>
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-setup.js"></script>
-<!-- End of additions -->
-
<!-- TMPL_INCLUDE NAME="menus.inc" -->
<!-- TMPL_INCLUDE NAME="menu-members.inc" -->
<!-- TMPL_IF NAME="opadd" -->
Index: koha-tmpl/intranet-tmpl/prog/en/members/memberentryC.tmpl
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/members/memberentryC.tmpl,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -b -r1.16 -r1.17
--- koha-tmpl/intranet-tmpl/prog/en/members/memberentryC.tmpl 12 Mar 2007 01:23:04 -0000 1.16
+++ koha-tmpl/intranet-tmpl/prog/en/members/memberentryC.tmpl 16 Mar 2007 01:25:09 -0000 1.17
@@ -1,15 +1,9 @@
<!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
<title>Koha › Child Borrower Management</title>
<script type="text/javascript" src="<!-- TMPL_VAR NAME='themelang' -->/includes/members.js"></script>
+<!-- TMPL_INCLUDE NAME="calendar.inc" -->
<!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
-<!-- Additions to enable Calendar system -->
-<link rel="stylesheet" type="text/css" href="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-system.css">
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar.js"></script>
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-en.js"></script>
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-setup.js"></script>
-<!-- End of additions -->
-
<!-- TMPL_INCLUDE NAME="menus.inc" -->
<!-- TMPL_INCLUDE NAME="menu-members.inc" -->
<script language="javascript" type="text/javascript">
Index: koha-tmpl/intranet-tmpl/prog/en/members/memberentryI.tmpl
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/members/memberentryI.tmpl,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -b -r1.12 -r1.13
--- koha-tmpl/intranet-tmpl/prog/en/members/memberentryI.tmpl 12 Mar 2007 01:23:04 -0000 1.12
+++ koha-tmpl/intranet-tmpl/prog/en/members/memberentryI.tmpl 16 Mar 2007 01:25:09 -0000 1.13
@@ -1,15 +1,9 @@
<!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
<title>Koha › Organisation Borrower Management</title>
<script type="text/javascript" src="<!-- TMPL_VAR NAME='themelang' -->/includes/members.js"></script>
+<!-- TMPL_INCLUDE NAME="calendar.inc" -->
<!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
-<!-- Additions to enable Calendar system -->
-<link rel="stylesheet" type="text/css" href="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-system.css">
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar.js"></script>
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-en.js"></script>
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-setup.js"></script>
-<!-- End of additions -->
-
<!-- TMPL_INCLUDE NAME="menus.inc" -->
<!-- TMPL_INCLUDE NAME="menu-members.inc" -->
Index: koha-tmpl/intranet-tmpl/prog/en/members/memberentryP.tmpl
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/members/memberentryP.tmpl,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -b -r1.13 -r1.14
--- koha-tmpl/intranet-tmpl/prog/en/members/memberentryP.tmpl 12 Mar 2007 01:23:04 -0000 1.13
+++ koha-tmpl/intranet-tmpl/prog/en/members/memberentryP.tmpl 16 Mar 2007 01:25:09 -0000 1.14
@@ -1,33 +1,23 @@
<!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
<title>Koha › Professional Borrower Management</title>
<script type="text/javascript" src="<!-- TMPL_VAR NAME='themelang' -->/includes/members.js"></script>
+<!-- TMPL_INCLUDE NAME="calendar.inc" -->
<!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
-<!-- Additions to enable Calendar system -->
-<link rel="stylesheet" type="text/css" href="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-system.css">
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar.js"></script>
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-en.js"></script>
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-setup.js"></script>
-<!-- End of additions -->
-
<!-- TMPL_INCLUDE NAME="menus.inc" -->
<!-- TMPL_INCLUDE NAME="menu-members.inc" -->
<!-- TMPL_IF NAME="opadd" -->
- <h1>
- Add professional borrower (step <!-- TMPL_VAR NAME="step" -->) <!-- TMPL_VAR NAME="surname" --> <!-- TMPL_VAR name="firstname" -->
- </h1>
- <!-- TMPL_ELSE -->
- <h1 >
- Modify professional borrower <!-- TMPL_VAR NAME="surname" --> <!-- TMPL_VAR name="firstname" -->
- </h1>
+ <h1>Add professional borrower (step <!-- TMPL_VAR NAME="step" -->) <!-- TMPL_VAR NAME="surname" --> <!-- TMPL_VAR name="firstname" --></h1>
+ <!-- TMPL_ELSE -->
+ <h1>Modify professional borrower <!-- TMPL_VAR NAME="surname" --> <!-- TMPL_VAR name="firstname" --></h1>
<!-- /TMPL_IF -->
<!-- TMPL_IF NAME="check_member" -->
<!-- TMPL_IF NAME="step_2" -->
<p>
<form name="form_double">
<div id="problem">
- Duplicate suspected
+ Duplicate borrower suspected
<a href="javascript:Dopop('borrowers_details.pl?borrowernumber=<!--TMPL_VAR NAME="check_member"-->');" class="borrowers_button">Details</a>
Duplicate ?
<a href="/cgi-bin/koha/members/memberentry.pl?borrowernumber=<!--TMPL_VAR NAME="check_member"-->&category_type=<!--TMPL_VAR NAME="check_categorytype"-->" class="borrowers_button">Yes</a>
@@ -35,19 +25,19 @@
<INPUT type="checkbox" <!-- TMPL_IF NAME="checked"--> checked <!--/TMPL_IF--> name="answernodouble" >
</div>
</form>
-
</p>
<!--/TMPL_IF-->
<!--/TMPL_IF-->
+
<!-- TMPL_IF Name="nok" -->
<h1>ERROR</h1>
<div id="problem">
- <p>The following fields are wrong. Please fix it/them</p>
+ The following fields are wrong. Please fix it/them:
<!-- TMPL_IF NAME="ERROR_login_exist" -->
- <p>login/password already exist</p>
+ login already exists
<!-- /TMPL_IF -->
<!-- TMPL_IF NAME="ERROR_age_limitations" -->
- Borrower is too young or too old for this category
+ Borrower age is wrong for this category
<!-- /TMPL_IF -->
</div>
<!-- /TMPL_IF -->
@@ -55,7 +45,7 @@
<!-- TMPL_IF NAME="step_1"--><!--BEGIN OF TEST IF NOT collectivity BUT IN 1 STEP-->
<form name="form" action="/cgi-bin/koha/members/memberentry.pl" method="post">
<!-- field always hidden in different form (1,2,3) -->
- <input type="hidden" name="BorrowerMandatoryField" value="<!--TMPL_VAR NAME="BorrowerMandatoryField"-->">
+ <input type="hidden" name="BorrowerMandatoryField" value="<!--TMPL_VAR NAME="BorrowerMandatoryField"-->"/>
<input type="hidden" name="FormFieldList" value="surname|select_city|othernames|initials|title|cardnumber|firstname|dateofbirth|sort1|sort2">
<input type="hidden" name="category_type" value="<!-- TMPL_VAR name="category_type" -->">
<input type="hidden" name="type" value="borrowers">
@@ -112,7 +102,7 @@
<!--TMPL_ELSE-->
<label>
<!-- /TMPL_IF-->
- Card number</label>
+ Cardnumber</label>
<input type="text" name="cardnumber" size="10" value="<!-- TMPL_VAR NAME="cardnumber" -->">
</p>
<fieldset id="memberentry_identity">
@@ -198,8 +188,8 @@
<label>Category</label>
<!-- TMPL_VAR NAME="catcodepopup" -->
<!-- TMPL_ELSE -->
- <span class="problem">There is no category type to add a Professional.</span>
- <a href="/cgi-bin/koha/admin/categorie.pl">Please create one</a>
+ <span class="problem">There is no category type to add a Professional borrower.</span>
+ Please <a href="/cgi-bin/koha/admin/categorie.pl">create one</a>
<!-- /TMPL_IF -->
</p>
@@ -253,48 +243,48 @@
<form name="form" action="/cgi-bin/koha/members/memberentry.pl" method="post">
<!-- field always hidden in different form (1,2,3) -->
- <input type="hidden" name="BorrowerMandatoryField" value="<!--TMPL_VAR NAME="BorrowerMandatoryField"-->">
- <input type="hidden" name="FormFieldList" value="cardnumber|streetnumber|streettype|address|address2|zipcode|city|contactname|phone|phonepro|mobile|email|emailpro|B_zipcode|B_phone|B_address|B_city|relationship|fax|contactnote">
- <input type="hidden" name="category_type" value="<!-- TMPL_VAR name="category_type" -->">
- <input type="hidden" name="type" value="borrowers">
- <input type="hidden" name="step" value="<!-- TMPL_VAR NAME="step" -->">
- <input type="hidden" name="updtype" value="<!-- TMPL_VAR NAME="updtype" -->">
- <input type="hidden" name="actionType" value="<!-- TMPL_VAR NAME="actionType" -->">
- <input type="hidden" name="select_roadtype" value="<!-- TMPL_VAR NAME="select_roadtype" -->">
+ <input type="hidden" name="BorrowerMandatoryField" value="<!--TMPL_VAR NAME="BorrowerMandatoryField"-->"/>
+ <input type="hidden" name="FormFieldList" value="cardnumber|streetnumber|streettype|address|address2|zipcode|city|contactname|phone|phonepro|mobile|email|emailpro|B_zipcode|B_phone|B_address|B_city|relationship|fax|contactnote"/>
+ <input type="hidden" name="category_type" value="<!-- TMPL_VAR name="category_type" -->"/>
+ <input type="hidden" name="type" value="borrowers"/>
+ <input type="hidden" name="step" value="<!-- TMPL_VAR NAME="step" -->"/>
+ <input type="hidden" name="updtype" value="<!-- TMPL_VAR NAME="updtype" -->"/>
+ <input type="hidden" name="actionType" value="<!-- TMPL_VAR NAME="actionType" -->"/>
+ <input type="hidden" name="select_roadtype" value="<!-- TMPL_VAR NAME="select_roadtype" -->"/>
<input type="hidden" name="destination" value="<!-- TMPL_VAR NAME="destination" -->" />
<input type="hidden" name="check_member" value="<!-- TMPL_VAR NAME="check_member" -->" />
- <input type="hidden" name="borrowernumber" value="<!-- TMPL_VAR NAME="borrowernumber" -->">
+ <input type="hidden" name="borrowernumber" value="<!-- TMPL_VAR NAME="borrowernumber" -->"/>
<input type="hidden" name="nodouble" value="<!-- TMPL_VAR NAME="nodouble" -->" />
<!-- from form 1 -->
- <input type="hidden" name="title" value="<!-- TMPL_VAR NAME="title" -->">
- <input type="hidden" name="surname" value="<!-- TMPL_VAR NAME="surname" -->" >
- <input type="hidden" name="firstname" value="<!-- TMPL_VAR NAME="firstname" -->">
- <input type="hidden" name="dateofbirth" value="<!-- TMPL_VAR NAME="dateofbirth" -->">
- <input type="hidden" name="initials" value="<!-- TMPL_VAR NAME="initials" -->">
- <input type="hidden" name="othernames" value="<!-- TMPL_VAR NAME="othernames" -->" >
- <input type="hidden" name="sex" value="<!-- TMPL_VAR NAME="sex" -->" >
- <input type="hidden" name="categorycode" value="<!-- TMPL_VAR NAME="categorycode" -->">
- <input type="hidden" name="select_city" value="<!-- TMPL_VAR NAME="select_city" -->">
- <input type="hidden" name="sort1" value="<!-- TMPL_VAR NAME="sort1" -->">
- <input type="hidden" name="sort2" value="<!-- TMPL_VAR NAME="sort2" -->">
+ <input type="hidden" name="title" value="<!-- TMPL_VAR NAME="title" -->"/>
+ <input type="hidden" name="surname" value="<!-- TMPL_VAR NAME="surname" -->"/>
+ <input type="hidden" name="firstname" value="<!-- TMPL_VAR NAME="firstname" -->"/>
+ <input type="hidden" name="dateofbirth" value="<!-- TMPL_VAR NAME="dateofbirth" -->"/>
+ <input type="hidden" name="initials" value="<!-- TMPL_VAR NAME="initials" -->"/>
+ <input type="hidden" name="othernames" value="<!-- TMPL_VAR NAME="othernames" -->"/>
+ <input type="hidden" name="sex" value="<!-- TMPL_VAR NAME="sex" -->"/>
+ <input type="hidden" name="categorycode" value="<!-- TMPL_VAR NAME="categorycode" -->"/>
+ <input type="hidden" name="select_city" value="<!-- TMPL_VAR NAME="select_city" -->"/>
+ <input type="hidden" name="sort1" value="<!-- TMPL_VAR NAME="sort1" -->"/>
+ <input type="hidden" name="sort2" value="<!-- TMPL_VAR NAME="sort2" -->"/>
<!-- from form 3 -->
- <input type="hidden" name="dateenrolled" value="<!-- TMPL_VAR NAME="dateenrolled" -->">
- <input type="hidden" name="dateexpiry" value="<!-- TMPL_VAR NAME="dateexpiry" -->">
+ <input type="hidden" name="dateenrolled" value="<!-- TMPL_VAR NAME="dateenrolled" -->"/>
+ <input type="hidden" name="dateexpiry" value="<!-- TMPL_VAR NAME="dateexpiry" -->"/>
<textarea style="display:none;" name="opacnote" cols="70" rows="3"><!-- TMPL_VAR NAME="opacnote"--></textarea>
<textarea style="display:none;" name="borrowernotes" cols="70" rows="3"><!-- TMPL_VAR NAME="borrowernotes" --></textarea>
- <input type="hidden" name="userid" value="<!-- TMPL_VAR NAME="userid" -->">
- <input type="hidden" name="password" value="<!-- TMPL_VAR NAME="password" -->">
+ <input type="hidden" name="userid" value="<!-- TMPL_VAR NAME="userid" -->"/>
+ <input type="hidden" name="password" value="<!-- TMPL_VAR NAME="password" -->"/>
<input type="hidden" name="debarred" value="<!-- TMPL_VAR NAME="debarred" -->" />
<input type="hidden" name="lost" value="<!-- TMPL_VAR NAME="lost" -->" />
<input type="hidden" name="gonenoaddress" value="<!-- TMPL_VAR NAME="gonenoaddress" -->" />
<!-- TMPL_IF NAME="opadd" -->
- <input type="hidden" name="op" value="add">
+ <input type="hidden" name="op" value="add"/>
<!-- TMPL_ELSE -->
- <input type="hidden" name="op" value="modify">
+ <input type="hidden" name="op" value="modify"/>
<!-- /TMPL_IF -->
<input type="hidden" name="debarred" value="<!-- TMPL_VAR NAME="debarred" -->" />
@@ -306,7 +296,7 @@
<label>
<!-- /TMPL_IF-->
Card number</label>
- <input type="text" name="cardnumber" size="10" value="<!-- TMPL_VAR NAME="cardnumber" -->">
+ <input type="text" name="cardnumber" size="10" value="<!-- TMPL_VAR NAME="cardnumber" -->"/>
</p>
<fieldset is="memberentry_address">
<legend>Professional address</legend>
@@ -435,7 +425,7 @@
</p>
</fieldset>
<fieldset>
- <legend>Structure</legend>
+ <legend>Institution</legend>
<p>
<!-- TMPL_IF NAME="mandatorycontactname" -->
<label style="font-weight:bold">
@@ -465,7 +455,7 @@
<!-- TMPL_ELSE -->
<label>
<!-- /TMPL_IF-->
- Adress </label>
+ Address </label>
<input type="text" name="B_address" size="40" value="<!-- TMPL_VAR NAME="B_address" -->">
</p>
<p>
@@ -515,53 +505,53 @@
<!-- TMPL_IF NAME="step_3"-->
<form name="form" action="/cgi-bin/koha/members/memberentry.pl" method="post">
<!-- field always hidden in different form (1,2,3) -->
- <input type="hidden" name="BorrowerMandatoryField" value="<!--TMPL_VAR NAME="BorrowerMandatoryField"-->">
- <input type="hidden" name="FormFieldList" value="cardnumber|dateenrolled|dateexpiry|opacnote|borrowernotes|userid|password">
- <input type="hidden" name="category_type" value="<!-- TMPL_VAR name="category_type" -->">
- <input type="hidden" name="type" value="borrowers">
- <input type="hidden" name="step" value="<!-- TMPL_VAR NAME="step" -->">
- <input type="hidden" name="updtype" value="<!-- TMPL_VAR NAME="updtype" -->">
- <input type="hidden" name="actionType" value="<!-- TMPL_VAR NAME="actionType" -->">
- <input type="hidden" name="select_roadtype" value="<!-- TMPL_VAR NAME="select_roadtype" -->">
+ <input type="hidden" name="BorrowerMandatoryField" value="<!--TMPL_VAR NAME="BorrowerMandatoryField"-->"/>
+ <input type="hidden" name="FormFieldList" value="cardnumber|dateenrolled|dateexpiry|opacnote|borrowernotes|userid|password"/>
+ <input type="hidden" name="category_type" value="<!-- TMPL_VAR name="category_type" -->"/>
+ <input type="hidden" name="type" value="borrowers"/>
+ <input type="hidden" name="step" value="<!-- TMPL_VAR NAME="step" -->"/>
+ <input type="hidden" name="updtype" value="<!-- TMPL_VAR NAME="updtype" -->"/>
+ <input type="hidden" name="actionType" value="<!-- TMPL_VAR NAME="actionType" -->"/>
+ <input type="hidden" name="select_roadtype" value="<!-- TMPL_VAR NAME="select_roadtype" -->"/>
<input type="hidden" name="destination" value="<!-- TMPL_VAR NAME="destination" -->" />
<input type="hidden" name="check_member" value="<!-- TMPL_VAR NAME="check_member" -->" />
<input type="hidden" name="borrowernumber" value="<!-- TMPL_VAR NAME="borrowernumber" -->">
<input type="hidden" name="nodouble" value="<!-- TMPL_VAR NAME="nodouble" -->" />
<!-- from form 1 -->
- <input type="hidden" name="title" value="<!-- TMPL_VAR NAME="title" -->">
- <input type="hidden" name="surname" value="<!-- TMPL_VAR NAME="surname" -->" >
- <input type="hidden" name="firstname" value="<!-- TMPL_VAR NAME="firstname" -->">
- <input type="hidden" name="dateofbirth" value="<!-- TMPL_VAR NAME="dateofbirth" -->">
- <input type="hidden" name="initials" value="<!-- TMPL_VAR NAME="initials" -->">
- <input type="hidden" name="othernames" value="<!-- TMPL_VAR NAME="othernames" -->" >
- <input type="hidden" name="sex" value="<!-- TMPL_VAR NAME="sex" -->" >
- <input type="hidden" name="categorycode" value="<!-- TMPL_VAR NAME="categorycode" -->">
- <input type="hidden" name="select_city" value="<!-- TMPL_VAR NAME="select_city" -->">
- <input type="hidden" name="sort1" value="<!-- TMPL_VAR NAME="sort1" -->">
- <input type="hidden" name="sort2" value="<!-- TMPL_VAR NAME="sort2" -->">
+ <input type="hidden" name="title" value="<!-- TMPL_VAR NAME="title" -->"/>
+ <input type="hidden" name="surname" value="<!-- TMPL_VAR NAME="surname" -->" />
+ <input type="hidden" name="firstname" value="<!-- TMPL_VAR NAME="firstname" -->"/>
+ <input type="hidden" name="dateofbirth" value="<!-- TMPL_VAR NAME="dateofbirth" -->"/>
+ <input type="hidden" name="initials" value="<!-- TMPL_VAR NAME="initials" -->"/>
+ <input type="hidden" name="othernames" value="<!-- TMPL_VAR NAME="othernames" -->" />
+ <input type="hidden" name="sex" value="<!-- TMPL_VAR NAME="sex" -->" />
+ <input type="hidden" name="categorycode" value="<!-- TMPL_VAR NAME="categorycode" -->"/>
+ <input type="hidden" name="select_city" value="<!-- TMPL_VAR NAME="select_city" -->"/>
+ <input type="hidden" name="sort1" value="<!-- TMPL_VAR NAME="sort1" -->"/>
+ <input type="hidden" name="sort2" value="<!-- TMPL_VAR NAME="sort2" -->"/>
<!-- from form 2 -->
- <input type="hidden" name="streetnumber" value="<!-- TMPL_VAR NAME="streetnumber" -->">
- <input type="hidden" name="address" value="<!-- TMPL_VAR NAME="address" -->">
- <input type="hidden" name="address2" value="<!-- TMPL_VAR NAME="address2" -->">
- <input type="hidden" name="streettype" value="<!-- TMPL_VAR NAME="streettype" -->">
- <input type="hidden" name="zipcode" value="<!-- TMPL_VAR NAME="zipcode" -->">
- <input type="hidden" name="city" value="<!-- TMPL_VAR NAME="city" -->">
- <input type="hidden" name="branchcode" value="<!-- TMPL_VAR NAME="branchcode" -->">
- <input type="hidden" name="phone" value="<!-- TMPL_VAR NAME="phone" -->" >
- <input type="hidden" name="phonepro" value="<!-- TMPL_VAR NAME="phonepro" -->" >
- <input type="hidden" name="mobile" value="<!-- TMPL_VAR NAME="mobile" -->" >
- <input type="hidden" name="email" value="<!-- TMPL_VAR NAME="email" -->" >
- <input type="hidden" name="emailpro" value="<!-- TMPL_VAR NAME="emailpro" -->" >
- <input type="hidden" name="contactname" value="<!-- TMPL_VAR NAME="contactname" -->">
- <input type="hidden" name="relationship" value="<!-- TMPL_VAR NAME="relationship" -->">
- <input type="hidden" name="B_address" value="<!-- TMPL_VAR NAME="B_address" -->">
- <input type="hidden" name="B_zipcode" value="<!-- TMPL_VAR NAME="B_zipcode" -->">
- <input type="hidden" name="B_city" value="<!-- TMPL_VAR NAME="B_city" -->">
- <input type="hidden" name="B_phone" value="<!-- TMPL_VAR NAME="B_phone" -->">
- <input type="hidden" name="fax" value="<!-- TMPL_VAR NAME="fax" -->">
+ <input type="hidden" name="streetnumber" value="<!-- TMPL_VAR NAME="streetnumber" -->"/>
+ <input type="hidden" name="address" value="<!-- TMPL_VAR NAME="address" -->"/>
+ <input type="hidden" name="address2" value="<!-- TMPL_VAR NAME="address2" -->"/>
+ <input type="hidden" name="streettype" value="<!-- TMPL_VAR NAME="streettype" -->"/>
+ <input type="hidden" name="zipcode" value="<!-- TMPL_VAR NAME="zipcode" -->"/>
+ <input type="hidden" name="city" value="<!-- TMPL_VAR NAME="city" -->"/>
+ <input type="hidden" name="branchcode" value="<!-- TMPL_VAR NAME="branchcode" -->"/>
+ <input type="hidden" name="phone" value="<!-- TMPL_VAR NAME="phone" -->"/>
+ <input type="hidden" name="phonepro" value="<!-- TMPL_VAR NAME="phonepro" -->"/>
+ <input type="hidden" name="mobile" value="<!-- TMPL_VAR NAME="mobile" -->"/>
+ <input type="hidden" name="email" value="<!-- TMPL_VAR NAME="email" -->"/>
+ <input type="hidden" name="emailpro" value="<!-- TMPL_VAR NAME="emailpro" -->"/>
+ <input type="hidden" name="contactname" value="<!-- TMPL_VAR NAME="contactname" -->"/>
+ <input type="hidden" name="relationship" value="<!-- TMPL_VAR NAME="relationship" -->"/>
+ <input type="hidden" name="B_address" value="<!-- TMPL_VAR NAME="B_address" -->"/>
+ <input type="hidden" name="B_zipcode" value="<!-- TMPL_VAR NAME="B_zipcode" -->"/>
+ <input type="hidden" name="B_city" value="<!-- TMPL_VAR NAME="B_city" -->"/>
+ <input type="hidden" name="B_phone" value="<!-- TMPL_VAR NAME="B_phone" -->"/>
+ <input type="hidden" name="fax" value="<!-- TMPL_VAR NAME="fax" -->"/>
<textarea style="display:none;" name="contactnote" cols="70" rows="3" ><!-- TMPL_VAR NAME="contactnote" --></textarea>
<!-- TMPL_IF NAME="opadd" -->
@@ -576,7 +566,7 @@
<label>
<!-- /TMPL_IF-->
Card number</label>
- <input type="text" name="cardnumber" size="10" value="<!-- TMPL_VAR NAME="cardnumber" -->">
+ <input type="text" name="cardnumber" size="10" value="<!-- TMPL_VAR NAME="cardnumber" -->"/>
</p>
<fieldset id="memberentry_subscription">
<legend>Library set-up</legend>
Index: koha-tmpl/intranet-tmpl/prog/en/members/moremember.tmpl
===================================================================
RCS file: /sources/koha/koha/koha-tmpl/intranet-tmpl/prog/en/members/moremember.tmpl,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -b -r1.18 -r1.19
--- koha-tmpl/intranet-tmpl/prog/en/members/moremember.tmpl 12 Mar 2007 01:23:04 -0000 1.18
+++ koha-tmpl/intranet-tmpl/prog/en/members/moremember.tmpl 16 Mar 2007 01:25:09 -0000 1.19
@@ -1,40 +1,40 @@
<!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
-<title>Borrower's Details</title>
+<title>Koha › Borrower's Details</title>
<!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
<!-- TMPL_INCLUDE NAME="menus.inc" -->
<!-- TMPL_INCLUDE NAME="menu-members.inc" -->
<!-- TMPL_IF NAME="unknowuser" -->
- <p>This borrower doesn't exist anymore.<a href="javascript:back();">Go Back</a></p>
+ This borrower doesn't exist anymore.<a href="javascript:back();">Go Back</a>
<!-- TMPL_ELSE -->
+<a href="/cgi-bin/koha/mainpage.pl">Home</a> › <a href="/cgi-bin/koha/members/members-home.pl">Borrowers</a> › <a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->">Details for <!-- TMPL_VAR NAME="firstname" --> <!-- TMPL_VAR NAME="surname" --> (<!-- TMPL_VAR NAME="cardnumber" -->)</a>
-<h1><!-- TMPL_VAR NAME="firstname" --> <!-- TMPL_VAR NAME="surname" --> (<!-- TMPL_VAR NAME="cardnumber" -->)</h1>
- <form name="form">
- <input type="hidden" name="reregistration" value="<!-- TMPL_VAR NAME="reregistration"-->">
- <input type="hidden" name="borrowernumber" value="<!-- TMPL_VAR NAME="borrowernumber" -->" />
- </form>
+<form action="" name="form">
+<input type="hidden" name="reregistration" value="<!-- TMPL_VAR NAME="reregistration"-->"/>
+<input type="hidden" name="borrowernumber" value="<!-- TMPL_VAR NAME="borrowernumber" -->" />
+</form>
<div id="action">
<div class="edit">
<!-- TMPL_IF name="adultborrower" -->
- <a href="/cgi-bin/koha/members/memberentry.pl?op=add&guarantorid=<!-- TMPL_VAR NAME="borrowernumber" -->&category_type=C">
+ <a href="/cgi-bin/koha/members/memberentry.pl?op=add&guarantorid=<!-- TMPL_VAR NAME="borrowernumber" -->&category_type=C">
Add child
</a>
<!-- /TMPL_IF -->
<!-- TMPL_IF NAME="category_type" -->
<!--TMPL_IF NAME="guarantor"-->
- <a href="/cgi-bin/koha/members/memberentry.pl?op=modify&borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->&guarantorid=<!-- TMPL_VAR NAME="guarantorborrowernumber" -->&category_type=<!-- TMPL_VAR NAME="category_type"-->">
+ <a href="/cgi-bin/koha/members/memberentry.pl?op=modify&borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->&guarantorid=<!-- TMPL_VAR NAME="guarantorborrowernumber" -->&category_type=<!-- TMPL_VAR NAME="category_type"-->">
<!--TMPL_ELSE-->
- <a href="/cgi-bin/koha/members/memberentry.pl?op=modify&borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->&category_type=<!-- TMPL_VAR NAME="category_type"-->">
+ <a href="/cgi-bin/koha/members/memberentry.pl?op=modify&borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->&category_type=<!-- TMPL_VAR NAME="category_type"-->">
<!--/TMPL_IF-->
Edit
</a>
<!-- TMPL_ELSE --> <!-- try with categorycode if no category_type -->
<!-- TMPL_IF NAME="categorycode" -->
- <a href="/cgi-bin/koha/members/memberentry.pl?op=modify&borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->&categorycode=<!-- TMPL_VAR NAME="categorycode"-->">
+ <a href="/cgi-bin/koha/members/memberentry.pl?op=modify&borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->&categorycode=<!-- TMPL_VAR NAME="categorycode"-->">
Edit
</a>
<!-- TMPL_ELSE --> <!-- if no categorycode, set category_type to A by default -->
- <a href="/cgi-bin/koha/members/memberentry.pl?op=modify&borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->&category_type=A">
+ <a href="/cgi-bin/koha/members/memberentry.pl?op=modify&borrowernumber=<!-- TMPL_VAR NAME="borrowernumber" -->&category_type=A">
Edit
</a>
<!-- /TMPL_IF -->
@@ -66,7 +66,7 @@
</div>
<div class="others">
<!-- TMPL_IF NAME="CAN_user_parameters"-->
- <a href="/cgi-bin/koha/tools/viewlog.pl?do_it=1&module=MEMBERS&action=MODIFY&object=<!-- TMPL_VAR NAME="borrowernumber"-->">Modification log</a>
+ <a href="/cgi-bin/koha/tools/viewlog.pl?do_it=1&module=MEMBERS&action=MODIFY&object=<!-- TMPL_VAR NAME="borrowernumber"-->">Modification log</a>
<!-- /TMPL_IF -->
</div>
</div>
@@ -213,7 +213,7 @@
<table>
<tr>
<th scope="col">Title</th>
- <th scope="col">Due</th>
+ <th scope="col">Date due</th>
<th scope="col">Itemtype</th>
<th scope="col">Charge</th>
<th scope="col">Price</th>
@@ -277,9 +277,9 @@
<td colspan="3"> </td>
</tr>
</table>
- <div id="action">
- <input type="submit" name="renew_checked" value="Renew Checked Items" />
- <input type="submit" name="renew_all" value="Renew All" />
+ <div>
+ <input type="submit" name="renew_checked" value="Renew checked items" />
+ <input type="submit" name="renew_all" value="Renew all" />
</div>
</form>
</div>
@@ -334,11 +334,9 @@
<!-- /TMPL_LOOP -->
</table>
<!-- /TMPL_IF -->
-</div>
-
<script type="text/javascript">
function confirm_deletion() {
- var is_confirmed = window.confirm('Do you confirm deletion ?');
+ var is_confirmed = window.confirm('Click OK to confirm deletion');
var borrowernumbervalue=document.form.borrowernumber.value;
if (is_confirmed) {
@@ -347,10 +345,10 @@
}
function confirm_reregistration() {
- var is_confirmed = window.confirm('Do you confirm re_registration ?');
+ var is_confirmed = window.confirm('Click OK to confirm renewal');
var borrowernumbervalue1=document.form.borrowernumber.value;
if (is_confirmed) {
- window.location='/cgi-bin/koha/members/moremember.pl?reregistration=y&borrowernumber='+borrowernumbervalue1+'';
+ window.location='/cgi-bin/koha/members/moremember.pl?reregistration=y&borrowernumber='+borrowernumbervalue1+'';
}
}
</script>
Index: members/member.pl
===================================================================
RCS file: /sources/koha/koha/members/member.pl,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -b -r1.14 -r1.15
--- members/member.pl 9 Mar 2007 14:56:55 -0000 1.14
+++ members/member.pl 16 Mar 2007 01:25:09 -0000 1.15
@@ -1,6 +1,6 @@
#!/usr/bin/perl
-# $Id: member.pl,v 1.14 2007/03/09 14:56:55 tipaul Exp $
+# $Id: member.pl,v 1.15 2007/03/16 01:25:09 kados Exp $
#script to do a borrower enquiery/brin up borrower details etc
#written 20/12/99 by chris at katipo.co.nz
@@ -113,6 +113,7 @@
}
$template->param(
+ searching => "1",
member => $member,
numresults => $count,
resultsloop => \@resultsdata,
Index: misc/sql-datas/en/mandatory/05_sysprefs.sql
===================================================================
RCS file: /sources/koha/koha/misc/sql-datas/en/mandatory/05_sysprefs.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -b -r1.3 -r1.4
--- misc/sql-datas/en/mandatory/05_sysprefs.sql 9 Mar 2007 22:03:13 -0000 1.3
+++ misc/sql-datas/en/mandatory/05_sysprefs.sql 16 Mar 2007 01:25:09 -0000 1.4
@@ -1,99 +1,99 @@
-INSERT INTO `systempreferences` VALUES('acquisitions','normal','Normal, budget-based acquisitions, or Simple bibliographic-data acquisitions','simple|normal','Choice');
-INSERT INTO `systempreferences` VALUES('advancedMARCeditor','0','If set, the MARC editor won\'t show you tag/subfields description','','YesNo');
-INSERT INTO `systempreferences` VALUES('AmazonAssocTag','','see: associates.amazon.com/gp/flex/associates/apply-login.html','','free');
-INSERT INTO `systempreferences` VALUES('AmazonContent','0','Turn On Amazon Content - You MUST set AmazonDevKey and AmazonAssocTag if enabled','','YesNo');
-INSERT INTO `systempreferences` VALUES('AmazonDevKey','','see: aws-portal.amazon.com/gp/aws/developer/registration/index.html','','free');
-INSERT INTO `systempreferences` VALUES('AnonSuggestions','0','Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free');
-INSERT INTO `systempreferences` VALUES('authoritysep','--','the separator used in authority/thesaurus. Usually --','10','free');
-INSERT INTO `systempreferences` VALUES('autoBarcode','1','Barcode is auto-calculated','','YesNo');
-INSERT INTO `systempreferences` VALUES('AutoLocation','0','switch to activate or not Autolocation, if Yes, the Librarian can\'t change his location, it\'s defined by branchip',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('AutomaticItemReturn','1','This Variable allow or not to return automaticly to his homebranch',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('autoMemberNum','1','Member number is auto-calculated','','YesNo');
-INSERT INTO `systempreferences` VALUES('BiblioDefaultView','normal','Define the default view of a biblio. Can be either normal, marc or isbd','normal|marc|isbd','Choice');
-INSERT INTO `systempreferences` VALUES('BorrowerMandatoryField','zipcode|surname','List all mandatory fields for borrowers',NULL,'free');
-INSERT INTO `systempreferences` VALUES('borrowerRelationship','father|mother','The relationships between a guarantor & a guarantee (separated by | or ,)','','free');
-INSERT INTO `systempreferences` VALUES('BorrowersLog','0','Active this if you want to log borrowers edition/creation/deletion...',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('BorrowersTitles','Mr|Mrs|Miss|Ms','List all Titles for borrowers',NULL,'free');
-INSERT INTO `systempreferences` VALUES('CataloguingLog','0','Active this if you want to log cataloguing action.',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('checkdigit','none','Validity checks on membership number: none or \"Katipo\" style checks','none|katipo','Choice');
-INSERT INTO `systempreferences` VALUES('dateformat','us','date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy/mm/dd)','metric|us|iso','Choice');
-INSERT INTO `systempreferences` VALUES('delimiter',';','Define the default separator character for report exportations into files',';|tabulation|,|/|\\|#','Choice');
-INSERT INTO `systempreferences` VALUES('Disable_Dictionary','1','Disables Dictionary buttons if set to yes','','YesNo');
-INSERT INTO `systempreferences` VALUES('expandedSearchOption','0','search among marc field',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('FinesLog','0','Active this if you want to log fines',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('gist','0','the gist rate. NOT in %, but in numeric form (0.12 for 12%)','','free');
-INSERT INTO `systempreferences` VALUES('hidelostitems','0','show or hide \"lost\" items in OPAC.','','YesNo');
-INSERT INTO `systempreferences` VALUES('hide_marc','0','hide marc specific datas like subfield code & indicators to library',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('IndependantBranches','0','Turn Branch independancy management On an Off',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('insecure','NO','If YES, no auth at all is needed. Be careful if you set this to yes!',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('IntranetBiblioDefaultView','normal','IntranetBiblioDefaultView','','');
-INSERT INTO `systempreferences` VALUES('intranetcolorstylesheet','intranet.css','Enter the name of the color stylesheet to use in Intranet','','free');
-INSERT INTO `systempreferences` VALUES('IntranetmainUserblock','','A user-defined block of HTML on the intranet home page','50|20','Textarea');
-INSERT INTO `systempreferences` VALUES('IntranetNav','','Use HTML tabs to add navigational links to the left-hand navigational bar in Int','70|10','Textarea');
-INSERT INTO `systempreferences` VALUES('intranetreadinghistory','0','Turn on or off the Reading History option in the intranet','','YesNo');
-INSERT INTO `systempreferences` VALUES('intranetstylesheet','','Enter a complete URL to use an alternate layout stylesheet in Intranet',NULL,'free');
-INSERT INTO `systempreferences` VALUES('intranetuserjs','function prepareEmailPopup(){\r\n if (!document.getElementById) return false;\r\n if (!document.getElementById(\'reserveemail\')) return false;\r\n rsvlink = document.getElementById(\'reserveemail\');\r\n rsvlink.onclick = function() {\r\n doReservePopup();\r\n return false;\r\n }\r\n}\r\n\r\nfunction doReservePopup(){\r\n}\r\n\r\nfunction prepareReserveList(){\r\n}\r\n\r\naddLoadEvent(prepareEmailPopup);\r\naddLoadEvent(prepareReserveList);','Custom javascript for inclusion in Intranet','50|10','Textarea');
-INSERT INTO `systempreferences` VALUES('intranet_includes','includes','The includes directory you want for specific look of Koha (includes or includes_npl for example)',NULL,'Free');
-INSERT INTO `systempreferences` VALUES('ISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|<br/><br/>\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|<br/><br/>|{ 5003 }{ 500a }|\r\n#501|<br/><br/>|{ 501a }|\r\n#502|<br/><br/>|{ 502a }|\r\n#504|<br/><br/>|{ 504a }|\r\n#505|<br/><br/>|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|<br/><br/>|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|<br/><br/>|{ 507a }{ 507b }|\r\n#508|<br/><br/>|{ 508a }{ 508a }|\r\n#510|<br/><br/>|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|<br/><br/>|{ 511a }|\r\n#513|<br/><br/>|{ 513a }{513b }|\r\n#514|<br/><br/>|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|<br/><br/>|{ 515a }|\r\n#516|<br/><br/>|{ 516a }|\r\n#518|<br/><br/>|{ 5183 }{ 518a }|\r\n#520|<br/><br/>|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|<br/><br/>|{ 5213 }{ 521a }{ 521b }|\r\n#522|<br/><br/>|{ 522a }|\r\n#524|<br/><br/>|{ 524a }|\r\n#525|<br/><br/>|{ 525a }|\r\n#526|<br/><br/>|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|<br/><br/>|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|<br/><br/>|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|<br/><br/>|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|<br/><br/>|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|<br/><br/>|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|<br/><br/>|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|<br/><br/>|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|<br/><br/>|{\\n545a }{ 545b }{\\n545u }|\r\n#546|<br/><br/>|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|<br/><br/>|{\\n547a }|\r\n#550|<br/><br/>|{ 550a }|\r\n#552|<br/><br/>|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|<br/><br/>|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|<br/><br/>|{ 556a }{ 506z }|\r\n#563|<br/><br/>|{ 5633 }{ 563a }{ 563u }|\r\n#565|<br/><br/>|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|<br/><br/>|{ 567a }|\r\n#580|<br/><br/>|{ 580a }|\r\n#581|<br/><br/>|{ 5633 }{ 581a }{ 581z }|\r\n#584|<br/><br/>|{ 5843 }{ 584a }{ 584b }|\r\n#585|<br/><br/>|{ 5853 }{ 585a }|\r\n#586|<br/><br/>|{ 5863 }{ 586a }|\r\n#020|<br/><br/><label>ISBN: </label>|{ 020a }{ 020c }|\r\n#022|<br/><br/><label>ISSN: </label>|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|<br/><br/><label>Standard No.: </label>|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|<br/><br/><label>Standard Tech. Report. No.: </label>|{ 027a }|\r\n#028|<br/><br/><label>Publisher. No.: </label>|{ 028a }{ 028b }|\r\n#013|<br/><br/><label>Patent No.: </label>|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|<br/><br/><label>CODEN: </label>|{ 030a }|\r\n#037|<br/><br/><label>Source: </label>|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|<br/><br/><label>LCCN: </label>|{ 010a }|\r\n#015|<br/><br/><label>Nat. Bib. No.: </label>|{ 015a }{ 0152 }|\r\n#016|<br/><br/><label>Nat. Bib. Agency Control No.: </label>|{ 016a }{ 0162 }|\r\n#600|<br/><br/><label>Subjects--Personal Names: </label>|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|<br/><br/><label>Subjects--Corporate Names: </label>|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|<br/><br/><label>Subjects--Meeting Names: </label>|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|<br/><br/><label>Subjects--Uniform Titles: </label>|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|<br/><br/><label>Subjects--Chronological Terms: </label>|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|<br/><br/><label>Subjects--Topical Terms: </label>|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|<br/><br/><label>Subjects--Geographic Terms: </label>|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|<br/><br/><label>Subjects--Index Terms: </label>|{ 653a }|\r\n#654|<br/><br/><label>Subjects--Facted Index Terms: </label>|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|<br/><br/><label>Index Terms--Genre/Form: </label>|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|<br/><br/><label>Index Terms--Occupation: </label>|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|<br/><br/><label>Index Terms--Function: </label>|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|<br/><br/><label>Index Terms--Curriculum Objective: </label>|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|<br/><br/><label>LC Class. No.: </label>|{ 050a }{ / 050b }|\r\n#082|<br/><br/><label>Dewey Class. No.: </label>|{ 082a }{ / 082b }|\r\n#080|<br/><br/><label>Universal Decimal Class. No.: </label>|{ 080a }{ 080x }{ / 080b }|\r\n#070|<br/><br/><label>National Agricultural Library Call No.: </label>|{ 070a }{ / 070b }|\r\n#060|<br/><br/><label>National Library of Medicine Call No.: </label>|{ 060a }{ / 060b }|\r\n#074|<br/><br/><label>GPO Item No.: </label>|{ 074a }|\r\n#086|<br/><br/><label>Gov. Doc. Class. No.: </label>|{ 086a }|\r\n#088|<br/><br/><label>Report. No.: </label>|{ 088a }|','ISBD','80|20','Textarea');
-INSERT INTO `systempreferences` VALUES('IssueLog','0','Active this if you want to log issue.',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('IssuingInProcess','0','Allow no debt alert if the patron is issuing item that accumulate debt',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('item-level_itypes','1','Item-level Itemtype / issuing rules','','YesNo');
-INSERT INTO `systempreferences` VALUES('itemcallnumber','676a','The MARC field/subfield that is used to calculate the itemcallnumber (in UNIMARC',NULL,'free');
-INSERT INTO `systempreferences` VALUES('KohaAdminEmailAddress','root at localhost','the email address where borrowers modifs are sent','','free');
-INSERT INTO `systempreferences` VALUES('kohaspsuggest','1','Keep track of queries and suggestions in a database','','');
-INSERT INTO `systempreferences` VALUES('LabelMARCView','standard','Define how a MARC record will display','standard|economical','Choice');
-INSERT INTO `systempreferences` VALUES('LetterLog','0','Active this if you want to log all the letter sent',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('LibraryName','','Library name as shown on main opac page','','');
-INSERT INTO `systempreferences` VALUES('marc','ON','Turn on MARC support',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('marcflavour','MARC21','your MARC flavor (MARC21 or UNIMARC) used for character encoding','MARC21|UNIMARC','Choice');
-INSERT INTO `systempreferences` VALUES('MARCOrgCode','OSt','Your MARC Organization Code - http://www.loc.gov/marc/organizations/orgshome.htm','','free');
-INSERT INTO `systempreferences` VALUES('maxoutstanding','5','maximum amount withstanding to be able make reserves','','Integer');
-INSERT INTO `systempreferences` VALUES('maxreserves','50','maximum number of reserves a member can make','','Integer');
-INSERT INTO `systempreferences` VALUES('memberofinstitution','0','Are your patrons members of institutions',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('MIME','EXCEL','Define the default application for report exportations into files','EXCEL|OPENOFFICE.ORG','Choice');
-INSERT INTO `systempreferences` VALUES('noissuescharge','5','maximum amount withstanding to be able to check out an item','','Integer');
-INSERT INTO `systempreferences` VALUES('NotifyBorrowerDeparture','0','Delay before expiry where a notice is sent when issuing',NULL,'Integer');
-INSERT INTO `systempreferences` VALUES('OpacAuthorities','1','Enable / Disable the search authority link on OPAC',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('opacbookbag','1','Enable or disable display of biblio basket (book bag)','','YesNo');
-INSERT INTO `systempreferences` VALUES('OpacBrowser','1','Enable/Disable browser link on OPAC (needs to set misc/cronjob/build_browser.pl)',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('OpacCloud','1','Enable / Disable cloud link on OPAC',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('opaccolorstylesheet','colors.css','Enter the name of the color stylesheet to use in the OPAC','','free');
-INSERT INTO `systempreferences` VALUES('opaccredits','','Put any HTML Credits at the bottom of the OPAC page','70|10','Textarea');
-INSERT INTO `systempreferences` VALUES('opacheader','','Enter HTML to be included as a custom header in the OPAC','30|10','Textarea');
-INSERT INTO `systempreferences` VALUES('opaclanguages','en','Set the preferred order for translations. The top language will be tried first.',NULL,'Languages');
-INSERT INTO `systempreferences` VALUES('opaclanguagesdisplay','0','Turn on/off display of Change Language feature on OPAC','','YesNo');
-INSERT INTO `systempreferences` VALUES('opaclargeimage','','Enter a complete URL to an image, will be on the main page, instead of the Koha',NULL,'free');
-INSERT INTO `systempreferences` VALUES('opaclayoutstylesheet','opac.css','Enter the name of the layout stylesheet to use in the OPAC','','free');
-INSERT INTO `systempreferences` VALUES('OpacMaintenance','0','This will give the users a nice maintenance warning if enabled','','YesNo');
-INSERT INTO `systempreferences` VALUES('OpacMainUserBlock','Welcome to Koha...\r\n<hr>','A user-defined block of HTML in the main content area of the opac main page','50|20','Textarea');
-INSERT INTO `systempreferences` VALUES('OpacNav','Important links here.','Use HTML tabs to add navigational links to the left-hand navigational bar in OPA','70|10','Textarea');
-INSERT INTO `systempreferences` VALUES('OpacPasswordChange','1','Enable/Disable password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('opacreadinghistory','1','Turn on/off display of Patron Reading History in OPAC','','YesNo');
-INSERT INTO `systempreferences` VALUES('opacsmallimage','','Enter a complete URL to an image, will be on top/left instead of the Koha logo','','free');
-INSERT INTO `systempreferences` VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');
-INSERT INTO `systempreferences` VALUES('opacthemes','prog','Set the preferred order for themes. The top theme will be tried first.','','Themes');
-INSERT INTO `systempreferences` VALUES('OpacTopissue','1','Enable / Disable the top issue link on OPAC',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('opacuserjs','','Custom javascript for inclusion in OPAC','50|20','Textarea');
-INSERT INTO `systempreferences` VALUES('opacuserlogin','1','Enable or disable display of user login features',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('patronimages','0','Turn on/off display of patron images in Intranet and specify a file extension fo','','YesNo');
-INSERT INTO `systempreferences` VALUES('printcirculationslips','1','if set to 1, print circulation slips. If set to 0, don\'t','','free');
-INSERT INTO `systempreferences` VALUES('ReadingHistory','1','Allow reading record info retrievable from issues and oldissues tables','','YesNo');
-INSERT INTO `systempreferences` VALUES('RequestOnOpac','1','option to allow reserves on opac',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('ReservesMaxPickUpDelay','7','Maximum delay to pick up a reserved document','','free');
-INSERT INTO `systempreferences` VALUES('ReturnBeforeExpiry','0','If Yes, Returndate on issuing can\'t be after borrower card expiry',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('ReturnLog','0','Active this if you want to log the circulation return',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('reviewson','1','Allows patrons to submit reviews from the opac','','YesNo');
-INSERT INTO `systempreferences` VALUES('serialsadditems','0','If set, a new item will be automatically added when receiving an issue',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('sortbynonfiling','no','Sort search results by MARC nonfiling characters',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('SpecifyDueDate','1','Choose whether to display \"Specify Due Date\" form in Circulation','','YesNo');
-INSERT INTO `systempreferences` VALUES('SubscriptionHistory',';','Define the information level for serials history in OPAC','simplified|full','Choice');
-INSERT INTO `systempreferences` VALUES('SubscriptionLog','0','Active this if you want to log Subscription action',NULL,'YesNo');
-INSERT INTO `systempreferences` VALUES('suggestion','1','if set to 1, suggestions are activated in OPAC','','free');
-INSERT INTO `systempreferences` VALUES('template','prog','Preference order for intranet interface templates','','Themes');
-INSERT INTO `systempreferences` VALUES('TemplateEncoding','utf-8','Specify the encoding to use in Templates','iso-8859-1|utf-8','Choice');
-INSERT INTO `systempreferences` VALUES('timeout','12000000','Inactivity timeout for cookies authentication (in seconds)',NULL,'Integer');
-INSERT INTO `systempreferences` VALUES('TransfersMaxDaysWarning','3','Max delay before considering the transfer has potentialy a problem',NULL,'free');
-INSERT INTO `systempreferences` VALUES('useDaysMode','Calendar','How to calculate return dates : Calendar means holidays will be controled, Days means the return date don\'t depend on holidays','Calendar|Days','Choice');
-INSERT INTO `systempreferences` VALUES('virtualshelves','1','Set virtual shelves management ON or OFF','','YesNo');
-INSERT INTO `systempreferences` VALUES('z3950AuthorAuthFields','701,702,700','contains the MARC biblio tags of person authorities to fill biblio.author with w',NULL,'free');
-INSERT INTO `systempreferences` VALUES('z3950NormalizeAuthor','0','If set, Personal Name Authorities will replace authors in biblio.author','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('acquisitions','normal','Normal, budget-based acquisitions, or Simple bibliographic-data acquisitions','simple|normal','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('advancedMARCeditor','0','If set, the MARC editor won\'t show you tag/subfields description','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','see: associates.amazon.com/gp/flex/associates/apply-login.html','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonContent','0','Turn On Amazon Content - You MUST set AmazonDevKey and AmazonAssocTag if enabled','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonDevKey','','see: aws-portal.amazon.com/gp/aws/developer/registration/index.html','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions','0','Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','the separator used in authority/thesaurus. Usually --','10','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('autoBarcode','1','Barcode is auto-calculated','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AutoLocation','0','switch to activate or not Autolocation, if Yes, the Librarian can\'t change his location, it\'s defined by branchip',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AutomaticItemReturn','1','This Variable allow or not to return automaticly to his homebranch',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('autoMemberNum','1','Member number is auto-calculated','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('BiblioDefaultView','normal','Define the default view of a biblio. Can be either normal, marc or isbd','normal|marc|isbd','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('BorrowerMandatoryField','zipcode|surname','List all mandatory fields for borrowers',NULL,'free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('borrowerRelationship','father|mother','The relationships between a guarantor & a guarantee (separated by | or ,)','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('BorrowersLog','0','Active this if you want to log borrowers edition/creation/deletion...',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('BorrowersTitles','Mr|Mrs|Miss|Ms','List all Titles for borrowers',NULL,'free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('CataloguingLog','0','Active this if you want to log cataloguing action.',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('checkdigit','none','Validity checks on membership number: none or \"Katipo\" style checks','none|katipo','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('dateformat','us','date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy/mm/dd)','metric|us|iso','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('delimiter',';','Define the default separator character for report exportations into files',';|tabulation|,|/|\\|#','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Disable_Dictionary','1','Disables Dictionary buttons if set to yes','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('expandedSearchOption','0','search among marc field',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('FinesLog','0','Active this if you want to log fines',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('gist','0','the gist rate. NOT in %, but in numeric form (0.12 for 12%)','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('hidelostitems','0','show or hide \"lost\" items in OPAC.','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('hide_marc','0','hide marc specific datas like subfield code & indicators to library',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IndependantBranches','0','Turn Branch independancy management On an Off',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('insecure','NO','If YES, no auth at all is needed. Be careful if you set this to yes!',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IntranetBiblioDefaultView','normal','IntranetBiblioDefaultView','','');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetcolorstylesheet','intranet.css','Enter the name of the color stylesheet to use in Intranet','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IntranetmainUserblock','','A user-defined block of HTML on the intranet home page','50|20','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IntranetNav','','Use HTML tabs to add navigational links to the left-hand navigational bar in Int','70|10','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetreadinghistory','0','Turn on or off the Reading History option in the intranet','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetstylesheet','','Enter a complete URL to use an alternate layout stylesheet in Intranet',NULL,'free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetuserjs','function prepareEmailPopup(){\r\n if (!document.getElementById) return false;\r\n if (!document.getElementById(\'reserveemail\')) return false;\r\n rsvlink = document.getElementById(\'reserveemail\');\r\n rsvlink.onclick = function() {\r\n doReservePopup();\r\n return false;\r\n }\r\n}\r\n\r\nfunction doReservePopup(){\r\n}\r\n\r\nfunction prepareReserveList(){\r\n}\r\n\r\naddLoadEvent(prepareEmailPopup);\r\naddLoadEvent(prepareReserveList);','Custom javascript for inclusion in Intranet','50|10','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranet_includes','includes','The includes directory you want for specific look of Koha (includes or includes_npl for example)',NULL,'Free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|<br/><br/>\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|<br/><br/>|{ 5003 }{ 500a }|\r\n#501|<br/><br/>|{ 501a }|\r\n#502|<br/><br/>|{ 502a }|\r\n#504|<br/><br/>|{ 504a }|\r\n#505|<br/><br/>|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|<br/><br/>|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|<br/><br/>|{ 507a }{ 507b }|\r\n#508|<br/><br/>|{ 508a }{ 508a }|\r\n#510|<br/><br/>|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|<br/><br/>|{ 511a }|\r\n#513|<br/><br/>|{ 513a }{513b }|\r\n#514|<br/><br/>|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|<br/><br/>|{ 515a }|\r\n#516|<br/><br/>|{ 516a }|\r\n#518|<br/><br/>|{ 5183 }{ 518a }|\r\n#520|<br/><br/>|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|<br/><br/>|{ 5213 }{ 521a }{ 521b }|\r\n#522|<br/><br/>|{ 522a }|\r\n#524|<br/><br/>|{ 524a }|\r\n#525|<br/><br/>|{ 525a }|\r\n#526|<br/><br/>|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|<br/><br/>|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|<br/><br/>|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|<br/><br/>|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|<br/><br/>|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|<br/><br/>|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|<br/><br/>|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|<br/><br/>|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|<br/><br/>|{\\n545a }{ 545b }{\\n545u }|\r\n#546|<br/><br/>|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|<br/><br/>|{\\n547a }|\r\n#550|<br/><br/>|{ 550a }|\r\n#552|<br/><br/>|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|<br/><br/>|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|<br/><br/>|{ 556a }{ 506z }|\r\n#563|<br/><br/>|{ 5633 }{ 563a }{ 563u }|\r\n#565|<br/><br/>|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|<br/><br/>|{ 567a }|\r\n#580|<br/><br/>|{ 580a }|\r\n#581|<br/><br/>|{ 5633 }{ 581a }{ 581z }|\r\n#584|<br/><br/>|{ 5843 }{ 584a }{ 584b }|\r\n#585|<br/><br/>|{ 5853 }{ 585a }|\r\n#586|<br/><br/>|{ 5863 }{ 586a }|\r\n#020|<br/><br/><label>ISBN: </label>|{ 020a }{ 020c }|\r\n#022|<br/><br/><label>ISSN: </label>|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|<br/><br/><label>Standard No.: </label>|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|<br/><br/><label>Standard Tech. Report. No.: </label>|{ 027a }|\r\n#028|<br/><br/><label>Publisher. No.: </label>|{ 028a }{ 028b }|\r\n#013|<br/><br/><label>Patent No.: </label>|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|<br/><br/><label>CODEN: </label>|{ 030a }|\r\n#037|<br/><br/><label>Source: </label>|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|<br/><br/><label>LCCN: </label>|{ 010a }|\r\n#015|<br/><br/><label>Nat. Bib. No.: </label>|{ 015a }{ 0152 }|\r\n#016|<br/><br/><label>Nat. Bib. Agency Control No.: </label>|{ 016a }{ 0162 }|\r\n#600|<br/><br/><label>Subjects--Personal Names: </label>|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|<br/><br/><label>Subjects--Corporate Names: </label>|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|<br/><br/><label>Subjects--Meeting Names: </label>|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|<br/><br/><label>Subjects--Uniform Titles: </label>|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|<br/><br/><label>Subjects--Chronological Terms: </label>|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|<br/><br/><label>Subjects--Topical Terms: </label>|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|<br/><br/><label>Subjects--Geographic Terms: </label>|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|<br/><br/><label>Subjects--Index Terms: </label>|{ 653a }|\r\n#654|<br/><br/><label>Subjects--Facted Index Terms: </label>|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|<br/><br/><label>Index Terms--Genre/Form: </label>|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|<br/><br/><label>Index Terms--Occupation: </label>|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|<br/><br/><label>Index Terms--Function: </label>|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|<br/><br/><label>Index Terms--Curriculum Objective: </label>|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|<br/><br/><label>LC Class. No.: </label>|{ 050a }{ / 050b }|\r\n#082|<br/><br/><label>Dewey Class. No.: </label>|{ 082a }{ / 082b }|\r\n#080|<br/><br/><label>Universal Decimal Class. No.: </label>|{ 080a }{ 080x }{ / 080b }|\r\n#070|<br/><br/><label>National Agricultural Library Call No.: </label>|{ 070a }{ / 070b }|\r\n#060|<br/><br/><label>National Library of Medicine Call No.: </label>|{ 060a }{ / 060b }|\r\n#074|<br/><br/><label>GPO Item No.: </label>|{ 074a }|\r\n#086|<br/><br/><label>Gov. Doc. Class. No.: </label>|{ 086a }|\r\n#088|<br/><br/><label>Report. No.: </label>|{ 088a }|','ISBD','80|20','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IssueLog','0','Active this if you want to log issue.',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IssuingInProcess','0','Allow no debt alert if the patron is issuing item that accumulate debt',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('item-level_itypes','1','Item-level Itemtype / issuing rules','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('itemcallnumber','676a','The MARC field/subfield that is used to calculate the itemcallnumber (in UNIMARC',NULL,'free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('KohaAdminEmailAddress','root at localhost','the email address where borrowers modifs are sent','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('kohaspsuggest','1','Keep track of queries and suggestions in a database','','');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('LabelMARCView','standard','Define how a MARC record will display','standard|economical','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('LetterLog','0','Active this if you want to log all the letter sent',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('LibraryName','','Library name as shown on main opac page','','');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('marc','ON','Turn on MARC support',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('marcflavour','MARC21','your MARC flavor (MARC21 or UNIMARC) used for character encoding','MARC21|UNIMARC','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('MARCOrgCode','OSt','Your MARC Organization Code - http://www.loc.gov/marc/organizations/orgshome.htm','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('maxoutstanding','5','maximum amount withstanding to be able make reserves','','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('maxreserves','50','maximum number of reserves a member can make','','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('memberofinstitution','0','Are your patrons members of institutions',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('MIME','EXCEL','Define the default application for report exportations into files','EXCEL|OPENOFFICE.ORG','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('noissuescharge','5','maximum amount withstanding to be able to check out an item','','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('NotifyBorrowerDeparture','0','Delay before expiry where a notice is sent when issuing',NULL,'Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacAuthorities','1','Enable / Disable the search authority link on OPAC',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacbookbag','1','Enable or disable display of biblio basket (book bag)','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacBrowser','1','Enable/Disable browser link on OPAC (needs to set misc/cronjob/build_browser.pl)',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacCloud','1','Enable / Disable cloud link on OPAC',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaccolorstylesheet','colors.css','Enter the name of the color stylesheet to use in the OPAC','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaccredits','','Put any HTML Credits at the bottom of the OPAC page','70|10','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacheader','','Enter HTML to be included as a custom header in the OPAC','30|10','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaclanguages','en','Set the preferred order for translations. The top language will be tried first.',NULL,'Languages');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaclanguagesdisplay','0','Turn on/off display of Change Language feature on OPAC','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaclargeimage','','Enter a complete URL to an image, will be on the main page, instead of the Koha',NULL,'free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaclayoutstylesheet','opac.css','Enter the name of the layout stylesheet to use in the OPAC','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMaintenance','0','This will give the users a nice maintenance warning if enabled','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMainUserBlock','Welcome to Koha...\r\n<hr>','A user-defined block of HTML in the main content area of the opac main page','50|20','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Important links here.','Use HTML tabs to add navigational links to the left-hand navigational bar in OPA','70|10','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange','1','Enable/Disable password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory','1','Turn on/off display of Patron Reading History in OPAC','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image, will be on top/left instead of the Koha logo','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacthemes','prog','Set the preferred order for themes. The top theme will be tried first.','','Themes');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacTopissue','1','Enable / Disable the top issue link on OPAC',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacuserjs','','Custom javascript for inclusion in OPAC','50|20','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacuserlogin','1','Enable or disable display of user login features',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('patronimages','0','Turn on/off display of patron images in Intranet and specify a file extension fo','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('printcirculationslips','1','if set to 1, print circulation slips. If set to 0, don\'t','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReadingHistory','1','Allow reading record info retrievable from issues and oldissues tables','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('RequestOnOpac','1','option to allow reserves on opac',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReservesMaxPickUpDelay','7','Maximum delay to pick up a reserved document','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReturnBeforeExpiry','0','If Yes, Returndate on issuing can\'t be after borrower card expiry',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReturnLog','0','Active this if you want to log the circulation return',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('reviewson','1','Allows patrons to submit reviews from the opac','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('serialsadditems','0','If set, a new item will be automatically added when receiving an issue',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('sortbynonfiling','no','Sort search results by MARC nonfiling characters',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SpecifyDueDate','1','Choose whether to display \"Specify Due Date\" form in Circulation','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SubscriptionHistory',';','Define the information level for serials history in OPAC','simplified|full','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SubscriptionLog','0','Active this if you want to log Subscription action',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('suggestion','1','if set to 1, suggestions are activated in OPAC','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('template','prog','Preference order for intranet interface templates','','Themes');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('TemplateEncoding','utf-8','Specify the encoding to use in Templates','iso-8859-1|utf-8','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('timeout','12000000','Inactivity timeout for cookies authentication (in seconds)',NULL,'Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('TransfersMaxDaysWarning','3','Max delay before considering the transfer has potentialy a problem',NULL,'free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('useDaysMode','Calendar','How to calculate return dates : Calendar means holidays will be controled, Days means the return date don\'t depend on holidays','Calendar|Days','Choice');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('virtualshelves','1','Set virtual shelves management ON or OFF','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('z3950AuthorAuthFields','701,702,700','contains the MARC biblio tags of person authorities to fill biblio.author with w',NULL,'free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('z3950NormalizeAuthor','0','If set, Personal Name Authorities will replace authors in biblio.author','','YesNo');
Index: opac/opac-search.pl
===================================================================
RCS file: /sources/koha/koha/opac/opac-search.pl,v
retrieving revision 1.39
retrieving revision 1.40
diff -u -b -r1.39 -r1.40
--- opac/opac-search.pl 9 Mar 2007 15:12:54 -0000 1.39
+++ opac/opac-search.pl 16 Mar 2007 01:25:09 -0000 1.40
@@ -3,7 +3,7 @@
# Script to perform searching
# For documentation try 'perldoc /path/to/search'
#
-# $Header: /sources/koha/koha/opac/opac-search.pl,v 1.39 2007/03/09 15:12:54 tipaul Exp $
+# $Header: /sources/koha/koha/opac/opac-search.pl,v 1.40 2007/03/16 01:25:09 kados Exp $
#
# Copyright 2006 LibLime
#
@@ -489,6 +489,7 @@
my $this_page_number = $i;
my $highlight = 1
if ( $this_page_number == $current_page_number );
+ if ($this_page_number <= $pages) {
push @page_numbers,
{
offset => $this_offset,
@@ -498,6 +499,7 @@
@sort_by
};
}
+ }
$template->param(
PAGE_NUMBERS => \@page_numbers,
previous_page_offset => $previous_page_offset,
Index: updater/updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.158
retrieving revision 1.159
diff -u -b -r1.158 -r1.159
--- updater/updatedatabase 9 Mar 2007 15:14:57 -0000 1.158
+++ updater/updatedatabase 16 Mar 2007 01:25:09 -0000 1.159
@@ -1,6 +1,6 @@
#!/usr/bin/perl
-# $Id: updatedatabase,v 1.158 2007/03/09 15:14:57 tipaul Exp $
+# $Id: updatedatabase,v 1.159 2007/03/16 01:25:09 kados Exp $
# Database Updater
# This script checks for required updates to the database.
@@ -1101,6 +1101,12 @@
content => 'itemnumber',
}
],
+ userflags => [
+ { indexname => 'PRIMARY',
+ content => 'bit',
+ type => 'PRI',
+ }
+ ]
);
my %foreign_keys = (
@@ -1962,6 +1968,20 @@
exit;
# $Log: updatedatabase,v $
+# Revision 1.159 2007/03/16 01:25:09 kados
+# Using my precrash CVS copy I did the following:
+#
+# cvs -z3 -d:ext:kados at cvs.savannah.nongnu.org:/sources/koha co -P koha
+# find koha.precrash -type d -name "CVS" -exec rm -v {} \;
+# cp -r koha.precrash/* koha/
+# cd koha/
+# cvs commit
+#
+# This should in theory put us right back where we were before the crash
+#
+# Revision 1.159 2007/03/12 17:52:30 rych
+# add pri key to userflags
+#
# Revision 1.158 2007/03/09 15:14:57 tipaul
# rel_3_0 moved to HEAD
#
Index: koha-tmpl/intranet-tmpl/prog/en/includes/calendar.inc
===================================================================
RCS file: koha-tmpl/intranet-tmpl/prog/en/includes/calendar.inc
diff -N koha-tmpl/intranet-tmpl/prog/en/includes/calendar.inc
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ koha-tmpl/intranet-tmpl/prog/en/includes/calendar.inc 16 Mar 2007 01:25:09 -0000 1.1
@@ -0,0 +1,4 @@
+<link rel="stylesheet" type="text/css" href="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-system.css"/>
+<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar.js"></script>
+<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-en.js"></script>
+<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/includes/calendar/calendar-setup.js"></script>
Index: koha-tmpl/intranet-tmpl/prog/en/includes/members.js
===================================================================
RCS file: koha-tmpl/intranet-tmpl/prog/en/includes/members.js
diff -N koha-tmpl/intranet-tmpl/prog/en/includes/members.js
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ koha-tmpl/intranet-tmpl/prog/en/includes/members.js 16 Mar 2007 01:25:09 -0000 1.1
@@ -0,0 +1,180 @@
+function _(s) { return s; }
+
+// this function checks id date is like DD/MM/YYYY
+function CheckDate(field) {
+var d = field.value;
+if (d!="") {
+ var amin = 1900;
+ var amax = 2100;
+ var date = d.split("/");
+ var ok=1;
+ var msg;
+ if ( (date.length < 2) && (ok==1) ) {
+ msg = _("Separator must be /");
+ alert(msg); ok=0; field.focus();
+ return;
+ }
+ var dd = date[0];
+ var mm = date[1];
+ var yyyy = date[2];
+ // checking days
+ if ( ((isNaN(dd))||(dd<1)||(dd>31)) && (ok==1) ) {
+ msg = _("day not correct.");
+ alert(msg); ok=0; field.focus();
+ return;
+ }
+ // checking months
+ if ( ((isNaN(mm))||(mm<1)||(mm>12)) && (ok==1) ) {
+ msg = _("month not correct.");
+ alert(msg); ok=0; field.focus();
+ return;
+ }
+ // checking years
+ if ( ((isNaN(yyyy))||(yyyy<amin)||(yyyy>amax)) && (ok==1) ) {
+ msg = _("years not correct.");
+ alert(msg); ok=0; field.focus();
+ return;
+ }
+ }
+}
+
+//function test if member is unique and if it's right the member is registred
+function unique() {
+var msg1;
+var msg2;
+if ( document.form.check_member.value==1){
+ if (document.form.categorycode.value != "I"){
+
+ msg1 += ("Warning !!!! Duplicate borrower!!!!");
+ alert(msg1);
+ check_form_borrowers(0);
+ document.form.submit();
+
+ }else{
+ msg2 += ("Warning !!!! Duplicate organisation!!!!");
+ alert(msg2);
+ check_form_borrowers(0);
+ }
+}
+else
+{
+ document.form.submit();
+}
+
+}
+//end function
+//function test if date enrooled < date expiry
+function check_manip_date(status) {
+if (status=='verify'){
+// this part of function('verify') is used to check if dateenrolled<date expiry
+if (document.form.dateenrolled != '' && document.form.dateexpiry.value !='') {
+var myDate1=document.form.dateenrolled.value.split ('/');
+var myDate2=document.form.dateexpiry.value.split ('/');
+ if ((myDate1[2]>myDate2[2])||(myDate1[2]==myDate2[2] && myDate1[1]>myDate2[1])||(myDate1[2]==myDate2[2] && myDate1[1]>=myDate2[1] && myDate1[0]>=myDate2[0]))
+
+ {
+ document.form.dateenrolled.focus();
+ var msg = ("Warning !!! check date expiry >= date enrolment");
+ alert(msg);
+ }
+ }
+ }
+}
+//end function
+
+
+// function to test all fields in forms and nav in different forms(1 ,2 or 3)
+ function check_form_borrowers(nav){
+var statut=0;
+if (nav < document.form.step.value) {
+ document.form.step.value=nav;
+ if ((document.form.step.value==0) && document.form.check_member.value == 1 )
+ {
+
+ if (document.form_double.answernodouble) {
+ if( (!(document.form_double.answernodouble.checked))){
+ document.form.nodouble.value=0;
+ }
+ else {
+ document.form.nodouble.value=1;
+ }
+ }
+ }
+ document.form.submit();
+
+} else {
+ if (document.form.BorrowerMandatoryField.value==''||document.form.FormFieldList.value=='' )
+ {}
+ else
+ {
+ var champ_verif = document.form.BorrowerMandatoryField.value.split ('|');
+ var champ_form= document.form.FormFieldList.value.split('|');
+ var message ="The following fields are mandatory :\n";
+ var message_champ="";
+ for (var j=0; j<champ_form.length; j++){
+ if (document.getElementsByName(""+champ_form[j]+"")[0]){
+ for (var i=0; i<champ_verif.length; i++) {
+ if (document.getElementsByName(""+champ_verif[i]+"")[0]) {
+ var val_champ=eval("document.form."+champ_verif[i]+".value");
+ var ref_champ=eval("document.form."+champ_verif[i]);
+ var val_form=eval("document.form."+champ_form[j]+".value");
+ if (champ_verif[i] == champ_form[j]){
+ //check if it's a select
+ if (ref_champ.type=='select-one'){
+ if (ref_champ.options[0].selected ){
+ // action if field is empty
+ message_champ+=champ_verif[i]+"\n";
+ //test to konw if you must show a message with error
+ statut=1;
+ }
+ }else {
+ if ( val_champ == '' ) {
+ // action if the field is not empty
+ message_champ+=champ_verif[i]+"\n";
+ statut=1;
+ }
+ }
+ }
+ }
+ }
+ }
+ }
+ }
+//borrowers form 2 test if u chcked no to the quetsion of double
+ if (document.form.step.value==2 && statut!=1 && document.form.check_member.value > 0 )
+ {
+
+
+ if (!(document.form_double.answernodouble.checked)){
+
+ message ="";
+ message_champ+=("Please confirm suspicious duplicate borrower !!! ");
+ statut=1;
+ document.form.nodouble.value=0;
+ }
+ else {
+ document.form.nodouble.value=1;
+ }
+ }
+
+ if (statut==1){
+ //alert if at least 1 error
+ alert(message+"\n"+message_champ);
+ }
+ else
+ {
+ document.form.step=nav;
+ document.form.submit();
+ }
+ }
+}
+
+function Dopop(link) {
+// // var searchstring=document.form.value[i].value;
+ var newin=window.open(link,'popup','width=600,height=400,resizable=no,toolbar=false,scrollbars=no,top');
+}
+
+function Dopopguarantor(link) {
+
+ var newin=window.open(link,'popup','width=600,height=400,resizable=no,toolbar=false,scrollbars=yes,top');
+}
More information about the Koha-cvs
mailing list