~singpolyma/jmp-schemas

Add schema for tel_inventory #320

Signed-off-by: Amolith <amolith@secluded.site>
customer_plans.pending
Tag for deploy, no answer and failed should not bill
Added dispositions NO ANSWER and FAILED to cdr_with_charge ignore list
Tag area_codes and sims.nickname
Added new column for setting SIM nicknames.
README should mention CI file to see how to set up
Add area_codes table

This requires PostGIS to be installed and enabled by the super user.

A table containing all the area codes in North America with their approximate
locations, for doing lookup by location.
Multi-account billing schema

Add parent_customer_id to plan_log
customer_plans view includes this new column
balances shows parent balance if there is a parent (non recursive)
INSERT INTO transactions inserts for parent if there is one (non recursive)
NOTIFY possible_renewal for self and all expired children
Tag for notify on top up an expired account
Maybe renew a customer when they top up

If they are expired and they top up, ask sgx-jmp to check if they and registered
and bill/renew them.
Tag settled_after NOT NULL
Require settled_after to be NOT NULL
Sqitch tag for settled_after
Next