Connected to: "Apigee" on 10.201.148.235/9160
Welcome to Cassandra CLI version 1.2.11

Type 'help;' or '?' for help.
Type 'quit;' or 'exit;' to quit.

[default@unknown] show schema;
create keyspace Locks
  with placement_strategy = 'SimpleStrategy'
  and strategy_options = {replication_factor : 1}
  and durable_writes = true;

use Locks;

create column family HLocks
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 1.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace Usergrid
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-1 : 1}
  and durable_writes = true;

use Usergrid;

create column family Applications
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family PrincipalTokens
  with column_type = 'Standard'
  and comparator = 'UUIDType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Properties
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Tokens
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace Usergrid_Applications
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-1 : 1}
  and durable_writes = true;

use Usergrid_Applications;

create column family Application_Aggregate_Counters
  with column_type = 'Standard'
  and comparator = 'LongType'
  and default_validation_class = 'CounterColumnType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Application_Roles
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Applications
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Consumer_Queue_Messages_Properties
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Entity_Composite_Dictionaries
  with column_type = 'Standard'
  and comparator = 'DynamicCompositeType(b=>org.apache.cassandra.db.marshal.BytesType,A=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.AsciiType),B=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.BytesType),a=>org.apache.cassandra.db.marshal.AsciiType,L=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LongType),l=>org.apache.cassandra.db.marshal.LongType,I=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.IntegerType),i=>org.apache.cassandra.db.marshal.IntegerType,U=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.UUIDType),T=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.TimeUUIDType),u=>org.apache.cassandra.db.marshal.UUIDType,t=>org.apache.cassandra.db.marshal.TimeUUIDType,s=>org.apache.cassandra.db.marshal.UTF8Type,S=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.UTF8Type),X=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LexicalUUIDType),x=>org.apache.cassandra.db.marshal.LexicalUUIDType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Entity_Counters
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'CounterColumnType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Entity_Dictionaries
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Entity_Id_Sets
  with column_type = 'Standard'
  and comparator = 'UUIDType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Entity_Index
  with column_type = 'Standard'
  and comparator = 'DynamicCompositeType(b=>org.apache.cassandra.db.marshal.BytesType,A=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.AsciiType),B=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.BytesType),a=>org.apache.cassandra.db.marshal.AsciiType,L=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LongType),l=>org.apache.cassandra.db.marshal.LongType,I=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.IntegerType),i=>org.apache.cassandra.db.marshal.IntegerType,U=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.UUIDType),T=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.TimeUUIDType),u=>org.apache.cassandra.db.marshal.UUIDType,t=>org.apache.cassandra.db.marshal.TimeUUIDType,s=>org.apache.cassandra.db.marshal.UTF8Type,S=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.UTF8Type),X=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LexicalUUIDType),x=>org.apache.cassandra.db.marshal.LexicalUUIDType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Entity_Index_Entries
  with column_type = 'Standard'
  and comparator = 'DynamicCompositeType(b=>org.apache.cassandra.db.marshal.BytesType,A=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.AsciiType),B=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.BytesType),a=>org.apache.cassandra.db.marshal.AsciiType,L=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LongType),l=>org.apache.cassandra.db.marshal.LongType,I=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.IntegerType),i=>org.apache.cassandra.db.marshal.IntegerType,U=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.UUIDType),T=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.TimeUUIDType),u=>org.apache.cassandra.db.marshal.UUIDType,t=>org.apache.cassandra.db.marshal.TimeUUIDType,s=>org.apache.cassandra.db.marshal.UTF8Type,S=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.UTF8Type),X=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LexicalUUIDType),x=>org.apache.cassandra.db.marshal.LexicalUUIDType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Entity_Metadata
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Entity_Properties
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Entity_Unique
  with column_type = 'Standard'
  and comparator = 'UUIDType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family MQ_Consumers
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family MQ_Consumers_Timeout
  with column_type = 'Standard'
  and comparator = 'UUIDType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family MQ_Counters
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'CounterColumnType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family MQ_Property_Index
  with column_type = 'Standard'
  and comparator = 'DynamicCompositeType(b=>org.apache.cassandra.db.marshal.BytesType,A=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.AsciiType),B=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.BytesType),a=>org.apache.cassandra.db.marshal.AsciiType,L=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LongType),l=>org.apache.cassandra.db.marshal.LongType,I=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.IntegerType),i=>org.apache.cassandra.db.marshal.IntegerType,U=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.UUIDType),T=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.TimeUUIDType),u=>org.apache.cassandra.db.marshal.UUIDType,t=>org.apache.cassandra.db.marshal.TimeUUIDType,s=>org.apache.cassandra.db.marshal.UTF8Type,S=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.UTF8Type),X=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LexicalUUIDType),x=>org.apache.cassandra.db.marshal.LexicalUUIDType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family MQ_Property_Index_Entries
  with column_type = 'Standard'
  and comparator = 'DynamicCompositeType(b=>org.apache.cassandra.db.marshal.BytesType,A=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.AsciiType),B=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.BytesType),a=>org.apache.cassandra.db.marshal.AsciiType,L=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LongType),l=>org.apache.cassandra.db.marshal.LongType,I=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.IntegerType),i=>org.apache.cassandra.db.marshal.IntegerType,U=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.UUIDType),T=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.TimeUUIDType),u=>org.apache.cassandra.db.marshal.UUIDType,t=>org.apache.cassandra.db.marshal.TimeUUIDType,s=>org.apache.cassandra.db.marshal.UTF8Type,S=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.UTF8Type),X=>org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LexicalUUIDType),x=>org.apache.cassandra.db.marshal.LexicalUUIDType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Queue_Dictionaries
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Queue_Inbox
  with column_type = 'Standard'
  and comparator = 'UUIDType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Queue_Properties
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Queue_Subscribers
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Queue_Subscriptions
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace analytics
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use analytics;

create column family custom_aggregates_defn
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family custom_aggregates_defn_updates
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family custom_rules_defn
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family custom_rules_defn_updates
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace apihub
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use apihub;

create column family apis
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'ALL'
  and column_metadata = [
    {column_name : 'm_by',
    validation_class : UTF8Type},
    {column_name : 'a_uuid',
    validation_class : UTF8Type,
    index_name : 'a_a_uuid',
    index_type : 0},
    {column_name : 'desc',
    validation_class : UTF8Type},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'a_org_name',
    index_type : 0},
    {column_name : 'c_time',
    validation_class : UTF8Type},
    {column_name : 'c_by',
    validation_class : UTF8Type},
    {column_name : 'a_latest_rev',
    validation_class : UTF8Type,
    index_name : 'a_latest_rev',
    index_type : 0},
    {column_name : 'm_time',
    validation_class : UTF8Type},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 'a_name',
    index_type : 0},
    {column_name : 'a_curr_rev',
    validation_class : UTF8Type,
    index_name : 'a_curr_rev',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family apis_revision
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'ALL'
  and column_metadata = [
    {column_name : 'api_uuid',
    validation_class : UTF8Type,
    index_name : 'ar_api_uuid',
    index_type : 0},
    {column_name : 'ar_is_curr',
    validation_class : UTF8Type,
    index_name : 'ar_is_curr',
    index_type : 0},
    {column_name : 'desc',
    validation_class : UTF8Type},
    {column_name : 'c_time',
    validation_class : UTF8Type},
    {column_name : 'c_by',
    validation_class : UTF8Type},
    {column_name : 'm_by',
    validation_class : UTF8Type},
    {column_name : 'api_name',
    validation_class : UTF8Type,
    index_name : 'ar_api_name',
    index_type : 0},
    {column_name : 'rev_num',
    validation_class : UTF8Type,
    index_name : 'ar_rev_num',
    index_type : 0},
    {column_name : 'ar_uuid',
    validation_class : UTF8Type,
    index_name : 'ar_a_uuid',
    index_type : 0},
    {column_name : 'base_url',
    validation_class : UTF8Type,
    index_name : 'ar_base_url',
    index_type : 0},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'ar_org_name',
    index_type : 0},
    {column_name : 'm_time',
    validation_class : UTF8Type},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 'ar_name',
    index_type : 0},
    {column_name : 'ar_is_latest',
    validation_class : UTF8Type,
    index_name : 'ar_is_latest',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family credentials
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'ALL'
  and column_metadata = [
    {column_name : 'm_by',
    validation_class : UTF8Type},
    {column_name : 'access_token_url',
    validation_class : UTF8Type},
    {column_name : 'request_token_url',
    validation_class : UTF8Type},
    {column_name : 'client_secret',
    validation_class : UTF8Type},
    {column_name : 'client_id',
    validation_class : UTF8Type},
    {column_name : 'c_by',
    validation_class : UTF8Type},
    {column_name : 'access_token_param_name',
    validation_class : UTF8Type},
    {column_name : 'access_token_type',
    validation_class : UTF8Type},
    {column_name : 'request_token_verb',
    validation_class : UTF8Type},
    {column_name : 'client_auth_scheme',
    validation_class : UTF8Type},
    {column_name : 'authorization_verb',
    validation_class : UTF8Type},
    {column_name : 'authorization_url',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family groups
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'ALL'
  and column_metadata = [
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'group_orgName',
    index_type : 0},
    {column_name : 'description',
    validation_class : UTF8Type,
    index_name : 'description',
    index_type : 0},
    {column_name : 'group_name',
    validation_class : UTF8Type,
    index_name : 'group_name',
    index_type : 0},
    {column_name : 'group_type',
    validation_class : UTF8Type,
    index_name : 'group_type',
    index_type : 0},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 'g_name',
    index_type : 0},
    {column_name : 'group_uuid',
    validation_class : UTF8Type,
    index_name : 'group_uuid',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family html
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'ALL'
  and column_metadata = [
    {column_name : 'html_uuid',
    validation_class : UTF8Type,
    index_name : 'html_uuid',
    index_type : 0},
    {column_name : 'entity',
    validation_class : UTF8Type,
    index_name : 'html_entity',
    index_type : 0},
    {column_name : 'api_name',
    validation_class : UTF8Type,
    index_name : 'h_api_name',
    index_type : 0},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'html_org_name',
    index_type : 0},
    {column_name : 'template',
    validation_class : BytesType},
    {column_name : 'org_uuid',
    validation_class : UTF8Type,
    index_name : 'html_org_uuid',
    index_type : 0},
    {column_name : 'html',
    validation_class : BytesType},
    {column_name : 'entity_uuid',
    validation_class : UTF8Type,
    index_name : 'entity_uuid',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family operation
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'ALL'
  and column_metadata = [
    {column_name : 'api_uuid',
    validation_class : UTF8Type,
    index_name : 'o_api_uuid',
    index_type : 0},
    {column_name : 'ar_name',
    validation_class : UTF8Type,
    index_name : 'o_ar_name',
    index_type : 0},
    {column_name : 'desc',
    validation_class : UTF8Type},
    {column_name : 'c_time',
    validation_class : UTF8Type},
    {column_name : 'c_by',
    validation_class : UTF8Type},
    {column_name : 'verb',
    validation_class : UTF8Type,
    index_name : 'o_verb',
    index_type : 0},
    {column_name : 'm_by',
    validation_class : UTF8Type},
    {column_name : 'resps',
    validation_class : UTF8Type},
    {column_name : 'api_name',
    validation_class : UTF8Type,
    index_name : 'o_api_name',
    index_type : 0},
    {column_name : 'rev_num',
    validation_class : UTF8Type,
    index_name : 'or_rev_num',
    index_type : 0},
    {column_name : 'ar_uuid',
    validation_class : UTF8Type,
    index_name : 'o_ar_uuid',
    index_type : 0},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'o_org_name',
    index_type : 0},
    {column_name : 'resource_uuid',
    validation_class : UTF8Type,
    index_name : 'o_resource_uuid',
    index_type : 0},
    {column_name : 'res_name',
    validation_class : UTF8Type,
    index_name : 'o_res_name',
    index_type : 0},
    {column_name : 'm_time',
    validation_class : UTF8Type},
    {column_name : 'o_uuid',
    validation_class : UTF8Type,
    index_name : 'o_o_uuid',
    index_type : 0},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 'o_name',
    index_type : 0},
    {column_name : 'req',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family resource
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'ALL'
  and column_metadata = [
    {column_name : 'api_uuid',
    validation_class : UTF8Type,
    index_name : 'r_api_uuid',
    index_type : 0},
    {column_name : 'desc',
    validation_class : UTF8Type},
    {column_name : 'c_time',
    validation_class : UTF8Type},
    {column_name : 'c_by',
    validation_class : UTF8Type},
    {column_name : 'm_by',
    validation_class : UTF8Type},
    {column_name : 'api_name',
    validation_class : UTF8Type,
    index_name : 'r_api_name',
    index_type : 0},
    {column_name : 'rel_ver',
    validation_class : UTF8Type},
    {column_name : 'rev_num',
    validation_class : UTF8Type,
    index_name : 'r_rev_num',
    index_type : 0},
    {column_name : 'r_uuid',
    validation_class : UTF8Type,
    index_name : 'r_r_uuid',
    index_type : 0},
    {column_name : 'ar_uuid',
    validation_class : UTF8Type,
    index_name : 'r_ar_uuid',
    index_type : 0},
    {column_name : 'base_url',
    validation_class : UTF8Type,
    index_name : 'r_base_url',
    index_type : 0},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'r_org_name',
    index_type : 0},
    {column_name : 'res_path',
    validation_class : UTF8Type,
    index_name : 'r_res_path',
    index_type : 0},
    {column_name : 'm_time',
    validation_class : UTF8Type},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 'res_name',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family revision_counters
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'CounterColumnType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 1.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'ALL'
  and column_metadata = [
    {column_name : 'r_cnt',
    validation_class : CounterColumnType}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family template
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'ALL'
  and column_metadata = [
    {column_name : 'entity',
    validation_class : UTF8Type,
    index_name : 'template_entity',
    index_type : 0},
    {column_name : 'api_name',
    validation_class : UTF8Type,
    index_name : 't_api_name',
    index_type : 0},
    {column_name : 'revision',
    validation_class : UTF8Type,
    index_name : 'template_revision',
    index_type : 0},
    {column_name : 'template_uuid',
    validation_class : UTF8Type,
    index_name : 'template_uuid',
    index_type : 0},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'template_org_name',
    index_type : 0},
    {column_name : 'org_uuid',
    validation_class : UTF8Type,
    index_name : 'template_org_uuid',
    index_type : 0},
    {column_name : 'template_name',
    validation_class : UTF8Type,
    index_name : 'template_name',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family template_counters
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'CounterColumnType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 1.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'ALL'
  and column_metadata = [
    {column_name : 't_cnt',
    validation_class : CounterColumnType}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace apimodel
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-1 : 3}
  and durable_writes = true;

use apimodel;

create column family apis
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'm_by',
    validation_class : UTF8Type},
    {column_name : 'd_name',
    validation_class : UTF8Type},
    {column_name : 'a_def_index_template',
    validation_class : UTF8Type},
    {column_name : 'desc',
    validation_class : UTF8Type},
    {column_name : 'a_def_method_template',
    validation_class : UTF8Type},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'a_org_name',
    index_type : 0},
    {column_name : 'c_time',
    validation_class : LongType},
    {column_name : 'c_by',
    validation_class : UTF8Type},
    {column_name : 'a_latest_rev',
    validation_class : Int32Type},
    {column_name : 'm_time',
    validation_class : LongType},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 'a_name',
    index_type : 0},
    {column_name : 'a_active_rev',
    validation_class : Int32Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family apis_revision
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'a_name',
    validation_class : UTF8Type,
    index_name : 'ar_a_name',
    index_type : 0},
    {column_name : 'd_name',
    validation_class : UTF8Type},
    {column_name : 'a_uuid',
    validation_class : UUIDType,
    index_name : 'ar_a_uuid',
    index_type : 0},
    {column_name : 'desc',
    validation_class : UTF8Type},
    {column_name : 'c_time',
    validation_class : LongType},
    {column_name : 'c_by',
    validation_class : UTF8Type},
    {column_name : 'change_log',
    validation_class : UTF8Type},
    {column_name : 'api_schema',
    validation_class : UTF8Type},
    {column_name : 'is_latest',
    validation_class : BooleanType,
    index_name : 'ar_is_latest',
    index_type : 0},
    {column_name : 'is_active',
    validation_class : BooleanType,
    index_name : 'ar_is_active',
    index_type : 0},
    {column_name : 'm_by',
    validation_class : UTF8Type},
    {column_name : 'rel_ver',
    validation_class : UTF8Type,
    index_name : 'ar_rel_ver',
    index_type : 0},
    {column_name : 'params',
    validation_class : UTF8Type},
    {column_name : 'param_groups',
    validation_class : UTF8Type},
    {column_name : 'rev_num',
    validation_class : Int32Type,
    index_name : 'ar_rev_num',
    index_type : 0},
    {column_name : 'base_url',
    validation_class : UTF8Type,
    index_name : 'ar_base_url',
    index_type : 0},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'ar_org_name',
    index_type : 0},
    {column_name : 'm_time',
    validation_class : LongType}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family credentials
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'oauth.request_token_verb',
    validation_class : UTF8Type},
    {column_name : 'oauth.request_token_url',
    validation_class : UTF8Type},
    {column_name : 'oauth.access_token_url',
    validation_class : UTF8Type},
    {column_name : 'oauth.access_token_param_name',
    validation_class : UTF8Type},
    {column_name : 'oauth.client_secret',
    validation_class : UTF8Type},
    {column_name : 'oauth.client_id',
    validation_class : UTF8Type},
    {column_name : 'oauth.authorization_verb',
    validation_class : UTF8Type},
    {column_name : 'custom.token_type',
    validation_class : UTF8Type},
    {column_name : 'oauth.client_auth_scheme',
    validation_class : UTF8Type},
    {column_name : 'custom.token_map',
    validation_class : UTF8Type},
    {column_name : 'oauth.authorization_url',
    validation_class : UTF8Type},
    {column_name : 'oauth.access_token_type',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family method
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'a_name',
    validation_class : UTF8Type,
    index_name : 'm_a_name',
    index_type : 0},
    {column_name : 'd_name',
    validation_class : UTF8Type},
    {column_name : 'a_uuid',
    validation_class : UUIDType,
    index_name : 'm_api_uuid',
    index_type : 0},
    {column_name : 'desc',
    validation_class : UTF8Type},
    {column_name : 'c_time',
    validation_class : LongType},
    {column_name : 'c_by',
    validation_class : UTF8Type},
    {column_name : 'verb',
    validation_class : UTF8Type,
    index_name : 'm_verb',
    index_type : 0},
    {column_name : 'm_by',
    validation_class : UTF8Type},
    {column_name : 'params',
    validation_class : UTF8Type},
    {column_name : 'param_groups',
    validation_class : UTF8Type},
    {column_name : 'rev_num',
    validation_class : Int32Type,
    index_name : 'm_rev_num',
    index_type : 0},
    {column_name : 'r_uuid',
    validation_class : UUIDType,
    index_name : 'm_r_uuid',
    index_type : 0},
    {column_name : 'ar_uuid',
    validation_class : UUIDType,
    index_name : 'm_ar_uuid',
    index_type : 0},
    {column_name : 'base_url',
    validation_class : UTF8Type,
    index_name : 'm_base_url',
    index_type : 0},
    {column_name : 'r_name',
    validation_class : UTF8Type,
    index_name : 'm_r_name',
    index_type : 0},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'm_org_name',
    index_type : 0},
    {column_name : 'response',
    validation_class : UTF8Type},
    {column_name : 'samples',
    validation_class : UTF8Type},
    {column_name : 'res_path',
    validation_class : UTF8Type,
    index_name : 'm_res_path',
    index_type : 0},
    {column_name : 'authschemes',
    validation_class : UTF8Type},
    {column_name : 'm_time',
    validation_class : LongType},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 'm_name',
    index_type : 0},
    {column_name : 'body',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family resource
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'a_name',
    validation_class : UTF8Type,
    index_name : 'r_a_name',
    index_type : 0},
    {column_name : 'd_name',
    validation_class : UTF8Type},
    {column_name : 'a_uuid',
    validation_class : UUIDType,
    index_name : 'r_api_uuid',
    index_type : 0},
    {column_name : 'desc',
    validation_class : UTF8Type},
    {column_name : 'c_time',
    validation_class : LongType},
    {column_name : 'c_by',
    validation_class : UTF8Type},
    {column_name : 'm_by',
    validation_class : UTF8Type},
    {column_name : 'params',
    validation_class : UTF8Type},
    {column_name : 'param_groups',
    validation_class : UTF8Type},
    {column_name : 'rev_num',
    validation_class : Int32Type,
    index_name : 'r_rev_num',
    index_type : 0},
    {column_name : 'ar_uuid',
    validation_class : UUIDType,
    index_name : 'r_ar_uuid',
    index_type : 0},
    {column_name : 'base_url',
    validation_class : UTF8Type,
    index_name : 'r_base_url',
    index_type : 0},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 'r_org_name',
    index_type : 0},
    {column_name : 'res_path',
    validation_class : UTF8Type,
    index_name : 'r_res_path',
    index_type : 0},
    {column_name : 'm_time',
    validation_class : LongType},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 'r_name',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family revision_counters
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'CounterColumnType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'r_cnt',
    validation_class : CounterColumnType}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family template
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'a_name',
    validation_class : UTF8Type,
    index_name : 't_a_name',
    index_type : 0},
    {column_name : 'entity',
    validation_class : UTF8Type,
    index_name : 't_entity',
    index_type : 0},
    {column_name : 'a_uuid',
    validation_class : UUIDType,
    index_name : 't_a_uuid',
    index_type : 0},
    {column_name : 'org_name',
    validation_class : UTF8Type,
    index_name : 't_org_name',
    index_type : 0},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 't_name',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family template_counters
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'CounterColumnType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 't_cnt',
    validation_class : CounterColumnType}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace apprepo
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use apprepo;

create column family api_proxy_revisions_r21
  with column_type = 'Standard'
  and comparator = 'DynamicCompositeType(s=>org.apache.cassandra.db.marshal.UTF8Type)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family apiproxies
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family apiproxy_revisions
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family environments
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'environments_organization_name_idx',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family organizations
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace aries
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use aries;

create column family job
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'start_time',
    validation_class : LongType},
    {column_name : 'cron_pattern',
    validation_class : UTF8Type},
    {column_name : 'last_completion_time',
    validation_class : LongType},
    {column_name : 'env',
    validation_class : UTF8Type},
    {column_name : 'retries',
    validation_class : LongType},
    {column_name : 'org',
    validation_class : UTF8Type},
    {column_name : 'job_template',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family jobExecution
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family jobInstance
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'start_time',
    validation_class : LongType},
    {column_name : 'completion_time',
    validation_class : LongType},
    {column_name : 'status',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family jobInstancePerJob
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family jobInstancePerOrgEnv
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family jobPerOrgEnv
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family jobTemplate
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'creation_time',
    validation_class : LongType},
    {column_name : 'class_name',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace audit
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use audit;

create column family audits
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'requesturi',
    validation_class : UTF8Type,
    index_name : 'audits_requesturi_idx',
    index_type : 0},
    {column_name : 'id',
    validation_class : UTF8Type},
    {column_name : 'type',
    validation_class : UTF8Type},
    {column_name : 'request',
    validation_class : UTF8Type},
    {column_name : 'responsecode',
    validation_class : UTF8Type,
    index_name : 'audits_responsecode_idx',
    index_type : 0},
    {column_name : 'response',
    validation_class : UTF8Type},
    {column_name : 'timestamp',
    validation_class : LongType,
    index_name : 'audits_timestamp_idx',
    index_type : 0},
    {column_name : 'user',
    validation_class : UTF8Type,
    index_name : 'audits_user_idx',
    index_type : 0},
    {column_name : 'operation',
    validation_class : UTF8Type,
    index_name : 'audits_operation_idx',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family audits_ref
  with column_type = 'Standard'
  and comparator = 'DynamicCompositeType(s=>org.apache.cassandra.db.marshal.UTF8Type,l=>org.apache.cassandra.db.marshal.LongType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace ax_custom_report_model
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use ax_custom_report_model;

create column family org_metadata
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'currentUpperBound',
    validation_class : LongType},
    {column_name : 'firstReportTime',
    validation_class : LongType}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family org_report_lookup
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family report_created_view
  with column_type = 'Standard'
  and comparator = 'ReversedType(org.apache.cassandra.db.marshal.LongType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family report_description
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family report_id_lookup
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family report_viewed_view
  with column_type = 'Standard'
  and comparator = 'ReversedType(org.apache.cassandra.db.marshal.LongType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace cache
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use cache;

create column family cache_entries
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'uncompressed_size',
    validation_class : LongType},
    {column_name : 'cache_name',
    validation_class : UTF8Type,
    index_name : 'cache_entries_cache_name_idx',
    index_type : 0},
    {column_name : 'is_compressed',
    validation_class : UTF8Type},
    {column_name : 'expires_in',
    validation_class : LongType},
    {column_name : 'added_at',
    validation_class : LongType},
    {column_name : 'cache_value',
    validation_class : BytesType}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family cache_sequence_id_r24
  with column_type = 'Standard'
  and comparator = 'ReversedType(org.apache.cassandra.db.marshal.LongType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace counter
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use counter;

create column family counters
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'CounterColumnType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'used_tokens',
    validation_class : CounterColumnType}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family counters_current_version
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'expires_at',
    validation_class : LongType},
    {column_name : 'version',
    validation_class : LongType}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family counters_with_expiry
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family gateway_quota
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'starttime',
    validation_class : LongType}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family key_timestamp_count
  with column_type = 'Standard'
  and comparator = 'CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.LongType),org.apache.cassandra.db.marshal.UTF8Type)'
  and default_validation_class = 'CounterColumnType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family period_timestamp
  with column_type = 'Standard'
  and comparator = 'ReversedType(org.apache.cassandra.db.marshal.LongType)'
  and default_validation_class = 'BooleanType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family timestamp_key
  with column_type = 'Standard'
  and comparator = 'CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)'
  and default_validation_class = 'BooleanType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace devconnect
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use devconnect;

create column family companies
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'lastmodified_at',
    validation_class : LongType},
    {column_name : 'display_name',
    validation_class : UTF8Type},
    {column_name : 'created_by',
    validation_class : UTF8Type},
    {column_name : 'created_at',
    validation_class : LongType},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'companies_organization_name_idx',
    index_type : 0},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 'companies_name_idx',
    index_type : 0},
    {column_name : 'lastmodified_by',
    validation_class : UTF8Type},
    {column_name : 'status',
    validation_class : UTF8Type,
    index_name : 'companies_status_idx',
    index_type : 0},
    {column_name : 'attributes',
    validation_class : UTF8Type},
    {column_name : 'apps',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family company_developers
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'role',
    validation_class : UTF8Type},
    {column_name : 'company_name',
    validation_class : UTF8Type,
    index_name : 'company_developers_company_name_idx',
    index_type : 0},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'company_developers_organization_name_idx',
    index_type : 0},
    {column_name : 'developer_email',
    validation_class : UTF8Type,
    index_name : 'company_developers_developer_email_idx',
    index_type : 0}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family developers
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'created_by',
    validation_class : UTF8Type},
    {column_name : 'email',
    validation_class : UTF8Type,
    index_name : 'developers_email_idx',
    index_type : 0},
    {column_name : 'lastmodified_by',
    validation_class : UTF8Type},
    {column_name : 'password',
    validation_class : UTF8Type},
    {column_name : 'salt',
    validation_class : UTF8Type},
    {column_name : 'apps',
    validation_class : UTF8Type},
    {column_name : 'encrypted_password',
    validation_class : UTF8Type},
    {column_name : 'created_at',
    validation_class : LongType},
    {column_name : 'first_name',
    validation_class : UTF8Type},
    {column_name : 'lastmodified_at',
    validation_class : LongType},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'developers_organization_name_idx',
    index_type : 0},
    {column_name : 'user_name',
    validation_class : UTF8Type},
    {column_name : 'last_name',
    validation_class : UTF8Type},
    {column_name : 'status',
    validation_class : UTF8Type,
    index_name : 'developers_status_idx',
    index_type : 0},
    {column_name : 'attributes',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace keyvaluemap
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use keyvaluemap;

create column family keyvaluemaps_r21
  with column_type = 'Standard'
  and comparator = 'DynamicCompositeType(s=>org.apache.cassandra.db.marshal.UTF8Type)'
  and default_validation_class = 'UTF8Type'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace kms
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {dc-2 : 3, dc-1 : 3}
  and durable_writes = true;

use kms;

create column family api_products
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'quota_time_unit',
    validation_class : UTF8Type},
    {column_name : 'created_by',
    validation_class : UTF8Type},
    {column_name : 'proxies',
    validation_class : UTF8Type},
    {column_name : 'environments',
    validation_class : UTF8Type},
    {column_name : 'quota_interval',
    validation_class : UTF8Type},
    {column_name : 'lastmodified_by',
    validation_class : UTF8Type},
    {column_name : 'created_at',
    validation_class : LongType},
    {column_name : 'display_name',
    validation_class : UTF8Type},
    {column_name : 'lastmodified_at',
    validation_class : LongType},
    {column_name : 'quota',
    validation_class : UTF8Type},
    {column_name : 'api_resources',
    validation_class : UTF8Type},
    {column_name : 'description',
    validation_class : UTF8Type},
    {column_name : 'approval_type',
    validation_class : UTF8Type},
    {column_name : 'scopes',
    validation_class : UTF8Type},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'api_products_organization_name_idx',
    index_type : 0},
    {column_name : 'name',
    validation_class : UTF8Type},
    {column_name : 'attributes',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family api_resources
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'api_products',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family apiproducts_appslist
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'keys_count',
    validation_class : UTF8Type},
    {column_name : 'keys',
    validation_class : UTF8Type},
    {column_name : 'apps_count',
    validation_class : UTF8Type},
    {column_name : 'apps',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family app_credentials
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'developer_status',
    validation_class : UTF8Type},
    {column_name : 'expires_at',
    validation_class : LongType},
    {column_name : 'consumer_secret',
    validation_class : UTF8Type},
    {column_name : 'api_products',
    validation_class : UTF8Type,
    index_name : 'app_credentials_api_products_idx',
    index_type : 0},
    {column_name : 'organization_app_id',
    validation_class : UTF8Type,
    index_name : 'app_credentials_organization_app_id_idx',
    index_type : 0},
    {column_name : 'credential_method',
    validation_class : UTF8Type},
    {column_name : 'company_status',
    validation_class : UTF8Type},
    {column_name : 'issued_at',
    validation_class : LongType},
    {column_name : 'scopes',
    validation_class : UTF8Type},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'app_credentials_organization_name_idx',
    index_type : 0},
    {column_name : 'app_status',
    validation_class : UTF8Type},
    {column_name : 'attributes',
    validation_class : UTF8Type},
    {column_name : 'status',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family app_end_user
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'app_id',
    validation_class : UTF8Type,
    index_name : 'app_end_user_app_id_idx',
    index_type : 0},
    {column_name : 'email',
    validation_class : UTF8Type},
    {column_name : 'password',
    validation_class : UTF8Type},
    {column_name : 'attributes',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family apps
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'parent_id',
    validation_class : UTF8Type,
    index_name : 'apps_parent_id_idx',
    index_type : 0},
    {column_name : 'created_by',
    validation_class : UTF8Type},
    {column_name : 'access_type',
    validation_class : UTF8Type},
    {column_name : 'app_family',
    validation_class : UTF8Type,
    index_name : 'apps_app_family_idx',
    index_type : 0},
    {column_name : 'lastmodified_by',
    validation_class : UTF8Type},
    {column_name : 'app_id',
    validation_class : UTF8Type,
    index_name : 'apps_app_id_idx',
    index_type : 0},
    {column_name : 'callback_url',
    validation_class : UTF8Type},
    {column_name : 'created_at',
    validation_class : LongType},
    {column_name : 'display_name',
    validation_class : UTF8Type},
    {column_name : 'lastmodified_at',
    validation_class : LongType},
    {column_name : 'app_type',
    validation_class : UTF8Type,
    index_name : 'apps_app_type_idx',
    index_type : 0},
    {column_name : 'parent_status',
    validation_class : UTF8Type,
    index_name : 'apps_parent_status_idx',
    index_type : 0},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'apps_organization_name_idx',
    index_type : 0},
    {column_name : 'name',
    validation_class : UTF8Type,
    index_name : 'apps_name_idx',
    index_type : 0},
    {column_name : 'status',
    validation_class : UTF8Type,
    index_name : 'apps_status_idx',
    index_type : 0},
    {column_name : 'attributes',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family maps
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'maps_organization_name_idx',
    index_type : 0},
    {column_name : 'name',
    validation_class : UTF8Type},
    {column_name : 'value',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family oauth_10_access_tokens
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'created_by',
    validation_class : UTF8Type},
    {column_name : 'expires_at',
    validation_class : LongType},
    {column_name : 'scope',
    validation_class : UTF8Type},
    {column_name : 'developer_id',
    validation_class : UTF8Type},
    {column_name : 'consumer_secret',
    validation_class : UTF8Type},
    {column_name : 'lastmodified_by',
    validation_class : UTF8Type},
    {column_name : 'isTokensHashed',
    validation_class : UTF8Type},
    {column_name : 'app_id',
    validation_class : UTF8Type,
    index_name : 'oauth_10_access_tokens_app_id_idx',
    index_type : 0},
    {column_name : 'token_secret',
    validation_class : UTF8Type},
    {column_name : 'consumer_key',
    validation_class : UTF8Type,
    index_name : 'oauth_10_access_tokens_consumer_key_idx',
    index_type : 0},
    {column_name : 'created_at',
    validation_class : LongType},
    {column_name : 'lastmodified_at',
    validation_class : LongType},
    {column_name : 'issued_at',
    validation_class : LongType},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'oauth_10_access_tokens_organization_name_idx',
    index_type : 0},
    {column_name : 'app_end_user',
    validation_class : UTF8Type},
    {column_name : 'status',
    validation_class : UTF8Type,
    index_name : 'oauth_10_access_tokens_status_idx',
    index_type : 0},
    {column_name : 'attributes',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family oauth_10_request_tokens
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'created_by',
    validation_class : UTF8Type},
    {column_name : 'expires_at',
    validation_class : LongType},
    {column_name : 'scope',
    validation_class : UTF8Type},
    {column_name : 'lastmodified_by',
    validation_class : UTF8Type},
    {column_name : 'secret',
    validation_class : UTF8Type},
    {column_name : 'consumer_key',
    validation_class : UTF8Type,
    index_name : 'oauth_10_request_tokens_consumer_key_idx',
    index_type : 0},
    {column_name : 'created_at',
    validation_class : LongType},
    {column_name : 'lastmodified_at',
    validation_class : LongType},
    {column_name : 'issued_at',
    validation_class : LongType},
    {column_name : 'callback_uri',
    validation_class : UTF8Type},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'oauth_10_request_tokens_organization_name_idx',
    index_type : 0},
    {column_name : 'attributes',
    validation_class : UTF8Type},
    {column_name : 'status',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family oauth_10_verifiers
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'request_token',
    validation_class : UTF8Type,
    index_name : 'oauth_10_verifiers_request_token_idx',
    index_type : 0},
    {column_name : 'lastmodified_at',
    validation_class : LongType},
    {column_name : 'created_by',
    validation_class : UTF8Type},
    {column_name : 'created_at',
    validation_class : LongType},
    {column_name : 'expires_at',
    validation_class : LongType},
    {column_name : 'issued_at',
    validation_class : LongType},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'oauth_10_verifiers_organization_name_idx',
    index_type : 0},
    {column_name : 'app_end_user',
    validation_class : UTF8Type},
    {column_name : 'lastmodified_by',
    validation_class : UTF8Type},
    {column_name : 'attributes',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family oauth_20_access_tokens
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'refresh_token_issued_at',
    validation_class : LongType},
    {column_name : 'created_by',
    validation_class : UTF8Type},
    {column_name : 'grant_type',
    validation_class : UTF8Type},
    {column_name : 'refresh_token_status',
    validation_class : UTF8Type},
    {column_name : 'redirect_uri',
    validation_class : UTF8Type},
    {column_name : 'expires_at',
    validation_class : LongType},
    {column_name : 'scope',
    validation_class : UTF8Type},
    {column_name : 'developer_id',
    validation_class : UTF8Type},
    {column_name : 'refresh_token',
    validation_class : UTF8Type,
    index_name : 'oauth_20_access_tokens_refresh_token_idx',
    index_type : 0},
    {column_name : 'refresh_count',
    validation_class : UTF8Type},
    {column_name : 'lastmodified_by',
    validation_class : UTF8Type},
    {column_name : 'isTokensHashed',
    validation_class : UTF8Type},
    {column_name : 'app_id',
    validation_class : UTF8Type,
    index_name : 'oauth_20_access_tokens_app_id_idx',
    index_type : 0},
    {column_name : 'token_secret',
    validation_class : UTF8Type},
    {column_name : 'created_at',
    validation_class : LongType},
    {column_name : 'lastmodified_at',
    validation_class : LongType},
    {column_name : 'client_secret',
    validation_class : UTF8Type},
    {column_name : 'refresh_token_expires_at',
    validation_class : LongType},
    {column_name : 'client_id',
    validation_class : UTF8Type,
    index_name : 'oauth_20_access_tokens_client_id_idx',
    index_type : 0},
    {column_name : 'issued_at',
    validation_class : LongType},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'oauth_20_access_tokens_organization_name_idx',
    index_type : 0},
    {column_name : 'app_end_user',
    validation_class : UTF8Type},
    {column_name : 'status',
    validation_class : UTF8Type,
    index_name : 'oauth_20_access_tokens_status_idx',
    index_type : 0},
    {column_name : 'attributes',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family oauth_20_authorization_codes
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'lastmodified_at',
    validation_class : LongType},
    {column_name : 'created_by',
    validation_class : UTF8Type},
    {column_name : 'created_at',
    validation_class : LongType},
    {column_name : 'redirect_uri',
    validation_class : UTF8Type},
    {column_name : 'expires_at',
    validation_class : LongType},
    {column_name : 'scope',
    validation_class : UTF8Type},
    {column_name : 'issued_at',
    validation_class : LongType},
    {column_name : 'client_id',
    validation_class : UTF8Type,
    index_name : 'oauth_20_authorization_codes_client_id_idx',
    index_type : 0},
    {column_name : 'organization_name',
    validation_class : UTF8Type,
    index_name : 'oauth_20_authorization_codes_organization_name_idx',
    index_type : 0},
    {column_name : 'lastmodified_by',
    validation_class : UTF8Type},
    {column_name : 'status',
    validation_class : UTF8Type},
    {column_name : 'attributes',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family organizations
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.1
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and column_metadata = [
    {column_name : 'is_generate_app_key',
    validation_class : UTF8Type},
    {column_name : 'app_attribute_keys',
    validation_class : UTF8Type},
    {column_name : 'display_name',
    validation_class : UTF8Type},
    {column_name : 'approve_developer_bydefault',
    validation_class : UTF8Type},
    {column_name : 'credential_methods',
    validation_class : UTF8Type},
    {column_name : 'name',
    validation_class : UTF8Type},
    {column_name : 'attributes',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace system
  with placement_strategy = 'LocalStrategy'
  and durable_writes = true;

use system;

create column family HintsColumnFamily
  with column_type = 'Super'
  and comparator = 'BytesType'
  and subcomparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 0
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and comment = 'unused';

create column family IndexInfo
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 0
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and bloom_filter_fp_chance = 0.01
  and comment = 'indexes that have been completed'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family LocationInfo
  with column_type = 'Standard'
  and comparator = 'BytesType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 0
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and comment = 'unused';

create column family Migrations
  with column_type = 'Standard'
  and comparator = 'TimeUUIDType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 0
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and comment = 'unused';

create column family NodeIdInfo
  with column_type = 'Standard'
  and comparator = 'TimeUUIDType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 0
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and bloom_filter_fp_chance = 0.01
  and comment = 'counter node IDs'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family Schema
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and read_repair_chance = 0.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 0
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and comment = 'unused';

create column family hints
  with column_type = 'Standard'
  and comparator = 'CompositeType(org.apache.cassandra.db.marshal.TimeUUIDType,org.apache.cassandra.db.marshal.Int32Type)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UUIDType'
  and read_repair_chance = 0.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 0
  and min_compaction_threshold = 0
  and max_compaction_threshold = 0
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and bloom_filter_fp_chance = 0.01
  and compaction_strategy_options = {'max_threshold' : '0', 'min_threshold' : '0'}
  and comment = 'hints awaiting delivery'
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

create column family schema_keyspaces
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'UTF8Type'
  and read_repair_chance = 0.0
  and dclocal_read_repair_chance = 0.0
  and populate_io_cache_on_flush = false
  and gc_grace = 8640
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and caching = 'KEYS_ONLY'
  and bloom_filter_fp_chance = 0.01
  and comment = 'keyspace definitions'
  and column_metadata = [
    {column_name : 'strategy_options',
    validation_class : UTF8Type},
    {column_name : 'durable_writes',
    validation_class : BooleanType},
    {column_name : 'strategy_class',
    validation_class : UTF8Type}]
  and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};



create keyspace system_traces
  with placement_strategy = 'SimpleStrategy'
  and strategy_options = {replication_factor : 2}
  and durable_writes = true;

use system_traces;



[default@unknown]