CREATE TABLE CipresPortal(
	id int NOT NULL AUTO_INCREMENT,
	sessionId varchar(40) not null,
	sessionCount varchar(3) not null,
	special varchar(5),
	email varchar(60),
	groupLabel varchar(16),
	analysis varchar(32),
	toolNames varchar(32),
	originalNexusName varchar(124) not null,
	datatype varchar(20),
	ntaxa varchar(5),
	nchars varchar(5),
	ntrees varchar(5),
	start	datetime,
	stop	varchar(124), 
	status tinytext,
	PRIMARY KEY (id)
)
CREATE TABLE Questionnaire(
	id int NOT NULL AUTO_INCREMENT,
	jobs varchar(8),
	impression varchar(12),
	problems_q varchar(4),
	problems tinytext,
	configuration_q varchar(4),
	configuration tinytext,
	seqalignment_q varchar(4),
	seqalignment tinytext,
	visualization_q varchar(4),
	visualization tinytext,
	postanalysis_q varchar(4),
	postanalysis tinytext,
	login_q varchar(4),
	configuration_rating varchar(4),
	seqalignment_rating varchar(4),
	visualization_rating varchar(4),
	postanalysis_rating varchar(4),
	login_rating varchar(4),
	comments tinytext,
	PRIMARY KEY (id)
)
CREATE TABLE Permission (
	id int NOT NULL AUTO_INCREMENT,
	email varchar(60),
	clusternode varchar(124) DEFAULT "corbaloc::cipres15.sdsc.edu:5001/CipresRegistry",
	minutes varchar(16) DEFAULT "0",
	start date,
	stop date,
	PRIMARY KEY (id)
)
