From 2c8620b2e8774136788a42929dbe9faded5e9008 Mon Sep 17 00:00:00 2001
From: pnixon <pnixon>
Date: Fri, 18 Mar 2005 22:29:57 +0000
Subject: [PATCH] totacct for Oracle

---
 sql/oracle/totacct.sql | 40 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 sql/oracle/totacct.sql

diff --git a/sql/oracle/totacct.sql b/sql/oracle/totacct.sql
new file mode 100644
index 0000000..8cbd11a
--- /dev/null
+++ b/sql/oracle/totacct.sql
@@ -0,0 +1,40 @@
+/*
+ * $Id$
+ *
+ */
+
+
+/*
+ * Table structure for table 'totacct'
+ */
+CREATE TABLE totacct (
+        totacctid      INT PRIMARY KEY,
+        username        varchar(64) NOT NULL,
+        acctdate        DATE,
+        connnum         NUMERIC(12),
+        conntotduration NUMERIC(12),
+        connmaxduration NUMERIC(12),
+        connminduration NUMERIC(12),
+        inputoctets     NUMERIC(12),
+        outputoctets    NUMERIC(12),
+        nasipaddress    varchar(15) default NULL
+);
+CREATE INDEX totacct_acctdate_idx ON totacct (acctdate);
+CREATE INDEX totacct_nasipaddress_idx ON totacct (nasipaddress);
+CREATE INDEX totacct_nasondate_idx ON totacct (acctdate, nasipaddress);
+CREATE INDEX totacct_username_idx ON totacct (username);
+CREATE INDEX totacct_userondate_idx ON totacct (username, acctdate);
+
+CREATE SEQUENCE totacct_seq START WITH 1 INCREMENT BY 1;
+
+/* Trigger to emulate a serial # on the primary key */
+CREATE OR REPLACE TRIGGER totacct_serialnumber
+        BEFORE INSERT OR UPDATE OF totacctid ON totacct
+        FOR EACH ROW
+        BEGIN
+                if ( :new.totacctid = 0 or :new.totacctid is null ) then
+                        SELECT totacct_seq.nextval into :new.totacctid from dual;
+                end if;
+        END;
+/
+
-- 
2.39.5