-- +--------------------------------------------------------------------+
-- | CiviCRM version 3.1                                                |
-- +--------------------------------------------------------------------+
-- | Copyright CiviCRM LLC (c) 2004-2010                                |
-- +--------------------------------------------------------------------+
-- | This file is a part of CiviCRM.                                    |
-- |                                                                    |
-- | CiviCRM is free software; you can copy, modify, and distribute it  |
-- | under the terms of the GNU Affero General Public License           |
-- | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
-- |                                                                    |
-- | CiviCRM is distributed in the hope that it will be useful, but     |
-- | WITHOUT ANY WARRANTY; without even the implied warranty of         |
-- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
-- | See the GNU Affero General Public License for more details.        |
-- |                                                                    |
-- | You should have received a copy of the GNU Affero General Public   |
-- | License and the CiviCRM Licensing Exception along                  |
-- | with this program; if not, contact CiviCRM LLC                     |
-- | at info[AT]civicrm[DOT]org. If you have questions about the        |
-- | GNU Affero General Public License or the licensing of CiviCRM,     |
-- | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
-- +--------------------------------------------------------------------+
-- /*******************************************************
-- *
-- * Clean up the exisiting tables
-- *
-- *******************************************************/
DROP TABLE IF EXISTS civicrm_pledge_payment;
DROP TABLE IF EXISTS civicrm_participant_payment;
DROP TABLE IF EXISTS civicrm_participant;
DROP TABLE IF EXISTS civicrm_event;
DROP TABLE IF EXISTS civicrm_membership_payment;
DROP TABLE IF EXISTS civicrm_financial_trxn;
DROP TABLE IF EXISTS civicrm_contribution_soft;
DROP TABLE IF EXISTS civicrm_contribution_product;
DROP TABLE IF EXISTS civicrm_contribution;
DROP TABLE IF EXISTS civicrm_group_contact;
DROP TABLE IF EXISTS civicrm_loc_block;
DROP TABLE IF EXISTS civicrm_address;
DROP TABLE IF EXISTS civicrm_pcp_block;
DROP TABLE IF EXISTS civicrm_uf_join;
DROP TABLE IF EXISTS civicrm_uf_field;
DROP TABLE IF EXISTS civicrm_uf_group;
DROP TABLE IF EXISTS civicrm_county;
DROP TABLE IF EXISTS civicrm_line_item;
DROP TABLE IF EXISTS civicrm_price_field;
DROP TABLE IF EXISTS civicrm_pledge;
DROP TABLE IF EXISTS civicrm_case_activity;
DROP TABLE IF EXISTS civicrm_activity_target;
DROP TABLE IF EXISTS civicrm_activity_assignment;
DROP TABLE IF EXISTS civicrm_activity;
DROP TABLE IF EXISTS civicrm_membership_log;
DROP TABLE IF EXISTS civicrm_membership_block;
DROP TABLE IF EXISTS civicrm_membership;
DROP TABLE IF EXISTS civicrm_pcp;
DROP TABLE IF EXISTS civicrm_contribution_widget;
DROP TABLE IF EXISTS civicrm_contribution_page;
DROP TABLE IF EXISTS civicrm_mailing_event_unsubscribe;
DROP TABLE IF EXISTS civicrm_mailing_event_trackable_url_open;
DROP TABLE IF EXISTS civicrm_mailing_event_confirm;
DROP TABLE IF EXISTS civicrm_mailing_event_subscribe;
DROP TABLE IF EXISTS civicrm_mailing_event_reply;
DROP TABLE IF EXISTS civicrm_mailing_event_opened;
DROP TABLE IF EXISTS civicrm_mailing_event_forward;
DROP TABLE IF EXISTS civicrm_mailing_event_delivered;
DROP TABLE IF EXISTS civicrm_mailing_event_bounce;
DROP TABLE IF EXISTS civicrm_mailing_event_queue;
DROP TABLE IF EXISTS civicrm_relationship;
DROP TABLE IF EXISTS civicrm_group_organization;
DROP TABLE IF EXISTS civicrm_group_nesting;
DROP TABLE IF EXISTS civicrm_group_contact_cache;
DROP TABLE IF EXISTS civicrm_subscription_history;
DROP TABLE IF EXISTS civicrm_group;
DROP TABLE IF EXISTS civicrm_dashboard_contact;
DROP TABLE IF EXISTS civicrm_acl_cache;
DROP TABLE IF EXISTS civicrm_openid;
DROP TABLE IF EXISTS civicrm_timezone;
DROP TABLE IF EXISTS civicrm_uf_match;
DROP TABLE IF EXISTS civicrm_state_province;
DROP TABLE IF EXISTS civicrm_preferences;
DROP TABLE IF EXISTS civicrm_phone;
DROP TABLE IF EXISTS civicrm_option_value;
DROP TABLE IF EXISTS civicrm_note;
DROP TABLE IF EXISTS civicrm_menu;
DROP TABLE IF EXISTS civicrm_mapping_field;
DROP TABLE IF EXISTS civicrm_log;
DROP TABLE IF EXISTS civicrm_im;
DROP TABLE IF EXISTS civicrm_entity_tag;
DROP TABLE IF EXISTS civicrm_entity_file;
DROP TABLE IF EXISTS civicrm_email;
DROP TABLE IF EXISTS civicrm_dashboard;
DROP TABLE IF EXISTS civicrm_custom_field;
DROP TABLE IF EXISTS civicrm_custom_group;
DROP TABLE IF EXISTS civicrm_country;
DROP TABLE IF EXISTS civicrm_cache;
DROP TABLE IF EXISTS civicrm_price_set_entity;
DROP TABLE IF EXISTS civicrm_price_set;
DROP TABLE IF EXISTS civicrm_report_instance;
DROP TABLE IF EXISTS civicrm_pledge_block;
DROP TABLE IF EXISTS civicrm_openid_associations;
DROP TABLE IF EXISTS civicrm_openid_nonces;
DROP TABLE IF EXISTS civicrm_tell_friend;
DROP TABLE IF EXISTS civicrm_grant;
DROP TABLE IF EXISTS civicrm_case_contact;
DROP TABLE IF EXISTS civicrm_case;
DROP TABLE IF EXISTS civicrm_dedupe_rule;
DROP TABLE IF EXISTS civicrm_dedupe_rule_group;
DROP TABLE IF EXISTS civicrm_participant_status_type;
DROP TABLE IF EXISTS civicrm_membership_status;
DROP TABLE IF EXISTS civicrm_membership_type;
DROP TABLE IF EXISTS civicrm_task_status;
DROP TABLE IF EXISTS civicrm_task;
DROP TABLE IF EXISTS civicrm_project;
DROP TABLE IF EXISTS civicrm_premiums_product;
DROP TABLE IF EXISTS civicrm_product;
DROP TABLE IF EXISTS civicrm_premiums;
DROP TABLE IF EXISTS civicrm_contribution_type;
DROP TABLE IF EXISTS civicrm_contribution_recur;
DROP TABLE IF EXISTS civicrm_mailing_spool;
DROP TABLE IF EXISTS civicrm_mailing_bounce_pattern;
DROP TABLE IF EXISTS civicrm_mailing_bounce_type;
DROP TABLE IF EXISTS civicrm_mailing_job;
DROP TABLE IF EXISTS civicrm_mailing_trackable_url;
DROP TABLE IF EXISTS civicrm_mailing_group;
DROP TABLE IF EXISTS civicrm_mailing;
DROP TABLE IF EXISTS civicrm_mailing_component;
DROP TABLE IF EXISTS civicrm_contact_type;
DROP TABLE IF EXISTS civicrm_saved_search;
DROP TABLE IF EXISTS civicrm_relationship_type;
DROP TABLE IF EXISTS civicrm_acl_contact_cache;
DROP TABLE IF EXISTS civicrm_contact;
DROP TABLE IF EXISTS civicrm_acl_entity_role;
DROP TABLE IF EXISTS civicrm_acl;
DROP TABLE IF EXISTS civicrm_discount;
DROP TABLE IF EXISTS civicrm_component;
DROP TABLE IF EXISTS civicrm_worldregion;
DROP TABLE IF EXISTS civicrm_tag;
DROP TABLE IF EXISTS civicrm_preferences_date;
DROP TABLE IF EXISTS civicrm_payment_processor_type;
DROP TABLE IF EXISTS civicrm_payment_processor;
DROP TABLE IF EXISTS civicrm_option_group;
DROP TABLE IF EXISTS civicrm_navigation;
DROP TABLE IF EXISTS civicrm_msg_template;
DROP TABLE IF EXISTS civicrm_mapping;
DROP TABLE IF EXISTS civicrm_mail_settings;
DROP TABLE IF EXISTS civicrm_location_type;
DROP TABLE IF EXISTS civicrm_file;
DROP TABLE IF EXISTS civicrm_domain;
DROP TABLE IF EXISTS civicrm_currency;