#!/bin/bash

mysql -u kmoore12 -p -D lei -Bse "
CREATE TABLE IF NOT EXISTS \`COUNTER_EXP1_SONA\` (
  \`stim_set\` VARCHAR(16) NOT NULL,
  \`count\` FLOAT NOT NULL DEFAULT 0,
  UNIQUE KEY \`uq_stimset\` (\`stim_set\`)
);

INSERT IGNORE INTO \`COUNTER_EXP1_SONA\` (\`stim_set\`, \`count\`) VALUES
  ('00A', 0), ('00B', 0),
  ('01A', 0), ('01B', 0),
  ('02A', 0), ('02B', 0),
  ('03A', 0), ('03B', 0),
  ('04A', 0), ('04B', 0),
  ('05A', 0), ('05B', 0),
  ('06A', 0), ('06B', 0),
  ('07A', 0), ('07B', 0),
  ('08A', 0), ('08B', 0),
  ('09A', 0), ('09B', 0);
"