Re: inital_insert.sql and Oracle
Florent Guiliani <fguiliani <at> perinfo.com>
2005-12-07 13:53:57 GMT
Florent Guiliani a écrit :
>
> current_timestamp doesn't exist, Oracle use instead sysdate.
after replaced all current_timestamp with sysdate, others statments are
invalids because some right-quote are missing.
Here is the patch in attachment.
Florent,
--- initial_insert.sql.orig Wed Dec 7 14:52:34 2005
+++ initial_insert.sql Wed Dec 7 14:52:45 2005
<at> <at> -240,456 +240,480 <at> <at>
INSERT INTO valid
(name, create_by, create_time, change_by, change_time)
VALUES
- ('valid', 1, current_timestamp, 1, current_timestamp);
+ ('valid', 1, sysdate, 1, sysdate);
INSERT INTO valid
(name, create_by, create_time, change_by, change_time)
VALUES
- ('invalid', 1, current_timestamp, 1, current_timestamp);
+ ('invalid', 1, sysdate, 1, sysdate);
INSERT INTO valid
(name, create_by, create_time, change_by, change_time)
VALUES
- ('invalid-temporarily', 1, current_timestamp, 1, current_timestamp);
+ ('invalid-temporarily', 1, sysdate, 1, sysdate);
-- ticket_priority
INSERT INTO ticket_priority
(name, create_by, create_time, change_by, change_time)
VALUES
- ('1 very low', 1, current_timestamp, 1, current_timestamp);
+ ('1 very low', 1, sysdate, 1, sysdate);
INSERT INTO ticket_priority
(name, create_by, create_time, change_by, change_time)
VALUES
- ('2 low', 1, current_timestamp, 1, current_timestamp);
+ ('2 low', 1, sysdate, 1, sysdate);
INSERT INTO ticket_priority
(name, create_by, create_time, change_by, change_time)
VALUES
- ('3 normal', 1, current_timestamp, 1, current_timestamp);
+ ('3 normal', 1, sysdate, 1, sysdate);
INSERT INTO ticket_priority
(name, create_by, create_time, change_by, change_time)
VALUES
- ('4 high', 1, current_timestamp, 1, current_timestamp);
+ ('4 high', 1, sysdate, 1, sysdate);
INSERT INTO ticket_priority
(name, create_by, create_time, change_by, change_time)
VALUES
- ('5 very high', 1, current_timestamp, 1, current_timestamp);
+ ('5 very high', 1, sysdate, 1, sysdate);
-- ticket_lock_type
INSERT INTO ticket_lock_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('unlock', 1, 1, current_timestamp, 1, current_timestamp);
+ ('unlock', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_lock_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('lock', 1, 1, current_timestamp, 1, current_timestamp);
+ ('lock', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_lock_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('tmp_lock', 1, 1, current_timestamp, 1, current_timestamp);
+ ('tmp_lock', 1, 1, sysdate, 1, sysdate);
-- user
INSERT INTO system_user
(first_name, last_name, login, pw, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Admin', 'OTRS', 'root <at> localhost', 'roK20XGbWEsSM', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Admin', 'OTRS', 'root <at> localhost', 'roK20XGbWEsSM', 1, 1, sysdate, 1, sysdate);
-- groups
INSERT INTO groups
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('users', 1, 1, current_timestamp, 1, current_timestamp);
+ ('users', 1, 1, sysdate, 1, sysdate);
INSERT INTO groups
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('admin', 1, 1, current_timestamp, 1, current_timestamp);
+ ('admin', 1, 1, sysdate, 1, sysdate);
INSERT INTO groups
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('stats', 1, 1, current_timestamp, 1, current_timestamp);
+ ('stats', 1, 1, sysdate, 1, sysdate);
INSERT INTO groups
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('faq', 1, 1, current_timestamp, 1, current_timestamp);
+ ('faq', 1, 1, sysdate, 1, sysdate);
-- group_user (add admin to groups)
INSERT INTO group_user
(user_id, group_id, permission_key, permission_value, create_by, create_time, change_by, change_time)
VALUES
- (1, 1, 'rw', 1, 1, current_timestamp, 1, current_timestamp);
+ (1, 1, 'rw', 1, 1, sysdate, 1, sysdate);
INSERT INTO group_user
(user_id, group_id, permission_key, permission_value, create_by, create_time, change_by, change_time)
VALUES
- (1, 2, 'rw', 1, 1, current_timestamp, 1, current_timestamp);
+ (1, 2, 'rw', 1, 1, sysdate, 1, sysdate);
INSERT INTO group_user
(user_id, group_id, permission_key, permission_value, create_by, create_time, change_by, change_time)
VALUES
- (1, 3, 'rw', 1, 1, current_timestamp, 1, current_timestamp);
+ (1, 3, 'rw', 1, 1, sysdate, 1, sysdate);
-- theme
INSERT INTO theme
(theme, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Standard', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Standard', 1, 1, sysdate, 1, sysdate);
INSERT INTO theme
(theme, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Lite', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Lite', 1, 1, sysdate, 1, sysdate);
-- ticket_state
INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time)
- VALUES ('new', 'ticket is new', 1, 1, 1, current_timestamp, 1, current_timestamp);
+ VALUES ('new', 'ticket is new', 1, 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time)
- VALUES ('closed successful', 'ticket is closed successful', 3, 1, 1, current_timestamp, 1, current_timestamp);
+ VALUES ('closed successful', 'ticket is closed successful', 3, 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time)
- VALUES ('closed unsuccessful', 'ticket is closed unsuccessful', 3, 1, 1, current_timestamp, 1, current_timestamp);
+ VALUES ('closed unsuccessful', 'ticket is closed unsuccessful', 3, 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time)
- VALUES ('open', 'ticket is open', 2, 1, 1, current_timestamp, 1, current_timestamp);
+ VALUES ('open', 'ticket is open', 2, 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time)
- VALUES ('removed', 'customer removed ticket (can reactivate)', 6, 1, 1, current_timestamp, 1, current_timestamp);
+ VALUES ('removed', 'customer removed ticket (can reactivate)', 6, 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time)
- VALUES ('pending reminder', 'ticket is pending for agent reminder', 4, 1, 1, current_timestamp, 1, current_timestamp);
+ VALUES ('pending reminder', 'ticket is pending for agent reminder', 4, 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time)
- VALUES ('pending auto close+', 'ticket is pending for automatic close', 5, 1, 1, current_timestamp, 1, current_timestamp);
+ VALUES ('pending auto close+', 'ticket is pending for automatic close', 5, 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time)
- VALUES ('pending auto close-', 'ticket is pending for automatic close', 5, 1, 1, current_timestamp, 1, current_timestamp);
+ VALUES ('pending auto close-', 'ticket is pending for automatic close', 5, 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time)
- VALUES ('merged', 'state for merged tickets', 7, 1, 1, current_timestamp, 1, current_timestamp);
+ VALUES ('merged', 'state for merged tickets', 7, 1, 1, sysdate, 1, sysdate);
-- ticket_state_type
INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time)
VALUES
- ('new', 'all new state types (default: viewable)', 1, current_timestamp, 1, current_timestamp);
+ ('new', 'all new state types (default: viewable)', 1, sysdate, 1, sysdate);
INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time)
VALUES
- ('open', 'all open state types (default: viewable)', 1, current_timestamp, 1, current_timestamp);
+ ('open', 'all open state types (default: viewable)', 1, sysdate, 1, sysdate);
INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time)
VALUES
- ('closed', 'all closed state types (default: not viewable)', 1, current_timestamp, 1, current_timestamp);
+ ('closed', 'all closed state types (default: not viewable)', 1, sysdate, 1, sysdate);
INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time)
VALUES
- ('pending reminder', 'all "pending reminder" state types (default: viewable)', 1, current_timestamp, 1, current_timestamp);
+ ('pending reminder', 'all "pending reminder" state types (default: viewable)', 1, sysdate, 1, sysdate);
INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time)
VALUES
- ('pending auto', 'all "pending auto *" state types (default: viewable)', 1, current_timestamp, 1, current_timestamp);
+ ('pending auto', 'all "pending auto *" state types (default: viewable)', 1, sysdate, 1, sysdate);
INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time)
VALUES
- ('removed', 'all "removed" state types (default: not viewable)', 1, current_timestamp, 1, current_timestamp);
+ ('removed', 'all "removed" state types (default: not viewable)', 1, sysdate, 1, sysdate);
INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time)
VALUES
- ('merged', 'state type for merged tickets (default: not viewable)', 1, current_timestamp, 1, current_timestamp);
+ ('merged', 'state type for merged tickets (default: not viewable)', 1, sysdate, 1, sysdate);
-- salutation
INSERT INTO salutation
(name, text, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('system standard salutation (en)', 'Dear <OTRS_CUSTOMER_REALNAME>,
Thank you for your request.
', 'std. salutation', 1, 1, current_timestamp, 1, current_timestamp);
+ ('system standard salutation (en)', 'Dear <OTRS_CUSTOMER_REALNAME>,
+Thank you for your request.
+', 'std. salutation', 1, 1, sysdate, 1, sysdate);
-- signature
INSERT INTO signature
(name, text, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('system standard signature (en)', '
Your Ticket-Team
-
<OTRS_FIRST_NAME> <OTRS_LAST_NAME>
--
Super Support - Waterford Business Park
5201 Blue Lagoon Drive - 8th Floor & 9th Floor - Miami, 33126 USA
Email: hot <at> example.com - Web: http://www.example.com/
--', 'std signature', 1, 1, current_timestamp, 1, current_timestamp);
+ ('system standard signature (en)', '
+our Ticket-Team
+ -
+<OTRS_FIRST_NAME> <OTRS_LAST_NAME>
+--
+Super Support - Waterford Business Park
+5201 Blue Lagoon Drive - 8th Floor & 9th Floor - Miami, 33126 USA
+Email: hot <at> example.com - Web: http://www.example.com/
+-', 'std signature', 1, 1, sysdate, 1, sysdate);
-- system_address
INSERT INTO system_address
(value0, value1, comments, valid_id, queue_id, create_by, create_time, change_by, change_time)
VALUES
- ('otrs <at> localhost', 'OTRS System', 'Std. Address', 1, 1, 1, current_timestamp, 1, current_timestamp);
+ ('otrs <at> localhost', 'OTRS System', 'Std. Address', 1, 1, 1, sysdate, 1, sysdate);
-- follow_up_possible
INSERT INTO follow_up_possible
(name, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('possible', 'Follow ups after closed(+|-) possible. Ticket will be reopen.', 1, 1, current_timestamp, 1, current_timestamp);
+ ('possible', 'Follow ups after closed(+|-) possible. Ticket will be reopen.', 1, 1, sysdate, 1, sysdate);
INSERT INTO follow_up_possible
(name, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('reject', 'Follow ups after closed(+|-) not possible. No new ticket will be created.', 1, 1, current_timestamp, 1, current_timestamp);
+ ('reject', 'Follow ups after closed(+|-) not possible. No new ticket will be created.', 1, 1, sysdate, 1, sysdate);
INSERT INTO follow_up_possible
(name, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('new ticket', 'Follow ups after closed(+|-) not possible. A new ticket will be created.', 1, 1, current_timestamp, 1, current_timestamp);
+ ('new ticket', 'Follow ups after closed(+|-) not possible. A new ticket will be created.', 1, 1, sysdate, 1, sysdate);
-- queue
INSERT INTO queue
(name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, escalation_time, unlock_timeout, move_notify, lock_notify, state_notify, owner_notify, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Postmaster', 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 'master queue', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Postmaster', 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 'master queue', 1, 1, sysdate, 1, sysdate);
INSERT INTO queue
(name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, escalation_time, unlock_timeout, move_notify, lock_notify, state_notify, owner_notify, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Raw', 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 'all incoming tickets', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Raw', 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 'all incoming tickets', 1, 1, sysdate, 1, sysdate);
INSERT INTO queue
(name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, escalation_time, unlock_timeout, move_notify, lock_notify, state_notify, owner_notify, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Junk', 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 'all junk tickets', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Junk', 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 'all junk tickets', 1, 1, sysdate, 1, sysdate);
INSERT INTO queue
(name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, escalation_time, unlock_timeout, move_notify, lock_notify, state_notify, owner_notify, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Misc', 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 'all misk tickets', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Misc', 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 'all misk tickets', 1, 1, sysdate, 1, sysdate);
-- ticket_history_type
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('NewTicket', 1, 1, current_timestamp, 1, current_timestamp);
+ ('NewTicket', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('FollowUp', 1, 1, current_timestamp, 1, current_timestamp);
+ ('FollowUp', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('SendAutoReject', 1, 1, current_timestamp, 1, current_timestamp);
+ ('SendAutoReject', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('SendAutoReply', 1, 1, current_timestamp, 1, current_timestamp);
+ ('SendAutoReply', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('SendAutoFollowUp', 1, 1, current_timestamp, 1, current_timestamp);
+ ('SendAutoFollowUp', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Forward', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Forward', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Bounce', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Bounce', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('SendAnswer', 1, 1, current_timestamp, 1, current_timestamp);
+ ('SendAnswer', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('SendAgentNotification', 1, 1, current_timestamp, 1, current_timestamp);
+ ('SendAgentNotification', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('SendCustomerNotification', 1, 1, current_timestamp, 1, current_timestamp);
+ ('SendCustomerNotification', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('EmailAgent', 1, 1, current_timestamp, 1, current_timestamp);
+ ('EmailAgent', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('EmailCustomer', 1, 1, current_timestamp, 1, current_timestamp);
+ ('EmailCustomer', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('PhoneCallAgent', 1, 1, current_timestamp, 1, current_timestamp);
+ ('PhoneCallAgent', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('PhoneCallCustomer', 1, 1, current_timestamp, 1, current_timestamp);
+ ('PhoneCallCustomer', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('AddNote', 1, 1, current_timestamp, 1, current_timestamp);
+ ('AddNote', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Move', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Move', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Lock', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Lock', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Unlock', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Unlock', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Remove', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Remove', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('TimeAccounting', 1, 1, current_timestamp, 1, current_timestamp);
+ ('TimeAccounting', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('CustomerUpdate', 1, 1, current_timestamp, 1, current_timestamp);
+ ('CustomerUpdate', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('PriorityUpdate', 1, 1, current_timestamp, 1, current_timestamp);
+ ('PriorityUpdate', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('OwnerUpdate', 1, 1, current_timestamp, 1, current_timestamp);
+ ('OwnerUpdate', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('LoopProtection', 1, 1, current_timestamp, 1, current_timestamp);
+ ('LoopProtection', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Misc', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Misc', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('SetPendingTime', 1, 1, current_timestamp, 1, current_timestamp);
+ ('SetPendingTime', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('StateUpdate', 1, 1, current_timestamp, 1, current_timestamp);
+ ('StateUpdate', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('TicketFreeTextUpdate', 1, 1, current_timestamp, 1, current_timestamp);
+ ('TicketFreeTextUpdate', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('WebRequestCustomer', 1, 1, current_timestamp, 1, current_timestamp);
+ ('WebRequestCustomer', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('TicketLinkAdd', 1, 1, current_timestamp, 1, current_timestamp);
+ ('TicketLinkAdd', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('TicketLinkDelete', 1, 1, current_timestamp, 1, current_timestamp);
+ ('TicketLinkDelete', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('SystemRequest', 1, 1, current_timestamp, 1, current_timestamp);
+ ('SystemRequest', 1, 1, sysdate, 1, sysdate);
INSERT INTO ticket_history_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('Merged', 1, 1, current_timestamp, 1, current_timestamp);
+ ('Merged', 1, 1, sysdate, 1, sysdate);
-- article_type
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('email-external', 1, 1, current_timestamp, 1, current_timestamp);
+ ('email-external', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('email-internal', 1, 1, current_timestamp, 1, current_timestamp);
+ ('email-internal', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('email-notification-ext', 1, 1, current_timestamp, 1, current_timestamp);
+ ('email-notification-ext', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('email-notification-int', 1, 1, current_timestamp, 1, current_timestamp);
+ ('email-notification-int', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('phone', 1, 1, current_timestamp, 1, current_timestamp);
+ ('phone', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('fax', 1, 1, current_timestamp, 1, current_timestamp);
+ ('fax', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('sms', 1, 1, current_timestamp, 1, current_timestamp);
+ ('sms', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('webrequest', 1, 1, current_timestamp, 1, current_timestamp);
+ ('webrequest', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('note-internal', 1, 1, current_timestamp, 1, current_timestamp);
+ ('note-internal', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('note-external', 1, 1, current_timestamp, 1, current_timestamp);
+ ('note-external', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('note-report', 1, 1, current_timestamp, 1, current_timestamp);
+ ('note-report', 1, 1, sysdate, 1, sysdate);
-- article_article_sender_type
INSERT INTO article_sender_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('agent', 1, 1, current_timestamp, 1, current_timestamp);
+ ('agent', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_sender_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('system', 1, 1, current_timestamp, 1, current_timestamp);
+ ('system', 1, 1, sysdate, 1, sysdate);
INSERT INTO article_sender_type
(name, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('customer', 1, 1, current_timestamp, 1, current_timestamp);
+ ('customer', 1, 1, sysdate, 1, sysdate);
-- standard_response
INSERT INTO standard_response
(name, text, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('empty answer', '', 1, 1, current_timestamp, 1, current_timestamp);
+ ('empty answer', '', 1, 1, sysdate, 1, sysdate);
INSERT INTO standard_response
(name, text, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('test answer', 'test answer ...', 1, 1, current_timestamp, 1, current_timestamp);
+ ('test answer', 'test answer ...', 1, 1, sysdate, 1, sysdate);
-- queue_standard_response
INSERT INTO queue_standard_response
(queue_id, standard_response_id, create_by, create_time, change_by, change_time)
VALUES
- (1, 1, 1, current_timestamp, 1, current_timestamp);
+ (1, 1, 1, sysdate, 1, sysdate);
INSERT INTO queue_standard_response
(queue_id, standard_response_id, create_by, create_time, change_by, change_time)
VALUES
- (2, 1, 1, current_timestamp, 1, current_timestamp);
+ (2, 1, 1, sysdate, 1, sysdate);
INSERT INTO queue_standard_response
(queue_id, standard_response_id, create_by, create_time, change_by, change_time)
VALUES
- (3, 1, 1, current_timestamp, 1, current_timestamp);
+ (3, 1, 1, sysdate, 1, sysdate);
INSERT INTO queue_standard_response
(queue_id, standard_response_id, create_by, create_time, change_by, change_time)
VALUES
- (4, 1, 1, current_timestamp, 1, current_timestamp);
+ (4, 1, 1, sysdate, 1, sysdate);
-- auto_response_type
INSERT INTO auto_response_type
(name, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('auto reply', 'auto replay after a new ticket.', 1, 1, current_timestamp, 1, current_timestamp);
+ ('auto reply', 'auto replay after a new ticket.', 1, 1, sysdate, 1, sysdate);
INSERT INTO auto_response_type
(name, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('auto reject', 'auto reject.', 1, 1, current_timestamp, 1, current_timestamp);
+ ('auto reject', 'auto reject.', 1, 1, sysdate, 1, sysdate);
INSERT INTO auto_response_type
(name, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('auto follow up', 'auto follow up after a follow up.', 1, 1, current_timestamp, 1, current_timestamp);
+ ('auto follow up', 'auto follow up after a follow up.', 1, 1, sysdate, 1, sysdate);
INSERT INTO auto_response_type
(name, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('auto reply/new ticket', 'auto reply after a follow up. Because the ticket is closed.', 1, 1, current_timestamp, 1, current_timestamp);
+ ('auto reply/new ticket', 'auto reply after a follow up. Because the ticket is closed.', 1, 1, sysdate, 1, sysdate);
INSERT INTO auto_response_type
(name, comments, valid_id, create_by, create_time, change_by, change_time)
VALUES
- ('auto remove', 'auto remove after a remove e-mail.', 1, 1, current_timestamp, 1, current_timestamp);
+ ('auto remove', 'auto remove after a remove e-mail.', 1, 1, sysdate, 1, sysdate);
-- auto_response
INSERT INTO auto_response
(type_id, system_address_id, name, text0, text1, charset, comments, valid_id, create_time, create_by, change_time, change_by)
VALUES
- (1, 1, 'default reply', 'This is a demo text which is send to every inquery.
It could contain something like:
Thanks for your e-mail. A new ticket has been created.
You wrote:
<OTRS_CUSTOMER_EMAIL[6]>
Your e-mail will be answered by a human asap
Have fun with OTRS! :-)
Your OTRS Team
', 'RE: <OTRS_CUSTOMER_SUBJECT[20]>', 'iso-8859-1', 'default', 1, current_timestamp, 1, current_timestamp, 1);
+ (1, 1, 'default reply', 'This is a demo text which is send to every inquery.
+t could contain something like:
+Thanks for your e-mail. A new ticket has been created.
+You wrote:
+OTRS_CUSTOMER_EMAIL[6]>
+Your e-mail will be answered by a human asap
+Have fun with OTRS! :-)
+ Your OTRS Team
+', 'RE: <OTRS_CUSTOMER_SUBJECT[20]>', 'iso-8859-1', 'default', 1, sysdate, 1, sysdate, 1);
INSERT INTO auto_response
(type_id, system_address_id, name, text0, text1, charset, comments, valid_id, create_time, create_by, change_time, change_by)
VALUES
- (2, 1, 'default reject', 'Reject.', 'thank you for your e-mail. But you forgot importand infos. Pleace write again with all informations. Thanks', 'iso-8859-1', 'default', 1, current_timestamp, 1, current_timestamp, 1);
+ (2, 1, 'default reject', 'Reject.', 'thank you for your e-mail. But you forgot importand infos. Pleace write again with all informations. Thanks', 'iso-8859-1', 'default', 1, sysdate, 1, sysdate, 1);
INSERT INTO auto_response
(type_id, system_address_id, name, text0, text1, charset, comments, valid_id, create_time, create_by, change_time, change_by)
VALUES
- (3, 1, 'default follow up', 'Thanks for your follow up e-mail
You wrote:
<OTRS_CUSTOMER_EMAIL[6]>
Your e-mail will be answered by a human asap.
Have fun with OTRS!
Your OTRS Team
', 'RE: <OTRS_CUSTOMER_SUBJECT[20]>', 'iso-8859-1', 'default', 1, current_timestamp, 1, current_timestamp, 1);
+ (3, 1, 'default follow up', 'Thanks for your follow up e-mail
+You wrote:
+OTRS_CUSTOMER_EMAIL[6]>
+Your e-mail will be answered by a human asap.
+Have fun with OTRS!
+Your OTRS Team
+', 'RE: <OTRS_CUSTOMER_SUBJECT[20]>', 'iso-8859-1', 'default', 1, sysdate, 1, sysdate, 1);
INSERT INTO auto_response
(type_id, system_address_id, name, text0, text1, charset, comments, valid_id, create_time, create_by, change_time, change_by)
VALUES
- (4, 1, 'default closed -> new ticket', 'New ticket after follow up.', 'thank you for your e-mail. The old ticket is closed. You have a new ticket now.', 'iso-8859-1', 'default', 1, current_timestamp, 1, current_timestamp, 1);
+ (4, 1, 'default closed -> new ticket', 'New ticket after follow up.', 'thank you for your e-mail. The old ticket is closed. You have a new ticket now.', 'iso-8859-1', 'default', 1, sysdate, 1, sysdate, 1);
INSERT INTO auto_response
(type_id, system_address_id, name, text0, text1, charset, comments, valid_id, create_time, create_by, change_time, change_by)
VALUES
- (5, 1, 'default remove', 'Ticket removed.', 'thank you for your remove e-mail. The ticket is closed.', 'iso-8859-1', 'default', 1, current_timestamp, 1, current_timestamp, 1);
+ (5, 1, 'default remove', 'Ticket removed.', 'thank you for your remove e-mail. The ticket is closed.', 'iso-8859-1', 'default', 1, sysdate, 1, sysdate, 1);
-- --
-- welcome ticket
<at> <at> -700,28 +724,35 <at> <at>
VALUES
(1,1,3, 'OTRS Feedback <feedback <at> otrs.org>', 'Your OTRS System <otrs <at> localhost>',
'Welcome to OTRS!', '<007 <at> localhost>',
- 'Welcome to OTRS!
thank you for installing OTRS.
You will find updates and patches at http://otrs.org/. Online
documentation is available at http://doc.otrs.org/. You can also
take advantage of our mailing lists http://lists.otrs.org/.
Your OTRS Team
Manage your communication!',
- 1012757943, '2002/02/3', 1, current_timestamp,1,current_timestamp,1);
+ 'Welcome to OTRS!
+thank you for installing OTRS.
+You will find updates and patches at http://otrs.org/. Online
+ocumentation is available at http://doc.otrs.org/. You can also
+ake advantage of our mailing lists http://lists.otrs.org/.
+
+our OTRS Team
+ Manage your communication!',
+ 1012757943, '2002/02/3', 1, sysdate,1,sysdate,1);
INSERT INTO ticket
(tn, queue_id, ticket_lock_id, ticket_answered, user_id, group_id, ticket_priority_id, ticket_state_id, valid_id, create_time_unix, escalation_start_time, create_time, create_by, change_time, change_by)
VALUES
- ('1010001', 2, 1, 0, 1, 1, 3, 1, 1, 1012757943, 0, current_timestamp, 1, current_timestamp, 1);
+ ('1010001', 2, 1, 0, 1, 1, 3, 1, 1, 1012757943, 0, sysdate, 1, sysdate, 1);
INSERT INTO ticket_history
(name, history_type_id, ticket_id, article_id, priority_id, owner_id, state_id, queue_id, valid_id, create_time, create_by, change_time, change_by)
VALUES
- ('New Ticket [1010001] created.',1,1,1,3,1,1,1,1, current_timestamp,1,current_timestamp,1);
+ ('New Ticket [1010001] created.',1,1,1,3,1,1,1,1, sysdate,1,sysdate,1);
INSERT INTO faq_item
(f_number, f_name, f_language_id, f_subject, state_id, category_id, f_field1, f_field2, f_field3, create_time, create_by, change_time, change_by)
VALUES
- ('100001', 'welcome', 1, 'Welcome!', 1, 1, 'symptom...', 'problem...', 'solution...', current_timestamp, 1, current_timestamp, 1);
+ ('100001', 'welcome', 1, 'Welcome!', 1, 1, 'symptom...', 'problem...', 'solution...', sysdate, 1, sysdate, 1);
INSERT INTO faq_history
(name, item_id, create_time, create_by, change_time, change_by)
VALUES
- ('Created', 1, current_timestamp, 1, current_timestamp, 1);
+ ('Created', 1, sysdate, 1, sysdate, 1);
INSERT INTO faq_language (name) VALUES ('en');
INSERT INTO faq_language (name) VALUES ('de');
<at> <at> -731,7 +762,7 <at> <at>
INSERT INTO faq_category
(name, comments, create_time, create_by, change_time, change_by)
VALUES
- ('all', 'default category', current_timestamp, 1, current_timestamp, 1);
+ ('all', 'default category', sysdate, 1, sysdate, 1);
INSERT INTO faq_state (name, type_id) VALUES ('internal (agent)', 1);
INSERT INTO faq_state (name, type_id) VALUES ('external (customer)', 2);
<at> <at> -747,83 +778,189 <at> <at>
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::NewTicket', 'iso-8859-1', 'en', 'New ticket notification! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_USERFIRSTNAME>,
there is a new ticket in "<OTRS_TICKET_QUEUE>"!
<OTRS_CUSTOMER_FROM> wrote:
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::NewTicket', 'iso-8859-1', 'en', 'New ticket notification! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_USERFIRSTNAME>,
+there is a new ticket in "<OTRS_TICKET_QUEUE>"!
+<OTRS_CUSTOMER_FROM> wrote:
+snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::FollowUp', 'iso-8859-1', 'en', 'You got follow up! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
you got a follow up!
<OTRS_CUSTOMER_FROM> wrote:
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::FollowUp', 'iso-8859-1', 'en', 'You got follow up! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
+you got a follow up!
+<OTRS_CUSTOMER_FROM> wrote:
+snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::LockTimeout', 'iso-8859-1', 'en', 'Lock Timeout! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
unlocked (lock timeout) your locked ticket [<OTRS_TICKET_TicketNumber>].
<OTRS_CUSTOMER_FROM> wrote:
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::LockTimeout', 'iso-8859-1', 'en', 'Lock Timeout! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
+unlocked (lock timeout) your locked ticket [<OTRS_TICKET_TicketNumber>].
+<OTRS_CUSTOMER_FROM> wrote:
+snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+ <OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::OwnerUpdate', 'iso-8859-1', 'en', 'Ticket assigned to you! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
a ticket [<OTRS_TICKET_TicketNumber>] is assigned to you by "<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>".
Comment:
<OTRS_COMMENT>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::OwnerUpdate', 'iso-8859-1', 'en', 'Ticket assigned to you! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
+a ticket [<OTRS_TICKET_TicketNumber>] is assigned to you by "<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>".
+Comment:
+OTRS_COMMENT>
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::AddNote', 'iso-8859-1', 'en', 'New note! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
"<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>" added a new note to ticket [<OTRS_TICKET_TicketNumber>].
Note:
<OTRS_CUSTOMER_BODY>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::AddNote', 'iso-8859-1', 'en', 'New note! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
+"<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>" added a new note to ticket [<OTRS_TICKET_TicketNumber>].
+Note:
+OTRS_CUSTOMER_BODY>
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::Move', 'iso-8859-1', 'en', 'Moved ticket in "<OTRS_CUSTOMER_QUEUE>" queue! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi,
"<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>" moved a ticket [<OTRS_TICKET_TicketNumber>] into "<OTRS_CUSTOMER_QUEUE>".
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::Move', 'iso-8859-1', 'en', 'Moved ticket in "<OTRS_CUSTOMER_QUEUE>" queue! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi,
+"<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>" moved a ticket [<OTRS_TICKET_TicketNumber>] into "<OTRS_CUSTOMER_QUEUE>".
+<snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::PendingReminder', 'iso-8859-1', 'en', 'Ticket Reminder!', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
the ticket "<OTRS_TICKET_TicketNumber>" has reached the reminder time!
<OTRS_CUSTOMER_FROM> wrote:
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
Please have a look at:
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::PendingReminder', 'iso-8859-1', 'en', 'Ticket Reminder!', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
+the ticket "<OTRS_TICKET_TicketNumber>" has reached the reminder time!
+<OTRS_CUSTOMER_FROM> wrote:
+snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+Please have a look at:
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::Escalation', 'iso-8859-1', 'en', 'Ticket Escalation!', 'Hi <OTRS_USERFIRSTNAME>,
the ticket "<OTRS_TICKET_TicketNumber>" is escaleted!
<OTRS_CUSTOMER_FROM> wrote:
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
Please have a look at:
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::Escalation', 'iso-8859-1', 'en', 'Ticket Escalation!', 'Hi <OTRS_USERFIRSTNAME>,
+the ticket "<OTRS_TICKET_TicketNumber>" is escaleted!
+<OTRS_CUSTOMER_FROM> wrote:
+snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+Please have a look at:
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::NewTicket', 'iso-8859-1', 'de', 'Neues Ticket! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_USERFIRSTNAME>,
es ist ein neues Ticket in "<OTRS_TICKET_QUEUE>"!
<OTRS_CUSTOMER_FROM> schrieb:
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::NewTicket', 'iso-8859-1', 'de', 'Neues Ticket! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_USERFIRSTNAME>,
+es ist ein neues Ticket in "<OTRS_TICKET_QUEUE>"!
+<OTRS_CUSTOMER_FROM> schrieb:
+snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::FollowUp', 'iso-8859-1', 'de', 'Nachfrage! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
Sie haben eine Nachfrage bekommen!
<OTRS_CUSTOMER_FROM> schrieb:
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::FollowUp', 'iso-8859-1', 'de', 'Nachfrage! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
+Sie haben eine Nachfrage bekommen!
+<OTRS_CUSTOMER_FROM> schrieb:
+snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::LockTimeout', 'iso-8859-1', 'de', 'Lock Timeout! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
Aufhebung der Sperre auf Dein gesperrtes Ticket [<OTRS_TICKET_TicketNumber>].
<OTRS_CUSTOMER_FROM> schrieb:
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::LockTimeout', 'iso-8859-1', 'de', 'Lock Timeout! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
+Aufhebung der Sperre auf Dein gesperrtes Ticket [<OTRS_TICKET_TicketNumber>].
+<OTRS_CUSTOMER_FROM> schrieb:
+snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+ <OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::OwnerUpdate', 'iso-8859-1', 'de', 'Ticket uebertragen an Sie! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
ein Ticket [<OTRS_TICKET_TicketNumber>] wurde an Sie von "<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>" uebertragen.
Kommentar:
<OTRS_COMMENT>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::OwnerUpdate', 'iso-8859-1', 'de', 'Ticket uebertragen an Sie! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
+ein Ticket [<OTRS_TICKET_TicketNumber>] wurde an Sie von "<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>" uebertragen.
+Kommentar:
+OTRS_COMMENT>
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::AddNote', 'iso-8859-1', 'de', 'Neue Notiz! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
"<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>" fuegte eine Notiz an Ticket [<OTRS_TICKET_TicketNumber>].
Notiz:
<OTRS_CUSTOMER_BODY>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::AddNote', 'iso-8859-1', 'de', 'Neue Notiz! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
+"<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>" fuegte eine Notiz an Ticket [<OTRS_TICKET_TicketNumber>].
+Notiz:
+OTRS_CUSTOMER_BODY>
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::Move', 'iso-8859-1', 'de', 'Ticket verschoben in "<OTRS_CUSTOMER_QUEUE>" Queue! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_USERFIRSTNAME>,
"<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>" verschob Ticket [<OTRS_TICKET_TicketNumber>] nach "<OTRS_CUSTOMER_QUEUE>".
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::Move', 'iso-8859-1', 'de', 'Ticket verschoben in "<OTRS_CUSTOMER_QUEUE>" Queue! (<OTRS_CUSTOMER_SUBJECT[18]>)', 'Hi <OTRS_USERFIRSTNAME>,
+"<OTRS_CURRENT_USERFIRSTNAME> <OTRS_CURRENT_USERLASTNAME>" verschob Ticket [<OTRS_TICKET_TicketNumber>] nach "<OTRS_CUSTOMER_QUEUE>".
+<snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::PendingReminder', 'iso-8859-1', 'de', 'Ticket Erinnerung!', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
das Ticket "<OTRS_TICKET_TicketNumber>" hat die Erinnerungszeit erreicht!
<OTRS_CUSTOMER_FROM> schrieb:
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
Bitte um weitere Bearbeitung:
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::PendingReminder', 'iso-8859-1', 'de', 'Ticket Erinnerung!', 'Hi <OTRS_OWNER_USERFIRSTNAME>,
+das Ticket "<OTRS_TICKET_TicketNumber>" hat die Erinnerungszeit erreicht!
+<OTRS_CUSTOMER_FROM> schrieb:
+snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+Bitte um weitere Bearbeitung:
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Agent::Escalation', 'iso-8859-1', 'de', 'Ticket Eskalation!', 'Hi <OTRS_USERFIRSTNAME>,
das Ticket "<OTRS_TICKET_TicketNumber>" ist eskaliert!
<OTRS_CUSTOMER_FROM> schrieb:
<snip>
<OTRS_CUSTOMER_EMAIL[16]>
<snip>
MBitte um Bearbeitung:
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master', current_timestamp, 1, current_timestamp, 1);
+ ('Agent::Escalation', 'iso-8859-1', 'de', 'Ticket Eskalation!', 'Hi <OTRS_USERFIRSTNAME>,
+das Ticket "<OTRS_TICKET_TicketNumber>" ist eskaliert!
+<OTRS_CUSTOMER_FROM> schrieb:
+snip>
+OTRS_CUSTOMER_EMAIL[16]>
+snip>
+MBitte um Bearbeitung:
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master', sysdate, 1, sysdate, 1);
--
-- customer notifications (en)
<at> <at> -831,17 +968,35 <at> <at>
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Customer::QueueUpdate', 'iso-8859-1', 'en', 'New Queue "<OTRS_TICKET_Queue>"!', '*** THIS IS JUST A NOTE ***
The queue of your ticket "<OTRS_TICKET_TicketNumber>" has been changed by
"<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname>" to "<OTRS_TICKET_Queue>".
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master
*** THIS IS JUST A NOTE ***
', current_timestamp, 1, current_timestamp, 1);
+ ('Customer::QueueUpdate', 'iso-8859-1', 'en', 'New Queue "<OTRS_TICKET_Queue>"!', '*** THIS IS JUST A NOTE ***
+The queue of your ticket "<OTRS_TICKET_TicketNumber>" has been changed by
+<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname>" to "<OTRS_TICKET_Queue>".
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master
+*** THIS IS JUST A NOTE ***
+', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Customer::OwnerUpdate', 'iso-8859-1', 'en', 'New Owner "<OTRS_OWNER_UserFirstname>"!', '*** THIS IS JUST A NOTE ***
The owner of your ticket "<OTRS_TICKET_TicketNumber>" has been changed to
"<OTRS_OWNER_UserFirstname> <OTRS_OWNER_UserLastname>.
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master
*** THIS IS JUST A NOTE ***
', current_timestamp, 1, current_timestamp, 1);
+ ('Customer::OwnerUpdate', 'iso-8859-1', 'en', 'New Owner "<OTRS_OWNER_UserFirstname>"!', '*** THIS IS JUST A NOTE ***
+The owner of your ticket "<OTRS_TICKET_TicketNumber>" has been changed to
+<OTRS_OWNER_UserFirstname> <OTRS_OWNER_UserLastname>.
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master
+*** THIS IS JUST A NOTE ***
+', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Customer::StateUpdate', 'iso-8859-1', 'en', 'New State "<OTRS_TICKET_State>"!', '*** THIS IS JUST A NOTE ***
The state of your ticket "<OTRS_TICKET_TicketNumber>" has been changed by
"<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname>" to "<OTRS_TICKET_State>".
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master
*** THIS IS JUST A NOTE ***
', current_timestamp, 1, current_timestamp, 1);
+ ('Customer::StateUpdate', 'iso-8859-1', 'en', 'New State "<OTRS_TICKET_State>"!', '*** THIS IS JUST A NOTE ***
+The state of your ticket "<OTRS_TICKET_TicketNumber>" has been changed by
+<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname>" to "<OTRS_TICKET_State>".
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
+Your OTRS Notification Master
+*** THIS IS JUST A NOTE ***
+', sysdate, 1, sysdate, 1);
--
-- customer notifications (de)
<at> <at> -849,15 +1004,33 <at> <at>
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Customer::QueueUpdate', 'iso-8859-1', 'de', 'Neue Queue "<OTRS_TICKET_Queue>"!', '*** NUR EINE INFO ***
Die Queue Ihres Tickets "<OTRS_TICKET_TicketNumber>" hat
"<OTRS_CUSTOMER_UserFirstname> <OTRS_CUSTOMER_UserLastname>" auf "<OTRS_TICKET_Queue>" geaendert.
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master
*** NUR EINE INFO ***
', current_timestamp, 1, current_timestamp, 1);
+ ('Customer::QueueUpdate', 'iso-8859-1', 'de', 'Neue Queue "<OTRS_TICKET_Queue>"!', '*** NUR EINE INFO ***
+Die Queue Ihres Tickets "<OTRS_TICKET_TicketNumber>" hat
+<OTRS_CUSTOMER_UserFirstname> <OTRS_CUSTOMER_UserLastname>" auf "<OTRS_TICKET_Queue>" geaendert.
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master
+*** NUR EINE INFO ***
+', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Customer::OwnerUpdate', 'iso-8859-1', 'de', 'Neuer Besitzer "<OTRS_OWNER_UserFirstname>"!', '*** NUR EINE INFO ***
Der Besitzer des Tickets "<OTRS_TICKET_TicketNumber>" hat sich auf
"<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> geaendert.
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master
*** NUR EINE INFO ***
', current_timestamp, 1, current_timestamp, 1);
+ ('Customer::OwnerUpdate', 'iso-8859-1', 'de', 'Neuer Besitzer "<OTRS_OWNER_UserFirstname>"!', '*** NUR EINE INFO ***
+Der Besitzer des Tickets "<OTRS_TICKET_TicketNumber>" hat sich auf
+<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> geaendert.
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master
+*** NUR EINE INFO ***
+', sysdate, 1, sysdate, 1);
INSERT INTO notifications
(notification_type, notification_charset, notification_language, subject, text, create_time, create_by, change_time, change_by)
VALUES
- ('Customer::StateUpdate', 'iso-8859-1', 'de', 'Neuer Status "<OTRS_TICKET_State>"!', '*** NUR EINE INFO ***
Der Status des Tickets "<OTRS_TICKET_TicketNumber>" hat sich durch
"<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname>" auf "<OTRS_TICKET_State>" veraendert.
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master
*** NUR EINE INFO ***
', current_timestamp, 1, current_timestamp, 1);
+ ('Customer::StateUpdate', 'iso-8859-1', 'de', 'Neuer Status "<OTRS_TICKET_State>"!', '*** NUR EINE INFO ***
+Der Status des Tickets "<OTRS_TICKET_TicketNumber>" hat sich durch
+<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname>" auf "<OTRS_TICKET_State>" veraendert.
+<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>customer.pl?Action=CustomerZoom&TicketID=<OTRS_TICKET_TicketID>
+Ihr OTRS Benachrichtigungs-Master
+*** NUR EINE INFO ***
+', sysdate, 1, sysdate, 1);
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
> > > Without knowing all that much, i think i wan't to write a new function > let's call it "GetSubscribedUserIDsByCustomerId" replacing > GetSubscribedUserIDsByQueueID. > This function should lookup agent <-> customer relation that i have > stored in an additional table, what is required is that i pass
It's a bug. It's fixed in upcoming OTRS 2.0.5. 
RSS Feed