Update of /cvsroot/monetdb/sql/src/test/Skyserver
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv14753
Modified Files:
Tag: SQL_2-16
Skyserver_dropTables.sql Skyserver_tables.sql run.all
Added Files:
Tag: SQL_2-16
Skyserver_constraints.sql Skyserver_dropCache.sql
Skyserver_dropConstraints.sql Skyserver_dropMath.sql
Skyserver_dropMs_functions.sql
Log Message:
Drop some functions which were not dropped in the end of the test.
Split the Skyserver_tables into Skyserver_tables and Skyserver_constraints.
--- NEW FILE: Skyserver_dropMath.sql ---
START TRANSACTION;
DROP FUNCTION degrees;
DROP FUNCTION radians;
COMMIT;
--- NEW FILE: Skyserver_constraints.sql ---
START TRANSACTION;
ALTER TABLE "Match" ADD CONSTRAINT fk_Match_matchHead_MatchHead_obj FOREIGN
KEY(matchHead)
REFERENCES MatchHead (objID)
;
ALTER TABLE "Match" ADD CONSTRAINT fk_Match_objID1_PhotoObjAll_objI FOREIGN
KEY(objID1)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE SpecObjAll ADD CONSTRAINT fk_SpecObjAll_plateID_PlateX_pla
FOREIGN KEY(plateID)
REFERENCES PlateX (plateID)
;
ALTER TABLE HoleObj ADD CONSTRAINT fk_HoleObj_plateID_PlateX_plateI FOREIGN
KEY(plateID)
REFERENCES PlateX (plateID)
;
ALTER TABLE SpecPhotoAll ADD CONSTRAINT fk_SpecPhotoAll_specObjID_SpecOb
FOREIGN KEY(specObjID)
REFERENCES SpecObjAll (specObjID)
;
ALTER TABLE QuasarCatalog ADD CONSTRAINT fk_QuasarCatalog_specObjID_SpecO
FOREIGN KEY(specObjId)
REFERENCES SpecObjAll (specObjID)
;
ALTER TABLE SpecLineIndex ADD CONSTRAINT fk_SpecLineIndex_specobjID_SpecO
FOREIGN KEY(specobjID)
REFERENCES SpecObjAll (specObjID)
;
ALTER TABLE SpecLineAll ADD CONSTRAINT fk_SpecLineAll_specObjID_SpecObj
FOREIGN KEY(specobjID)
REFERENCES SpecObjAll (specObjID)
;
ALTER TABLE XCRedshift ADD CONSTRAINT fk_XCRedshift_specObjID_SpecObjA
FOREIGN KEY(specObjID)
REFERENCES SpecObjAll (specObjID)
;
ALTER TABLE ELRedShift ADD CONSTRAINT fk_ELRedshift_specObjID_SpecObjA
FOREIGN KEY(specObjID)
REFERENCES SpecObjAll (specObjID)
;
ALTER TABLE TargetInfo ADD CONSTRAINT fk_TargetInfo_targetID_Target_ta
FOREIGN KEY(targetID)
REFERENCES Target (targetID)
;
ALTER TABLE TiledTargetAll ADD CONSTRAINT fk_TiledTargetAll_tile_TileAll_t
FOREIGN KEY(tile)
REFERENCES TileAll (tile)
;
ALTER TABLE PlateX ADD CONSTRAINT fk_PlateX_tile_TileAll_tile FOREIGN
KEY(tile)
REFERENCES TileAll (tile)
;
ALTER TABLE Sector2Tile ADD CONSTRAINT fk_Sector2Tile_regionID_Region_r
FOREIGN KEY(regionID)
REFERENCES Region (regionid)
;
ALTER TABLE Sector2Tile ADD CONSTRAINT fk_Sector2Tile_tile_TileAll_tile
FOREIGN KEY(tile)
REFERENCES TileAll (tile)
;
ALTER TABLE TilingInfo ADD CONSTRAINT fk_TilingInfo_tileRun_TilingRun_
FOREIGN KEY(tileRun)
REFERENCES TilingRun (tileRun)
;
ALTER TABLE TileAll ADD CONSTRAINT fk_TileAll_tileRun_TilingRun_til FOREIGN
KEY(tileRun)
REFERENCES TilingRun (tileRun)
;
ALTER TABLE TilingNote ADD CONSTRAINT fk_TilingNote_tileRun_TilingRun_
FOREIGN KEY(tileRun)
REFERENCES TilingRun (tileRun)
;
ALTER TABLE TilingGeometry ADD CONSTRAINT fk_TilingGeometry_stripe_StripeD
FOREIGN KEY(stripe)
REFERENCES StripeDefs (stripe)
;
ALTER TABLE TilingGeometry ADD CONSTRAINT fk_TilingGeometry_tileRun_Tiling
FOREIGN KEY(tileRun)
REFERENCES TilingRun (tileRun)
;
ALTER TABLE RegionConvex ADD CONSTRAINT fk_RegionConvex_regionID_Region_
FOREIGN KEY(regionID)
REFERENCES Region (regionid)
;
ALTER TABLE Region2Box ADD CONSTRAINT fk_Region2Box_boxID_Region_regio
FOREIGN KEY(boxid)
REFERENCES Region (regionid)
;
ALTER TABLE Sector ADD CONSTRAINT fk_Sector_regionID_Region_region FOREIGN
KEY(regionID)
REFERENCES Region (regionid)
;
ALTER TABLE RegionArcs ADD CONSTRAINT fk_RegionArcs_regionID_Region_re
FOREIGN KEY(regionid)
REFERENCES Region (regionid)
;
ALTER TABLE HalfSpace ADD CONSTRAINT fk_HalfSpace_regionID_Region_reg FOREIGN
KEY(regionid)
REFERENCES Region (regionid)
;
ALTER TABLE Inventory ADD CONSTRAINT fk_Inventory_name_DBObjects_name FOREIGN
KEY(name)
REFERENCES DBObjects (name)
;
ALTER TABLE DBColumns ADD CONSTRAINT fk_DBColumns_tablename_DBObjects FOREIGN
KEY(tablename)
REFERENCES DBObjects (name)
;
ALTER TABLE DBViewCols ADD CONSTRAINT fk_DBViewCols_viewname_DBObjects
FOREIGN KEY(viewname)
REFERENCES DBObjects (name)
;
ALTER TABLE IndexMap ADD CONSTRAINT fk_IndexMap_tableName_DBObjects_ FOREIGN
KEY(tableName)
REFERENCES DBObjects (name)
;
ALTER TABLE BestTarget2Sector ADD CONSTRAINT fk_BestTarget2Sector_objID_Photo
FOREIGN KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE BestTarget2Sector ADD CONSTRAINT fk_BestTarget2Sector_regionID_Se
FOREIGN KEY(regionID)
REFERENCES Sector (regionID)
;
ALTER TABLE Segment ADD CONSTRAINT fk_Segment_chunkId_Chunk_chunkId FOREIGN
KEY(chunkID)
REFERENCES Chunk (chunkID)
;
ALTER TABLE Segment ADD CONSTRAINT fk_Segment_stripe_StripeDefs_str FOREIGN
KEY(stripe)
REFERENCES StripeDefs (stripe)
;
ALTER TABLE Field ADD CONSTRAINT fk_Field_segmentID_Segment_segme FOREIGN
KEY(segmentID)
REFERENCES Segment (segmentID)
;
ALTER TABLE PhotoObjAll ADD CONSTRAINT fk_PhotoObjAll_fieldID_Field_fie
FOREIGN KEY(fieldID)
REFERENCES Field (fieldID)
;
ALTER TABLE RunQA ADD CONSTRAINT fk_RunQA_fieldID_Field_fieldID FOREIGN
KEY(fieldID)
REFERENCES Field (fieldID)
;
ALTER TABLE FieldProfile ADD CONSTRAINT fk_FieldProfile_fieldID_Field_fi
FOREIGN KEY(fieldID)
REFERENCES Field (fieldID)
;
ALTER TABLE PhotoTag ADD CONSTRAINT fk_PhotoTag_fieldID_Field_fieldI FOREIGN
KEY(fieldID)
REFERENCES Field (fieldID)
;
ALTER TABLE PhotoTag ADD CONSTRAINT fk_PhotoTag_objID_PhotoObjAll_ob FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE Frame ADD CONSTRAINT fk_Frame_fieldID_Field_fieldID FOREIGN
KEY(fieldID)
REFERENCES Field (fieldID)
;
ALTER TABLE ObjMask ADD CONSTRAINT fk_ObjMask_objID_PhotoObjAll_obj FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE MatchHead ADD CONSTRAINT fk_MatchHead_objID_PhotoObjAll_o FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE MaskedObject ADD CONSTRAINT fk_MaskedObject_maskID_Mask_mask
FOREIGN KEY(maskID)
REFERENCES Mask (maskID)
;
ALTER TABLE MaskedObject ADD CONSTRAINT fk_MaskedObject_objID_PhotoObjAl
FOREIGN KEY(objid)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE Neighbors ADD CONSTRAINT fk_Neighbors_objID_PhotoObjAll_o FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE Zone ADD CONSTRAINT fk_Zone_objID_PhotoObjAll_objID FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE USNOB ADD CONSTRAINT fk_USNOB_objID_PhotoObjAll_objID FOREIGN
KEY(objid)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE USNO ADD CONSTRAINT fk_USNO_objID_PhotoObjAll_objID FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE PhotoAuxAll ADD CONSTRAINT fk_PhotoAuxAll_objID_PhotoObjAll
FOREIGN KEY(objid)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE Photoz ADD CONSTRAINT fk_Photoz_objID_PhotoObjAll_objI FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE First ADD CONSTRAINT fk_First_objID_PhotoObjAll_objID FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE Rosat ADD CONSTRAINT fk_Rosat_objID_PhotoObjAll_objID FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE PhotoProfile ADD CONSTRAINT fk_PhotoProfile_objID_PhotoObjAl
FOREIGN KEY(objID)
REFERENCES PhotoObjAll (objID)
;
ALTER TABLE FileGroupMap ADD CONSTRAINT fk_FileGroupMap_tableFileGroup_P
FOREIGN KEY(tableFileGroup)
REFERENCES PartitionMap (fileGroupName)
;
ALTER TABLE Chunk ADD CONSTRAINT fk_Chunk_stripe_StripeDefs_strip FOREIGN
KEY(stripe)
REFERENCES StripeDefs (stripe)
;
COMMIT;
--- NEW FILE: Skyserver_dropMs_functions.sql ---
START TRANSACTION;
DROP FUNCTION MS_STUFF;
DROP FUNCTION MS_ROUND;
COMMIT;
--- NEW FILE: Skyserver_dropConstraints.sql ---
START TRANSACTION;
ALTER TABLE "Match" DROP CONSTRAINT fk_Match_matchHead_MatchHead_obj;
ALTER TABLE "Match" DROP CONSTRAINT fk_Match_objID1_PhotoObjAll_objI;
ALTER TABLE SpecObjAll DROP CONSTRAINT fk_SpecObjAll_plateID_PlateX_pla;
ALTER TABLE HoleObj DROP CONSTRAINT fk_HoleObj_plateID_PlateX_plateI;
ALTER TABLE SpecPhotoAll DROP CONSTRAINT fk_SpecPhotoAll_specObjID_SpecOb;
ALTER TABLE QuasarCatalog DROP CONSTRAINT fk_QuasarCatalog_specObjID_SpecO;
ALTER TABLE SpecLineIndex DROP CONSTRAINT fk_SpecLineIndex_specobjID_SpecO;
ALTER TABLE SpecLineAll DROP CONSTRAINT fk_SpecLineAll_specObjID_SpecObj;
ALTER TABLE XCRedshift DROP CONSTRAINT fk_XCRedshift_specObjID_SpecObjA;
ALTER TABLE ELRedShift DROP CONSTRAINT fk_ELRedshift_specObjID_SpecObjA;
ALTER TABLE TargetInfo DROP CONSTRAINT fk_TargetInfo_targetID_Target_ta;
ALTER TABLE TiledTargetAll DROP CONSTRAINT fk_TiledTargetAll_tile_TileAll_t;
ALTER TABLE PlateX DROP CONSTRAINT fk_PlateX_tile_TileAll_tile;
ALTER TABLE Sector2Tile DROP CONSTRAINT fk_Sector2Tile_regionID_Region_r;
ALTER TABLE Sector2Tile DROP CONSTRAINT fk_Sector2Tile_tile_TileAll_tile;
ALTER TABLE TilingInfo DROP CONSTRAINT fk_TilingInfo_tileRun_TilingRun_;
ALTER TABLE TileAll DROP CONSTRAINT fk_TileAll_tileRun_TilingRun_til;
ALTER TABLE TilingNote DROP CONSTRAINT fk_TilingNote_tileRun_TilingRun_;
ALTER TABLE TilingGeometry DROP CONSTRAINT fk_TilingGeometry_stripe_StripeD;
ALTER TABLE TilingGeometry DROP CONSTRAINT fk_TilingGeometry_tileRun_Tiling;
ALTER TABLE RegionConvex DROP CONSTRAINT fk_RegionConvex_regionID_Region_;
ALTER TABLE Region2Box DROP CONSTRAINT fk_Region2Box_boxID_Region_regio;
ALTER TABLE Sector DROP CONSTRAINT fk_Sector_regionID_Region_region;
ALTER TABLE RegionArcs DROP CONSTRAINT fk_RegionArcs_regionID_Region_re;
ALTER TABLE HalfSpace DROP CONSTRAINT fk_HalfSpace_regionID_Region_reg;
ALTER TABLE Inventory DROP CONSTRAINT fk_Inventory_name_DBObjects_name;
ALTER TABLE DBColumns DROP CONSTRAINT fk_DBColumns_tablename_DBObjects;
ALTER TABLE DBViewCols DROP CONSTRAINT fk_DBViewCols_viewname_DBObjects;
ALTER TABLE IndexMap DROP CONSTRAINT fk_IndexMap_tableName_DBObjects_;
ALTER TABLE BestTarget2Sector DROP CONSTRAINT fk_BestTarget2Sector_objID_Photo;
ALTER TABLE BestTarget2Sector DROP CONSTRAINT fk_BestTarget2Sector_regionID_Se;
ALTER TABLE Segment DROP CONSTRAINT fk_Segment_chunkId_Chunk_chunkId;
ALTER TABLE Segment DROP CONSTRAINT fk_Segment_stripe_StripeDefs_str;
ALTER TABLE Field DROP CONSTRAINT fk_Field_segmentID_Segment_segme;
ALTER TABLE PhotoObjAll DROP CONSTRAINT fk_PhotoObjAll_fieldID_Field_fie;
ALTER TABLE RunQA DROP CONSTRAINT fk_RunQA_fieldID_Field_fieldID;
ALTER TABLE FieldProfile DROP CONSTRAINT fk_FieldProfile_fieldID_Field_fi;
ALTER TABLE PhotoTag DROP CONSTRAINT fk_PhotoTag_fieldID_Field_fieldI;
ALTER TABLE PhotoTag DROP CONSTRAINT fk_PhotoTag_objID_PhotoObjAll_ob;
ALTER TABLE Frame DROP CONSTRAINT fk_Frame_fieldID_Field_fieldID;
ALTER TABLE ObjMask DROP CONSTRAINT fk_ObjMask_objID_PhotoObjAll_obj;
ALTER TABLE MatchHead DROP CONSTRAINT fk_MatchHead_objID_PhotoObjAll_o;
ALTER TABLE MaskedObject DROP CONSTRAINT fk_MaskedObject_maskID_Mask_mask;
ALTER TABLE MaskedObject DROP CONSTRAINT fk_MaskedObject_objID_PhotoObjAl;
ALTER TABLE Neighbors DROP CONSTRAINT fk_Neighbors_objID_PhotoObjAll_o;
ALTER TABLE Zone DROP CONSTRAINT fk_Zone_objID_PhotoObjAll_objID;
ALTER TABLE USNOB DROP CONSTRAINT fk_USNOB_objID_PhotoObjAll_objID;
ALTER TABLE USNO DROP CONSTRAINT fk_USNO_objID_PhotoObjAll_objID;
ALTER TABLE PhotoAuxAll DROP CONSTRAINT fk_PhotoAuxAll_objID_PhotoObjAll;
ALTER TABLE Photoz DROP CONSTRAINT fk_Photoz_objID_PhotoObjAll_objI;
ALTER TABLE First DROP CONSTRAINT fk_First_objID_PhotoObjAll_objID;
ALTER TABLE Rosat DROP CONSTRAINT fk_Rosat_objID_PhotoObjAll_objID;
ALTER TABLE PhotoProfile DROP CONSTRAINT fk_PhotoProfile_objID_PhotoObjAl;
ALTER TABLE FileGroupMap DROP CONSTRAINT fk_FileGroupMap_tableFileGroup_P;
ALTER TABLE Chunk DROP CONSTRAINT fk_Chunk_stripe_StripeDefs_strip;
COMMIT;
Index: Skyserver_tables.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_tables.sql,v
retrieving revision 1.2
retrieving revision 1.2.4.1
diff -u -d -r1.2 -r1.2.4.1
--- Skyserver_tables.sql 12 Oct 2006 09:20:19 -0000 1.2
+++ Skyserver_tables.sql 19 Mar 2007 14:12:13 -0000 1.2.4.1
@@ -2547,172 +2547,3 @@
COMMIT;
-START TRANSACTION;
-
-ALTER TABLE "Match" ADD CONSTRAINT fk_Match_matchHead_MatchHead_obj FOREIGN
KEY(matchHead)
-REFERENCES MatchHead (objID)
-;
-ALTER TABLE "Match" ADD CONSTRAINT fk_Match_objID1_PhotoObjAll_objI FOREIGN
KEY(objID1)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE SpecObjAll ADD CONSTRAINT fk_SpecObjAll_plateID_PlateX_pla
FOREIGN KEY(plateID)
-REFERENCES PlateX (plateID)
-;
-ALTER TABLE HoleObj ADD CONSTRAINT fk_HoleObj_plateID_PlateX_plateI FOREIGN
KEY(plateID)
-REFERENCES PlateX (plateID)
-;
-ALTER TABLE SpecPhotoAll ADD CONSTRAINT fk_SpecPhotoAll_specObjID_SpecOb
FOREIGN KEY(specObjID)
-REFERENCES SpecObjAll (specObjID)
-;
-ALTER TABLE QuasarCatalog ADD CONSTRAINT fk_QuasarCatalog_specObjID_SpecO
FOREIGN KEY(specObjId)
-REFERENCES SpecObjAll (specObjID)
-;
-ALTER TABLE SpecLineIndex ADD CONSTRAINT fk_SpecLineIndex_specobjID_SpecO
FOREIGN KEY(specobjID)
-REFERENCES SpecObjAll (specObjID)
-;
-ALTER TABLE SpecLineAll ADD CONSTRAINT fk_SpecLineAll_specObjID_SpecObj
FOREIGN KEY(specobjID)
-REFERENCES SpecObjAll (specObjID)
-;
-ALTER TABLE XCRedshift ADD CONSTRAINT fk_XCRedshift_specObjID_SpecObjA
FOREIGN KEY(specObjID)
-REFERENCES SpecObjAll (specObjID)
-;
-ALTER TABLE ELRedShift ADD CONSTRAINT fk_ELRedshift_specObjID_SpecObjA
FOREIGN KEY(specObjID)
-REFERENCES SpecObjAll (specObjID)
-;
-ALTER TABLE TargetInfo ADD CONSTRAINT fk_TargetInfo_targetID_Target_ta
FOREIGN KEY(targetID)
-REFERENCES Target (targetID)
-;
-ALTER TABLE TiledTargetAll ADD CONSTRAINT fk_TiledTargetAll_tile_TileAll_t
FOREIGN KEY(tile)
-REFERENCES TileAll (tile)
-;
-ALTER TABLE PlateX ADD CONSTRAINT fk_PlateX_tile_TileAll_tile FOREIGN
KEY(tile)
-REFERENCES TileAll (tile)
-;
-ALTER TABLE Sector2Tile ADD CONSTRAINT fk_Sector2Tile_regionID_Region_r
FOREIGN KEY(regionID)
-REFERENCES Region (regionid)
-;
-ALTER TABLE Sector2Tile ADD CONSTRAINT fk_Sector2Tile_tile_TileAll_tile
FOREIGN KEY(tile)
-REFERENCES TileAll (tile)
-;
-ALTER TABLE TilingInfo ADD CONSTRAINT fk_TilingInfo_tileRun_TilingRun_
FOREIGN KEY(tileRun)
-REFERENCES TilingRun (tileRun)
-;
-ALTER TABLE TileAll ADD CONSTRAINT fk_TileAll_tileRun_TilingRun_til FOREIGN
KEY(tileRun)
-REFERENCES TilingRun (tileRun)
-;
-ALTER TABLE TilingNote ADD CONSTRAINT fk_TilingNote_tileRun_TilingRun_
FOREIGN KEY(tileRun)
-REFERENCES TilingRun (tileRun)
-;
-ALTER TABLE TilingGeometry ADD CONSTRAINT fk_TilingGeometry_stripe_StripeD
FOREIGN KEY(stripe)
-REFERENCES StripeDefs (stripe)
-;
-ALTER TABLE TilingGeometry ADD CONSTRAINT fk_TilingGeometry_tileRun_Tiling
FOREIGN KEY(tileRun)
-REFERENCES TilingRun (tileRun)
-;
-ALTER TABLE RegionConvex ADD CONSTRAINT fk_RegionConvex_regionID_Region_
FOREIGN KEY(regionID)
-REFERENCES Region (regionid)
-;
-ALTER TABLE Region2Box ADD CONSTRAINT fk_Region2Box_boxID_Region_regio
FOREIGN KEY(boxid)
-REFERENCES Region (regionid)
-;
-ALTER TABLE Sector ADD CONSTRAINT fk_Sector_regionID_Region_region FOREIGN
KEY(regionID)
-REFERENCES Region (regionid)
-;
-ALTER TABLE RegionArcs ADD CONSTRAINT fk_RegionArcs_regionID_Region_re
FOREIGN KEY(regionid)
-REFERENCES Region (regionid)
-;
-ALTER TABLE HalfSpace ADD CONSTRAINT fk_HalfSpace_regionID_Region_reg
FOREIGN KEY(regionid)
-REFERENCES Region (regionid)
-;
-ALTER TABLE Inventory ADD CONSTRAINT fk_Inventory_name_DBObjects_name
FOREIGN KEY(name)
-REFERENCES DBObjects (name)
-;
-ALTER TABLE DBColumns ADD CONSTRAINT fk_DBColumns_tablename_DBObjects
FOREIGN KEY(tablename)
-REFERENCES DBObjects (name)
-;
-ALTER TABLE DBViewCols ADD CONSTRAINT fk_DBViewCols_viewname_DBObjects
FOREIGN KEY(viewname)
-REFERENCES DBObjects (name)
-;
-ALTER TABLE IndexMap ADD CONSTRAINT fk_IndexMap_tableName_DBObjects_ FOREIGN
KEY(tableName)
-REFERENCES DBObjects (name)
-;
-ALTER TABLE BestTarget2Sector ADD CONSTRAINT
fk_BestTarget2Sector_objID_Photo FOREIGN KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE BestTarget2Sector ADD CONSTRAINT
fk_BestTarget2Sector_regionID_Se FOREIGN KEY(regionID)
-REFERENCES Sector (regionID)
-;
-ALTER TABLE Segment ADD CONSTRAINT fk_Segment_chunkId_Chunk_chunkId FOREIGN
KEY(chunkID)
-REFERENCES Chunk (chunkID)
-;
-ALTER TABLE Segment ADD CONSTRAINT fk_Segment_stripe_StripeDefs_str FOREIGN
KEY(stripe)
-REFERENCES StripeDefs (stripe)
-;
-ALTER TABLE Field ADD CONSTRAINT fk_Field_segmentID_Segment_segme FOREIGN
KEY(segmentID)
-REFERENCES Segment (segmentID)
-;
-ALTER TABLE PhotoObjAll ADD CONSTRAINT fk_PhotoObjAll_fieldID_Field_fie
FOREIGN KEY(fieldID)
-REFERENCES Field (fieldID)
-;
-ALTER TABLE RunQA ADD CONSTRAINT fk_RunQA_fieldID_Field_fieldID FOREIGN
KEY(fieldID)
-REFERENCES Field (fieldID)
-;
-ALTER TABLE FieldProfile ADD CONSTRAINT fk_FieldProfile_fieldID_Field_fi
FOREIGN KEY(fieldID)
-REFERENCES Field (fieldID)
-;
-ALTER TABLE PhotoTag ADD CONSTRAINT fk_PhotoTag_fieldID_Field_fieldI FOREIGN
KEY(fieldID)
-REFERENCES Field (fieldID)
-;
-ALTER TABLE PhotoTag ADD CONSTRAINT fk_PhotoTag_objID_PhotoObjAll_ob FOREIGN
KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE Frame ADD CONSTRAINT fk_Frame_fieldID_Field_fieldID FOREIGN
KEY(fieldID)
-REFERENCES Field (fieldID)
-;
-ALTER TABLE ObjMask ADD CONSTRAINT fk_ObjMask_objID_PhotoObjAll_obj FOREIGN
KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE MatchHead ADD CONSTRAINT fk_MatchHead_objID_PhotoObjAll_o
FOREIGN KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE MaskedObject ADD CONSTRAINT fk_MaskedObject_maskID_Mask_mask
FOREIGN KEY(maskID)
-REFERENCES Mask (maskID)
-;
-ALTER TABLE MaskedObject ADD CONSTRAINT fk_MaskedObject_objID_PhotoObjAl
FOREIGN KEY(objid)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE Neighbors ADD CONSTRAINT fk_Neighbors_objID_PhotoObjAll_o
FOREIGN KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE Zone ADD CONSTRAINT fk_Zone_objID_PhotoObjAll_objID FOREIGN
KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE USNOB ADD CONSTRAINT fk_USNOB_objID_PhotoObjAll_objID FOREIGN
KEY(objid)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE USNO ADD CONSTRAINT fk_USNO_objID_PhotoObjAll_objID FOREIGN
KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE PhotoAuxAll ADD CONSTRAINT fk_PhotoAuxAll_objID_PhotoObjAll
FOREIGN KEY(objid)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE Photoz ADD CONSTRAINT fk_Photoz_objID_PhotoObjAll_objI FOREIGN
KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE First ADD CONSTRAINT fk_First_objID_PhotoObjAll_objID FOREIGN
KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE Rosat ADD CONSTRAINT fk_Rosat_objID_PhotoObjAll_objID FOREIGN
KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE PhotoProfile ADD CONSTRAINT fk_PhotoProfile_objID_PhotoObjAl
FOREIGN KEY(objID)
-REFERENCES PhotoObjAll (objID)
-;
-ALTER TABLE FileGroupMap ADD CONSTRAINT fk_FileGroupMap_tableFileGroup_P
FOREIGN KEY(tableFileGroup)
-REFERENCES PartitionMap (fileGroupName)
-;
-ALTER TABLE Chunk ADD CONSTRAINT fk_Chunk_stripe_StripeDefs_strip FOREIGN
KEY(stripe)
-REFERENCES StripeDefs (stripe)
-;
-
-COMMIT;
--- NEW FILE: Skyserver_dropCache.sql ---
START TRANSACTION;
DROP FUNCTION query_cache;
COMMIT;
Index: Skyserver_dropTables.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_dropTables.sql,v
retrieving revision 1.1
retrieving revision 1.1.4.1
diff -u -d -r1.1 -r1.1.4.1
--- Skyserver_dropTables.sql 18 Sep 2006 17:39:19 -0000 1.1
+++ Skyserver_dropTables.sql 19 Mar 2007 14:12:12 -0000 1.1.4.1
@@ -1,65 +1,5 @@
START TRANSACTION;
-ALTER TABLE "Match" DROP CONSTRAINT fk_Match_matchHead_MatchHead_obj;
-ALTER TABLE "Match" DROP CONSTRAINT fk_Match_objID1_PhotoObjAll_objI;
-ALTER TABLE SpecObjAll DROP CONSTRAINT fk_SpecObjAll_plateID_PlateX_pla;
-ALTER TABLE HoleObj DROP CONSTRAINT fk_HoleObj_plateID_PlateX_plateI;
-ALTER TABLE SpecPhotoAll DROP CONSTRAINT fk_SpecPhotoAll_specObjID_SpecOb;
-ALTER TABLE QuasarCatalog DROP CONSTRAINT fk_QuasarCatalog_specObjID_SpecO;
-ALTER TABLE SpecLineIndex DROP CONSTRAINT fk_SpecLineIndex_specobjID_SpecO;
-ALTER TABLE SpecLineAll DROP CONSTRAINT fk_SpecLineAll_specObjID_SpecObj;
-ALTER TABLE XCRedshift DROP CONSTRAINT fk_XCRedshift_specObjID_SpecObjA;
-ALTER TABLE ELRedShift DROP CONSTRAINT fk_ELRedshift_specObjID_SpecObjA;
-ALTER TABLE TargetInfo DROP CONSTRAINT fk_TargetInfo_targetID_Target_ta;
-ALTER TABLE TiledTargetAll DROP CONSTRAINT fk_TiledTargetAll_tile_TileAll_t;
-ALTER TABLE PlateX DROP CONSTRAINT fk_PlateX_tile_TileAll_tile;
-ALTER TABLE Sector2Tile DROP CONSTRAINT fk_Sector2Tile_regionID_Region_r;
-ALTER TABLE Sector2Tile DROP CONSTRAINT fk_Sector2Tile_tile_TileAll_tile;
-ALTER TABLE TilingInfo DROP CONSTRAINT fk_TilingInfo_tileRun_TilingRun_;
-ALTER TABLE TileAll DROP CONSTRAINT fk_TileAll_tileRun_TilingRun_til;
-ALTER TABLE TilingNote DROP CONSTRAINT fk_TilingNote_tileRun_TilingRun_;
-ALTER TABLE TilingGeometry DROP CONSTRAINT fk_TilingGeometry_stripe_StripeD;
-ALTER TABLE TilingGeometry DROP CONSTRAINT fk_TilingGeometry_tileRun_Tiling;
-ALTER TABLE RegionConvex DROP CONSTRAINT fk_RegionConvex_regionID_Region_;
-ALTER TABLE Region2Box DROP CONSTRAINT fk_Region2Box_boxID_Region_regio;
-ALTER TABLE Sector DROP CONSTRAINT fk_Sector_regionID_Region_region;
-ALTER TABLE RegionArcs DROP CONSTRAINT fk_RegionArcs_regionID_Region_re;
-ALTER TABLE HalfSpace DROP CONSTRAINT fk_HalfSpace_regionID_Region_reg;
-ALTER TABLE Inventory DROP CONSTRAINT fk_Inventory_name_DBObjects_name;
-ALTER TABLE DBColumns DROP CONSTRAINT fk_DBColumns_tablename_DBObjects;
-ALTER TABLE DBViewCols DROP CONSTRAINT fk_DBViewCols_viewname_DBObjects;
-ALTER TABLE IndexMap DROP CONSTRAINT fk_IndexMap_tableName_DBObjects_;
-ALTER TABLE BestTarget2Sector DROP CONSTRAINT fk_BestTarget2Sector_objID_Photo;
-ALTER TABLE BestTarget2Sector DROP CONSTRAINT fk_BestTarget2Sector_regionID_Se;
-ALTER TABLE Segment DROP CONSTRAINT fk_Segment_chunkId_Chunk_chunkId;
-ALTER TABLE Segment DROP CONSTRAINT fk_Segment_stripe_StripeDefs_str;
-ALTER TABLE Field DROP CONSTRAINT fk_Field_segmentID_Segment_segme;
-ALTER TABLE PhotoObjAll DROP CONSTRAINT fk_PhotoObjAll_fieldID_Field_fie;
-ALTER TABLE RunQA DROP CONSTRAINT fk_RunQA_fieldID_Field_fieldID;
-ALTER TABLE FieldProfile DROP CONSTRAINT fk_FieldProfile_fieldID_Field_fi;
-ALTER TABLE PhotoTag DROP CONSTRAINT fk_PhotoTag_fieldID_Field_fieldI;
-ALTER TABLE PhotoTag DROP CONSTRAINT fk_PhotoTag_objID_PhotoObjAll_ob;
-ALTER TABLE Frame DROP CONSTRAINT fk_Frame_fieldID_Field_fieldID;
-ALTER TABLE ObjMask DROP CONSTRAINT fk_ObjMask_objID_PhotoObjAll_obj;
-ALTER TABLE MatchHead DROP CONSTRAINT fk_MatchHead_objID_PhotoObjAll_o;
-ALTER TABLE MaskedObject DROP CONSTRAINT fk_MaskedObject_maskID_Mask_mask;
-ALTER TABLE MaskedObject DROP CONSTRAINT fk_MaskedObject_objID_PhotoObjAl;
-ALTER TABLE Neighbors DROP CONSTRAINT fk_Neighbors_objID_PhotoObjAll_o;
-ALTER TABLE Zone DROP CONSTRAINT fk_Zone_objID_PhotoObjAll_objID;
-ALTER TABLE USNOB DROP CONSTRAINT fk_USNOB_objID_PhotoObjAll_objID;
-ALTER TABLE USNO DROP CONSTRAINT fk_USNO_objID_PhotoObjAll_objID;
-ALTER TABLE PhotoAuxAll DROP CONSTRAINT fk_PhotoAuxAll_objID_PhotoObjAll;
-ALTER TABLE Photoz DROP CONSTRAINT fk_Photoz_objID_PhotoObjAll_objI;
-ALTER TABLE First DROP CONSTRAINT fk_First_objID_PhotoObjAll_objID;
-ALTER TABLE Rosat DROP CONSTRAINT fk_Rosat_objID_PhotoObjAll_objID;
-ALTER TABLE PhotoProfile DROP CONSTRAINT fk_PhotoProfile_objID_PhotoObjAl;
-ALTER TABLE FileGroupMap DROP CONSTRAINT fk_FileGroupMap_tableFileGroup_P;
-ALTER TABLE Chunk DROP CONSTRAINT fk_Chunk_stripe_StripeDefs_strip;
-
-COMMIT;
-
-START TRANSACTION;
-
DROP TABLE RC3;
DROP TABLE Stetson;
DROP TABLE QsoCatalogAll;
Index: run.all
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/run.all,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- run.all 3 Jan 2007 12:39:52 -0000 1.2
+++ run.all 19 Mar 2007 14:12:14 -0000 1.2.2.1
@@ -32,6 +32,7 @@
echo tables
$SQL1 < Skyserver_tables.sql
+$SQL1 < Skyserver_constraints.sql
echo views
$SQL1 < Skyserver_views.sql
@@ -40,9 +41,13 @@
$SQL1 < Skyserver_functions.sql
echo Cleanup
+$SQL1 < Skyserver_dropFunctions.sql
+$SQL1 < Skyserver_dropMs_functions.sql
+$SQL1 < Skyserver_dropMath.sql
+$SQL1 < Skyserver_dropCache.sql
$SQL1 < Skyserver_dropViews.sql
+$SQL1 < Skyserver_dropConstraints.sql
$SQL1 < Skyserver_dropTables.sql
-$SQL1 < Skyserver_dropFunctions.sql
echo Remove User
$SQL < drop_user.sql
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
