Add list_id and publicflg columns to containers table.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 1e926c70e514b7fe10ffa83ced98b0ad56948d74..9793fa79607a818a3a25be5f6644e8e02ebfd6ed 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -407,6 +407,8 @@ create table containers
 (
        name            VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
        cnt_id          INTEGER         DEFAULT 0       NOT NULL,
+       list_id         INTEGER         DEFAULT 0       NOT NULL,
+       publicflg       INTEGER         DEFAULT 0       NOT NULL,
        description     VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
        location        VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
        contact         VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,