, INDEX FKEY_acl_id ( acl_id ) ,
FOREIGN KEY (acl_id) REFERENCES civicrm_acl(id)
, INDEX index_acl_id( acl_id)
-
+
) TYPE=InnoDB;
-- /*******************************************************
FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
) TYPE=InnoDB ;
-
+
-- /*******************************************************
-- *
-- * Modify the civicrm_acl Table Structure
-- *******************************************************/
- ALTER TABLE `civicrm_acl` ADD domain_id int unsigned NOT NULL DEFAULT '0' COMMENT 'Which Domain owns this contact';
- ALTER TABLE `civicrm_acl` ADD INDEX FKEY_domain_id (domain_id);
- ALTER TABLE `civicrm_acl` ADD FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id);
+ ALTER TABLE `civicrm_acl` ADD domain_id int unsigned NOT NULL DEFAULT '0' COMMENT 'Which Domain owns this contact';
+ ALTER TABLE `civicrm_acl` ADD INDEX FKEY_domain_id (domain_id);
+ ALTER TABLE `civicrm_acl` ADD FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id);
- ALTER TABLE `civicrm_acl` ADD name varchar(64) COMMENT 'ACL Name.';
+ ALTER TABLE `civicrm_acl` ADD name varchar(64) COMMENT 'ACL Name.';
- ALTER TABLE `civicrm_acl` CHANGE `operation` `operation` ENUM('All', 'View', 'Edit', 'Create', 'Delete', 'Grant', 'Revoke') NOT NULL COMMENT 'What operation does this ACL entry control?';
+ ALTER TABLE `civicrm_acl` CHANGE `operation` `operation` ENUM('All', 'View', 'Edit', 'Create', 'Delete', 'Grant', 'Revoke') NOT NULL COMMENT 'What operation does this ACL entry control?';
- ALTER TABLE `civicrm_acl` ADD is_active tinyint(4) COMMENT 'Is this property active?';
-
- ALTER TABLE `civicrm_acl` ADD INDEX index_acl_id (acl_id);
+ ALTER TABLE `civicrm_acl` ADD is_active tinyint(4) COMMENT 'Is this property active?';
+
+ ALTER TABLE `civicrm_acl` ADD INDEX index_acl_id (acl_id);
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_activity` ADD INDEX UI_activity_type_id (`activity_type_id`);
- ALTER TABLE `civicrm_activity` DROP FOREIGN KEY `civicrm_activity_ibfk_2`;
- ALTER TABLE `civicrm_activity` DROP INDEX `FKEY_activity_type_id`;
+ ALTER TABLE `civicrm_activity` ADD INDEX UI_activity_type_id (`activity_type_id`);
+ ALTER TABLE `civicrm_activity` DROP FOREIGN KEY `civicrm_activity_ibfk_2`;
+ ALTER TABLE `civicrm_activity` DROP INDEX `FKEY_activity_type_id`;
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_activity_history` ADD INDEX index_activity (`activity_id`);
+ ALTER TABLE `civicrm_activity_history` ADD INDEX index_activity (`activity_id`);
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE civicrm_contact ADD INDEX index_contact_type_domain (contact_type, domain_id);
- ALTER TABLE civicrm_contact ADD INDEX index_contact_sub_type_domain (contact_sub_type, domain_id);
- ALTER TABLE civicrm_contact ADD INDEX index_preferred_communication_method (preferred_communication_method);
-
- UPDATE civicrm_contact
- SET `preferred_communication_method` = CONCAT(char(1),`preferred_communication_method`,char(1))
- WHERE civicrm_contact.preferred_communication_method IS NOT NULL;
-
+ ALTER TABLE civicrm_contact ADD INDEX index_contact_type_domain (contact_type, domain_id);
+ ALTER TABLE civicrm_contact ADD INDEX index_contact_sub_type_domain (contact_sub_type, domain_id);
+ ALTER TABLE civicrm_contact ADD INDEX index_preferred_communication_method (preferred_communication_method);
+
+ UPDATE civicrm_contact
+ SET `preferred_communication_method` = CONCAT(char(1),`preferred_communication_method`,char(1))
+ WHERE civicrm_contact.preferred_communication_method IS NOT NULL;
+
-- /*******************************************************
-- *
-- * civicrm_contribution
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_contribution` ADD `contribution_status_id` int unsigned DEFAULT '1';
- ALTER TABLE `civicrm_contribution` DROP FOREIGN KEY `civicrm_contribution_ibfk_6`;
- ALTER TABLE `civicrm_contribution` DROP FOREIGN KEY `civicrm_contribution_ibfk_7`;
- ALTER TABLE `civicrm_contribution` DROP INDEX `FKEY_payment_instrument_id`;
- ALTER TABLE `civicrm_contribution` DROP INDEX `FKEY_recur_contribution_id`;
-
- ALTER TABLE `civicrm_contribution` DROP recur_contribution_id;
-
- ALTER TABLE `civicrm_contribution` ADD is_test tinyint NULL DEFAULT 0;
- ALTER TABLE `civicrm_contribution` ADD `honor_contact_id` int unsigned COMMENT 'FK to contact ID';
- ALTER TABLE `civicrm_contribution` ADD contribution_recur_id int unsigned AFTER note;
- ALTER TABLE `civicrm_contribution` ADD INDEX FKEY_contribution_recur_id (contribution_recur_id);
- ALTER TABLE `civicrm_contribution` ADD CONSTRAINT FOREIGN KEY (`contribution_recur_id`) REFERENCES civicrm_contribution_recur (`id`);
-
- ALTER TABLE `civicrm_contribution` ADD INDEX `UI_contrib_payment_instrument_id`(payment_instrument_id);
- ALTER TABLE `civicrm_contribution` ADD INDEX `index_contribution_status` (contribution_status_id);
- ALTER TABLE `civicrm_contribution` ADD INDEX FKEY_honor_contact_id (honor_contact_id);
- ALTER TABLE `civicrm_contribution` ADD CONSTRAINT FOREIGN KEY (`honor_contact_id`) REFERENCES `civicrm_contact` (`id`);
+ ALTER TABLE `civicrm_contribution` ADD `contribution_status_id` int unsigned DEFAULT '1';
+ ALTER TABLE `civicrm_contribution` DROP FOREIGN KEY `civicrm_contribution_ibfk_6`;
+ ALTER TABLE `civicrm_contribution` DROP FOREIGN KEY `civicrm_contribution_ibfk_7`;
+ ALTER TABLE `civicrm_contribution` DROP INDEX `FKEY_payment_instrument_id`;
+ ALTER TABLE `civicrm_contribution` DROP INDEX `FKEY_recur_contribution_id`;
+
+ ALTER TABLE `civicrm_contribution` DROP recur_contribution_id;
+
+ ALTER TABLE `civicrm_contribution` ADD is_test tinyint NULL DEFAULT 0;
+ ALTER TABLE `civicrm_contribution` ADD `honor_contact_id` int unsigned COMMENT 'FK to contact ID';
+ ALTER TABLE `civicrm_contribution` ADD contribution_recur_id int unsigned AFTER note;
+ ALTER TABLE `civicrm_contribution` ADD INDEX FKEY_contribution_recur_id (contribution_recur_id);
+ ALTER TABLE `civicrm_contribution` ADD CONSTRAINT FOREIGN KEY (`contribution_recur_id`) REFERENCES civicrm_contribution_recur (`id`);
+
+ ALTER TABLE `civicrm_contribution` ADD INDEX `UI_contrib_payment_instrument_id`(payment_instrument_id);
+ ALTER TABLE `civicrm_contribution` ADD INDEX `index_contribution_status` (contribution_status_id);
+ ALTER TABLE `civicrm_contribution` ADD INDEX FKEY_honor_contact_id (honor_contact_id);
+ ALTER TABLE `civicrm_contribution` ADD CONSTRAINT FOREIGN KEY (`honor_contact_id`) REFERENCES `civicrm_contact` (`id`);
- UPDATE civicrm_contribution SET contribution_status_id=3 WHERE cancel_date IS NOT NULL;
-
+ UPDATE civicrm_contribution SET contribution_status_id=3 WHERE cancel_date IS NOT NULL;
+
-- /*******************************************************
-- *
-- * civicrm_contribution_page
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_contribution_page` ADD honor_block_is_active tinyint COMMENT 'Should this contribution have the honor block enabled?';
- ALTER TABLE `civicrm_contribution_page` ADD honor_block_title varchar(255) COMMENT 'Title for honor block.';
- ALTER TABLE `civicrm_contribution_page` ADD honor_block_text text COMMENT 'text for honor block.';
- ALTER TABLE `civicrm_contribution_page` ADD is_monetary tinyint DEFAULT '1' COMMENT 'if true - allows real-time monetary transactions otherwise non-monetary transactions.';
- ALTER TABLE `civicrm_contribution_page` ADD is_recur tinyint NULL DEFAULT '0' AFTER is_monetary;
+ ALTER TABLE `civicrm_contribution_page` ADD honor_block_is_active tinyint COMMENT 'Should this contribution have the honor block enabled?';
+ ALTER TABLE `civicrm_contribution_page` ADD honor_block_title varchar(255) COMMENT 'Title for honor block.';
+ ALTER TABLE `civicrm_contribution_page` ADD honor_block_text text COMMENT 'text for honor block.';
+ ALTER TABLE `civicrm_contribution_page` ADD is_monetary tinyint DEFAULT '1' COMMENT 'if true - allows real-time monetary transactions otherwise non-monetary transactions.';
+ ALTER TABLE `civicrm_contribution_page` ADD is_recur tinyint NULL DEFAULT '0' AFTER is_monetary;
-- /*******************************************************
-- * civicrm_contribution_recur
-- *
-- *******************************************************/
-
- ALTER TABLE `civicrm_contribution_recur` ADD domain_id int unsigned NOT NULL DEFAULT '0' COMMENT 'Which Domain owns this contact';
- ALTER TABLE `civicrm_contribution_recur` ADD trxn_id varchar(255) COMMENT 'unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method';
- ALTER TABLE `civicrm_contribution_recur` ADD invoice_id varchar(255) COMMENT 'unique invoice id, system generated or passed in';
- ALTER TABLE `civicrm_contribution_recur` ADD contribution_status_id int unsigned NULL DEFAULT '1' AFTER invoice_id;
- ALTER TABLE `civicrm_contribution_recur` ADD end_date datetime NOT NULL AFTER cancel_date;
- ALTER TABLE `civicrm_contribution_recur` ADD is_test tinyint NULL DEFAULT '0' AFTER contribution_status_id;
-
- ALTER TABLE `civicrm_contribution_recur` MODIFY start_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
- ALTER TABLE `civicrm_contribution_recur` MODIFY create_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
- ALTER TABLE `civicrm_contribution_recur` MODIFY modified_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
- ALTER TABLE `civicrm_contribution_recur` MODIFY cancel_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
- ALTER TABLE `civicrm_contribution_recur` MODIFY next_sched_contribution datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
- ALTER TABLE `civicrm_contribution_recur` MODIFY failure_retry_date datetime NULL DEFAULT NULL;
-
- ALTER TABLE `civicrm_contribution_recur` DROP is_active;
-
- ALTER TABLE `civicrm_contribution_recur` ADD INDEX FKEY_domain_id (domain_id);
- ALTER TABLE `civicrm_contribution_recur` ADD INDEX index_contribution_status (contribution_status_id);
- ALTER TABLE `civicrm_contribution_recur` ADD FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id);
-
+
+ ALTER TABLE `civicrm_contribution_recur` ADD domain_id int unsigned NOT NULL DEFAULT '0' COMMENT 'Which Domain owns this contact';
+ ALTER TABLE `civicrm_contribution_recur` ADD trxn_id varchar(255) COMMENT 'unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method';
+ ALTER TABLE `civicrm_contribution_recur` ADD invoice_id varchar(255) COMMENT 'unique invoice id, system generated or passed in';
+ ALTER TABLE `civicrm_contribution_recur` ADD contribution_status_id int unsigned NULL DEFAULT '1' AFTER invoice_id;
+ ALTER TABLE `civicrm_contribution_recur` ADD end_date datetime NOT NULL AFTER cancel_date;
+ ALTER TABLE `civicrm_contribution_recur` ADD is_test tinyint NULL DEFAULT '0' AFTER contribution_status_id;
+
+ ALTER TABLE `civicrm_contribution_recur` MODIFY start_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
+ ALTER TABLE `civicrm_contribution_recur` MODIFY create_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
+ ALTER TABLE `civicrm_contribution_recur` MODIFY modified_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
+ ALTER TABLE `civicrm_contribution_recur` MODIFY cancel_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
+ ALTER TABLE `civicrm_contribution_recur` MODIFY next_sched_contribution datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
+ ALTER TABLE `civicrm_contribution_recur` MODIFY failure_retry_date datetime NULL DEFAULT NULL;
+
+ ALTER TABLE `civicrm_contribution_recur` DROP is_active;
+
+ ALTER TABLE `civicrm_contribution_recur` ADD INDEX FKEY_domain_id (domain_id);
+ ALTER TABLE `civicrm_contribution_recur` ADD INDEX index_contribution_status (contribution_status_id);
+ ALTER TABLE `civicrm_contribution_recur` ADD FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id);
+
-- /*******************************************************
-- *
-- * civicrm_custom_group
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_custom_group` ADD extends_entity_column_name varchar(64) COMMENT 'linking custom group for dynamic object';
- ALTER TABLE `civicrm_custom_group` ADD extends_entity_column_value varchar(64) COMMENT 'linking custom group for dynamic object';
-
- ALTER TABLE `civicrm_custom_group` MODIFY extends enum('Contact','Individual','Household','Organization','Location','Address','Contribution','Activity','Relationship','Phonecall','Meeting','Group','Membership') NULL DEFAULT 'Contact' COMMENT 'Type of object this group extends (can add other options later e.g. contact_address, etc.).';
-
- UPDATE civicrm_custom_group
- SET extends_entity_column_value=NULL
- WHERE extends='Activity';
-
- UPDATE civicrm_custom_group
- SET extends='Activity', extends_entity_column_value='2'
- WHERE extends='Phonecall';
-
- UPDATE civicrm_custom_group
- SET extends='Activity', extends_entity_column_value='1'
- WHERE extends='Meeting';
-
- UPDATE civicrm_custom_group
- SET extends_entity_column_value=NULL
- WHERE extends='Contact';
-
- UPDATE civicrm_custom_group
- SET extends_entity_column_value=NULL
- WHERE extends='Relationship';
-
+ ALTER TABLE `civicrm_custom_group` ADD extends_entity_column_name varchar(64) COMMENT 'linking custom group for dynamic object';
+ ALTER TABLE `civicrm_custom_group` ADD extends_entity_column_value varchar(64) COMMENT 'linking custom group for dynamic object';
+
+ ALTER TABLE `civicrm_custom_group` MODIFY extends enum('Contact','Individual','Household','Organization','Location','Address','Contribution','Activity','Relationship','Phonecall','Meeting','Group','Membership') NULL DEFAULT 'Contact' COMMENT 'Type of object this group extends (can add other options later e.g. contact_address, etc.).';
+
+ UPDATE civicrm_custom_group
+ SET extends_entity_column_value=NULL
+ WHERE extends='Activity';
+
+ UPDATE civicrm_custom_group
+ SET extends='Activity', extends_entity_column_value='2'
+ WHERE extends='Phonecall';
+
+ UPDATE civicrm_custom_group
+ SET extends='Activity', extends_entity_column_value='1'
+ WHERE extends='Meeting';
+
+ UPDATE civicrm_custom_group
+ SET extends_entity_column_value=NULL
+ WHERE extends='Contact';
+
+ UPDATE civicrm_custom_group
+ SET extends_entity_column_value=NULL
+ WHERE extends='Relationship';
+
-- /*******************************************************
-- *
-- * civicrm_custom_value
-- *
-- *******************************************************/
- ALTER TABLE civicrm_custom_value ADD INDEX index_int_field (int_data, custom_field_id);
- ALTER TABLE civicrm_custom_value ADD INDEX index_float_field (float_data, custom_field_id);
- ALTER TABLE civicrm_custom_value ADD INDEX index_decimal_field (decimal_data, custom_field_id);
- ALTER TABLE civicrm_custom_value ADD INDEX index_char_field (char_data, custom_field_id);
- ALTER TABLE civicrm_custom_value ADD INDEX index_date_field (date_data, custom_field_id);
+ ALTER TABLE civicrm_custom_value ADD INDEX index_int_field (int_data, custom_field_id);
+ ALTER TABLE civicrm_custom_value ADD INDEX index_float_field (float_data, custom_field_id);
+ ALTER TABLE civicrm_custom_value ADD INDEX index_decimal_field (decimal_data, custom_field_id);
+ ALTER TABLE civicrm_custom_value ADD INDEX index_char_field (char_data, custom_field_id);
+ ALTER TABLE civicrm_custom_value ADD INDEX index_date_field (date_data, custom_field_id);
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE civicrm_domain ADD config_backend text COMMENT 'Backend configuration.';
- ALTER TABLE civicrm_domain ADD config_frontend text COMMENT 'Frontend configuration.';
+ ALTER TABLE civicrm_domain ADD config_backend text COMMENT 'Backend configuration.';
+ ALTER TABLE civicrm_domain ADD config_frontend text COMMENT 'Frontend configuration.';
-- /*******************************************************
-- *
-- * Tag entities (Contacts, Groups, Actions) to categories.
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_entity_tag` ALTER COLUMN `entity_id` DROP DEFAULT;
- ALTER TABLE `civicrm_entity_tag` ALTER COLUMN `tag_id` DROP DEFAULT;
+ ALTER TABLE `civicrm_entity_tag` ALTER COLUMN `entity_id` DROP DEFAULT;
+ ALTER TABLE `civicrm_entity_tag` ALTER COLUMN `tag_id` DROP DEFAULT;
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_file` DROP FOREIGN KEY `civicrm_file_ibfk_1`;
- ALTER TABLE `civicrm_file` DROP INDEX `FKEY_file_type_id`;
+ ALTER TABLE `civicrm_file` DROP FOREIGN KEY `civicrm_file_ibfk_1`;
+ ALTER TABLE `civicrm_file` DROP INDEX `FKEY_file_type_id`;
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE civicrm_group ADD where_clause text NULL DEFAULT NULL AFTER visibility;
- ALTER TABLE civicrm_group ADD select_tables text NULL DEFAULT NULL AFTER where_clause;
- ALTER TABLE civicrm_group ADD where_tables text NULL DEFAULT NULL AFTER select_tables;
+ ALTER TABLE civicrm_group ADD where_clause text NULL DEFAULT NULL AFTER visibility;
+ ALTER TABLE civicrm_group ADD select_tables text NULL DEFAULT NULL AFTER where_clause;
+ ALTER TABLE civicrm_group ADD where_tables text NULL DEFAULT NULL AFTER select_tables;
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_im` DROP FOREIGN KEY civicrm_im_ibfk_2;
- ALTER TABLE `civicrm_im` DROP INDEX FKEY_provider_id;
- ALTER TABLE `civicrm_im` ADD INDEX UI_provider_id (provider_id);
+ ALTER TABLE `civicrm_im` DROP FOREIGN KEY civicrm_im_ibfk_2;
+ ALTER TABLE `civicrm_im` DROP INDEX FKEY_provider_id;
+ ALTER TABLE `civicrm_im` ADD INDEX UI_provider_id (provider_id);
-- /*******************************************************
-- * Define contact-individual specific properties. Extends civicrm_contact.
-- *
-- *******************************************************/
-
- ALTER TABLE civicrm_individual DROP FOREIGN KEY civicrm_individual_ibfk_2;
- ALTER TABLE civicrm_individual DROP FOREIGN KEY civicrm_individual_ibfk_3;
- ALTER TABLE civicrm_individual DROP FOREIGN KEY civicrm_individual_ibfk_4;
-
- ALTER TABLE civicrm_individual DROP INDEX FKEY_prefix_id;
- ALTER TABLE civicrm_individual DROP INDEX FKEY_suffix_id;
- ALTER TABLE civicrm_individual DROP INDEX FKEY_gender_id;
-
- ALTER TABLE civicrm_individual ADD INDEX UI_prefix (prefix_id);
- ALTER TABLE civicrm_individual ADD INDEX UI_suffix (suffix_id);
- ALTER TABLE civicrm_individual ADD INDEX UI_gender (gender_id);
-
+
+ ALTER TABLE civicrm_individual DROP FOREIGN KEY civicrm_individual_ibfk_2;
+ ALTER TABLE civicrm_individual DROP FOREIGN KEY civicrm_individual_ibfk_3;
+ ALTER TABLE civicrm_individual DROP FOREIGN KEY civicrm_individual_ibfk_4;
+
+ ALTER TABLE civicrm_individual DROP INDEX FKEY_prefix_id;
+ ALTER TABLE civicrm_individual DROP INDEX FKEY_suffix_id;
+ ALTER TABLE civicrm_individual DROP INDEX FKEY_gender_id;
+
+ ALTER TABLE civicrm_individual ADD INDEX UI_prefix (prefix_id);
+ ALTER TABLE civicrm_individual ADD INDEX UI_suffix (suffix_id);
+ ALTER TABLE civicrm_individual ADD INDEX UI_gender (gender_id);
+
-- /*******************************************************
-- *
-- * civicrm_mapping
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_mapping` MODIFY mapping_type enum('Export','Import','Export Contributions','Import Contributions','Import Activity History','Search Builder','Import Memberships') COMMENT 'Type of Mapping.';
+ ALTER TABLE `civicrm_mapping` MODIFY mapping_type enum('Export','Import','Export Contributions','Import Contributions','Import Activity History','Search Builder','Import Memberships') COMMENT 'Type of Mapping.';
-- /*******************************************************
-- *
-- * Contact Membership records.
-- *
-- *******************************************************/
-
- ALTER TABLE civicrm_membership ADD reminder_date date AFTER is_override;
+
+ ALTER TABLE civicrm_membership ADD reminder_date date AFTER is_override;
-- /*******************************************************
-- *
-- * Logs actions which affect a Membership record (signup, status override, renewal, etc.)
-- *
-- *******************************************************/
-
- ALTER TABLE civicrm_membership_log ADD renewal_reminder_date date AFTER modified_date;
+
+ ALTER TABLE civicrm_membership_log ADD renewal_reminder_date date AFTER modified_date;
-- /*******************************************************
-- *
-- * Sites can configure multiple types of memberships. They encode the owner organization, fee, and the rules needed to set start and end (expire) dates when a member signs up for that type.
-- *
-- *******************************************************/
-
- ALTER TABLE civicrm_membership_type ADD renewal_msg_id int unsigned AFTER weight;
- ALTER TABLE civicrm_membership_type ADD renewal_reminder_day int AFTER renewal_msg_id;
-
- ALTER TABLE civicrm_membership_type ADD INDEX FKEY_renewal_msg_id ( renewal_msg_id );
- ALTER TABLE civicrm_membership_type ADD FOREIGN KEY (renewal_msg_id) REFERENCES civicrm_msg_template(id);
-
+
+ ALTER TABLE civicrm_membership_type ADD renewal_msg_id int unsigned AFTER weight;
+ ALTER TABLE civicrm_membership_type ADD renewal_reminder_day int AFTER renewal_msg_id;
+
+ ALTER TABLE civicrm_membership_type ADD INDEX FKEY_renewal_msg_id ( renewal_msg_id );
+ ALTER TABLE civicrm_membership_type ADD FOREIGN KEY (renewal_msg_id) REFERENCES civicrm_msg_template(id);
+
-- /*******************************************************
-- *
-- * civicrm_phone
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_phone` DROP FOREIGN KEY civicrm_phone_ibfk_2;
- ALTER TABLE `civicrm_phone` DROP INDEX FKEY_mobile_provider_id;
+ ALTER TABLE `civicrm_phone` DROP FOREIGN KEY civicrm_phone_ibfk_2;
+ ALTER TABLE `civicrm_phone` DROP INDEX FKEY_mobile_provider_id;
- ALTER TABLE `civicrm_phone` ADD INDEX UI_mobile_provider_id (mobile_provider_id);
+ ALTER TABLE `civicrm_phone` ADD INDEX UI_mobile_provider_id (mobile_provider_id);
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE civicrm_project DROP FOREIGN KEY civicrm_project_ibfk_2;
- ALTER TABLE civicrm_project DROP INDEX FKEY_status_id;
-
+ ALTER TABLE civicrm_project DROP FOREIGN KEY civicrm_project_ibfk_2;
+ ALTER TABLE civicrm_project DROP INDEX FKEY_status_id;
+
-- /*******************************************************
-- *
-- * civicrm_saved_search
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_saved_search` ADD where_clause text DEFAULT NULL COMMENT 'the sql where clause if a saved search acl';
+ ALTER TABLE `civicrm_saved_search` ADD where_clause text DEFAULT NULL COMMENT 'the sql where clause if a saved search acl';
- ALTER TABLE `civicrm_saved_search` ADD select_tables text DEFAULT NULL COMMENT 'the tables to be included in a select data';
+ ALTER TABLE `civicrm_saved_search` ADD select_tables text DEFAULT NULL COMMENT 'the tables to be included in a select data';
- ALTER TABLE `civicrm_saved_search` ADD where_tables text DEFAULT NULL COMMENT 'the tables to be included in the count statement';
+ ALTER TABLE `civicrm_saved_search` ADD where_tables text DEFAULT NULL COMMENT 'the tables to be included in the count statement';
-- /*******************************************************/
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_task` DROP FOREIGN KEY civicrm_task_ibfk_2;
- ALTER TABLE `civicrm_task` DROP FOREIGN KEY civicrm_task_ibfk_3;
-
- ALTER TABLE `civicrm_task` DROP INDEX FKEY_task_type_id;
- ALTER TABLE `civicrm_task` DROP INDEX FKEY_priority_id;
+ ALTER TABLE `civicrm_task` DROP FOREIGN KEY civicrm_task_ibfk_2;
+ ALTER TABLE `civicrm_task` DROP FOREIGN KEY civicrm_task_ibfk_3;
+
+ ALTER TABLE `civicrm_task` DROP INDEX FKEY_task_type_id;
+ ALTER TABLE `civicrm_task` DROP INDEX FKEY_priority_id;
-- /*******************************************************
-- *
-- * Tracks the responsible entity, optional target entity and status of a task. Tasks can have multiple task_status entries if assigned to multiple responsible entities and-or there are multiple targets.
-- *
-- *******************************************************/
-
- ALTER TABLE `civicrm_task_status` DROP FOREIGN KEY civicrm_task_status_ibfk_2;
- ALTER TABLE `civicrm_task_status` DROP INDEX FKEY_status_id;
+
+ ALTER TABLE `civicrm_task_status` DROP FOREIGN KEY civicrm_task_status_ibfk_2;
+ ALTER TABLE `civicrm_task_status` DROP INDEX FKEY_status_id;
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_uf_group` ADD is_edit_link tinyint NULL DEFAULT '0' COMMENT 'Should edit link display in profile selector';
+ ALTER TABLE `civicrm_uf_group` ADD is_edit_link tinyint NULL DEFAULT '0' COMMENT 'Should edit link display in profile selector';
-- /*******************************************************
-- *
CREATE UNIQUE INDEX UI_uf_id ON civicrm_uf_match(uf_id);
CREATE UNIQUE INDEX UI_contrib_trxn_id_domain_id ON civicrm_contribution_recur(trxn_id, domain_id);
CREATE UNIQUE INDEX UI_contrib_invoice_id_domain_id ON civicrm_contribution_recur(invoice_id, domain_id);
-
+