projects / weblabels.fsf.org.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
commiting uncommited changes on live site
[weblabels.fsf.org.git] / crm.fsf.org / 20131203 / files / sites / all / modules-old / civicrm / sql / civicrm_drop.mysql
CommitLineData
7f254ad8
AE		 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
34SET FOREIGN_KEY_CHECKS=0;
35
36DROP TABLE IF EXISTS `civicrm_line_item`;
37DROP TABLE IF EXISTS `civicrm_pledge_payment`;
38DROP TABLE IF EXISTS `civicrm_events_in_carts`;
39DROP TABLE IF EXISTS `civicrm_participant_payment`;
40DROP TABLE IF EXISTS `civicrm_participant`;
41DROP TABLE IF EXISTS `civicrm_event`;
42DROP TABLE IF EXISTS `civicrm_membership_payment`;
43DROP TABLE IF EXISTS `civicrm_entity_financial_trxn`;
44DROP TABLE IF EXISTS `civicrm_contribution_soft`;
45DROP TABLE IF EXISTS `civicrm_contribution_product`;
46DROP TABLE IF EXISTS `civicrm_contribution`;
47DROP TABLE IF EXISTS `civicrm_group_contact`;
48DROP TABLE IF EXISTS `civicrm_loc_block`;
49DROP TABLE IF EXISTS `civicrm_address`;
50DROP TABLE IF EXISTS `civicrm_pcp_block`;
51DROP TABLE IF EXISTS `civicrm_price_field_value`;
52DROP TABLE IF EXISTS `civicrm_price_field`;
53DROP TABLE IF EXISTS `civicrm_case_activity`;
54DROP TABLE IF EXISTS `civicrm_activity_contact`;
55DROP TABLE IF EXISTS `civicrm_activity`;
56DROP TABLE IF EXISTS `civicrm_membership_log`;
57DROP TABLE IF EXISTS `civicrm_membership`;
58DROP TABLE IF EXISTS `civicrm_financial_trxn`;
59DROP TABLE IF EXISTS `civicrm_contribution_recur`;
60DROP TABLE IF EXISTS `civicrm_relationship`;
61DROP TABLE IF EXISTS `civicrm_dashboard_contact`;
62DROP TABLE IF EXISTS `civicrm_action_log`;
63DROP TABLE IF EXISTS `civicrm_action_schedule`;
64DROP TABLE IF EXISTS `civicrm_uf_join`;
65DROP TABLE IF EXISTS `civicrm_uf_field`;
66DROP TABLE IF EXISTS `civicrm_uf_group`;
67DROP TABLE IF EXISTS `civicrm_entity_tag`;
68DROP TABLE IF EXISTS `civicrm_discount`;
69DROP TABLE IF EXISTS `civicrm_dashboard`;
70DROP TABLE IF EXISTS `civicrm_county`;
71DROP TABLE IF EXISTS `civicrm_price_set_entity`;
72DROP TABLE IF EXISTS `civicrm_price_set`;
73DROP TABLE IF EXISTS `civicrm_report_instance`;
74DROP TABLE IF EXISTS `civicrm_pledge`;
75DROP TABLE IF EXISTS `civicrm_case_contact`;
76DROP TABLE IF EXISTS `civicrm_case`;
77DROP TABLE IF EXISTS `civicrm_membership_block`;
78DROP TABLE IF EXISTS `civicrm_membership_type`;
79DROP TABLE IF EXISTS `civicrm_payment_token`;
80DROP TABLE IF EXISTS `civicrm_payment_processor`;
81DROP TABLE IF EXISTS `civicrm_contribution_widget`;
82DROP TABLE IF EXISTS `civicrm_premiums_product`;
83DROP TABLE IF EXISTS `civicrm_product`;
84DROP TABLE IF EXISTS `civicrm_contribution_page`;
85DROP TABLE IF EXISTS `civicrm_mailing_event_unsubscribe`;
86DROP TABLE IF EXISTS `civicrm_mailing_event_trackable_url_open`;
87DROP TABLE IF EXISTS `civicrm_mailing_event_confirm`;
88DROP TABLE IF EXISTS `civicrm_mailing_event_subscribe`;
89DROP TABLE IF EXISTS `civicrm_mailing_event_reply`;
90DROP TABLE IF EXISTS `civicrm_mailing_event_opened`;
91DROP TABLE IF EXISTS `civicrm_mailing_event_forward`;
92DROP TABLE IF EXISTS `civicrm_mailing_event_delivered`;
93DROP TABLE IF EXISTS `civicrm_mailing_event_bounce`;
94DROP TABLE IF EXISTS `civicrm_mailing_event_queue`;
95DROP TABLE IF EXISTS `civicrm_mailing_spool`;
96DROP TABLE IF EXISTS `civicrm_mailing_recipients`;
97DROP TABLE IF EXISTS `civicrm_mailing_job`;
98DROP TABLE IF EXISTS `civicrm_mailing_trackable_url`;
99DROP TABLE IF EXISTS `civicrm_mailing_group`;
100DROP TABLE IF EXISTS `civicrm_mailing`;
101DROP TABLE IF EXISTS `civicrm_group_organization`;
102DROP TABLE IF EXISTS `civicrm_group_nesting`;
103DROP TABLE IF EXISTS `civicrm_group_contact_cache`;
104DROP TABLE IF EXISTS `civicrm_subscription_history`;
105DROP TABLE IF EXISTS `civicrm_group`;
106DROP TABLE IF EXISTS `civicrm_acl_cache`;
107DROP TABLE IF EXISTS `civicrm_word_replacement`;
108DROP TABLE IF EXISTS `civicrm_print_label`;
109DROP TABLE IF EXISTS `civicrm_setting`;
110DROP TABLE IF EXISTS `civicrm_website`;
111DROP TABLE IF EXISTS `civicrm_openid`;
112DROP TABLE IF EXISTS `civicrm_timezone`;
113DROP TABLE IF EXISTS `civicrm_uf_match`;
114DROP TABLE IF EXISTS `civicrm_tag`;
115DROP TABLE IF EXISTS `civicrm_state_province`;
116DROP TABLE IF EXISTS `civicrm_phone`;
117DROP TABLE IF EXISTS `civicrm_option_value`;
118DROP TABLE IF EXISTS `civicrm_note`;
119DROP TABLE IF EXISTS `civicrm_navigation`;
120DROP TABLE IF EXISTS `civicrm_menu`;
121DROP TABLE IF EXISTS `civicrm_mapping_field`;
122DROP TABLE IF EXISTS `civicrm_mail_settings`;
123DROP TABLE IF EXISTS `civicrm_log`;
124DROP TABLE IF EXISTS `civicrm_job_log`;
125DROP TABLE IF EXISTS `civicrm_job`;
126DROP TABLE IF EXISTS `civicrm_im`;
127DROP TABLE IF EXISTS `civicrm_entity_file`;
128DROP TABLE IF EXISTS `civicrm_email`;
129DROP TABLE IF EXISTS `civicrm_domain`;
130DROP TABLE IF EXISTS `civicrm_custom_field`;
131DROP TABLE IF EXISTS `civicrm_custom_group`;
132DROP TABLE IF EXISTS `civicrm_country`;
133DROP TABLE IF EXISTS `civicrm_cache`;
134DROP TABLE IF EXISTS `civicrm_cxn`;
135DROP TABLE IF EXISTS `civicrm_pcp`;
136DROP TABLE IF EXISTS `civicrm_queue_item`;
137DROP TABLE IF EXISTS `civicrm_pledge_block`;
138DROP TABLE IF EXISTS `civicrm_tell_friend`;
139DROP TABLE IF EXISTS `civicrm_grant`;
140DROP TABLE IF EXISTS `civicrm_case_type`;
141DROP TABLE IF EXISTS `civicrm_dedupe_exception`;
142DROP TABLE IF EXISTS `civicrm_dedupe_rule`;
143DROP TABLE IF EXISTS `civicrm_dedupe_rule_group`;
144DROP TABLE IF EXISTS `civicrm_event_carts`;
145DROP TABLE IF EXISTS `civicrm_participant_status_type`;
146DROP TABLE IF EXISTS `civicrm_survey`;
147DROP TABLE IF EXISTS `civicrm_campaign_group`;
148DROP TABLE IF EXISTS `civicrm_campaign`;
149DROP TABLE IF EXISTS `civicrm_membership_status`;
150DROP TABLE IF EXISTS `civicrm_sms_provider`;
151DROP TABLE IF EXISTS `civicrm_financial_item`;
152DROP TABLE IF EXISTS `civicrm_entity_financial_account`;
153DROP TABLE IF EXISTS `civicrm_financial_type`;
154DROP TABLE IF EXISTS `civicrm_payment_processor_type`;
155DROP TABLE IF EXISTS `civicrm_financial_account`;
156DROP TABLE IF EXISTS `civicrm_currency`;
157DROP TABLE IF EXISTS `civicrm_premiums`;
158DROP TABLE IF EXISTS `civicrm_mailing_bounce_pattern`;
159DROP TABLE IF EXISTS `civicrm_mailing_bounce_type`;
160DROP TABLE IF EXISTS `civicrm_mailing_abtest`;
161DROP TABLE IF EXISTS `civicrm_mailing_component`;
162DROP TABLE IF EXISTS `civicrm_entity_batch`;
163DROP TABLE IF EXISTS `civicrm_batch`;
164DROP TABLE IF EXISTS `civicrm_contact_type`;
165DROP TABLE IF EXISTS `civicrm_saved_search`;
166DROP TABLE IF EXISTS `civicrm_relationship_type`;
167DROP TABLE IF EXISTS `civicrm_acl_contact_cache`;
168DROP TABLE IF EXISTS `civicrm_contact`;
169DROP TABLE IF EXISTS `civicrm_acl_entity_role`;
170DROP TABLE IF EXISTS `civicrm_acl`;
171DROP TABLE IF EXISTS `civicrm_recurring_entity`;
172DROP TABLE IF EXISTS `civicrm_action_mapping`;
173DROP TABLE IF EXISTS `civicrm_prevnext_cache`;
174DROP TABLE IF EXISTS `civicrm_persistent`;
175DROP TABLE IF EXISTS `civicrm_component`;
176DROP TABLE IF EXISTS `civicrm_worldregion`;
177DROP TABLE IF EXISTS `civicrm_system_log`;
178DROP TABLE IF EXISTS `civicrm_preferences_date`;
179DROP TABLE IF EXISTS `civicrm_option_group`;
180DROP TABLE IF EXISTS `civicrm_msg_template`;
181DROP TABLE IF EXISTS `civicrm_mapping`;
182DROP TABLE IF EXISTS `civicrm_managed`;
183DROP TABLE IF EXISTS `civicrm_location_type`;
184DROP TABLE IF EXISTS `civicrm_file`;
185DROP TABLE IF EXISTS `civicrm_extension`;
186DROP TABLE IF EXISTS `civicrm_address_format`;
187
188SET FOREIGN_KEY_CHECKS=1;