james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From se...@apache.org
Subject cvs commit: jakarta-james/src/conf sqlResources.xml
Date Thu, 13 Sep 2001 01:24:07 GMT
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: james-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-dev-help@jakarta.apache.org


Mime
View raw message