Revision
14271
Author
rupa
Date
2009-07-16 10:40:29 -0500 (Thu, 16 Jul 2009)

Log Message

update sql

Modified Paths

Diff

Modified: freeswitch/trunk/src/mod/applications/mod_lcr/sql/mysql-5.0.sql (14270 => 14271)


--- freeswitch/trunk/src/mod/applications/mod_lcr/sql/mysql-5.0.sql	2009-07-16 15:38:16 UTC (rev 14270)
+++ freeswitch/trunk/src/mod/applications/mod_lcr/sql/mysql-5.0.sql	2009-07-16 15:40:29 UTC (rev 14271)
@@ -24,7 +24,8 @@
   `id` int(11) NOT NULL auto_increment,
   `digits` varchar(15) default NULL,
   `rate` float(11,5) unsigned NOT NULL,
-  `intra` float(11, 5) unsigned NOT NULL,
+  `intrastate_rate` float(11, 5) unsigned NOT NULL,
+  `intralata_rate` float(11, 5) unsigned NOT NULL,
   `carrier_id` int(11) NOT NULL,
   `lead_strip` int(11) NOT NULL,
   `trail_strip` int(11) NOT NULL,

Modified: freeswitch/trunk/src/mod/applications/mod_lcr/sql/postgres-8.3.sql (14270 => 14271)


--- freeswitch/trunk/src/mod/applications/mod_lcr/sql/postgres-8.3.sql	2009-07-16 15:38:16 UTC (rev 14270)
+++ freeswitch/trunk/src/mod/applications/mod_lcr/sql/postgres-8.3.sql	2009-07-16 15:40:29 UTC (rev 14271)
@@ -43,7 +43,8 @@
   id serial NOT NULL,
   digits NUMERIC(20, 0),
   rate numeric(11,5) NOT NULL,
-  intra numeric(11,5) NOT NULL,
+  intrastate_rate numeric(11,5) NOT NULL,
+  intralata_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,