From: danw <danw>
Date: Tue, 16 Nov 1999 04:27:26 +0000 (+0000)
Subject: IMAPpy goodness. add imap_id to users and make some device and dir
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/7509f097f2e92c0e4fd4b18fa6f9df4ca97675f1

IMAPpy goodness. add imap_id to users and make some device and dir
in nfsphys bigger
---

diff --git a/db/schema.sql b/db/schema.sql
index c799ceee..361e7bab 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -27,6 +27,7 @@ create table users
 	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,
@@ -226,8 +227,8 @@ create table nfsphys
 (
 	nfsphys_id	INTEGER		DEFAULT 0	NOT NULL,
 	mach_id		INTEGER		DEFAULT 0	NOT NULL,
-	device		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
-	dir		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
+	device		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
+	dir		VARCHAR(64) 	DEFAULT CHR(0)	NOT NULL,
 	status		SMALLINT 	DEFAULT 0	NOT NULL,
 	allocated	INTEGER		DEFAULT 0	NOT NULL,
 	partsize	INTEGER		DEFAULT 0	NOT NULL,