Update of /cvsroot/monetdb/sql/src/test/Skyserver
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv25182
Modified Files:
Tag: SQL_2-24
Skyserver_dropTables_v6.sql Skyserver_dropViews_v6.sql
Skyserver_constraints_v6.sql Skyserver_dropConstraints_v6.sql
Log Message:
Synchronize with skyserver module...
PhotoTag is a view and not a table..
U Skyserver_dropTables_v6.sql
Index: Skyserver_dropTables_v6.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_dropTables_v6.sql,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -d -r1.1.2.2 -r1.1.2.3
--- Skyserver_dropTables_v6.sql 30 May 2008 09:27:32 -0000 1.1.2.2
+++ Skyserver_dropTables_v6.sql 12 Jun 2008 10:57:06 -0000 1.1.2.3
@@ -32,7 +32,6 @@
DROP TABLE PartitionMap;
DROP TABLE PhotoObjAll;
DROP TABLE PhotoProfile;
-DROP TABLE PhotoTag;
DROP TABLE Photoz;
DROP TABLE Photoz2;
DROP TABLE PlateX;
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.3
retrieving revision 1.1.2.4
diff -u -d -r1.1.2.3 -r1.1.2.4
--- Skyserver_dropViews_v6.sql 30 May 2008 09:27:33 -0000 1.1.2.3
+++ Skyserver_dropViews_v6.sql 12 Jun 2008 10:57:09 -0000 1.1.2.4
@@ -1,3 +1,4 @@
+DROP VIEW PhotoTag;
DROP VIEW CoordType;
DROP VIEW FieldMask;
DROP VIEW FieldQuality;
U Skyserver_constraints_v6.sql
Index: Skyserver_constraints_v6.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_constraints_v6.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- Skyserver_constraints_v6.sql 27 May 2008 14:04:38 -0000 1.1.2.1
+++ Skyserver_constraints_v6.sql 12 Jun 2008 10:57:12 -0000 1.1.2.2
@@ -79,12 +79,6 @@
ALTER TABLE PhotoProfile ADD CONSTRAINT fk_PhotoProfile_objID_PhotoObjAl
FOREIGN KEY(objID)
REFERENCES PhotoObjAll (objID)
;
-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 Photoz ADD CONSTRAINT fk_Photoz_objID_PhotoObjAll_objI FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
;
U Skyserver_dropConstraints_v6.sql
Index: Skyserver_dropConstraints_v6.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_dropConstraints_v6.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- Skyserver_dropConstraints_v6.sql 27 May 2008 14:04:41 -0000 1.1.2.1
+++ Skyserver_dropConstraints_v6.sql 12 Jun 2008 10:57:15 -0000 1.1.2.2
@@ -52,10 +52,6 @@
;
ALTER TABLE PhotoProfile DROP CONSTRAINT fk_PhotoProfile_objID_PhotoObjAl
;
-ALTER TABLE PhotoTag DROP CONSTRAINT fk_PhotoTag_fieldID_Field_fieldI
-;
-ALTER TABLE PhotoTag DROP CONSTRAINT fk_PhotoTag_objID_PhotoObjAll_ob
-;
ALTER TABLE Photoz DROP CONSTRAINT fk_Photoz_objID_PhotoObjAll_objI
;
ALTER TABLE Photoz2 DROP CONSTRAINT fk_Photoz2_objID_PhotoObjAll_obj
-------------------------------------------------------------------------
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
