[otrs-cvs] otrs/scripts/database otrs-schema-post.db2.sql, 1.9,
1.10 otrs-schema-post.maxdb.sql, 1.10,
1.11 otrs-schema-post.mssql.sql, 1.6,
1.7 otrs-schema-post.mysql.sql, 1.13,
1.14 otrs-schema-post.oracle.sql, 1.13,
1.14 otrs-schema-post.postgresql.sql, 1.12,
1.13 otrs-schema.db2.sql, 1.15, 1.16 otrs-schema.maxdb.sql,
1.16, 1.17 otrs-schema.mssql.sql, 1.11,
1.12 otrs-schema.mysql.sql, 1.57, 1.58 otrs-schema.oracle.sql,
1.22, 1.23 otrs-schema.postgresql.sql, 1.56, 1.57
cvs-log at otrs.org
cvs-log at otrs.org
Thu Apr 12 09:24:19 GMT 2007
Comments:
Update of /home/cvs/otrs/scripts/database
In directory lancelot:/tmp/cvs-serv21981
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
Log Message:
Fixed bug# 1744 - Unable to create xml_storage table in utf8 charset on mysql database.
Author: mh
Index: otrs-schema-post.db2.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema-post.db2.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** otrs-schema-post.db2.sql 2 Apr 2007 13:41:36 -0000 1.9
--- otrs-schema-post.db2.sql 12 Apr 2007 09:24:14 -0000 1.10
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: db2, generated: 2007-04-02 15:40:20
-- ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES system_user(id);
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: db2, generated: 2007-04-12 11:18:50
-- ----------------------------------------------------------
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.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** otrs-schema-post.maxdb.sql 2 Apr 2007 13:41:36 -0000 1.10
--- otrs-schema-post.maxdb.sql 12 Apr 2007 09:24:14 -0000 1.11
***************
*** 1,4 ****
// ----------------------------------------------------------
! // driver: maxdb, generated: 2007-04-02 15:40:29
// ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES system_user(id)
--- 1,4 ----
// ----------------------------------------------------------
! // driver: maxdb, generated: 2007-04-12 11:19:00
// ----------------------------------------------------------
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.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** otrs-schema-post.mssql.sql 2 Apr 2007 13:41:36 -0000 1.6
--- otrs-schema-post.mssql.sql 12 Apr 2007 09:24:14 -0000 1.7
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2007-04-02 15:40:38
-- ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2007-04-12 11:19:09
-- ----------------------------------------------------------
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.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** otrs-schema-post.mysql.sql 2 Apr 2007 13:41:36 -0000 1.13
--- otrs-schema-post.mysql.sql 12 Apr 2007 09:24:14 -0000 1.14
***************
*** 1,4 ****
# ----------------------------------------------------------
! # driver: mysql, generated: 2007-04-02 15:39:21
# ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
--- 1,4 ----
# ----------------------------------------------------------
! # driver: mysql, generated: 2007-04-12 11:18:39
# ----------------------------------------------------------
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.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** otrs-schema-post.oracle.sql 2 Apr 2007 13:41:36 -0000 1.13
--- otrs-schema-post.oracle.sql 12 Apr 2007 09:24:14 -0000 1.14
***************
*** 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);
--- 1,16 ----
-- ----------------------------------------------------------
! -- driver: oracle, generated: 2007-04-12 11:19:18
-- ----------------------------------------------------------
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_by75 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_priority ADD CONSTRAINT fk_ticket_priority_change_by54 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_b46 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_lock_type ADD CONSTRAINT fk_ticket_lock_type_change_b46 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE ticket_lock_type ADD CONSTRAINT fk_ticket_lock_type_valid_id23 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);
***************
*** 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);
--- 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_group82 FOREIGN KEY (group_id) REFERENCES groups(id);
! ALTER TABLE group_customer_user ADD CONSTRAINT fk_group_customer_user_creat72 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE group_customer_user ADD CONSTRAINT fk_group_customer_user_chang46 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);
***************
*** 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);
--- 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_86 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_state_type ADD CONSTRAINT fk_ticket_state_type_change_37 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);
***************
*** 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);
--- 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_create2 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE follow_up_possible ADD CONSTRAINT fk_follow_up_possible_change83 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE follow_up_possible ADD CONSTRAINT fk_follow_up_possible_valid_94 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);
***************
*** 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);
--- 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_id78 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_i36 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);
***************
*** 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);
--- 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_i40 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);
***************
*** 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);
--- 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_ty87 FOREIGN KEY (history_type_id) REFERENCES ticket_history_type(id);
! ALTER TABLE ticket_history ADD CONSTRAINT fk_ticket_history_article_id40 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_creat45 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE ticket_history_type ADD CONSTRAINT fk_ticket_history_type_chang19 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE ticket_history_type ADD CONSTRAINT fk_ticket_history_type_valid54 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_creat7 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE article_sender_type ADD CONSTRAINT fk_article_sender_type_chang95 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE article_sender_type ADD CONSTRAINT fk_article_sender_type_valid73 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_ty59 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);
***************
*** 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);
--- 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_create60 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE article_attachment ADD CONSTRAINT fk_article_attachment_change30 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE article_attachment ADD CONSTRAINT fk_article_attachment_articl33 FOREIGN KEY (article_id) REFERENCES article(id);
! ALTER TABLE standard_response ADD CONSTRAINT fk_standard_response_create_46 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE standard_response ADD CONSTRAINT fk_standard_response_change_21 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE standard_response ADD CONSTRAINT fk_standard_response_valid_i48 FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_c82 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_c60 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_s51 FOREIGN KEY (standard_response_id) REFERENCES standard_response(id);
! ALTER TABLE queue_standard_response ADD CONSTRAINT fk_queue_standard_response_q72 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_chang66 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE standard_attachment ADD CONSTRAINT fk_standard_attachment_valid8 FOREIGN KEY (valid_id) REFERENCES valid(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm92 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm70 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm75 FOREIGN KEY (standard_response_id) REFERENCES standard_response(id);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT fk_standard_response_attachm36 FOREIGN KEY (standard_attachment_id) REFERENCES standard_attachment(id);
! ALTER TABLE auto_response_type ADD CONSTRAINT fk_auto_response_type_create81 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE auto_response_type ADD CONSTRAINT fk_auto_response_type_change65 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE auto_response_type ADD CONSTRAINT fk_auto_response_type_valid_48 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_addr11 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_5 FOREIGN KEY (auto_response_id) REFERENCES auto_response(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_creat21 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_chang21 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE queue_auto_response ADD CONSTRAINT fk_queue_auto_response_queue44 FOREIGN KEY (queue_id) REFERENCES queue(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_create_by9 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_change_by96 FOREIGN KEY (change_by) REFERENCES system_user(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_article_i12 FOREIGN KEY (article_id) REFERENCES article(id);
! ALTER TABLE time_accounting ADD CONSTRAINT fk_time_accounting_ticket_id84 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);
***************
*** 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);
--- 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_create88 FOREIGN KEY (create_by) REFERENCES system_user(id);
! ALTER TABLE package_repository ADD CONSTRAINT fk_package_repository_change40 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.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** otrs-schema-post.postgresql.sql 2 Apr 2007 13:41:36 -0000 1.12
--- otrs-schema-post.postgresql.sql 12 Apr 2007 09:24:14 -0000 1.13
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2007-04-02 15:40:55
-- ----------------------------------------------------------
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES system_user(id);
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2007-04-12 11:19:29
-- ----------------------------------------------------------
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.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** otrs-schema.db2.sql 2 Apr 2007 14:53:39 -0000 1.15
--- otrs-schema.db2.sql 12 Apr 2007 09:24:14 -0000 1.16
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: db2, generated: 2007-04-02 16:52:36
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: db2, generated: 2007-04-12 11:18:50
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 89,93 ****
);
! CREATE INDEX index_user_prefe58 ON user_preferences (user_id);
-- ----------------------------------------------------------
--- 89,93 ----
);
! CREATE INDEX index_user_prefe3 ON user_preferences (user_id);
-- ----------------------------------------------------------
***************
*** 408,418 ****
);
! CREATE INDEX index_ticket_use76 ON ticket (user_id);
! CREATE INDEX index_ticket_typ13 ON ticket (type_id);
! CREATE INDEX index_ticket_que66 ON ticket (ticket_state_id, ticket_lock_id, group_id);
! CREATE INDEX index_ticket_ans13 ON ticket (ticket_answered);
-- ----------------------------------------------------------
--- 408,418 ----
);
! CREATE INDEX index_ticket_use93 ON ticket (user_id);
! CREATE INDEX index_ticket_typ53 ON ticket (type_id);
! CREATE INDEX index_ticket_que55 ON ticket (ticket_state_id, ticket_lock_id, group_id);
! CREATE INDEX index_ticket_ans59 ON ticket (ticket_answered);
-- ----------------------------------------------------------
***************
*** 449,455 ****
);
! CREATE INDEX ticket_history_t62 ON ticket_history (ticket_id);
! CREATE INDEX ticket_history_c6 ON ticket_history (create_time);
-- ----------------------------------------------------------
--- 449,455 ----
);
! CREATE INDEX ticket_history_t92 ON ticket_history (ticket_id);
! CREATE INDEX ticket_history_c37 ON ticket_history (create_time);
-- ----------------------------------------------------------
***************
*** 511,517 ****
);
! CREATE INDEX article_flag_cre9 ON article_flag (create_by);
! CREATE INDEX article_flag_art23 ON article_flag (article_id);
-- ----------------------------------------------------------
--- 511,517 ----
);
! CREATE INDEX article_flag_cre41 ON article_flag (create_by);
! CREATE INDEX article_flag_art26 ON article_flag (article_id);
-- ----------------------------------------------------------
***************
*** 547,553 ****
);
! CREATE INDEX article_ticket_i51 ON article (ticket_id);
! CREATE INDEX article_message_28 ON article (a_message_id);
-- ----------------------------------------------------------
--- 547,553 ----
);
! CREATE INDEX article_ticket_i55 ON article (ticket_id);
! CREATE INDEX article_message_68 ON article (a_message_id);
-- ----------------------------------------------------------
***************
*** 565,569 ****
);
! CREATE INDEX article_plain_ar27 ON article_plain (article_id);
-- ----------------------------------------------------------
--- 565,569 ----
);
! CREATE INDEX article_plain_ar82 ON article_plain (article_id);
-- ----------------------------------------------------------
***************
*** 584,588 ****
);
! CREATE INDEX article_attachme16 ON article_attachment (article_id);
-- ----------------------------------------------------------
--- 584,588 ----
);
! CREATE INDEX article_attachme0 ON article_attachment (article_id);
-- ----------------------------------------------------------
***************
*** 715,719 ****
);
! CREATE INDEX index_time_accou3 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
--- 715,719 ----
);
! CREATE INDEX index_time_accou22 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
***************
*** 729,733 ****
);
! CREATE INDEX ticket_id ON ticket_watcher (ticket_id);
CREATE TABLE service (
--- 729,733 ----
);
! CREATE INDEX ticket_watcher_t29 ON ticket_watcher (ticket_id);
CREATE TABLE service (
***************
*** 770,774 ****
);
! CREATE INDEX index_session_id13 ON sessions (session_id);
-- ----------------------------------------------------------
--- 770,774 ----
);
! CREATE INDEX index_session_id63 ON sessions (session_id);
-- ----------------------------------------------------------
***************
*** 794,798 ****
);
! CREATE INDEX index_ticket_loc97 ON ticket_lock_index (ticket_id);
-- ----------------------------------------------------------
--- 794,798 ----
);
! CREATE INDEX index_ticket_loc33 ON ticket_lock_index (ticket_id);
-- ----------------------------------------------------------
***************
*** 827,831 ****
);
! CREATE INDEX index_customer_p55 ON customer_preferences (user_id);
-- ----------------------------------------------------------
--- 827,831 ----
);
! CREATE INDEX index_customer_p22 ON customer_preferences (user_id);
-- ----------------------------------------------------------
***************
*** 846,851 ****
change_time TIMESTAMP NOT NULL,
change_by INTEGER NOT NULL,
! UNIQUE (customer_id),
! UNIQUE (name)
);
--- 846,851 ----
change_time TIMESTAMP NOT NULL,
change_by INTEGER NOT NULL,
! UNIQUE (name),
! UNIQUE (customer_id)
);
***************
*** 858,864 ****
);
! CREATE INDEX index_ticket_loo61 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loo18 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
--- 858,864 ----
);
! CREATE INDEX index_ticket_loo39 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loo49 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
***************
*** 960,966 ****
);
! CREATE INDEX xml_content_key ON xml_storage (xml_content_key);
! CREATE INDEX xml_type_key ON xml_storage (xml_type, xml_key);
-- ----------------------------------------------------------
--- 960,966 ----
);
! CREATE INDEX xml_storage_xml_71 ON xml_storage (xml_content_key);
! CREATE INDEX xml_storage_key_94 ON xml_storage (xml_key, xml_type);
-- ----------------------------------------------------------
Author: mh
Index: otrs-schema.maxdb.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.maxdb.sql,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** otrs-schema.maxdb.sql 2 Apr 2007 14:53:39 -0000 1.16
--- otrs-schema.maxdb.sql 12 Apr 2007 09:24:14 -0000 1.17
***************
*** 1,4 ****
// ----------------------------------------------------------
! // driver: maxdb, generated: 2007-04-02 16:52:36
// ----------------------------------------------------------
// ----------------------------------------------------------
--- 1,4 ----
// ----------------------------------------------------------
! // driver: maxdb, generated: 2007-04-12 11:19:00
// ----------------------------------------------------------
// ----------------------------------------------------------
***************
*** 89,93 ****
)
//
! CREATE INDEX index_user_preferenc11 ON user_preferences (user_id)
//
// ----------------------------------------------------------
--- 89,93 ----
)
//
! CREATE INDEX index_user_preferenc88 ON user_preferences (user_id)
//
// ----------------------------------------------------------
***************
*** 412,418 ****
CREATE INDEX index_ticket_type ON ticket (type_id)
//
! CREATE INDEX index_ticket_queue_v61 ON ticket (ticket_state_id, ticket_lock_id, group_id)
//
! CREATE INDEX index_ticket_answere38 ON ticket (ticket_answered)
//
// ----------------------------------------------------------
--- 412,418 ----
CREATE INDEX index_ticket_type ON ticket (type_id)
//
! CREATE INDEX index_ticket_queue_v13 ON ticket (ticket_state_id, ticket_lock_id, group_id)
//
! CREATE INDEX index_ticket_answere25 ON ticket (ticket_answered)
//
// ----------------------------------------------------------
***************
*** 449,455 ****
)
//
! CREATE INDEX ticket_history_ticke77 ON ticket_history (ticket_id)
//
! CREATE INDEX ticket_history_creat39 ON ticket_history (create_time)
//
// ----------------------------------------------------------
--- 449,455 ----
)
//
! CREATE INDEX ticket_history_ticke69 ON ticket_history (ticket_id)
//
! CREATE INDEX ticket_history_creat46 ON ticket_history (create_time)
//
// ----------------------------------------------------------
***************
*** 511,517 ****
)
//
! CREATE INDEX article_flag_create_27 ON article_flag (create_by)
//
! CREATE INDEX article_flag_article60 ON article_flag (article_id)
//
// ----------------------------------------------------------
--- 511,517 ----
)
//
! CREATE INDEX article_flag_create_37 ON article_flag (create_by)
//
! CREATE INDEX article_flag_article95 ON article_flag (article_id)
//
// ----------------------------------------------------------
***************
*** 565,569 ****
)
//
! CREATE INDEX article_plain_articl29 ON article_plain (article_id)
//
// ----------------------------------------------------------
--- 565,569 ----
)
//
! CREATE INDEX article_plain_articl16 ON article_plain (article_id)
//
// ----------------------------------------------------------
***************
*** 584,588 ****
)
//
! CREATE INDEX article_attachment_a40 ON article_attachment (article_id)
//
// ----------------------------------------------------------
--- 584,588 ----
)
//
! CREATE INDEX article_attachment_a50 ON article_attachment (article_id)
//
// ----------------------------------------------------------
***************
*** 715,719 ****
)
//
! CREATE INDEX index_time_accountin10 ON time_accounting (ticket_id)
//
// ----------------------------------------------------------
--- 715,719 ----
)
//
! CREATE INDEX index_time_accountin36 ON time_accounting (ticket_id)
//
// ----------------------------------------------------------
***************
*** 729,733 ****
)
//
! CREATE INDEX ticket_id ON ticket_watcher (ticket_id)
//
CREATE TABLE service (
--- 729,733 ----
)
//
! CREATE INDEX ticket_watcher_ticke45 ON ticket_watcher (ticket_id)
//
CREATE TABLE service (
***************
*** 785,789 ****
)
//
! CREATE INDEX index_ticket_index_t61 ON ticket_index (ticket_id)
//
// ----------------------------------------------------------
--- 785,789 ----
)
//
! CREATE INDEX index_ticket_index_t0 ON ticket_index (ticket_id)
//
// ----------------------------------------------------------
***************
*** 794,798 ****
)
//
! CREATE INDEX index_ticket_lock_ti98 ON ticket_lock_index (ticket_id)
//
// ----------------------------------------------------------
--- 794,798 ----
)
//
! CREATE INDEX index_ticket_lock_ti75 ON ticket_lock_index (ticket_id)
//
// ----------------------------------------------------------
***************
*** 827,831 ****
)
//
! CREATE INDEX index_customer_prefe52 ON customer_preferences (user_id)
//
// ----------------------------------------------------------
--- 827,831 ----
)
//
! CREATE INDEX index_customer_prefe1 ON customer_preferences (user_id)
//
// ----------------------------------------------------------
***************
*** 846,851 ****
change_time timestamp NOT NULL,
change_by INTEGER NOT NULL,
! UNIQUE (name),
! UNIQUE (customer_id)
)
//
--- 846,851 ----
change_time timestamp NOT NULL,
change_by INTEGER NOT NULL,
! UNIQUE (customer_id),
! UNIQUE (name)
)
//
***************
*** 858,864 ****
)
//
! CREATE INDEX index_ticket_loop_pr58 ON ticket_loop_protection (sent_to)
//
! CREATE INDEX index_ticket_loop_pr93 ON ticket_loop_protection (sent_date)
//
// ----------------------------------------------------------
--- 858,864 ----
)
//
! CREATE INDEX index_ticket_loop_pr92 ON ticket_loop_protection (sent_to)
//
! CREATE INDEX index_ticket_loop_pr13 ON ticket_loop_protection (sent_date)
//
// ----------------------------------------------------------
***************
*** 960,966 ****
)
//
! CREATE INDEX xml_content_key ON xml_storage (xml_content_key)
//
! CREATE INDEX xml_type_key ON xml_storage (xml_type, xml_key)
//
// ----------------------------------------------------------
--- 960,966 ----
)
//
! CREATE INDEX xml_storage_xml_cont21 ON xml_storage (xml_content_key)
//
! CREATE INDEX xml_storage_key_type57 ON xml_storage (xml_key, xml_type)
//
// ----------------------------------------------------------
Author: mh
Index: otrs-schema.mssql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.mssql.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** otrs-schema.mssql.sql 2 Apr 2007 14:53:39 -0000 1.11
--- otrs-schema.mssql.sql 12 Apr 2007 09:24:14 -0000 1.12
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2007-04-02 16:52:36
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2007-04-12 11:19:09
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 675,679 ****
change_by INTEGER NOT NULL
);
! CREATE INDEX ticket_id ON ticket_watcher (ticket_id);
CREATE TABLE service (
id INTEGER NOT NULL IDENTITY(1,1) ,
--- 675,679 ----
change_by INTEGER NOT NULL
);
! CREATE INDEX ticket_watcher_ticket_id ON ticket_watcher (ticket_id);
CREATE TABLE service (
id INTEGER NOT NULL IDENTITY(1,1) ,
***************
*** 780,785 ****
change_time DATETIME NOT NULL,
change_by INTEGER NOT NULL,
! UNIQUE (name),
! UNIQUE (customer_id)
);
-- ----------------------------------------------------------
--- 780,785 ----
change_time DATETIME NOT NULL,
change_by INTEGER NOT NULL,
! UNIQUE (customer_id),
! UNIQUE (name)
);
-- ----------------------------------------------------------
***************
*** 882,887 ****
xml_content_value TEXT
);
! 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
--- 882,887 ----
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
Author: mh
Index: otrs-schema.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.mysql.sql,v
retrieving revision 1.57
retrieving revision 1.58
diff -C2 -d -r1.57 -r1.58
*** otrs-schema.mysql.sql 2 Apr 2007 14:53:39 -0000 1.57
--- otrs-schema.mysql.sql 12 Apr 2007 09:24:14 -0000 1.58
***************
*** 1,4 ****
# ----------------------------------------------------------
! # driver: mysql, generated: 2007-04-02 16:52:37
# ----------------------------------------------------------
# ----------------------------------------------------------
--- 1,4 ----
# ----------------------------------------------------------
! # driver: mysql, generated: 2007-04-12 11:18:39
# ----------------------------------------------------------
# ----------------------------------------------------------
***************
*** 674,678 ****
change_time DATETIME NOT NULL,
change_by INTEGER NOT NULL,
! INDEX ticket_id (ticket_id)
);
CREATE TABLE service (
--- 674,678 ----
change_time DATETIME NOT NULL,
change_by INTEGER NOT NULL,
! INDEX ticket_watcher_ticket_id (ticket_id)
);
CREATE TABLE service (
***************
*** 881,886 ****
xml_content_key VARCHAR (250) NOT NULL,
xml_content_value LONGBLOB,
! INDEX xml_content_key (xml_content_key),
! INDEX xml_type_key (xml_type, xml_key)
);
# ----------------------------------------------------------
--- 881,886 ----
xml_content_key VARCHAR (250) NOT NULL,
xml_content_value LONGBLOB,
! INDEX xml_storage_xml_content_key (xml_content_key(100)),
! INDEX xml_storage_key_type (xml_key(10), xml_type(10))
);
# ----------------------------------------------------------
Author: mh
Index: otrs-schema.oracle.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.oracle.sql,v
retrieving revision 1.22
retrieving revision 1.23
diff -C2 -d -r1.22 -r1.23
*** otrs-schema.oracle.sql 2 Apr 2007 14:53:39 -0000 1.22
--- otrs-schema.oracle.sql 12 Apr 2007 09:24:14 -0000 1.23
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: oracle, generated: 2007-04-02 16:52:37
-- ----------------------------------------------------------
SET DEFINE OFF;
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: oracle, generated: 2007-04-12 11:19:18
-- ----------------------------------------------------------
SET DEFINE OFF;
***************
*** 900,911 ****
change_by NUMBER NOT NULL
);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT standard_response_attach42_PK PRIMARY KEY (id);
! DROP SEQUENCE standard_response_attach42_seq;
! CREATE SEQUENCE standard_response_attach42_seq;
! CREATE OR REPLACE TRIGGER standard_response_attach42_s_t
before insert on standard_response_attachment
for each row
begin
! select standard_response_attach42_seq.nextval
into :new.id
from dual;
--- 900,911 ----
change_by NUMBER NOT NULL
);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT standard_response_attach45_PK PRIMARY KEY (id);
! DROP SEQUENCE standard_response_attach45_seq;
! CREATE SEQUENCE standard_response_attach45_seq;
! CREATE OR REPLACE TRIGGER standard_response_attach45_s_t
before insert on standard_response_attachment
for each row
begin
! select standard_response_attach45_seq.nextval
into :new.id
from dual;
***************
*** 1024,1028 ****
/
--;
! CREATE INDEX index_time_accounting_ticket66 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
-- create table ticket_watcher
--- 1024,1028 ----
/
--;
! CREATE INDEX index_time_accounting_ticket51 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
-- create table ticket_watcher
***************
*** 1036,1040 ****
change_by NUMBER NOT NULL
);
! CREATE INDEX ticket_id ON ticket_watcher (ticket_id);
CREATE TABLE service (
id NUMBER NOT NULL,
--- 1036,1040 ----
change_by NUMBER NOT NULL
);
! CREATE INDEX ticket_watcher_ticket_id ON ticket_watcher (ticket_id);
CREATE TABLE service (
id NUMBER NOT NULL,
***************
*** 1159,1163 ****
preferences_value VARCHAR2 (250)
);
! CREATE INDEX index_customer_preferences_u10 ON customer_preferences (user_id);
-- ----------------------------------------------------------
-- create table customer_company
--- 1159,1163 ----
preferences_value VARCHAR2 (250)
);
! CREATE INDEX index_customer_preferences_u61 ON customer_preferences (user_id);
-- ----------------------------------------------------------
-- create table customer_company
***************
*** 1187,1192 ****
sent_date VARCHAR2 (150) NOT NULL
);
! CREATE INDEX index_ticket_loop_protection27 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loop_protection23 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
-- create table pop3_account
--- 1187,1192 ----
sent_date VARCHAR2 (150) NOT NULL
);
! CREATE INDEX index_ticket_loop_protection55 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loop_protection92 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
-- create table pop3_account
***************
*** 1303,1308 ****
xml_content_value CLOB
);
! 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
--- 1303,1308 ----
xml_content_value CLOB
);
! 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
Author: mh
Index: otrs-schema.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.postgresql.sql,v
retrieving revision 1.56
retrieving revision 1.57
diff -C2 -d -r1.56 -r1.57
*** otrs-schema.postgresql.sql 2 Apr 2007 14:53:39 -0000 1.56
--- otrs-schema.postgresql.sql 12 Apr 2007 09:24:14 -0000 1.57
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2007-04-02 16:52:38
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2007-04-12 11:19:29
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 675,679 ****
change_by INTEGER NOT NULL
);
! CREATE INDEX ticket_id ON ticket_watcher (ticket_id);
CREATE TABLE service (
id serial,
--- 675,679 ----
change_by INTEGER NOT NULL
);
! CREATE INDEX ticket_watcher_ticket_id ON ticket_watcher (ticket_id);
CREATE TABLE service (
id serial,
***************
*** 882,887 ****
xml_content_value TEXT
);
! 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
--- 882,887 ----
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
More information about the cvs-log
mailing list