text: CREATE KEYSPACE system WITH replication = {'class': 'LocalStrategy'} AND durable_writes = true;
  
  CREATE TABLE system."HintsColumnFamily" (
    "key" blob,
    "column1" blob,
    value blob,
    PRIMARY KEY ("key", "column1")
  )
  WITH COMPACT STORAGE
   AND bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'unused'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system."IndexInfo" (
    table_name text,
    index_name text,
    PRIMARY KEY (table_name, index_name)
  )
  WITH COMPACT STORAGE
   AND bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'indexes that have been completed'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system."LocationInfo" (
    "key" blob,
    "column1" blob,
    value blob,
    PRIMARY KEY ("key", "column1")
  )
  WITH COMPACT STORAGE
   AND bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'unused'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system."Migrations" (
    "key" blob,
    "column1" timeuuid,
    value blob,
    PRIMARY KEY ("key", "column1")
  )
  WITH COMPACT STORAGE
   AND bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'unused'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system."NodeIdInfo" (
    "key" text,
    id timeuuid,
    PRIMARY KEY ("key", id)
  )
  WITH COMPACT STORAGE
   AND bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'counter node IDs'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system."Schema" (
    "key" blob,
    "column1" text,
    value blob,
    PRIMARY KEY ("key", "column1")
  )
  WITH COMPACT STORAGE
   AND bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'unused'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system.batchlog (
    id uuid PRIMARY KEY,
    data blob,
    written_at timestamp
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'uncommited batches'
   AND compaction = {'class': 'SizeTieredCompactionStrategy', 'min_threshold': '2'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system.hints (
    target_id uuid,
    hint_id timeuuid,
    message_version int,
    mutation blob,
    PRIMARY KEY (target_id, hint_id, message_version)
  )
  WITH COMPACT STORAGE
   AND bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'hints awaiting delivery'
   AND compaction = {'class': 'SizeTieredCompactionStrategy', 'min_threshold': '0', 'max_threshold': '0'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system.local (
    "key" text PRIMARY KEY,
    bootstrapped text,
    cluster_name text,
    cql_version text,
    data_center text,
    gossip_generation int,
    host_id uuid,
    partitioner text,
    rack text,
    release_version text,
    schema_version uuid,
    thrift_version text,
    tokens set<text>,
    truncated_at map<uuid, blob>
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'information about the local node'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system.peer_events (
    peer inet PRIMARY KEY,
    hints_dropped map<uuid, int>
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'cf contains events related to peers'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system.peers (
    peer inet PRIMARY KEY,
    data_center text,
    host_id uuid,
    rack text,
    release_version text,
    rpc_address inet,
    schema_version uuid,
    tokens set<text>
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'known peers in the cluster'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system.range_xfers (
    token_bytes blob PRIMARY KEY,
    requested_at timestamp
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'ranges requested for transfer here'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system.schema_columnfamilies (
    keyspace_name text,
    columnfamily_name text,
    bloom_filter_fp_chance double,
    caching text,
    column_aliases text,
    comment text,
    compaction_strategy_class text,
    compaction_strategy_options text,
    comparator text,
    compression_parameters text,
    default_validator text,
    gc_grace_seconds int,
    id int,
    key_alias text,
    key_aliases text,
    key_validator text,
    local_read_repair_chance double,
    max_compaction_threshold int,
    min_compaction_threshold int,
    populate_io_cache_on_flush boolean,
    read_repair_chance double,
    replicate_on_write boolean,
    subcomparator text,
    "type" text,
    value_alias text,
    PRIMARY KEY (keyspace_name, columnfamily_name)
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'ColumnFamily definitions'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 604800
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system.schema_columns (
    keyspace_name text,
    columnfamily_name text,
    column_name text,
    component_index int,
    index_name text,
    index_options text,
    index_type text,
    validator text,
    PRIMARY KEY (keyspace_name, columnfamily_name, column_name)
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'ColumnFamily column attributes'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 604800
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system.schema_keyspaces (
    keyspace_name text PRIMARY KEY,
    durable_writes boolean,
    strategy_class text,
    strategy_options text
  )
  WITH COMPACT STORAGE
   AND bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'keyspace definitions'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 604800
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE KEYSPACE system_traces WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '2'} AND durable_writes = true;
  
  CREATE TABLE system_traces.events (
    session_id uuid,
    event_id timeuuid,
    activity text,
    source inet,
    source_elapsed int,
    thread text,
    PRIMARY KEY (session_id, event_id)
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = ''
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE TABLE system_traces.sessions (
    session_id uuid PRIMARY KEY,
    coordinator inet,
    duration int,
    parameters map<text, text>,
    request text,
    started_at timestamp
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'traced sessions'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'SnappyCompressor'}
   AND dclocal_read_repair_chance = 0.0
   AND gc_grace_seconds = 0
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.0
   AND replicate_on_write = 'true';
  
  CREATE KEYSPACE simplex WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true;
  
  CREATE TABLE simplex."t1" (
    "f1" int,
    "f2" int,
    "f3" int,
    PRIMARY KEY ("f1", "f2")
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'test table'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'LZ4Compressor'}
   AND dclocal_read_repair_chance = 0.1
   AND gc_grace_seconds = 2
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.1
   AND replicate_on_write = 'true';
  
  CREATE INDEX "ind1" ON simplex."t1" ("f3");
  
  CREATE TABLE simplex."t2" (
    "f1" int,
    "f2" int,
    "f3" int,
    PRIMARY KEY ("f1", "f2")
  )
  WITH CLUSTERING ORDER BY ("f2" DESC)
   AND COMPACT STORAGE
   AND bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'compact test table'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'LZ4Compressor'}
   AND dclocal_read_repair_chance = 0.1
   AND gc_grace_seconds = 2
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.1
   AND replicate_on_write = 'true';
  
  CREATE TABLE simplex."t3" (
    "f1" int PRIMARY KEY,
    "f2" int
  )
  WITH bloom_filter_fp_chance = 0.01
   AND caching = 'KEYS_ONLY'
   AND comment = 'test table one column key'
   AND compaction = {'class': 'SizeTieredCompactionStrategy'}
   AND compression = {'sstable_compression': 'LZ4Compressor'}
   AND dclocal_read_repair_chance = 0.1
   AND gc_grace_seconds = 2
   AND populate_io_cache_on_flush = 'false'
   AND read_repair_chance = 0.1
   AND replicate_on_write = 'true';
  