Bug 13795: Remove occurences of unused columns in code

[koha-equinox.git] / installer / data / mysql / backfill_statistics.pl

diff --git a/installer/data/mysql/backfill_statistics.pl b/installer/data/mysql/backfill_statistics.pl
index 8308b6b..daa8e83 100755 (executable)
--- a/installer/data/mysql/backfill_statistics.pl
+++ b/installer/data/mysql/backfill_statistics.pl
@@ -24,9 +24,7 @@ sub get_counts() {
        (SELECT count(*) FROM statistics WHERE branch="NO_LIBRARY"       ) AS NO_LIBRARY,
        (SELECT count(*) FROM statistics WHERE branch             IS NULL) AS NULL_BRANCH,
        (SELECT count(*) FROM statistics WHERE itemtype           IS NULL AND itemnumber IS NOT NULL) AS NULL_ITEMTYPE,
-       (SELECT count(*) FROM statistics WHERE usercode           IS NULL) AS NULL_USERCODE,
        (SELECT count(*) FROM statistics WHERE borrowernumber     IS NULL) AS NULL_BORROWERNUMBER,
-       (SELECT count(*) FROM statistics WHERE associatedborrower IS NULL) AS NULL_ASSOCIATEDBORROWER,
        (SELECT count(*) FROM statistics                                 ) AS Total
        );
        my $sth = $dbh->prepare($query);