Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-29108

Add Integer Primary Keys to Site, Page, and tool table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.4
    • Fix Version/s: 11.0
    • Component/s: Portal
    • Labels:
      None
    • Conversion Script Required:
      Yes

      Description

      This will add an integer primary key to the site, page, and placement tables. The guids for these rows will continue to be the primary key and (for now) continue to be how the joins and lookups are done for these tables. But these integer primary keys can be evolved to give us much shorter URLs and much faster joins with future modifications.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  csev Charles Severance
                  Reporter:
                  csev Charles Severance
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration