Schema changes for generic acls

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 569e9ca148813e8f8fcc71a18bcff9211b061e71..bd8f501a95ed5a15abafabd039a5bcf70c6b29ff 100644 (file)
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -70,6 +70,8 @@ create unique index i_zph_class on zephyr  (class);
 
 create unique index i_hac_mid on hostaccess  (mach_id);
 
+create index i_acl_mt on acl (mach_id, target);
+
 create index i_prn_name on printers (name);
 create index i_prn_dname on printers (duplexname);
 create index i_prn_mach on printers (mach_id);

diff --git a/db/schema.sql b/db/schema.sql
index 9f1a215cb2f38754e9c7d45ef296e1403a252980..7bd54dcbfb0439085ac7fe27562ec256902ec8cb 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -148,6 +148,7 @@ create table imembers
        list_id         INTEGER         DEFAULT 0       NOT NULL,
        member_type     VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
        member_id       INTEGER         DEFAULT 0       NOT NULL,
+       tag             INTEGER         DEFAULT 0       NOT NULL,
        ref_count       SMALLINT        DEFAULT 0       NOT NULL,
        direct          SMALLINT        DEFAULT 0       NOT NULL
 );
@@ -272,6 +273,17 @@ create table hostaccess
        modwith         VARCHAR(8)      DEFAULT CHR(0)  NOT NULL
 );
 
+create table acl
+(
+       mach_id         INTEGER         DEFAULT 0       NOT NULL,
+       target          VARCHAR(128)    DEFAULT CHR(0)  NOT NULL,
+       kind            VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       list_id         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 strings 
 (
        string_id       INTEGER         DEFAULT 0       NOT NULL,

diff --git a/db/unschema.sql b/db/unschema.sql
index 9a51402ab16e6921d64282177e1f6e4e24d43eff..65a0feb3f7991adf0419c66566362275d6c747c6 100644 (file)
--- a/db/unschema.sql
+++ b/db/unschema.sql
@@ -16,6 +16,7 @@ drop table nfsphys;
 drop table quota;
 drop table zephyr;
 drop table hostaccess;
+drop table acl;
 drop table strings;
 drop table services;
 drop table printers;