-- MySQL dump 10.10
--
-- Host: xdaq    Database: primex_online
-- ------------------------------------------------------
-- Server version	5.0.1-alpha-standard


--
-- Table structure for table `Run_Files`
--

DROP TABLE IF EXISTS `Run_Files`;
CREATE TABLE `Run_Files` (
  `Id` int(11) NOT NULL auto_increment,
  `Run_Number` int(10) unsigned NOT NULL default '0',
  `Time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `File_Name` varchar(255) default NULL,
  `Number_of_Events` int(10) unsigned default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `RunID`
--

DROP TABLE IF EXISTS `RunID`;
CREATE TABLE `RunID` (
  `Run_Number` int(10) unsigned NOT NULL default '0',
  `Run_Type` varchar(255) NOT NULL default 'unknown',
  `Run_Status` enum('IN PROGRESS','GOOD','IGNORE','UNKNOWN') default NULL,
  `Run_Comment` varchar(255) default NULL,
  `Operators` varchar(255) default NULL,
  `Trigger_Configuration` blob default NULL,
  `Beam_Current_requested` float default NULL,
  `Radiator` enum('OUT','A','B','C','D','undefined') default NULL,
  `Converter` enum('OUT','-4','-3','-2','undefined') default NULL,
  `Begin_Run_Time` datetime default NULL,
  `End_Run_Time` datetime default NULL,
  `Total_Number_of_Events` int(10) unsigned default NULL,
  PRIMARY KEY  (`Run_Number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `Beam`
--

DROP TABLE IF EXISTS `Beam`;
CREATE TABLE `Beam` (
  `Id` int(11) NOT NULL auto_increment,
  `Run_Number` int(10) unsigned NOT NULL default '0',
  `Time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Beam_Energy` float default NULL,
  `BPM2C21I` float default NULL,
  `BPM2C21X` float default NULL,
  `BPM2C21Y` float default NULL,
  `BPM2C24I` float default NULL,
  `BPM2C24X` float default NULL,
  `BPM2C24Y` float default NULL,
  `gp_mean_x` float default NULL,
  `gp_mean_y` float default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;