svn commit: r425971 - /incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java

[jlim]

Author: jlim
Date: Wed Jul 26 23:25:29 2006
New Revision: 425971

URL: http://svn.apache.org/viewvc?rev=425971&view=rev
Log:
added NOT NULL contraint for ID column in ACTIVEMQ_LOCK table

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

Modified: 
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
URL: 
http://svn.apache.org/viewvc/incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java?rev=425971&r1=425970&r2=425971&view=diff
==============================================================================
--- 
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
 (original)
+++ 
incubator/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
 Wed Jul 26 23:25:29 2006
@@ -80,7 +80,7 @@
                             + ", CLIENT_ID " + stringIdDataType + " NOT NULL" 
+ ", SUB_NAME " + stringIdDataType
                             + " NOT NULL" + ", SELECTOR " + stringIdDataType + 
", LAST_ACKED_ID " + sequenceDataType
                             + ", PRIMARY KEY ( CONTAINER, CLIENT_ID, 
SUB_NAME))", 
-                    "CREATE TABLE " + getFullLockTableName() + "( ID " + 
longDataType + ", TIME " + longDataType 
+                    "CREATE TABLE " + getFullLockTableName() + "( ID " + 
longDataType + " NOT NULL, TIME " + longDataType 
                             + ", BROKER_NAME " + stringIdDataType + ", PRIMARY 
KEY (ID) )",
                     "INSERT INTO " + getFullLockTableName() + "(ID) VALUES 
(1)", 
             };