[otrs-cvs] otrs/scripts/database otrs-schema-post.db2.sql, 1.8,
1.9 otrs-schema-post.maxdb.sql, 1.9,
1.10 otrs-schema-post.mssql.sql, 1.5,
1.6 otrs-schema-post.mysql.sql, 1.12,
1.13 otrs-schema-post.oracle.sql, 1.12,
1.13 otrs-schema-post.postgresql.sql, 1.11,
1.12 otrs-schema.db2.sql, 1.13, 1.14 otrs-schema.maxdb.sql,
1.14, 1.15 otrs-schema.mssql.sql, 1.9,
1.10 otrs-schema.mysql.sql, 1.55, 1.56 otrs-schema.oracle.sql,
1.20, 1.21 otrs-schema.postgresql.sql, 1.54,
1.55 otrs-schema.xml, 1.62, 1.63
cvs-log at otrs.org
cvs-log at otrs.org
Mon Apr 2 13:41:41 GMT 2007
Comments:
Update of /home/cvs/otrs/scripts/database
In directory lancelot:/tmp/cvs-serv3616
Modified Files:
otrs-schema-post.db2.sql otrs-schema-post.maxdb.sql
otrs-schema-post.mssql.sql otrs-schema-post.mysql.sql
otrs-schema-post.oracle.sql otrs-schema-post.postgresql.sql
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:
Improved indexes of xml_storage table
Author: mh
Index: otrs-schema-post.db2.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema-post.db2.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** otrs-schema-post.db2.sql 5 Mar 2007 01:59:58 -0000 1.8
--- otrs-schema-post.db2.sql 2 Apr 2007 13:41:36 -0000 1.9
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- database: db2, generated: 2007-03-05 02:51:51
-- ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES system_user(id);
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: db2, generated: 2007-04-02 15:40:20
-- ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES system_user(id);
Author: mh
Index: otrs-schema-post.maxdb.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema-post.maxdb.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** otrs-schema-post.maxdb.sql 5 Mar 2007 01:59:58 -0000 1.9
--- otrs-schema-post.maxdb.sql 2 Apr 2007 13:41:36 -0000 1.10
***************
*** 1,4 ****
// ----------------------------------------------------------
! // database: maxdb, generated: 2007-03-05 02:51:44
// ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES system_user(id)
--- 1,4 ----
// ----------------------------------------------------------
! // driver: maxdb, generated: 2007-04-02 15:40:29
// ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES system_user(id)
Author: mh
Index: otrs-schema-post.mssql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema-post.mssql.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** otrs-schema-post.mssql.sql 5 Mar 2007 01:59:58 -0000 1.5
--- otrs-schema-post.mssql.sql 2 Apr 2007 13:41:36 -0000 1.6
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- database: mssql, generated: 2007-03-05 02:51:37
-- ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2007-04-02 15:40:38
-- ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
Author: mh
Index: otrs-schema-post.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema-post.mysql.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** otrs-schema-post.mysql.sql 5 Mar 2007 01:59:58 -0000 1.12
--- otrs-schema-post.mysql.sql 2 Apr 2007 13:41:36 -0000 1.13
***************
*** 1,4 ****
# ----------------------------------------------------------
! # database: mysql, generated: 2007-03-05 02:47:35
# ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
--- 1,4 ----
# ----------------------------------------------------------
! # driver: mysql, generated: 2007-04-02 15:39:21
# ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
Author: mh
Index: otrs-schema-post.oracle.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema-post.oracle.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** otrs-schema-post.oracle.sql 5 Mar 2007 01:59:58 -0000 1.12
--- otrs-schema-post.oracle.sql 2 Apr 2007 13:41:36 -0000 1.13
***************
*** 1,15 ****
-- ----------------------------------------------------------
! -- database: oracle, generated: 2007-03-05 02:51:58
-- ----------------------------------------------------------
ALTER TABLE valid ADD CONSTRAINT fk_valid_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE valid ADD CONSTRAINT fk_valid_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE ticket_priority ADD CONSTRAINT fk_ticket_priority_create_by77 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_priority ADD CONSTRAINT fk_ticket_priority_change_by29 FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE ticket_type ADD CONSTRAINT fk_ticket_type_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE ticket_type ADD CONSTRAINT fk_ticket_type_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE ticket_type ADD CONSTRAINT fk_ticket_type_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE ticket_lock_type ADD CONSTRAINT fk_ticket_lock_type_create_b75 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_lock_type ADD CONSTRAINT fk_ticket_lock_type_change_b12 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE ticket_lock_type ADD CONSTRAINT fk_ticket_lock_type_valid_id11 FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE system_user ADD CONSTRAINT fk_system_user_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE system_user ADD CONSTRAINT fk_system_user_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
--- 1,16 ----
-- ----------------------------------------------------------
! -- driver: oracle, generated: 2007-04-02 15:40:47
-- ----------------------------------------------------------
+ SET DEFINE OFF;
ALTER TABLE valid ADD CONSTRAINT fk_valid_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE valid ADD CONSTRAINT fk_valid_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE ticket_priority ADD CONSTRAINT fk_ticket_priority_create_by51 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_priority ADD CONSTRAINT fk_ticket_priority_change_by94 FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE ticket_type ADD CONSTRAINT fk_ticket_type_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE ticket_type ADD CONSTRAINT fk_ticket_type_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE ticket_type ADD CONSTRAINT fk_ticket_type_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE ticket_lock_type ADD CONSTRAINT fk_ticket_lock_type_create_b16 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_lock_type ADD CONSTRAINT fk_ticket_lock_type_change_b54 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE ticket_lock_type ADD CONSTRAINT fk_ticket_lock_type_valid_id4 FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE system_user ADD CONSTRAINT fk_system_user_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE system_user ADD CONSTRAINT fk_system_user_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
***************
*** 27,33 ****
ALTER TABLE group_role ADD CONSTRAINT fk_group_role_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE group_role ADD CONSTRAINT fk_group_role_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE group_customer_user ADD CONSTRAINT fk_group_customer_user_group94 FOREIGN KEY (group_id) REFERENCES groups(id);
! ALTER TABLE group_customer_user ADD CONSTRAINT fk_group_customer_user_creat63 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE group_customer_user ADD CONSTRAINT fk_group_customer_user_chang60 FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE roles ADD CONSTRAINT fk_roles_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE roles ADD CONSTRAINT fk_roles_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
--- 28,34 ----
ALTER TABLE group_role ADD CONSTRAINT fk_group_role_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE group_role ADD CONSTRAINT fk_group_role_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE group_customer_user ADD CONSTRAINT fk_group_customer_user_group97 FOREIGN KEY (group_id) REFERENCES groups(id);
! ALTER TABLE group_customer_user ADD CONSTRAINT fk_group_customer_user_creat48 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE group_customer_user ADD CONSTRAINT fk_group_customer_user_chang45 FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE roles ADD CONSTRAINT fk_roles_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE roles ADD CONSTRAINT fk_roles_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
***************
*** 45,50 ****
ALTER TABLE ticket_state ADD CONSTRAINT fk_ticket_state_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE ticket_state ADD CONSTRAINT fk_ticket_state_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE ticket_state_type ADD CONSTRAINT fk_ticket_state_type_create_63 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_state_type ADD CONSTRAINT fk_ticket_state_type_change_85 FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE salutation ADD CONSTRAINT fk_salutation_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE salutation ADD CONSTRAINT fk_salutation_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
--- 46,51 ----
ALTER TABLE ticket_state ADD CONSTRAINT fk_ticket_state_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE ticket_state ADD CONSTRAINT fk_ticket_state_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE ticket_state_type ADD CONSTRAINT fk_ticket_state_type_create_57 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_state_type ADD CONSTRAINT fk_ticket_state_type_change_49 FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE salutation ADD CONSTRAINT fk_salutation_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE salutation ADD CONSTRAINT fk_salutation_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
***************
*** 56,62 ****
ALTER TABLE system_address ADD CONSTRAINT fk_system_address_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE system_address ADD CONSTRAINT fk_system_address_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE follow_up_possible ADD CONSTRAINT fk_follow_up_possible_create4 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE follow_up_possible ADD CONSTRAINT fk_follow_up_possible_change77 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE follow_up_possible ADD CONSTRAINT fk_follow_up_possible_valid_24 FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE queue ADD CONSTRAINT fk_queue_salutation_id_id FOREIGN KEY (salutation_id) REFERENCES salutation(id);
ALTER TABLE queue ADD CONSTRAINT fk_queue_signature_id_id FOREIGN KEY (signature_id) REFERENCES signature(id);
--- 57,63 ----
ALTER TABLE system_address ADD CONSTRAINT fk_system_address_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE system_address ADD CONSTRAINT fk_system_address_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE follow_up_possible ADD CONSTRAINT fk_follow_up_possible_create78 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE follow_up_possible ADD CONSTRAINT fk_follow_up_possible_change31 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE follow_up_possible ADD CONSTRAINT fk_follow_up_possible_valid_20 FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE queue ADD CONSTRAINT fk_queue_salutation_id_id FOREIGN KEY (salutation_id) REFERENCES salutation(id);
ALTER TABLE queue ADD CONSTRAINT fk_queue_signature_id_id FOREIGN KEY (signature_id) REFERENCES signature(id);
***************
*** 68,76 ****
ALTER TABLE queue ADD CONSTRAINT fk_queue_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_ticket_lock_id_id FOREIGN KEY (ticket_lock_id) REFERENCES ticket_lock_type(id);
! ALTER TABLE ticket ADD CONSTRAINT fk_ticket_ticket_priority_id12 FOREIGN KEY (ticket_priority_id) REFERENCES ticket_priority(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_user_id_id FOREIGN KEY (user_id) REFERENCES system_user(id);
! ALTER TABLE ticket ADD CONSTRAINT fk_ticket_responsible_user_i44 FOREIGN KEY (responsible_user_id) REFERENCES system_user(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_service_id_id FOREIGN KEY (service_id) REFERENCES service(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
--- 69,77 ----
ALTER TABLE queue ADD CONSTRAINT fk_queue_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_ticket_lock_id_id FOREIGN KEY (ticket_lock_id) REFERENCES ticket_lock_type(id);
! ALTER TABLE ticket ADD CONSTRAINT fk_ticket_ticket_priority_id98 FOREIGN KEY (ticket_priority_id) REFERENCES ticket_priority(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_user_id_id FOREIGN KEY (user_id) REFERENCES system_user(id);
! ALTER TABLE ticket ADD CONSTRAINT fk_ticket_responsible_user_i52 FOREIGN KEY (responsible_user_id) REFERENCES system_user(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_service_id_id FOREIGN KEY (service_id) REFERENCES service(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
***************
*** 79,83 ****
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_type_id_id FOREIGN KEY (type_id) REFERENCES ticket_type(id);
! ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_priority_i12 FOREIGN KEY (priority_id) REFERENCES ticket_priority(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_owner_id_id FOREIGN KEY (owner_id) REFERENCES system_user(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
--- 80,84 ----
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue(id);
ALTER TABLE ticket ADD CONSTRAINT fk_ticket_type_id_id FOREIGN KEY (type_id) REFERENCES ticket_type(id);
! ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_priority_i18 FOREIGN KEY (priority_id) REFERENCES ticket_priority(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_owner_id_id FOREIGN KEY (owner_id) REFERENCES system_user(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
***************
*** 85,104 ****
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_state_id_id FOREIGN KEY (state_id) REFERENCES ticket_state(id);
! ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_history_ty0 FOREIGN KEY (history_type_id) REFERENCES ticket_history_type(id);
! ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_article_id71 FOREIGN KEY (article_id) REFERENCES article(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_type_id_id FOREIGN KEY (type_id) REFERENCES ticket_type(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket(id);
! ALTER TABLE ticket_history_type ADD CONSTRAINT fk_ticket_history_type_creat93 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_history_type ADD CONSTRAINT fk_ticket_history_type_chang20 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE ticket_history_type ADD CONSTRAINT fk_ticket_history_type_valid30 FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE article_type ADD CONSTRAINT fk_article_type_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE article_type ADD CONSTRAINT fk_article_type_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE article_type ADD CONSTRAINT fk_article_type_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE article_sender_type ADD CONSTRAINT fk_article_sender_type_creat10 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE article_sender_type ADD CONSTRAINT fk_article_sender_type_chang79 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE article_sender_type ADD CONSTRAINT fk_article_sender_type_valid12 FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE article_flag ADD CONSTRAINT fk_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE article ADD CONSTRAINT fk_article_article_sender_ty83 FOREIGN KEY (article_sender_type_id) REFERENCES article_sender_type(id);
ALTER TABLE article ADD CONSTRAINT fk_article_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE article ADD CONSTRAINT fk_article_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
--- 86,105 ----
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_state_id_id FOREIGN KEY (state_id) REFERENCES ticket_state(id);
! ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_history_ty52 FOREIGN KEY (history_type_id) REFERENCES ticket_history_type(id);
! ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_article_id25 FOREIGN KEY (article_id) REFERENCES article(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_type_id_id FOREIGN KEY (type_id) REFERENCES ticket_type(id);
ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket(id);
! ALTER TABLE ticket_history_type ADD CONSTRAINT fk_ticket_history_type_creat17 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_history_type ADD CONSTRAINT fk_ticket_history_type_chang63 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE ticket_history_type ADD CONSTRAINT fk_ticket_history_type_valid86 FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE article_type ADD CONSTRAINT fk_article_type_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE article_type ADD CONSTRAINT fk_article_type_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE article_type ADD CONSTRAINT fk_article_type_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE article_sender_type ADD CONSTRAINT fk_article_sender_type_creat95 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE article_sender_type ADD CONSTRAINT fk_article_sender_type_chang39 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE article_sender_type ADD CONSTRAINT fk_article_sender_type_valid6 FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE article_flag ADD CONSTRAINT fk_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE article ADD CONSTRAINT fk_article_article_sender_ty78 FOREIGN KEY (article_sender_type_id) REFERENCES article_sender_type(id);
ALTER TABLE article ADD CONSTRAINT fk_article_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE article ADD CONSTRAINT fk_article_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
***************
*** 109,145 ****
ALTER TABLE article_plain ADD CONSTRAINT fk_article_plain_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE article_plain ADD CONSTRAINT fk_article_plain_article_id_id FOREIGN KEY (article_id) REFERENCES article(id);
! ALTER TABLE article_attachment ADD CONSTRAINT fk_article_attachment_create27 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE article_attachment ADD CONSTRAINT fk_article_attachment_change34 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE article_attachment ADD CONSTRAINT fk_article_attachment_articl78 FOREIGN KEY (article_id) REFERENCES article(id);
! ALTER TABLE standard_response ADD CONSTRAINT fk_standard_response_create_72 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE standard_response ADD CONSTRAINT fk_standard_response_change_6 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE standard_response ADD CONSTRAINT fk_standard_response_valid_i2 FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_c8 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_c23 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_s32 FOREIGN KEY (standard_response_id) REFERENCES standard_response(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_q6 FOREIGN KEY (queue_id) REFERENCES queue(id);
! ALTER TABLE standard_attachment ADD CONSTRAINT fk_standard_attachment_creat47 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE standard_attachment ADD CONSTRAINT fk_standard_attachment_chang73 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE standard_attachment ADD CONSTRAINT fk_standard_attachment_valid25 FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm45 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm32 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm45 FOREIGN KEY (standard_response_id) REFERENCES standard_response(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm97 FOREIGN KEY (standard_attachment_id) REFERENCES standard_attachment(id);
! ALTER TABLE auto_response_type ADD CONSTRAINT fk_auto_response_type_create55 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE auto_response_type ADD CONSTRAINT fk_auto_response_type_change26 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE auto_response_type ADD CONSTRAINT fk_auto_response_type_valid_31 FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE auto_response ADD CONSTRAINT fk_auto_response_type_id_id FOREIGN KEY (type_id) REFERENCES auto_response_type(id);
! ALTER TABLE auto_response ADD CONSTRAINT fk_auto_response_system_addr60 FOREIGN KEY (system_address_id) REFERENCES system_address(id);
ALTER TABLE auto_response ADD CONSTRAINT fk_auto_response_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE auto_response ADD CONSTRAINT fk_auto_response_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE auto_response ADD CONSTRAINT fk_auto_response_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_auto_37 FOREIGN KEY (auto_response_id) REFERENCES auto_response(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_creat14 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_chang61 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_queue57 FOREIGN KEY (queue_id) REFERENCES queue(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_create_by46 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_change_by21 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_article_i70 FOREIGN KEY (article_id) REFERENCES article(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_ticket_id53 FOREIGN KEY (ticket_id) REFERENCES ticket(id);
ALTER TABLE service ADD CONSTRAINT fk_service_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE service ADD CONSTRAINT fk_service_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
--- 110,146 ----
ALTER TABLE article_plain ADD CONSTRAINT fk_article_plain_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE article_plain ADD CONSTRAINT fk_article_plain_article_id_id FOREIGN KEY (article_id) REFERENCES article(id);
! ALTER TABLE article_attachment ADD CONSTRAINT fk_article_attachment_create6 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE article_attachment ADD CONSTRAINT fk_article_attachment_change54 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE article_attachment ADD CONSTRAINT fk_article_attachment_articl71 FOREIGN KEY (article_id) REFERENCES article(id);
! ALTER TABLE standard_response ADD CONSTRAINT fk_standard_response_create_36 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE standard_response ADD CONSTRAINT fk_standard_response_change_98 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE standard_response ADD CONSTRAINT fk_standard_response_valid_i73 FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_c62 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_c13 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_s61 FOREIGN KEY (standard_response_id) REFERENCES standard_response(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_q38 FOREIGN KEY (queue_id) REFERENCES queue(id);
! ALTER TABLE standard_attachment ADD CONSTRAINT fk_standard_attachment_creat28 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE standard_attachment ADD CONSTRAINT fk_standard_attachment_chang64 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE standard_attachment ADD CONSTRAINT fk_standard_attachment_valid61 FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm24 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm48 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm9 FOREIGN KEY (standard_response_id) REFERENCES standard_response(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm37 FOREIGN KEY (standard_attachment_id) REFERENCES standard_attachment(id);
! ALTER TABLE auto_response_type ADD CONSTRAINT fk_auto_response_type_create17 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE auto_response_type ADD CONSTRAINT fk_auto_response_type_change24 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE auto_response_type ADD CONSTRAINT fk_auto_response_type_valid_93 FOREIGN KEY (valid_id) REFERENCES valid(id);
ALTER TABLE auto_response ADD CONSTRAINT fk_auto_response_type_id_id FOREIGN KEY (type_id) REFERENCES auto_response_type(id);
! ALTER TABLE auto_response ADD CONSTRAINT fk_auto_response_system_addr39 FOREIGN KEY (system_address_id) REFERENCES system_address(id);
ALTER TABLE auto_response ADD CONSTRAINT fk_auto_response_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE auto_response ADD CONSTRAINT fk_auto_response_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
ALTER TABLE auto_response ADD CONSTRAINT fk_auto_response_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_auto_80 FOREIGN KEY (auto_response_id) REFERENCES auto_response(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_creat81 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_chang85 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_queue38 FOREIGN KEY (queue_id) REFERENCES queue(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_create_by43 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_change_by27 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_article_i97 FOREIGN KEY (article_id) REFERENCES article(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_ticket_id0 FOREIGN KEY (ticket_id) REFERENCES ticket(id);
ALTER TABLE service ADD CONSTRAINT fk_service_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE service ADD CONSTRAINT fk_service_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
***************
*** 155,158 ****
ALTER TABLE notifications ADD CONSTRAINT fk_notifications_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE notifications ADD CONSTRAINT fk_notifications_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE package_repository ADD CONSTRAINT fk_package_repository_create95 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE package_repository ADD CONSTRAINT fk_package_repository_change92 FOREIGN KEY (change_by) REFERENCES system_user(id);
--- 156,159 ----
ALTER TABLE notifications ADD CONSTRAINT fk_notifications_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
ALTER TABLE notifications ADD CONSTRAINT fk_notifications_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE package_repository ADD CONSTRAINT fk_package_repository_create89 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE package_repository ADD CONSTRAINT fk_package_repository_change6 FOREIGN KEY (change_by) REFERENCES system_user(id);
Author: mh
Index: otrs-schema-post.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema-post.postgresql.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** otrs-schema-post.postgresql.sql 5 Mar 2007 01:59:58 -0000 1.11
--- otrs-schema-post.postgresql.sql 2 Apr 2007 13:41:36 -0000 1.12
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- database: postgresql, generated: 2007-03-05 02:52:16
-- ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES system_user(id);
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2007-04-02 15:40:55
-- ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES system_user(id);
Author: mh
Index: otrs-schema.db2.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.db2.sql,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** otrs-schema.db2.sql 16 Mar 2007 10:02:13 -0000 1.13
--- otrs-schema.db2.sql 2 Apr 2007 13:41:36 -0000 1.14
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: db2, generated: 2007-03-16 11:00:00
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: db2, generated: 2007-04-02 15:40:20
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 89,93 ****
);
! CREATE INDEX index_user_prefe90 ON user_preferences (user_id);
-- ----------------------------------------------------------
--- 89,93 ----
);
! CREATE INDEX index_user_prefe16 ON user_preferences (user_id);
-- ----------------------------------------------------------
***************
*** 408,418 ****
);
! CREATE INDEX index_ticket_use6 ON ticket (user_id);
! CREATE INDEX index_ticket_typ32 ON ticket (type_id);
! CREATE INDEX index_ticket_que21 ON ticket (ticket_state_id, ticket_lock_id, group_id);
! CREATE INDEX index_ticket_ans89 ON ticket (ticket_answered);
-- ----------------------------------------------------------
--- 408,418 ----
);
! CREATE INDEX index_ticket_use85 ON ticket (user_id);
! CREATE INDEX index_ticket_typ13 ON ticket (type_id);
! CREATE INDEX index_ticket_que94 ON ticket (ticket_state_id, ticket_lock_id, group_id);
! CREATE INDEX index_ticket_ans66 ON ticket (ticket_answered);
-- ----------------------------------------------------------
***************
*** 449,455 ****
);
! CREATE INDEX ticket_history_t25 ON ticket_history (ticket_id);
! CREATE INDEX ticket_history_c50 ON ticket_history (create_time);
-- ----------------------------------------------------------
--- 449,455 ----
);
! CREATE INDEX ticket_history_t38 ON ticket_history (ticket_id);
! CREATE INDEX ticket_history_c57 ON ticket_history (create_time);
-- ----------------------------------------------------------
***************
*** 511,517 ****
);
! CREATE INDEX article_flag_cre80 ON article_flag (create_by);
! CREATE INDEX article_flag_art82 ON article_flag (article_id);
-- ----------------------------------------------------------
--- 511,517 ----
);
! CREATE INDEX article_flag_cre35 ON article_flag (create_by);
! CREATE INDEX article_flag_art23 ON article_flag (article_id);
-- ----------------------------------------------------------
***************
*** 547,553 ****
);
! CREATE INDEX article_ticket_i77 ON article (ticket_id);
! CREATE INDEX article_message_40 ON article (a_message_id);
-- ----------------------------------------------------------
--- 547,553 ----
);
! CREATE INDEX article_ticket_i0 ON article (ticket_id);
! CREATE INDEX article_message_21 ON article (a_message_id);
-- ----------------------------------------------------------
***************
*** 565,569 ****
);
! CREATE INDEX article_plain_ar13 ON article_plain (article_id);
-- ----------------------------------------------------------
--- 565,569 ----
);
! CREATE INDEX article_plain_ar71 ON article_plain (article_id);
-- ----------------------------------------------------------
***************
*** 584,588 ****
);
! CREATE INDEX article_attachme59 ON article_attachment (article_id);
-- ----------------------------------------------------------
--- 584,588 ----
);
! CREATE INDEX article_attachme96 ON article_attachment (article_id);
-- ----------------------------------------------------------
***************
*** 715,719 ****
);
! CREATE INDEX index_time_accou53 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
--- 715,719 ----
);
! CREATE INDEX index_time_accou2 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
***************
*** 770,774 ****
);
! CREATE INDEX index_session_id24 ON sessions (session_id);
-- ----------------------------------------------------------
--- 770,774 ----
);
! CREATE INDEX index_session_id80 ON sessions (session_id);
-- ----------------------------------------------------------
***************
*** 785,789 ****
);
! CREATE INDEX index_ticket_ind46 ON ticket_index (ticket_id);
-- ----------------------------------------------------------
--- 785,789 ----
);
! CREATE INDEX index_ticket_ind67 ON ticket_index (ticket_id);
-- ----------------------------------------------------------
***************
*** 794,798 ****
);
! CREATE INDEX index_ticket_loc39 ON ticket_lock_index (ticket_id);
-- ----------------------------------------------------------
--- 794,798 ----
);
! CREATE INDEX index_ticket_loc30 ON ticket_lock_index (ticket_id);
-- ----------------------------------------------------------
***************
*** 827,831 ****
);
! CREATE INDEX index_customer_p91 ON customer_preferences (user_id);
-- ----------------------------------------------------------
--- 827,831 ----
);
! CREATE INDEX index_customer_p89 ON customer_preferences (user_id);
-- ----------------------------------------------------------
***************
*** 837,843 ****
);
! CREATE INDEX index_ticket_loo50 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loo22 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
--- 837,843 ----
);
! CREATE INDEX index_ticket_loo61 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loo17 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
***************
*** 941,947 ****
CREATE INDEX xml_content_key ON xml_storage (xml_content_key);
! CREATE INDEX xml_type ON xml_storage (xml_type);
!
! CREATE INDEX xml_key ON xml_storage (xml_key);
-- ----------------------------------------------------------
--- 941,945 ----
CREATE INDEX xml_content_key ON xml_storage (xml_content_key);
! CREATE INDEX xml_type_key ON xml_storage (xml_type, xml_key);
-- ----------------------------------------------------------
Author: mh
Index: otrs-schema.maxdb.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.maxdb.sql,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
*** otrs-schema.maxdb.sql 16 Mar 2007 10:02:13 -0000 1.14
--- otrs-schema.maxdb.sql 2 Apr 2007 13:41:36 -0000 1.15
***************
*** 1,4 ****
// ----------------------------------------------------------
! // driver: maxdb, generated: 2007-03-16 11:00:01
// ----------------------------------------------------------
// ----------------------------------------------------------
--- 1,4 ----
// ----------------------------------------------------------
! // driver: maxdb, generated: 2007-04-02 15:40:29
// ----------------------------------------------------------
// ----------------------------------------------------------
***************
*** 89,93 ****
)
//
! CREATE INDEX index_user_preferenc49 ON user_preferences (user_id)
//
// ----------------------------------------------------------
--- 89,93 ----
)
//
! CREATE INDEX index_user_preferenc77 ON user_preferences (user_id)
//
// ----------------------------------------------------------
***************
*** 412,418 ****
CREATE INDEX index_ticket_type ON ticket (type_id)
//
! CREATE INDEX index_ticket_queue_v23 ON ticket (ticket_state_id, ticket_lock_id, group_id)
//
! CREATE INDEX index_ticket_answere45 ON ticket (ticket_answered)
//
// ----------------------------------------------------------
--- 412,418 ----
CREATE INDEX index_ticket_type ON ticket (type_id)
//
! CREATE INDEX index_ticket_queue_v7 ON ticket (ticket_state_id, ticket_lock_id, group_id)
//
! CREATE INDEX index_ticket_answere56 ON ticket (ticket_answered)
//
// ----------------------------------------------------------
***************
*** 449,455 ****
)
//
! CREATE INDEX ticket_history_ticke1 ON ticket_history (ticket_id)
//
! CREATE INDEX ticket_history_creat18 ON ticket_history (create_time)
//
// ----------------------------------------------------------
--- 449,455 ----
)
//
! CREATE INDEX ticket_history_ticke30 ON ticket_history (ticket_id)
//
! CREATE INDEX ticket_history_creat68 ON ticket_history (create_time)
//
// ----------------------------------------------------------
***************
*** 511,515 ****
)
//
! CREATE INDEX article_flag_create_28 ON article_flag (create_by)
//
CREATE INDEX article_flag_article46 ON article_flag (article_id)
--- 511,515 ----
)
//
! CREATE INDEX article_flag_create_57 ON article_flag (create_by)
//
CREATE INDEX article_flag_article46 ON article_flag (article_id)
***************
*** 565,569 ****
)
//
! CREATE INDEX article_plain_articl83 ON article_plain (article_id)
//
// ----------------------------------------------------------
--- 565,569 ----
)
//
! CREATE INDEX article_plain_articl55 ON article_plain (article_id)
//
// ----------------------------------------------------------
***************
*** 584,588 ****
)
//
! CREATE INDEX article_attachment_a81 ON article_attachment (article_id)
//
// ----------------------------------------------------------
--- 584,588 ----
)
//
! CREATE INDEX article_attachment_a37 ON article_attachment (article_id)
//
// ----------------------------------------------------------
***************
*** 715,719 ****
)
//
! CREATE INDEX index_time_accountin20 ON time_accounting (ticket_id)
//
// ----------------------------------------------------------
--- 715,719 ----
)
//
! CREATE INDEX index_time_accountin7 ON time_accounting (ticket_id)
//
// ----------------------------------------------------------
***************
*** 785,789 ****
)
//
! CREATE INDEX index_ticket_index_t59 ON ticket_index (ticket_id)
//
// ----------------------------------------------------------
--- 785,789 ----
)
//
! CREATE INDEX index_ticket_index_t24 ON ticket_index (ticket_id)
//
// ----------------------------------------------------------
***************
*** 794,798 ****
)
//
! CREATE INDEX index_ticket_lock_ti74 ON ticket_lock_index (ticket_id)
//
// ----------------------------------------------------------
--- 794,798 ----
)
//
! CREATE INDEX index_ticket_lock_ti55 ON ticket_lock_index (ticket_id)
//
// ----------------------------------------------------------
***************
*** 827,831 ****
)
//
! CREATE INDEX index_customer_prefe4 ON customer_preferences (user_id)
//
// ----------------------------------------------------------
--- 827,831 ----
)
//
! CREATE INDEX index_customer_prefe59 ON customer_preferences (user_id)
//
// ----------------------------------------------------------
***************
*** 837,843 ****
)
//
! CREATE INDEX index_ticket_loop_pr3 ON ticket_loop_protection (sent_to)
//
! CREATE INDEX index_ticket_loop_pr35 ON ticket_loop_protection (sent_date)
//
// ----------------------------------------------------------
--- 837,843 ----
)
//
! CREATE INDEX index_ticket_loop_pr15 ON ticket_loop_protection (sent_to)
//
! CREATE INDEX index_ticket_loop_pr51 ON ticket_loop_protection (sent_date)
//
// ----------------------------------------------------------
***************
*** 941,947 ****
CREATE INDEX xml_content_key ON xml_storage (xml_content_key)
//
! CREATE INDEX xml_type ON xml_storage (xml_type)
! //
! CREATE INDEX xml_key ON xml_storage (xml_key)
//
// ----------------------------------------------------------
--- 941,945 ----
CREATE INDEX xml_content_key ON xml_storage (xml_content_key)
//
! CREATE INDEX xml_type_key ON xml_storage (xml_type, xml_key)
//
// ----------------------------------------------------------
Author: mh
Index: otrs-schema.mssql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.mssql.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** otrs-schema.mssql.sql 16 Mar 2007 10:02:13 -0000 1.9
--- otrs-schema.mssql.sql 2 Apr 2007 13:41:36 -0000 1.10
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2007-03-16 11:00:01
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2007-04-02 15:40:38
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 863,868 ****
);
CREATE INDEX xml_content_key ON xml_storage (xml_content_key);
! CREATE INDEX xml_type ON xml_storage (xml_type);
! CREATE INDEX xml_key ON xml_storage (xml_key);
-- ----------------------------------------------------------
-- create table package_repository
--- 863,867 ----
);
CREATE INDEX xml_content_key ON xml_storage (xml_content_key);
! CREATE INDEX xml_type_key ON xml_storage (xml_type, xml_key);
-- ----------------------------------------------------------
-- create table package_repository
Author: mh
Index: otrs-schema.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.mysql.sql,v
retrieving revision 1.55
retrieving revision 1.56
diff -C2 -d -r1.55 -r1.56
*** otrs-schema.mysql.sql 16 Mar 2007 10:02:13 -0000 1.55
--- otrs-schema.mysql.sql 2 Apr 2007 13:41:36 -0000 1.56
***************
*** 1,4 ****
# ----------------------------------------------------------
! # driver: mysql, generated: 2007-03-16 11:00:01
# ----------------------------------------------------------
# ----------------------------------------------------------
--- 1,4 ----
# ----------------------------------------------------------
! # driver: mysql, generated: 2007-04-02 15:39:21
# ----------------------------------------------------------
# ----------------------------------------------------------
***************
*** 862,867 ****
xml_content_value LONGBLOB,
INDEX xml_content_key (xml_content_key),
! INDEX xml_type (xml_type),
! INDEX xml_key (xml_key)
);
# ----------------------------------------------------------
--- 862,866 ----
xml_content_value LONGBLOB,
INDEX xml_content_key (xml_content_key),
! INDEX xml_type_key (xml_type, xml_key)
);
# ----------------------------------------------------------
Author: mh
Index: otrs-schema.oracle.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.oracle.sql,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -d -r1.20 -r1.21
*** otrs-schema.oracle.sql 16 Mar 2007 10:02:13 -0000 1.20
--- otrs-schema.oracle.sql 2 Apr 2007 13:41:36 -0000 1.21
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: oracle, generated: 2007-03-16 11:00:02
-- ----------------------------------------------------------
SET DEFINE OFF;
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: oracle, generated: 2007-04-02 15:40:47
-- ----------------------------------------------------------
SET DEFINE OFF;
***************
*** 900,911 ****
change_by NUMBER NOT NULL
);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT standard_response_attach89_PK PRIMARY KEY (id);
! DROP SEQUENCE standard_response_attach89_seq;
! CREATE SEQUENCE standard_response_attach89_seq;
! CREATE OR REPLACE TRIGGER standard_response_attach89_s_t
before insert on standard_response_attachment
for each row
begin
! select standard_response_attach89_seq.nextval
into :new.id
from dual;
--- 900,911 ----
change_by NUMBER NOT NULL
);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT standard_response_attach78_PK PRIMARY KEY (id);
! DROP SEQUENCE standard_response_attach78_seq;
! CREATE SEQUENCE standard_response_attach78_seq;
! CREATE OR REPLACE TRIGGER standard_response_attach78_s_t
before insert on standard_response_attachment
for each row
begin
! select standard_response_attach78_seq.nextval
into :new.id
from dual;
***************
*** 1024,1028 ****
/
--;
! CREATE INDEX index_time_accounting_ticket59 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
-- create table ticket_watcher
--- 1024,1028 ----
/
--;
! CREATE INDEX index_time_accounting_ticket33 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
-- create table ticket_watcher
***************
*** 1159,1163 ****
preferences_value VARCHAR2 (250)
);
! CREATE INDEX index_customer_preferences_u96 ON customer_preferences (user_id);
-- ----------------------------------------------------------
-- create table ticket_loop_protection
--- 1159,1163 ----
preferences_value VARCHAR2 (250)
);
! CREATE INDEX index_customer_preferences_u23 ON customer_preferences (user_id);
-- ----------------------------------------------------------
-- create table ticket_loop_protection
***************
*** 1167,1172 ****
sent_date VARCHAR2 (150) NOT NULL
);
! CREATE INDEX index_ticket_loop_protection22 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loop_protection61 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
-- create table pop3_account
--- 1167,1172 ----
sent_date VARCHAR2 (150) NOT NULL
);
! CREATE INDEX index_ticket_loop_protection11 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loop_protection32 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
-- create table pop3_account
***************
*** 1284,1289 ****
);
CREATE INDEX xml_content_key ON xml_storage (xml_content_key);
! CREATE INDEX xml_type ON xml_storage (xml_type);
! CREATE INDEX xml_key ON xml_storage (xml_key);
-- ----------------------------------------------------------
-- create table package_repository
--- 1284,1288 ----
);
CREATE INDEX xml_content_key ON xml_storage (xml_content_key);
! CREATE INDEX xml_type_key ON xml_storage (xml_type, xml_key);
-- ----------------------------------------------------------
-- create table package_repository
Author: mh
Index: otrs-schema.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.postgresql.sql,v
retrieving revision 1.54
retrieving revision 1.55
diff -C2 -d -r1.54 -r1.55
*** otrs-schema.postgresql.sql 16 Mar 2007 10:02:13 -0000 1.54
--- otrs-schema.postgresql.sql 2 Apr 2007 13:41:36 -0000 1.55
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2007-03-16 11:00:02
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2007-04-02 15:40:55
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 863,868 ****
);
CREATE INDEX xml_content_key ON xml_storage (xml_content_key);
! CREATE INDEX xml_type ON xml_storage (xml_type);
! CREATE INDEX xml_key ON xml_storage (xml_key);
-- ----------------------------------------------------------
-- create table package_repository
--- 863,867 ----
);
CREATE INDEX xml_content_key ON xml_storage (xml_content_key);
! CREATE INDEX xml_type_key ON xml_storage (xml_type, xml_key);
-- ----------------------------------------------------------
-- create table package_repository
Author: mh
Index: otrs-schema.xml
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.xml,v
retrieving revision 1.62
retrieving revision 1.63
diff -C2 -d -r1.62 -r1.63
*** otrs-schema.xml 16 Mar 2007 10:02:13 -0000 1.62
--- otrs-schema.xml 2 Apr 2007 13:41:36 -0000 1.63
***************
*** 9,12 ****
--- 9,15 ----
$Log$
+ Revision 1.63 2007/04/02 13:41:36 mh
+ Improved indexes of xml_storage table
+
Revision 1.62 2007/03/16 10:02:13 martin
Moved to new escalataion params like first_response_time, update_time and solution time.
***************
*** 1521,1528 ****
<Column Name="xml_content_key" Required="true" Size="250" Type="VARCHAR"/>
<Column Name="xml_content_value" Required="false" Type="LONGBLOB"/>
! <Index Name="xml_type">
<IndexColumn Name="xml_type"/>
- </Index>
- <Index Name="xml_key">
<IndexColumn Name="xml_key"/>
</Index>
--- 1524,1529 ----
<Column Name="xml_content_key" Required="true" Size="250" Type="VARCHAR"/>
<Column Name="xml_content_value" Required="false" Type="LONGBLOB"/>
! <Index Name="xml_type_key">
<IndexColumn Name="xml_type"/>
<IndexColumn Name="xml_key"/>
</Index>
More information about the cvs-log
mailing list