#
# mSQL Dump  (requires mSQL 2.0 Beta 5 or newer)
#
# Host: 134.184.1.73    Database: experiments_example
#--------------------------------------------------------


#
# Table structure for table 'users'
#
CREATE TABLE users (
  name CHAR(30) NOT NULL,
  function CHAR(30) NOT NULL
) \g

CREATE UNIQUE  INDEX id ON users (
	name
) \g


#
# Dumping data for table 'users'
#


#
# Table structure for table 'variables'
#
CREATE TABLE variables (
  name CHAR(30) NOT NULL,
  isParallel CHAR(1),
  explanation CHAR(50) NOT NULL
) \g

CREATE UNIQUE  INDEX id ON variables (
	name
) \g


#
# Dumping data for table 'variables'
#


#
# Table structure for table 'measurements'
#
CREATE TABLE measurements (
  experimentID UINT NOT NULL,
  variable CHAR(30) NOT NULL,
  val REAL NOT NULL
) \g

CREATE UNIQUE  INDEX id ON measurements (
	experimentID,
	variable
) \g


#
# Dumping data for table 'measurements'
#


#
# Table structure for table 'experiments'
#
CREATE TABLE experiments (
  ID UINT NOT NULL,
  name CHAR(30) NOT NULL,
  creation CHAR(30) NOT NULL,
  who CHAR(30) NOT NULL,
  p UINT NOT NULL,
  comment CHAR(50)
) \g

CREATE UNIQUE  INDEX id ON experiments (
	ID
) \g


#
# Dumping data for table 'experiments'
#