summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
authormkanat%kerio.com <>2005-09-23 23:24:30 +0200
committermkanat%kerio.com <>2005-09-23 23:24:30 +0200
commit882d039556a75fd7f6bd2a605d91c8f3e616e98a (patch)
treeea32f3cab46ec56feeefc2244de49fd15fb07743 /Bugzilla
parentfa82fac5cc984fc02be50c49b1790f382d1d57e6 (diff)
downloadbugzilla-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.pm2
-rw-r--r--Bugzilla/Series.pm11
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'}," .