freeside/Freeside — pull request #31 by Jayceh (2014-09-30 17:01:13+00:00)
Title: Add indexes on paynum, and void_paynum. Paynum was causing major

migration pains with our process. Also a reminder that in PG, creating
a foreign key does not create an index

also added a jobnum index, as deleting from queue begins doing a full
table scan on cust_pay_pending because of the foreign key. For systems
that use the pending system, that becomes very expensive. Key makes it
run correctly.