In version 0.7 the default material type is "book" and collection is "Adult Nonfiction". If your library is not predominantly books or is books but is not predominantly Adult Nonfiction you may wish change the default material or collection type - which can be done by setting flags in the appropriate database table. The "default_flg" column in table "material_type_dm" and the "default_flg" in "collection_dm" controls the default material and collection respectively. Login into your OpenBiblio database using your database tool of choice and run the following SQL: " As an example: you run a library lending mostly children's stories on CD - so you want to change the default material to "cd audio" and the collection to "Juvenile Fiction" from the default material type of "book" and collection of "Adult Nonfiction". From the above SQL select statements you will see the code for "cd audio" is "3" in the material_type_dm table and for "Juvenile Fiction" is "7" in the collection_dm table and the default material type of "book" and collection of "Adult Nonfiction" the code is "2" in both cases. For this example you would run the following SQL update statements: To set remove the current default material type of "book" as a default:
" To set new default of "cd audio" as default:
" To remove the current default collection type of "Adult Nonfiction" as a default:
" To set new default of "Juvenile Fiction" as default:
" If you run the SQL select statements above again you can check this is now only one default material and collection type and it is set to your newly chosen defaults. |