X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=sql%2Fcivicrm_upgradedb_v1.3_v1.4_41.mysql;h=08d6440b1ec0103a5f00dea7c4c631f9c3cffaf1;hb=a6f3251ba7ee3cf9a04320dce9719c43183aaa71;hp=3f86d69ae1853b4df4198e904311619f59d550bf;hpb=ec9bb041d5407d659b30d3ecd00b5db60d71ad52;p=civicrm-core.git
diff --git a/sql/civicrm_upgradedb_v1.3_v1.4_41.mysql b/sql/civicrm_upgradedb_v1.3_v1.4_41.mysql
index 3f86d69ae1..08d6440b1e 100644
--- a/sql/civicrm_upgradedb_v1.3_v1.4_41.mysql
+++ b/sql/civicrm_upgradedb_v1.3_v1.4_41.mysql
@@ -1,7 +1,7 @@
-- +--------------------------------------------------------------------+
--- | 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. |
-- | |
@@ -54,12 +54,12 @@ CREATE TABLE civicrm_contribution_product (
fulfilled_date date COMMENT 'Optional. Can be used to record the date this product was fulfilled or shipped.',
start_date date COMMENT 'Actual start date for a time-delimited premium (subscription, service or membership)',
end_date date COMMENT 'Actual end date for a time-delimited premium (subscription, service or membership)',
- comment text
+ comment text
,
PRIMARY KEY ( id )
-,
+,
FOREIGN KEY (contribution_id) REFERENCES civicrm_contribution(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
@@ -85,12 +85,12 @@ CREATE TABLE civicrm_contribution_recur (
failure_count int unsigned DEFAULT 0 COMMENT 'Number of failed charge attempts since last success. Business rule could be set to deactivate on more than x failures.',
failure_retry_date date COMMENT 'At Groundspring we set a business rule to retry failed payments every 7 days - and stored the next scheduled attempt date there.',
processor_id varchar(255) COMMENT 'Possibly needed to store a unique identifier for this recurring payment order - if this is available from the processor??',
- auto_renew tinyint NOT NULL DEFAULT 0 COMMENT 'Some systems allow contributor to set a number of installments - but then auto-renew the subscription or commitment if they do not cancel.'
+ auto_renew tinyint NOT NULL DEFAULT 0 COMMENT 'Some systems allow contributor to set a number of installments - but then auto-renew the subscription or commitment if they do not cancel.'
,
PRIMARY KEY ( id )
-,
+,
FOREIGN KEY (contact_id) REFERENCES civicrm_contact(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
@@ -98,7 +98,7 @@ CREATE TABLE civicrm_contribution_recur (
-- *
-- * civicrm_premiums
-- *
--- * table - settings for the Premiums features for a given contribution page
+-- * table - settings for the Premiums features for a given contribution page
-- *
-- *******************************************************/
CREATE TABLE civicrm_premiums (
@@ -110,10 +110,10 @@ CREATE TABLE civicrm_premiums (
premiums_intro_text text COMMENT 'Displayed in
at top of Premiums section of page. Text and html allowed.',
premiums_contact_email varchar(100) COMMENT 'This email address is included in receipts if it is populated and a premium has been selected.',
premiums_contact_phone varchar(50) COMMENT 'This phone number is included in receipts if it is populated and a premium has been selected.',
- premiums_display_min_contribution tinyint NOT NULL COMMENT 'Boolean. Should we automatically display minimum contribution amount text after the premium descriptions.'
+ premiums_display_min_contribution tinyint NOT NULL COMMENT 'Boolean. Should we automatically display minimum contribution amount text after the premium descriptions.'
,
PRIMARY KEY ( id )
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
@@ -121,7 +121,7 @@ CREATE TABLE civicrm_premiums (
-- *
-- * civicrm_product
-- *
--- * able - stores "product info" for premiums and can be used for non-incentive products
+-- * able - stores "product info" for premiums and can be used for non-incentive products
-- *
-- *******************************************************/
CREATE TABLE civicrm_product (
@@ -143,12 +143,12 @@ CREATE TABLE civicrm_product (
duration_unit enum('day', 'month', 'week', 'year') DEFAULT 'year' ,
duration_interval int COMMENT 'Number of units for total duration of subscription, service, membership (e.g. 12 Months).',
frequency_unit enum('day', 'month', 'week', 'year') DEFAULT 'month' COMMENT 'Frequency unit and interval allow option to store actual delivery frequency for a subscription or service.',
- frequency_interval int COMMENT 'Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months).'
+ frequency_interval int COMMENT 'Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months).'
,
PRIMARY KEY ( id )
-,
+,
FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
@@ -163,14 +163,14 @@ CREATE TABLE civicrm_premiums_product (
id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Contribution ID',
premiums_id int unsigned NOT NULL COMMENT 'Foreign key to premiums settings record.',
product_id int unsigned NOT NULL COMMENT 'Foreign key to each product object.',
- sort_position int unsigned NOT NULL
+ sort_position int unsigned NOT NULL
,
PRIMARY KEY ( id )
-,
+,
FOREIGN KEY (premiums_id) REFERENCES civicrm_premiums(id)
-,
+,
FOREIGN KEY (product_id) REFERENCES civicrm_product(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
@@ -185,12 +185,12 @@ CREATE TABLE civicrm_sms_history (
id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'SMS History ID',
message text COMMENT 'Contents of the SMS.',
contact_id int unsigned NOT NULL COMMENT 'FK to Contact who is sending this SMS',
- sent_date date COMMENT 'When was this SMS sent'
+ sent_date date COMMENT 'When was this SMS sent'
,
PRIMARY KEY ( id )
-,
+,
FOREIGN KEY (contact_id) REFERENCES civicrm_contact(id)
-
+
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
@@ -208,15 +208,15 @@ CREATE TABLE civicrm_sms_history (
-- * Modify the civicrm_contribution Table Structure
-- *
-- *******************************************************/
-
+
ALTER TABLE `civicrm_contribution` ADD `solicitor_id` int unsigned COMMENT 'FK to Solicitor ID';
-
+
ALTER TABLE `civicrm_contribution` ADD CONSTRAINT FOREIGN KEY (`solicitor_id`) REFERENCES `civicrm_contact` (`id`);
ALTER TABLE `civicrm_contribution` ADD note text COMMENT 'Note and/or Comment.';
- ALTER TABLE `civicrm_contribution` ADD recur_contribution_id int unsigned COMMENT 'Conditional foreign key to civicrm_contribution_recur id. Each contribution made in connection with a recurring contribution carries a foreign key to the recurring contribution record. This assumes we can track these processor initiated events.';
-
+ ALTER TABLE `civicrm_contribution` ADD recur_contribution_id int unsigned COMMENT 'Conditional foreign key to civicrm_contribution_recur id. Each contribution made in connection with a recurring contribution carries a foreign key to the recurring contribution record. This assumes we can track these processor initiated events.';
+
ALTER TABLE `civicrm_contribution` ADD CONSTRAINT FOREIGN KEY (recur_contribution_id) REFERENCES civicrm_contribution_recur(id);
@@ -226,7 +226,7 @@ CREATE TABLE civicrm_sms_history (
-- *
-- *******************************************************/
- ALTER TABLE `civicrm_contribution_page` ADD footer_text text COMMENT 'Text and html allowed. Displayed at the bottom of the first page of the contribution wizard.';
+ ALTER TABLE `civicrm_contribution_page` ADD footer_text text COMMENT 'Text and html allowed. Displayed at the bottom of the first page of the contribution wizard.';
-- /*******************************************************
@@ -234,13 +234,13 @@ CREATE TABLE civicrm_sms_history (
-- * Modify the civicrm_custom_field Table Structure
-- *
-- *******************************************************/
-
+
ALTER TABLE `civicrm_custom_field` ADD is_search_range tinyint DEFAULT 0 COMMENT 'Is this property range searchable.';
ALTER TABLE `civicrm_custom_field` ADD start_date_years int unsigned COMMENT 'Date may be up to start_date_years years prior to tcurrent date ';
ALTER TABLE `civicrm_custom_field` ADD end_date_years int unsigned COMMENT 'Date may be up to end_date_years years after to tcurrent date ';
ALTER TABLE `civicrm_custom_field` ADD date_parts varchar(255) COMMENT 'which date part included in display ';
ALTER TABLE `civicrm_custom_field` ADD note_columns int unsigned COMMENT ' Number of columns in Note Field ';
- ALTER TABLE `civicrm_custom_field` ADD note_rows int unsigned COMMENT ' Number of rows in Note Field ';
+ ALTER TABLE `civicrm_custom_field` ADD note_rows int unsigned COMMENT ' Number of rows in Note Field ';
-- /*******************************************************
@@ -260,7 +260,7 @@ CREATE TABLE civicrm_sms_history (
ALTER TABLE `civicrm_location` ADD name varchar(255);
-
+
-- /*******************************************************
-- *
-- * Modify the civicrm_uf_field Table Structure
@@ -272,17 +272,17 @@ CREATE TABLE civicrm_sms_history (
ALTER TABLE `civicrm_uf_field` ADD label varchar(255) COMMENT 'To save label for fields.';
ALTER TABLE `civicrm_uf_field` ADD field_type varchar(255) COMMENT 'This field saves field type (ie individual,household.. field etc).';
-
+
-- /*******************************************************
-- *
-- * Modify the civicrm_uf_group Table Structure
-- *
-- *******************************************************/
-
+
ALTER TABLE `civicrm_uf_group` ADD limit_listings_group_id int unsigned COMMENT 'Group id, foriegn key from civicrm_group';
- ALTER TABLE `civicrm_uf_group` ADD CONSTRAINT FOREIGN KEY (limit_listings_group_id) REFERENCES civicrm_group(id);
+ ALTER TABLE `civicrm_uf_group` ADD CONSTRAINT FOREIGN KEY (limit_listings_group_id) REFERENCES civicrm_group(id);
ALTER TABLE `civicrm_uf_group` ADD post_URL varchar(255) COMMENT 'Redirect to URL.';
@@ -303,7 +303,7 @@ CREATE TABLE civicrm_sms_history (
-- * Drop Old Tables
-- *
-- *******************************************************/
-
+
DROP TABLE IF EXISTS civicrm_module_profile;