-- MySQL dump 9.08
--
-- Host: info9    Database: ExperimentsExample
---------------------------------------------------------
-- Server version	4.0.14

--
-- Table structure for table 'experiments'
--

CREATE TABLE experiments (
  ID int NOT NULL,
  name varchar(30) NOT NULL,
  creation varchar(50) default '',
  who varchar(30) NOT NULL default '',
  p int unsigned NOT NULL default '0',
  comment varchar(100) default NULL,
  PRIMARY KEY (ID)
);

--
-- Table structure for table 'measurements'
--

CREATE TABLE measurements (
  experimentID int unsigned NOT NULL default '0',
  variable varchar(30) NOT NULL default '',
  val double NOT NULL default '0',
  PRIMARY KEY (experimentID,variable)
);

--
-- Table structure for table 'users'
--

CREATE TABLE users (
  name varchar(30) NOT NULL default '',
  function varchar(30) NOT NULL default '',
  PRIMARY KEY (name)
);

--
-- Table structure for table 'variables'
--

CREATE TABLE variables (
  name varchar(30) NOT NULL default '',
  isParallel bool default 0,
  explanation varchar(50) NOT NULL default '',
  PRIMARY KEY (name)
);