From: Ivan Kohler <ivan@freeside.biz>
Date: Sat, 18 Mar 2017 18:58:09 +0000 (-0700)
Subject: drop h_access_user_log if it exists from a previous beta, RT#75160
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=1a2bd8688493c5bf950fd6af5c2835b9753f8c0f

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 8f751eef6..da74555a5 100644
--- 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 563f3cef0..026670caf 100644
--- 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