add printservers table

diff --git a/db/schema.sql b/db/schema.sql
index d40cff928c5deb3875a048f502f414fa4d04cbc5..571e975f561cf1fd9541e8cc0b7c27fd99ac034b 100644 (file)
--- 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 0744a8ce728376eb31054b3c517667c095d2aa26..9a51402ab16e6921d64282177e1f6e4e24d43eff 100644 (file)
--- 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;