hopefully final table schema

diff --git a/dialup_admin/sql/oracle/badusers.sql b/dialup_admin/sql/oracle/badusers.sql
index 7c29ed3..f211968 100644 (file)
--- a/dialup_admin/sql/oracle/badusers.sql
+++ b/dialup_admin/sql/oracle/badusers.sql
@@ -9,10 +9,10 @@
 
 CREATE TABLE badusers (
        id              INT PRIMARY KEY,
-       username        VARCHAR(30) NOT NULL,
-       actiondate      TIMESTAMP WITH TIME ZONE,
-       reason          VARCHAR(128) NOT NULL,
-       admin           VARCHAR(128) NOT NULL
+       username        VARCHAR(30) DEFAULT '' NOT NULL,
+       actiondate      TIMESTAMP WITH TIME ZONE DEFAULT sysdate NOT NULL,
+       reason          VARCHAR(128) DEFAULT '' NOT NULL,
+       admin           VARCHAR(128) DEFAULT '-' NOT NULL
 );
 CREATE SEQUENCE badusers_seq START WITH 1 INCREMENT BY 1;
 CREATE INDEX badusers_actiondate_idx ON badusers (actiondate);

diff --git a/dialup_admin/sql/oracle/mtotacct.sql b/dialup_admin/sql/oracle/mtotacct.sql
index 7067b70..b623ece 100644 (file)
--- a/dialup_admin/sql/oracle/mtotacct.sql
+++ b/dialup_admin/sql/oracle/mtotacct.sql
@@ -9,8 +9,8 @@
  */
 CREATE TABLE mtotacct (
        mtotacctid      INT PRIMARY KEY,
-       username        varchar(64) NOT NULL,
-       acctdate        DATE,
+       username        varchar(64) DEFAULT '' NOT NULL,
+       acctdate        DATE DEFAULT sysdate NOT NULL,
        connnum         NUMERIC(12),
        conntotduration NUMERIC(12),
        connmaxduration NUMERIC(12),

diff --git a/dialup_admin/sql/oracle/totacct.sql b/dialup_admin/sql/oracle/totacct.sql
index 8cbd11a..144c2f4 100644 (file)
--- a/dialup_admin/sql/oracle/totacct.sql
+++ b/dialup_admin/sql/oracle/totacct.sql
@@ -8,9 +8,9 @@
  * Table structure for table 'totacct'
  */
 CREATE TABLE totacct (
-        totacctid      INT PRIMARY KEY,
-        username        varchar(64) NOT NULL,
-        acctdate        DATE,
+        totacctid      INT PRIMARY KEY,
+        username        varchar(64) DEFAULT '' NOT NULL,
+        acctdate        DATE DEFAULT sysdate NOT NULL,
         connnum         NUMERIC(12),
         conntotduration NUMERIC(12),
         connmaxduration NUMERIC(12),

diff --git a/dialup_admin/sql/oracle/userinfo.sql b/dialup_admin/sql/oracle/userinfo.sql
index 0b73f62..7ecd6cc 100644 (file)
--- a/dialup_admin/sql/oracle/userinfo.sql
+++ b/dialup_admin/sql/oracle/userinfo.sql
@@ -8,14 +8,14 @@
  */
 
 CREATE TABLE userinfo (
-    id INT PRIMARY KEY,
-    username VARCHAR(128),
-    name VARCHAR(128),
-    mail VARCHAR(128),
-    department VARCHAR(128),
-    workphone VARCHAR(128),
-    homephone VARCHAR(128),
-    mobile VARCHAR(128) 
+       id              INT PRIMARY KEY,
+       username        VARCHAR(128) DEFAULT '' NOT NULL,
+       name            VARCHAR(128) DEFAULT '' NOT NULL,
+       mail            VARCHAR(128) DEFAULT '' NOT NULL,
+       department      VARCHAR(128) DEFAULT '' NOT NULL,
+       workphone       VARCHAR(128) DEFAULT '' NOT NULL,
+       homephone       VARCHAR(128) DEFAULT '' NOT NULL,
+       mobile          VARCHAR(128) DEFAULT '' NOT NULL 
 );
 CREATE INDEX userinfo_department_idx ON userinfo (department);
 CREATE INDEX userinfo_username_idx ON userinfo (username);