ozeigermann 2003/11/19 03:46:36
Modified: proposals/stores/org/apache/slide/store/impl/rdbms
SQLServerSchema.sql
Log:
Added unique constraint to URI_STRING in table URI - thanks to Martin Holz
Submitted by: Martin Holz
Revision Changes Path
1.2 +1 -1
jakarta-slide/proposals/stores/org/apache/slide/store/impl/rdbms/SQLServerSchema.sql
Index: SQLServerSchema.sql
===================================================================
RCS file:
/home/cvs/jakarta-slide/proposals/stores/org/apache/slide/store/impl/rdbms/SQLServerSchema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- SQLServerSchema.sql 14 Nov 2003 12:28:27 -0000 1.1
+++ SQLServerSchema.sql 19 Nov 2003 11:46:36 -0000 1.2
@@ -125,7 +125,7 @@
CREATE TABLE dbo.URI (
URI_ID id_type IDENTITY UNIQUE NOT NULL,
- URI_STRING uri_str_type NOT NULL,
+ URI_STRING uri_str_type UNIQUE NOT NULL,
-- UNIQUE NONCLUSTERED (URI_ID)
)
GO
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
