Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-12274

Merge activity tables into one unified table activity contact table

          Details

          • Type: Improvement
          • Status: Done/Fixed
          • Priority: Major
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.4.0
          • Fix Version/s: 4.4.0
          • Component/s: Core CiviCRM
          • Labels:
            None

            Description

            1. Merge tables activity_assignment, activity_target and 'source_contact_id' column from activity table into one new table activity_contact.

            2. For the upgrade script, please consider renaming activity_assignment or activity_target to the new table name which reduces the migration needed

            3. Restructure all queries to use the new table

            4. For a future project, consider searching on all contacts in activity rather than the current restriction of only activity_target (for query sanity purposes)

              Attachments

                Issue Links

                is supplemented by

                Bug - A problem which impairs or prevents the functions of the product. CRM-14056 Multi-lingual 4.4.4 upgrade fails due to dashboard upgrade

                • Blocker - Blocks development and/or testing work, production could not run.
                • Done/Fixed

                Bug - A problem which impairs or prevents the functions of the product. CRM-12849 "Change log" tab crashes with "Table log_civicrm_activity_target doesn't exist"

                • Major - Major loss of function.
                • Done/Fixed

                Bug - A problem which impairs or prevents the functions of the product. CRM-13315 Regression in activity import

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Done/Fixed

                Bug - A problem which impairs or prevents the functions of the product. CRM-12545 failing api tests #1

                • Trivial - Cosmetic problem like misspelt words or misaligned text.
                • Done/Fixed

                  Activity

                    People

                    • Assignee:
                      yashodha Yashodha Chaku
                      Reporter:
                      lobo Donald A. Lobo
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Due:
                        Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - 3 days, 6 hours
                        3d 6h
                        Remaining:
                        Time Spent - 2 days, 4 hours Remaining Estimate - 1 day, 2 hours
                        1d 2h
                        Logged:
                        Time Spent - 2 days, 4 hours Remaining Estimate - 1 day, 2 hours
                        2d 4h