[otrs-cvs] CVS: otrs/scripts DBUpdate-to-2.1.mysql.sql,1.5,1.6 DBUpdate-to-2.1.postgresql.sql,1.5,1.6

cvs-log at otrs.org cvs-log at otrs.org
Wed Aug 2 11:07:48 CEST 2006


Update of /home/cvs/otrs/scripts
In directory lancelot:/tmp/cvs-serv24538/scripts

Modified Files:
	DBUpdate-to-2.1.mysql.sql DBUpdate-to-2.1.postgresql.sql 
Log Message:
added new ticket_history_type Subscribe and Unsubscribe for ticket watcher

Index: DBUpdate-to-2.1.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.1.mysql.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** DBUpdate-to-2.1.mysql.sql	25 Jul 2006 17:48:54 -0000	1.5
--- DBUpdate-to-2.1.mysql.sql	2 Aug 2006 08:07:45 -0000	1.6
***************
*** 35,38 ****
--- 35,46 ----
          VALUES
          ('ResponsibleUpdate', 1, 1, current_timestamp, 1, current_timestamp);
+ INSERT INTO ticket_history_type
+         (name, valid_id, create_by, create_time, change_by, change_time)
+         VALUES
+         ('Subscribe', 1, 1, current_timestamp, 1, current_timestamp);
+ INSERT INTO ticket_history_type
+         (name, valid_id, create_by, create_time, change_by, change_time)
+         VALUES
+         ('Unsubscribe', 1, 1, current_timestamp, 1, current_timestamp);
  
  CREATE TABLE ticket_watcher (

Index: DBUpdate-to-2.1.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.1.postgresql.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** DBUpdate-to-2.1.postgresql.sql	25 Jul 2006 17:48:54 -0000	1.5
--- DBUpdate-to-2.1.postgresql.sql	2 Aug 2006 08:07:45 -0000	1.6
***************
*** 35,38 ****
--- 35,46 ----
          VALUES
          ('ResponsibleUpdate', 1, 1, current_timestamp, 1, current_timestamp);
+ INSERT INTO ticket_history_type
+         (name, valid_id, create_by, create_time, change_by, change_time)
+         VALUES
+         ('Subscribe', 1, 1, current_timestamp, 1, current_timestamp);
+ INSERT INTO ticket_history_type
+         (name, valid_id, create_by, create_time, change_by, change_time)
+         VALUES
+         ('Unsubscribe', 1, 1, current_timestamp, 1, current_timestamp);
  
  CREATE TABLE ticket_watcher (



More information about the cvs-log mailing list