hopefully final table schema

[freeradius.git] / dialup_admin / sql / oracle / userinfo.sql

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);