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 /Bugzilla | |
| 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 'Bugzilla')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Series.pm | 11 |
2 files changed, 7 insertions, 6 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 5f8fe4869..ccbef9834 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -873,7 +873,7 @@ use constant ABSTRACT_SCHEMA => { frequency => {TYPE => 'INT2', NOTNULL => 1}, last_viewed => {TYPE => 'DATETIME'}, query => {TYPE => 'MEDIUMTEXT', NOTNULL => 1}, - public => {TYPE => 'BOOLEAN', NOTNULL => 1, + is_public => {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE'}, ], INDEXES => [ diff --git a/Bugzilla/Series.pm b/Bugzilla/Series.pm index db4e1f9f9..521357488 100644 --- a/Bugzilla/Series.pm +++ b/Bugzilla/Series.pm @@ -18,6 +18,7 @@ # Rights Reserved. # # Contributor(s): Gervase Markham <gerv@gerv.net> +# Lance Larsh <lance.larsh@oracle.com> use strict; use lib "."; @@ -90,7 +91,7 @@ sub initFromDatabase { my $dbh = Bugzilla->dbh; my @series = $dbh->selectrow_array("SELECT series.series_id, cc1.name, " . "cc2.name, series.name, series.creator, series.frequency, " . - "series.query, series.public " . + "series.query, series.is_public " . "FROM series " . "LEFT JOIN series_categories AS cc1 " . " ON series.category = cc1.id " . @@ -103,11 +104,11 @@ sub initFromDatabase { " AND ugm.user_id = " . Bugzilla->user->id . " AND isbless = 0 " . "WHERE series.series_id = $series_id AND " . - "(public = 1 OR creator = " . Bugzilla->user->id . " OR " . + "(is_public = 1 OR creator = " . Bugzilla->user->id . " OR " . "(ugm.group_id IS NOT NULL)) " . $dbh->sql_group_by('series.series_id', 'cc1.name, cc2.name, ' . 'series.name, series.creator, series.frequency, ' . - 'series.query, series.public')); + 'series.query, series.is_public')); if (@series) { $self->initFromParameters(@series); @@ -189,7 +190,7 @@ sub writeToDatabase { my $dbh = Bugzilla->dbh; $dbh->do("UPDATE series SET " . "category = ?, subcategory = ?," . - "name = ?, frequency = ?, public = ? " . + "name = ?, frequency = ?, is_public = ? " . "WHERE series_id = ?", undef, $category_id, $subcategory_id, $self->{'name'}, $self->{'frequency'}, $self->{'public'}, @@ -198,7 +199,7 @@ sub writeToDatabase { else { # Insert the new series into the series table $dbh->do("INSERT INTO series (creator, category, subcategory, " . - "name, frequency, query, public) VALUES " . + "name, frequency, query, is_public) VALUES " . "($self->{'creator'}, " . "$category_id, $subcategory_id, " . $dbh->quote($self->{'name'}) . ", $self->{'frequency'}," . |