diff options
| author | mkanat%kerio.com <> | 2005-06-21 10:38:57 +0200 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-06-21 10:38:57 +0200 |
| commit | 5609425d739829a7c26840b021e3a89dceb34005 (patch) | |
| tree | 0a6dbcdf0d42051ccb5dfd43a0e9180f8a412bbb | |
| parent | 7f9a55a1573e31ca4189fb9a379960ede2200f4b (diff) | |
| download | bugzilla-5609425d739829a7c26840b021e3a89dceb34005.tar.gz bugzilla-5609425d739829a7c26840b021e3a89dceb34005.tar.xz | |
Bug 296039: [PostgreSQL] Cannot create a new product
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=wurblzap, a=myk
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 3 | ||||
| -rwxr-xr-x | checksetup.pl | 5 |
2 files changed, 7 insertions, 1 deletions
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)], 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 |