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

Sanitize Database tables

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.5
    • Component/s: Database
    • Labels:

      Description

      Actually , some data models in the DB are not identical to the others DB.

      Here are the differences :

      SQL SERVER :
      (MSSQL ) Table activities (user_login) has a varchar(30) , all the others varchar(255).
      (MSSQL ) Table authors (login) => varchar(100) => varchar(255)

      MYSQL :
      Table issues_changes (col user_login) VARCHAR(40) => 255

      POSTGRESQL:
      Table issues_changes (col user_login) VARCHAR(40) => 255

      ORACLE :
      Table issues_changes (col user_login) VARCHAR(40) => 255

        Attachments

          Activity

            People

            Assignee:
            simon.brandhof Simon Brandhof (Inactive)
            Reporter:
            eric.duquesnoy Eric Duquesnoy (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: