[dbunit-commit] dbunit/src/sql mssql.sql,1.1,1.2

[<de...@us...>]

Update of /cvsroot/dbunit/dbunit/src/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv30474

Modified Files:
	mssql.sql 
Log Message:
Added new table for Identity not PK test.  Also, somehow missed all the PK constraints when I first committed the code!

Index: mssql.sql
===================================================================
RCS file: /cvsroot/dbunit/dbunit/src/sql/mssql.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mssql.sql	13 Dec 2002 21:41:33 -0000	1.1
--- mssql.sql	29 Jan 2003 13:04:57 -0000	1.2
***************
*** 27,30 ****
--- 27,34 ----
  GO
  
+ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TEST_IDENTITY_NOT_PK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+ drop table [dbo].[TEST_IDENTITY_NOT_PK]
+ GO
+ 
  CREATE TABLE [dbo].[EMPTY_MULTITYPE_TABLE] (
      [VARCHAR_COL] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
***************
*** 50,53 ****
--- 54,65 ----
  GO
  
+ ALTER TABLE dbo.IDENTITY_TABLE ADD CONSTRAINT
+   PK_IDENTITY_TABLE PRIMARY KEY CLUSTERED 
+   (
+   IDENTITY_TABLE_ID
+   ) ON [PRIMARY]
+ 
+ GO
+ 
  CREATE TABLE [dbo].[ONLY_PK_TABLE] (
      [PK0] [numeric](38, 0) NOT NULL 
***************
*** 55,58 ****
--- 67,78 ----
  GO
  
+ ALTER TABLE dbo.ONLY_PK_TABLE ADD CONSTRAINT
+   PK_ONLY_PK_TABLE PRIMARY KEY CLUSTERED 
+   (
+   PK0
+   ) ON [PRIMARY]
+ 
+ GO
+ 
  CREATE TABLE [dbo].[PK_TABLE] (
      [PK0] [numeric](38, 0) NOT NULL ,
***************
*** 63,66 ****
--- 83,95 ----
  ) ON [PRIMARY]
  GO
+ ALTER TABLE dbo.PK_TABLE ADD CONSTRAINT
+   PK_PK_TABLE PRIMARY KEY CLUSTERED 
+   (
+   PK0,
+   PK1,
+   PK2
+   ) ON [PRIMARY]
+ 
+ GO
  
  CREATE TABLE [dbo].[SECOND_TABLE] (
***************
*** 79,81 ****
  ) ON [PRIMARY]
  GO
! 
--- 108,115 ----
  ) ON [PRIMARY]
  GO
! CREATE TABLE dbo.TEST_IDENTITY_NOT_PK
!   (
!   COL01 int NOT NULL IDENTITY (1, 1),
!   COL02 varchar(64) NULL
!   )  ON [PRIMARY]
! GO