diff options
| author | mkanat%kerio.com <> | 2005-09-23 23:24:30 +0200 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-09-23 23:24:30 +0200 |
| commit | 882d039556a75fd7f6bd2a605d91c8f3e616e98a (patch) | |
| tree | ea32f3cab46ec56feeefc2244de49fd15fb07743 /checksetup.pl | |
| parent | fa82fac5cc984fc02be50c49b1790f382d1d57e6 (diff) | |
| download | bugzilla-882d039556a75fd7f6bd2a605d91c8f3e616e98a.tar.gz bugzilla-882d039556a75fd7f6bd2a605d91c8f3e616e98a.tar.xz | |
Bug 308717: Column name "PUBLIC" in SERIES table is an Oracle reserved word
Patch By Lance Larsh <lance.larsh@oracle.com> r=mkanat, a=justdave
Diffstat (limited to 'checksetup.pl')
| -rwxr-xr-x | checksetup.pl | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/checksetup.pl b/checksetup.pl index 1ad8124cf..2c7eca5c1 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -4031,6 +4031,14 @@ if ($dbh->bz_column_info("attachments", "thedata")) { $dbh->bz_drop_column("attachments", "thedata"); } +# 2005-09-15 lance.larsh@oracle.com Bug 308717 +if ($dbh->bz_column_info("series", "public")) { + # PUBLIC is a reserved word in Oracle, so renaming the column + # PUBLIC in table SERIES avoids having to quote the column name + # in every query against that table + $dbh->bz_rename_column('series', 'public', 'is_public'); +} + # If you had to change the --TABLE-- definition in any way, then add your # differential change code *** A B O V E *** this comment. |