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

Make Crowd database schema lowercase

XMLWordPrintable

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

      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.

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

            [CWD-1411] Make Crowd database schema lowercase

            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 - restricted [ 1510118 ] New: JAC Bug Workflow v3 [ 3365515 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 [ 1392907 ] New: Simplified Crowd Development Workflow v2 - restricted [ 1510118 ]
            Owen made changes -
            Workflow Original: Crowd Development Workflow v2 [ 271926 ] New: Simplified Crowd Development Workflow v2 [ 1392907 ]
            jawong.adm made changes -
            Workflow Original: JIRA Bug Workflow v2 [ 174494 ] New: Crowd Development Workflow v2 [ 271926 ]
            Justin Koke made changes -
            Attachment New: mysql_startup.txt [ 32353 ]
            angel made changes -
            Attachment New: mysql-crowd2.png [ 32347 ]
            Justin Koke made changes -
            Workflow Original: jira [ 150883 ] New: JIRA Bug Workflow v2 [ 174494 ]
            Justin Koke made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Open [ 1 ] New: Resolved [ 5 ]
            Justin Koke made changes -
            Link New: This issue is incorporated by CWD-1507 [ CWD-1507 ]
            David O'Flynn [Atlassian] made changes -
            Fix Version/s New: 2.0 [ 12269 ]
            David Yu created issue -

              doflynn David O'Flynn [Atlassian]
              davidyu David Yu
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: