[Koha-cvs] CVS: koha/updater sample_only_param_tables.sql,1.1,1.2 updatedatabase,1.27,1.28

[Paul POULAIN]

Update of /cvsroot/koha/koha/updater
In directory sc8-pr-cvs1:/tmp/cvs-serv10548/updater

Modified Files:
        sample_only_param_tables.sql updatedatabase 
Log Message:
bugfixes (davide mails in koha-dev)

Index: sample_only_param_tables.sql
===================================================================
RCS file: /cvsroot/koha/koha/updater/sample_only_param_tables.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** sample_only_param_tables.sql        19 Mar 2002 15:37:15 -0000      1.1
--- sample_only_param_tables.sql        10 Dec 2002 13:27:47 -0000      1.2
***************
*** 76,126 ****
  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 printers VALUES( 'Shannon Issues', 'shanlp', 'docket');
--- 76,126 ----
  INSERT INTO currency VALUES( 'USD', '0.49000');
  
! 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');

Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.27
retrieving revision 1.28
diff -C2 -r1.27 -r1.28
*** updatedatabase      26 Nov 2002 15:04:54 -0000      1.27
--- updatedatabase      10 Dec 2002 13:27:47 -0000      1.28
***************
*** 134,142 ****
                                                repeatable tinyint(4) NOT NULL 
default '0',
                                                mandatory tinyint(4) NOT NULL 
default '0',
!                                               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),
--- 134,142 ----
                                                repeatable tinyint(4) NOT NULL 
default '0',
                                                mandatory tinyint(4) NOT NULL 
default '0',
!                                               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) default 
NULL,
                                                PRIMARY KEY  
(tagfield,tagsubfield),
                                                KEY kohafield (kohafield),
***************
*** 527,530 ****
--- 527,533 ----
  
  # $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