crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/sql/civicrm_drop.mysql

   1 -- +--------------------------------------------------------------------+
   2 -- | CiviCRM version 4.6                                                |
   3 -- +--------------------------------------------------------------------+
   4 -- | Copyright CiviCRM LLC (c) 2004-2015                                |
   5 -- +--------------------------------------------------------------------+
   6 -- | This file is a part of CiviCRM.                                    |
   7 -- |                                                                    |
   8 -- | CiviCRM is free software; you can copy, modify, and distribute it  |
   9 -- | under the terms of the GNU Affero General Public License           |
  10 -- | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
  11 -- |                                                                    |
  12 -- | CiviCRM is distributed in the hope that it will be useful, but     |
  13 -- | WITHOUT ANY WARRANTY; without even the implied warranty of         |
  14 -- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
  15 -- | See the GNU Affero General Public License for more details.        |
  16 -- |                                                                    |
  17 -- | You should have received a copy of the GNU Affero General Public   |
  18 -- | License and the CiviCRM Licensing Exception along                  |
  19 -- | with this program; if not, contact CiviCRM LLC                     |
  20 -- | at info[AT]civicrm[DOT]org. If you have questions about the        |
  21 -- | GNU Affero General Public License or the licensing of CiviCRM,     |
  22 -- | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  23 -- +--------------------------------------------------------------------+
  24 --
  25 -- Generated from drop.tpl
  26 -- DO NOT EDIT.  Generated by CRM_Core_CodeGen
  27 --
  28 -- /*******************************************************
  29 -- *
  30 -- * Clean up the exisiting tables
  31 -- *
  32 -- *******************************************************/
  33
  34 SET FOREIGN_KEY_CHECKS=0;
  35
  36 DROP TABLE IF EXISTS `civicrm_line_item`;
  37 DROP TABLE IF EXISTS `civicrm_pledge_payment`;
  38 DROP TABLE IF EXISTS `civicrm_events_in_carts`;
  39 DROP TABLE IF EXISTS `civicrm_participant_payment`;
  40 DROP TABLE IF EXISTS `civicrm_participant`;
  41 DROP TABLE IF EXISTS `civicrm_event`;
  42 DROP TABLE IF EXISTS `civicrm_membership_payment`;
  43 DROP TABLE IF EXISTS `civicrm_entity_financial_trxn`;
  44 DROP TABLE IF EXISTS `civicrm_contribution_soft`;
  45 DROP TABLE IF EXISTS `civicrm_contribution_product`;
  46 DROP TABLE IF EXISTS `civicrm_contribution`;
  47 DROP TABLE IF EXISTS `civicrm_group_contact`;
  48 DROP TABLE IF EXISTS `civicrm_loc_block`;
  49 DROP TABLE IF EXISTS `civicrm_address`;
  50 DROP TABLE IF EXISTS `civicrm_pcp_block`;
  51 DROP TABLE IF EXISTS `civicrm_price_field_value`;
  52 DROP TABLE IF EXISTS `civicrm_price_field`;
  53 DROP TABLE IF EXISTS `civicrm_case_activity`;
  54 DROP TABLE IF EXISTS `civicrm_activity_contact`;
  55 DROP TABLE IF EXISTS `civicrm_activity`;
  56 DROP TABLE IF EXISTS `civicrm_membership_log`;
  57 DROP TABLE IF EXISTS `civicrm_membership`;
  58 DROP TABLE IF EXISTS `civicrm_financial_trxn`;
  59 DROP TABLE IF EXISTS `civicrm_contribution_recur`;
  60 DROP TABLE IF EXISTS `civicrm_relationship`;
  61 DROP TABLE IF EXISTS `civicrm_dashboard_contact`;
  62 DROP TABLE IF EXISTS `civicrm_action_log`;
  63 DROP TABLE IF EXISTS `civicrm_action_schedule`;
  64 DROP TABLE IF EXISTS `civicrm_uf_join`;
  65 DROP TABLE IF EXISTS `civicrm_uf_field`;
  66 DROP TABLE IF EXISTS `civicrm_uf_group`;
  67 DROP TABLE IF EXISTS `civicrm_entity_tag`;
  68 DROP TABLE IF EXISTS `civicrm_discount`;
  69 DROP TABLE IF EXISTS `civicrm_dashboard`;
  70 DROP TABLE IF EXISTS `civicrm_county`;
  71 DROP TABLE IF EXISTS `civicrm_price_set_entity`;
  72 DROP TABLE IF EXISTS `civicrm_price_set`;
  73 DROP TABLE IF EXISTS `civicrm_report_instance`;
  74 DROP TABLE IF EXISTS `civicrm_pledge`;
  75 DROP TABLE IF EXISTS `civicrm_case_contact`;
  76 DROP TABLE IF EXISTS `civicrm_case`;
  77 DROP TABLE IF EXISTS `civicrm_membership_block`;
  78 DROP TABLE IF EXISTS `civicrm_membership_type`;
  79 DROP TABLE IF EXISTS `civicrm_payment_token`;
  80 DROP TABLE IF EXISTS `civicrm_payment_processor`;
  81 DROP TABLE IF EXISTS `civicrm_contribution_widget`;
  82 DROP TABLE IF EXISTS `civicrm_premiums_product`;
  83 DROP TABLE IF EXISTS `civicrm_product`;
  84 DROP TABLE IF EXISTS `civicrm_contribution_page`;
  85 DROP TABLE IF EXISTS `civicrm_mailing_event_unsubscribe`;
  86 DROP TABLE IF EXISTS `civicrm_mailing_event_trackable_url_open`;
  87 DROP TABLE IF EXISTS `civicrm_mailing_event_confirm`;
  88 DROP TABLE IF EXISTS `civicrm_mailing_event_subscribe`;
  89 DROP TABLE IF EXISTS `civicrm_mailing_event_reply`;
  90 DROP TABLE IF EXISTS `civicrm_mailing_event_opened`;
  91 DROP TABLE IF EXISTS `civicrm_mailing_event_forward`;
  92 DROP TABLE IF EXISTS `civicrm_mailing_event_delivered`;
  93 DROP TABLE IF EXISTS `civicrm_mailing_event_bounce`;
  94 DROP TABLE IF EXISTS `civicrm_mailing_event_queue`;
  95 DROP TABLE IF EXISTS `civicrm_mailing_spool`;
  96 DROP TABLE IF EXISTS `civicrm_mailing_recipients`;
  97 DROP TABLE IF EXISTS `civicrm_mailing_job`;
  98 DROP TABLE IF EXISTS `civicrm_mailing_trackable_url`;
  99 DROP TABLE IF EXISTS `civicrm_mailing_group`;
 100 DROP TABLE IF EXISTS `civicrm_mailing`;
 101 DROP TABLE IF EXISTS `civicrm_group_organization`;
 102 DROP TABLE IF EXISTS `civicrm_group_nesting`;
 103 DROP TABLE IF EXISTS `civicrm_group_contact_cache`;
 104 DROP TABLE IF EXISTS `civicrm_subscription_history`;
 105 DROP TABLE IF EXISTS `civicrm_group`;
 106 DROP TABLE IF EXISTS `civicrm_acl_cache`;
 107 DROP TABLE IF EXISTS `civicrm_word_replacement`;
 108 DROP TABLE IF EXISTS `civicrm_print_label`;
 109 DROP TABLE IF EXISTS `civicrm_setting`;
 110 DROP TABLE IF EXISTS `civicrm_website`;
 111 DROP TABLE IF EXISTS `civicrm_openid`;
 112 DROP TABLE IF EXISTS `civicrm_timezone`;
 113 DROP TABLE IF EXISTS `civicrm_uf_match`;
 114 DROP TABLE IF EXISTS `civicrm_tag`;
 115 DROP TABLE IF EXISTS `civicrm_state_province`;
 116 DROP TABLE IF EXISTS `civicrm_phone`;
 117 DROP TABLE IF EXISTS `civicrm_option_value`;
 118 DROP TABLE IF EXISTS `civicrm_note`;
 119 DROP TABLE IF EXISTS `civicrm_navigation`;
 120 DROP TABLE IF EXISTS `civicrm_menu`;
 121 DROP TABLE IF EXISTS `civicrm_mapping_field`;
 122 DROP TABLE IF EXISTS `civicrm_mail_settings`;
 123 DROP TABLE IF EXISTS `civicrm_log`;
 124 DROP TABLE IF EXISTS `civicrm_job_log`;
 125 DROP TABLE IF EXISTS `civicrm_job`;
 126 DROP TABLE IF EXISTS `civicrm_im`;
 127 DROP TABLE IF EXISTS `civicrm_entity_file`;
 128 DROP TABLE IF EXISTS `civicrm_email`;
 129 DROP TABLE IF EXISTS `civicrm_domain`;
 130 DROP TABLE IF EXISTS `civicrm_custom_field`;
 131 DROP TABLE IF EXISTS `civicrm_custom_group`;
 132 DROP TABLE IF EXISTS `civicrm_country`;
 133 DROP TABLE IF EXISTS `civicrm_cache`;
 134 DROP TABLE IF EXISTS `civicrm_cxn`;
 135 DROP TABLE IF EXISTS `civicrm_pcp`;
 136 DROP TABLE IF EXISTS `civicrm_queue_item`;
 137 DROP TABLE IF EXISTS `civicrm_pledge_block`;
 138 DROP TABLE IF EXISTS `civicrm_tell_friend`;
 139 DROP TABLE IF EXISTS `civicrm_grant`;
 140 DROP TABLE IF EXISTS `civicrm_case_type`;
 141 DROP TABLE IF EXISTS `civicrm_dedupe_exception`;
 142 DROP TABLE IF EXISTS `civicrm_dedupe_rule`;
 143 DROP TABLE IF EXISTS `civicrm_dedupe_rule_group`;
 144 DROP TABLE IF EXISTS `civicrm_event_carts`;
 145 DROP TABLE IF EXISTS `civicrm_participant_status_type`;
 146 DROP TABLE IF EXISTS `civicrm_survey`;
 147 DROP TABLE IF EXISTS `civicrm_campaign_group`;
 148 DROP TABLE IF EXISTS `civicrm_campaign`;
 149 DROP TABLE IF EXISTS `civicrm_membership_status`;
 150 DROP TABLE IF EXISTS `civicrm_sms_provider`;
 151 DROP TABLE IF EXISTS `civicrm_financial_item`;
 152 DROP TABLE IF EXISTS `civicrm_entity_financial_account`;
 153 DROP TABLE IF EXISTS `civicrm_financial_type`;
 154 DROP TABLE IF EXISTS `civicrm_payment_processor_type`;
 155 DROP TABLE IF EXISTS `civicrm_financial_account`;
 156 DROP TABLE IF EXISTS `civicrm_currency`;
 157 DROP TABLE IF EXISTS `civicrm_premiums`;
 158 DROP TABLE IF EXISTS `civicrm_mailing_bounce_pattern`;
 159 DROP TABLE IF EXISTS `civicrm_mailing_bounce_type`;
 160 DROP TABLE IF EXISTS `civicrm_mailing_abtest`;
 161 DROP TABLE IF EXISTS `civicrm_mailing_component`;
 162 DROP TABLE IF EXISTS `civicrm_entity_batch`;
 163 DROP TABLE IF EXISTS `civicrm_batch`;
 164 DROP TABLE IF EXISTS `civicrm_contact_type`;
 165 DROP TABLE IF EXISTS `civicrm_saved_search`;
 166 DROP TABLE IF EXISTS `civicrm_relationship_type`;
 167 DROP TABLE IF EXISTS `civicrm_acl_contact_cache`;
 168 DROP TABLE IF EXISTS `civicrm_contact`;
 169 DROP TABLE IF EXISTS `civicrm_acl_entity_role`;
 170 DROP TABLE IF EXISTS `civicrm_acl`;
 171 DROP TABLE IF EXISTS `civicrm_recurring_entity`;
 172 DROP TABLE IF EXISTS `civicrm_action_mapping`;
 173 DROP TABLE IF EXISTS `civicrm_prevnext_cache`;
 174 DROP TABLE IF EXISTS `civicrm_persistent`;
 175 DROP TABLE IF EXISTS `civicrm_component`;
 176 DROP TABLE IF EXISTS `civicrm_worldregion`;
 177 DROP TABLE IF EXISTS `civicrm_system_log`;
 178 DROP TABLE IF EXISTS `civicrm_preferences_date`;
 179 DROP TABLE IF EXISTS `civicrm_option_group`;
 180 DROP TABLE IF EXISTS `civicrm_msg_template`;
 181 DROP TABLE IF EXISTS `civicrm_mapping`;
 182 DROP TABLE IF EXISTS `civicrm_managed`;
 183 DROP TABLE IF EXISTS `civicrm_location_type`;
 184 DROP TABLE IF EXISTS `civicrm_file`;
 185 DROP TABLE IF EXISTS `civicrm_extension`;
 186 DROP TABLE IF EXISTS `civicrm_address_format`;
 187
 188 SET FOREIGN_KEY_CHECKS=1;