2 points..
1/ I changed the MySQL table and added a field "message_id int(32) unsigned
zerofill NOT NULL auto_increment,"
made it the PK, and the old key a UNIQUE which works without changing the
code, diff appended ..
2/ the latest mysql seems not to have this restriction anymore anyway.
cvs -z9 diff -u sqlResources.xml
Index: sqlResources.xml
===================================================================
RCS file: /home/cvspublic/jakarta-james/src/conf/sqlResources.xml,v
retrieving revision 1.3
diff -u -r1.3 sqlResources.xml
--- sqlResources.xml 2001/09/13 01:33:26 1.3
+++ sqlResources.xml 2001/09/25 11:55:28
@@ -116,6 +116,7 @@
<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_id int(32) unsigned zerofill NOT NULL auto_increment,
message_name varchar (200) NOT NULL,
repository_name varchar (200) NOT NULL,
message_state varchar (30) NOT NULL ,
@@ -126,7 +127,8 @@
remote_addr varchar (20) NOT NULL ,
message_body longblob NOT NULL ,
last_updated datetime NOT NULL,
- PRIMARY KEY (message, repository_name)
+ UNIQUE names (message_name,repository_name),
+ PRIMARY KEY (message_id)
)
</sql>
<sql name="createTable" db="mssql">
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
