drop h_access_user_log if it exists from a previous beta, RT#75160

diff --git a/FS/FS/Upgrade.pm b/FS/FS/Upgrade.pm
index 8f751ee..da74555 100644 (file)
--- a/FS/FS/Upgrade.pm
+++ b/FS/FS/Upgrade.pm
@@ -561,6 +561,9 @@ sub upgrade_schema_data {
     'cust_bill_pkg_detail' => [],
     #add necessary columns to RT schema
     'TicketSystem' => [],
+    #remove h_access_user_log if it exists (since our regular auto schema
+    # upgrade doesn't have the drop tables flag turned on) 
+    'access_user_log' => [],
     #remove possible dangling records
     'password_history' => [],
     'cust_pay_pending' => [],

diff --git a/FS/FS/access_user_log.pm b/FS/FS/access_user_log.pm
index 563f3ce..026670c 100644 (file)
--- a/FS/FS/access_user_log.pm
+++ b/FS/FS/access_user_log.pm
@@ -135,6 +135,17 @@ sub check {
 
 =back
 
+=cut
+
+sub _upgrade_schema {
+  my ($class, %opts) = @_;
+
+  my $sql = 'DROP TABLE IF EXISTS h_access_user_log';
+
+  my $sth = dbh->prepare($sql) or die dbh->errstr;
+  $sth->execute or die $sth->errstr;
+}
+
 =head1 BUGS
 
 =head1 SEE ALSO