From 5a88ca1e93bf4c5165c5de07748180f4acf5065d Mon Sep 17 00:00:00 2001
From: zacheiss <zacheiss>
Date: Sun, 18 Sep 2005 02:49:31 +0000
Subject: [PATCH] Add userhistory table.

---
 db/schema.sql | 56 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 56 insertions(+)

diff --git a/db/schema.sql b/db/schema.sql
index a03920ec..763f05d7 100644
--- 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
+);
-- 
2.45.1