Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-33893 Test and Fix MySQL conversion script for Sakai 12
  3. SAK-33916

Investigate/fix nullable and autoIncrement changes in Sakai 11/12

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: RESOLVED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 19.0
    • Component/s: None
    • Labels:
      None
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      These are the remaining issues about a nullable change. These should be investigated to see if they need to be updated in the conversion script.

           sakai_12.ASN_AP_ITEM_T.ASSIGNMENT_ID
                nullable changed from 'false' to 'true'
           sakai_12.ASN_MA_ITEM_T.ASSIGNMENT_ID
                nullable changed from 'false' to 'true'
           sakai_12.ASN_NOTE_ITEM_T.ASSIGNMENT_ID
                nullable changed from 'false' to 'true'
           sakai_12.ASN_SUP_ATTACH_T.ATTACHMENT_ID
                nullable changed from 'false' to 'true'
           sakai_12.SAKAI_MESSAGE_BUNDLE.BASENAME
                nullable changed from 'false' to 'true'
           sakai_12.CHAT2_CHANNEL.ENABLE_USER_OVERRIDE
                nullable changed from 'false' to 'true'
           sakai_12.ASN_AP_ITEM_T.HIDE
                nullable changed from 'false' to 'true'
           sakai_12.ASN_AP_ITEM_ACCESS_T.ITEM_ACCESS
                nullable changed from 'false' to 'true'
           sakai_12.SAKAI_MESSAGE_BUNDLE.LOCALE
                nullable changed from 'false' to 'true'
           sakai_12.SAKAI_MESSAGE_BUNDLE.MODULE_NAME
                nullable changed from 'false' to 'true'
           sakai_12.SAKAI_MESSAGE_BUNDLE.PROP_NAME
                nullable changed from 'false' to 'true'
           sakai_12.ASN_PEER_ASSESSMENT_ITEM_T.REMOVED
                nullable changed from 'false' to 'true'
           sakai_12.ASN_PEER_ASSESSMENT_ITEM_T.SUBMITTED
                nullable changed from 'false' to 'true'
           sakai_12.SAKAI_PRIVACY_RECORD.lockId
                nullable changed from 'true' to 'false'
           sakai_12.lesson_builder_pages.owned
                defaultValue changed from 'null' to 'false'
                nullable changed from 'true' to 'false'
           sakai_12.CHAT2_CHANNEL.placementDefaultChannel
                nullable changed from 'false' to 'true'
           sakai_12.user_audits_log.role_name
                nullable changed from 'false' to 'true'
           sakai_12.user_audits_log.site_id
                nullable changed from 'false' to 'true'
           sakai_12.pasystem_banner_dismissed.user_id
                nullable changed from 'true' to 'false'
           sakai_12.pasystem_popup_assign.user_id
                nullable changed from 'true' to 'false'
           sakai_12.pasystem_popup_dismissed.user_id
                nullable changed from 'true' to 'false'
           sakai_12.SAKAI_POSTEM_STUDENT.username
                nullable changed from 'false' to 'true'
      

      These are the autoIncrement

           sakai_12.SAM_EXTENDEDTIME_T.ID
                autoIncrement changed from 'true' to 'false'
           sakai_12.SAM_ITEMTAG_T.ITEMTAGID
                autoIncrement changed from 'true' to 'false'
           sakai_12.SAM_PUBLISHEDITEMTAG_T.ITEMTAGID
                autoIncrement changed from 'true' to 'false'
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                ern Earle R Nietzel
                Reporter:
                jonespm Matthew Jones
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code