text: CREATE KEYSPACE IF NOT EXISTS morphl WITH REPLICATION = {'class': 'SimpleStrategy', 'replication_factor': 1};
  
  CREATE TABLE morphl.ga_chp_users (
    client_id text,
    day_of_data_capture date,
    json_meta text,
    json_data text,
    PRIMARY KEY ((client_id), day_of_data_capture)
  ) WITH CLUSTERING ORDER BY (day_of_data_capture DESC);
  
  CREATE TABLE morphl.ga_chp_sessions (
    client_id text,
    day_of_data_capture date,
    session_id text,
    json_meta text,
    json_data text,
    PRIMARY KEY ((client_id), day_of_data_capture, session_id)
  ) WITH CLUSTERING ORDER BY (day_of_data_capture DESC);
  
  CREATE TABLE morphl.ga_chp_features_raw_t (
    client_id text,
    day_of_data_capture date,
    session_id text,
    session_count double,
    days_since_last_session double,
    s_sessions double,
    pageviews double,
    unique_pageviews double,
    screen_views double,
    hits double,
    time_on_page double,
    u_sessions double,
    session_duration double,
    entrances double,
    bounces double,
    exits double,
    page_value double,
    page_load_time double,
    page_load_sample double,
    is_desktop double,
    is_mobile double,
    is_tablet double,
    PRIMARY KEY ((client_id), day_of_data_capture, session_id)
  ) WITH CLUSTERING ORDER BY (day_of_data_capture DESC);
  
  CREATE TABLE morphl.ga_chp_features_raw_p (
    client_id text,
    day_of_data_capture date,
    session_id text,
    session_count double,
    days_since_last_session double,
    s_sessions double,
    pageviews double,
    unique_pageviews double,
    screen_views double,
    hits double,
    time_on_page double,
    u_sessions double,
    session_duration double,
    entrances double,
    bounces double,
    exits double,
    page_value double,
    page_load_time double,
    page_load_sample double,
    is_desktop double,
    is_mobile double,
    is_tablet double,
    PRIMARY KEY ((client_id), day_of_data_capture, session_id)
  ) WITH CLUSTERING ORDER BY (day_of_data_capture DESC);
  
  CREATE TABLE morphl.ga_chp_features_training (
    client_id text,
    pageviews double,
    unique_pageviews double,
    hits double,
    time_on_page double,
    u_sessions double,
    session_duration double,
    entrances double,
    bounces double,
    exits double,
    session_count double,
    is_desktop double,
    is_mobile double,
    is_tablet double,
    churned double,
    PRIMARY KEY ((client_id))
  );
  
  CREATE TABLE morphl.ga_chp_features_prediction (
    client_id text,
    pageviews double,
    unique_pageviews double,
    hits double,
    time_on_page double,
    u_sessions double,
    session_duration double,
    entrances double,
    bounces double,
    exits double,
    session_count double,
    is_desktop double,
    is_mobile double,
    is_tablet double,
    PRIMARY KEY ((client_id))
  );
  
  CREATE TABLE morphl.ga_chp_predictions (
    client_id text,
    prediction double,
    PRIMARY KEY ((client_id))
  );
  
  CREATE TABLE morphl.ga_chp_predictions_by_prediction_date (
    prediction_date date,
    client_id text, 
    prediction double,
    PRIMARY KEY ((prediction_date), client_id)
  );
  
  CREATE TABLE morphl.ga_chp_predictions_statistics (
    prediction_date date, 
    loyal double,
    neutral double,
    churning double,
    lost double,
    PRIMARY KEY ((prediction_date))
  );
  
  CREATE TABLE morphl.ga_chp_predictions_access_logs (
    client_id text,
    tstamp timestamp,
    prediction double,
    PRIMARY KEY ((client_id), tstamp)
  ) WITH CLUSTERING ORDER BY (tstamp DESC);
  
  CREATE TABLE morphl.ga_chp_valid_models (
    always_zero int,
    day_as_str text,
    tstamp timestamp,
    unique_hash text,
    threshold double,
    accuracy double,
    loss double,
    is_model_valid boolean,
    PRIMARY KEY ((always_zero), day_as_str, tstamp, unique_hash)
  ) WITH CLUSTERING ORDER BY (day_as_str DESC, tstamp DESC);
  
  CREATE TABLE morphl.ga_chp_config_parameters (
    morphl_component_name text,
    parameter_name text,
    parameter_value text,
    PRIMARY KEY ((morphl_component_name, parameter_name))
  );
  
  INSERT INTO morphl.ga_chp_config_parameters (morphl_component_name,parameter_name,parameter_value)
  VALUES ('ga_chp','days_worth_of_data_to_load','60');
  
  