Author: chirino
Date: Wed Feb 15 08:08:24 2006
New Revision: 378025

URL: http://svn.apache.org/viewcvs?rev=378025&view=rev
Log:
http://jira.activemq.org/jira/browse/AMQ-565

Modified:
    
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/AxionJDBCAdapter.java
    
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/DefaultStatementProvider.java

Modified: 
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/AxionJDBCAdapter.java
URL: 
http://svn.apache.org/viewcvs/incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/AxionJDBCAdapter.java?rev=378025&r1=378024&r2=378025&view=diff
==============================================================================
--- 
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/AxionJDBCAdapter.java
 (original)
+++ 
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/AxionJDBCAdapter.java
 Wed Feb 15 08:08:24 2006
@@ -43,6 +43,7 @@
                            +", PRIMARY KEY ( ID ) )",                          
                      "CREATE INDEX "+getTablePrefix()+messageTableName+"_MIDX 
ON "+getTablePrefix()+messageTableName+" (MSGID_PROD,MSGID_SEQ)",
                      "CREATE INDEX "+getTablePrefix()+messageTableName+"_CIDX 
ON "+getTablePrefix()+messageTableName+" (CONTAINER)",                          
             
+                     "CREATE INDEX "+getFullMessageTableName()+"_EIDX ON 
"+getFullMessageTableName()+" (EXPIRATION)",                 
                      "CREATE TABLE 
"+getTablePrefix()+durableSubAcksTableName+"("
                            +"CONTAINER "+containerNameDataType+" NOT NULL"
                            +", CLIENT_ID "+stringIdDataType+" NOT NULL"

Modified: 
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/DefaultStatementProvider.java
URL: 
http://svn.apache.org/viewcvs/incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/DefaultStatementProvider.java?rev=378025&r1=378024&r2=378025&view=diff
==============================================================================
--- 
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/DefaultStatementProvider.java
 (original)
+++ 
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/DefaultStatementProvider.java
 Wed Feb 15 08:08:24 2006
@@ -50,7 +50,8 @@
                                   +", MSG "+(useExternalMessageReferences ? 
stringIdDataType : binaryDataType)
                                   +", PRIMARY KEY ( ID ) )",                   
                           
             "CREATE INDEX "+getFullMessageTableName()+"_MIDX ON 
"+getFullMessageTableName()+" (MSGID_PROD,MSGID_SEQ)",
-            "CREATE INDEX "+getFullMessageTableName()+"_CIDX ON 
"+getFullMessageTableName()+" (CONTAINER)",                    
+            "CREATE INDEX "+getFullMessageTableName()+"_CIDX ON 
"+getFullMessageTableName()+" (CONTAINER)",            
+            "CREATE INDEX "+getFullMessageTableName()+"_EIDX ON 
"+getFullMessageTableName()+" (EXPIRATION)",                 
             "CREATE TABLE "+getTablePrefix()+durableSubAcksTableName+"("
                         +"CONTAINER "+containerNameDataType+" NOT NULL"
                         +", CLIENT_ID "+stringIdDataType+" NOT NULL"


Reply via email to