You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by no...@apache.org on 2006/12/11 16:21:41 UTC
svn commit: r485705 - /james/server/trunk/src/conf/sqlResources.xml
Author: norman
Date: Mon Dec 11 07:21:40 2006
New Revision: 485705
URL: http://svn.apache.org/viewvc?view=rev&rev=485705
Log:
Add postgresql support for creating vut table. Thx to Kev Jackson. See JAMES-731
Modified:
james/server/trunk/src/conf/sqlResources.xml
Modified: james/server/trunk/src/conf/sqlResources.xml
URL: http://svn.apache.org/viewvc/james/server/trunk/src/conf/sqlResources.xml?view=diff&rev=485705&r1=485704&r2=485705
==============================================================================
--- james/server/trunk/src/conf/sqlResources.xml (original)
+++ james/server/trunk/src/conf/sqlResources.xml Mon Dec 11 07:21:40 2006
@@ -1051,7 +1051,7 @@
PRIMARY KEY (user,domain)
)
</sql>
- <sql name="createTable" db="postgresql">
+ <sql name="createTable" db="sapdb">
CREATE TABLE VirtualUserTable (
user varchar(64) NOT NULL default '',
domain varchar(255) NOT NULL default '',
@@ -1059,7 +1059,7 @@
PRIMARY KEY (user,domain)
)
</sql>
- <sql name="createTable" db="sapdb">
+ <sql name="createTable" db="db2">
CREATE TABLE VirtualUserTable (
user varchar(64) NOT NULL default '',
domain varchar(255) NOT NULL default '',
@@ -1067,7 +1067,7 @@
PRIMARY KEY (user,domain)
)
</sql>
- <sql name="createTable" db="db2">
+ <sql name="createTable" db="ingres">
CREATE TABLE VirtualUserTable (
user varchar(64) NOT NULL default '',
domain varchar(255) NOT NULL default '',
@@ -1075,15 +1075,15 @@
PRIMARY KEY (user,domain)
)
</sql>
- <sql name="createTable" db="ingres">
+ -->
+ <sql name="createTable" db="postgresql">
CREATE TABLE VirtualUserTable (
- user varchar(64) NOT NULL default '',
+ "user" varchar(64) NOT NULL default '',
domain varchar(255) NOT NULL default '',
target_address varchar(255) NOT NULL default '',
- PRIMARY KEY (user,domain)
+ PRIMARY KEY ("user",domain)
)
</sql>
- -->
<sql name="createTable" db="derby">
CREATE TABLE VirtualUserTable (
"user" varchar (64) NOT NULL default '',
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org