-- ---------------------------------------------------------- -- driver: db2, generated: 2007-11-05 14:29:29 -- ---------------------------------------------------------- -- ---------------------------------------------------------- -- insert into table valid -- ---------------------------------------------------------- INSERT INTO valid (name, create_by, create_time, change_by, change_time) VALUES ('valid', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table valid -- ---------------------------------------------------------- INSERT INTO valid (name, create_by, create_time, change_by, change_time) VALUES ('invalid', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table valid -- ---------------------------------------------------------- INSERT INTO valid (name, create_by, create_time, change_by, change_time) VALUES ('invalid-temporarily', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table system_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@localhost', 'roK20XGbWEsSM', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table groups -- ---------------------------------------------------------- INSERT INTO groups (name, comments, valid_id, create_by, create_time, change_by, change_time) VALUES ('users', 'Group for default access.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table groups -- ---------------------------------------------------------- INSERT INTO groups (name, comments, valid_id, create_by, create_time, change_by, change_time) VALUES ('admin', 'Group of all admins.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table groups -- ---------------------------------------------------------- INSERT INTO groups (name, comments, valid_id, create_by, create_time, change_by, change_time) VALUES ('stats', 'Group for stats access.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table group_user -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table group_user -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table group_user -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table theme -- ---------------------------------------------------------- INSERT INTO theme (theme, valid_id, create_by, create_time, change_by, change_time) VALUES ('Standard', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table theme -- ---------------------------------------------------------- INSERT INTO theme (theme, valid_id, create_by, create_time, change_by, change_time) VALUES ('Lite', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table 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); -- ---------------------------------------------------------- -- insert into table ticket_state_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state -- ---------------------------------------------------------- INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) VALUES ('new', 'New ticket created by customer.', 1, 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_state -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state -- ---------------------------------------------------------- INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) VALUES ('open', 'Open tickets.', 2, 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_state -- ---------------------------------------------------------- INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) VALUES ('removed', 'Customer removed ticket.', 6, 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_state -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_state -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table salutation -- ---------------------------------------------------------- INSERT INTO salutation (name, text, comments, valid_id, create_by, create_time, change_by, change_time) VALUES ('system standard salutation (en)', 'Dear , Thank you for your request. ', 'Standard Salutation.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table 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 -- Super Support - Waterford Business Park 5201 Blue Lagoon Drive - 8th Floor & 9th Floor - Miami, 33126 USA Email: hot@example.com - Web: http://www.example.com/ --', 'Standard Signature.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table system_address -- ---------------------------------------------------------- INSERT INTO system_address (value0, value1, comments, valid_id, queue_id, create_by, create_time, change_by, change_time) VALUES ('otrs@localhost', 'OTRS System', 'Standard Address.', 1, 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table 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); -- ---------------------------------------------------------- -- insert into table follow_up_possible -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table follow_up_possible -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table queue -- ---------------------------------------------------------- INSERT INTO queue (name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, 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, 'Post master queue.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table queue -- ---------------------------------------------------------- INSERT INTO queue (name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, 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, 'All default incoming ticket.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table queue -- ---------------------------------------------------------- INSERT INTO queue (name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, 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, 'All junk tickets.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table queue -- ---------------------------------------------------------- INSERT INTO queue (name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, 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, 'All misc tickets.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table 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); -- ---------------------------------------------------------- -- insert into table standard_response -- ---------------------------------------------------------- INSERT INTO standard_response (name, text, valid_id, create_by, create_time, change_by, change_time) VALUES ('test answer', 'Some test answer to show how a standard response can be used.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table 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); -- ---------------------------------------------------------- -- insert into table queue_standard_response -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table queue_standard_response -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table queue_standard_response -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table 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 which will be sent out after a new ticket has been created.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table auto_response_type -- ---------------------------------------------------------- INSERT INTO auto_response_type (name, comments, valid_id, create_by, create_time, change_by, change_time) VALUES ('auto reject', 'Auto reject which will be sent out after a follow up has been rejected (in case queue follow up option is "reject").', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table auto_response_type -- ---------------------------------------------------------- INSERT INTO auto_response_type (name, comments, valid_id, create_by, create_time, change_by, change_time) VALUES ('auto follow up', 'Auto follow up is sent out after a added follow up has been received for a ticket (in case queue follow up option is "possible").', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table auto_response_type -- ---------------------------------------------------------- INSERT INTO auto_response_type (name, comments, valid_id, create_by, create_time, change_by, change_time) VALUES ('auto reply/new ticket', 'Auto reply/new ticket which will be sent out after a follow up has been rejected and a new ticket has been created (in case queue follow up option is "new ticket").', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table auto_response_type -- ---------------------------------------------------------- INSERT INTO auto_response_type (name, comments, valid_id, create_by, create_time, change_by, change_time) VALUES ('auto remove', 'Auto remove will be sent out after a customer removed th request by it self.', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table auto_response -- ---------------------------------------------------------- INSERT INTO auto_response (type_id, system_address_id, name, text0, text1, charset, comments, valid_id, create_by, create_time, change_by, change_time) VALUES (1, 1, 'default reply (after new ticket has been created)', '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: Your e-mail will be answered by a human asap Have fun with OTRS! :-) Your OTRS Team ', 'RE: ', 'iso-8859-1', '', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table auto_response -- ---------------------------------------------------------- INSERT INTO auto_response (type_id, system_address_id, name, text0, text1, charset, comments, valid_id, create_by, create_time, change_by, change_time) VALUES (2, 1, 'default reject (after follow up and rejected of a closed ticket)', 'Your previous ticket is closed. -- Your follow up has been rejected. -- Please create a new ticket. Your OTRS Team ', 'Your email has been rejected! (RE: )', 'iso-8859-1', '', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table auto_response -- ---------------------------------------------------------- INSERT INTO auto_response (type_id, system_address_id, name, text0, text1, charset, comments, valid_id, create_by, create_time, change_by, change_time) VALUES (3, 1, 'default follow up (after a ticket follow up has been added)', 'Thanks for your follow up e-mail You wrote: Your e-mail will be answered by a human asap. Have fun with OTRS! Your OTRS Team ', 'RE: ', 'iso-8859-1', '', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table auto_response -- ---------------------------------------------------------- INSERT INTO auto_response (type_id, system_address_id, name, text0, text1, charset, comments, valid_id, create_by, create_time, change_by, change_time) VALUES (4, 1, 'default reject/new ticket created (after closed follow up with new ticket creation)', 'Your previous ticket is closed. -- A new ticket has been created for you. -- You wrote: Your e-mail will be answered by a human asap. Have fun with OTRS! Your OTRS Team ', 'New ticket has been created! (RE: )', 'iso-8859-1', '', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_type -- ---------------------------------------------------------- INSERT INTO ticket_type (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('default', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_priority -- ---------------------------------------------------------- INSERT INTO ticket_priority (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('1 very low', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_priority -- ---------------------------------------------------------- INSERT INTO ticket_priority (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('2 low', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_priority -- ---------------------------------------------------------- INSERT INTO ticket_priority (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('3 normal', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_priority -- ---------------------------------------------------------- INSERT INTO ticket_priority (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('4 high', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_priority -- ---------------------------------------------------------- INSERT INTO ticket_priority (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('5 very high', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table 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); -- ---------------------------------------------------------- -- insert into table ticket_lock_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_lock_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('ResponsibleUpdate', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- 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 table ticket_history_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('TypeUpdate', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('ServiceUpdate', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_history_type -- ---------------------------------------------------------- INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('SLAUpdate', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table 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); -- ---------------------------------------------------------- -- insert into table article_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table article_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table article_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table article_type -- ---------------------------------------------------------- INSERT INTO article_type (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('phone', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table article_type -- ---------------------------------------------------------- INSERT INTO article_type (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('fax', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table article_type -- ---------------------------------------------------------- INSERT INTO article_type (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('sms', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table article_type -- ---------------------------------------------------------- INSERT INTO article_type (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('webrequest', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table article_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table article_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table article_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table 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); -- ---------------------------------------------------------- -- insert into table article_sender_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table article_sender_type -- ---------------------------------------------------------- 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); -- ---------------------------------------------------------- -- insert into table ticket -- ---------------------------------------------------------- INSERT INTO ticket (tn, queue_id, ticket_lock_id, ticket_answered, user_id, responsible_user_id, group_id, ticket_priority_id, ticket_state_id, create_time_unix, escalation_response_time, escalation_start_time, escalation_solution_time, valid_id, create_by, create_time, change_by, change_time) VALUES ('1010001', 2, 1, 0, 1, 1, 1, 3, 1, 1173345999, 0, 1173345999, 0, 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table article -- ---------------------------------------------------------- INSERT INTO article (ticket_id, article_type_id, article_sender_type_id, a_from, a_to, a_subject, a_body, a_message_id, incoming_time, content_path, valid_id, create_by, create_time, change_by, change_time) VALUES (1, 1, 3, 'OTRS Feedback ', 'Your OTRS System ', 'Welcome to OTRS!', 'Welcome! 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/. ((enjoy)) Your OTRS Team -- Communication with success! ', '<007@localhost>', 1173345999, '2007/03/08', 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table ticket_history -- ---------------------------------------------------------- INSERT INTO ticket_history (name, history_type_id, ticket_id, type_id, article_id, priority_id, owner_id, state_id, queue_id, valid_id, create_by, create_time, change_by, change_time) VALUES ('New Ticket [1010001] created.', 1, 1, 1, 1, 3, 1, 1, 1, 1, 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::NewTicket', 'iso-8859-1', 'en', 'New ticket notification! ()', 'Hi , there is a new ticket in ""! wrote: :///index.pl?Action=AgentZoom&TicketID= Your OTRS Notification Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::FollowUp', 'iso-8859-1', 'en', 'You got follow up! ()', 'Hi , you got a follow up! wrote: :///index.pl?Action=AgentZoom&TicketID= Your OTRS Notification Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::LockTimeout', 'iso-8859-1', 'en', 'Lock Timeout! ()', 'Hi , unlocked (lock timeout) your locked ticket []. wrote: :///index.pl?Action=AgentZoom&TicketID= Your OTRS Notification Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::OwnerUpdate', 'iso-8859-1', 'en', 'Ticket owner assigned to you! ()', 'Hi , a ticket [] is assigned to you by "( ". Comment: :///index.pl?Action=AgentZoom&TicketID= Your OTRS Notification Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::ResponsibleUpdate', 'iso-8859-1', 'en', 'Ticket responsible assigned to you! ()', 'Hi , a ticket [] is assigned to you by "( ". Comment: :///index.pl?Action=AgentZoom&TicketID= Your OTRS Notification Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::AddNote', 'iso-8859-1', 'en', 'New note! ()', 'Hi , " added a new note to ticket []. Note: :///index.pl?Action=AgentZoom&TicketID= Your OTRS Notification Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::Move', 'iso-8859-1', 'en', 'Moved ticket in "" queue! ()', 'Hi , " moved a ticket [] into "". :///index.pl?Action=AgentZoom&TicketID= Your OTRS Notification Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::PendingReminder', 'iso-8859-1', 'en', 'Ticket reminder has been reached! ()', 'Hi , the ticket "" has been reached the reminder time! wrote: Please have a look at: :///index.pl?Action=AgentZoom&TicketID= Your OTRS Notification Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::Escalation', 'iso-8859-1', 'en', 'Ticket Escalation! ()', 'Hi , the ticket "" is escalated! wrote: Please have a look at: :///index.pl?Action=AgentZoom&TicketID= Your OTRS Notification Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::NewTicket', 'iso-8859-1', 'de', 'Neues Ticket! ()', 'Hallo , es ist ein neues Ticket in ""! schrieb: :///index.pl?Action=AgentZoom&TicketID= Ihr OTRS Benachrichtigungs-Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::FollowUp', 'iso-8859-1', 'de', 'Nachfrage! ()', 'Hallo , Sie haben eine Nachfrage bekommen! schrieb: :///index.pl?Action=AgentZoom&TicketID= Ihr OTRS Benachrichtigungs-Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::LockTimeout', 'iso-8859-1', 'de', 'Lock Timeout! ()', 'Hallo , Aufhebung der Sperre auf Dein gesperrtes Ticket []. schrieb: :///index.pl?Action=AgentZoom&TicketID= Ihr OTRS Benachrichtigungs-Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::OwnerUpdate', 'iso-8859-1', 'de', 'Ticket Besitz uebertragen an Sie! ()', 'Hallo , der Besitz des Tickets [] wurde an Sie von "( " uebertragen. Kommentar: :///index.pl?Action=AgentZoom&TicketID= Ihr OTRS Benachrichtigungs-Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::ResponsibleUpdate', 'iso-8859-1', 'de', 'Ticket Verantwortung uebertragen an Sie! ()', 'Hallo , die Verantwortung des Tickets [] wurde an Sie von "( " uebertragen. Kommentar: :///index.pl?Action=AgentZoom&TicketID= Ihr OTRS Benachrichtigungs-Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::AddNote', 'iso-8859-1', 'de', 'Neue Notiz! ()', 'Hallo , " fuegte eine Notiz an Ticket []. Notiz: :///index.pl?Action=AgentZoom&TicketID= Ihr OTRS Benachrichtigungs-Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::Move', 'iso-8859-1', 'de', 'Ticket verschoben in "" Queue! ()', 'Hallo , " verschob Ticket [] nach "". :///index.pl?Action=AgentZoom&TicketID= Ihr OTRS Benachrichtigungs-Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::PendingReminder', 'iso-8859-1', 'de', 'Ticket Erinnerung erreicht! ()', 'Hallo , das Ticket "" hat die Erinnerungszeit erreicht! schrieb: Bitte um weitere Bearbeitung: :///index.pl?Action=AgentZoom&TicketID= Ihr OTRS Benachrichtigungs-Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Agent::Escalation', 'iso-8859-1', 'de', 'Ticket Eskalation! ()', 'Hallo , das Ticket "" ist eskaliert! schrieb: Bitte um Bearbeitung: :///index.pl?Action=AgentZoom&TicketID= Ihr OTRS Benachrichtigungs-Master', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Customer::QueueUpdate', 'iso-8859-1', 'en', 'New Queue ""!', '*** THIS IS JUST A NOTE *** The queue of your ticket "" has been changed by " " to "". :///customer.pl?Action=CustomerZoom&TicketID= Your OTRS Notification Master *** THIS IS JUST A NOTE ***', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Customer::OwnerUpdate', 'iso-8859-1', 'en', 'New Owner " "!', '*** THIS IS JUST A NOTE *** The owner of your ticket "" has been changed to " . :///customer.pl?Action=CustomerZoom&TicketID= Your OTRS Notification Master *** THIS IS JUST A NOTE ***', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Customer::StateUpdate', 'iso-8859-1', 'en', 'New State ""!', '*** THIS IS JUST A NOTE *** The state of your ticket "" has been changed by " " to "". :///customer.pl?Action=CustomerZoom&TicketID= Your OTRS Notification Master *** THIS IS JUST A NOTE ***', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Customer::QueueUpdate', 'iso-8859-1', 'de', 'Neue Queue ""!', '*** NUR EINE INFO *** Die Queue Ihres Tickets "" hat " " auf "" geaendert. :///customer.pl?Action=CustomerZoom&TicketID= Ihr OTRS Benachrichtigungs-Master *** NUR EINE INFO ***', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Customer::OwnerUpdate', 'iso-8859-1', 'de', 'Neuer Besitzer " "!', '*** NUR EINE INFO *** Der Besitzer des Tickets "" hat sich auf " geaendert. :///customer.pl?Action=CustomerZoom&TicketID= Ihr OTRS Benachrichtigungs-Master *** NUR EINE INFO ***', 1, current_timestamp, 1, current_timestamp); -- ---------------------------------------------------------- -- insert into table notifications -- ---------------------------------------------------------- INSERT INTO notifications (notification_type, notification_charset, notification_language, subject, text, create_by, create_time, change_by, change_time) VALUES ('Customer::StateUpdate', 'iso-8859-1', 'de', 'Neuer Status ""!', '*** NUR EINE INFO *** Der Status des Tickets "" hat sich durch " " auf "" geaendert. :///customer.pl?Action=CustomerZoom&TicketID= Ihr OTRS Benachrichtigungs-Master *** NUR EINE INFO ***', 1, current_timestamp, 1, current_timestamp);