[otrs-cvs] otrs/scripts DBUpdate-to-2.3-schema.db2.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.maxdb.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.mssql.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.mysql.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.oracle.sql, 1.2, 1.3 DBUpdate-to-2.3-schema.postgresql.sql, 1.2, 1.3
CVS commits notifications of OTRS.org
cvs-log at otrs.org
Tue Apr 29 23:44:46 GMT 2008
Comments:
Update of /home/cvs/otrs/scripts
In directory lancelot:/tmp/cvs-serv9683/scripts
Modified Files:
DBUpdate-to-2.3-schema.db2.sql
DBUpdate-to-2.3-schema.maxdb.sql
DBUpdate-to-2.3-schema.mssql.sql
DBUpdate-to-2.3-schema.mysql.sql
DBUpdate-to-2.3-schema.oracle.sql
DBUpdate-to-2.3-schema.postgresql.sql
Log Message:
Added missing indexes and foreign keys.
Author: martin
Index: DBUpdate-to-2.3-schema.db2.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.3-schema.db2.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** DBUpdate-to-2.3-schema.db2.sql 28 Mar 2008 11:28:25 -0000 1.2
--- DBUpdate-to-2.3-schema.db2.sql 29 Apr 2008 23:44:41 -0000 1.3
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: db2, generated: 2008-03-28 12:27:28
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: db2, generated: 2008-04-30 01:39:46
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 11,15 ****
);
! CREATE INDEX index_queue_pref96 ON queue_preferences (queue_id);
-- ----------------------------------------------------------
--- 11,33 ----
);
! CREATE INDEX index_queue_pref23 ON queue_preferences (queue_id);
!
! CREATE INDEX user_preferences65 ON user_preferences (user_id);
!
! CREATE INDEX group_user_user_70 ON group_user (user_id);
!
! CREATE INDEX group_user_group5 ON group_user (group_id);
!
! CREATE INDEX group_role_role_56 ON group_role (role_id);
!
! CREATE INDEX group_role_group56 ON group_role (group_id);
!
! CREATE INDEX group_customer_u43 ON group_customer_user (user_id);
!
! CREATE INDEX group_customer_u2 ON group_customer_user (group_id);
!
! CREATE INDEX personal_queues_0 ON personal_queues (user_id);
!
! CREATE INDEX personal_queues_79 ON personal_queues (queue_id);
-- ----------------------------------------------------------
***************
*** 28,31 ****
--- 46,87 ----
ALTER TABLE queue ADD solution_notify SMALLINT;
+ CREATE INDEX queue_group_id ON queue (group_id);
+
+ CREATE INDEX ticket_title ON ticket (title);
+
+ CREATE INDEX ticket_customer_45 ON ticket (customer_user_id);
+
+ CREATE INDEX ticket_customer_77 ON ticket (customer_id);
+
+ CREATE INDEX ticket_queue_id ON ticket (queue_id);
+
+ CREATE INDEX ticket_responsib23 ON ticket (responsible_user_id);
+
+ CREATE INDEX index_object_lin18 ON object_link (object_link_a_id);
+
+ CREATE INDEX index_object_lin93 ON object_link (object_link_b_id);
+
+ CREATE INDEX index_object_lin40 ON object_link (object_link_a_object);
+
+ CREATE INDEX index_object_lin9 ON object_link (object_link_b_object);
+
+ CREATE INDEX index_object_lin83 ON object_link (object_link_type);
+
+ CREATE INDEX ticket_history_h48 ON ticket_history (history_type_id);
+
+ CREATE INDEX ticket_history_q4 ON ticket_history (queue_id);
+
+ CREATE INDEX ticket_history_t44 ON ticket_history (type_id);
+
+ CREATE INDEX ticket_history_o33 ON ticket_history (owner_id);
+
+ CREATE INDEX ticket_history_p90 ON ticket_history (priority_id);
+
+ CREATE INDEX ticket_history_s77 ON ticket_history (state_id);
+
+ CREATE INDEX ticket_history_p7 ON ticket_history (priority_id);
+
+ CREATE INDEX ticket_history_s97 ON ticket_history (state_id);
+
-- ----------------------------------------------------------
-- alter table sla
***************
*** 43,46 ****
--- 99,128 ----
ALTER TABLE sla ADD solution_notify SMALLINT;
+ CREATE INDEX article_article_43 ON article (article_type_id);
+
+ CREATE INDEX article_sender_t26 ON article (article_sender_type_id);
+
+ CREATE INDEX ticket_watcher_u81 ON ticket_watcher (user_id);
+
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (ticket_id) REFERENCES ticket(id);
+
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (user_id) REFERENCES system_user(id);
+
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (create_by) REFERENCES system_user(id);
+
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (change_by) REFERENCES system_user(id);
+
+ CREATE INDEX ticket_index_gro28 ON ticket_index (group_id);
+
+ ALTER TABLE ticket_index ADD FOREIGN KEY (ticket_id) REFERENCES ticket(id);
+
+ ALTER TABLE ticket_index ADD FOREIGN KEY (queue_id) REFERENCES queue(id);
+
+ ALTER TABLE ticket_index ADD FOREIGN KEY (group_id) REFERENCES groups(id);
+
+ CREATE INDEX postmaster_filte61 ON postmaster_filter (f_name);
+
+ CREATE INDEX generic_agent_jo11 ON generic_agent_jobs (job_name);
+
-- ----------------------------------------------------------
-- alter table mail_account
***************
*** 56,65 ****
-- alter table article
-- ----------------------------------------------------------
! ALTER TABLE article CHANGE a_body a_body CLOB (14062K) NOT NULL;
-- ----------------------------------------------------------
-- alter table xml_storage
-- ----------------------------------------------------------
! ALTER TABLE xml_storage CHANGE xml_content_value xml_content_value CLOB (7812K);
-- ----------------------------------------------------------
--- 138,165 ----
-- alter table article
-- ----------------------------------------------------------
! ALTER TABLE article ALTER COLUMN a_body SET DATA TYPE CLOB (14062K);
!
! CALL SYSPROC.ADMIN_CMD ('REORG TABLE article');
!
! -- ----------------------------------------------------------
! -- alter table article
! -- ----------------------------------------------------------
! ALTER TABLE article ALTER COLUMN a_body SET NOT NULL;
!
! CALL SYSPROC.ADMIN_CMD ('REORG TABLE article');
-- ----------------------------------------------------------
-- alter table xml_storage
-- ----------------------------------------------------------
! ALTER TABLE xml_storage ALTER COLUMN xml_content_value SET DATA TYPE CLOB (7812K);
!
! CALL SYSPROC.ADMIN_CMD ('REORG TABLE xml_storage');
!
! -- ----------------------------------------------------------
! -- alter table xml_storage
! -- ----------------------------------------------------------
! ALTER TABLE xml_storage ALTER COLUMN xml_content_value DROP NOT NULL;
!
! CALL SYSPROC.ADMIN_CMD ('REORG TABLE xml_storage');
-- ----------------------------------------------------------
Author: martin
Index: DBUpdate-to-2.3-schema.maxdb.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.3-schema.maxdb.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** DBUpdate-to-2.3-schema.maxdb.sql 28 Mar 2008 11:28:25 -0000 1.2
--- DBUpdate-to-2.3-schema.maxdb.sql 29 Apr 2008 23:44:41 -0000 1.3
***************
*** 1,4 ****
// ----------------------------------------------------------
! // driver: maxdb, generated: 2008-03-28 12:27:28
// ----------------------------------------------------------
// ----------------------------------------------------------
--- 1,4 ----
// ----------------------------------------------------------
! // driver: maxdb, generated: 2008-04-30 01:39:47
// ----------------------------------------------------------
// ----------------------------------------------------------
***************
*** 12,16 ****
)
//
! CREATE INDEX index_queue_preferen66 ON queue_preferences (queue_id)
//
// ----------------------------------------------------------
--- 12,16 ----
)
//
! CREATE INDEX index_queue_preferen87 ON queue_preferences (queue_id)
//
// ----------------------------------------------------------
Author: martin
Index: DBUpdate-to-2.3-schema.mssql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.3-schema.mssql.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** DBUpdate-to-2.3-schema.mssql.sql 28 Mar 2008 11:28:25 -0000 1.2
--- DBUpdate-to-2.3-schema.mssql.sql 29 Apr 2008 23:44:41 -0000 1.3
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2008-03-28 12:27:28
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2008-04-30 01:39:47
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 11,14 ****
--- 11,23 ----
);
CREATE INDEX index_queue_preferences_user_id ON queue_preferences (queue_id);
+ CREATE INDEX user_preferences_user_id ON user_preferences (user_id);
+ CREATE INDEX group_user_user_id ON group_user (user_id);
+ CREATE INDEX group_user_group_id ON group_user (group_id);
+ CREATE INDEX group_role_role_id ON group_role (role_id);
+ CREATE INDEX group_role_group_id ON group_role (group_id);
+ CREATE INDEX group_customer_user_id ON group_customer_user (user_id);
+ CREATE INDEX group_customer_user_group_id ON group_customer_user (group_id);
+ CREATE INDEX personal_queues_user_id ON personal_queues (user_id);
+ CREATE INDEX personal_queues_queue_id ON personal_queues (queue_id);
-- ----------------------------------------------------------
-- alter table queue
***************
*** 23,26 ****
--- 32,54 ----
-- ----------------------------------------------------------
ALTER TABLE queue ADD solution_notify SMALLINT;
+ CREATE INDEX queue_group_id ON queue (group_id);
+ CREATE INDEX ticket_title ON ticket (title);
+ CREATE INDEX ticket_customer_user_id ON ticket (customer_user_id);
+ CREATE INDEX ticket_customer_id ON ticket (customer_id);
+ CREATE INDEX ticket_queue_id ON ticket (queue_id);
+ CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
+ CREATE INDEX index_object_link_a_id ON object_link (object_link_a_id);
+ CREATE INDEX index_object_link_b_id ON object_link (object_link_b_id);
+ CREATE INDEX index_object_link_a_object ON object_link (object_link_a_object);
+ CREATE INDEX index_object_link_b_object ON object_link (object_link_b_object);
+ CREATE INDEX index_object_link_type ON object_link (object_link_type);
+ CREATE INDEX ticket_history_history_type_id ON ticket_history (history_type_id);
+ CREATE INDEX ticket_history_queue_id ON ticket_history (queue_id);
+ CREATE INDEX ticket_history_type_id ON ticket_history (type_id);
+ CREATE INDEX ticket_history_owner_id ON ticket_history (owner_id);
+ CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id);
+ CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
+ CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id);
+ CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
-- ----------------------------------------------------------
-- alter table sla
***************
*** 35,38 ****
--- 63,79 ----
-- ----------------------------------------------------------
ALTER TABLE sla ADD solution_notify SMALLINT;
+ CREATE INDEX article_article_type_id ON article (article_type_id);
+ CREATE INDEX article_sender_type_id ON article (article_sender_type_id);
+ CREATE INDEX ticket_watcher_user_id ON ticket_watcher (user_id);
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (ticket_id) REFERENCES ticket(id);
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (user_id) REFERENCES system_user(id);
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (create_by) REFERENCES system_user(id);
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (change_by) REFERENCES system_user(id);
+ CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
+ ALTER TABLE ticket_index ADD FOREIGN KEY (ticket_id) REFERENCES ticket(id);
+ ALTER TABLE ticket_index ADD FOREIGN KEY (queue_id) REFERENCES queue(id);
+ ALTER TABLE ticket_index ADD FOREIGN KEY (group_id) REFERENCES groups(id);
+ CREATE INDEX postmaster_filter_f_name ON postmaster_filter (f_name);
+ CREATE INDEX generic_agent_job_name ON generic_agent_jobs (job_name);
-- ----------------------------------------------------------
-- alter table mail_account
Author: martin
Index: DBUpdate-to-2.3-schema.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.3-schema.mysql.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** DBUpdate-to-2.3-schema.mysql.sql 28 Mar 2008 11:28:25 -0000 1.2
--- DBUpdate-to-2.3-schema.mysql.sql 29 Apr 2008 23:44:41 -0000 1.3
***************
*** 1,4 ****
# ----------------------------------------------------------
! # driver: mysql, generated: 2008-03-28 12:27:28
# ----------------------------------------------------------
# ----------------------------------------------------------
--- 1,4 ----
# ----------------------------------------------------------
! # driver: mysql, generated: 2008-04-30 01:39:47
# ----------------------------------------------------------
# ----------------------------------------------------------
***************
*** 11,14 ****
--- 11,23 ----
INDEX index_queue_preferences_user_id (queue_id)
);
+ CREATE INDEX user_preferences_user_id ON user_preferences (user_id);
+ CREATE INDEX group_user_user_id ON group_user (user_id);
+ CREATE INDEX group_user_group_id ON group_user (group_id);
+ CREATE INDEX group_role_role_id ON group_role (role_id);
+ CREATE INDEX group_role_group_id ON group_role (group_id);
+ CREATE INDEX group_customer_user_id ON group_customer_user (user_id);
+ CREATE INDEX group_customer_user_group_id ON group_customer_user (group_id);
+ CREATE INDEX personal_queues_user_id ON personal_queues (user_id);
+ CREATE INDEX personal_queues_queue_id ON personal_queues (queue_id);
# ----------------------------------------------------------
# alter table queue
***************
*** 23,26 ****
--- 32,54 ----
# ----------------------------------------------------------
ALTER TABLE queue ADD solution_notify SMALLINT;
+ CREATE INDEX queue_group_id ON queue (group_id);
+ CREATE INDEX ticket_title ON ticket (title);
+ CREATE INDEX ticket_customer_user_id ON ticket (customer_user_id);
+ CREATE INDEX ticket_customer_id ON ticket (customer_id);
+ CREATE INDEX ticket_queue_id ON ticket (queue_id);
+ CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
+ CREATE INDEX index_object_link_a_id ON object_link (object_link_a_id);
+ CREATE INDEX index_object_link_b_id ON object_link (object_link_b_id);
+ CREATE INDEX index_object_link_a_object ON object_link (object_link_a_object);
+ CREATE INDEX index_object_link_b_object ON object_link (object_link_b_object);
+ CREATE INDEX index_object_link_type ON object_link (object_link_type);
+ CREATE INDEX ticket_history_history_type_id ON ticket_history (history_type_id);
+ CREATE INDEX ticket_history_queue_id ON ticket_history (queue_id);
+ CREATE INDEX ticket_history_type_id ON ticket_history (type_id);
+ CREATE INDEX ticket_history_owner_id ON ticket_history (owner_id);
+ CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id);
+ CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
+ CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id);
+ CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
# ----------------------------------------------------------
# alter table sla
***************
*** 35,38 ****
--- 63,79 ----
# ----------------------------------------------------------
ALTER TABLE sla ADD solution_notify SMALLINT;
+ CREATE INDEX article_article_type_id ON article (article_type_id);
+ CREATE INDEX article_sender_type_id ON article (article_sender_type_id);
+ CREATE INDEX ticket_watcher_user_id ON ticket_watcher (user_id);
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`;
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`;
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
+ CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
+ ALTER TABLE ticket_index ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`;
+ ALTER TABLE ticket_index ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`;
+ ALTER TABLE ticket_index ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`;
+ CREATE INDEX postmaster_filter_f_name ON postmaster_filter (f_name);
+ CREATE INDEX generic_agent_job_name ON generic_agent_jobs (job_name);
# ----------------------------------------------------------
# alter table mail_account
Author: martin
Index: DBUpdate-to-2.3-schema.oracle.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.3-schema.oracle.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** DBUpdate-to-2.3-schema.oracle.sql 28 Mar 2008 11:28:25 -0000 1.2
--- DBUpdate-to-2.3-schema.oracle.sql 29 Apr 2008 23:44:41 -0000 1.3
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: oracle, generated: 2008-03-28 12:27:28
-- ----------------------------------------------------------
SET DEFINE OFF;
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: oracle, generated: 2008-04-30 01:39:48
-- ----------------------------------------------------------
SET DEFINE OFF;
***************
*** 11,15 ****
preferences_value VARCHAR2 (250)
);
! CREATE INDEX index_queue_preferences_user38 ON queue_preferences (queue_id);
-- ----------------------------------------------------------
-- alter table queue
--- 11,24 ----
preferences_value VARCHAR2 (250)
);
! CREATE INDEX index_queue_preferences_user23 ON queue_preferences (queue_id);
! CREATE INDEX user_preferences_user_id ON user_preferences (user_id);
! CREATE INDEX group_user_user_id ON group_user (user_id);
! CREATE INDEX group_user_group_id ON group_user (group_id);
! CREATE INDEX group_role_role_id ON group_role (role_id);
! CREATE INDEX group_role_group_id ON group_role (group_id);
! CREATE INDEX group_customer_user_id ON group_customer_user (user_id);
! CREATE INDEX group_customer_user_group_id ON group_customer_user (group_id);
! CREATE INDEX personal_queues_user_id ON personal_queues (user_id);
! CREATE INDEX personal_queues_queue_id ON personal_queues (queue_id);
-- ----------------------------------------------------------
-- alter table queue
***************
*** 24,27 ****
--- 33,55 ----
-- ----------------------------------------------------------
ALTER TABLE queue ADD solution_notify NUMBER (5, 0);
+ CREATE INDEX queue_group_id ON queue (group_id);
+ CREATE INDEX ticket_title ON ticket (title);
+ CREATE INDEX ticket_customer_user_id ON ticket (customer_user_id);
+ CREATE INDEX ticket_customer_id ON ticket (customer_id);
+ CREATE INDEX ticket_queue_id ON ticket (queue_id);
+ CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
+ CREATE INDEX index_object_link_a_id ON object_link (object_link_a_id);
+ CREATE INDEX index_object_link_b_id ON object_link (object_link_b_id);
+ CREATE INDEX index_object_link_a_object ON object_link (object_link_a_object);
+ CREATE INDEX index_object_link_b_object ON object_link (object_link_b_object);
+ CREATE INDEX index_object_link_type ON object_link (object_link_type);
+ CREATE INDEX ticket_history_history_type_id ON ticket_history (history_type_id);
+ CREATE INDEX ticket_history_queue_id ON ticket_history (queue_id);
+ CREATE INDEX ticket_history_type_id ON ticket_history (type_id);
+ CREATE INDEX ticket_history_owner_id ON ticket_history (owner_id);
+ CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id);
+ CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
+ CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id);
+ CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
-- ----------------------------------------------------------
-- alter table sla
***************
*** 36,39 ****
--- 64,80 ----
-- ----------------------------------------------------------
ALTER TABLE sla ADD solution_notify NUMBER (5, 0);
+ CREATE INDEX article_article_type_id ON article (article_type_id);
+ CREATE INDEX article_sender_type_id ON article (article_sender_type_id);
+ CREATE INDEX ticket_watcher_user_id ON ticket_watcher (user_id);
+ ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket(id);
+ ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_user_id_id FOREIGN KEY (user_id) REFERENCES system_user(id);
+ ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
+ ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
+ CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
+ ALTER TABLE ticket_index ADD CONSTRAINT FK_ticket_index_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket(id);
+ ALTER TABLE ticket_index ADD CONSTRAINT FK_ticket_index_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue(id);
+ ALTER TABLE ticket_index ADD CONSTRAINT FK_ticket_index_group_id_id FOREIGN KEY (group_id) REFERENCES groups(id);
+ CREATE INDEX postmaster_filter_f_name ON postmaster_filter (f_name);
+ CREATE INDEX generic_agent_job_name ON generic_agent_jobs (job_name);
-- ----------------------------------------------------------
-- alter table mail_account
Author: martin
Index: DBUpdate-to-2.3-schema.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.3-schema.postgresql.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** DBUpdate-to-2.3-schema.postgresql.sql 28 Mar 2008 11:28:25 -0000 1.2
--- DBUpdate-to-2.3-schema.postgresql.sql 29 Apr 2008 23:44:41 -0000 1.3
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2008-03-28 12:27:28
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2008-04-30 01:39:48
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 11,14 ****
--- 11,23 ----
);
CREATE INDEX index_queue_preferences_user_id ON queue_preferences (queue_id);
+ CREATE INDEX user_preferences_user_id ON user_preferences (user_id);
+ CREATE INDEX group_user_user_id ON group_user (user_id);
+ CREATE INDEX group_user_group_id ON group_user (group_id);
+ CREATE INDEX group_role_role_id ON group_role (role_id);
+ CREATE INDEX group_role_group_id ON group_role (group_id);
+ CREATE INDEX group_customer_user_id ON group_customer_user (user_id);
+ CREATE INDEX group_customer_user_group_id ON group_customer_user (group_id);
+ CREATE INDEX personal_queues_user_id ON personal_queues (user_id);
+ CREATE INDEX personal_queues_queue_id ON personal_queues (queue_id);
-- ----------------------------------------------------------
-- alter table queue
***************
*** 23,26 ****
--- 32,54 ----
-- ----------------------------------------------------------
ALTER TABLE queue ADD solution_notify INTEGER;
+ CREATE INDEX queue_group_id ON queue (group_id);
+ CREATE INDEX ticket_title ON ticket (title);
+ CREATE INDEX ticket_customer_user_id ON ticket (customer_user_id);
+ CREATE INDEX ticket_customer_id ON ticket (customer_id);
+ CREATE INDEX ticket_queue_id ON ticket (queue_id);
+ CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
+ CREATE INDEX index_object_link_a_id ON object_link (object_link_a_id);
+ CREATE INDEX index_object_link_b_id ON object_link (object_link_b_id);
+ CREATE INDEX index_object_link_a_object ON object_link (object_link_a_object);
+ CREATE INDEX index_object_link_b_object ON object_link (object_link_b_object);
+ CREATE INDEX index_object_link_type ON object_link (object_link_type);
+ CREATE INDEX ticket_history_history_type_id ON ticket_history (history_type_id);
+ CREATE INDEX ticket_history_queue_id ON ticket_history (queue_id);
+ CREATE INDEX ticket_history_type_id ON ticket_history (type_id);
+ CREATE INDEX ticket_history_owner_id ON ticket_history (owner_id);
+ CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id);
+ CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
+ CREATE INDEX ticket_history_priority_id ON ticket_history (priority_id);
+ CREATE INDEX ticket_history_state_id ON ticket_history (state_id);
-- ----------------------------------------------------------
-- alter table sla
***************
*** 35,38 ****
--- 63,79 ----
-- ----------------------------------------------------------
ALTER TABLE sla ADD solution_notify INTEGER;
+ CREATE INDEX article_article_type_id ON article (article_type_id);
+ CREATE INDEX article_sender_type_id ON article (article_sender_type_id);
+ CREATE INDEX ticket_watcher_user_id ON ticket_watcher (user_id);
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (ticket_id) REFERENCES ticket(id);
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (user_id) REFERENCES system_user(id);
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (create_by) REFERENCES system_user(id);
+ ALTER TABLE ticket_watcher ADD FOREIGN KEY (change_by) REFERENCES system_user(id);
+ CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
+ ALTER TABLE ticket_index ADD FOREIGN KEY (ticket_id) REFERENCES ticket(id);
+ ALTER TABLE ticket_index ADD FOREIGN KEY (queue_id) REFERENCES queue(id);
+ ALTER TABLE ticket_index ADD FOREIGN KEY (group_id) REFERENCES groups(id);
+ CREATE INDEX postmaster_filter_f_name ON postmaster_filter (f_name);
+ CREATE INDEX generic_agent_job_name ON generic_agent_jobs (job_name);
-- ----------------------------------------------------------
-- alter table mail_account
More information about the cvs-log
mailing list