-- +--------------------------------------------------------------------+
--- | CiviCRM version 3.2 |
+-- | CiviCRM version 4.6 |
-- +--------------------------------------------------------------------+
--- | Copyright CiviCRM LLC (c) 2004-2010 |
+-- | Copyright CiviCRM LLC (c) 2004-2015 |
-- +--------------------------------------------------------------------+
-- | This file is a part of CiviCRM. |
-- | |
relationship_type_id int unsigned COMMENT 'FK to Relationship Type ID',
visibility varchar(64) ,
weight int ,
- is_active tinyint DEFAULT 1 COMMENT 'Is this membership_type enabled'
+ is_active tinyint DEFAULT 1 COMMENT 'Is this membership_type enabled'
,
PRIMARY KEY ( id )
-
-
-,
+
+
+,
FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
-,
+,
FOREIGN KEY (member_of_contact_id) REFERENCES civicrm_contact(id)
-,
+,
FOREIGN KEY (contribution_type_id) REFERENCES civicrm_contribution_type(id)
-,
+,
FOREIGN KEY (relationship_type_id) REFERENCES civicrm_relationship_type(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- /*******************************************************
is_admin tinyint COMMENT 'Is this status for admin/manual assignment only.',
weight int ,
is_default tinyint COMMENT 'Assign this status to a membership record if no other status match is found.',
- is_active tinyint DEFAULT 1 COMMENT 'Is this membership_status enabled.'
+ is_active tinyint DEFAULT 1 COMMENT 'Is this membership_status enabled.'
,
PRIMARY KEY ( id )
-
-
-,
+
+
+,
FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- /*******************************************************
end_date date COMMENT 'Current membership period expire date.',
source varchar(128) ,
status_id int unsigned NOT NULL COMMENT 'FK to Membership Status',
- is_override tinyint COMMENT 'Admin users may set a manual status which overrides the calculated status. When this flag is true, automated status update scripts should NOT modify status for the record.'
+ is_override tinyint COMMENT 'Admin users may set a manual status which overrides the calculated status. When this flag is true, automated status update scripts should NOT modify status for the record.'
,
PRIMARY KEY ( id )
-
-
-,
+
+
+,
FOREIGN KEY (contact_id) REFERENCES civicrm_contact(id)
-,
+,
FOREIGN KEY (membership_type_id) REFERENCES civicrm_membership_type(id)
-,
+,
FOREIGN KEY (status_id) REFERENCES civicrm_membership_status(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
renewal_title varchar(255) COMMENT 'Title for renewal',
renewal_text text COMMENT 'Text to display for member renewal',
is_required tinyint DEFAULT 0 COMMENT 'Is membership sign up optional',
- is_active tinyint DEFAULT 1 COMMENT 'Is this membership_block enabled'
+ is_active tinyint DEFAULT 1 COMMENT 'Is this membership_block enabled'
,
PRIMARY KEY ( id )
-
-
-,
+
+
+,
FOREIGN KEY (entity_id) REFERENCES civicrm_contribution_page(id)
-,
+,
FOREIGN KEY (membership_type_default) REFERENCES civicrm_membership_type(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- /*******************************************************
start_date date COMMENT 'New membership period start date',
end_date date COMMENT 'New membership period expiration date.',
modified_id int unsigned COMMENT 'FK to Contact ID of person under whose credentials this data modification was made.',
- modified_date date COMMENT 'Date this membership modification action was logged.'
+ modified_date date COMMENT 'Date this membership modification action was logged.'
,
PRIMARY KEY ( id )
-
-
-,
+
+
+,
FOREIGN KEY (membership_id) REFERENCES civicrm_membership(id)
-,
+,
FOREIGN KEY (status_id) REFERENCES civicrm_membership_status(id)
-,
+,
FOREIGN KEY (modified_id) REFERENCES civicrm_contact(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- /*******************************************************
id int unsigned NOT NULL AUTO_INCREMENT ,
membership_id int unsigned NOT NULL COMMENT 'FK to Membership table',
payment_entity_table varchar(128) COMMENT 'Table being referenced for payment entity.',
- payment_entity_id int unsigned COMMENT 'FK to table with payment record (expected usage is civicrm_contribution).'
+ payment_entity_id int unsigned COMMENT 'FK to table with payment record (expected usage is civicrm_contribution).'
,
PRIMARY KEY ( id )
-
+
, INDEX index_payment_entity(
payment_entity_table
, payment_entity_id
)
-
-,
+
+,
FOREIGN KEY (membership_id) REFERENCES civicrm_membership(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- /*******************************************************
name varchar(64) NOT NULL COMMENT 'Option group name. Used as selection key by class properties which lookup options in civicrm_option_value.',
description varchar(255) COMMENT 'Option group description.',
is_reserved tinyint COMMENT 'Is this a predefined system option group (i.e. it can not be deleted)?',
- is_active tinyint COMMENT 'Is this option group active?'
+ is_active tinyint COMMENT 'Is this option group active?'
,
PRIMARY KEY ( id )
-
+
, UNIQUE INDEX option_group_name_domain_id(
name
, domain_id
)
-
-,
+
+,
FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- /*******************************************************
description varchar(255) COMMENT 'Optional description.',
is_optgroup tinyint DEFAULT 0 COMMENT 'Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?',
is_reserved tinyint DEFAULT 0 COMMENT 'Is this a predefined system object?',
- is_active tinyint DEFAULT 1 COMMENT 'Is this option active?'
+ is_active tinyint DEFAULT 1 COMMENT 'Is this option active?'
,
PRIMARY KEY ( id )
-
+
, INDEX index_option_group_id_value(
value
, option_group_id
)
-
-,
+
+,
FOREIGN KEY (option_group_id) REFERENCES civicrm_option_group(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- /*******************************************************
start_date datetime COMMENT 'Project start date.',
end_date datetime COMMENT 'Project end date.',
is_active tinyint COMMENT 'Is this record active? For Projects: can tasks be created for it, does it appear on project listings, etc.',
- status_id int unsigned COMMENT 'Configurable status value (e.g. Planned, Active, Closed...). FK to civicrm_option_value.'
+ status_id int unsigned COMMENT 'Configurable status value (e.g. Planned, Active, Closed...). FK to civicrm_option_value.'
,
PRIMARY KEY ( id )
-
+
, UNIQUE INDEX UI_project_owner(
id
, owner_entity_table
, owner_entity_id
)
-
-,
+
+,
FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
-,
+,
FOREIGN KEY (status_id) REFERENCES civicrm_option_value(value)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- /*******************************************************
due_date datetime COMMENT 'Task due date.',
priority_id int unsigned COMMENT 'Configurable priority value (e.g. Critical, High, Medium...). FK to civicrm_option_value.',
task_class varchar(255) COMMENT 'Optional key to a process class related to this task (e.g. CRM_Quest_PreApp).',
- is_active tinyint COMMENT 'Is this record active? For tasks: can it be assigned, does it appear on open task listings, etc.'
+ is_active tinyint COMMENT 'Is this record active? For tasks: can it be assigned, does it appear on open task listings, etc.'
,
PRIMARY KEY ( id )
-
+
, UNIQUE INDEX UI_task_parent(
id
, parent_entity_table
, owner_entity_table
, owner_entity_id
)
-
-,
+
+,
FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
-,
+,
FOREIGN KEY (task_type_id) REFERENCES civicrm_option_value(value)
-,
+,
FOREIGN KEY (priority_id) REFERENCES civicrm_option_value(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- /*******************************************************
status_detail text COMMENT 'Encoded array of status details used for programmatic progress reporting and tracking.',
status_id int unsigned COMMENT 'Configurable status value (e.g. Not Started, In Progress, Completed, Deferred...). FK to civicrm_option_value.',
create_date datetime COMMENT 'Date this record was created (date work on task started).',
- modified_date datetime COMMENT 'Date-time of last update to this task_status record.'
+ modified_date datetime COMMENT 'Date-time of last update to this task_status record.'
,
PRIMARY KEY ( id )
-
+
, INDEX index_task_status_responsible(
task_id
, responsible_entity_table
, target_entity_table
, target_entity_id
)
-
-,
+
+,
FOREIGN KEY (task_id) REFERENCES civicrm_task(id)
-,
+,
FOREIGN KEY (status_id) REFERENCES civicrm_option_value(value)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
entity_id int unsigned NOT NULL COMMENT 'Foreign key to the referenced item.',
data text COMMENT 'Updates does to this object if any.',
modified_id int unsigned COMMENT 'FK to Contact ID of person under whose credentials this data modification was made.',
- modified_date datetime COMMENT 'When was the referenced entity created or modified or deleted.'
+ modified_date datetime COMMENT 'When was the referenced entity created or modified or deleted.'
,
PRIMARY KEY ( id )
-
+
, INDEX index_entity(
entity_table
, entity_id
)
-
-,
+
+,
FOREIGN KEY (modified_id) REFERENCES civicrm_contact(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
uri varchar(255) COMMENT 'uri of the file on disk',
document mediumblob COMMENT 'contents of the document',
description varchar(255) COMMENT 'Additional descriptive text regarding this attachment (optional).',
- upload_date datetime COMMENT 'Date and time that this attachment was uploaded or written to server.'
+ upload_date datetime COMMENT 'Date and time that this attachment was uploaded or written to server.'
,
PRIMARY KEY ( id )
-
-
-,
+
+
+,
FOREIGN KEY (file_type_id) REFERENCES civicrm_option_value(value)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- /*******************************************************
id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
entity_table varchar(64) COMMENT 'physical tablename for entity being joined to file, e.g. civicrm_contact',
entity_id int unsigned NOT NULL COMMENT 'FK to entity table specified in entity_table column.',
- file_id int unsigned NOT NULL COMMENT 'FK to civicrm_file'
+ file_id int unsigned NOT NULL COMMENT 'FK to civicrm_file'
,
PRIMARY KEY ( id )
-
+
, INDEX index_entity(
entity_table
, entity_id
, entity_id
, file_id
)
-
-,
+
+,
FOREIGN KEY (file_id) REFERENCES civicrm_file(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
-- * Modify the civicrm_individual Table Structure
-- *******************************************************/
- ALTER TABLE `civicrm_individual` ADD deceased_date date COMMENT 'Date of deceased';
+ ALTER TABLE `civicrm_individual` ADD deceased_date date COMMENT 'Date of deceased';
-- /*******************************************************
-- *
-- * Modify the civicrm_contact Table Structure
-- *******************************************************/
- ALTER TABLE `civicrm_contact` DROP INDEX `index_sort_name`;
- ALTER TABLE `civicrm_contact` DROP `hash`;
-
- ALTER TABLE `civicrm_contact` ADD hash varchar(32) DEFAULT NULL COMMENT 'Key for validating requests related to this contact.';
- ALTER TABLE `civicrm_contact` ADD contact_sub_type varchar(64) DEFAULT NULL COMMENT 'May be used to over-ride contact view and edit templates.';
+ ALTER TABLE `civicrm_contact` DROP INDEX `index_sort_name`;
+ ALTER TABLE `civicrm_contact` DROP `hash`;
- ALTER TABLE `civicrm_contact` MODIFY preferred_communication_method varchar(255) DEFAULT NULL COMMENT 'What is the preferred mode of communication.';
+ ALTER TABLE `civicrm_contact` ADD hash varchar(32) DEFAULT NULL COMMENT 'Key for validating requests related to this contact.';
+ ALTER TABLE `civicrm_contact` ADD contact_sub_type varchar(64) DEFAULT NULL COMMENT 'May be used to over-ride contact view and edit templates.';
- ALTER TABLE `civicrm_contact` ADD INDEX index_sort_name_domain(sort_name, domain_id, hash);
+ ALTER TABLE `civicrm_contact` MODIFY preferred_communication_method varchar(255) DEFAULT NULL COMMENT 'What is the preferred mode of communication.';
- ALTER TABLE `civicrm_contact` ADD INDEX index_hash_domain(hash, domain_id);
+ ALTER TABLE `civicrm_contact` ADD INDEX index_sort_name_domain(sort_name, domain_id, hash);
+
+ ALTER TABLE `civicrm_contact` ADD INDEX index_hash_domain(hash, domain_id);
-- /*******************************************************
-- *
-- * fix preferred communication data
-- *******************************************************/
- SELECT @domain_id := id from civicrm_domain;
- INSERT INTO
- `civicrm_option_group` (`domain_id`, `name`, `description`, `is_reserved`, `is_active`)
- VALUES
+ SELECT @domain_id := id from civicrm_domain;
+ INSERT INTO
+ `civicrm_option_group` (`domain_id`, `name`, `description`, `is_reserved`, `is_active`)
+ VALUES
(@domain_id, 'preferred_communication_method', 'Preferred Communication Method' , 0, 1);
SELECT @option_group_id_pcm := max(id) from civicrm_option_group where name = 'preferred_communication_method';
- INSERT INTO
- `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`)
+ INSERT INTO
+ `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`)
VALUES
(@option_group_id_pcm, 'Phone', 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1),
(@option_group_id_pcm, 'Email', 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1),
-- *
-- * Modify the civicrm_contribution_page Table Structure
-- *******************************************************/
- ALTER TABLE `civicrm_contribution_page` ADD amount_block_is_active tinyint unsigned DEFAULT 1 COMMENT 'Is this property active?';
- ALTER TABLE `civicrm_contribution_page` ADD goal_amount decimal(20,2) COMMENT 'The target goal for this page, allows people to build a goal meter';
- ALTER TABLE `civicrm_contribution_page` ADD is_thermometer int(4) unsigned DEFAULT 1 COMMENT 'Should this contribution have the thermometer block enabled?';
- ALTER TABLE `civicrm_contribution_page` ADD thermometer_title varchar(255) DEFAULT NULL COMMENT 'Title for contribution page thermometer block.';
+ ALTER TABLE `civicrm_contribution_page` ADD amount_block_is_active tinyint unsigned DEFAULT 1 COMMENT 'Is this property active?';
+ ALTER TABLE `civicrm_contribution_page` ADD goal_amount decimal(20,2) COMMENT 'The target goal for this page, allows people to build a goal meter';
+ ALTER TABLE `civicrm_contribution_page` ADD is_thermometer int(4) unsigned DEFAULT 1 COMMENT 'Should this contribution have the thermometer block enabled?';
+ ALTER TABLE `civicrm_contribution_page` ADD thermometer_title varchar(255) DEFAULT NULL COMMENT 'Title for contribution page thermometer block.';
-- /*******************************************************
-- *
-- * Modify the civicrm_custom_field Table Structure
-- *******************************************************/
- ALTER TABLE `civicrm_custom_field` CHANGE `html_type` `html_type` ENUM( 'Text', 'TextArea', 'Select', 'Multi-Select', 'Radio', 'CheckBox', 'Select Date', 'Select State/Province', 'Select Country','File') DEFAULT NULL COMMENT 'HTML types plus several built-in extended types.';
+ ALTER TABLE `civicrm_custom_field` CHANGE `html_type` `html_type` ENUM( 'Text', 'TextArea', 'Select', 'Multi-Select', 'Radio', 'CheckBox', 'Select Date', 'Select State/Province', 'Select Country','File') DEFAULT NULL COMMENT 'HTML types plus several built-in extended types.';
- ALTER TABLE `civicrm_custom_field` CHANGE `data_type` `data_type` ENUM('String', 'Int', 'Float', 'Money', 'Memo', 'Date', 'Boolean', 'StateProvince', 'Country', 'File') DEFAULT NULL COMMENT 'Controls location of data storage in extended_data table.';
+ ALTER TABLE `civicrm_custom_field` CHANGE `data_type` `data_type` ENUM('String', 'Int', 'Float', 'Money', 'Memo', 'Date', 'Boolean', 'StateProvince', 'Country', 'File') DEFAULT NULL COMMENT 'Controls location of data storage in extended_data table.';
-- /*******************************************************
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_custom_group` CHANGE `extends` `extends` ENUM( 'Contact', 'Individual', 'Household', 'Organization', 'Location', 'Address', 'Contribution', 'Activity', 'Phonecall', 'Meeting', 'Group','Relationship') DEFAULT 'Contact' COMMENT 'Type of object this group extends (can add other options later e.g. contact_address, etc.).';
+ ALTER TABLE `civicrm_custom_group` CHANGE `extends` `extends` ENUM( 'Contact', 'Individual', 'Household', 'Organization', 'Location', 'Address', 'Contribution', 'Activity', 'Phonecall', 'Meeting', 'Group','Relationship') DEFAULT 'Contact' COMMENT 'Type of object this group extends (can add other options later e.g. contact_address, etc.).';
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_custom_value` ADD file_id int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_file';
- ALTER TABLE `civicrm_custom_value` ADD INDEX (`file_id`);
- ALTER TABLE `civicrm_custom_value` ADD FOREIGN KEY (`file_id`) REFERENCES `civicrm_file`(`id`);
-
+ ALTER TABLE `civicrm_custom_value` ADD file_id int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_file';
+ ALTER TABLE `civicrm_custom_value` ADD INDEX (`file_id`);
+ ALTER TABLE `civicrm_custom_value` ADD FOREIGN KEY (`file_id`) REFERENCES `civicrm_file`(`id`);
+
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_email` ADD INDEX `UI_email` (`email`);
+ ALTER TABLE `civicrm_email` ADD INDEX `UI_email` (`email`);
-- /*******************************************************
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_mapping` CHANGE `mapping_type` `mapping_type` ENUM('Export', 'Import', 'Export Contributions', 'Import Contributions', 'Import Activity History', 'Search Builder') default NULL COMMENT 'Type of Mapping.';
+ ALTER TABLE `civicrm_mapping` CHANGE `mapping_type` `mapping_type` ENUM('Export', 'Import', 'Export Contributions', 'Import Contributions', 'Import Activity History', 'Search Builder') default NULL COMMENT 'Type of Mapping.';
-- /*******************************************************
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_mapping_field` ADD grouping int(10) unsigned DEFAULT 1 COMMENT 'Used to group mapping_field records into related sets (e.g. for criteria sets in search builder mappings).';
+ ALTER TABLE `civicrm_mapping_field` ADD grouping int(10) unsigned DEFAULT 1 COMMENT 'Used to group mapping_field records into related sets (e.g. for criteria sets in search builder mappings).';
- ALTER TABLE `civicrm_mapping_field` ADD operator ENUM('=','!=','>','<','>=','<=','IN','NOT IN','LIKE','NOT LIKE') DEFAULT NULL COMMENT 'SQL WHERE operator for search-builder mapping fields (search criteria).';
+ ALTER TABLE `civicrm_mapping_field` ADD operator ENUM('=','!=','>','<','>=','<=','IN','NOT IN','LIKE','NOT LIKE') DEFAULT NULL COMMENT 'SQL WHERE operator for search-builder mapping fields (search criteria).';
- ALTER TABLE `civicrm_mapping_field` ADD value varchar(255) DEFAULT NULL COMMENT 'SQL WHERE value for search-builder mapping fields.';
+ ALTER TABLE `civicrm_mapping_field` ADD value varchar(255) DEFAULT NULL COMMENT 'SQL WHERE value for search-builder mapping fields.';
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_uf_group` ADD add_to_group_id int unsigned DEFAULT NULL COMMENT 'foreign key to civicrm_group_id';
- ALTER TABLE `civicrm_uf_group` ADD INDEX (`add_to_group_id`);
- ALTER TABLE `civicrm_uf_group` ADD FOREIGN KEY (`add_to_group_id`) REFERENCES `civicrm_group` (`id`);
-
- ALTER TABLE `civicrm_uf_group` ADD add_captcha tinyint DEFAULT 0 COMMENT 'Should a CAPTCHA widget be included this Profile form.';
+ ALTER TABLE `civicrm_uf_group` ADD add_to_group_id int unsigned DEFAULT NULL COMMENT 'foreign key to civicrm_group_id';
+ ALTER TABLE `civicrm_uf_group` ADD INDEX (`add_to_group_id`);
+ ALTER TABLE `civicrm_uf_group` ADD FOREIGN KEY (`add_to_group_id`) REFERENCES `civicrm_group` (`id`);
+
+ ALTER TABLE `civicrm_uf_group` ADD add_captcha tinyint DEFAULT 0 COMMENT 'Should a CAPTCHA widget be included this Profile form.';
- ALTER TABLE `civicrm_uf_group` ADD cancel_URL varchar(255) DEFAULT NULL COMMENT 'Redirect to URL when Cancle button clik .';
- ALTER TABLE `civicrm_uf_group` ADD is_map tinyint DEFAULT 0 COMMENT 'Do we want to map results from this profile.';
- ALTER TABLE `civicrm_uf_group` ADD collapse_display int(10) unsigned DEFAULT 0 COMMENT 'Will this group be in collapsed or expanded mode on initial display ?';
+ ALTER TABLE `civicrm_uf_group` ADD cancel_URL varchar(255) DEFAULT NULL COMMENT 'Redirect to URL when Cancle button clik .';
+ ALTER TABLE `civicrm_uf_group` ADD is_map tinyint DEFAULT 0 COMMENT 'Do we want to map results from this profile.';
+ ALTER TABLE `civicrm_uf_group` ADD collapse_display int(10) unsigned DEFAULT 0 COMMENT 'Will this group be in collapsed or expanded mode on initial display ?';
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_uf_match` ADD INDEX `UI_uf_id` (`uf_id`);
+ ALTER TABLE `civicrm_uf_match` ADD INDEX `UI_uf_id` (`uf_id`);
-- /*******************************************************
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_note` ADD `subject` varchar(255) DEFAULT NULL COMMENT 'subject of note description';
+ ALTER TABLE `civicrm_note` ADD `subject` varchar(255) DEFAULT NULL COMMENT 'subject of note description';
-- /*******************************************************
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_relationship` ADD `description` varchar(255) COMMENT 'Optional verbose description for the relationship.' ;
+ ALTER TABLE `civicrm_relationship` ADD `description` varchar(255) COMMENT 'Optional verbose description for the relationship.' ;
-- /*******************************************************
-- *
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_saved_search` ADD `mapping_id` INT UNSIGNED COMMENT 'Foreign key to civicrm_mapping used for saved search-builder searches.';
- ALTER TABLE `civicrm_saved_search` ADD INDEX (`mapping_id`);
- ALTER TABLE `civicrm_saved_search` ADD FOREIGN KEY (`mapping_id`) REFERENCES `civicrm_mapping` (`id`);
+ ALTER TABLE `civicrm_saved_search` ADD `mapping_id` INT UNSIGNED COMMENT 'Foreign key to civicrm_mapping used for saved search-builder searches.';
+ ALTER TABLE `civicrm_saved_search` ADD INDEX (`mapping_id`);
+ ALTER TABLE `civicrm_saved_search` ADD FOREIGN KEY (`mapping_id`) REFERENCES `civicrm_mapping` (`id`);
- ALTER TABLE `civicrm_saved_search` DROP FOREIGN KEY `civicrm_saved_search_ibfk_1`;
+ ALTER TABLE `civicrm_saved_search` DROP FOREIGN KEY `civicrm_saved_search_ibfk_1`;
- ALTER TABLE `civicrm_saved_search` DROP `query`,
- DROP `domain_id`,
- DROP `is_active`;
+ ALTER TABLE `civicrm_saved_search` DROP `query`,
+ DROP `domain_id`,
+ DROP `is_active`;
-- /*******************************************************
-- *
-- * Modify the civicrm_custom_value Table Structure