[otrs-cvs] otrs/scripts DBUpdate-to-2.3-schema.db2.sql, 1.3, 1.4 DBUpdate-to-2.3-schema.maxdb.sql, 1.3, 1.4 DBUpdate-to-2.3-schema.mssql.sql, 1.3, 1.4 DBUpdate-to-2.3-schema.mysql.sql, 1.3, 1.4 DBUpdate-to-2.3-schema.oracle.sql, 1.3, 1.4 DBUpdate-to-2.3-schema.postgresql.sql, 1.3, 1.4

Tue May 6 22:27:33 GMT 2008

Comments:
Update of /home/cvs/otrs/scripts
In directory lancelot:/tmp/cvs-serv16751/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.

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.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** DBUpdate-to-2.3-schema.db2.sql	29 Apr 2008 23:44:41 -0000	1.3
--- DBUpdate-to-2.3-schema.db2.sql	6 May 2008 22:27:28 -0000	1.4
***************
*** 1,4 ****
  -- ----------------------------------------------------------
! --  driver: db2, generated: 2008-04-30 01:39:46
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
--- 1,4 ----
  -- ----------------------------------------------------------
! --  driver: db2, generated: 2008-05-07 00:26:11
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
***************
*** 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);

  -- ----------------------------------------------------------
--- 11,37 ----
  );

! CREATE INDEX queue_preferen5e ON queue_preferences (queue_id);

! CREATE INDEX user_preferenc36 ON user_preferences (user_id);

! CREATE INDEX group_user_usea2 ON group_user (user_id);

! CREATE INDEX group_user_gro92 ON group_user (group_id);

! CREATE INDEX group_role_rolab ON group_role (role_id);

! CREATE INDEX group_role_gro4d ON group_role (group_id);

! CREATE INDEX group_customerf1 ON group_customer_user (user_id);

! CREATE INDEX group_customer1d ON group_customer_user (group_id);

! CREATE INDEX role_user_user42 ON role_user (user_id);

! CREATE INDEX role_user_role4d ON role_user (role_id);
! 
! CREATE INDEX personal_queue5c ON personal_queues (user_id);
! 
! CREATE INDEX personal_queue40 ON personal_queues (queue_id);

  -- ----------------------------------------------------------
***************
*** 50,86 ****
  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);

  -- ----------------------------------------------------------
--- 54,94 ----
  CREATE INDEX ticket_title ON ticket (title);

! CREATE INDEX ticket_custome8e ON ticket (customer_user_id);

! CREATE INDEX ticket_custome8e ON ticket (customer_id);

  CREATE INDEX ticket_queue_id ON ticket (queue_id);

! CREATE INDEX ticket_ticket_20 ON ticket (lock_id);

! CREATE INDEX ticket_responsbe ON ticket (responsible_user_id);

! CREATE INDEX ticket_ticket_67 ON ticket (ticket_state_id);

! CREATE INDEX ticket_ticket_36 ON ticket (ticket_priority_id);

! CREATE INDEX index_object_ldb ON object_link (object_link_a_id);

! CREATE INDEX index_object_l24 ON object_link (object_link_b_id);

! CREATE INDEX index_object_l52 ON object_link (object_link_a_object);

! CREATE INDEX index_object_lfd ON object_link (object_link_b_object);

! CREATE INDEX index_object_l2b ON object_link (object_link_type);

! CREATE INDEX ticket_history36 ON ticket_history (history_type_id);

! CREATE INDEX ticket_history32 ON ticket_history (queue_id);

! CREATE INDEX ticket_history01 ON ticket_history (type_id);

! CREATE INDEX ticket_historyf6 ON ticket_history (owner_id);

! CREATE INDEX ticket_history68 ON ticket_history (priority_id);
! 
! CREATE INDEX ticket_history68 ON ticket_history (state_id);
! 
! CREATE INDEX ticket_history68 ON ticket_history (priority_id);

  -- ----------------------------------------------------------
***************
*** 99,107 ****
  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);
--- 107,115 ----
  ALTER TABLE sla ADD solution_notify SMALLINT;

! CREATE INDEX article_articlf7 ON article (article_type_id);

! CREATE INDEX article_senderad ON article (article_sender_type_id);

! CREATE INDEX ticket_watcher3d ON ticket_watcher (user_id);

  ALTER TABLE ticket_watcher ADD FOREIGN KEY (ticket_id) REFERENCES ticket(id);
***************
*** 113,117 ****
  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);
--- 121,127 ----
  ALTER TABLE ticket_watcher ADD FOREIGN KEY (change_by) REFERENCES system_user(id);

! CREATE INDEX ticket_index_q1c ON ticket_index (queue_id);
! 
! CREATE INDEX ticket_index_g22 ON ticket_index (group_id);

  ALTER TABLE ticket_index ADD FOREIGN KEY (ticket_id) REFERENCES ticket(id);
***************
*** 121,127 ****
  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);

  -- ----------------------------------------------------------
--- 131,137 ----
  ALTER TABLE ticket_index ADD FOREIGN KEY (group_id) REFERENCES groups(id);

! CREATE INDEX postmaster_fil20 ON postmaster_filter (f_name);

! CREATE INDEX generic_agent_6c ON generic_agent_jobs (job_name);

  -- ----------------------------------------------------------

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.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** DBUpdate-to-2.3-schema.maxdb.sql	29 Apr 2008 23:44:41 -0000	1.3
--- DBUpdate-to-2.3-schema.maxdb.sql	6 May 2008 22:27:28 -0000	1.4
***************
*** 1,4 ****
  // ----------------------------------------------------------
! //  driver: maxdb, generated: 2008-04-30 01:39:47
  // ----------------------------------------------------------
  // ----------------------------------------------------------
--- 1,4 ----
  // ----------------------------------------------------------
! //  driver: maxdb, generated: 2008-05-07 00:26:11
  // ----------------------------------------------------------
  // ----------------------------------------------------------
***************
*** 12,16 ****
  )
  //
! CREATE INDEX index_queue_preferen87 ON queue_preferences (queue_id)
  //
  // ----------------------------------------------------------
--- 12,16 ----
  )
  //
! CREATE INDEX queue_preferences_qu0 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.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** DBUpdate-to-2.3-schema.mssql.sql	29 Apr 2008 23:44:41 -0000	1.3
--- DBUpdate-to-2.3-schema.mssql.sql	6 May 2008 22:27:28 -0000	1.4
***************
*** 1,4 ****
  -- ----------------------------------------------------------
! --  driver: mssql, generated: 2008-04-30 01:39:47
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
--- 1,4 ----
  -- ----------------------------------------------------------
! --  driver: mssql, generated: 2008-05-07 00:26:11
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
***************
*** 10,14 ****
      preferences_value VARCHAR (250)
  );
! 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);
--- 10,14 ----
      preferences_value VARCHAR (250)
  );
! CREATE INDEX queue_preferences_queue_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);
***************
*** 18,21 ****
--- 18,23 ----
  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 role_user_user_id ON role_user (user_id);
+ CREATE INDEX role_user_role_id ON role_user (role_id);
  CREATE INDEX personal_queues_user_id ON personal_queues (user_id);
  CREATE INDEX personal_queues_queue_id ON personal_queues (queue_id);
***************
*** 37,41 ****
--- 39,46 ----
  CREATE INDEX ticket_customer_id ON ticket (customer_id);
  CREATE INDEX ticket_queue_id ON ticket (queue_id);
+ CREATE INDEX ticket_ticket_lock_id ON ticket (lock_id);
  CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
+ CREATE INDEX ticket_ticket_state_id ON ticket (ticket_state_id);
+ CREATE INDEX ticket_ticket_priority_id ON ticket (ticket_priority_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);
***************
*** 50,54 ****
  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
--- 55,58 ----
***************
*** 70,73 ****
--- 74,78 ----
  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_queue_id ON ticket_index (queue_id);
  CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
  ALTER TABLE ticket_index ADD FOREIGN KEY (ticket_id) REFERENCES ticket(id);

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.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** DBUpdate-to-2.3-schema.mysql.sql	29 Apr 2008 23:44:41 -0000	1.3
--- DBUpdate-to-2.3-schema.mysql.sql	6 May 2008 22:27:28 -0000	1.4
***************
*** 1,4 ****
  # ----------------------------------------------------------
! #  driver: mysql, generated: 2008-04-30 01:39:47
  # ----------------------------------------------------------
  # ----------------------------------------------------------
--- 1,4 ----
  # ----------------------------------------------------------
! #  driver: mysql, generated: 2008-05-07 00:26:11
  # ----------------------------------------------------------
  # ----------------------------------------------------------
***************
*** 9,13 ****
      preferences_key VARCHAR (150) NOT NULL,
      preferences_value VARCHAR (250),
!     INDEX index_queue_preferences_user_id (queue_id)
  );
  CREATE INDEX user_preferences_user_id ON user_preferences (user_id);
--- 9,13 ----
      preferences_key VARCHAR (150) NOT NULL,
      preferences_value VARCHAR (250),
!     INDEX queue_preferences_queue_id (queue_id)
  );
  CREATE INDEX user_preferences_user_id ON user_preferences (user_id);
***************
*** 18,21 ****
--- 18,23 ----
  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 role_user_user_id ON role_user (user_id);
+ CREATE INDEX role_user_role_id ON role_user (role_id);
  CREATE INDEX personal_queues_user_id ON personal_queues (user_id);
  CREATE INDEX personal_queues_queue_id ON personal_queues (queue_id);
***************
*** 37,41 ****
--- 39,46 ----
  CREATE INDEX ticket_customer_id ON ticket (customer_id);
  CREATE INDEX ticket_queue_id ON ticket (queue_id);
+ CREATE INDEX ticket_ticket_lock_id ON ticket (lock_id);
  CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
+ CREATE INDEX ticket_ticket_state_id ON ticket (ticket_state_id);
+ CREATE INDEX ticket_ticket_priority_id ON ticket (ticket_priority_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);
***************
*** 50,54 ****
  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
--- 55,58 ----
***************
*** 70,73 ****
--- 74,78 ----
  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_queue_id ON ticket_index (queue_id);
  CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
  ALTER TABLE ticket_index ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`;

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.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** DBUpdate-to-2.3-schema.oracle.sql	29 Apr 2008 23:44:41 -0000	1.3
--- DBUpdate-to-2.3-schema.oracle.sql	6 May 2008 22:27:28 -0000	1.4
***************
*** 1,4 ****
  -- ----------------------------------------------------------
! --  driver: oracle, generated: 2008-04-30 01:39:48
  -- ----------------------------------------------------------
  SET DEFINE OFF;
--- 1,4 ----
  -- ----------------------------------------------------------
! --  driver: oracle, generated: 2008-05-07 00:26:11
  -- ----------------------------------------------------------
  SET DEFINE OFF;
***************
*** 11,15 ****
      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);
--- 11,15 ----
      preferences_value VARCHAR2 (250)
  );
! CREATE INDEX queue_preferences_queue_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);
***************
*** 19,22 ****
--- 19,24 ----
  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 role_user_user_id ON role_user (user_id);
+ CREATE INDEX role_user_role_id ON role_user (role_id);
  CREATE INDEX personal_queues_user_id ON personal_queues (user_id);
  CREATE INDEX personal_queues_queue_id ON personal_queues (queue_id);
***************
*** 38,42 ****
--- 40,47 ----
  CREATE INDEX ticket_customer_id ON ticket (customer_id);
  CREATE INDEX ticket_queue_id ON ticket (queue_id);
+ CREATE INDEX ticket_ticket_lock_id ON ticket (lock_id);
  CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
+ CREATE INDEX ticket_ticket_state_id ON ticket (ticket_state_id);
+ CREATE INDEX ticket_ticket_priority_id ON ticket (ticket_priority_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);
***************
*** 51,55 ****
  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
--- 56,59 ----
***************
*** 71,74 ****
--- 75,79 ----
  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_queue_id ON ticket_index (queue_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);

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.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** DBUpdate-to-2.3-schema.postgresql.sql	29 Apr 2008 23:44:41 -0000	1.3
--- DBUpdate-to-2.3-schema.postgresql.sql	6 May 2008 22:27:28 -0000	1.4
***************
*** 1,4 ****
  -- ----------------------------------------------------------
! --  driver: postgresql, generated: 2008-04-30 01:39:48
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
--- 1,4 ----
  -- ----------------------------------------------------------
! --  driver: postgresql, generated: 2008-05-07 00:26:11
  -- ----------------------------------------------------------
  -- ----------------------------------------------------------
***************
*** 10,14 ****
      preferences_value VARCHAR (250)
  );
! 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);
--- 10,14 ----
      preferences_value VARCHAR (250)
  );
! CREATE INDEX queue_preferences_queue_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);
***************
*** 18,21 ****
--- 18,23 ----
  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 role_user_user_id ON role_user (user_id);
+ CREATE INDEX role_user_role_id ON role_user (role_id);
  CREATE INDEX personal_queues_user_id ON personal_queues (user_id);
  CREATE INDEX personal_queues_queue_id ON personal_queues (queue_id);
***************
*** 37,41 ****
--- 39,46 ----
  CREATE INDEX ticket_customer_id ON ticket (customer_id);
  CREATE INDEX ticket_queue_id ON ticket (queue_id);
+ CREATE INDEX ticket_ticket_lock_id ON ticket (lock_id);
  CREATE INDEX ticket_responsible_user_id ON ticket (responsible_user_id);
+ CREATE INDEX ticket_ticket_state_id ON ticket (ticket_state_id);
+ CREATE INDEX ticket_ticket_priority_id ON ticket (ticket_priority_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);
***************
*** 50,54 ****
  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
--- 55,58 ----
***************
*** 70,73 ****
--- 74,78 ----
  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_queue_id ON ticket_index (queue_id);
  CREATE INDEX ticket_index_group_id ON ticket_index (group_id);
  ALTER TABLE ticket_index ADD FOREIGN KEY (ticket_id) REFERENCES ticket(id);