[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