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