sampledata [Koha Developer Wiki]

Subject:

        Re: [Koha] gripe + NT struggles
    Date: 
        Tue, 19 Mar 2002 16:43:10 +0100
   From: 
        paul POULAIN <paul.poulain@free.fr>
     To: 
        Chris Cormack <chris@katipo.co.nz>
     CC: 
        Andrew Hooper <telomere@iconz.co.nz>, koha@lists.katipo.co.nz

References:

        1 , 2

Chris Cormack wrote:

On Tue, 2002-03-19 at 21:39, Andrew Hooper wrote:

 Chris et. al - I have been following this thread with interest - you may
 recall I'm the mug trying to port Koha over to NT.
 My 2c worth - I did download the sample-data and found it too large and
 unwieldy to be of any practical use. If anyone can contribue a smaller
 sample-data set from a *working* system, I for one would find that of
 great assistance.

Hi Andrew,
I guess I can go threw the sample data and drop out all the tables that
arent needed to be added manually. And make a smaller version for that
purpose. 
I'll have a go at that in the weekend. Hopefully someone else might beat
me to it.

I've beated you it seems :-) )))) You will find the sample datas in attachment, and I've commited it in CVS too (updater directory)

– Paul

INSERT INTO aqbookfund VALUES( '5', 'Young Adult Fiction', '3'); INSERT INTO aqbookfund VALUES( '4', 'Fiction', '2'); INSERT INTO aqbookfund VALUES( '2', 'Talking books', '4'); INSERT INTO aqbookfund VALUES( '13', 'Newspapers & journals', '4'); INSERT INTO aqbookfund VALUES( '10', 'Te Ao Maori', '1'); INSERT INTO aqbookfund VALUES( '15', 'CDs, CD Roms, Maps, etc', '4'); INSERT INTO aqbookfund VALUES( '9', 'Junior Fiction', '3'); INSERT INTO aqbookfund VALUES( '7', 'Junior Non-Fiction', '3'); INSERT INTO aqbookfund VALUES( '72', 'Creative NZ', '4'); INSERT INTO aqbookfund VALUES( '11', 'Reference', '1'); INSERT INTO aqbookfund VALUES( '12', 'Videos', '4'); INSERT INTO aqbookfund VALUES( '8', 'Junior Paperback', '3'); INSERT INTO aqbookfund VALUES( '73', 'Large Print Link-up', '2'); INSERT INTO aqbookfund VALUES( '3', 'Large Print', '2'); INSERT INTO aqbookfund VALUES( '71', 'Creative NZ NonFiction', '1'); INSERT INTO aqbookfund VALUES( '6', 'Picture Books', '3'); INSERT INTO aqbookfund VALUES( '14', 'Nga pukapuka Maori', '3'); INSERT INTO aqbookfund VALUES( '80', 'Donations, junior books', '5'); INSERT INTO aqbookfund VALUES( '81', 'Donations, adult books', '5'); INSERT INTO aqbookfund VALUES( '82', 'Donations, magazines', '5'); INSERT INTO aqbookfund VALUES( '83', 'Donations, non books', '5'); INSERT INTO aqbookfund VALUES( '91', 'Vertical File', '5'); INSERT INTO aqbookfund VALUES( '100', 'Loans', '6'); INSERT INTO aqbookfund VALUES( '1', 'Test', '1');

INSERT INTO aqbudget VALUES( '1', '1999-07-01', '2000-06-30', '39000.00'); INSERT INTO aqbudget VALUES( '5', '1999-07-01', '2000-06-30', '3000.00'); INSERT INTO aqbudget VALUES( '4', '1999-07-01', '2000-06-30', '28000.00'); INSERT INTO aqbudget VALUES( '2', '1999-07-01', '2000-06-30', '2000.00'); INSERT INTO aqbudget VALUES( '13', '1999-07-01', '2000-06-30', '13000.00'); INSERT INTO aqbudget VALUES( '10', '1999-07-01', '2000-06-30', '7000.00'); INSERT INTO aqbudget VALUES( '15', '1999-07-01', '2000-06-30', '4000.00'); INSERT INTO aqbudget VALUES( '9', '1999-07-01', '2000-06-30', '1000.00'); INSERT INTO aqbudget VALUES( '7', '1999-07-01', '2000-06-30', '12000.00'); INSERT INTO aqbudget VALUES( '72', '1999-07-01', '2000-06-30', '1000.00'); INSERT INTO aqbudget VALUES( '11', '1999-07-01', '2000-06-30', '9000.00'); INSERT INTO aqbudget VALUES( '12', '1999-07-01', '2000-06-30', '7000.00'); INSERT INTO aqbudget VALUES( '8', '1999-07-01', '2000-06-30', '4300.00'); INSERT INTO aqbudget VALUES( '73', '1999-07-01', '2000-06-30', '20000.00'); INSERT INTO aqbudget VALUES( '3', '1999-07-01', '2000-06-30', '10000.00'); INSERT INTO aqbudget VALUES( '71', '1999-07-01', '2000-06-30', '2000.00'); INSERT INTO aqbudget VALUES( '6', '1999-07-01', '2000-06-30', '10000.00'); INSERT INTO aqbudget VALUES( '14', '1999-07-01', '2000-06-30', '700.00'); INSERT INTO aqbudget VALUES( '80', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO aqbudget VALUES( '81', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO aqbudget VALUES( '82', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO aqbudget VALUES( '83', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO aqbudget VALUES( '91', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO aqbudget VALUES( '100', '1999-07-01', '2000-06-30', '0.00');

INSERT INTO branches VALUES( 'C', 'Levin', , NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'F', 'Foxton',, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'FM', 'Foxton Mending', , NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'FP', 'Foxton Permanent Colln.',, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'I', 'Interloan', , NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'M', 'Mending',, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'P', 'Processing', , NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'S', 'Shannon',, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'SP', 'Shannon Permanent Colln.', , NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'T', 'Tokomaru',, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'TR', 'Transit', , NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'D', 'District', NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO categories VALUES( 'I', 'Institution', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO categories VALUES( 'W', 'Workers', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO categories VALUES( 'A', 'Adult', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '1.000000'); INSERT INTO categories VALUES( 'B', 'Housebound', '5', '99', '0', 'E', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO categories VALUES( 'E', 'Senior Citizen', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '1.000000'); INSERT INTO categories VALUES( 'F', 'Family', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '1.000000'); INSERT INTO categories VALUES( 'C', 'Child', '5', '16', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO categories VALUES( 'P', 'Privileged', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO categories VALUES( 'L', 'Library', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); 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 printers VALUES( 'Shannon Issues', 'shanlp', 'docket'); INSERT INTO printers VALUES( 'Levin Issues', 'leviss', 'docket'); INSERT INTO printers VALUES( 'Levin Returns', 'levret', 'docket'); INSERT INTO printers VALUES( 'Foxton Issue', 'foxlp', 'docket'); INSERT INTO printers VALUES( 'No Printer', 'nulllp',); INSERT INTO printers VALUES( 'Laser Printer', 'lp', '');

INSERT INTO stopwords VALUES( 'A'); INSERT INTO stopwords VALUES( 'AND'); INSERT INTO stopwords VALUES( 'ASSOC'); INSERT INTO stopwords VALUES( 'ASSOCIATES'); INSERT INTO stopwords VALUES( 'CO'); INSERT INTO stopwords VALUES( 'COMPANY'); INSERT INTO stopwords VALUES( 'CORP'); INSERT INTO stopwords VALUES( 'CORPORATION'); INSERT INTO stopwords VALUES( 'INC'); INSERT INTO stopwords VALUES( 'INCORPORATED'); INSERT INTO stopwords VALUES( 'LTD'); INSERT INTO stopwords VALUES( 'OF'); INSERT INTO stopwords VALUES( 'THE'); INSERT INTO stopwords VALUES( 'THIS');

INSERT INTO users VALUES( 'C', 'Levin', 'engido', '1'); INSERT INTO users VALUES( 'S', 'Shannon', 'xeyangu', '1'); INSERT INTO users VALUES( 'F', 'Foxton', 'thoochi', '1'); INSERT INTO users VALUES( 'T', 'Tokomaru', 'kadiesee', '1');