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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
