#!/bin/bash

mysql -u lei_user -p -h localhost -P 3306 -D lei -Bse "
CREATE TABLE IF NOT EXISTS \`COUNTER_EXP2_TEST\` (
  \`condition\` VARCHAR(128) NOT NULL,
  \`stim_set\` VARCHAR(16) NOT NULL,
  \`count\` FLOAT NOT NULL DEFAULT 0,
  UNIQUE KEY \`uq_condition_stimset\` (\`condition\`, \`stim_set\`)
);

INSERT IGNORE INTO \`COUNTER_EXP2_TEST\` (\`condition\`, \`stim_set\`, \`count\`) VALUES
  ('spectral_match_reference', '00A', 0), ('decaying_noise_matched_spectrum', '00A', 0), ('jittered_impacts', '00A', 0);
  # ('spectral_match_reference', '00A', 0), ('spectral_match_reference', '00B', 0),
  # ('spectral_match_reference', '01A', 0), ('spectral_match_reference', '01B', 0),
  # ('spectral_match_reference', '02A', 0), ('spectral_match_reference', '02B', 0),
  # ('spectral_match_reference', '03A', 0), ('spectral_match_reference', '03B', 0),
  # ('spectral_match_reference', '04A', 0), ('spectral_match_reference', '04B', 0),
  # ('spectral_match_reference', '05A', 0), ('spectral_match_reference', '05B', 0),
  # ('spectral_match_reference', '06A', 0), ('spectral_match_reference', '06B', 0),
  # ('spectral_match_reference', '07A', 0), ('spectral_match_reference', '07B', 0),
  # ('spectral_match_reference', '08A', 0), ('spectral_match_reference', '08B', 0),
  # ('spectral_match_reference', '09A', 0), ('spectral_match_reference', '09B', 0),

  # ('decaying_noise_matched_spectrum', '00A', 0), ('decaying_noise_matched_spectrum', '00B', 0),
  # ('decaying_noise_matched_spectrum', '01A', 0), ('decaying_noise_matched_spectrum', '01B', 0),
  # ('decaying_noise_matched_spectrum', '02A', 0), ('decaying_noise_matched_spectrum', '02B', 0),
  # ('decaying_noise_matched_spectrum', '03A', 0), ('decaying_noise_matched_spectrum', '03B', 0),
  # ('decaying_noise_matched_spectrum', '04A', 0), ('decaying_noise_matched_spectrum', '04B', 0),
  # ('decaying_noise_matched_spectrum', '05A', 0), ('decaying_noise_matched_spectrum', '05B', 0),
  # ('decaying_noise_matched_spectrum', '06A', 0), ('decaying_noise_matched_spectrum', '06B', 0),
  # ('decaying_noise_matched_spectrum', '07A', 0), ('decaying_noise_matched_spectrum', '07B', 0),
  # ('decaying_noise_matched_spectrum', '08A', 0), ('decaying_noise_matched_spectrum', '08B', 0),
  # ('decaying_noise_matched_spectrum', '09A', 0), ('decaying_noise_matched_spectrum', '09B', 0),

  # ('jittered_impacts', '00A', 0), ('jittered_impacts', '00B', 0),
  # ('jittered_impacts', '01A', 0), ('jittered_impacts', '01B', 0),
  # ('jittered_impacts', '02A', 0), ('jittered_impacts', '02B', 0),
  # ('jittered_impacts', '03A', 0), ('jittered_impacts', '03B', 0),
  # ('jittered_impacts', '04A', 0), ('jittered_impacts', '04B', 0),
  # ('jittered_impacts', '05A', 0), ('jittered_impacts', '05B', 0),
  # ('jittered_impacts', '06A', 0), ('jittered_impacts', '06B', 0),
  # ('jittered_impacts', '07A', 0), ('jittered_impacts', '07B', 0),
  # ('jittered_impacts', '08A', 0), ('jittered_impacts', '08B', 0),
  # ('jittered_impacts', '09A', 0), ('jittered_impacts', '09B', 0);
"