From de2403d8cb378a29a68374b824f328f7f7e37c6b Mon Sep 17 00:00:00 2001 From: tipaul Date: Tue, 10 Dec 2002 13:27:47 +0000 Subject: [PATCH] bugfixes (davide mails in koha-dev) --- updater/sample_only_param_tables.sql | 94 ++++++++++++++-------------- updater/updatedatabase | 9 ++- 2 files changed, 53 insertions(+), 50 deletions(-) diff --git a/updater/sample_only_param_tables.sql b/updater/sample_only_param_tables.sql index 0b5333366b..1f55257cf7 100644 --- a/updater/sample_only_param_tables.sql +++ b/updater/sample_only_param_tables.sql @@ -75,53 +75,53 @@ INSERT INTO currency VALUES( 'NZD', '1.00000'); INSERT INTO currency VALUES( 'AUD', '0.60000'); INSERT INTO currency VALUES( 'USD', '0.49000'); -INSERT INTO itemtypes VALUES( 'ART', 'Art Prints', '42', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'BCD', 'CD-ROM from book', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'CAS', 'Cassette', '14', '0', '1.0000'); -INSERT INTO itemtypes VALUES( 'CD', 'Compact disc (WN)', '14', '1', '2.0000'); -INSERT INTO itemtypes VALUES( 'F', 'Free Fiction', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'FJV', 'Junior free video', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'FVID', 'Adult free video', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'FYA', 'Young Adult Fiction', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'GWB', 'Get Well Bags', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'HCVF', 'Horowhenua Collection Vertical File', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'IL', 'Interloan', '22', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JCF', 'Junior Castle Fiction', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JCNF', 'Junior Castle Non-fictio', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JF', 'Junior Fiction', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JHC', 'Junior Horowhenua Collection VF', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JIG', 'Jigsaw puzzle', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JK', 'Junior Kermit ', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JNF', 'Junior Non-Fiction', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JPB', 'Junior Paperbacks', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JPC', 'Junior Picture Book', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JPER', 'Junior Periodical', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JREF', 'Junior Reference', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JVF', 'Junior Vertical File', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'JVID', 'Junior rental video', '7', '1', '3.0000'); -INSERT INTO itemtypes VALUES( 'LP', 'Large Print', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'MAP', 'Maps', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'NF', 'Adult Non-fiction', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'NFLP', 'NonFiction LargePrint', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'NFYA', 'Young Adult Non Fiction', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'NGA', 'Nga Pukapuka', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'PAY', 'Pay Collection', '14', '1', '1.0000'); -INSERT INTO itemtypes VALUES( 'PB', 'Pamphlet Box', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'PER', 'Periodicals Stand', '14', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'PHOT', 'Photograph', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'POS', 'Junior Posters', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'REF', 'Adult Reference Books', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'ROM', 'CD-Rom', '7', '1', '5.0000'); -INSERT INTO itemtypes VALUES( 'STF', 'Stack Fiction', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'STJ', 'Stack Junior', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'STLP', 'Stack Large Print', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'STNF', 'Stack Non-fiction', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'TB', 'Talking Books', '14', '1', '2.0000'); -INSERT INTO itemtypes VALUES( 'TREF', 'Taonga', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'VF', 'Vertical File', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'VID', 'Adult rental video', '7', '1', '3.0000'); -INSERT INTO itemtypes VALUES( 'FTB', 'Free Talking Books', '21', '1', '0.0000'); -INSERT INTO itemtypes VALUES( 'NLTB', 'National Library Talking Books', '21', '1', '2.0000'); +INSERT INTO itemtypes VALUES( 'ART', 'Art Prints', '42', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'BCD', 'CD-ROM from book', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'CAS', 'Cassette', '14', '0', '1.0000',0); +INSERT INTO itemtypes VALUES( 'CD', 'Compact disc (WN)', '14', '1', '2.0000',0); +INSERT INTO itemtypes VALUES( 'F', 'Free Fiction', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'FJV', 'Junior free video', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'FVID', 'Adult free video', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'FYA', 'Young Adult Fiction', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'GWB', 'Get Well Bags', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'HCVF', 'Horowhenua Collection Vertical File', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'IL', 'Interloan', '22', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JCF', 'Junior Castle Fiction', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JCNF', 'Junior Castle Non-fictio', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JF', 'Junior Fiction', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JHC', 'Junior Horowhenua Collection VF', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JIG', 'Jigsaw puzzle', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JK', 'Junior Kermit ', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JNF', 'Junior Non-Fiction', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JPB', 'Junior Paperbacks', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JPC', 'Junior Picture Book', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JPER', 'Junior Periodical', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JREF', 'Junior Reference', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JVF', 'Junior Vertical File', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'JVID', 'Junior rental video', '7', '1', '3.0000',0); +INSERT INTO itemtypes VALUES( 'LP', 'Large Print', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'MAP', 'Maps', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'NF', 'Adult Non-fiction', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'NFLP', 'NonFiction LargePrint', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'NFYA', 'Young Adult Non Fiction', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'NGA', 'Nga Pukapuka', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'PAY', 'Pay Collection', '14', '1', '1.0000',0); +INSERT INTO itemtypes VALUES( 'PB', 'Pamphlet Box', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'PER', 'Periodicals Stand', '14', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'PHOT', 'Photograph', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'POS', 'Junior Posters', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'REF', 'Adult Reference Books', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'ROM', 'CD-Rom', '7', '1', '5.0000',0); +INSERT INTO itemtypes VALUES( 'STF', 'Stack Fiction', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'STJ', 'Stack Junior', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'STLP', 'Stack Large Print', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'STNF', 'Stack Non-fiction', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'TB', 'Talking Books', '14', '1', '2.0000',0); +INSERT INTO itemtypes VALUES( 'TREF', 'Taonga', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'VF', 'Vertical File', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'VID', 'Adult rental video', '7', '1', '3.0000',0); +INSERT INTO itemtypes VALUES( 'FTB', 'Free Talking Books', '21', '1', '0.0000',0); +INSERT INTO itemtypes VALUES( 'NLTB', 'National Library Talking Books', '21', '1', '2.0000',0); INSERT INTO printers VALUES( 'Shannon Issues', 'shanlp', 'docket'); INSERT INTO printers VALUES( 'Levin Issues', 'leviss', 'docket'); diff --git a/updater/updatedatabase b/updater/updatedatabase index b0c93c0842..087179bee4 100755 --- a/updater/updatedatabase +++ b/updater/updatedatabase @@ -133,11 +133,11 @@ my %requiretables=( libopac char(255) NOT NULL default '', repeatable tinyint(4) NOT NULL default '0', mandatory tinyint(4) NOT NULL default '0', - kohafield char(40) NOT NULL default '', - tab tinyint(1), + kohafield char(40) default NULL, + tab tinyint(1) default NULL, authorised_value char(10) default NULL, thesaurus_category char(10) default NULL, - value_builder char(80) NOT NULL default '', + value_builder char(80) default NULL, PRIMARY KEY (tagfield,tagsubfield), KEY kohafield (kohafield), KEY tab (tab) @@ -526,6 +526,9 @@ $sth->finish; exit; # $Log$ +# Revision 1.28 2002/12/10 13:27:47 tipaul +# bugfixes (davide mails in koha-dev) +# # Revision 1.27 2002/11/26 15:04:54 tipaul # road to 1.3.2. Updating db structure during installation # -- 2.39.2