Author: intralanman Date: Fri Nov 21 11:09:17 2008 New Revision: 10496 Log: add pg schema && rm -f `find brainfart` Added: freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/ freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/postgres-8.3.sql Removed: freeswitch/trunk/scripts/contrib/intralanman/C/lcr/mod_lcr/mod_lcr.c.rej.orig Added: freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/postgres-8.3.sql ============================================================================== --- (empty file) +++ freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/postgres-8.3.sql Fri Nov 21 11:09:17 2008 @@ -0,0 +1,79 @@ +-- Table: carriers + +-- DROP TABLE carriers; + +CREATE TABLE carriers +( + id serial NOT NULL, + carrier_name VARCHAR(255) NOT NULL, + CONSTRAINT carriers_pkey PRIMARY KEY (id) +); + +-- Table: carrier_gateway + +-- DROP TABLE carrier_gateway; + +CREATE TABLE carrier_gateway +( + id serial NOT NULL, + carrier_id integer REFERENCES carriers(id), + prefix VARCHAR(128) NOT NULL DEFAULT '', + suffix VARCHAR(128) NOT NULL DEFAULT '', + CONSTRAINT carrier_gateway_pkey PRIMARY KEY (id) +); + +-- Index: gateway + +-- DROP INDEX gateway; + +CREATE UNIQUE INDEX gateway + ON carrier_gateway + (gateway, term_host, port); + +-- Table: lcr + +-- DROP TABLE lcr; + +CREATE TABLE lcr +( + id serial NOT NULL, + digits VARCHAR(15), + rate numeric(11,5) NOT NULL, + carrier_id integer NOT NULL REFERENCES carriers(id), + lead_strip integer NOT NULL DEFAULT 0, + trail_strip integer NOT NULL DEFAULT 0, + prefix VARCHAR(16) NOT NULL DEFAULT '', + suffix VARCHAR(16) NOT NULL DEFAULT '', + lcr_profile VARCHAR(32), + date_start timestamp with time zone NOT NULL, + date_end timestamp with time zone NOT NULL, + quality numeric(10,6) NOT NULL DEFAULT 0, + reliability numeric(10,6) NOT NULL DEFAULT 0, + CONSTRAINT lcr_pkey PRIMARY KEY (id) +); + +-- Index: digits_rate + +-- DROP INDEX digits_rate; + +CREATE INDEX digits_rate + ON lcr + USING btree + (digits, rate); + +-- Index: profile_digits_15 + +-- DROP INDEX profile_digits_15; + +CREATE INDEX profile_digits_15 + ON lcr + (digits, lcr_profile); + +-- Index: unique_route + +-- DROP INDEX unique_route; + +CREATE INDEX unique_route + ON lcr + (digits, carrier_id); +