[otrs-cvs] FAQ FAQ.sopm,1.20,1.21

[cvs-log at otrs.org]

Comments:
Update of /home/cvs/FAQ
In directory lancelot:/tmp/cvs-serv27423

Modified Files:
	FAQ.sopm 
Log Message:
Added database upgrade for version 1.1.*

Author: rk

Index: FAQ.sopm
===================================================================
RCS file: /home/cvs/FAQ/FAQ.sopm,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -d -r1.20 -r1.21
*** FAQ.sopm	10 Apr 2007 10:54:25 -0000	1.20
--- FAQ.sopm	10 Apr 2007 12:51:15 -0000	1.21
***************
*** 201,204 ****
--- 201,215 ----
          </TableCreate>
      </DatabaseInstall>
+     <DatabaseUpgrade>
+         <TableCreate Name="faq_category_group" Version="1.1.3">
+             <Column Name="id" Required="true" PrimaryKey="true" AutoIncrement="true" Type="INTEGER"/>
+             <Column Name="category_id" Required="true" Size="200" Type="INTEGER"/>
+             <Column Name="group_id" Required="true" Type="INTEGER"/>
+             <Column Name="created" Required="false" Type="DATE"/>
+             <Column Name="created_by" Required="false" Type="INTEGER"/>
+             <Column Name="changed" Required="false" Type="DATE"/>
+             <Column Name="changed_by" Required="false" Type="INTEGER"/>
+         </TableCreate>
+     </DatabaseUpgrade>
      <DatabaseUninstall>
          <TableDrop Name="faq_category"/>