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

Migration scripts for new Statistics User Activity feature added in SAK-40018

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 20.0 [Tentative]
    • Fix Version/s: 20.0 [Tentative]
    • Component/s: Reference
    • Labels:
      None
    • Test Plan:
      Hide
      1. Perform a fresh Sakai installation using auto.ddl
      2. Pick a site and remove the "sitestats.usertracking.track" and "sitestats.usertracking.be.tracked" permissions from the realm roles
      3. Record the structure of the SST_DETAILED_EVENTS table in the database
      4. Drop the SST_DETAILED_EVENTS table
      5. Run the script
      6. Confirm the the SST_DETAILED_EVENTS table and related indices were re-created
      7. Clear the Sakai caches using the Memory tool as admin
      8. Confirm the permissions were restored
      Show
      Perform a fresh Sakai installation using auto.ddl Pick a site and remove the "sitestats.usertracking.track" and "sitestats.usertracking.be.tracked" permissions from the realm roles Record the structure of the SST_DETAILED_EVENTS table in the database Drop the SST_DETAILED_EVENTS table Run the script Confirm the the SST_DETAILED_EVENTS table and related indices were re-created Clear the Sakai caches using the Memory tool as admin Confirm the permissions were restored

      Description

      SAK-40018 needs database migration scripts for table creation and permissions backfill.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  plukasew Paul Lukasewych
                  Reporter:
                  plukasew Paul Lukasewych
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code