CQL Commands for a Cassandra based Chat App

c_chat.sh

#!/bin/bash
cqlsh <<CQL
CREATE KEYSPACE chat_app WITH REPLICATION = {'class':'SimpleStrategy', 'replication_factor':1};
USE chat_app;
CREATE TABLE chat_messages (
  message_id uuid,
  from_user text,
  to_user text,
  body text,
  class text,
  time timeuuid,
  PRIMARY KEY ((from_user, to_user), time)
) WITH CLUSTERING ORDER BY (time ASC);
CREATE INDEX chat_messages_to_user ON chat_messages (to_user);
CREATE INDEX chat_messages_class ON chat_messages (class);
CQL