[otrs-cvs] otrs/scripts/database/update otrs-upgrade-to-2.3.xml, 1.1, 1.2
CVS commits notifications of OTRS.org
cvs-log at otrs.org
Tue Apr 29 23:44:46 GMT 2008
- Previous message: [otrs-cvs] otrs/Kernel/Modules CustomerTicketSearch.pm,1.31,1.32
- Next message: [otrs-cvs] otrs/scripts DBUpdate-to-2.3-schema.db2.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.maxdb.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.mssql.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.mysql.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.oracle.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.postgresql.sql, 1.2, 1.3
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
Comments:
Update of /home/cvs/otrs/scripts/database/update
In directory lancelot:/tmp/cvs-serv9683/scripts/database/update
Modified Files:
otrs-upgrade-to-2.3.xml
Log Message:
Added missing indexes and foreign keys.
Author: martin
Index: otrs-upgrade-to-2.3.xml
===================================================================
RCS file: /home/cvs/otrs/scripts/database/update/otrs-upgrade-to-2.3.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** otrs-upgrade-to-2.3.xml 11 Feb 2008 12:03:58 -0000 1.1
--- otrs-upgrade-to-2.3.xml 29 Apr 2008 23:44:41 -0000 1.2
***************
*** 15,22 ****
--- 15,130 ----
</TableCreate>
+ <TableAlter Name="user_preferences">
+ <IndexCreate Name="user_preferences_user_id">
+ <IndexColumn Name="user_id"/>
+ </IndexCreate>
+ </TableAlter>
+
+ <TableAlter Name="group_user">
+ <IndexCreate Name="group_user_user_id">
+ <IndexColumn Name="user_id"/>
+ </IndexCreate>
+ <IndexCreate Name="group_user_group_id">
+ <IndexColumn Name="group_id"/>
+ </IndexCreate>
+ </TableAlter>
+
+ <TableAlter Name="group_role">
+ <IndexCreate Name="group_role_role_id">
+ <IndexColumn Name="role_id"/>
+ </IndexCreate>
+ <IndexCreate Name="group_role_group_id">
+ <IndexColumn Name="group_id"/>
+ </IndexCreate>
+ </TableAlter>
+
+ <TableAlter Name="group_customer_user">
+ <IndexCreate Name="group_customer_user_id">
+ <IndexColumn Name="user_id"/>
+ </IndexCreate>
+ <IndexCreate Name="group_customer_user_group_id">
+ <IndexColumn Name="group_id"/>
+ </IndexCreate>
+ </TableAlter>
+
+ <TableAlter Name="personal_queues">
+ <IndexCreate Name="personal_queues_user_id">
+ <IndexColumn Name="user_id"/>
+ </IndexCreate>
+ <IndexCreate Name="personal_queues_queue_id">
+ <IndexColumn Name="queue_id"/>
+ </IndexCreate>
+ </TableAlter>
+
<TableAlter Name="queue">
<ColumnAdd Name="first_response_notify" Required="false" Type="SMALLINT"/>
<ColumnAdd Name="update_notify" Required="false" Type="SMALLINT"/>
<ColumnAdd Name="solution_notify" Required="false" Type="SMALLINT"/>
+ <IndexCreate Name="queue_group_id">
+ <IndexColumn Name="group_id"/>
+ </IndexCreate>
+ </TableAlter>
+
+ <TableAlter Name="ticket">
+ <IndexCreate Name="ticket_title">
+ <IndexColumn Name="title"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_customer_user_id">
+ <IndexColumn Name="customer_user_id"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_customer_id">
+ <IndexColumn Name="customer_id"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_queue_id">
+ <IndexColumn Name="queue_id"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_responsible_user_id">
+ <IndexColumn Name="responsible_user_id"/>
+ </IndexCreate>
+ </TableAlter>
+
+ <TableAlter Name="object_link">
+ <IndexCreate Name="index_object_link_a_id">
+ <IndexColumn Name="object_link_a_id"/>
+ </IndexCreate>
+ <IndexCreate Name="index_object_link_b_id">
+ <IndexColumn Name="object_link_b_id"/>
+ </IndexCreate>
+ <IndexCreate Name="index_object_link_a_object">
+ <IndexColumn Name="object_link_a_object"/>
+ </IndexCreate>
+ <IndexCreate Name="index_object_link_b_object">
+ <IndexColumn Name="object_link_b_object"/>
+ </IndexCreate>
+ <IndexCreate Name="index_object_link_type">
+ <IndexColumn Name="object_link_type"/>
+ </IndexCreate>
+ </TableAlter>
+
+ <TableAlter Name="ticket_history">
+ <IndexCreate Name="ticket_history_history_type_id">
+ <IndexColumn Name="history_type_id"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_history_queue_id">
+ <IndexColumn Name="queue_id"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_history_type_id">
+ <IndexColumn Name="type_id"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_history_owner_id">
+ <IndexColumn Name="owner_id"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_history_priority_id">
+ <IndexColumn Name="priority_id"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_history_state_id">
+ <IndexColumn Name="state_id"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_history_priority_id">
+ <IndexColumn Name="priority_id"/>
+ </IndexCreate>
+ <IndexCreate Name="ticket_history_state_id">
+ <IndexColumn Name="state_id"/>
+ </IndexCreate>
</TableAlter>
***************
*** 28,31 ****
--- 136,194 ----
<TableAlter Name="article">
+ <IndexCreate Name="article_article_type_id">
+ <IndexColumn Name="article_type_id"/>
+ </IndexCreate>
+ <IndexCreate Name="article_sender_type_id">
+ <IndexColumn Name="article_sender_type_id"/>
+ </IndexCreate>
+ </TableAlter>
+
+ <TableAlter Name="ticket_watcher">
+ <IndexCreate Name="ticket_watcher_user_id">
+ <IndexColumn Name="user_id"/>
+ </IndexCreate>
+ <ForeignKeyCreate ForeignTable="ticket">
+ <Reference Local="ticket_id" Foreign="id"/>
+ </ForeignKeyCreate>
+ <ForeignKeyCreate ForeignTable="system_user">
+ <Reference Local="user_id" Foreign="id"/>
+ <Reference Local="create_by" Foreign="id"/>
+ <Reference Local="change_by" Foreign="id"/>
+ </ForeignKeyCreate>
+ </TableAlter>
+
+ <TableAlter Name="ticket_index">
+ <IndexCreate Name="ticket_index_group_id">
+ <IndexColumn Name="group_id"/>
+ </IndexCreate>
+ <ForeignKeyCreate ForeignTable="ticket">
+ <Reference Local="ticket_id" Foreign="id"/>
+ </ForeignKeyCreate>
+ <ForeignKeyCreate ForeignTable="queue">
+ <Reference Local="queue_id" Foreign="id"/>
+ </ForeignKeyCreate>
+ <ForeignKeyCreate ForeignTable="groups">
+ <Reference Local="group_id" Foreign="id"/>
+ </ForeignKeyCreate>
+ </TableAlter>
+
+ <TableAlter Name="postmaster_filter">
+ <IndexCreate Name="postmaster_filter_f_name">
+ <IndexColumn Name="f_name"/>
+ </IndexCreate>
+ </TableAlter>
+
+ <TableAlter Name="generic_agent_jobs">
+ <IndexCreate Name="generic_agent_job_name">
+ <IndexColumn Name="job_name"/>
+ </IndexCreate>
+ </TableAlter>
+
+
+ <TableAlter NameNew="mail_account" NameOld="pop3_account">
+ <ColumnAdd Name="account_type" Required="false" Size="20" Type="VARCHAR"/>
+ </TableAlter>
+
+ <TableAlter Name="article">
<ColumnChange NameOld="a_body" NameNew="a_body" Required="true" Size="1800000" Type="VARCHAR"/>
</TableAlter>
- Previous message: [otrs-cvs] otrs/Kernel/Modules CustomerTicketSearch.pm,1.31,1.32
- Next message: [otrs-cvs] otrs/scripts DBUpdate-to-2.3-schema.db2.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.maxdb.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.mssql.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.mysql.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.oracle.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.postgresql.sql, 1.2, 1.3
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
More information about the cvs-log
mailing list