View | Details | Raw Unified | Return to bug 25429
Collapse All | Expand All

(-)a/misc/cronjobs/cleanup_database.pl (-39 / +49 lines)
Lines 47-91 sub usage { Link Here
47
    print STDERR <<USAGE;
47
    print STDERR <<USAGE;
48
Usage: $0 [-h|--help] [--sessions] [--sessdays DAYS] [-v|--verbose] [--zebraqueue DAYS] [-m|--mail] [--merged] [--import DAYS] [--logs DAYS] [--searchhistory DAYS] [--restrictions DAYS] [--all-restrictions] [--fees DAYS] [--temp-uploads] [--temp-uploads-days DAYS] [--uploads-missing 0|1 ] [--statistics DAYS] [--deleted-catalog DAYS] [--deleted-patrons DAYS] [--old-issues DAYS] [--old-reserves DAYS] [--transfers DAYS]
48
Usage: $0 [-h|--help] [--sessions] [--sessdays DAYS] [-v|--verbose] [--zebraqueue DAYS] [-m|--mail] [--merged] [--import DAYS] [--logs DAYS] [--searchhistory DAYS] [--restrictions DAYS] [--all-restrictions] [--fees DAYS] [--temp-uploads] [--temp-uploads-days DAYS] [--uploads-missing 0|1 ] [--statistics DAYS] [--deleted-catalog DAYS] [--deleted-patrons DAYS] [--old-issues DAYS] [--old-reserves DAYS] [--transfers DAYS]
49
49
50
   -h --help          prints this help message, and exits, ignoring all
50
   -h --help               Prints this help message, and exits, ignoring all other options.
51
                      other options
51
52
   --sessions         purge the sessions table.  If you use this while users 
52
   --sessions              Purge the sessions table.  If you use this while users 
53
                      are logged into Koha, they will have to reconnect.
53
                           are logged into Koha, they will have to reconnect.
54
   --sessdays DAYS    purge only sessions older than DAYS days.
54
55
   -v --verbose       will cause the script to give you a bit more information
55
   --sessdays DAYS         Purge only sessions older than DAYS days.
56
                      about the run.
56
57
   --zebraqueue DAYS  purge completed zebraqueue entries older than DAYS days.
57
   -v --verbose            Will cause the script to give you a bit more information
58
                      Defaults to 30 days if no days specified.
58
                           about the run.
59
   -m --mail DAYS     purge items from the mail queue that are older than DAYS days.
59
60
                      Defaults to 30 days if no days specified.
60
   --zebraqueue DAYS       Purge completed zebraqueue entries older than DAYS days.
61
   --merged           purged completed entries from need_merge_authorities.
61
                           Defaults to 30 days if no days specified.
62
   --import DAYS      purge records from import tables older than DAYS days.
62
63
                      Defaults to 60 days if no days specified.
63
   -m --mail DAYS          Purge items from the mail queue that are older than DAYS days.
64
   --z3950            purge records from import tables that are the result
64
                           Defaults to 30 days if no days specified.
65
                      of Z39.50 searches
65
66
   --fees DAYS        purge entries accountlines older than DAYS days, where
66
   --merged                Purge completed entries from need_merge_authorities.
67
                      amountoutstanding is 0 or NULL.
67
68
                      In the case of --fees, DAYS must be greater than
68
   --import DAYS           Purge records from import tables older than DAYS days.
69
                      or equal to 1.
69
                           Defaults to 60 days if no days specified.
70
   --logs DAYS        purge entries from action_logs older than DAYS days.
70
71
                      Defaults to 180 days if no days specified.
71
   --z3950                 Purge records from import tables that are the result
72
   --searchhistory DAYS  purge entries from search_history older than DAYS days.
72
                           of Z39.50 searches
73
                         Defaults to 30 days if no days specified
73
74
   --list-invites  DAYS  purge (unaccepted) list share invites older than DAYS
74
   --fees DAYS             Purge entries accountlines older than DAYS days, where amountoutstanding is 0 or NULL.
75
                         days.  Defaults to 14 days if no days specified.
75
                           In the case of --fees, DAYS must be greater than or equal to 1.
76
   --restrictions DAYS   purge patrons restrictions expired since more than DAYS days.
76
77
                         Defaults to 30 days if no days specified.
77
   --logs DAYS             Purge entries from action_logs older than DAYS days.
78
   --all-restrictions   purge all expired patrons restrictions.
78
                           Defaults to 180 days if no days specified.
79
   --return-claims DAYS Purge all resolved return claims older than DAYS
79
80
   --del-exp-selfreg  Delete expired self registration accounts
80
   --searchhistory DAYS    Purge entries from search_history older than DAYS days.
81
   --del-unv-selfreg  DAYS  Delete unverified self registrations older than DAYS
81
                           Defaults to 30 days if no days specified
82
   --unique-holidays DAYS  Delete all unique holidays older than DAYS
82
83
   --temp-uploads     Delete temporary uploads.
83
   --list-invites DAYS     Purge (unaccepted) list share invites older than DAYS
84
   --temp-uploads-days DAYS Override the corresponding preference value.
84
                           days.  Defaults to 14 days if no days specified.
85
   --uploads-missing FLAG Delete upload records for missing files when FLAG is true, count them otherwise
85
86
   --oauth-tokens     Delete expired OAuth2 tokens
86
   --restrictions DAYS     Purge patrons restrictions expired since more than DAYS days.
87
                           Defaults to 30 days if no days specified.
88
89
   --all-restrictions      Purge all expired patrons restrictions.
90
   --return-claims DAYS    Purge all resolved return claims older than DAYS.
91
   --del-exp-selfreg       Delete expired self registration accounts.
92
   --del-unv-selfreg DAYS  Delete unverified self registrations older than DAYS.
93
   --unique-holidays DAYS  Delete all unique holidays older than DAYS.
94
   --temp-uploads          Delete temporary uploads.
95
   --temp-uploads-daysDAYS Override the corresponding preference value.
96
   --uploads-missing FLAG  Delete upload records for missing files when FLAG is true, count them otherwise.
97
   --oauth-tokens          Delete expired OAuth2 tokens.
87
   --statistics DAYS       Purge statistics entries more than DAYS days old.
98
   --statistics DAYS       Purge statistics entries more than DAYS days old.
88
   --deleted-catalog  DAYS Purge catalog records deleted more then DAYS days ago
99
   --deleted-catalog DAYS  Purge catalog records deleted more then DAYS days ago.
89
                           (from tables deleteditems, deletedbiblioitems, deletedbiblio_metadata and deletedbiblio).
100
                           (from tables deleteditems, deletedbiblioitems, deletedbiblio_metadata and deletedbiblio).
90
   --deleted-patrons DAYS  Purge patrons deleted more than DAYS days ago.
101
   --deleted-patrons DAYS  Purge patrons deleted more than DAYS days ago.
91
   --old-issues DAYS       Purge checkouts (old_issues) returned more than DAYS days ago.
102
   --old-issues DAYS       Purge checkouts (old_issues) returned more than DAYS days ago.
92
- 

Return to bug 25429