From f8993bd8d3574efb4d31b16235ecb1a007fb1c22 Mon Sep 17 00:00:00 2001
From: tipaul <tipaul>
Date: Tue, 12 Nov 2002 16:44:38 +0000
Subject: [PATCH] road to 1.3.2 : * many bugfixes * adding value_builder : you
 can map a subfield in the marc_subfield_structure to a sub stored in
 "value_builder" directory. In this directory you can create screen used to
 build values with any method. In this commit is a 1st draft of the builder
 for 100$a unimarc french subfield, which is composed of 35 digits, with 12
 differents values (only the 4th first are provided for instance)

---
 updater/updatedatabase | 29 ++++++++++++++++++++++-------
 1 file changed, 22 insertions(+), 7 deletions(-)

diff --git a/updater/updatedatabase b/updater/updatedatabase
index 0721210b69..1f61d9570c 100755
--- a/updater/updatedatabase
+++ b/updater/updatedatabase
@@ -99,12 +99,19 @@ my %requiretables=(
 								userid char(100) NOT NULL default '',
 								ip char(18) NOT NULL default '',
 								url text NOT NULL default ''  )",
-	bibliothesaurus=> "( code BIGINT not null AUTO_INCREMENT,
-						freelib CHAR (255) not null ,
-						stdlib CHAR (255) not null ,
-						type CHAR (80) not null ,
-						PRIMARY KEY (code),
-						INDEX (freelib),index(stdlib),index(type) )",
+	bibliothesaurus=> "( CREATE TABLE 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 '',
+							PRIMARY KEY  (id),
+							KEY freelib (freelib),
+							KEY stdlib (stdlib),
+							KEY category (category),
+							KEY hierarchy (hierarchy)
+							)",
 	marc_biblio => "(
 						bibid bigint(20) unsigned NOT NULL auto_increment,
 						biblionumber int(11) NOT NULL default '0',
@@ -130,6 +137,8 @@ my %requiretables=(
 						kohafield char(40) NOT NULL default '',
 						tab tinyint(1),
 						authorised_value char(10) default NULL,
+						thesaurus_category char(10) default NULL,
+						value_builder char(80) NOT NULL default '',
 						PRIMARY KEY  (tagfield,tagsubfield),
 						KEY kohafield (kohafield),
 						KEY tab (tab)
@@ -229,7 +238,8 @@ my %defaultprefs=(
 		'acquisitions'=> ['simple','normal or simple : will use acquisition system found in directory acqui.simple or acquisition'],
 		'template' => ['default','template default name'],
 		'autoBarcode' => ['0','1 or else. If 1, Barcode is auto-calculated'],
-		'insecure' => ['no','if YES, no auth at all is needed. Be careful if you set this to yes !']
+		'insecure' => ['no','if YES, no auth at all is needed. Be careful if you set this to yes !'],
+		'authoritysep' => ['--','the separator used in authority/thesaurus. Usually --']
 		  );
 
 
@@ -421,6 +431,11 @@ $sth->finish;
 exit;
 
 # $Log$
+# Revision 1.25  2002/11/12 16:44:38  tipaul
+# road to 1.3.2 :
+# * many bugfixes
+# * adding value_builder : you can map a subfield in the marc_subfield_structure to a sub stored in "value_builder" directory. In this directory you can create screen used to build values with any method. In this commit is a 1st draft of the builder for 100$a unimarc french subfield, which is composed of 35 digits, with 12 differents values (only the 4th first are provided for instance)
+#
 # Revision 1.24  2002/10/30 14:00:23  arensb
 # (bug fix): Fixed typo.
 #
-- 
2.20.1