X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=auth%2Fauth-cass%2Fcass_init%2Finit.cql;h=f280de0085bae4f4c5195ee943c6cfdb6d858f50;hb=889a9891f6df5bbb26a760cfb106be947e87aa5c;hp=bf75998d5ccc56f401149d52124119d2a5683de0;hpb=c77226927523b821936debe660e880b713c88edc;p=aaf%2Fauthz.git

diff --git a/auth/auth-cass/cass_init/init.cql b/auth/auth-cass/cass_init/init.cql
index bf75998d..f280de00 100644
--- 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 (