#!/bin/bash

mysql -u kmoore12 -p -D lei -Bse '
CREATE TABLE IF NOT EXISTS `EXP1_SONA` (
  trial_type TEXT,
  trial_index FLOAT,
  time_elapsed FLOAT,
  internal_node_id TEXT,
  subject_id TEXT,
  study_id TEXT,
  session_id TEXT,
  exp_version TEXT,
  condition_type TEXT,
  `condition` TEXT,
  view_history TEXT,
  rt FLOAT,
  stimulus TEXT,
  response TEXT,
  `key` FLOAT,
  task TEXT,
  correct FLOAT,
  hp_accuracy FLOAT,
  didPassHeadphoneCheck FLOAT,
  url TEXT,
  success FLOAT,
  timeout FLOAT,
  failed_images TEXT,
  failed_audio TEXT,
  failed_video TEXT,
  stim_set TEXT,
  mouse_tracking_data LONGTEXT,
  mouse_tracking_targets TEXT,
  question_order TEXT,
  feedbackText TEXT,
  participationCode TEXT,
  `session` TEXT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);'