From: danw <danw>
Date: Tue, 25 May 1999 19:11:03 +0000 (+0000)
Subject: add printservers table
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/120cd8f96c319ed617dc7c1c37143e54d023bc2a

add printservers table
---

diff --git a/db/schema.sql b/db/schema.sql
index d40cff92..571e975f 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -312,6 +312,19 @@ create table printers
 	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
 );
 
+create table printservers
+(
+	mach_id		INTEGER		DEFAULT 0	NOT NULL,
+	kind		VARCHAR(8)	DEFAULT CHR(0)	NOT NULL,
+	printer_types	INTEGER		DEFAULT 0	NOT NULL,
+	owner_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
+	owner_id	INTEGER		DEFAULT 0	NOT NULL,
+	lpc_acl		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
+);
+
 create table capacls 
 (
 	capability	VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
diff --git a/db/unschema.sql b/db/unschema.sql
index 0744a8ce..9a51402a 100644
--- a/db/unschema.sql
+++ b/db/unschema.sql
@@ -7,20 +7,21 @@ drop table clusters;
 drop table mcmap;
 drop table svc;
 drop table list;
-drop table imembers ;
-drop table servers ;
-drop table serverhosts ;
-drop table filesys ;
+drop table imembers;
+drop table servers;
+drop table serverhosts;
+drop table filesys;
 drop table fsgroup;
-drop table nfsphys ;
-drop table quota ;
-drop table zephyr ;
-drop table hostaccess ;
-drop table strings ;
-drop table services ;
-drop table printers ;
-drop table capacls ;
-drop table alias ;
-drop table numvalues ;
-drop table tblstats ;
+drop table nfsphys;
+drop table quota;
+drop table zephyr;
+drop table hostaccess;
+drop table strings;
+drop table services;
+drop table printers;
+drop table printservers;
+drop table capacls;
+drop table alias;
+drop table numvalues;
+drop table tblstats;
 drop table incremental;