serge 2003/06/22 17:56:12
Modified: src/conf Tag: branch_2_1_fcs 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
No revision
No revision
1.16.4.4 +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.16.4.3
retrieving revision 1.16.4.4
diff -u -r1.16.4.3 -r1.16.4.4
--- sqlResources.xml 31 May 2003 23:37:39 -0000 1.16.4.3
+++ sqlResources.xml 23 Jun 2003 00:56:12 -0000 1.16.4.4
@@ -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 (repository_name, message_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]
