1 2 3 4 5 6 7 8 9 10 11 12 13 14
-- Deploy jmp:call_rates to pg -- requires: cdr BEGIN; CREATE TABLE call_rates ( prefix TEXT NOT NULL, direction call_direction NOT NULL, plan_name TEXT NOT NULL, rate NUMERIC NOT NULL, PRIMARY KEY (prefix, direction, plan_name) ); COMMIT;