[otrs-cvs] otrs/scripts/database/update otrs-upgrade-to-2.3.xml, 1.2, 1.3

[CVS commits notifications of OTRS.org]

Comments:
Update of /home/cvs/otrs/scripts/database/update
In directory lancelot:/tmp/cvs-serv15746/scripts/database/update

Modified Files:
	otrs-upgrade-to-2.3.xml 
Log Message:
Added missing indexes for 2.3.

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.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** otrs-upgrade-to-2.3.xml	29 Apr 2008 23:44:41 -0000	1.2
--- otrs-upgrade-to-2.3.xml	6 May 2008 22:12:48 -0000	1.3
***************
*** 48,51 ****
--- 48,60 ----
      </TableAlter>
  
+     <TableAlter Name="role_user">
+         <IndexCreate Name="role_user_user_id">
+             <IndexColumn Name="user_id"/>
+         </IndexCreate>
+         <IndexCreate Name="role_user_role_id">
+             <IndexColumn Name="role_id"/>
+         </IndexCreate>
+     </TableAlter>
+ 
      <TableAlter Name="personal_queues">
          <IndexCreate Name="personal_queues_user_id">
***************
*** 79,85 ****
--- 88,103 ----
              <IndexColumn Name="queue_id"/>
          </IndexCreate>
+         <IndexCreate Name="ticket_ticket_lock_id">
+             <IndexColumn Name="lock_id"/>
+         </IndexCreate>
          <IndexCreate Name="ticket_responsible_user_id">
              <IndexColumn Name="responsible_user_id"/>
          </IndexCreate>
+         <IndexCreate Name="ticket_ticket_state_id">
+             <IndexColumn Name="ticket_state_id"/>
+         </IndexCreate>
+         <IndexCreate Name="ticket_ticket_priority_id">
+             <IndexColumn Name="ticket_priority_id"/>
+         </IndexCreate>
      </TableAlter>
  
***************
*** 124,130 ****
              <IndexColumn Name="priority_id"/>
          </IndexCreate>
-         <IndexCreate Name="ticket_history_state_id">
-             <IndexColumn Name="state_id"/>
-         </IndexCreate>
      </TableAlter>
  
--- 142,145 ----
***************
*** 159,162 ****
--- 174,180 ----
  
      <TableAlter Name="ticket_index">
+         <IndexCreate Name="ticket_index_queue_id">
+             <IndexColumn Name="queue_id"/>
+         </IndexCreate>
          <IndexCreate Name="ticket_index_group_id">
              <IndexColumn Name="group_id"/>