isenseDev/iSENSE — Issue #34: Experiments Table Update
Author: jdalphon
Created: 2012-02-14 21:14:21+00:00
State: open

The experiments table in the database should be updated to have 5 more columns proposed below.

* req_name Should session name be required?
* req_procedure Should session procedure be required?
* req_location Should session location be required?
* name_prefix Prefix that should be used for sequential session names if no name is required.
* location Location to be used (optional) should location not be reqired.

SQL commands:
alter table experiments add (req_name tinyint not null DEFAULT '1');
alter table experiments add (req_procedure tinyint not null DEFAULT '1');
alter table experiments add (req_location tinyint not null DEFAULT '1');
alter table experiments add (name_prefix varchar(32));
alter table experiments add (location varchar(256));