%syntax-version=1.0.0 %project=jmp transactions 2021-02-22T19:15:25Z Stephen Paul Weber # Creates a table to track user's transactions balances 2021-02-23T15:08:09Z Stephen Paul Weber # Creates a view to lookup customer balances sub_cent_transactions 2021-02-24T01:37:35Z Stephen Paul Weber # Minutes cost less than 1 cent, so we need more decimal places plan_log 2021-02-24T01:53:29Z Stephen Paul Weber # Log to show what plans an account has had customer_plans 2021-02-24T02:06:25Z Stephen Paul Weber # View of current customer plans cdr 2021-02-24T18:36:49Z Stephen Paul Weber # Create CDR table for Asterisk @2021062 2021-03-03T14:38:01Z Stephen Paul Weber # First production deploy of jmp-pay plan_log_with_range [plan_log customer_plans] 2021-05-03T19:30:36Z Stephen Paul Weber,,, # Switch plan_log to use a tsrange @2021130 2021-05-11T01:37:34Z Stephen Paul Weber,,, # Deploy to production invites 2021-05-17T20:31:00Z Stephen Paul Weber,,, # Table to store invite codes and their state unused_invites 2021-05-17T20:40:20Z Stephen Paul Weber,,, # View for invites not yet used invite_per_15 [transactions invites] 2021-08-18T17:46:38Z Stephen Paul Weber,,, # $15 gives you an invite code