[basedb-cvs] basedb/sql base_mysql_data.sql,1.2,1.3 base_pgsql.sql,1.2,1.3

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

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

Modified Files:
	base_mysql_data.sql base_pgsql.sql 
Log Message:
Bumped schema version

Index: base_mysql_data.sql
===================================================================
RCS file: /cvsroot/basedb/basedb/sql/base_mysql_data.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** base_mysql_data.sql	2 Feb 2003 18:17:08 -0000	1.2
--- base_mysql_data.sql	13 Feb 2003 12:23:56 -0000	1.3
***************
*** 53,57 ****
  INSERT INTO SampleTissue (id, parent, name, descr, owner, addedDate, removed) VALUES (1,'','Homo sapiens','',1,'0000-00-00','');
  
! INSERT INTO SchemaVersion VALUES ('1.2.0RC1','1.2.2', '2002-12-23 15:53:17');
  
  INSERT INTO UserGroup (id, name, descr, owner, addedDate, removed, accessMask,isAccount) VALUES
--- 53,57 ----
  INSERT INTO SampleTissue (id, parent, name, descr, owner, addedDate, removed) VALUES (1,'','Homo sapiens','',1,'0000-00-00','');
  
! INSERT INTO SchemaVersion VALUES ('1.2.0RC2','1.2.3', '2002-02-13 12:44:00');
  
  INSERT INTO UserGroup (id, name, descr, owner, addedDate, removed, accessMask,isAccount) VALUES

Index: base_pgsql.sql
===================================================================
RCS file: /cvsroot/basedb/basedb/sql/base_pgsql.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** base_pgsql.sql	2 Feb 2003 18:17:29 -0000	1.2
--- base_pgsql.sql	13 Feb 2003 12:23:56 -0000	1.3
***************
*** 234,239 ****
    "bioAssaySet" int NOT NULL default '0',
    "extraDataColumn" int NOT NULL default '0',
!   "position" smallint NOT NULL default '0'
! , CONSTRAINT BioAssaySetExtraColumn_pkey PRIMARY KEY ("bioAssaySet","extraDataColumn")
  );
  
--- 234,239 ----
    "bioAssaySet" int NOT NULL default '0',
    "extraDataColumn" int NOT NULL default '0',
!   "position" smallint NOT NULL 
! , CONSTRAINT BioAssaySetExtraColumn_pkey PRIMARY KEY ("bioAssaySet","position")
  );
  
***************
*** 1324,1328 ****
  CREATE  INDEX BioAssaySet_experiment_index ON BioAssaySet USING btree ("experiment");
  
! CREATE UNIQUE INDEX BioAssaySetExtraColumn_setpos_index ON BioAssaySetExtraColumn USING btree ("bioAssaySet","position");
  
  CREATE UNIQUE INDEX BioAssaySetSearch_ref_index ON BioAssaySetSearch USING btree ("bioAssaySet","userGroup","searchType");
--- 1324,1328 ----
  CREATE  INDEX BioAssaySet_experiment_index ON BioAssaySet USING btree ("experiment");
  
! CREATE UNIQUE INDEX BioAssaySetExtraColumn_setcol_index ON BioAssaySetExtraColumn USING btree ("bioAssaySet","extraDataColumn");
  
  CREATE UNIQUE INDEX BioAssaySetSearch_ref_index ON BioAssaySetSearch USING btree ("bioAssaySet","userGroup","searchType");