Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-1316

Add primary key to table, that don't have it

    XMLWordPrintable

    Details

    • Change Log Group:
      Changed
    • Change Log Message:
      Replaced dual-column unique indexes with actual single column primary auto-increment keys.
    • Story Points:
      2
    • Sprint:
      In-Portal's First Sprint, In-Portal's 2nd Sprint
    • Copy Issue Key:
    • Patch Instructions:

      Patches must be submitted through Phabricator.

    • BC Break Details:
      Hide

      Deleted classes:

      • "UserGroups_DBItem"
      • "CategoryItems_DBItem"
      Show
      Deleted classes: "UserGroups_DBItem" "CategoryItems_DBItem"

      Description

      Plan:

      1. Locate database tables, that don't have a primary key (e.g. CategoryItems, UserGroupRelations)
      2. For each of such tables add primary key column called Id, with auto-increment flag set, as first table column
      3. in PHP code search for changed database table usage cases, where combination of existing 2 or more columns were used to uniquely identify records in the table
      4. change each found usage (where it makes sense) to use newly added Id column instead

        Attachments

        1. add_primary_keys_core_v2.patch
          20 kB
          Alex
        2. add_primary_keys_modules_v2.patch
          5 kB
          Alex
        3. core_add_primary_keys.patch
          22 kB
          Erik Snarski [Intechnic]
        4. modules_add_primary_keys.patch
          5 kB
          Erik Snarski [Intechnic]
        5. user_change_primary_group_fix.patch
          2 kB
          Alex

          Issue Links

          blocks

          Changelog Entry - Change log message to reflect changes in other linked In-Portal issues. MINB-28 Add primary key to table, that don't have it

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

          Changelog Entry - Change log message to reflect changes in other linked In-Portal issues. MINC-150 Add primary key to table, that don't have it

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

          Changelog Entry - Change log message to reflect changes in other linked In-Portal issues. MINL-20 Add primary key to table, that don't have it

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

          Changelog Entry - Change log message to reflect changes in other linked In-Portal issues. MINN-13 Add primary key to table, that don't have it

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          mentioned in

          Wiki Page Loading...

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                alex Alex
                Developer:
                Erik Snarski [Intechnic]
                Reviewer:
                Alex
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: