From 7509f097f2e92c0e4fd4b18fa6f9df4ca97675f1 Mon Sep 17 00:00:00 2001
From: danw <danw>
Date: Tue, 16 Nov 1999 04:27:26 +0000
Subject: [PATCH] IMAPpy goodness. add imap_id to users and make some device
 and dir in nfsphys bigger

---
 db/schema.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

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,
-- 
2.45.2