diff options
author | mkanat%kerio.com <> | 2005-03-18 12:28:51 +0100 |
---|---|---|
committer | mkanat%kerio.com <> | 2005-03-18 12:28:51 +0100 |
commit | 675c4bb9d83bdf1916eb0bcb61a973c6f4b69a73 (patch) | |
tree | 60143f66c528547062f2082b0640beb4b0b0858b /Bugzilla/DB/Schema | |
parent | 026808687250a3e1c2415c1967e1a48abeba217b (diff) | |
download | bugzilla-675c4bb9d83bdf1916eb0bcb61a973c6f4b69a73.tar.gz bugzilla-675c4bb9d83bdf1916eb0bcb61a973c6f4b69a73.tar.xz |
Bug 285748: Cross-DB bz_alter_column (Part of Bug 285111)
Patch By Max Kanat-Alexander <mkanat@kerio.com> r=Tomas.Kopal, a=justdave
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; |