db create script

db.cql

create keyspace if not exists honestdollar with replication = {'class': 'SimpleStrategy', 'replication_factor': 1} ;

use honestdollar ;

create table if not exists users (
  id uuid,
  firstname text,
  lastname text,
  email text,
  phone text,
  primary key (id, lastname)) ;

create table if not exists user_from_email (
  email text,
  id uuid, 
  firstname text,
  lastname text,
  primary key (email, id)) ;

create table if not exists user_from_phone (
  phone text, 
  id uuid,
  firstname text,
  lastname text,
  primary key (phone, id)) ;

exit ;