Update of /cvsroot/monetdb/sql/src/test/Skyserver
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26182
Modified Files:
Tag: SQL_2-24
Skyserver_views_v6.sql Skyserver_dropViews_v6.sql
Log Message:
Create once 2 views
and drop correctly to avoid dependencies problems...
U Skyserver_views_v6.sql
Index: Skyserver_views_v6.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_views_v6.sql,v
retrieving revision 1.1.2.3
retrieving revision 1.1.2.4
diff -u -d -r1.1.2.3 -r1.1.2.4
--- Skyserver_views_v6.sql 12 Jun 2008 10:54:12 -0000 1.1.2.3
+++ Skyserver_views_v6.sql 13 Jun 2008 08:12:36 -0000 1.1.2.4
@@ -36,12 +36,6 @@
FROM DataConstants
WHERE field='FramesStatus'
;
-CREATE VIEW GalaxyTag
-AS
-SELECT *
- FROM PhotoTag g
- WHERE type = 3 and mode=1
-;
CREATE VIEW HoleType
AS
SELECT name,
@@ -305,12 +299,6 @@
FROM PhotoPrimary
WHERE type = 6
;
-CREATE VIEW StarTag
-AS
-SELECT *
- FROM PhotoTag g
- WHERE type = 6 and mode=1
-;
CREATE VIEW TargPhotoObj
AS
SELECT * FROM TargPhotoObjAll g
U Skyserver_dropViews_v6.sql
Index: Skyserver_dropViews_v6.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_dropViews_v6.sql,v
retrieving revision 1.1.2.4
retrieving revision 1.1.2.5
diff -u -d -r1.1.2.4 -r1.1.2.5
--- Skyserver_dropViews_v6.sql 12 Jun 2008 10:57:09 -0000 1.1.2.4
+++ Skyserver_dropViews_v6.sql 13 Jun 2008 08:12:41 -0000 1.1.2.5
@@ -1,4 +1,3 @@
-DROP VIEW PhotoTag;
DROP VIEW CoordType;
DROP VIEW FieldMask;
DROP VIEW FieldQuality;
@@ -49,3 +48,4 @@
DROP VIEW UberCalibStatus;
DROP VIEW Unknown;
DROP VIEW PhotoPrimary ;
+DROP VIEW PhotoTag;
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
