only be able to administer those access servers and not see the rest of the nas list.
* Add username searching in the find page as suggested by joram agten
* Don't use nas_list in nas_admin
+* Add postgresql specific sql schema by apellido jr., wilfredo p. Move each sql schema to a
+ separate directory (mysql and postgresql)
Ver 1.70:
* Add the /bin postgresql compatibility patch from Guy Fraser
* Add ldap_userdn as a configuration directive. If set we use that for
--- /dev/null
+SET search_path = public, pg_catalog;
+
+--Table structure for table 'badusers'
+--
+CREATE TABLE badusers (
+ id BIGSERIAL PRIMARY KEY,
+ username TEXT NOT NULL,
+ date timestamp with time zone DEFAULT 'now' NOT NULL,
+ reason TEXT,
+ admin TEXT DEFAULT '-'
+);
+CREATE INDEX badusers_actiondate_idx ON badusers USING btree (actiondate);
+CREATE INDEX badusers_username_idx ON badusers USING btree (username);
--- /dev/null
+SET search_path = public, pg_catalog;
+
+--
+-- Table structure for table 'mtotacct'
+--
+CREATE TABLE mtotacct (
+ mtotacctid BIGSERIAL PRIMARY KEY,
+ username TEXT DEFAULT '' NOT NULL,
+ acctdate DATE DEFAULT 'now' NOT NULL,
+ connnum BIGINT,
+ conntotduration BIGINT,
+ connmaxduration BIGINT,
+ connminduration BIGINT,
+ inputoctets BIGINT,
+ outputoctets BIGINT,
+ nasipaddress INET
+);
+CREATE INDEX mtotacct_acctdate_idx ON mtotacct USING btree (acctdate);
+CREATE INDEX mtotacct_nasipaddress_idx ON mtotacct USING btree
+(nasipaddress);
+CREATE INDEX mtotacct_username_idx ON mtotacct USING btree (username);
+CREATE INDEX mtotacct_userondate_idx ON mtotacct USING btree (username,
+acctdate);
--- /dev/null
+SET search_path = public, pg_catalog;
+
+--
+-- Table structure for table 'totacct'
+--
+CREATE TABLE totacct (
+ totacctid bigSERIAL PRIMARY KEY,
+ username TEXT DEFAULT '' NOT NULL,
+ acctdate DATE DEFAULT 'now' NOT NULL,
+ connnum BIGINT,
+ conntotduration BIGINT,
+ connmaxduration BIGINT,
+ connminduration BIGINT,
+ inputoctets BIGINT,
+ outputoctets BIGINT,
+ nasipaddress INET
+);
+CREATE INDEX totacct_acctdate_idx ON totacct USING btree (acctdate);
+CREATE INDEX totacct_nasipaddress_idx ON totacct USING btree (nasipaddress);
+CREATE INDEX totacct_nasondate_idx ON totacct USING btree (acctdate,
+nasipaddress);
+CREATE INDEX totacct_username_idx ON totacct USING btree (username);
+CREATE INDEX totacct_userondate_idx ON totacct USING btree (username,
+acctdate);
--- /dev/null
+SET search_path = public, pg_catalog;
+
+--
+-- Table structure for table 'userinfo'
+--
+CREATE TABLE userinfo (
+ id SERIAL PRIMARY KEY,
+ username TEXT,
+ name TEXT,
+ mail TEXT,
+ department TEXT,
+ workphone TEXT,
+ homephone TEXT,
+ mobile TEXT
+);
+CREATE INDEX userinfo_department_idx ON userinfo USING btree (department);
+CREATE INDEX userinfo_username_idx ON userinfo USING btree (username);
+
+