Update Oracle schema to use the Oracle equivalent of BIGINT "NUMERIC(19)"

[freeradius.git] / doc / examples / oracle.sql

diff --git a/doc/examples/oracle.sql b/doc/examples/oracle.sql
index 3910a83..f97890d 100644 (file)
--- a/doc/examples/oracle.sql
+++ b/doc/examples/oracle.sql
@@ -51,12 +51,12 @@ CREATE TABLE radacct (
        nasporttype             VARCHAR(32),
        acctstarttime           TIMESTAMP WITH TIME ZONE,
        acctstoptime            TIMESTAMP WITH TIME ZONE,
-       acctsessiontime         NUMERIC(12),
+       acctsessiontime         NUMERIC(19),
        acctauthentic           VARCHAR(32),
        connectinfo_start       VARCHAR(50),
        connectinfo_stop        VARCHAR(50),
-       acctinputoctets         NUMERIC(12),
-       acctoutputoctets        NUMERIC(12),
+       acctinputoctets         NUMERIC(19),
+       acctoutputoctets        NUMERIC(19),
        calledstationid         VARCHAR(50),
        callingstationid        VARCHAR(50),
        acctterminatecause      VARCHAR(32),