*/
/*
+ * Table structure for table 'dictionary'
+ */
+CREATE TABLE dictionary (
+ id INT PRIMARY KEY,
+ type VARCHAR(30),
+ attribute VARCHAR(32),
+ value VARCHAR(32),
+ format VARCHAR(20),
+ vendor VARCHAR(32)
+);
+CREATE SEQUENCE dictionary_seq START WITH 1 INCREMENT BY 1;
+
+/*
* 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),
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;
connectinfo_stop VARCHAR(32),
acctinputoctets NUMERIC(12),
acctoutputoctets NUMERIC(12),
- calledstationid VARCHAR(30),
- callingstationid VARCHAR(30),
+ calledstationid VARCHAR(50),
+ callingstationid VARCHAR(50),
acctterminatecause VARCHAR(32),
servicetype VARCHAR(32),
framedprotocol VARCHAR(32),