gistfile1.txt

CREATE TABLE IF NOT EXISTS streamingInventoryEvents(
  locationType text,
  locationId int,
  cacheTime timestamp,
  itemNumber text,
  tag text,
  time timestamp,
  scanType int,
  pieceTag text,
  repId int,
  ip text,
  PRIMARY KEY((locationType, locationId), cacheTime, itemNumber, tag)) WITH CLUSTERING ORDER BY (cacheTime DESC) AND default_time_to_live = 259200  AND gc_grace_seconds = 86400;
 
CREATE TABLE IF NOT EXISTS streamingInventories (
  locationType text,
  locationId int,
  cacheTime timestamp,
  PRIMARY KEY((locationType, locationId), cacheTime)) WITH CLUSTERING ORDER BY (cacheTime DESC) AND default_time_to_live = 259200  AND gc_grace_seconds = 86400;
  
CREATE TABLE IF NOT EXISTS streamingInventoryProducts (
  locationType text,
  locationId int,
  cacheTime timestamp,
  itemNumber text,
  productCount int,
  PRIMARY KEY((locationType, locationId), cacheTime, itemNumber)) WITH CLUSTERING ORDER BY (cacheTime DESC) AND default_time_to_live = 259200  AND gc_grace_seconds = 86400;