[otrs-cvs] otrs/scripts/database otrs-schema.db2.sql, 1.25, 1.26 otrs-schema.maxdb.sql, 1.26, 1.27 otrs-schema.mssql.sql, 1.20, 1.21 otrs-schema.mysql.sql, 1.66, 1.67 otrs-schema.oracle.sql, 1.31, 1.32 otrs-schema.postgresql.sql, 1.64, 1.65 otrs-schema.xml, 1.77, 1.78

CVS commits notifications of OTRS.org cvs-log at otrs.org
Tue May 6 22:46:54 GMT 2008 

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

Modified Files:
	otrs-schema.db2.sql otrs-schema.maxdb.sql 
	otrs-schema.mssql.sql otrs-schema.mysql.sql 
	otrs-schema.oracle.sql otrs-schema.postgresql.sql 
	otrs-schema.xml 
Log Message:
Added sort fot index order.

Author: martin

Index: otrs-schema.db2.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.db2.sql,v
retrieving revision 1.25
retrieving revision 1.26
diff -C2 -d -r1.25 -r1.26
*** otrs-schema.db2.sql	6 May 2008 22:28:17 -0000	1.25
--- otrs-schema.db2.sql	6 May 2008 22:46:49 -0000	1.26
***************
*** 1,4 ****
  -- ----------------------------------------------------------
! --  driver: db2, generated: 2008-05-07 00:18:07
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
--- 1,4 ----
  -- ----------------------------------------------------------
! --  driver: db2, generated: 2008-05-07 00:43:00
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
***************
*** 139,146 ****
  );
  
- CREATE INDEX group_role_rolab ON group_role (role_id);
- 
  CREATE INDEX group_role_gro4d ON group_role (group_id);
  
  -- ----------------------------------------------------------
  --  create table group_customer_user
--- 139,146 ----
  );
  
  CREATE INDEX group_role_gro4d ON group_role (group_id);
  
+ CREATE INDEX group_role_rolab ON group_role (role_id);
+ 
  -- ----------------------------------------------------------
  --  create table group_customer_user
***************
*** 446,460 ****
  );
  
! CREATE INDEX ticket_ticket_67 ON ticket (ticket_state_id);
! 
! CREATE INDEX ticket_ticket_36 ON ticket (ticket_priority_id);
! 
! CREATE INDEX ticket_user_id ON ticket (user_id);
  
  CREATE INDEX ticket_custome8e ON ticket (customer_id);
  
! CREATE INDEX ticket_answered ON ticket (ticket_answered);
  
! CREATE INDEX ticket_type_id ON ticket (type_id);
  
  CREATE INDEX ticket_queue_v8a ON ticket (ticket_state_id, ticket_lock_id, group_id);
--- 446,456 ----
  );
  
! CREATE INDEX ticket_answered ON ticket (ticket_answered);
  
  CREATE INDEX ticket_custome8e ON ticket (customer_id);
  
! CREATE INDEX ticket_custome8e ON ticket (customer_user_id);
  
! CREATE INDEX ticket_queue_id ON ticket (queue_id);
  
  CREATE INDEX ticket_queue_v8a ON ticket (ticket_state_id, ticket_lock_id, group_id);
***************
*** 462,472 ****
  CREATE INDEX ticket_responsbe ON ticket (responsible_user_id);
  
! CREATE INDEX ticket_custome8e ON ticket (customer_user_id);
  
! CREATE INDEX ticket_ticket_20 ON ticket (lock_id);
  
  CREATE INDEX ticket_title ON ticket (title);
  
! CREATE INDEX ticket_queue_id ON ticket (queue_id);
  
  -- ----------------------------------------------------------
--- 458,472 ----
  CREATE INDEX ticket_responsbe ON ticket (responsible_user_id);
  
! CREATE INDEX ticket_ticket_20 ON ticket (ticket_lock_id);
  
! CREATE INDEX ticket_ticket_36 ON ticket (ticket_priority_id);
! 
! CREATE INDEX ticket_ticket_67 ON ticket (ticket_state_id);
  
  CREATE INDEX ticket_title ON ticket (title);
  
! CREATE INDEX ticket_type_id ON ticket (type_id);
! 
! CREATE INDEX ticket_user_id ON ticket (user_id);
  
  -- ----------------------------------------------------------
***************
*** 481,493 ****
  );
  
! CREATE INDEX object_link_b_ae ON object_link (object_link_b_object);
  
! CREATE INDEX object_link_b_05 ON object_link (object_link_b_id);
  
! CREATE INDEX object_link_ty89 ON object_link (object_link_type);
  
! CREATE INDEX object_link_a_93 ON object_link (object_link_a_object);
  
! CREATE INDEX object_link_a_e1 ON object_link (object_link_a_id);
  
  -- ----------------------------------------------------------
--- 481,493 ----
  );
  
! CREATE INDEX object_link_a_e1 ON object_link (object_link_a_id);
  
! CREATE INDEX object_link_a_93 ON object_link (object_link_a_object);
  
! CREATE INDEX object_link_b_05 ON object_link (object_link_b_id);
  
! CREATE INDEX object_link_b_ae ON object_link (object_link_b_object);
  
! CREATE INDEX object_link_ty89 ON object_link (object_link_type);
  
  -- ----------------------------------------------------------
***************
*** 513,530 ****
  );
  
  CREATE INDEX ticket_history36 ON ticket_history (history_type_id);
  
  CREATE INDEX ticket_historyf6 ON ticket_history (owner_id);
  
- CREATE INDEX ticket_historyee ON ticket_history (ticket_id);
- 
  CREATE INDEX ticket_history68 ON ticket_history (priority_id, priority_id);
  
- CREATE INDEX ticket_historyaa ON ticket_history (create_time);
- 
  CREATE INDEX ticket_history32 ON ticket_history (queue_id);
  
  CREATE INDEX ticket_history68 ON ticket_history (state_id);
  
  CREATE INDEX ticket_history01 ON ticket_history (type_id);
  
--- 513,530 ----
  );
  
+ CREATE INDEX ticket_historyaa ON ticket_history (create_time);
+ 
  CREATE INDEX ticket_history36 ON ticket_history (history_type_id);
  
  CREATE INDEX ticket_historyf6 ON ticket_history (owner_id);
  
  CREATE INDEX ticket_history68 ON ticket_history (priority_id, priority_id);
  
  CREATE INDEX ticket_history32 ON ticket_history (queue_id);
  
  CREATE INDEX ticket_history68 ON ticket_history (state_id);
  
+ CREATE INDEX ticket_historyee ON ticket_history (ticket_id);
+ 
  CREATE INDEX ticket_history01 ON ticket_history (type_id);
  
***************
*** 587,594 ****
  );
  
- CREATE INDEX article_flag_cfa ON article_flag (create_by);
- 
  CREATE INDEX article_flag_a1e ON article_flag (article_id);
  
  -- ----------------------------------------------------------
  --  create table article
--- 587,594 ----
  );
  
  CREATE INDEX article_flag_a1e ON article_flag (article_id);
  
+ CREATE INDEX article_flag_cfa ON article_flag (create_by);
+ 
  -- ----------------------------------------------------------
  --  create table article
***************
*** 625,632 ****
  CREATE INDEX article_articl72 ON article (article_sender_type_id);
  
- CREATE INDEX article_messag11 ON article (a_message_id);
- 
  CREATE INDEX article_articlf7 ON article (article_type_id);
  
  CREATE INDEX article_ticketc5 ON article (ticket_id);
  
--- 625,632 ----
  CREATE INDEX article_articl72 ON article (article_sender_type_id);
  
  CREATE INDEX article_articlf7 ON article (article_type_id);
  
+ CREATE INDEX article_messag11 ON article (a_message_id);
+ 
  CREATE INDEX article_ticketc5 ON article (ticket_id);
  
***************
*** 893,900 ****
  CREATE INDEX ticket_index_g22 ON ticket_index (group_id);
  
- CREATE INDEX ticket_index_t6d ON ticket_index (ticket_id);
- 
  CREATE INDEX ticket_index_q1c ON ticket_index (queue_id);
  
  -- ----------------------------------------------------------
  --  create table ticket_lock_index
--- 893,900 ----
  CREATE INDEX ticket_index_g22 ON ticket_index (group_id);
  
  CREATE INDEX ticket_index_q1c ON ticket_index (queue_id);
  
+ CREATE INDEX ticket_index_t6d ON ticket_index (ticket_id);
+ 
  -- ----------------------------------------------------------
  --  create table ticket_lock_index
***************
*** 956,961 ****
      change_time TIMESTAMP NOT NULL,
      change_by INTEGER NOT NULL,
!     UNIQUE (customer_id),
!     UNIQUE (name)
  );
  
--- 956,961 ----
      change_time TIMESTAMP NOT NULL,
      change_by INTEGER NOT NULL,
!     UNIQUE (name),
!     UNIQUE (customer_id)
  );
  
***************
*** 968,975 ****
  );
  
- CREATE INDEX ticket_loop_pr29 ON ticket_loop_protection (sent_to);
- 
  CREATE INDEX ticket_loop_pr3b ON ticket_loop_protection (sent_date);
  
  -- ----------------------------------------------------------
  --  create table mail_account
--- 968,975 ----
  );
  
  CREATE INDEX ticket_loop_pr3b ON ticket_loop_protection (sent_date);
  
+ CREATE INDEX ticket_loop_pr29 ON ticket_loop_protection (sent_to);
+ 
  -- ----------------------------------------------------------
  --  create table mail_account
***************
*** 1077,1084 ****
  );
  
- CREATE INDEX xml_storage_xm68 ON xml_storage (xml_content_key);
- 
  CREATE INDEX xml_storage_ke77 ON xml_storage (xml_key, xml_type);
  
  -- ----------------------------------------------------------
  --  create table package_repository
--- 1077,1084 ----
  );
  
  CREATE INDEX xml_storage_ke77 ON xml_storage (xml_key, xml_type);
  
+ CREATE INDEX xml_storage_xm68 ON xml_storage (xml_content_key);
+ 
  -- ----------------------------------------------------------
  --  create table package_repository

Author: martin

Index: otrs-schema.maxdb.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.maxdb.sql,v
retrieving revision 1.26
retrieving revision 1.27
diff -C2 -d -r1.26 -r1.27
*** otrs-schema.maxdb.sql	6 May 2008 22:28:17 -0000	1.26
--- otrs-schema.maxdb.sql	6 May 2008 22:46:49 -0000	1.27
***************
*** 1,4 ****
  // ----------------------------------------------------------
! //  driver: maxdb, generated: 2008-05-07 00:18:08
  // ----------------------------------------------------------
  // ----------------------------------------------------------
--- 1,4 ----
  // ----------------------------------------------------------
! //  driver: maxdb, generated: 2008-05-07 00:43:00
  // ----------------------------------------------------------
  // ----------------------------------------------------------
***************
*** 95,99 ****
  )
  //
! CREATE INDEX user_preferences_use6 ON user_preferences (user_id)
  //
  // ----------------------------------------------------------
--- 95,99 ----
  )
  //
! CREATE INDEX user_preferences_use15 ON user_preferences (user_id)
  //
  // ----------------------------------------------------------
***************
*** 148,155 ****
  )
  //
- CREATE INDEX group_role_role_id ON group_role (role_id)
- //
  CREATE INDEX group_role_group_id ON group_role (group_id)
  //
  // ----------------------------------------------------------
  //  create table group_customer_user
--- 148,155 ----
  )
  //
  CREATE INDEX group_role_group_id ON group_role (group_id)
  //
+ CREATE INDEX group_role_role_id ON group_role (role_id)
+ //
  // ----------------------------------------------------------
  //  create table group_customer_user
***************
*** 167,173 ****
  )
  //
! CREATE INDEX group_customer_user_47 ON group_customer_user (group_id)
  //
! CREATE INDEX group_customer_user_19 ON group_customer_user (user_id)
  //
  // ----------------------------------------------------------
--- 167,173 ----
  )
  //
! CREATE INDEX group_customer_user_38 ON group_customer_user (group_id)
  //
! CREATE INDEX group_customer_user_20 ON group_customer_user (user_id)
  //
  // ----------------------------------------------------------
***************
*** 214,220 ****
  )
  //
! CREATE INDEX personal_queues_queu18 ON personal_queues (queue_id)
  //
! CREATE INDEX personal_queues_user95 ON personal_queues (user_id)
  //
  // ----------------------------------------------------------
--- 214,220 ----
  )
  //
! CREATE INDEX personal_queues_queu24 ON personal_queues (queue_id)
  //
! CREATE INDEX personal_queues_user88 ON personal_queues (user_id)
  //
  // ----------------------------------------------------------
***************
*** 389,393 ****
  )
  //
! CREATE INDEX queue_preferences_qu53 ON queue_preferences (queue_id)
  //
  // ----------------------------------------------------------
--- 389,393 ----
  )
  //
! CREATE INDEX queue_preferences_qu23 ON queue_preferences (queue_id)
  //
  // ----------------------------------------------------------
***************
*** 469,495 ****
  )
  //
! CREATE INDEX ticket_ticket_state_98 ON ticket (ticket_state_id)
! //
! CREATE INDEX ticket_ticket_priori34 ON ticket (ticket_priority_id)
! //
! CREATE INDEX ticket_user_id ON ticket (user_id)
  //
  CREATE INDEX ticket_customer_id ON ticket (customer_id)
  //
! CREATE INDEX ticket_answered ON ticket (ticket_answered)
  //
! CREATE INDEX ticket_type_id ON ticket (type_id)
  //
  CREATE INDEX ticket_queue_view ON ticket (ticket_state_id, ticket_lock_id, group_id)
  //
! CREATE INDEX ticket_responsible_u93 ON ticket (responsible_user_id)
  //
! CREATE INDEX ticket_customer_user25 ON ticket (customer_user_id)
  //
! CREATE INDEX ticket_ticket_lock_i35 ON ticket (lock_id)
  //
  CREATE INDEX ticket_title ON ticket (title)
  //
! CREATE INDEX ticket_queue_id ON ticket (queue_id)
  //
  // ----------------------------------------------------------
--- 469,495 ----
  )
  //
! CREATE INDEX ticket_answered ON ticket (ticket_answered)
  //
  CREATE INDEX ticket_customer_id ON ticket (customer_id)
  //
! CREATE INDEX ticket_customer_user51 ON ticket (customer_user_id)
  //
! CREATE INDEX ticket_queue_id ON ticket (queue_id)
  //
  CREATE INDEX ticket_queue_view ON ticket (ticket_state_id, ticket_lock_id, group_id)
  //
! CREATE INDEX ticket_responsible_u61 ON ticket (responsible_user_id)
  //
! CREATE INDEX ticket_ticket_lock_i98 ON ticket (ticket_lock_id)
  //
! CREATE INDEX ticket_ticket_priori38 ON ticket (ticket_priority_id)
! //
! CREATE INDEX ticket_ticket_state_23 ON ticket (ticket_state_id)
  //
  CREATE INDEX ticket_title ON ticket (title)
  //
! CREATE INDEX ticket_type_id ON ticket (type_id)
! //
! CREATE INDEX ticket_user_id ON ticket (user_id)
  //
  // ----------------------------------------------------------
***************
*** 505,517 ****
  )
  //
! CREATE INDEX object_link_b_object42 ON object_link (object_link_b_object)
  //
! CREATE INDEX object_link_b_id ON object_link (object_link_b_id)
  //
! CREATE INDEX object_link_type ON object_link (object_link_type)
  //
! CREATE INDEX object_link_a_object70 ON object_link (object_link_a_object)
  //
! CREATE INDEX object_link_a_id ON object_link (object_link_a_id)
  //
  // ----------------------------------------------------------
--- 505,517 ----
  )
  //
! CREATE INDEX object_link_a_id ON object_link (object_link_a_id)
  //
! CREATE INDEX object_link_a_object3 ON object_link (object_link_a_object)
  //
! CREATE INDEX object_link_b_id ON object_link (object_link_b_id)
  //
! CREATE INDEX object_link_b_object53 ON object_link (object_link_b_object)
  //
! CREATE INDEX object_link_type ON object_link (object_link_type)
  //
  // ----------------------------------------------------------
***************
*** 538,556 ****
  )
  //
! CREATE INDEX ticket_history_histo59 ON ticket_history (history_type_id)
  //
! CREATE INDEX ticket_history_owner14 ON ticket_history (owner_id)
  //
! CREATE INDEX ticket_history_ticke48 ON ticket_history (ticket_id)
  //
! CREATE INDEX ticket_history_prior9 ON ticket_history (priority_id, priority_id)
  //
! CREATE INDEX ticket_history_creat25 ON ticket_history (create_time)
  //
! CREATE INDEX ticket_history_queue93 ON ticket_history (queue_id)
  //
! CREATE INDEX ticket_history_state78 ON ticket_history (state_id)
  //
! CREATE INDEX ticket_history_type_15 ON ticket_history (type_id)
  //
  // ----------------------------------------------------------
--- 538,556 ----
  )
  //
! CREATE INDEX ticket_history_creat96 ON ticket_history (create_time)
  //
! CREATE INDEX ticket_history_histo14 ON ticket_history (history_type_id)
  //
! CREATE INDEX ticket_history_owner32 ON ticket_history (owner_id)
  //
! CREATE INDEX ticket_history_prior89 ON ticket_history (priority_id, priority_id)
  //
! CREATE INDEX ticket_history_queue74 ON ticket_history (queue_id)
  //
! CREATE INDEX ticket_history_state87 ON ticket_history (state_id)
  //
! CREATE INDEX ticket_history_ticke89 ON ticket_history (ticket_id)
  //
! CREATE INDEX ticket_history_type_72 ON ticket_history (type_id)
  //
  // ----------------------------------------------------------
***************
*** 616,622 ****
  )
  //
! CREATE INDEX article_flag_create_0 ON article_flag (create_by)
  //
! CREATE INDEX article_flag_article56 ON article_flag (article_id)
  //
  // ----------------------------------------------------------
--- 616,622 ----
  )
  //
! CREATE INDEX article_flag_article8 ON article_flag (article_id)
  //
! CREATE INDEX article_flag_create_75 ON article_flag (create_by)
  //
  // ----------------------------------------------------------
***************
*** 653,661 ****
  )
  //
! CREATE INDEX article_article_send6 ON article (article_sender_type_id)
  //
! CREATE INDEX article_message_id ON article (a_message_id)
  //
! CREATE INDEX article_article_type45 ON article (article_type_id)
  //
  CREATE INDEX article_ticket_id ON article (ticket_id)
--- 653,661 ----
  )
  //
! CREATE INDEX article_article_send92 ON article (article_sender_type_id)
  //
! CREATE INDEX article_article_type67 ON article (article_type_id)
  //
! CREATE INDEX article_message_id ON article (a_message_id)
  //
  CREATE INDEX article_ticket_id ON article (ticket_id)
***************
*** 676,680 ****
  )
  //
! CREATE INDEX article_plain_articl87 ON article_plain (article_id)
  //
  // ----------------------------------------------------------
--- 676,680 ----
  )
  //
! CREATE INDEX article_plain_articl68 ON article_plain (article_id)
  //
  // ----------------------------------------------------------
***************
*** 696,700 ****
  )
  //
! CREATE INDEX article_attachment_a34 ON article_attachment (article_id)
  //
  // ----------------------------------------------------------
--- 696,700 ----
  )
  //
! CREATE INDEX article_attachment_a53 ON article_attachment (article_id)
  //
  // ----------------------------------------------------------
***************
*** 835,839 ****
  )
  //
! CREATE INDEX time_accounting_tick19 ON time_accounting (ticket_id)
  //
  // ----------------------------------------------------------
--- 835,839 ----
  )
  //
! CREATE INDEX time_accounting_tick77 ON time_accounting (ticket_id)
  //
  // ----------------------------------------------------------
***************
*** 850,856 ****
  )
  //
! CREATE INDEX ticket_watcher_ticke79 ON ticket_watcher (ticket_id)
  //
! CREATE INDEX ticket_watcher_user_61 ON ticket_watcher (user_id)
  //
  // ----------------------------------------------------------
--- 850,856 ----
  )
  //
! CREATE INDEX ticket_watcher_ticke70 ON ticket_watcher (ticket_id)
  //
! CREATE INDEX ticket_watcher_user_77 ON ticket_watcher (user_id)
  //
  // ----------------------------------------------------------
***************
*** 882,888 ****
  )
  //
! CREATE INDEX service_customer_use89 ON service_customer_user (customer_user_login)
  //
! CREATE INDEX service_customer_use93 ON service_customer_user (service_id)
  //
  // ----------------------------------------------------------
--- 882,888 ----
  )
  //
! CREATE INDEX service_customer_use66 ON service_customer_user (customer_user_login)
  //
! CREATE INDEX service_customer_use35 ON service_customer_user (service_id)
  //
  // ----------------------------------------------------------
***************
*** 937,945 ****
  )
  //
! CREATE INDEX ticket_index_group_i18 ON ticket_index (group_id)
  //
! CREATE INDEX ticket_index_ticket_15 ON ticket_index (ticket_id)
  //
! CREATE INDEX ticket_index_queue_i75 ON ticket_index (queue_id)
  //
  // ----------------------------------------------------------
--- 937,945 ----
  )
  //
! CREATE INDEX ticket_index_group_i68 ON ticket_index (group_id)
  //
! CREATE INDEX ticket_index_queue_i79 ON ticket_index (queue_id)
  //
! CREATE INDEX ticket_index_ticket_35 ON ticket_index (ticket_id)
  //
  // ----------------------------------------------------------
***************
*** 951,955 ****
  )
  //
! CREATE INDEX ticket_lock_index_ti57 ON ticket_lock_index (ticket_id)
  //
  // ----------------------------------------------------------
--- 951,955 ----
  )
  //
! CREATE INDEX ticket_lock_index_ti25 ON ticket_lock_index (ticket_id)
  //
  // ----------------------------------------------------------
***************
*** 986,990 ****
  )
  //
! CREATE INDEX customer_preferences18 ON customer_preferences (user_id)
  //
  // ----------------------------------------------------------
--- 986,990 ----
  )
  //
! CREATE INDEX customer_preferences70 ON customer_preferences (user_id)
  //
  // ----------------------------------------------------------
***************
*** 1006,1011 ****
      change_time timestamp NOT NULL,
      change_by INTEGER NOT NULL,
!     UNIQUE (customer_id),
!     UNIQUE (name)
  )
  //
--- 1006,1011 ----
      change_time timestamp NOT NULL,
      change_by INTEGER NOT NULL,
!     UNIQUE (name),
!     UNIQUE (customer_id)
  )
  //
***************
*** 1019,1025 ****
  )
  //
! CREATE INDEX ticket_loop_protecti45 ON ticket_loop_protection (sent_to)
  //
! CREATE INDEX ticket_loop_protecti83 ON ticket_loop_protection (sent_date)
  //
  // ----------------------------------------------------------
--- 1019,1025 ----
  )
  //
! CREATE INDEX ticket_loop_protecti90 ON ticket_loop_protection (sent_date)
  //
! CREATE INDEX ticket_loop_protecti83 ON ticket_loop_protection (sent_to)
  //
  // ----------------------------------------------------------
***************
*** 1055,1059 ****
  )
  //
! CREATE INDEX postmaster_filter_f_18 ON postmaster_filter (f_name)
  //
  // ----------------------------------------------------------
--- 1055,1059 ----
  )
  //
! CREATE INDEX postmaster_filter_f_34 ON postmaster_filter (f_name)
  //
  // ----------------------------------------------------------
***************
*** 1067,1071 ****
  )
  //
! CREATE INDEX generic_agent_job_na64 ON generic_agent_jobs (job_name)
  //
  // ----------------------------------------------------------
--- 1067,1071 ----
  )
  //
! CREATE INDEX generic_agent_job_na50 ON generic_agent_jobs (job_name)
  //
  // ----------------------------------------------------------
***************
*** 1081,1085 ****
  )
  //
! CREATE INDEX search_profile_login74 ON search_profile (login, profile_name)
  //
  // ----------------------------------------------------------
--- 1081,1085 ----
  )
  //
! CREATE INDEX search_profile_login25 ON search_profile (login, profile_name)
  //
  // ----------------------------------------------------------
***************
*** 1136,1142 ****
  )
  //
! CREATE INDEX xml_storage_xml_cont26 ON xml_storage (xml_content_key)
  //
! CREATE INDEX xml_storage_key_type79 ON xml_storage (xml_key, xml_type)
  //
  // ----------------------------------------------------------
--- 1136,1142 ----
  )
  //
! CREATE INDEX xml_storage_key_type81 ON xml_storage (xml_key, xml_type)
  //
! CREATE INDEX xml_storage_xml_cont16 ON xml_storage (xml_content_key)
  //
  // ----------------------------------------------------------

Author: martin

Index: otrs-schema.mssql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.mssql.sql,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -d -r1.20 -r1.21
*** otrs-schema.mssql.sql	6 May 2008 22:28:17 -0000	1.20
--- otrs-schema.mssql.sql	6 May 2008 22:46:49 -0000	1.21
***************
*** 1,4 ****
  -- ----------------------------------------------------------
! --  driver: mssql, generated: 2008-05-07 00:18:08
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
--- 1,4 ----
  -- ----------------------------------------------------------
! --  driver: mssql, generated: 2008-05-07 00:43:00
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
***************
*** 127,132 ****
      change_by INTEGER NOT NULL
  );
- CREATE INDEX group_role_role_id ON group_role (role_id);
  CREATE INDEX group_role_group_id ON group_role (group_id);
  -- ----------------------------------------------------------
  --  create table group_customer_user
--- 127,132 ----
      change_by INTEGER NOT NULL
  );
  CREATE INDEX group_role_group_id ON group_role (group_id);
+ CREATE INDEX group_role_role_id ON group_role (role_id);
  -- ----------------------------------------------------------
  --  create table group_customer_user
***************
*** 410,425 ****
      UNIQUE (tn)
  );
- CREATE INDEX ticket_ticket_state_id ON ticket (ticket_state_id);
- CREATE INDEX ticket_ticket_priority_id ON ticket (ticket_priority_id);
- CREATE INDEX ticket_user_id ON ticket (user_id);
- CREATE INDEX ticket_customer_id ON ticket (customer_id);
  CREATE INDEX ticket_answered ON ticket (ticket_answered);
! CREATE INDEX ticket_type_id ON ticket (type_id);
  CREATE INDEX ticket_queue_view ON ticket (ticket_state_id, ticket_lock_id, group_id);
  CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
! CREATE INDEX ticket_customer_user_id ON ticket (customer_user_id);
! CREATE INDEX ticket_ticket_lock_id ON ticket (lock_id);
  CREATE INDEX ticket_title ON ticket (title);
! CREATE INDEX ticket_queue_id ON ticket (queue_id);
  -- ----------------------------------------------------------
  --  create table object_link
--- 410,425 ----
      UNIQUE (tn)
  );
  CREATE INDEX ticket_answered ON ticket (ticket_answered);
! CREATE INDEX ticket_customer_id ON ticket (customer_id);
! CREATE INDEX ticket_customer_user_id ON ticket (customer_user_id);
! CREATE INDEX ticket_queue_id ON ticket (queue_id);
  CREATE INDEX ticket_queue_view ON ticket (ticket_state_id, ticket_lock_id, group_id);
  CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
! CREATE INDEX ticket_ticket_lock_id ON ticket (ticket_lock_id);
! CREATE INDEX ticket_ticket_priority_id ON ticket (ticket_priority_id);
! CREATE INDEX ticket_ticket_state_id ON ticket (ticket_state_id);
  CREATE INDEX ticket_title ON ticket (title);
! CREATE INDEX ticket_type_id ON ticket (type_id);
! CREATE INDEX ticket_user_id ON ticket (user_id);
  -- ----------------------------------------------------------
  --  create table object_link
***************
*** 432,440 ****
      object_link_type VARCHAR (200) NOT NULL
  );
! CREATE INDEX object_link_b_object ON object_link (object_link_b_object);
  CREATE INDEX object_link_b_id ON object_link (object_link_b_id);
  CREATE INDEX object_link_type ON object_link (object_link_type);
- CREATE INDEX object_link_a_object ON object_link (object_link_a_object);
- CREATE INDEX object_link_a_id ON object_link (object_link_a_id);
  -- ----------------------------------------------------------
  --  create table ticket_history
--- 432,440 ----
      object_link_type VARCHAR (200) NOT NULL
  );
! CREATE INDEX object_link_a_id ON object_link (object_link_a_id);
! CREATE INDEX object_link_a_object ON object_link (object_link_a_object);
  CREATE INDEX object_link_b_id ON object_link (object_link_b_id);
+ CREATE INDEX object_link_b_object ON object_link (object_link_b_object);
  CREATE INDEX object_link_type ON object_link (object_link_type);
  -- ----------------------------------------------------------
  --  create table ticket_history
***************
*** 458,468 ****
      PRIMARY KEY(id)
  );
  CREATE INDEX ticket_history_history_type_id ON ticket_history (history_type_id);
  CREATE INDEX ticket_history_owner_id ON ticket_history (owner_id);
- CREATE INDEX ticket_history_ticket_id ON ticket_history (ticket_id);
  CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id, priority_id);
- CREATE INDEX ticket_history_create_time ON ticket_history (create_time);
  CREATE INDEX ticket_history_queue_id ON ticket_history (queue_id);
  CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
  CREATE INDEX ticket_history_type_id ON ticket_history (type_id);
  -- ----------------------------------------------------------
--- 458,468 ----
      PRIMARY KEY(id)
  );
+ CREATE INDEX ticket_history_create_time ON ticket_history (create_time);
  CREATE INDEX ticket_history_history_type_id ON ticket_history (history_type_id);
  CREATE INDEX ticket_history_owner_id ON ticket_history (owner_id);
  CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id, priority_id);
  CREATE INDEX ticket_history_queue_id ON ticket_history (queue_id);
  CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
+ CREATE INDEX ticket_history_ticket_id ON ticket_history (ticket_id);
  CREATE INDEX ticket_history_type_id ON ticket_history (type_id);
  -- ----------------------------------------------------------
***************
*** 520,525 ****
      create_by INTEGER NOT NULL
  );
- CREATE INDEX article_flag_create_by ON article_flag (create_by);
  CREATE INDEX article_flag_article_id ON article_flag (article_id);
  -- ----------------------------------------------------------
  --  create table article
--- 520,525 ----
      create_by INTEGER NOT NULL
  );
  CREATE INDEX article_flag_article_id ON article_flag (article_id);
+ CREATE INDEX article_flag_create_by ON article_flag (create_by);
  -- ----------------------------------------------------------
  --  create table article
***************
*** 554,559 ****
  );
  CREATE INDEX article_article_sender_type_id ON article (article_sender_type_id);
- CREATE INDEX article_message_id ON article (a_message_id);
  CREATE INDEX article_article_type_id ON article (article_type_id);
  CREATE INDEX article_ticket_id ON article (ticket_id);
  -- ----------------------------------------------------------
--- 554,559 ----
  );
  CREATE INDEX article_article_sender_type_id ON article (article_sender_type_id);
  CREATE INDEX article_article_type_id ON article (article_type_id);
+ CREATE INDEX article_message_id ON article (a_message_id);
  CREATE INDEX article_ticket_id ON article (ticket_id);
  -- ----------------------------------------------------------
***************
*** 794,799 ****
  );
  CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
- CREATE INDEX ticket_index_ticket_id ON ticket_index (ticket_id);
  CREATE INDEX ticket_index_queue_id ON ticket_index (queue_id);
  -- ----------------------------------------------------------
  --  create table ticket_lock_index
--- 794,799 ----
  );
  CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
  CREATE INDEX ticket_index_queue_id ON ticket_index (queue_id);
+ CREATE INDEX ticket_index_ticket_id ON ticket_index (ticket_id);
  -- ----------------------------------------------------------
  --  create table ticket_lock_index
***************
*** 860,865 ****
      sent_date VARCHAR (150) NOT NULL
  );
- CREATE INDEX ticket_loop_protection_sent_to ON ticket_loop_protection (sent_to);
  CREATE INDEX ticket_loop_protection_sent_date ON ticket_loop_protection (sent_date);
  -- ----------------------------------------------------------
  --  create table mail_account
--- 860,865 ----
      sent_date VARCHAR (150) NOT NULL
  );
  CREATE INDEX ticket_loop_protection_sent_date ON ticket_loop_protection (sent_date);
+ CREATE INDEX ticket_loop_protection_sent_to ON ticket_loop_protection (sent_to);
  -- ----------------------------------------------------------
  --  create table mail_account
***************
*** 956,961 ****
      xml_content_value TEXT
  );
- CREATE INDEX xml_storage_xml_content_key ON xml_storage (xml_content_key);
  CREATE INDEX xml_storage_key_type ON xml_storage (xml_key, xml_type);
  -- ----------------------------------------------------------
  --  create table package_repository
--- 956,961 ----
      xml_content_value TEXT
  );
  CREATE INDEX xml_storage_key_type ON xml_storage (xml_key, xml_type);
+ CREATE INDEX xml_storage_xml_content_key ON xml_storage (xml_content_key);
  -- ----------------------------------------------------------
  --  create table package_repository

Author: martin

Index: otrs-schema.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.mysql.sql,v
retrieving revision 1.66
retrieving revision 1.67
diff -C2 -d -r1.66 -r1.67
*** otrs-schema.mysql.sql	6 May 2008 22:28:17 -0000	1.66
--- otrs-schema.mysql.sql	6 May 2008 22:46:49 -0000	1.67
***************
*** 1,4 ****
  # ----------------------------------------------------------
! #  driver: mysql, generated: 2008-05-07 00:18:08
  # ----------------------------------------------------------
  # ----------------------------------------------------------
--- 1,4 ----
  # ----------------------------------------------------------
! #  driver: mysql, generated: 2008-05-07 00:43:01
  # ----------------------------------------------------------
  # ----------------------------------------------------------
***************
*** 126,131 ****
      change_time DATETIME NOT NULL,
      change_by INTEGER NOT NULL,
!     INDEX group_role_role_id (role_id),
!     INDEX group_role_group_id (group_id)
  );
  # ----------------------------------------------------------
--- 126,131 ----
      change_time DATETIME NOT NULL,
      change_by INTEGER NOT NULL,
!     INDEX group_role_group_id (group_id),
!     INDEX group_role_role_id (role_id)
  );
  # ----------------------------------------------------------
***************
*** 409,424 ****
      PRIMARY KEY(id),
      UNIQUE INDEX (tn),
-     INDEX ticket_ticket_state_id (ticket_state_id),
-     INDEX ticket_ticket_priority_id (ticket_priority_id),
-     INDEX ticket_user_id (user_id),
-     INDEX ticket_customer_id (customer_id),
      INDEX ticket_answered (ticket_answered),
!     INDEX ticket_type_id (type_id),
      INDEX ticket_queue_view (ticket_state_id, ticket_lock_id, group_id),
      INDEX ticket_responsible_user_id (responsible_user_id),
!     INDEX ticket_customer_user_id (customer_user_id),
!     INDEX ticket_ticket_lock_id (lock_id),
      INDEX ticket_title (title),
!     INDEX ticket_queue_id (queue_id)
  );
  # ----------------------------------------------------------
--- 409,424 ----
      PRIMARY KEY(id),
      UNIQUE INDEX (tn),
      INDEX ticket_answered (ticket_answered),
!     INDEX ticket_customer_id (customer_id),
!     INDEX ticket_customer_user_id (customer_user_id),
!     INDEX ticket_queue_id (queue_id),
      INDEX ticket_queue_view (ticket_state_id, ticket_lock_id, group_id),
      INDEX ticket_responsible_user_id (responsible_user_id),
!     INDEX ticket_ticket_lock_id (ticket_lock_id),
!     INDEX ticket_ticket_priority_id (ticket_priority_id),
!     INDEX ticket_ticket_state_id (ticket_state_id),
      INDEX ticket_title (title),
!     INDEX ticket_type_id (type_id),
!     INDEX ticket_user_id (user_id)
  );
  # ----------------------------------------------------------
***************
*** 431,439 ****
      object_link_b_object VARCHAR (200) NOT NULL,
      object_link_type VARCHAR (200) NOT NULL,
!     INDEX object_link_b_object (object_link_b_object),
!     INDEX object_link_b_id (object_link_b_id),
!     INDEX object_link_type (object_link_type),
      INDEX object_link_a_object (object_link_a_object),
!     INDEX object_link_a_id (object_link_a_id)
  );
  # ----------------------------------------------------------
--- 431,439 ----
      object_link_b_object VARCHAR (200) NOT NULL,
      object_link_type VARCHAR (200) NOT NULL,
!     INDEX object_link_a_id (object_link_a_id),
      INDEX object_link_a_object (object_link_a_object),
!     INDEX object_link_b_id (object_link_b_id),
!     INDEX object_link_b_object (object_link_b_object),
!     INDEX object_link_type (object_link_type)
  );
  # ----------------------------------------------------------
***************
*** 457,467 ****
      change_by INTEGER NOT NULL,
      PRIMARY KEY(id),
      INDEX ticket_history_history_type_id (history_type_id),
      INDEX ticket_history_owner_id (owner_id),
-     INDEX ticket_history_ticket_id (ticket_id),
      INDEX ticket_history_priority_id (priority_id, priority_id),
-     INDEX ticket_history_create_time (create_time),
      INDEX ticket_history_queue_id (queue_id),
      INDEX ticket_history_state_id (state_id),
      INDEX ticket_history_type_id (type_id)
  );
--- 457,467 ----
      change_by INTEGER NOT NULL,
      PRIMARY KEY(id),
+     INDEX ticket_history_create_time (create_time),
      INDEX ticket_history_history_type_id (history_type_id),
      INDEX ticket_history_owner_id (owner_id),
      INDEX ticket_history_priority_id (priority_id, priority_id),
      INDEX ticket_history_queue_id (queue_id),
      INDEX ticket_history_state_id (state_id),
+     INDEX ticket_history_ticket_id (ticket_id),
      INDEX ticket_history_type_id (type_id)
  );
***************
*** 519,524 ****
      create_time DATETIME NOT NULL,
      create_by INTEGER NOT NULL,
!     INDEX article_flag_create_by (create_by),
!     INDEX article_flag_article_id (article_id)
  );
  # ----------------------------------------------------------
--- 519,524 ----
      create_time DATETIME NOT NULL,
      create_by INTEGER NOT NULL,
!     INDEX article_flag_article_id (article_id),
!     INDEX article_flag_create_by (create_by)
  );
  # ----------------------------------------------------------
***************
*** 553,558 ****
      PRIMARY KEY(id),
      INDEX article_article_sender_type_id (article_sender_type_id),
-     INDEX article_message_id (a_message_id(255)),
      INDEX article_article_type_id (article_type_id),
      INDEX article_ticket_id (ticket_id)
  );
--- 553,558 ----
      PRIMARY KEY(id),
      INDEX article_article_sender_type_id (article_sender_type_id),
      INDEX article_article_type_id (article_type_id),
+     INDEX article_message_id (a_message_id(255)),
      INDEX article_ticket_id (ticket_id)
  );
***************
*** 793,798 ****
      create_time_unix BIGINT NOT NULL,
      INDEX ticket_index_group_id (group_id),
!     INDEX ticket_index_ticket_id (ticket_id),
!     INDEX ticket_index_queue_id (queue_id)
  );
  # ----------------------------------------------------------
--- 793,798 ----
      create_time_unix BIGINT NOT NULL,
      INDEX ticket_index_group_id (group_id),
!     INDEX ticket_index_queue_id (queue_id),
!     INDEX ticket_index_ticket_id (ticket_id)
  );
  # ----------------------------------------------------------
***************
*** 850,855 ****
      change_time DATETIME NOT NULL,
      change_by INTEGER NOT NULL,
!     UNIQUE INDEX (customer_id),
!     UNIQUE INDEX (name)
  );
  # ----------------------------------------------------------
--- 850,855 ----
      change_time DATETIME NOT NULL,
      change_by INTEGER NOT NULL,
!     UNIQUE INDEX (name),
!     UNIQUE INDEX (customer_id)
  );
  # ----------------------------------------------------------
***************
*** 859,864 ****
      sent_to VARCHAR (250) NOT NULL,
      sent_date VARCHAR (150) NOT NULL,
!     INDEX ticket_loop_protection_sent_to (sent_to),
!     INDEX ticket_loop_protection_sent_date (sent_date)
  );
  # ----------------------------------------------------------
--- 859,864 ----
      sent_to VARCHAR (250) NOT NULL,
      sent_date VARCHAR (150) NOT NULL,
!     INDEX ticket_loop_protection_sent_date (sent_date),
!     INDEX ticket_loop_protection_sent_to (sent_to)
  );
  # ----------------------------------------------------------
***************
*** 955,960 ****
      xml_content_key VARCHAR (250) NOT NULL,
      xml_content_value MEDIUMTEXT,
!     INDEX xml_storage_xml_content_key (xml_content_key(100)),
!     INDEX xml_storage_key_type (xml_key(10), xml_type(10))
  );
  # ----------------------------------------------------------
--- 955,960 ----
      xml_content_key VARCHAR (250) NOT NULL,
      xml_content_value MEDIUMTEXT,
!     INDEX xml_storage_key_type (xml_key(10), xml_type(10)),
!     INDEX xml_storage_xml_content_key (xml_content_key(100))
  );
  # ----------------------------------------------------------

Author: martin

Index: otrs-schema.oracle.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.oracle.sql,v
retrieving revision 1.31
retrieving revision 1.32
diff -C2 -d -r1.31 -r1.32
*** otrs-schema.oracle.sql	6 May 2008 22:28:17 -0000	1.31
--- otrs-schema.oracle.sql	6 May 2008 22:46:49 -0000	1.32
***************
*** 1,4 ****
  -- ----------------------------------------------------------
! --  driver: oracle, generated: 2008-05-07 00:18:08
  -- ----------------------------------------------------------
  SET DEFINE OFF;
--- 1,4 ----
  -- ----------------------------------------------------------
! --  driver: oracle, generated: 2008-05-07 00:43:01
  -- ----------------------------------------------------------
  SET DEFINE OFF;
***************
*** 669,673 ****
  CREATE INDEX ticket_queue_view ON ticket (ticket_state_id, ticket_lock_id, group_id);
  CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
! CREATE INDEX ticket_ticket_lock_id ON ticket (lock_id);
  CREATE INDEX ticket_ticket_priority_id ON ticket (ticket_priority_id);
  CREATE INDEX ticket_ticket_state_id ON ticket (ticket_state_id);
--- 669,673 ----
  CREATE INDEX ticket_queue_view ON ticket (ticket_state_id, ticket_lock_id, group_id);
  CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
! CREATE INDEX ticket_ticket_lock_id ON ticket (ticket_lock_id);
  CREATE INDEX ticket_ticket_priority_id ON ticket (ticket_priority_id);
  CREATE INDEX ticket_ticket_state_id ON ticket (ticket_state_id);
***************
*** 1367,1372 ****
      change_time DATE NOT NULL,
      change_by NUMBER NOT NULL,
!     CONSTRAINT customer_company_U_1 UNIQUE (customer_id),
!     CONSTRAINT customer_company_U_2 UNIQUE (name)
  );
  -- ----------------------------------------------------------
--- 1367,1372 ----
      change_time DATE NOT NULL,
      change_by NUMBER NOT NULL,
!     CONSTRAINT customer_company_U_1 UNIQUE (name),
!     CONSTRAINT customer_company_U_2 UNIQUE (customer_id)
  );
  -- ----------------------------------------------------------

Author: martin

Index: otrs-schema.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.postgresql.sql,v
retrieving revision 1.64
retrieving revision 1.65
diff -C2 -d -r1.64 -r1.65
*** otrs-schema.postgresql.sql	6 May 2008 22:28:17 -0000	1.64
--- otrs-schema.postgresql.sql	6 May 2008 22:46:49 -0000	1.65
***************
*** 1,4 ****
  -- ----------------------------------------------------------
! --  driver: postgresql, generated: 2008-05-07 00:18:09
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
--- 1,4 ----
  -- ----------------------------------------------------------
! --  driver: postgresql, generated: 2008-05-07 00:43:01
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
***************
*** 127,132 ****
      change_by INTEGER NOT NULL
  );
- CREATE INDEX group_role_role_id ON group_role (role_id);
  CREATE INDEX group_role_group_id ON group_role (group_id);
  -- ----------------------------------------------------------
  --  create table group_customer_user
--- 127,132 ----
      change_by INTEGER NOT NULL
  );
  CREATE INDEX group_role_group_id ON group_role (group_id);
+ CREATE INDEX group_role_role_id ON group_role (role_id);
  -- ----------------------------------------------------------
  --  create table group_customer_user
***************
*** 410,425 ****
      UNIQUE (tn)
  );
- CREATE INDEX ticket_ticket_state_id ON ticket (ticket_state_id);
- CREATE INDEX ticket_ticket_priority_id ON ticket (ticket_priority_id);
- CREATE INDEX ticket_user_id ON ticket (user_id);
- CREATE INDEX ticket_customer_id ON ticket (customer_id);
  CREATE INDEX ticket_answered ON ticket (ticket_answered);
! CREATE INDEX ticket_type_id ON ticket (type_id);
  CREATE INDEX ticket_queue_view ON ticket (ticket_state_id, ticket_lock_id, group_id);
  CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
! CREATE INDEX ticket_customer_user_id ON ticket (customer_user_id);
! CREATE INDEX ticket_ticket_lock_id ON ticket (lock_id);
  CREATE INDEX ticket_title ON ticket (title);
! CREATE INDEX ticket_queue_id ON ticket (queue_id);
  -- ----------------------------------------------------------
  --  create table object_link
--- 410,425 ----
      UNIQUE (tn)
  );
  CREATE INDEX ticket_answered ON ticket (ticket_answered);
! CREATE INDEX ticket_customer_id ON ticket (customer_id);
! CREATE INDEX ticket_customer_user_id ON ticket (customer_user_id);
! CREATE INDEX ticket_queue_id ON ticket (queue_id);
  CREATE INDEX ticket_queue_view ON ticket (ticket_state_id, ticket_lock_id, group_id);
  CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
! CREATE INDEX ticket_ticket_lock_id ON ticket (ticket_lock_id);
! CREATE INDEX ticket_ticket_priority_id ON ticket (ticket_priority_id);
! CREATE INDEX ticket_ticket_state_id ON ticket (ticket_state_id);
  CREATE INDEX ticket_title ON ticket (title);
! CREATE INDEX ticket_type_id ON ticket (type_id);
! CREATE INDEX ticket_user_id ON ticket (user_id);
  -- ----------------------------------------------------------
  --  create table object_link
***************
*** 432,440 ****
      object_link_type VARCHAR (200) NOT NULL
  );
! CREATE INDEX object_link_b_object ON object_link (object_link_b_object);
  CREATE INDEX object_link_b_id ON object_link (object_link_b_id);
  CREATE INDEX object_link_type ON object_link (object_link_type);
- CREATE INDEX object_link_a_object ON object_link (object_link_a_object);
- CREATE INDEX object_link_a_id ON object_link (object_link_a_id);
  -- ----------------------------------------------------------
  --  create table ticket_history
--- 432,440 ----
      object_link_type VARCHAR (200) NOT NULL
  );
! CREATE INDEX object_link_a_id ON object_link (object_link_a_id);
! CREATE INDEX object_link_a_object ON object_link (object_link_a_object);
  CREATE INDEX object_link_b_id ON object_link (object_link_b_id);
+ CREATE INDEX object_link_b_object ON object_link (object_link_b_object);
  CREATE INDEX object_link_type ON object_link (object_link_type);
  -- ----------------------------------------------------------
  --  create table ticket_history
***************
*** 458,468 ****
      PRIMARY KEY(id)
  );
  CREATE INDEX ticket_history_history_type_id ON ticket_history (history_type_id);
  CREATE INDEX ticket_history_owner_id ON ticket_history (owner_id);
- CREATE INDEX ticket_history_ticket_id ON ticket_history (ticket_id);
  CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id, priority_id);
- CREATE INDEX ticket_history_create_time ON ticket_history (create_time);
  CREATE INDEX ticket_history_queue_id ON ticket_history (queue_id);
  CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
  CREATE INDEX ticket_history_type_id ON ticket_history (type_id);
  -- ----------------------------------------------------------
--- 458,468 ----
      PRIMARY KEY(id)
  );
+ CREATE INDEX ticket_history_create_time ON ticket_history (create_time);
  CREATE INDEX ticket_history_history_type_id ON ticket_history (history_type_id);
  CREATE INDEX ticket_history_owner_id ON ticket_history (owner_id);
  CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id, priority_id);
  CREATE INDEX ticket_history_queue_id ON ticket_history (queue_id);
  CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
+ CREATE INDEX ticket_history_ticket_id ON ticket_history (ticket_id);
  CREATE INDEX ticket_history_type_id ON ticket_history (type_id);
  -- ----------------------------------------------------------
***************
*** 520,525 ****
      create_by INTEGER NOT NULL
  );
- CREATE INDEX article_flag_create_by ON article_flag (create_by);
  CREATE INDEX article_flag_article_id ON article_flag (article_id);
  -- ----------------------------------------------------------
  --  create table article
--- 520,525 ----
      create_by INTEGER NOT NULL
  );
  CREATE INDEX article_flag_article_id ON article_flag (article_id);
+ CREATE INDEX article_flag_create_by ON article_flag (create_by);
  -- ----------------------------------------------------------
  --  create table article
***************
*** 554,559 ****
  );
  CREATE INDEX article_article_sender_type_id ON article (article_sender_type_id);
- CREATE INDEX article_message_id ON article (a_message_id);
  CREATE INDEX article_article_type_id ON article (article_type_id);
  CREATE INDEX article_ticket_id ON article (ticket_id);
  -- ----------------------------------------------------------
--- 554,559 ----
  );
  CREATE INDEX article_article_sender_type_id ON article (article_sender_type_id);
  CREATE INDEX article_article_type_id ON article (article_type_id);
+ CREATE INDEX article_message_id ON article (a_message_id);
  CREATE INDEX article_ticket_id ON article (ticket_id);
  -- ----------------------------------------------------------
***************
*** 794,799 ****
  );
  CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
- CREATE INDEX ticket_index_ticket_id ON ticket_index (ticket_id);
  CREATE INDEX ticket_index_queue_id ON ticket_index (queue_id);
  -- ----------------------------------------------------------
  --  create table ticket_lock_index
--- 794,799 ----
  );
  CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
  CREATE INDEX ticket_index_queue_id ON ticket_index (queue_id);
+ CREATE INDEX ticket_index_ticket_id ON ticket_index (ticket_id);
  -- ----------------------------------------------------------
  --  create table ticket_lock_index
***************
*** 860,865 ****
      sent_date VARCHAR (150) NOT NULL
  );
- CREATE INDEX ticket_loop_protection_sent_to ON ticket_loop_protection (sent_to);
  CREATE INDEX ticket_loop_protection_sent_date ON ticket_loop_protection (sent_date);
  -- ----------------------------------------------------------
  --  create table mail_account
--- 860,865 ----
      sent_date VARCHAR (150) NOT NULL
  );
  CREATE INDEX ticket_loop_protection_sent_date ON ticket_loop_protection (sent_date);
+ CREATE INDEX ticket_loop_protection_sent_to ON ticket_loop_protection (sent_to);
  -- ----------------------------------------------------------
  --  create table mail_account
***************
*** 956,961 ****
      xml_content_value VARCHAR
  );
- CREATE INDEX xml_storage_xml_content_key ON xml_storage (xml_content_key);
  CREATE INDEX xml_storage_key_type ON xml_storage (xml_key, xml_type);
  -- ----------------------------------------------------------
  --  create table package_repository
--- 956,961 ----
      xml_content_value VARCHAR
  );
  CREATE INDEX xml_storage_key_type ON xml_storage (xml_key, xml_type);
+ CREATE INDEX xml_storage_xml_content_key ON xml_storage (xml_content_key);
  -- ----------------------------------------------------------
  --  create table package_repository

Author: martin

Index: otrs-schema.xml
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.xml,v
retrieving revision 1.77
retrieving revision 1.78
diff -C2 -d -r1.77 -r1.78
*** otrs-schema.xml	6 May 2008 22:10:16 -0000	1.77
--- otrs-schema.xml	6 May 2008 22:46:49 -0000	1.78
***************
*** 606,610 ****
      </Index>
      <Index Name="ticket_ticket_lock_id">
!         <IndexColumn Name="lock_id"/>
      </Index>
      <Index Name="ticket_queue_view">
--- 606,610 ----
      </Index>
      <Index Name="ticket_ticket_lock_id">
!         <IndexColumn Name="ticket_lock_id"/>
      </Index>
      <Index Name="ticket_queue_view">

More information about the cvs-log mailing list