Update of /cvsroot/basedb/basedb/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv26305
Modified Files:
base_mysql.sql
Log Message:
Added missing auto_increment on BioAssaySetExtraColumn.position
Index: base_mysql.sql
===================================================================
RCS file: /cvsroot/basedb/basedb/sql/base_mysql.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** base_mysql.sql 2 Feb 2003 18:16:45 -0000 1.2
--- base_mysql.sql 12 Feb 2003 09:23:06 -0000 1.3
***************
*** 246,252 ****
bioAssaySet int(11) NOT NULL default '0',
extraDataColumn int(11) NOT NULL default '0',
! position tinyint(4) NOT NULL default '0',
! PRIMARY KEY (bioAssaySet,extraDataColumn),
! UNIQUE KEY setpos (bioAssaySet,position)
) TYPE=MyISAM;
--- 246,252 ----
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;
|
