Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-14792

Remove DB migrations prior to 8.9, create a 9.0 initial schema

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 9.0
    • Component/s: Database
    • Labels:
      None
    • Edition:
      Community
    • Production Notes:
      None

      Description

      Since migrating from LTS 8.9 is required to upgrade to 9.0 and later, all incremental steps (DB migrations) executed to reach DB schema of SQ 8.9 can be compressed into a single one in 9.0.

      => notes from the SQ council: we specifically want to remove db migrations < 8.9, to not have unexpected upgrade paths 7.9 -> 9.0 without installing 8.9.

      Once this task is done, it will not be possible to upgrade from 7.9 to 9.0.

      As migrations are executed for all UT and ITs, we expect a small speed improvement in the CI.

        Attachments

          Issue Links

          1.
          Drop all 8.X migrations SONAR-14966 Sub-task Closed Jacek Poreda Major
          2.
          Move any DB helpers out of 8.X migrations (if any) SONAR-14967 Sub-task Closed Jacek Poreda Major
          3.
          Drop tables from init script SONAR-14965 Sub-task Closed Jacek Poreda Major
          4.
          Update table definition ACTIVE_RULE_PARAMETERS SONAR-14969 Sub-task Closed Jacek Poreda Major
          5.
          Update table definition ACTIVE_RULES SONAR-14970 Sub-task Closed Jacek Poreda Major
          6.
          Create table definition ALM_PATS SONAR-14971 Sub-task Closed Pierre Guillot Major
          7.
          Create table definition ALM_SETTINGS SONAR-14972 Sub-task Closed Pierre Guillot Major
          8.
          Update table definition ANALYSIS_PROPERTIES SONAR-14973 Sub-task Closed Jacek Poreda Major
          9.
          Create table definition APP_BRANCH_PROJECT_BRANCH SONAR-14974 Sub-task Closed Pierre Guillot Major
          10.
          Create table definition APP_PROJECTS SONAR-14975 Sub-task Closed Pierre Guillot Major
          11.
          Update table definition CE_ACTIVITY SONAR-14976 Sub-task Closed Pierre Guillot Major
          12.
          Update table definition CE_QUEUE SONAR-14977 Sub-task Closed Pierre Guillot Major
          13.
          Update table definition CE_TASK_MESSAGE SONAR-14978 Sub-task Closed Pierre Guillot Major
          14.
          Create table definition COMPONENTS SONAR-14979 Sub-task Closed Pierre Guillot Major
          15.
          Update table definition DEFAULT_QPROFILES SONAR-14980 Sub-task Closed Pierre Guillot Major
          16.
          Update table definition DEPRECATED_RULE_KEYS SONAR-14981 Sub-task Closed Pierre Guillot Major
          17.
          Update table definition DUPLICATIONS_INDEX SONAR-14982 Sub-task Closed Pierre Guillot Major
          18.
          Update table definition EVENTS SONAR-14983 Sub-task Closed Pierre Guillot Major
          19.
          Update table definition FILE_SOURCES SONAR-14984 Sub-task Closed Pierre Guillot Major
          20.
          Update table definition GROUP_ROLES SONAR-14985 Sub-task Closed Pierre Guillot Major
          21.
          Update table definition GROUPS SONAR-14986 Sub-task Closed Pierre Guillot Major
          22.
          Update table definition GROUPS_USERS SONAR-14987 Sub-task Closed Pierre Guillot Major
          23.
          Update table definition INTERNAL_PROPERTIES SONAR-14988 Sub-task Closed Pierre Guillot Major
          24.
          Update table definition ISSUE_CHANGES SONAR-14989 Sub-task Closed Pierre Guillot Major
          25.
          Update table definition ISSUES SONAR-14990 Sub-task Closed Pierre Guillot Major
          26.
          Update table definition LIVE_MEASURES SONAR-14991 Sub-task Closed Pierre Guillot Major
          27.
          Update table definition MANUAL_MEASURES SONAR-14992 Sub-task Closed Pierre Guillot Major
          28.
          Update table definition METRICS SONAR-14993 Sub-task Closed Pierre Guillot Major
          29.
          Create table definition NEW_CODE_PERIODS SONAR-14994 Sub-task Closed Pierre Guillot Major
          30.
          Update table definition NOTIFICATIONS SONAR-14995 Sub-task Closed Pierre Guillot Major
          31.
          Update table definition ORG_QPROFILES SONAR-14996 Sub-task Closed Pierre Guillot Major
          32.
          Update table definition PERM_TEMPLATES_GROUPS SONAR-14997 Sub-task Closed Pierre Guillot Major
          33.
          Update table definition PERM_TEMPLATES_USERS SONAR-14998 Sub-task Closed Pierre Guillot Major
          34.
          Update table definition PERM_TPL_CHARACTERISTICS SONAR-14999 Sub-task Closed Pierre Guillot Major
          35.
          Update table definition PERMISSION_TEMPLATES SONAR-15000 Sub-task Closed Pierre Guillot Major
          36.
          Update table definition PLUGINS SONAR-15001 Sub-task Closed Pierre Guillot Major
          37.
          Create table definition PROJECT_ALM_SETTINGS SONAR-15002 Sub-task Closed Pierre Guillot Major
          38.
          Update table definition PROJECT_BRANCHES SONAR-15003 Sub-task Closed Pierre Guillot Major
          39.
          Update table definition PROJECT_MEASURES SONAR-15004 Sub-task Closed Pierre Guillot Major
          40.
          Update table definition PROJECT_QPROFILES SONAR-15005 Sub-task Closed Pierre Guillot Major
          41.
          Update table definition PROJECTS SONAR-15006 Sub-task Closed Pierre Guillot Major
          42.
          Update table definition PROPERTIES SONAR-15007 Sub-task Closed Jacek Poreda Major
          43.
          Update table definition QPROFILE_CHANGES SONAR-15008 Sub-task Closed Pierre Guillot Major
          44.
          Update table definition QPROFILE_EDIT_GROUPS SONAR-15009 Sub-task Closed Pierre Guillot Major
          45.
          Update table definition QPROFILE_EDIT_USERS SONAR-15010 Sub-task Closed Pierre Guillot Major
          46.
          Update table definition QUALITY_GATE_CONDITIONS SONAR-15011 Sub-task Closed Pierre Guillot Major
          47.
          Update table definition QUALITY_GATES SONAR-15012 Sub-task Closed Pierre Guillot Major
          48.
          Update table definition RULES SONAR-15013 Sub-task Closed Pierre Guillot Major
          49.
          Update table definition RULES_METADATA SONAR-15014 Sub-task Closed Pierre Guillot Major
          50.
          Update table definition RULES_PARAMETERS SONAR-15015 Sub-task Closed Pierre Guillot Major
          51.
          Update table definition RULES_PROFILES SONAR-15016 Sub-task Closed Pierre Guillot Major
          52.
          Create table definition SAML_MESSAGE_IDS SONAR-15017 Sub-task Closed Pierre Guillot Major
          53.
          Create table definition SESSION_TOKENS SONAR-15018 Sub-task Closed Pierre Guillot Major
          54.
          Update table definition SNAPSHOTS SONAR-15019 Sub-task Closed Pierre Guillot Major
          55.
          Create table definition USER_DISMISSED_MESSAGES SONAR-15020 Sub-task Closed Pierre Guillot Major
          56.
          Update table definition USER_ROLES SONAR-15021 Sub-task Closed Pierre Guillot Major
          57.
          Update table definition USER_TOKENS SONAR-15022 Sub-task Closed Pierre Guillot Major
          58.
          Update table definition USERS SONAR-15023 Sub-task Closed Pierre Guillot Major
          59.
          Update table definition WEBHOOK_DELIVERIES SONAR-15024 Sub-task Closed Pierre Guillot Major
          60.
          Update table definition WEBHOOKS SONAR-15025 Sub-task Closed Pierre Guillot Major
          61.
          Preserve order of columns in table builder SONAR-15030 Sub-task Closed Jacek Poreda Major
          62.
          remove newLenientVarcharBuilder from initial init schema script SONAR-15038 Sub-task Closed Pierre Guillot Major

            Activity

              People

              Assignee:
              jacek.poreda Jacek Poreda
              Reporter:
              pierre.guillot Pierre Guillot
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: