[basedb-cvs] basedb/exec/migration_tools devchanges.sql,NONE,1.1

[<tr...@us...>]

Update of /cvsroot/basedb/basedb/exec/migration_tools
In directory usw-pr-cvs1:/tmp/cvs-serv26825a

Added Files:
	devchanges.sql 
Log Message:
Database changes necessary to use the CVS version

--- NEW FILE: devchanges.sql ---
-- This file mostly contains the structural changes (from 1.0.6) that
-- have been done so far. 

ALTER TABLE Sample 
	DROP useCount,
	ADD sampleDate DATE not null,
	ADD removed TINYINT(1) not null,
	ADD gid INT not null ,
	ADD groupAccess TINYINT(1) not null,
	ADD worldAccess TINYINT(1) not null;

ALTER TABLE Extract 
	DROP useCount,
	ADD removed TINYINT(1) not null,
	ADD gid INT not null ,
	ADD groupAccess TINYINT(1) not null,
	ADD worldAccess TINYINT(1) not null;

ALTER TABLE LabeledExtract 
[...185 lines suppressed...]
CREATE TABLE `UserGroupParent` (
  `child` int(11) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  PRIMARY KEY  (`child`,`parent`)
) TYPE=MyISAM;

INSERT INTO UserGroup (id, name, accessMask)
	SELECT (id, userName, accessMask) FROM Submitter;

INSERT INTO UserAccount
	(userGroup, email, address, phone, fax, realName, md5Pass, activeUntil)
	SELECT (id, email, address, phone, fax, name, md5Pass, activeUntil) FROM Submitter;

ALTER TABLE UserSearch CHANGE searchType searchType ENUM
 ('plate','sample','extract','labeled','hybridization','value','arraytype','well','wizzzard','raw','exp','user','gene','genelist','program','news','acq','acq_img','ware','acq_rba','platetype','print','array','molecule','upload','annottype','protocol') DEFAULT
  'plate' not null;

UPDATE Protocol SET worldAccess = 1;
UPDATE SampleAnnotationType SET worldAccess = 1;
UPDATE Program SET worldAccess = 1;