serge 2003/06/22 18:53:27
Modified: src/conf sqlResources.xml
Log:
Changed sql for MS SQL server from defining the mail/spool repositories with a
2-step create then alter table script, to just a single create table script like the
other DBs do.
Revision Changes Path
1.19 +4 -14 jakarta-james/src/conf/sqlResources.xml
Index: sqlResources.xml
===================================================================
RCS file: /home/cvs/jakarta-james/src/conf/sqlResources.xml,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -r1.18 -r1.19
--- sqlResources.xml 1 Jun 2003 00:02:03 -0000 1.18
+++ sqlResources.xml 23 Jun 2003 01:53:27 -0000 1.19
@@ -235,14 +235,9 @@
[remote_host] [varchar] (255) NOT NULL ,
[remote_addr] [varchar] (20) NOT NULL ,
[message_body] [image] NOT NULL ,
- [last_updated] [datetime] NOT NULL
+ [last_updated] [datetime] NOT NULL,
+ PRIMARY KEY (repository_name, message_name)
)
- ALTER TABLE [${table}] WITH NOCHECK ADD
- CONSTRAINT [PK_${table}] PRIMARY KEY
- (
- [repository_name],
- [message_name]
- )
</sql>
<sql name="createTable" db="oracle">
CREATE TABLE ${table} (
@@ -371,14 +366,9 @@
[remote_host] [varchar] (255) NOT NULL ,
[remote_addr] [varchar] (20) NOT NULL ,
[message_body] [image] NOT NULL ,
- [last_updated] [datetime] NOT NULL
+ [last_updated] [datetime] NOT NULL,
+ PRIMARY KEY (message_name, repository_name)
)
- ALTER TABLE [${table}] WITH NOCHECK ADD
- CONSTRAINT [PK_${table}] PRIMARY KEY
- (
- [message_name],
- [repository_name]
- )
</sql>
<sql name="createTable" db="oracle">
CREATE TABLE ${table} (
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
