Change ConnectInfo_{start,stop} to be varchar(50). This closes Bug#204

diff --git a/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql b/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql
index 73297d4..0f7421b 100644 (file)
--- a/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql
+++ b/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql
@@ -25,8 +25,8 @@ CREATE TABLE radacct (
   AcctStopTime datetime NOT NULL default '0000-00-00 00:00:00',
   AcctSessionTime int(12) default NULL,
   AcctAuthentic varchar(32) default NULL,
-  ConnectInfo_start varchar(32) default NULL,
-  ConnectInfo_stop varchar(32) default NULL,
+  ConnectInfo_start varchar(50) default NULL,
+  ConnectInfo_stop varchar(50) default NULL,
   AcctInputOctets bigint(12) default NULL,
   AcctOutputOctets bigint(12) default NULL,
   CalledStationId varchar(50) NOT NULL default '',

diff --git a/src/modules/rlm_sql/drivers/rlm_sql_oracle/db_oracle.sql b/src/modules/rlm_sql/drivers/rlm_sql_oracle/db_oracle.sql
index 5b2ebe9..4c4053e 100644 (file)
--- a/src/modules/rlm_sql/drivers/rlm_sql_oracle/db_oracle.sql
+++ b/src/modules/rlm_sql/drivers/rlm_sql_oracle/db_oracle.sql
@@ -52,8 +52,8 @@ CREATE TABLE radacct (
        acctstoptime            DATE,
        acctsessiontime         NUMERIC(12),
        acctauthentic           VARCHAR(32),
-       connectinfo_start       VARCHAR(32),
-       connectinfo_stop        VARCHAR(32),
+       connectinfo_start       VARCHAR(50),
+       connectinfo_stop        VARCHAR(50),
        acctinputoctets         NUMERIC(12),
        acctoutputoctets        NUMERIC(12),
        calledstationid         VARCHAR(50),

diff --git a/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_postgresql.sql b/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_postgresql.sql
index a0eb505..f0bf2d4 100644 (file)
--- a/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_postgresql.sql
+++ b/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_postgresql.sql
@@ -26,8 +26,8 @@ CREATE TABLE radacct (
        AcctStopTime            TIMESTAMP with time zone,
        AcctSessionTime         BIGINT,
        AcctAuthentic           VARCHAR(32),
-       ConnectInfo_start       VARCHAR(32),
-       ConnectInfo_stop        VARCHAR(32),
+       ConnectInfo_start       VARCHAR(50),
+       ConnectInfo_stop        VARCHAR(50),
        AcctInputOctets         BIGINT,
        AcctOutputOctets        BIGINT,
        CalledStationId         VARCHAR(50),