Merge pull request #3257 from pratik-joshi/views-upgrade-error

[civicrm-core.git] / sql / civicrm_upgradedb_v1.3_v1.4_40.mysql

diff --git a/sql/civicrm_upgradedb_v1.3_v1.4_40.mysql b/sql/civicrm_upgradedb_v1.3_v1.4_40.mysql
index 4b6f4a5124dce83744a6dd15d0e0c5f351dd6a53..688036037f3d3556cb50143ae81bc1a5cefd4014 100644 (file)
--- a/sql/civicrm_upgradedb_v1.3_v1.4_40.mysql
+++ b/sql/civicrm_upgradedb_v1.3_v1.4_40.mysql
@@ -268,7 +268,7 @@ CREATE TABLE civicrm_sms_history (
 
    ALTER TABLE `civicrm_location` ADD  name varchar(255);
 
-       
+  
 -- /*******************************************************
 -- *
 -- * Modify the civicrm_uf_field  Table Structure
@@ -290,9 +290,9 @@ CREATE TABLE civicrm_sms_history (
    
    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 INDEX (`limit_listings_group_id`);               
+   ALTER TABLE `civicrm_uf_group` ADD INDEX (`limit_listings_group_id`);    
 
-   ALTER TABLE `civicrm_uf_group` ADD FOREIGN KEY (limit_listings_group_id) REFERENCES civicrm_group(id);      
+   ALTER TABLE `civicrm_uf_group` ADD FOREIGN KEY (limit_listings_group_id) REFERENCES civicrm_group(id);  
 
    ALTER TABLE `civicrm_uf_group` ADD post_URL varchar(255)    COMMENT 'Redirect to URL.';
 
@@ -340,5 +340,5 @@ CREATE TABLE civicrm_sms_history (
 -- * update the custom fields set options per line if it is null
 -- *
 -- *******************************************************/
-       
+
    UPDATE civicrm_custom_field SET  options_per_line=0  WHERE options_per_line IS NULL;