[Hyperic-hq-discuss] hq r14239 - in trunk: installer/data sql/appdef

[<rm...@hy...>]

Author: rmorgan
Date: 2010-01-27 15:30:35 -0800 (Wed, 27 Jan 2010)
New Revision: 14239
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=14239

Modified:
   trunk/installer/data/db-upgrade.xml
   trunk/sql/appdef/Service.hbm.xml
Log:
[HHQ-3695] Increase service autoinventoryidentifier to 500 characters, matching the limit of EAM_RESOURCE.name

Modified: trunk/installer/data/db-upgrade.xml
===================================================================
--- trunk/installer/data/db-upgrade.xml	2010-01-27 22:18:45 UTC (rev 14238)
+++ trunk/installer/data/db-upgrade.xml	2010-01-27 23:30:35 UTC (rev 14239)
@@ -10879,6 +10879,12 @@
                         precision="2048" columnType="VARCHAR2" nullable="NOT NULL" />
   </schemaSpec>
 
+  <!-- Increase autoinventoryidentifier to limit of 500 (per name in EAM_RESOURCE) -->
+  <schemaSpec version="3.194"> 
+    <schema-alterColumn table="EAM_SERVICE" column="autoinventoryidentifier"
+                        precision="500" columnType="VARCHAR2" />
+  </schemaSpec>
+
 </dbupgrade>
 </target>
 </project>

Modified: trunk/sql/appdef/Service.hbm.xml
===================================================================
--- trunk/sql/appdef/Service.hbm.xml	2010-01-27 22:18:45 UTC (rev 14238)
+++ trunk/sql/appdef/Service.hbm.xml	2010-01-27 23:30:35 UTC (rev 14239)
@@ -61,7 +61,7 @@
         <column name="SERVER_ID" not-null="false" index="EAM_SERVICE_AIID_IDX"/>
       </many-to-one>
       <property name="autoinventoryIdentifier" type="string">
-        <column name="AUTOINVENTORYIDENTIFIER" not-null="false" length="250" index="EAM_SERVICE_AIID_IDX"/>
+        <column name="AUTOINVENTORYIDENTIFIER" not-null="false" length="500" index="EAM_SERVICE_AIID_IDX"/>
       </property>
     </properties>