Minor schema changes to oracle and Postgres

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 b5357e1..a5e625b 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
@@ -9,7 +9,10 @@
 
 /*
  * Table structure for table 'nas'
+ * This is not currently used but FreeRADIUS but is usefull for reporting
+ * anyway.
  */
+
 CREATE TABLE nas (
        id              INT PRIMARY KEY,
        nasname         VARCHAR(128),

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 af19752..36edbe8 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
@@ -1,4 +1,11 @@
 /*
+ * $Id$
+ *
+ * Postgresql schema for FreeRADIUS
+ *
+ */
+
+/*
  * Table structure for table 'nas'
  * This is not currently used but FreeRADIUS but is usefull for reporting
  * anyway.
@@ -18,6 +25,9 @@ CREATE TABLE nas (
 
 /*
  * Table structure for table 'radacct'
+ *
+ * Note: Column type BIGSERIAL does not exist prior to Postgres 7.2
+ *       If you run an older version you need to change this to SERIAL
  */
 CREATE TABLE radacct (
   RadAcctId BIGSERIAL PRIMARY KEY,
@@ -29,7 +39,7 @@ CREATE TABLE radacct (
   NASPortId NUMERIC(12),
   NASPortType VARCHAR(32),
   AcctStartTime timestamp without time zone NOT NULL,
-  AcctStopTime timestamp without time zone NOT NULL,
+  AcctStopTime timestamp without time zone,
   AcctSessionTime NUMERIC(12),
   AcctAuthentic VARCHAR(32),
   ConnectInfo_start VARCHAR(32),