[Koha-cvs] CVS: koha/updater updatedatabase,1.22,1.23

[Paul POULAIN]

Update of /cvsroot/koha/koha/updater
In directory usw-pr-cvs1:/tmp/cvs-serv15970/updater

Modified Files:
        updatedatabase 
Log Message:
Road to 1.3.2
* bugfixes and improvements
* manage mandatory MARC subfields
* new table : authorised_values. this table contains categories and authorised 
values for the category. On MARC management, you can map a subfield to a 
authorised_values category. If you do this, the subfield can only be filled 
with a authorised_value of the selected category.
this submit contains everything needed :
* updatedatabase
* admin screens
* "links" management
* creation of a html-list if a subfield is mapped to an authorised value.

Note this is different from authorities support, which will come soon.
The authorised_values is supposed to contains a "small" number of authorised 
values for a category (less than 50-100). If you enter more authorised values 
than this, it should be hard to find what you want in a BIG list...

Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.22
retrieving revision 1.23
diff -C2 -r1.22 -r1.23
*** updatedatabase      15 Oct 2002 10:08:19 -0000      1.22
--- updatedatabase      25 Oct 2002 10:55:46 -0000      1.23
***************
*** 130,133 ****
--- 130,134 ----
                                                kohafield char(40) NOT NULL 
default '',
                                                tab tinyint(1),
+                                               authorised_value char(10) 
default NULL,
                                                PRIMARY KEY  
(tagfield,tagsubfield),
                                                KEY kohafield (kohafield),
***************
*** 182,185 ****
--- 183,192 ----
                                                                PRIMARY KEY  
(isbn)
                                                                )",
+       authorised_values => "(id int(11) NOT NULL auto_increment,
+                                                                       
category char(10) NOT NULL default '',
+                                                                       
authorised_value char(80) NOT NULL default '',
+                                                                       PRIMARY 
KEY  (id),
+                                                                       KEY 
name (category)
+                                                               )";
        );
  
***************
*** 415,418 ****
--- 422,439 ----
  
  # $Log$
+ # Revision 1.23  2002/10/25 10:55:46  tipaul
+ # Road to 1.3.2
+ # * bugfixes and improvements
+ # * manage mandatory MARC subfields
+ # * new table : authorised_values. this table contains categories and 
authorised values for the category. On MARC management, you can map a subfield 
to a authorised_values category. If you do this, the subfield can only be 
filled with a authorised_value of the selected category.
+ # this submit contains everything needed :
+ # * updatedatabase
+ # * admin screens
+ # * "links" management
+ # * creation of a html-list if a subfield is mapped to an authorised value.
+ #
+ # Note this is different from authorities support, which will come soon.
+ # The authorised_values is supposed to contains a "small" number of 
authorised values for a category (less than 50-100). If you enter more 
authorised values than this, it should be hard to find what you want in a BIG 
list...
+ #
  # Revision 1.22  2002/10/15 10:08:19  tipaul
  # fixme corrected, re-indent and adding the marc_breeding table (see commit 
of marcimport.pl for more explanations about breeding)