diff options
| author | jeff <jeff> | 2009-04-10 03:43:00 +0000 |
|---|---|---|
| committer | jeff <jeff> | 2009-04-10 03:43:00 +0000 |
| commit | f3ccf427a76015d690cb089f369bf8e5509c05a3 (patch) | |
| tree | 89a74543b43e5ffba0edb4bc542abf2090a26a81 | |
| parent | 0946eacb6b3a00cc8ccfcbb2623f63b821ba5321 (diff) | |
orders of magnitude faster
| -rw-r--r-- | FS/FS/cust_main.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index a39ac34c9..b828542a7 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -8434,7 +8434,7 @@ sub queued_bill { sub _upgrade_data { #class method my ($class, %opts) = @_; - my $sql = 'UPDATE h_cust_main SET paycvv = NULL'; + my $sql = 'UPDATE h_cust_main SET paycvv = NULL WHERE paycvv IS NOT NULL'; my $sth = dbh->prepare($sql) or die dbh->errstr; $sth->execute or die $sth->errstr; |