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

Update conversion script (or code) for changed column sizes

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: RESOLVED
    • Priority: Blocker
    • 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

      Many column sizes or types have changed because of fixes in 12. These need to be researched and updated

           sakai_12.CHAT2_CHANNEL.CHANNEL_ID
                type changed from 'VARCHAR(36 BYTE)' to 'VARCHAR(99 BYTE)'
           sakai_12.CHAT2_MESSAGE.CHANNEL_ID
                type changed from 'VARCHAR(36 BYTE)' to 'VARCHAR(99 BYTE)'
           sakai_12.SAKAI_USER.CREATEDON
                type changed from 'DATETIME(19)' to 'TIMESTAMP(19)'
           sakai_12.SAKAI_CONFIG_ITEM.DEFAULT_VALUE
                type changed from 'VARCHAR(3000 BYTE)' to 'VARCHAR(4000 BYTE)'
           sakai_12.SAKAI_CONFIG_ITEM.DESCRIPTION
                type changed from 'VARCHAR(3000 BYTE)' to 'VARCHAR(4000 BYTE)'
           sakai_12.CHAT2_MESSAGE.MESSAGE_ID
                type changed from 'VARCHAR(36 BYTE)' to 'VARCHAR(99 BYTE)'
           sakai_12.SAKAI_CONFIG_ITEM.RAW_VALUE
                type changed from 'VARCHAR(3000 BYTE)' to 'VARCHAR(4000 BYTE)'
           sakai_12.ASN_PEER_ASSESSMENT_ITEM_T.REVIEW_COMMENT
                type changed from 'LONGTEXT(2147483647)' to 'VARCHAR(6000 BYTE)'
           sakai_12.SAKAI_SESSION.SESSION_SERVER
                type changed from 'VARCHAR(255 BYTE)' to 'VARCHAR(64 BYTE)'
           sakai_12.SAKAI_CONFIG_ITEM.VALUE
                type changed from 'VARCHAR(3000 BYTE)' to 'VARCHAR(4000 BYTE)'
           sakai_12.lti_content.toolorder
                type changed from 'INT(10)' to 'TINYINT(3)'
           sakai_12.lti_tools.toolorder
                type changed from 'INT(10)' to 'TINYINT(3)'
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jonespm Matthew Jones
                Reporter:
                jonespm Matthew Jones
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code