[Freeswitch-svn] [commit] r12813 - freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql

[FreeSWITCH SVN]

Author: rupa
Date: Fri Mar 27 15:11:21 2009
New Revision: 12813

Log:
update sample DDL


Modified:
   freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/mysql-5.0.sql
   freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/postgres-8.3.sql

Modified: freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/mysql-5.0.sql
==============================================================================
--- freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/mysql-5.0.sql	(original)
+++ freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/mysql-5.0.sql	Fri Mar 27 15:11:21 2009
@@ -34,6 +34,7 @@
   `date_end` datetime NOT NULL DEFAULT '2030-12-31',
   `quality` float(10,6) NOT NULL,
   `reliability` float(10,6) NOT NULL,
+  `cid` varchar(32), NOT NULL DEFAULT '',
   `enabled` boolean NOT NULL DEFAULT '1',
   PRIMARY KEY  (`id`),
   KEY `carrier_id` (`carrier_id`),

Modified: freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/postgres-8.3.sql
==============================================================================
--- freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/postgres-8.3.sql	(original)
+++ freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/postgres-8.3.sql	Fri Mar 27 15:11:21 2009
@@ -53,6 +53,7 @@
   date_end timestamp with time zone NOT NULL DEFAULT '2030-12-31',
   quality numeric(10,6) NOT NULL DEFAULT 0,
   reliability numeric(10,6) NOT NULL DEFAULT 0,
+  cid VARCHAR(32) NOT NULL DEFAULT '',
   enabled boolean NOT NULL DEFAULT 'true',
   CONSTRAINT lcr_pkey PRIMARY KEY (id)
 );