|
Lines 1-152
Link Here
|
| 1 |
INSERT INTO aqbookfund VALUES( '5', 'Young Adult Fiction', '3'); |
|
|
| 2 |
INSERT INTO aqbookfund VALUES( '4', 'Fiction', '2'); |
| 3 |
INSERT INTO aqbookfund VALUES( '2', 'Talking books', '4'); |
| 4 |
INSERT INTO aqbookfund VALUES( '13', 'Newspapers & journals', '4'); |
| 5 |
INSERT INTO aqbookfund VALUES( '10', 'Te Ao Maori', '1'); |
| 6 |
INSERT INTO aqbookfund VALUES( '15', 'CDs, CD Roms, Maps, etc', '4'); |
| 7 |
INSERT INTO aqbookfund VALUES( '9', 'Junior Fiction', '3'); |
| 8 |
INSERT INTO aqbookfund VALUES( '7', 'Junior Non-Fiction', '3'); |
| 9 |
INSERT INTO aqbookfund VALUES( '72', 'Creative NZ', '4'); |
| 10 |
INSERT INTO aqbookfund VALUES( '11', 'Reference', '1'); |
| 11 |
INSERT INTO aqbookfund VALUES( '12', 'Videos', '4'); |
| 12 |
INSERT INTO aqbookfund VALUES( '8', 'Junior Paperback', '3'); |
| 13 |
INSERT INTO aqbookfund VALUES( '73', 'Large Print Link-up', '2'); |
| 14 |
INSERT INTO aqbookfund VALUES( '3', 'Large Print', '2'); |
| 15 |
INSERT INTO aqbookfund VALUES( '71', 'Creative NZ NonFiction', '1'); |
| 16 |
INSERT INTO aqbookfund VALUES( '6', 'Picture Books', '3'); |
| 17 |
INSERT INTO aqbookfund VALUES( '14', 'Nga pukapuka Maori', '3'); |
| 18 |
INSERT INTO aqbookfund VALUES( '80', 'Donations, junior books', '5'); |
| 19 |
INSERT INTO aqbookfund VALUES( '81', 'Donations, adult books', '5'); |
| 20 |
INSERT INTO aqbookfund VALUES( '82', 'Donations, magazines', '5'); |
| 21 |
INSERT INTO aqbookfund VALUES( '83', 'Donations, non books', '5'); |
| 22 |
INSERT INTO aqbookfund VALUES( '91', 'Vertical File', '5'); |
| 23 |
INSERT INTO aqbookfund VALUES( '100', 'Loans', '6'); |
| 24 |
INSERT INTO aqbookfund VALUES( '1', 'Test', '1'); |
| 25 |
|
| 26 |
INSERT INTO aqbudget VALUES( '1', '1999-07-01', '2000-06-30', '39000.00'); |
| 27 |
INSERT INTO aqbudget VALUES( '5', '1999-07-01', '2000-06-30', '3000.00'); |
| 28 |
INSERT INTO aqbudget VALUES( '4', '1999-07-01', '2000-06-30', '28000.00'); |
| 29 |
INSERT INTO aqbudget VALUES( '2', '1999-07-01', '2000-06-30', '2000.00'); |
| 30 |
INSERT INTO aqbudget VALUES( '13', '1999-07-01', '2000-06-30', '13000.00'); |
| 31 |
INSERT INTO aqbudget VALUES( '10', '1999-07-01', '2000-06-30', '7000.00'); |
| 32 |
INSERT INTO aqbudget VALUES( '15', '1999-07-01', '2000-06-30', '4000.00'); |
| 33 |
INSERT INTO aqbudget VALUES( '9', '1999-07-01', '2000-06-30', '1000.00'); |
| 34 |
INSERT INTO aqbudget VALUES( '7', '1999-07-01', '2000-06-30', '12000.00'); |
| 35 |
INSERT INTO aqbudget VALUES( '72', '1999-07-01', '2000-06-30', '1000.00'); |
| 36 |
INSERT INTO aqbudget VALUES( '11', '1999-07-01', '2000-06-30', '9000.00'); |
| 37 |
INSERT INTO aqbudget VALUES( '12', '1999-07-01', '2000-06-30', '7000.00'); |
| 38 |
INSERT INTO aqbudget VALUES( '8', '1999-07-01', '2000-06-30', '4300.00'); |
| 39 |
INSERT INTO aqbudget VALUES( '73', '1999-07-01', '2000-06-30', '20000.00'); |
| 40 |
INSERT INTO aqbudget VALUES( '3', '1999-07-01', '2000-06-30', '10000.00'); |
| 41 |
INSERT INTO aqbudget VALUES( '71', '1999-07-01', '2000-06-30', '2000.00'); |
| 42 |
INSERT INTO aqbudget VALUES( '6', '1999-07-01', '2000-06-30', '10000.00'); |
| 43 |
INSERT INTO aqbudget VALUES( '14', '1999-07-01', '2000-06-30', '700.00'); |
| 44 |
INSERT INTO aqbudget VALUES( '80', '1999-07-01', '2000-06-30', '0.00'); |
| 45 |
INSERT INTO aqbudget VALUES( '81', '1999-07-01', '2000-06-30', '0.00'); |
| 46 |
INSERT INTO aqbudget VALUES( '82', '1999-07-01', '2000-06-30', '0.00'); |
| 47 |
INSERT INTO aqbudget VALUES( '83', '1999-07-01', '2000-06-30', '0.00'); |
| 48 |
INSERT INTO aqbudget VALUES( '91', '1999-07-01', '2000-06-30', '0.00'); |
| 49 |
INSERT INTO aqbudget VALUES( '100', '1999-07-01', '2000-06-30', '0.00'); |
| 50 |
|
| 51 |
INSERT INTO branches VALUES( 'C', 'Levin', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 52 |
INSERT INTO branches VALUES( 'F', 'Foxton', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 53 |
INSERT INTO branches VALUES( 'FM', 'Foxton Mending', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 54 |
INSERT INTO branches VALUES( 'FP', 'Foxton Permanent Colln.', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 55 |
INSERT INTO branches VALUES( 'I', 'Interloan', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 56 |
INSERT INTO branches VALUES( 'M', 'Mending', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 57 |
INSERT INTO branches VALUES( 'P', 'Processing', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 58 |
INSERT INTO branches VALUES( 'S', 'Shannon', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 59 |
INSERT INTO branches VALUES( 'SP', 'Shannon Permanent Colln.', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 60 |
INSERT INTO branches VALUES( 'T', 'Tokomaru', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 61 |
INSERT INTO branches VALUES( 'TR', 'Transit', '', NULL, NULL, NULL, NULL, NULL, NULL); |
| 62 |
INSERT INTO branches VALUES( 'D', 'District', NULL, NULL, NULL, NULL, NULL, NULL, NULL); |
| 63 |
|
| 64 |
INSERT INTO categories VALUES( 'I', 'Institution', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); |
| 65 |
INSERT INTO categories VALUES( 'W', 'Workers', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); |
| 66 |
INSERT INTO categories VALUES( 'A', 'Adult', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '1.000000'); |
| 67 |
INSERT INTO categories VALUES( 'B', 'Housebound', '5', '99', '0', 'E', '0', '0.000000', '0', '99', '0.000000'); |
| 68 |
INSERT INTO categories VALUES( 'E', 'Senior Citizen', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '1.000000'); |
| 69 |
INSERT INTO categories VALUES( 'F', 'Family', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '1.000000'); |
| 70 |
INSERT INTO categories VALUES( 'C', 'Child', '5', '16', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); |
| 71 |
INSERT INTO categories VALUES( 'P', 'Privileged', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); |
| 72 |
INSERT INTO categories VALUES( 'L', 'Library', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); |
| 73 |
|
| 74 |
INSERT INTO currency VALUES( 'NZD', '1.00000'); |
| 75 |
INSERT INTO currency VALUES( 'AUD', '0.60000'); |
| 76 |
INSERT INTO currency VALUES( 'USD', '0.49000'); |
| 77 |
|
| 78 |
INSERT INTO itemtypes VALUES( 'ART', 'Art Prints', '42', '1', '0.0000',0); |
| 79 |
INSERT INTO itemtypes VALUES( 'BCD', 'CD-ROM from book', '21', '1', '0.0000',0); |
| 80 |
INSERT INTO itemtypes VALUES( 'CAS', 'Cassette', '14', '0', '1.0000',0); |
| 81 |
INSERT INTO itemtypes VALUES( 'CD', 'Compact disc (WN)', '14', '1', '2.0000',0); |
| 82 |
INSERT INTO itemtypes VALUES( 'F', 'Free Fiction', '21', '1', '0.0000',0); |
| 83 |
INSERT INTO itemtypes VALUES( 'FJV', 'Junior free video', '21', '1', '0.0000',0); |
| 84 |
INSERT INTO itemtypes VALUES( 'FVID', 'Adult free video', '21', '1', '0.0000',0); |
| 85 |
INSERT INTO itemtypes VALUES( 'FYA', 'Young Adult Fiction', '21', '1', '0.0000',0); |
| 86 |
INSERT INTO itemtypes VALUES( 'GWB', 'Get Well Bags', '21', '1', '0.0000',0); |
| 87 |
INSERT INTO itemtypes VALUES( 'HCVF', 'Horowhenua Collection Vertical File', '21', '1', '0.0000',0); |
| 88 |
INSERT INTO itemtypes VALUES( 'IL', 'Interloan', '22', '1', '0.0000',0); |
| 89 |
INSERT INTO itemtypes VALUES( 'JCF', 'Junior Castle Fiction', '21', '1', '0.0000',0); |
| 90 |
INSERT INTO itemtypes VALUES( 'JCNF', 'Junior Castle Non-fictio', '21', '1', '0.0000',0); |
| 91 |
INSERT INTO itemtypes VALUES( 'JF', 'Junior Fiction', '21', '1', '0.0000',0); |
| 92 |
INSERT INTO itemtypes VALUES( 'JHC', 'Junior Horowhenua Collection VF', '21', '1', '0.0000',0); |
| 93 |
INSERT INTO itemtypes VALUES( 'JIG', 'Jigsaw puzzle', '21', '1', '0.0000',0); |
| 94 |
INSERT INTO itemtypes VALUES( 'JK', 'Junior Kermit ', '21', '1', '0.0000',0); |
| 95 |
INSERT INTO itemtypes VALUES( 'JNF', 'Junior Non-Fiction', '21', '1', '0.0000',0); |
| 96 |
INSERT INTO itemtypes VALUES( 'JPB', 'Junior Paperbacks', '21', '1', '0.0000',0); |
| 97 |
INSERT INTO itemtypes VALUES( 'JPC', 'Junior Picture Book', '21', '1', '0.0000',0); |
| 98 |
INSERT INTO itemtypes VALUES( 'JPER', 'Junior Periodical', '21', '1', '0.0000',0); |
| 99 |
INSERT INTO itemtypes VALUES( 'JREF', 'Junior Reference', '21', '1', '0.0000',0); |
| 100 |
INSERT INTO itemtypes VALUES( 'JVF', 'Junior Vertical File', '21', '1', '0.0000',0); |
| 101 |
INSERT INTO itemtypes VALUES( 'JVID', 'Junior rental video', '7', '1', '3.0000',0); |
| 102 |
INSERT INTO itemtypes VALUES( 'LP', 'Large Print', '21', '1', '0.0000',0); |
| 103 |
INSERT INTO itemtypes VALUES( 'MAP', 'Maps', '21', '1', '0.0000',0); |
| 104 |
INSERT INTO itemtypes VALUES( 'NF', 'Adult Non-fiction', '21', '1', '0.0000',0); |
| 105 |
INSERT INTO itemtypes VALUES( 'NFLP', 'NonFiction LargePrint', '21', '1', '0.0000',0); |
| 106 |
INSERT INTO itemtypes VALUES( 'NFYA', 'Young Adult Non Fiction', '21', '1', '0.0000',0); |
| 107 |
INSERT INTO itemtypes VALUES( 'NGA', 'Nga Pukapuka', '21', '1', '0.0000',0); |
| 108 |
INSERT INTO itemtypes VALUES( 'PAY', 'Pay Collection', '14', '1', '1.0000',0); |
| 109 |
INSERT INTO itemtypes VALUES( 'PB', 'Pamphlet Box', '21', '1', '0.0000',0); |
| 110 |
INSERT INTO itemtypes VALUES( 'PER', 'Periodicals Stand', '14', '1', '0.0000',0); |
| 111 |
INSERT INTO itemtypes VALUES( 'PHOT', 'Photograph', '21', '1', '0.0000',0); |
| 112 |
INSERT INTO itemtypes VALUES( 'POS', 'Junior Posters', '21', '1', '0.0000',0); |
| 113 |
INSERT INTO itemtypes VALUES( 'REF', 'Adult Reference Books', '21', '1', '0.0000',0); |
| 114 |
INSERT INTO itemtypes VALUES( 'ROM', 'CD-Rom', '7', '1', '5.0000',0); |
| 115 |
INSERT INTO itemtypes VALUES( 'STF', 'Stack Fiction', '21', '1', '0.0000',0); |
| 116 |
INSERT INTO itemtypes VALUES( 'STJ', 'Stack Junior', '21', '1', '0.0000',0); |
| 117 |
INSERT INTO itemtypes VALUES( 'STLP', 'Stack Large Print', '21', '1', '0.0000',0); |
| 118 |
INSERT INTO itemtypes VALUES( 'STNF', 'Stack Non-fiction', '21', '1', '0.0000',0); |
| 119 |
INSERT INTO itemtypes VALUES( 'TB', 'Talking Books', '14', '1', '2.0000',0); |
| 120 |
INSERT INTO itemtypes VALUES( 'TREF', 'Taonga', '21', '1', '0.0000',0); |
| 121 |
INSERT INTO itemtypes VALUES( 'VF', 'Vertical File', '21', '1', '0.0000',0); |
| 122 |
INSERT INTO itemtypes VALUES( 'VID', 'Adult rental video', '7', '1', '3.0000',0); |
| 123 |
INSERT INTO itemtypes VALUES( 'FTB', 'Free Talking Books', '21', '1', '0.0000',0); |
| 124 |
INSERT INTO itemtypes VALUES( 'NLTB', 'National Library Talking Books', '21', '1', '2.0000',0); |
| 125 |
|
| 126 |
INSERT INTO printers VALUES( 'Shannon Issues', 'shanlp', 'docket'); |
| 127 |
INSERT INTO printers VALUES( 'Levin Issues', 'leviss', 'docket'); |
| 128 |
INSERT INTO printers VALUES( 'Levin Returns', 'levret', 'docket'); |
| 129 |
INSERT INTO printers VALUES( 'Foxton Issue', 'foxlp', 'docket'); |
| 130 |
INSERT INTO printers VALUES( 'No Printer', 'nulllp', ''); |
| 131 |
INSERT INTO printers VALUES( 'Laser Printer', 'lp', ''); |
| 132 |
|
| 133 |
INSERT INTO stopwords VALUES( 'A'); |
| 134 |
INSERT INTO stopwords VALUES( 'AND'); |
| 135 |
INSERT INTO stopwords VALUES( 'ASSOC'); |
| 136 |
INSERT INTO stopwords VALUES( 'ASSOCIATES'); |
| 137 |
INSERT INTO stopwords VALUES( 'CO'); |
| 138 |
INSERT INTO stopwords VALUES( 'COMPANY'); |
| 139 |
INSERT INTO stopwords VALUES( 'CORP'); |
| 140 |
INSERT INTO stopwords VALUES( 'CORPORATION'); |
| 141 |
INSERT INTO stopwords VALUES( 'INC'); |
| 142 |
INSERT INTO stopwords VALUES( 'INCORPORATED'); |
| 143 |
INSERT INTO stopwords VALUES( 'LTD'); |
| 144 |
INSERT INTO stopwords VALUES( 'OF'); |
| 145 |
INSERT INTO stopwords VALUES( 'THE'); |
| 146 |
INSERT INTO stopwords VALUES( 'THIS'); |
| 147 |
|
| 148 |
INSERT INTO users VALUES( 'C', 'Levin', 'engido', '1'); |
| 149 |
INSERT INTO users VALUES( 'S', 'Shannon', 'xeyangu', '1'); |
| 150 |
INSERT INTO users VALUES( 'F', 'Foxton', 'thoochi', '1'); |
| 151 |
INSERT INTO users VALUES( 'T', 'Tokomaru', 'kadiesee', '1'); |
| 152 |
|
| 153 |
- |