X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/7509f097f2e92c0e4fd4b18fa6f9df4ca97675f1..de3d85c08a322e2546da6619d7cba842f5ba1f8f:/db/schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 361e7bab..7073f68f 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -4,6 +4,7 @@ create table users
 	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 CHR(0)	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,
@@ -124,7 +125,7 @@ create table svc
 (
 	clu_id		INTEGER		DEFAULT 0	NOT NULL,
 	serv_label	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
-	serv_cluster	VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL
+	serv_cluster	VARCHAR(128) 	DEFAULT CHR(0)	NOT NULL
 );
 
 create table list
@@ -137,9 +138,12 @@ create table list
 	maillist	INTEGER 	DEFAULT 0	NOT NULL,
 	grouplist	INTEGER 	DEFAULT 0	NOT NULL,
 	gid		SMALLINT 	DEFAULT 0	NOT NULL,
+	nfsgroup	INTEGER		DEFAULT 0	NOT NULL,	
 	description	VARCHAR(255) 	DEFAULT CHR(0)	NOT NULL,
 	acl_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
 	acl_id		INTEGER		DEFAULT 0	NOT NULL,
+	memacl_type	VARCHAR(8)	DEFAULT 'NONE'	NOT NULL,
+	memacl_id	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
@@ -260,6 +264,8 @@ create table zephyr
 	iws_id		INTEGER		DEFAULT 0	NOT NULL,
 	iui_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
 	iui_id		INTEGER		DEFAULT 0	NOT NULL,
+	owner_type	VARCHAR(8)	DEFAULT 'NONE'	NOT NULL,
+	owner_id	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
@@ -374,3 +380,17 @@ create table incremental
 	table_name	VARCHAR(16)	DEFAULT CHR(0)	NOT NULL,
 	service		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL
 );
+
+create table usersids
+(
+	users_id	INTEGER		DEFAULT 0	NOT NULL,
+	sid		VARCHAR(64)	DEFAULT CHR(0)	NOT NULL,
+	created		DATE		DEFAULT SYSDATE	NOT NULL
+);
+
+create table listsids
+(
+	list_id		INTEGER		DEFAULT 0	NOT NULL,
+	sid		VARCHAR(64)	DEFAULT CHR(0)	NOT NULL,
+	created		DATE		DEFAULT SYSDATE	NOT NULL
+);
