--------------------------------------------------
-- New tables for SU24 analysis
-- Created 20100629
--------------------------------------------------

CREATE TABLE IF NOT EXISTS `analysis_usobt` (
  `uuid` char(32) NOT NULL,
  `field` varchar(10) NOT NULL,
  `low` varchar(40) NOT NULL,
  `high` varchar(40) default NULL,
  PRIMARY KEY  (`uuid`,`field`,`low`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `analysis_usobx` (
  `uuid` char(32) NOT NULL,
  `flag` char(1) NOT NULL,
  PRIMARY KEY  (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
