#!/bin/bash

mysql -u lei_user -p -h localhost -P 3306 -D lei -Bse 'CREATE TABLE IF NOT EXISTS `KMTEST2` (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` 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 TEXT, mouse_tracking_targets TEXT, question_order TEXT, feedbackText TEXT, participationCode TEXT, `session` TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);'