[otrs-cvs] FAQ FAQ.sopm,1.123,1.124
"CVS commits notifications of OTRS.org" <[email protected]>
| Newsgroups | gmane.comp.otrs.cvs |
|---|---|
| Message-ID | <[email protected]> |
Comments:
Update of /home/cvs/FAQ
In directory lancelot:/tmp/cvs-serv4577
Modified Files:
FAQ.sopm
Log Message:
Added database indizes to improve performance.
Author: mh
Index: FAQ.sopm
===================================================================
RCS file: /home/cvs/FAQ/FAQ.sopm,v
retrieving revision 1.123
retrieving revision 1.124
diff -2 -u -d -r1.123 -r1.124
--- FAQ.sopm 26 Oct 2012 23:13:01 -0000 1.123
+++ FAQ.sopm 6 Dec 2012 10:09:26 -0000 1.124
@@ -177,4 +177,7 @@
<UniqueColumn Name="name"/>
</Unique>
+ <Index Name="faq_state_type_id">
+ <IndexColumn Name="type_id"/>
+ </Index>
</TableCreate>
<TableCreate Name="faq_category">
@@ -188,4 +191,13 @@
<Column Name="changed" Required="true" Type="DATE"/>
<Column Name="changed_by" Required="true" Type="INTEGER"/>
+ <Index Name="faq_category_parent_id">
+ <IndexColumn Name="parent_id"/>
+ </Index>
+ <Index Name="faq_category_name">
+ <IndexColumn Name="name"/>
+ </Index>
+ <Index Name="faq_category_valid_id">
+ <IndexColumn Name="valid_id"/>
+ </Index>
</TableCreate>
<Insert Table="faq_category">
@@ -207,4 +219,7 @@
<Column Name="changed" Required="false" Type="DATE"/>
<Column Name="changed_by" Required="false" Type="INTEGER"/>
+ <Index Name="faq_category_group_category_id">
+ <IndexColumn Name="category_id"/>
+ </Index>
</TableCreate>
<TableCreate Name="faq_item">
@@ -228,4 +243,13 @@
<Column Name="changed" Required="true" Type="DATE"/>
<Column Name="changed_by" Required="true" Type="INTEGER"/>
+ <Index Name="faq_item_state_id">
+ <IndexColumn Name="state_id"/>
+ </Index>
+ <Index Name="faq_item_category_id">
+ <IndexColumn Name="category_id"/>
+ </Index>
+ <Index Name="faq_item_f_keywords">
+ <IndexColumn Name="f_keywords"/>
+ </Index>
</TableCreate>
<TableCreate Name="faq_history">
@@ -237,4 +261,7 @@
<Column Name="changed" Required="true" Type="DATE"/>
<Column Name="changed_by" Required="true" Type="INTEGER"/>
+ <Index Name="faq_history_item_id">
+ <IndexColumn Name="item_id"/>
+ </Index>
</TableCreate>
<Insert Table="faq_history">
@@ -258,5 +285,5 @@
<Column Name="changed" Required="true" Type="DATE"/>
<Column Name="changed_by" Required="true" Type="INTEGER"/>
- <Index Name="faq_id">
+ <Index Name="faq_attachment_faq_id">
<IndexColumn Name="faq_id"/>
</Index>
@@ -270,4 +297,7 @@
<Column Name="rate" Required="true" Type="INTEGER"/>
<Column Name="created" Required="false" Type="DATE"/>
+ <Index Name="faq_voting">
+ <IndexColumn Name="item_id"/>
+ </Index>
</TableCreate>
<TableCreate Name="faq_log">
@@ -278,5 +308,5 @@
<Column Name="user_agent" Required="false" Size="200" Type="VARCHAR"/>
<Column Name="created" Required="true" Type="DATE"/>
- <Index Name="item_id">
+ <Index Name="faq_log_item_id">
<IndexColumn Name="item_id"/>
</Index>
@@ -320,4 +350,58 @@
<ColumnDrop Name="free_value4"/>
</TableAlter>
+ <TableAlter Name="faq_state" Version="2.1.92">
+ <IndexCreate Name="faq_state_type_id">
+ <IndexColumn Name="type_id"/>
+ </IndexCreate>
+ </TableAlter>
+ <TableAlter Name="faq_category" Version="2.1.92">
+ <IndexCreate Name="faq_category_parent_id">
+ <IndexColumn Name="parent_id"/>
+ </IndexCreate>
+ <IndexCreate Name="faq_category_name">
+ <IndexColumn Name="name"/>
+ </IndexCreate>
+ <IndexCreate Name="faq_category_valid_id">
+ <IndexColumn Name="valid_id"/>
+ </IndexCreate>
+ </TableAlter>
+ <TableAlter Name="faq_category_group" Version="2.1.92">
+ <IndexCreate Name="faq_category_group_category_id">
+ <IndexColumn Name="category_id"/>
+ </IndexCreate>
+ </TableAlter>
+ <TableAlter Name="faq_item" Version="2.1.92">
+ <IndexCreate Name="faq_item_state_id">
+ <IndexColumn Name="state_id"/>
+ </IndexCreate>
+ <IndexCreate Name="faq_item_category_id">
+ <IndexColumn Name="category_id"/>
+ </IndexCreate>
+ <IndexCreate Name="faq_item_f_keywords">
+ <IndexColumn Name="f_keywords"/>
+ </IndexCreate>
+ </TableAlter>
+ <TableAlter Name="faq_history" Version="2.1.92">
+ <IndexCreate Name="faq_history_item_id">
+ <IndexColumn Name="item_id"/>
+ </IndexCreate>
+ </TableAlter>
+ <TableAlter Name="faq_attachment" Version="2.1.92">
+ <IndexDrop Name="faq_id"/>
+ <IndexCreate Name="faq_attachment_faq_id">
+ <IndexColumn Name="faq_id"/>
+ </IndexCreate>
+ </TableAlter>
+ <TableAlter Name="faq_voting" Version="2.1.92">
+ <IndexCreate Name="faq_voting">
+ <IndexColumn Name="item_id"/>
+ </IndexCreate>
+ </TableAlter>
+ <TableAlter Name="faq_log" Version="2.1.92">
+ <IndexDrop Name="item_id"/>
+ <IndexCreate Name="faq_log_item_id">
+ <IndexColumn Name="item_id"/>
+ </IndexCreate>
+ </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