projects
/
freeradius.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Pull from branch_0_9: Widen call{ed,ing}stationid from 30 to 50
[freeradius.git]
/
src
/
modules
/
rlm_sql
/
drivers
/
rlm_sql_oracle
/
db_oracle.sql
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
bddbe10
..
8e9fc40
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
@@
-22,7
+22,10
@@
CREATE SEQUENCE dictionary_seq START WITH 1 INCREMENT BY 1;
/*
* Table structure for table 'nas'
/*
* 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),
CREATE TABLE nas (
id INT PRIMARY KEY,
nasname VARCHAR(128),
@@
-32,7
+35,8
@@
CREATE TABLE nas (
ports INT,
secret VARCHAR(60),
community VARCHAR(50),
ports INT,
secret VARCHAR(60),
community VARCHAR(50),
- snmp VARCHAR(10)
+ snmp VARCHAR(10),
+ naslocation VARCHAR(10)
);
CREATE SEQUENCE nas_seq START WITH 1 INCREMENT BY 1;
);
CREATE SEQUENCE nas_seq START WITH 1 INCREMENT BY 1;
@@
-56,8
+60,8
@@
CREATE TABLE radacct (
connectinfo_stop VARCHAR(32),
acctinputoctets NUMERIC(12),
acctoutputoctets NUMERIC(12),
connectinfo_stop VARCHAR(32),
acctinputoctets NUMERIC(12),
acctoutputoctets NUMERIC(12),
- calledstationid VARCHAR(
3
0),
- callingstationid VARCHAR(
3
0),
+ calledstationid VARCHAR(
5
0),
+ callingstationid VARCHAR(
5
0),
acctterminatecause VARCHAR(32),
servicetype VARCHAR(32),
framedprotocol VARCHAR(32),
acctterminatecause VARCHAR(32),
servicetype VARCHAR(32),
framedprotocol VARCHAR(32),