add a flag to groups allowing them to be turned "off" as far as accepting any new...
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 16 Aug 2006 03:58:35 +0000 (03:58 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 16 Aug 2006 03:58:35 +0000 (03:58 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@5526 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/sql/Pg/006.schema.permissions.sql

index a3451aa..39293b4 100644 (file)
@@ -119,6 +119,7 @@ CREATE TABLE permission.grp_tree (
        id                      SERIAL  PRIMARY KEY,
        name                    TEXT    NOT NULL UNIQUE,
        parent                  INT     REFERENCES permission.grp_tree (id) ON DELETE RESTRICT,
+       usergroup               BOOL    NOT NULL DEFAULT TRUE,
        perm_interval           INTERVAL DEFAULT '3 years'::interval NOT NULL,
        description             TEXT,
        application_perm        TEXT