a patch for raddb/sql/oracle/schema.sql

zhongwei feng fengzhw at gmail.com
Thu Aug 27 12:44:37 CEST 2009


hi,
	there is a simple patch . correct index problem.

--- schema.sql.orig     Mon May 18 19:13:56 2009
+++ schema.sql  Thu Aug 27 18:27:37 2009
@@ -39,7 +39,7 @@
        XAscendSessionSvrKey    VARCHAR(10)
 );
 CREATE UNIQUE INDEX radacct_idx1
-       ON radacct(acctsessionid,username,acctstarttime,
+       ON radacct(username,acctsessionid,acctstarttime,
                acctstoptime,nasipaddress,framedipaddress);
 
 CREATE SEQUENCE radacct_seq START WITH 1 INCREMENT BY 1;
@@ -65,6 +65,7 @@
        op              VARCHAR(2) NOT NULL,
        value           VARCHAR(40)
 );
+CREATE INDEX radcheck_idx1 ON radcheck(UserName);
 CREATE SEQUENCE radcheck_seq START WITH 1 INCREMENT BY 1;
 
 /* Trigger to emulate a serial # on the primary key */




More information about the Freeradius-Devel mailing list