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

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

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Verified
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 10.4
    • Fix Version/s: 11.0
    • Component/s: Kernel
    • Labels:

      Description

      This will add an integer primary key to the user, site, page, realm and placement tables. The string guids for these rows will continue to be the primary key and (through Sakai 11) 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 post-Sakai-11 modifications.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code