moving localfiles to tmp

[koha.git] / updater / sample_only_param_tables.sql

diff --git a/updater/sample_only_param_tables.sql b/updater/sample_only_param_tables.sql
index 0b53333..1f55257 100644 (file)
--- 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');