[basedb-cvs] basedb/sql upgrade_rc1_to_rc2.sql,NONE,1.1

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

Update of /cvsroot/basedb/basedb/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv17804/sql

Added Files:
	upgrade_rc1_to_rc2.sql 
Log Message:
Untested

--- NEW FILE: upgrade_rc1_to_rc2.sql ---
DROP TABLE BioAssaySetExtraColumn;

CREATE TABLE BioAssaySetExtraColumn (
  bioAssaySet int(11) NOT NULL default '0',
  extraDataColumn int(11) NOT NULL default '0',
  position tinyint(4) NOT NULL auto_increment,
  PRIMARY KEY  (bioAssaySet,position),
  UNIQUE KEY setcol (bioAssaySet,extraDataColumn)
) TYPE=MyISAM;


ALTER TABLE UserAccount
  ADD defaultGid int(11) NOT NULL default '0',
  ADD defaultGroupAccess tinyint(1) NOT NULL default '0',
  ADD defaultWorldAccess tinyint(1) NOT NULL default '0';

ALTER TABLE UserGroup
  CHANGE name name varchar(30) default NULL;

UPDATE SchemaVersion SET baseVersion = '1.2.0RC2',
  schemaVersion = '1.2.3', lastChanged = NOW();