add printservers table

[moira.git] / db / schema.sql

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,