-- Deploy jmp:cdr to pg

BEGIN;

CREATE TYPE call_direction AS ENUM ('inbound', 'outbound');

CREATE TABLE cdr (
	cdr_id      TEXT           PRIMARY KEY,
	customer_id TEXT           NOT NULL,
	start       TIMESTAMP      NOT NULL,
	billsec     INTEGER        NOT NULL,
	disposition TEXT           NOT NULL,
	tel         TEXT           NOT NULL, -- source or destination
	direction   call_direction NOT NULL DEFAULT('outbound')
);

CREATE INDEX ON cdr (customer_id);

COMMIT;