2 # ianb@erislabs.net 20080212
3 # empty out a mir db ready to reload a database dump
5 # uploaded_media should be last because other tables depend on it
6 TABLES="active_article_classification active_groups
7 active_multimedia_file active_publishbuffer
8 active_ratings_system active_usertable active_webcast
9 active_webcast_groups active_webcast_groups_appear
10 active_weblink article_type audio breaking comment
11 comment_status comment_x_media content content_x_media
12 content_x_topic features_category features_feature_categories
13 features_features features_imc_site_info features_language
14 features_site_languages features_tmp_features_count filter
15 filter_group images img_color img_format img_layout img_type
16 language media_folder media_type messages other_media rights
17 topic video webdb_users
20 SEQUENCES="category_id_seq features_id_seq imc_site_info_id_seq
21 groupid webcastid weblinkid publishbufferid
22 article_classificationid webcast_groupsid
23 webcast_groups_appearid usertableid multimedia_fileid
24 ratings_systemid media_folder_id_seq media_type_id_seq
25 language_id_seq comment_status_id_seq webdb_users_id_seq
26 article_type_id_seq topic_id_seq comment_id_seq
27 media_id_seq breaking_id_seq messages_id_seq filter_id_seq
33 echo "usage: $0 [dbname]" 1>&2
34 echo " deletes mir db ready for a database restore" 1>&2
35 echo " USE WITH CARE - will destroy your mir database" 1>&2
40 echo "DROP LANGUAGE plpgsql;"
41 echo "DROP FUNCTION plpgsql_call_handler ( ) ;"
48 echo "DROP SEQUENCE $i;"
50 ) | sudo -u postgres psql "$1"