Add userhistory table.

diff --git a/db/schema.sql b/db/schema.sql
index a03920ec33ac11f54e49ede622a6855c2859a108..763f05d7d1725a2ccbd62d8daeeeb27225b93e62 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -421,3 +421,59 @@ create table accountnumbers
 (
        account_number  VARCHAR(10)     DEFAULT CHR(0)  NOT NULL
 );
+
+create table userhistory
+(
+       login           VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
+       users_id        INTEGER         DEFAULT 0       NOT NULL,
+       unix_uid        SMALLINT        DEFAULT 0       NOT NULL,
+       shell           VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       winconsoleshell VARCHAR(32)     DEFAULT 'cmd'   NOT NULL,
+       last            VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
+       first           VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
+       middle          VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
+       status          SMALLINT        DEFAULT 0       NOT NULL,
+       clearid         VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       type            VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
+       comments        INTEGER         DEFAULT 0       NOT NULL,
+       modtime         DATE            DEFAULT SYSDATE NOT NULL,
+       modby           INTEGER         DEFAULT 0       NOT NULL,
+       modwith         VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
+       fullname        VARCHAR(92)     DEFAULT CHR(0)  NOT NULL,
+       nickname        VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       home_addr       VARCHAR(82)     DEFAULT CHR(0)  NOT NULL,
+       home_phone      VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
+       office_addr     VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       office_phone    VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
+       department      VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
+       affiliation     VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
+       fmodtime        DATE            DEFAULT SYSDATE NOT NULL,
+       fmodby          INTEGER         DEFAULT 0       NOT NULL,
+       fmodwith        VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
+       potype          VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
+       pop_id          INTEGER         DEFAULT 0       NOT NULL,
+       imap_id         INTEGER         DEFAULT 0       NOT NULL,
+       box_id          INTEGER         DEFAULT 0       NOT NULL,
+       pmodtime        DATE            DEFAULT SYSDATE NOT NULL,
+       pmodby          INTEGER         DEFAULT 0       NOT NULL,
+       pmodwith        VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
+       xname           VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
+       xdept           VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
+       xtitle          VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
+       xaddress        VARCHAR(82)     DEFAULT CHR(0)  NOT NULL,
+       xphone1         VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
+       xphone2         VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
+       xmodtime        DATE            DEFAULT SYSDATE NOT NULL,
+       sigdate         INTEGER         DEFAULT 0       NOT NULL,
+       sigwho          INTEGER         DEFAULT 0       NOT NULL,
+       signature       VARCHAR(68)     DEFAULT CHR(0)  NOT NULL,
+       secure          INTEGER         DEFAULT 0       NOT NULL,       
+       pin             VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,
+       reservations    VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,
+       flag            INTEGER         DEFAULT 0       NOT NULL,
+       created         DATE            DEFAULT SYSDATE NOT NULL,
+       creator         INTEGER         DEFAULT 0       NOT NULL,
+       winhomedir      VARCHAR(260)    DEFAULT '[DFS]' NOT NULL,
+       winprofiledir   VARCHAR(260)    DEFAULT '[DFS]' NOT NULL,
+       purged          DATE            DEFAULT SYSDATE NOT NULL
+);