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

---
 checksetup.pl | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'checksetup.pl')

diff --git a/checksetup.pl b/checksetup.pl
index 57981a639..4cfc096e1 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -3960,6 +3960,11 @@ $dbh->bz_alter_column('versions', 'value',
 $dbh->bz_add_index('versions', 'versions_product_id_idx',
                    {TYPE => 'UNIQUE', FIELDS => [qw(product_id value)]});
 
+# Milestone sortkeys get a default just like all other sortkeys.
+if (!exists $dbh->bz_column_info('milestones', 'sortkey')->{DEFAULT}) {
+    $dbh->bz_alter_column('milestones', 'sortkey', 
+                          {TYPE => 'INT2', NOTNULL => 1, DEFAULT => 0});
+}
 
 
 # If you had to change the --TABLE-- definition in any way, then add your
-- 
cgit v1.2.3-24-g4f1b