[Freeswitch-svn] [commit] r10496 - in freeswitch/trunk/scripts/contrib/intralanman/C/lcr: mod_lcr sql

[FreeSWITCH SVN]

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);
+