[Koha] Deleting the installation sample library file

[Edgar Fuß]

> I realize that a "delete my whole structure" might be a dangerous "in
> production" command for Koha - but that is what I need now - to start with a
> clean slate. Do I have to do a complete re-install without the test/sample file?
I attach such a DANGEROUS drop-all script.

DON'T DO THIS ON A PRODUCTION SYSTEM. You will lose your WHOLE koha structure and will have to re-install.
Call with mysql -h mysql -u koha -p koha < koha_drop.sql or whatever your MySQL server and koha user and koha database are called.
YOU HAVE BEEN WARNED.

The advantage to dropping the koha database is that you don't lose permissions and passwords.
-------------- next part --------------
DROP TABLE accountlines;
DROP TABLE accountoffsets;
DROP TABLE action_logs;
DROP TABLE alert;
DROP TABLE aqorderdelivery;
DROP TABLE aqorders;
DROP TABLE aqbasket;
DROP TABLE aqbasketgroups;
DROP TABLE aqbudgetperiods;
DROP TABLE aqbudgets_planning;
DROP TABLE aqcontract;
DROP TABLE aqorders_items;
DROP TABLE auth_header;
DROP TABLE auth_subfield_structure;
DROP TABLE auth_tag_structure;
DROP TABLE auth_types;
DROP TABLE authorised_values;
DROP TABLE biblio_framework;
DROP TABLE borrower_attributes;
DROP TABLE borrower_message_transport_preferences;
DROP TABLE branch_borrower_circ_rules;
DROP TABLE branch_item_rules;
DROP TABLE branch_transfer_limits;
DROP TABLE branchrelations;
DROP TABLE branchtransfers;
DROP TABLE browser;
DROP TABLE cities;
DROP TABLE class_sources;
DROP TABLE default_borrower_circ_rules;
DROP TABLE default_branch_circ_rules;
DROP TABLE default_branch_item_rules;
DROP TABLE default_circ_rules;
DROP TABLE deletedbiblio;
DROP TABLE deletedbiblioitems;
DROP TABLE deletedborrowers;
DROP TABLE deleteditems;
DROP TABLE ethnicity;
DROP TABLE export_format;
DROP TABLE fieldmapping;
DROP TABLE hold_fill_targets;
DROP TABLE import_biblios;
DROP TABLE import_items;
DROP TABLE import_record_matches;
DROP TABLE import_records;
DROP TABLE issues;
DROP TABLE issuingrules;
DROP TABLE itemtypes;
DROP TABLE language_descriptions;
DROP TABLE language_rfc4646_to_iso639;
DROP TABLE language_script_bidi;
DROP TABLE language_script_mapping;
DROP TABLE language_subtag_registry;
DROP TABLE marc_subfield_structure;
DROP TABLE marc_tag_structure;
DROP TABLE matchchecks;
DROP TABLE matcher_matchpoints;
DROP TABLE matchpoint_component_norms;
DROP TABLE matchpoint_components;
DROP TABLE matchpoints;
DROP TABLE message_queue;
DROP TABLE message_transports;
DROP TABLE notifys;
DROP TABLE nozebra;
DROP TABLE old_issues;
DROP TABLE old_reserves;
DROP TABLE opac_news;
DROP TABLE overduerules;
DROP TABLE patroncards;
DROP TABLE patronimage;
DROP TABLE printers;
DROP TABLE printers_profile;
DROP TABLE repeatable_holidays;
DROP TABLE reports_dictionary;
DROP TABLE reserveconstraints;
DROP TABLE reserves;
DROP TABLE reviews;
DROP TABLE roadtype;
DROP TABLE saved_reports;
DROP TABLE saved_sql;
DROP TABLE search_history;
DROP TABLE serialitems;
DROP TABLE services_throttle;
DROP TABLE sessions;
DROP TABLE special_holidays;
DROP TABLE statistics;
DROP TABLE stopwords;
DROP TABLE subscription;
DROP TABLE subscriptionhistory;
DROP TABLE subscriptionroutinglist;
DROP TABLE suggestions;
DROP TABLE systempreferences;
DROP TABLE tags;
DROP TABLE tags_all;
DROP TABLE tags_index;
DROP TABLE tmp_holdsqueue;
DROP TABLE user_permissions;
DROP TABLE virtualshelfcontents;
DROP TABLE virtualshelves;
DROP TABLE z3950servers;
DROP TABLE zebraqueue;
DROP TABLE aqbooksellers;
DROP TABLE aqbudgets;
DROP TABLE borrower_attribute_types;
DROP TABLE borrower_message_preferences;
DROP TABLE branchcategories;
DROP TABLE class_sort_rules;
DROP TABLE currency;
DROP TABLE import_batches;
DROP TABLE item_circulation_alert_preferences;
DROP TABLE collections;
DROP TABLE collections_tracking;
DROP TABLE creator_batches;
DROP TABLE creator_images;
DROP TABLE creator_layouts;
DROP TABLE creator_templates;
DROP TABLE items;
DROP TABLE letter;
DROP TABLE marc_matchers;
DROP TABLE messages;
DROP TABLE message_attributes;
DROP TABLE message_transport_types;
DROP TABLE permissions;
DROP TABLE serial;
DROP TABLE tags_approval;
DROP TABLE userflags;
DROP TABLE biblioitems;
DROP TABLE borrowers;
DROP TABLE branches;
DROP TABLE categories;
DROP TABLE biblio;