From: <tr...@us...> - 2003-02-12 09:23:09
|
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; |