[Freeswitch-svn] [commit] r12813 - freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql
FreeSWITCH SVN
rupa at freeswitch.org
Fri Mar 27 13:11:21 PDT 2009
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)
);
More information about the Freeswitch-svn
mailing list