[otrs-cvs] ITSMConfigItem ITSMConfigItem.sopm,1.73,1.74

[CVS commits notifications of OTRS.org]

Comments:
Update of /home/cvs/ITSMConfigItem
In directory lancelot:/tmp/cvs-serv6802

Modified Files:
	ITSMConfigItem.sopm 
Log Message:
Fixed bug# 2841 - NameSearch fails in the VersionSearch() function.

Author: mh

Index: ITSMConfigItem.sopm
===================================================================
RCS file: /home/cvs/ITSMConfigItem/ITSMConfigItem.sopm,v
retrieving revision 1.73
retrieving revision 1.74
diff -C2 -d -r1.73 -r1.74
*** ITSMConfigItem.sopm	25 Apr 2008 16:11:13 -0000	1.73
--- ITSMConfigItem.sopm	2 May 2008 19:39:01 -0000	1.74
***************
*** 74,77 ****
--- 74,78 ----
              <Column Name="configitem_number" Required="true" Size="100" Type="VARCHAR"/>
              <Column Name="class_id" Required="true" Type="INTEGER"/>
+             <Column Name="last_version_id" Required="false" Type="BIGINT"/>
              <Column Name="cur_depl_state_id" Required="false" Type="INTEGER"/>
              <Column Name="cur_inci_state_id" Required="false" Type="INTEGER"/>
***************
*** 83,86 ****
--- 84,90 ----
                  <UniqueColumn Name="configitem_number"/>
              </Unique>
+             <Unique>
+                 <UniqueColumn Name="configitem_last_version_id"/>
+             </Unique>
              <Index Name="configitem_class_id">
                  <IndexColumn Name="class_id"/>
***************
*** 1364,1367 ****
--- 1368,1374 ----
              <ColumnChange NameOld="inci_state_id" NameNew="inci_state_id" Required="false" Type="INTEGER"/>
          </TableAlter>
+         <TableAlter Name="configitem" Version="1.0.96">
+             <ColumnAdd Name="last_version_id" Required="true" Type="BIGINT"/>
+         </TableAlter>
      </DatabaseUpgrade>
      <DatabaseUninstall>