[Koha-bugs] [Bug 7945] New: rename DB columns in Koha, that are 'reserved words' in SQL

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Apr 12 07:37:45 CEST 2012


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7945

          Priority: P5 - low
 Change sponsored?: ---
            Bug ID: 7945
          Assignee: gmcharlt at gmail.com
           Summary: rename DB columns in Koha, that are 'reserved words'
                    in SQL
        QA Contact: koha.sekjal at gmail.com
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: mtj at kohaaloha.com
          Hardware: All
            Status: NEW
           Version: master
         Component: Database
           Product: Koha

some database columns in Koha match SQL reserved-words

this bug will attempt to locate these columns, and rename them


fyi: here's some links for reserved-words in mysql and postgres...
 http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html
 http://www.postgresql.org/docs/8.1/static/sql-keywords-appendix.html

and some other dbs too...
 http://www.adp-gmbh.ch/ora/sql/reserved_words.html
 http://msdn.microsoft.com/en-us/library/aa238507(v=sql.80).aspx
 http://drupal.org/node/141051

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list