You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-dev@jakarta.apache.org by oz...@apache.org on 2004/05/11 12:02:50 UTC
cvs commit: jakarta-slide/src/conf/schema SybaseSchema.sql
ozeigermann 2004/05/11 03:02:50
Modified: src/conf/schema SybaseSchema.sql
Log:
Removed references to CHILDREN table that no longer exists
Revision Changes Path
1.2 +0 -11 jakarta-slide/src/conf/schema/SybaseSchema.sql
Index: SybaseSchema.sql
===================================================================
RCS file: /home/cvs/jakarta-slide/src/conf/schema/SybaseSchema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- SybaseSchema.sql 25 Feb 2004 09:13:20 -0000 1.1
+++ SybaseSchema.sql 11 May 2004 10:02:50 -0000 1.2
@@ -6,10 +6,6 @@
DROP TABLE OBJECT
GO
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'CHILDREN')
-DROP TABLE CHILDREN
-GO
-
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'BINDING')
DROP TABLE BINDING
GO
@@ -154,13 +150,6 @@
REFERENCES URI (URI_ID),
UNIQUE CLUSTERED (URI_ID, NAME, PARENT_UURI_ID)
)
-GO
-
-CREATE INDEX XCHILDREN1
- ON CHILDREN(URI_ID)
-GO
-CREATE INDEX XCHILDREN2
- ON CHILDREN(CHILD_URI_ID)
GO
-- early versions of Sybase do not allow more than 16 tables per query
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org