ozeigermann 2004/05/11 03:06:10
Modified: src/conf/schema Tag: SLIDE_2_0_RELEASE_BRANCH
SybaseSchema.sql
Log:
Removed references to CHILDREN table that no longer exists
Revision Changes Path
No revision
No revision
1.1.2.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.2.1
retrieving revision 1.1.2.2
diff -u -r1.1.2.1 -r1.1.2.2
--- SybaseSchema.sql 25 Feb 2004 09:15:12 -0000 1.1.2.1
+++ SybaseSchema.sql 11 May 2004 10:06:10 -0000 1.1.2.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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
