[otrs-cvs] otrs/scripts/database otrs-schema.xml,1.76,1.77
CVS commits notifications of OTRS.org
cvs-log at otrs.org
Tue May 6 22:10:22 GMT 2008
Comments:
Update of /home/cvs/otrs/scripts/database
In directory lancelot:/tmp/cvs-serv15664/scripts/database
Modified Files:
otrs-schema.xml
Log Message:
Added missing indexes and foreign keys.
Author: martin
Index: otrs-schema.xml
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.xml,v
retrieving revision 1.76
retrieving revision 1.77
diff -C2 -d -r1.76 -r1.77
*** otrs-schema.xml 25 Apr 2008 12:58:47 -0000 1.76
--- otrs-schema.xml 6 May 2008 22:10:16 -0000 1.77
***************
*** 119,123 ****
<Column Name="preferences_key" Required="true" Size="150" Type="VARCHAR"/>
<Column Name="preferences_value" Required="false" Size="250" Type="VARCHAR"/>
! <Index Name="index_user_preferences_user_id">
<IndexColumn Name="user_id"/>
</Index>
--- 119,123 ----
<Column Name="preferences_key" Required="true" Size="150" Type="VARCHAR"/>
<Column Name="preferences_value" Required="false" Size="250" Type="VARCHAR"/>
! <Index Name="user_preferences_user_id">
<IndexColumn Name="user_id"/>
</Index>
***************
*** 159,162 ****
--- 159,168 ----
<Column Name="change_time" Required="true" Type="DATE"/>
<Column Name="change_by" Required="true" Type="INTEGER"/>
+ <Index Name="group_user_user_id">
+ <IndexColumn Name="user_id"/>
+ </Index>
+ <Index Name="group_user_group_id">
+ <IndexColumn Name="group_id"/>
+ </Index>
<ForeignKey ForeignTable="system_user">
<Reference Local="create_by" Foreign="id"/>
***************
*** 179,182 ****
--- 185,194 ----
<Column Name="change_time" Required="true" Type="DATE"/>
<Column Name="change_by" Required="true" Type="INTEGER"/>
+ <Index Name="group_role_role_id">
+ <IndexColumn Name="role_id"/>
+ </Index>
+ <Index Name="group_role_group_id">
+ <IndexColumn Name="group_id"/>
+ </Index>
<ForeignKey ForeignTable="system_user">
<Reference Local="create_by" Foreign="id"/>
***************
*** 201,204 ****
--- 213,222 ----
<Column Name="change_time" Required="true" Type="DATE"/>
<Column Name="change_by" Required="true" Type="INTEGER"/>
+ <Index Name="group_customer_user_id">
+ <IndexColumn Name="user_id"/>
+ </Index>
+ <Index Name="group_customer_user_group_id">
+ <IndexColumn Name="group_id"/>
+ </Index>
<ForeignKey ForeignTable="system_user">
<Reference Local="create_by" Foreign="id"/>
***************
*** 240,243 ****
--- 258,267 ----
<Column Name="change_time" Required="true" Type="DATE"/>
<Column Name="change_by" Required="true" Type="INTEGER"/>
+ <Index Name="role_user_user_id">
+ <IndexColumn Name="user_id"/>
+ </Index>
+ <Index Name="role_user_role_id">
+ <IndexColumn Name="role_id"/>
+ </Index>
<ForeignKey ForeignTable="system_user">
<Reference Local="create_by" Foreign="id"/>
***************
*** 251,254 ****
--- 275,284 ----
<Column Name="user_id" Required="true" Type="INTEGER"/>
<Column Name="queue_id" Required="true" Type="INTEGER"/>
+ <Index Name="personal_queues_user_id">
+ <IndexColumn Name="user_id"/>
+ </Index>
+ <Index Name="personal_queues_queue_id">
+ <IndexColumn Name="queue_id"/>
+ </Index>
<ForeignKey ForeignTable="system_user">
<Reference Local="user_id" Foreign="id"/>
***************
*** 449,452 ****
--- 479,485 ----
<UniqueColumn Name="name"/>
</Unique>
+ <Index Name="queue_group_id">
+ <IndexColumn Name="group_id"/>
+ </Index>
<ForeignKey ForeignTable="valid">
<Reference Local="valid_id" Foreign="id"/>
***************
*** 478,482 ****
<Column Name="preferences_key" Required="true" Size="150" Type="VARCHAR"/>
<Column Name="preferences_value" Required="false" Size="250" Type="VARCHAR"/>
! <Index Name="index_queue_preferences_user_id">
<IndexColumn Name="queue_id"/>
</Index>
--- 511,515 ----
<Column Name="preferences_key" Required="true" Size="150" Type="VARCHAR"/>
<Column Name="preferences_value" Required="false" Size="250" Type="VARCHAR"/>
! <Index Name="queue_preferences_queue_id">
<IndexColumn Name="queue_id"/>
</Index>
***************
*** 560,575 ****
<UniqueColumn Name="tn"/>
</Unique>
! <Index Name="index_ticket_queue_view">
<IndexColumn Name="ticket_state_id"/>
<IndexColumn Name="ticket_lock_id"/>
<IndexColumn Name="group_id"/>
</Index>
! <Index Name="index_ticket_type">
<IndexColumn Name="type_id"/>
</Index>
! <Index Name="index_ticket_user">
<IndexColumn Name="user_id"/>
</Index>
! <Index Name="index_ticket_answered">
<IndexColumn Name="ticket_answered"/>
</Index>
--- 593,632 ----
<UniqueColumn Name="tn"/>
</Unique>
! <Index Name="ticket_title">
! <IndexColumn Name="title"/>
! </Index>
! <Index Name="ticket_customer_user_id">
! <IndexColumn Name="customer_user_id"/>
! </Index>
! <Index Name="ticket_customer_id">
! <IndexColumn Name="customer_id"/>
! </Index>
! <Index Name="ticket_queue_id">
! <IndexColumn Name="queue_id"/>
! </Index>
! <Index Name="ticket_ticket_lock_id">
! <IndexColumn Name="lock_id"/>
! </Index>
! <Index Name="ticket_queue_view">
<IndexColumn Name="ticket_state_id"/>
<IndexColumn Name="ticket_lock_id"/>
<IndexColumn Name="group_id"/>
</Index>
! <Index Name="ticket_type_id">
<IndexColumn Name="type_id"/>
</Index>
! <Index Name="ticket_user_id">
<IndexColumn Name="user_id"/>
</Index>
! <Index Name="ticket_responsible_user_id">
! <IndexColumn Name="responsible_user_id"/>
! </Index>
! <Index Name="ticket_ticket_state_id">
! <IndexColumn Name="ticket_state_id"/>
! </Index>
! <Index Name="ticket_ticket_priority_id">
! <IndexColumn Name="ticket_priority_id"/>
! </Index>
! <Index Name="ticket_answered">
<IndexColumn Name="ticket_answered"/>
</Index>
***************
*** 613,616 ****
--- 670,688 ----
<Column Name="object_link_b_object" Required="true" Size="200" Type="VARCHAR"/>
<Column Name="object_link_type" Required="true" Size="200" Type="VARCHAR"/>
+ <Index Name="object_link_a_id">
+ <IndexColumn Name="object_link_a_id"/>
+ </Index>
+ <Index Name="object_link_b_id">
+ <IndexColumn Name="object_link_b_id"/>
+ </Index>
+ <Index Name="object_link_a_object">
+ <IndexColumn Name="object_link_a_object"/>
+ </Index>
+ <Index Name="object_link_b_object">
+ <IndexColumn Name="object_link_b_object"/>
+ </Index>
+ <Index Name="object_link_type">
+ <IndexColumn Name="object_link_type"/>
+ </Index>
</Table>
***************
*** 635,638 ****
--- 707,731 ----
<IndexColumn Name="ticket_id"/>
</Index>
+ <Index Name="ticket_history_history_type_id">
+ <IndexColumn Name="history_type_id"/>
+ </Index>
+ <Index Name="ticket_history_queue_id">
+ <IndexColumn Name="queue_id"/>
+ </Index>
+ <Index Name="ticket_history_type_id">
+ <IndexColumn Name="type_id"/>
+ </Index>
+ <Index Name="ticket_history_owner_id">
+ <IndexColumn Name="owner_id"/>
+ </Index>
+ <Index Name="ticket_history_priority_id">
+ <IndexColumn Name="priority_id"/>
+ </Index>
+ <Index Name="ticket_history_state_id">
+ <IndexColumn Name="state_id"/>
+ </Index>
+ <Index Name="ticket_history_priority_id">
+ <IndexColumn Name="priority_id"/>
+ </Index>
<Index Name="ticket_history_create_time">
<IndexColumn Name="create_time"/>
***************
*** 782,785 ****
--- 875,884 ----
<IndexColumn Name="ticket_id"/>
</Index>
+ <Index Name="article_article_type_id">
+ <IndexColumn Name="article_type_id"/>
+ </Index>
+ <Index Name="article_article_sender_type_id">
+ <IndexColumn Name="article_sender_type_id"/>
+ </Index>
<Index Name="article_message_id">
<IndexColumn Name="a_message_id" Size="255"/>
***************
*** 1024,1028 ****
<Column Name="change_time" Required="true" Type="DATE"/>
<Column Name="change_by" Required="true" Type="INTEGER"/>
! <Index Name="index_time_accounting_ticket_id">
<IndexColumn Name="ticket_id"/>
</Index>
--- 1123,1127 ----
<Column Name="change_time" Required="true" Type="DATE"/>
<Column Name="change_by" Required="true" Type="INTEGER"/>
! <Index Name="time_accounting_ticket_id">
<IndexColumn Name="ticket_id"/>
</Index>
***************
*** 1050,1053 ****
--- 1149,1163 ----
<IndexColumn Name="ticket_id"/>
</Index>
+ <Index Name="ticket_watcher_user_id">
+ <IndexColumn Name="user_id"/>
+ </Index>
+ <ForeignKey ForeignTable="ticket">
+ <Reference Local="ticket_id" Foreign="id"/>
+ </ForeignKey>
+ <ForeignKey ForeignTable="system_user">
+ <Reference Local="user_id" Foreign="id"/>
+ <Reference Local="create_by" Foreign="id"/>
+ <Reference Local="change_by" Foreign="id"/>
+ </ForeignKey>
</Table>
***************
*** 1083,1086 ****
--- 1193,1199 ----
<IndexColumn Name="service_id"/>
</Index>
+ <ForeignKey ForeignTable="service">
+ <Reference Local="service_id" Foreign="id"/>
+ </ForeignKey>
<ForeignKey ForeignTable="system_user">
<Reference Local="create_by" Foreign="id"/>
***************
*** 1120,1126 ****
<!-- sessions -->
<Table Name="sessions">
! <Column Name="session_id" Required="true" Size="150" Type="VARCHAR"/>
<Column Name="session_value" Required="true" Size="10000" Type="VARCHAR"/>
! <Index Name="index_session_id">
<IndexColumn Name="session_id"/>
</Index>
--- 1233,1239 ----
<!-- sessions -->
<Table Name="sessions">
! <Column Name="session_id" Required="true" Size="150" PrimaryKey="true" Type="VARCHAR"/>
<Column Name="session_value" Required="true" Size="10000" Type="VARCHAR"/>
! <Index Name="sessions_session_id">
<IndexColumn Name="session_id"/>
</Index>
***************
*** 1136,1142 ****
<Column Name="s_state" Required="true" Size="70" Type="VARCHAR"/>
<Column Name="create_time_unix" Required="true" Type="BIGINT"/>
! <Index Name="index_ticket_index_ticket_id">
<IndexColumn Name="ticket_id"/>
</Index>
</Table>
--- 1249,1270 ----
<Column Name="s_state" Required="true" Size="70" Type="VARCHAR"/>
<Column Name="create_time_unix" Required="true" Type="BIGINT"/>
! <Index Name="ticket_index_ticket_id">
<IndexColumn Name="ticket_id"/>
</Index>
+ <Index Name="ticket_index_queue_id">
+ <IndexColumn Name="queue_id"/>
+ </Index>
+ <Index Name="ticket_index_group_id">
+ <IndexColumn Name="group_id"/>
+ </Index>
+ <ForeignKey ForeignTable="ticket">
+ <Reference Local="ticket_id" Foreign="id"/>
+ </ForeignKey>
+ <ForeignKey ForeignTable="queue">
+ <Reference Local="queue_id" Foreign="id"/>
+ </ForeignKey>
+ <ForeignKey ForeignTable="groups">
+ <Reference Local="group_id" Foreign="id"/>
+ </ForeignKey>
</Table>
***************
*** 1144,1150 ****
<Table Name="ticket_lock_index">
<Column Name="ticket_id" Required="true" Type="BIGINT"/>
! <Index Name="index_ticket_lock_ticket_id">
<IndexColumn Name="ticket_id"/>
</Index>
</Table>
--- 1272,1281 ----
<Table Name="ticket_lock_index">
<Column Name="ticket_id" Required="true" Type="BIGINT"/>
! <Index Name="ticket_lock_index_ticket_id">
<IndexColumn Name="ticket_id"/>
</Index>
+ <ForeignKey ForeignTable="ticket">
+ <Reference Local="ticket_id" Foreign="id"/>
+ </ForeignKey>
</Table>
***************
*** 1182,1186 ****
<Column Name="preferences_key" Required="true" Size="150" Type="VARCHAR"/>
<Column Name="preferences_value" Required="false" Size="250" Type="VARCHAR"/>
! <Index Name="index_customer_preferences_user_id">
<IndexColumn Name="user_id"/>
</Index>
--- 1313,1317 ----
<Column Name="preferences_key" Required="true" Size="150" Type="VARCHAR"/>
<Column Name="preferences_value" Required="false" Size="250" Type="VARCHAR"/>
! <Index Name="customer_preferences_user_id">
<IndexColumn Name="user_id"/>
</Index>
***************
*** 1214,1221 ****
<Column Name="sent_to" Required="true" Size="250" Type="VARCHAR"/>
<Column Name="sent_date" Required="true" Size="150" Type="VARCHAR"/>
! <Index Name="index_ticket_loop_protection_sent_to">
<IndexColumn Name="sent_to"/>
</Index>
! <Index Name="index_ticket_loop_protection_sent_date">
<IndexColumn Name="sent_date"/>
</Index>
--- 1345,1352 ----
<Column Name="sent_to" Required="true" Size="250" Type="VARCHAR"/>
<Column Name="sent_date" Required="true" Size="150" Type="VARCHAR"/>
! <Index Name="ticket_loop_protection_sent_to">
<IndexColumn Name="sent_to"/>
</Index>
! <Index Name="ticket_loop_protection_sent_date">
<IndexColumn Name="sent_date"/>
</Index>
***************
*** 1252,1255 ****
--- 1383,1389 ----
<Column Name="f_key" Required="true" Size="200" Type="VARCHAR"/>
<Column Name="f_value" Required="true" Size="200" Type="VARCHAR"/>
+ <Index Name="postmaster_filter_f_name">
+ <IndexColumn Name="f_name"/>
+ </Index>
</Table>
***************
*** 1259,1262 ****
--- 1393,1399 ----
<Column Name="job_key" Required="true" Size="200" Type="VARCHAR"/>
<Column Name="job_value" Required="false" Size="200" Type="VARCHAR"/>
+ <Index Name="generic_agent_job_name">
+ <IndexColumn Name="job_name"/>
+ </Index>
</Table>
***************
*** 1268,1271 ****
--- 1405,1412 ----
<Column Name="profile_key" Required="true" Size="200" Type="VARCHAR"/>
<Column Name="profile_value" Required="false" Size="200" Type="VARCHAR"/>
+ <Index Name="search_profile_login_name">
+ <IndexColumn Name="login"/>
+ <IndexColumn Name="profile_name"/>
+ </Index>
</Table>
More information about the cvs-log
mailing list