changed to unmaintained

[aaf/authz.git] / auth / auth-cass / cass_init / init.cql

diff --git a/auth/auth-cass/cass_init/init.cql b/auth/auth-cass/cass_init/init.cql
index bf75998..f280de0 100644 (file)
--- a/auth/auth-cass/cass_init/init.cql
+++ b/auth/auth-cass/cass_init/init.cql
@@ -73,6 +73,7 @@ CREATE TABLE cred (
     notes varchar,
     cred  blob,
     prev  blob,
+    tag   varchar,
     PRIMARY KEY (id,type,expires)
   );
 CREATE INDEX cred_ns ON cred(ns);
@@ -89,12 +90,12 @@ CREATE TABLE cert (
 CREATE INDEX cert_id ON cert(id);
 CREATE INDEX cert_x500 ON cert(x500);
 
-CREATE TABLE notify (
+CREATE TABLE notified (
   user                 text,
-  type                 int,
+  target        text,
+  key          text,
   last                 timestamp,
-  checksum     int,
-  PRIMARY KEY (user,type)
+  PRIMARY KEY (user,target,key)
 );
 
 CREATE TABLE x509 (
@@ -167,11 +168,14 @@ CREATE TABLE future (
   memo     varchar,            // Description
   start     timestamp,                 // When it should take effect
   expires   timestamp,                 // When not longer valid
+  target_key varchar,           // Item Key (or 2nd key, assuming user is first)
+  target_date timestamp,        // Item's relevant date/stamp
   construct blob,              // How to construct this object (like History)
   PRIMARY KEY(id)
 );
 CREATE INDEX future_idx ON future(target);
 CREATE INDEX future_start_idx ON future(start);
+CREATE INDEX future_target_key ON authz.future (target_key);
 
 
 CREATE TABLE approval (