Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-1411

Make Crowd database schema lowercase

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • 2.0
    • 1.6
    • Database
    • None

    Description

      We currently have a mix of upper-case and lower-case table names in Crowd. For example, ApplicationDirectoryPermission.hbm.xml contains no backticks in the table name:

          <class name="com.atlassian.crowd.model.permission.ApplicationDirectoryPermission" table="APPLICATIONDIRECTORYPERMISSION">
      

      while Application.hbm.xml does:

          <class name="com.atlassian.crowd.model.application.Application" table="`APPLICATION`">
      

      We should default on one convention as case-sensitive databases like Postgres will require you to wrap all queries that reference the tables or columns in quotes or the query won't be recognized. For people that might be interested in querying the database, or for times when we need to pass some queries to users to run, it would be nice not to have to worry about this.

      Attachments

        1. mysql_startup.txt
          14 kB
        2. mysql-crowd2.png
          mysql-crowd2.png
          32 kB

        Issue Links

          Activity

            People

              doflynn David O'Flynn [Atlassian]
              davidyu David Yu
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: