Interesting. Do you really even need a primary key in this case? Doesn't
seem like you're using it.
Serge Knystautas
Loki Technologies
http://www.lokitech.com/
----- Original Message -----
From: "Danny Angus" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 7:58 AM
Subject: RE: Bug in MySQL JDBC sqlResources table creation statement
> 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]
