gistfile1.txt

cqlsh> describe KEYSPACE "OpsCenter";

CREATE KEYSPACE "OpsCenter" WITH replication = {
  'class': 'SimpleStrategy',
  'replication_factor': '1'
};

USE "OpsCenter";

CREATE TABLE backup_reports (
  week text,
  event_time timestamp,
  backup_id text,
  type text,
  destination text,
  deleted_at timestamp,
  full_status text,
  keyspaces text,
  status text,
  PRIMARY KEY ((week), event_time, backup_id, type, destination)
) WITH CLUSTERING ORDER BY (event_time DESC, backup_id ASC, type ASC, destination ASC) AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=864000 AND
  index_interval=128 AND
  read_repair_chance=0.000000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'class': 'SizeTieredCompactionStrategy'} AND
  compression={'sstable_compression': 'LZ4Compressor'};

CREATE TABLE bestpractice_results (
  key text,
  column1 varint,
  value blob,
  PRIMARY KEY ((key), column1)
) WITH COMPACT STORAGE AND
  CLUSTERING ORDER BY (column1 DESC) AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=0 AND
  index_interval=128 AND
  read_repair_chance=0.250000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'min_threshold': '4', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '32'} AND
  compression={'sstable_compression': 'LZ4Compressor'};

CREATE TABLE events (
  key text,
  action bigint,
  api_source_ip text,
  column_family text,
  event_source text,
  "keyspace" text,
  level bigint,
  message text,
  source_node text,
  success boolean,
  target_node text,
  time bigint,
  user text,
  PRIMARY KEY ((key))
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=864000 AND
  index_interval=128 AND
  read_repair_chance=0.250000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'min_threshold': '8', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '12'} AND
  compression={'sstable_compression': 'LZ4Compressor'};

CREATE TABLE events_timeline (
  key text,
  column1 bigint,
  value blob,
  PRIMARY KEY ((key), column1)
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=864000 AND
  index_interval=128 AND
  read_repair_chance=0.250000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'min_threshold': '4', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '8'} AND
  compression={'sstable_compression': 'LZ4Compressor'};

CREATE TABLE pdps (
  key text,
  column1 text,
  value blob,
  PRIMARY KEY ((key), column1)
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=0 AND
  index_interval=128 AND
  read_repair_chance=0.250000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'min_threshold': '4', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '32'} AND
  compression={'sstable_compression': 'LZ4Compressor'};

CREATE TABLE rollups300 (
  key text,
  "timestamp" varint,
  value blob,
  PRIMARY KEY ((key), "timestamp")
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=0 AND
  index_interval=128 AND
  read_repair_chance=0.250000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'min_threshold': '4', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '16'} AND
  compression={'sstable_compression': 'LZ4Compressor'};

CREATE TABLE rollups60 (
  key text,
  "timestamp" varint,
  value blob,
  PRIMARY KEY ((key), "timestamp")
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=0 AND
  index_interval=128 AND
  read_repair_chance=0.250000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'min_threshold': '4', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '32'} AND
  compression={'sstable_compression': 'LZ4Compressor'};

CREATE TABLE rollups7200 (
  key text,
  "timestamp" varint,
  value blob,
  PRIMARY KEY ((key), "timestamp")
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=0 AND
  index_interval=128 AND
  read_repair_chance=0.250000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'min_threshold': '2', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '8'} AND
  compression={'sstable_compression': 'LZ4Compressor'};

CREATE TABLE rollups86400 (
  key text,
  "timestamp" varint,
  value blob,
  PRIMARY KEY ((key), "timestamp")
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=0 AND
  index_interval=128 AND
  read_repair_chance=0.250000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'min_threshold': '2', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '8'} AND
  compression={'sstable_compression': 'LZ4Compressor'};

CREATE TABLE settings (
  key blob,
  column1 blob,
  value blob,
  PRIMARY KEY ((key), column1)
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=864000 AND
  index_interval=128 AND
  read_repair_chance=1.000000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'min_threshold': '8', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '12'} AND
  compression={'sstable_compression': 'LZ4Compressor'};