[Koha-cvs] CVS: koha/updater sample_only_param_tables.sql,1.1,1.2 updatedatabase,1.27,1.28
Paul POULAIN
tipaul at users.sourceforge.net
Tue Dec 10 14:27:49 CET 2002
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
More information about the Koha-cvs
mailing list