james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From se...@apache.org
Subject cvs commit: jakarta-james/src/conf sqlResources.xml
Date Thu, 13 Sep 2001 01:33:26 GMT
serge       01/09/12 18:33:26

  Modified:    src/conf sqlResources.xml
  Log:
  Simplified mssql SQL syntax, and fixed how 2 field primary keys were defined.
  
  Revision  Changes    Path
  1.3       +11 -4     jakarta-james/src/conf/sqlResources.xml
  
  Index: sqlResources.xml
  ===================================================================
  RCS file: /home/cvs/jakarta-james/src/conf/sqlResources.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- sqlResources.xml	2001/09/13 01:24:07	1.2
  +++ sqlResources.xml	2001/09/13 01:33:26	1.3
  @@ -130,9 +130,9 @@
           )
       </sql>
       <sql name="createTable" db="mssql">
  -        CREATE TABLE [dbo].[${table}] (
  -        	[message_name] [varchar] (200) NOT NULL PRIMARY KEY,
  -        	[repository_name] [varchar] (200) NOT NULL PRIMARY KEY,
  +        CREATE TABLE [${table}] (
  +        	[message_name] [varchar] (200) NOT NULL,
  +        	[repository_name] [varchar] (200) NOT NULL,
           	[message_state] [varchar] (30) NOT NULL ,
           	[error_message] [varchar] (1000) NULL ,
           	[sender] [varchar] (200) NULL ,
  @@ -141,7 +141,14 @@
           	[remote_addr] [varchar] (20) NOT NULL ,
           	[message_body] [image] NOT NULL ,
           	[last_updated] [datetime] NOT NULL
  -        ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  +        )
  +		ALTER TABLE [${table}] WITH NOCHECK ADD
  +			CONSTRAINT [PK_${table}] PRIMARY KEY
  +			(
  +				[message_name],
  +				[repository_name]
  +			)
  +
       </sql>
   </sqlDefs>
   
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-dev-help@jakarta.apache.org


Mime
View raw message