[otrs-cvs] FAQ FAQ.sopm,1.125,1.126

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

Modified Files:
	FAQ.sopm 
Log Message:
Fixed bug# 7806 - Missing FAQ-Item valid/invalid column in the database.

Author: ub

Index: FAQ.sopm
===================================================================
RCS file: /home/cvs/FAQ/FAQ.sopm,v
retrieving revision 1.125
retrieving revision 1.126
diff -2 -u -d -r1.125 -r1.126
--- FAQ.sopm	6 Dec 2012 13:14:38 -0000	1.125
+++ FAQ.sopm	2 Jan 2013 11:13:01 -0000	1.126
@@ -200,4 +200,7 @@
                 <IndexColumn Name="valid_id"/>
             </Index>
+            <ForeignKey ForeignTable="valid">
+                <Reference Local="valid_id" Foreign="id"/>
+            </ForeignKey>
         </TableCreate>
         <Insert Table="faq_category">
@@ -232,4 +235,5 @@
             <Column Name="category_id" Required="true" Type="SMALLINT"/>
             <Column Name="approved" Required="true" Default="1" Type="SMALLINT"/>
+            <Column Name="valid_id" Required="true" Default="1" Type="SMALLINT"/>
             <Column Name="f_keywords" Required="false" Size="400" Type="VARCHAR"/>
             <Column Name="f_field1" Required="false" Size="20000" Type="VARCHAR"/>
@@ -249,4 +253,10 @@
                 <IndexColumn Name="category_id"/>
             </Index>
+            <Index Name="faq_item_valid_id">
+                <IndexColumn Name="valid_id"/>
+            </Index>
+            <ForeignKey ForeignTable="valid">
+                <Reference Local="valid_id" Foreign="id"/>
+            </ForeignKey>
         </TableCreate>
         <TableCreate Name="faq_history">
@@ -398,4 +408,18 @@
             </IndexCreate>
         </TableAlter>
+        <TableAlter Name="faq_category" Version="2.1.93">
+            <ForeignKeyCreate ForeignTable="valid">
+                <Reference Local="valid_id" Foreign="id"/>
+            </ForeignKeyCreate>
+        </TableAlter>
+        <TableAlter Name="faq_item" Version="2.1.93">
+            <ColumnAdd Name="valid_id" Required="true" Default="1" Type="SMALLINT"/>
+            <IndexCreate Name="faq_item_valid_id">
+                <IndexColumn Name="valid_id"/>
+            </IndexCreate>
+            <ForeignKeyCreate ForeignTable="valid">
+                <Reference Local="valid_id" Foreign="id"/>
+            </ForeignKeyCreate>
+        </TableAlter>
     </DatabaseUpgrade>
     <DatabaseUninstall Type="pre">
---------------------------------------------------------------------
OTRS mailing list: cvs-log - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/cvs-log
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/cvs-log