james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nor...@apache.org
Subject svn commit: r485705 - /james/server/trunk/src/conf/sqlResources.xml
Date Mon, 11 Dec 2006 15:21:41 GMT
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


Mime
View raw message