-- create database idl;
-- use idl;
--

CREATE TABLE taskresults (
userid CHAR(33),
session TINYINT,
task CHAR(10),
bubble_attention_mean REAL,
bubble_attention_std  REAL,
bubble_baseline_mean REAL,
bubble_baseline_std REAL,
alternate_use_answer VARCHAR(1000),
alternate_use_image CHAR(30),
bem_td_diff_log REAL,
bem_td_diff_inv REAL,
jar_count INT,
jar_image CHAR(30),
remote_viewing_hits REAL,
time_estimation REAL,
timestamp TIMESTAMP(6));

CREATE TABLE users (
userid CHAR(33),
birthday CHAR(33),
firstname CHAR(33),
task CHAR(33),
workshop CHAR(33),
session TINYINT
);

ALTER TABLE users
ADD (
timestamp TIMESTAMP(6));

