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");
|
