docker pull cassandra:latest

docker run -d -p9042:9042 --name cass_cluster cassandra:latest

docker exec -it cass_cluster cqlsh

create keyspace bezkoder with replication={'class':'SimpleStrategy', 'replication_factor':1};

use bezkoder;
 
CREATE TABLE monopoly(
   id uuid PRIMARY KEY,
   pot int,
   gameover boolean
); 
 
CREATE TABLE entrepreneur(
   id uuid PRIMARY KEY,
   name text,
   tokentype text,
   funds int,
   monopolyid uuid,
   squareid int,
   human boolean,
   message text
);

CREATE INDEX monopoly_idx ON entrepreneur ( monopolyid );

CREATE TABLE property(
   monopolyid uuid,
   squareid int,
   entrepreneurid uuid,
   ownedType text,
   PRIMARY KEY((monopolyid), squareid)
);

CREATE INDEX entrepreneur_idx ON property ( entrepreneurid );