From f18c6f0b18359a7b3e525bf398f51ccb1773c86f Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Sun, 17 Apr 2005 14:27:06 +0000 Subject: Bug 290411: Cross-DB bz_drop_table Patch By Max Kanat-Alexander r=Tomas.Kopal, a=justdave --- Bugzilla/DB/Schema.pm | 31 ++++++++++++++++++++++++++++++- 1 file changed, 30 insertions(+), 1 deletion(-) (limited to 'Bugzilla/DB') diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index c65d1f0f2..8dce761d8 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1549,6 +1549,18 @@ sub get_drop_column_ddl { return ("ALTER TABLE $table DROP COLUMN $column"); } +=item C + + Description: Generate SQL to drop a table from the database. + Params: $table - The name of the table to drop. + Returns: An array of SQL statements. + +=cut +sub get_drop_table_ddl { + my ($self, $table) = @_; + return ("DROP TABLE $table"); +} + sub get_rename_column_ddl { =item C @@ -1568,11 +1580,28 @@ sub get_rename_column_ddl { . " has not implemented a method."; } +=item C + + Description: Deletes a table from this Schema object. + Dies if you try to delete a table that doesn't exist. + Params: $name - The name of the table to delete. + Returns: nothing + +=cut +sub delete_table { + my ($self, $name) = @_; + + die "Attempted to delete nonexistent table '$name'." unless + $self->get_table_abstract($name); + + delete $self->{abstract_schema}->{$name}; + delete $self->{schema}->{$name}; +} + sub get_column_abstract { =item C - Description: A column definition from the abstract internal schema. cross-database format. Params: $table - The name of the table -- cgit v1.2.3-24-g4f1b