From 5609425d739829a7c26840b021e3a89dceb34005 Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Tue, 21 Jun 2005 08:38:57 +0000
Subject: Bug 296039: [PostgreSQL] Cannot create a new product Patch By Max
 Kanat-Alexander <mkanat@bugzilla.org> r=wurblzap, a=myk

---
 Bugzilla/DB/Schema.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'Bugzilla/DB')

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 2ca0abc1a..c7d4a5583 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -469,7 +469,8 @@ use constant ABSTRACT_SCHEMA => {
         FIELDS => [
             product_id => {TYPE => 'INT2', NOTNULL => 1},
             value      => {TYPE => 'varchar(20)', NOTNULL => 1},
-            sortkey    => {TYPE => 'INT2', NOTNULL => 1},
+            sortkey    => {TYPE => 'INT2', NOTNULL => 1,
+                           DEFAULT => 0},
         ],
         INDEXES => [
             milestones_product_id_idx => {FIELDS => [qw(product_id value)],
-- 
cgit v1.2.3-24-g4f1b