Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/tool/Tool.hbm.xml
===================================================================
diff -u -r1dbf40946efb1324c987cccf44c18ad5559cdc53 -r98059cd516068af9c71148dbc4141f961e194d6d
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/tool/Tool.hbm.xml	(.../Tool.hbm.xml)	(revision 1dbf40946efb1324c987cccf44c18ad5559cdc53)
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/tool/Tool.hbm.xml	(.../Tool.hbm.xml)	(revision 98059cd516068af9c71148dbc4141f961e194d6d)
@@ -385,8 +385,23 @@
             length="1"
             not-null="true"
         </meta>    
-    </property>    
-
+    </property>
+    
+    <property
+        name="extLmsId"
+        type="java.lang.String"
+        column="ext_lms_id"
+        not-null="false"
+        length="255"
+    >
+    	<meta attribute="field-description">
+           name="extLmsId"
+	        type="java.lang.String"
+	        column="ext_lms_id"
+	        length="255"
+        </meta>
+    </property>
+    
     <!-- Associations -->
   
     <!-- bi-directional one-to-many association to Activity -->
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -rabdbcb3cf86ed9f5048624058123cb923d583f0c -r98059cd516068af9c71148dbc4141f961e194d6d
--- lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision abdbcb3cf86ed9f5048624058123cb923d583f0c)
+++ lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 98059cd516068af9c71148dbc4141f961e194d6d)
@@ -470,6 +470,7 @@
      , context_file VARCHAR(255)
      , admin_url TEXT
      , supports_outputs TINYINT(1) DEFAULT 0
+	 , ext_lms_id VARCHAR(255) DEFAULT NULL
      , UNIQUE UQ_lams_tool_sig (tool_signature)
      , UNIQUE UQ_lams_tool_class_name (service_name)
      , PRIMARY KEY (tool_id)