add a "banner" field to the printers table to determine whether or not

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 7c43496a62026b6dda0d94df04eeb0fdfa78025b..d40cff928c5deb3875a048f502f414fa4d04cbc5 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -304,6 +304,7 @@ create table printers
        pc              SMALLINT        DEFAULT 0       NOT NULL,
        ac              INTEGER         DEFAULT 0       NOT NULL,
        lpc_acl         INTEGER         DEFAULT 0       NOT NULL,
+       banner          INTEGER         DEFAULT 0       NOT NULL,
        location        VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
        contact         VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
        modtime         DATE            DEFAULT SYSDATE NOT NULL,