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

          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: