Adding some new fields to biblioitems:

[koha_fer] / updater / updatedatabase

diff --git a/updater/updatedatabase b/updater/updatedatabase
index 1bef877..26606ed 100755 (executable)
--- a/updater/updatedatabase
+++ b/updater/updatedatabase
@@ -52,21 +52,6 @@ $|=1; # flushes output
 
 # Tables to add if they don't exist
 my %requiretables = (
-    categorytable       => "(categorycode char(5) NOT NULL default '',
-                             description text default '',
-                             itemtypecodes text default '',
-                             PRIMARY KEY (categorycode)
-                            )",
-    subcategorytable       => "(subcategorycode char(5) NOT NULL default '',
-                             description text default '',
-                             itemtypecodes text default '',
-                             PRIMARY KEY (subcategorycode)
-                            )",
-    mediatypetable       => "(mediatypecode char(5) NOT NULL default '',
-                             description text default '',
-                             itemtypecodes text default '',
-                             PRIMARY KEY (mediatypecode)
-                            )",
     action_logs     => "(
                     `timestamp` TIMESTAMP NOT NULL ,
                     `user` INT( 11 ) NOT NULL ,
@@ -175,10 +160,6 @@ my %requiretables = (
                             datereviewed datetime,
                             PRIMARY KEY (reviewid)
                             )",
-    borrowers_to_borrowers  => "(
-                            borrower1 integer,
-                            borrower2 integer
-                            )",
     subscriptionroutinglist=>"(
                              routingid integer NOT NULL auto_increment,
                              borrowernumber integer,
@@ -428,7 +409,7 @@ my %tabledata = (
             value               => '1',
             forceupdate         => { 'explanation' => 1,
                                      'type' => 1},
-            explanation         => 'Enable / Disable cloud link on OPAC',
+            explanation         => 'Enable / Disable cloud link on OPAC (Require to run misc/cronjobs/build_browser_and_cloud.pl on the server)',
             type                => 'YesNo',
         },
        {
@@ -437,7 +418,7 @@ my %tabledata = (
             value               => '1',
             forceupdate         => { 'explanation' => 1,
                                      'type' => 1},
-            explanation         => 'Enable/Disable browser link on OPAC (needs to set misc/cronjob/build_browser.pl)',
+            explanation         => 'Enable/Disable browser link on OPAC (Require to run misc/cronjobs/build_browser_and_cloud.pl on the server)',
             type                => 'YesNo',
         },
        {
@@ -538,6 +519,14 @@ my %tabledata = (
             explanation         => "Enter a specific hash for NoZebra indexes. Enter : 'indexname' => '100a,245a,500*','index2' => '...'",
             type                => 'Free',
         },
+        {
+            uniquefieldrequired => 'variable',
+            variable            => 'uppercasesurnames',
+            value               => '0',
+            forceupdate         => {'explanation' => 1, 'type' => 1},
+            explanation         => "Force Surnames to be uppercase",
+            type                => 'YesNo',
+        },
     ],
     userflags => [
         {
@@ -596,7 +585,7 @@ my %fielddefinitions = (
             field    => 'id',
             type    => 'int(11)',
             null    => 'NOT NULL',
-            key        => '',
+            key        => 'PRI',
             default    => '',
             extra    => 'auto_increment',
         },
@@ -750,6 +739,49 @@ my %fielddefinitions = (
             default => '',
             extra   => '',
         },
+        {
+            field   => 'publicationyear',
+            type    => 'text',
+            null    => 'null',
+            default => '',
+            extra   => '',
+        },
+        {
+            field   => 'collectiontitle',
+            type    => 'mediumtext',
+            null    => 'null',
+            default => '',
+            extra   => '',
+        },
+        {
+            field   => 'collectionissn',
+            type    => 'mediumtext',
+            null    => 'null',
+            default => '',
+            extra   => '',
+        },
+        {
+            field   => 'collectionvolume',
+            type    => 'mediumtext',
+            null    => 'null',
+            default => '',
+            extra   => '',
+        },
+        {
+            field   => 'editionstatement',
+            type    => 'text',
+            null    => 'null',
+            default => '',
+            extra   => '',
+        },
+        {
+            field   => 'editionresponsability',
+            type    => 'text',
+            null    => 'null',
+            default => '',
+            extra   => '',
+        },
+              
     ],
     deletedbiblioitems => [
         {
@@ -998,6 +1030,15 @@ my %fielddefinitions = (
             extra  => '',
         },
     ],
+    marc_breeding => [
+        {
+            field => 'marc',
+            type  => 'LONGBLOB',
+            null  => 'NULL',
+            key    => '',
+            extra  => '',
+        }
+    ],
     marc_subfield_structure => [
         {
             field => 'defaultvalue',
@@ -2058,6 +2099,27 @@ $sth->finish;
 exit;
 
 # $Log$
+# Revision 1.172  2007/07/19 10:21:22  hdl
+# Adding some new fields to biblioitems:
+# collectiontitle
+# collectionissn
+# collectionvolume
+#
+#
+# Changing publicationyear to text.
+#
+# Revision 1.171  2007/07/02 02:30:16  rangi
+# Fix for bug 1296, making surnames uppercase a systems preference
+#
+# Revision 1.170  2007/06/26 13:25:37  tipaul
+# removing some useless tables from updatedatabase
+#
+# Revision 1.169  2007/06/26 09:23:26  tipaul
+# improving OpacBrowser systempref explanation
+#
+# Revision 1.168  2007/06/25 15:02:31  tipaul
+# missing field declaration
+#
 # Revision 1.167  2007/06/15 13:09:08  toins
 # bugfix : bibliotitems.dewey & deletedbiblioitems.dewey mustn't be double(8,6).
 #