diff options
Diffstat (limited to 'Bugzilla/DB/Schema')
-rw-r--r-- | Bugzilla/DB/Schema/Mysql.pm | 13 | ||||
-rw-r--r-- | Bugzilla/DB/Schema/Pg.pm | 4 |
2 files changed, 14 insertions, 3 deletions
diff --git a/Bugzilla/DB/Schema/Mysql.pm b/Bugzilla/DB/Schema/Mysql.pm index dff626097..fa6e2d5ba 100644 --- a/Bugzilla/DB/Schema/Mysql.pm +++ b/Bugzilla/DB/Schema/Mysql.pm @@ -96,5 +96,16 @@ sub _get_create_index_ddl { return($sql); } #eosub--_get_create_index_ddl -#------------------------------------------------------------------------------ +#-------------------------------------------------------------------- + +# MySQL has a simpler ALTER TABLE syntax than ANSI. +sub get_alter_column_ddl { + + my ($self, $table, $column, $new_def) = @_; + + my $new_ddl = $self->get_type_ddl($new_def); + + return (("ALTER TABLE $table CHANGE COLUMN $column $column $new_ddl")); +} + 1; diff --git a/Bugzilla/DB/Schema/Pg.pm b/Bugzilla/DB/Schema/Pg.pm index 3a45744bb..59072e79d 100644 --- a/Bugzilla/DB/Schema/Pg.pm +++ b/Bugzilla/DB/Schema/Pg.pm @@ -115,8 +115,8 @@ sub get_add_column_ddl { } if ($definition->{PRIMARYKEY}) { - push(@statements, "ALTER TABLE $table ALTER COLUMN $column " - . " SET ADD PRIMARY KEY"); + push(@statements, "ALTER TABLE $table ALTER COLUMN " + . " ADD PRIMARY KEY ($column)"); } return @statements; |