serge 01/09/12 18:24:07
Modified: src/conf sqlResources.xml
Log:
Changed mysql and mssql create table statements for mail repository.
Revision Changes Path
1.2 +5 -4 jakarta-james/src/conf/sqlResources.xml
Index: sqlResources.xml
===================================================================
RCS file: /home/cvs/jakarta-james/src/conf/sqlResources.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- sqlResources.xml 2001/09/11 04:29:30 1.1
+++ sqlResources.xml 2001/09/13 01:24:07 1.2
@@ -116,8 +116,8 @@
<sql name="listMessagesSQL">SELECT message_name, message_state, last_updated
FROM ${table} WHERE repository_name = ? ORDER BY last_updated ASC</sql>
<sql name="createTable" db="mysql">
CREATE TABLE ${table} (
- message_name varchar (200) NOT NULL PRIMARY KEY,
- repository_name varchar (200) NOT NULL PRIMARY KEY,
+ message_name varchar (200) NOT NULL,
+ repository_name varchar (200) NOT NULL,
message_state varchar (30) NOT NULL ,
error_message varchar (200) NULL ,
sender varchar (200) NULL ,
@@ -125,13 +125,14 @@
remote_host varchar (100) NOT NULL ,
remote_addr varchar (20) NOT NULL ,
message_body longblob NOT NULL ,
- last_updated datetime NOT NULL
+ last_updated datetime NOT NULL,
+ PRIMARY KEY (message, repository_name)
)
</sql>
<sql name="createTable" db="mssql">
CREATE TABLE [dbo].[${table}] (
[message_name] [varchar] (200) NOT NULL PRIMARY KEY,
- [repository_name] [varchar] (200) NOT NULL,
+ [repository_name] [varchar] (200) NOT NULL PRIMARY KEY,
[message_state] [varchar] (30) NOT NULL ,
[error_message] [varchar] (1000) NULL ,
[sender] [varchar] (200) NULL ,
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
