Hallo zusammen,
ich habs geschaftt, OTRS funktioniert auf einer openSuse 13.1 mit mySQL, apache2 und php. Ein langer Weg, aber hat sich gelohnt. SChon tut sich aber das nächste PRoblem auf. Die Instalaltion, die ich letztlich zum laufen bekommen habe, ist die standard Installation aus dem Yast2. itsm habe ich in der Instalaltion nicht installiert, das wollte ich nachholen.
Übern den Yast2 geht es nicht, die aktuelle Version von der Homepage funktioniert auch nicht, vermutlich wegen der Versionsunterschiede.
Ich wollte sowieso, dass ich die aktuelle Version 3.2.16 auf die 3.3.8 updaten sollte. Die Frage ist nur wie?
Wenn ich mit Firefox das aktuelle Archiv für Suse herunterlade, dann öffnet sich der Arc und installiert die Dateien. Leider funktioniert dann die Änderung oder Neuanlegung der Datenbank nicht. Zwar werden dei Datenbanklen angelegt und der DB User bekommt ein seltsames Passwort, nur ab da hängt das Script. Ein neuer Aufruf der installer.pl führt dann zum Fehler, weil die DBs schon da sind.
Sollte ich dazu vielleicht besser die tars nehmen und alles von Hand ändern?
Hat jemand nen Tip?
update von 3.2.16 auf 3.3.8
Re: update von 3.2.16 auf 3.3.8
Hier noch die Fehlermeldung beim Aufruf der index.pl
Fehlermeldung: Access denied for user 'otrs'@'localhost' (using password: YES)
Fehlermeldung: Access denied for user 'otrs'@'localhost' (using password: YES)
Re: update von 3.2.16 auf 3.3.8
Hi,
wenn Du die online Yast version genommen hast, wirds tricky
(aber nicht schwer)
Meine Empfehlung:
Sichere alle Configs + Dumpe die Datenbank.
Entferne das yast otrs
installiere das SuSE rpm von otrs.com
restore Deine Config + Datenbank, passe ggf. die Datenbank Verbindung an (Username/Passwort)
sollte ohne Probleme gehen
Flo
wenn Du die online Yast version genommen hast, wirds tricky
(aber nicht schwer)
Meine Empfehlung:
Sichere alle Configs + Dumpe die Datenbank.
Entferne das yast otrs
installiere das SuSE rpm von otrs.com
restore Deine Config + Datenbank, passe ggf. die Datenbank Verbindung an (Username/Passwort)
sollte ohne Probleme gehen
Flo
OTRS 2025 SILVER (Prod)
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
Re: update von 3.2.16 auf 3.3.8
Hi Flo,
also gerade habe ich OTRS Yast weg gemacht und die rpms installiert. Alles wurde auch richtig angelegt und ich kann übern den Installer zugreifen.
Allerdings bekommt der es gerade mal hin, die Datenbank anzusprechen und die Tabellen in der DB anzulegen.
Ob alle angelegt wurden, kann ich nicht sagen, denn wenn ich mit phpMyAdmin einen Export mache, dann sagt mir die Datenbankfolgendes:
Sieht so aus, als würde in der letzten Tabelle irgendwas schief laufen.
Zuugriff auf den insaller.pl geht übrigens erst nach einem Neustart der Maschine. Hab noch nicht genau herausgefunden, welche Dienste ich in stoppen und starten muss.
Nachdem sich jetzt 20 Minuten lang nichts getan hat und der Export sich nicht ändert, starte ich die Maschine nochmal durch.
Tja und nach dem Neustart heißt es dann:
CREATE DATABASE `otrs`
Can't create database 'otrs'; database exists
und ein Button: Zurück
Das bringt mich wieder zum Test der Datenbankverbindung.
Also lösche ich die DB mit phpMyAdmin wieder und vergebe dieses Mal das Passwort für den Benutzer, welches auch schon in der vorherigen Version (OTRS Yast) angelegt wurde und auch funktioniert hat.
Aber gleiches Ergebnis:
Irgendwo klemmpt der Installer beim Beenden der Konfiguration.
Ich hol jetzt ein Image zurück, das die Yast Version drauf hat und fange nochmal von vorne an. Diesmal mit den Tars. Für die OpenSuse scheint weder der Download für die 10er noch für die 11er zu funktionieren.
Mal schsuen, was die tars sagen.
Gruß Markus
also gerade habe ich OTRS Yast weg gemacht und die rpms installiert. Alles wurde auch richtig angelegt und ich kann übern den Installer zugreifen.
Allerdings bekommt der es gerade mal hin, die Datenbank anzusprechen und die Tabellen in der DB anzulegen.
Ob alle angelegt wurden, kann ich nicht sagen, denn wenn ich mit phpMyAdmin einen Export mache, dann sagt mir die Datenbankfolgendes:
Code: Select all
-- phpMyAdmin SQL Dump
-- version 4.1.8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 29. Aug 2014 um 10:41
-- Server Version: 5.6.12
-- PHP-Version: 5.4.20
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Datenbank: `otrs`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `acl`
--
CREATE TABLE IF NOT EXISTS `acl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`description` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`stop_after_match` smallint(6) DEFAULT NULL,
`config_match` longblob,
`config_change` longblob,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `acl_name` (`name`),
KEY `FK_acl_create_by_id` (`create_by`),
KEY `FK_acl_change_by_id` (`change_by`),
KEY `FK_acl_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `acl_sync`
--
CREATE TABLE IF NOT EXISTS `acl_sync` (
`acl_id` varchar(200) NOT NULL,
`sync_state` varchar(30) NOT NULL,
`create_time` datetime NOT NULL,
`change_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `article`
--
CREATE TABLE IF NOT EXISTS `article` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) NOT NULL,
`article_type_id` smallint(6) NOT NULL,
`article_sender_type_id` smallint(6) NOT NULL,
`a_from` text,
`a_reply_to` text,
`a_to` text,
`a_cc` text,
`a_subject` text,
`a_message_id` text,
`a_message_id_md5` varchar(32) DEFAULT NULL,
`a_in_reply_to` text,
`a_references` text,
`a_content_type` varchar(250) DEFAULT NULL,
`a_body` mediumtext NOT NULL,
`incoming_time` int(11) NOT NULL,
`content_path` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `article_article_sender_type_id` (`article_sender_type_id`),
KEY `article_article_type_id` (`article_type_id`),
KEY `article_message_id_md5` (`a_message_id_md5`),
KEY `article_ticket_id` (`ticket_id`),
KEY `FK_article_create_by_id` (`create_by`),
KEY `FK_article_change_by_id` (`change_by`),
KEY `FK_article_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `article`
--
INSERT INTO `article` (`id`, `ticket_id`, `article_type_id`, `article_sender_type_id`, `a_from`, `a_reply_to`, `a_to`, `a_cc`, `a_subject`, `a_message_id`, `a_message_id_md5`, `a_in_reply_to`, `a_references`, `a_content_type`, `a_body`, `incoming_time`, `content_path`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 1, 1, 3, 'OTRS Feedback <feedback@otrs.org>', NULL, 'Your OTRS System <otrs@localhost>', NULL, 'Welcome to OTRS!', '<007@localhost>', NULL, NULL, NULL, NULL, 'Welcome!\n\nThank you for installing OTRS.\n\nYou will find updates and patches at http://www.otrs.com/open-source/.\nOnline documentation is available at http://doc.otrs.org/.\nYou can also use our mailing lists http://lists.otrs.org/\nor our forums at http://forums.otrs.org/\n\nRegards,\n\nThe OTRS Project\n', 1280750400, '2010/08/02', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `article_attachment`
--
CREATE TABLE IF NOT EXISTS `article_attachment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`article_id` bigint(20) NOT NULL,
`filename` varchar(250) DEFAULT NULL,
`content_size` varchar(30) DEFAULT NULL,
`content_type` text,
`content_id` varchar(250) DEFAULT NULL,
`content_alternative` varchar(50) DEFAULT NULL,
`content` longblob NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `article_attachment_article_id` (`article_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `article_flag`
--
CREATE TABLE IF NOT EXISTS `article_flag` (
`article_id` bigint(20) NOT NULL,
`article_key` varchar(50) NOT NULL,
`article_value` varchar(50) DEFAULT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
KEY `article_flag_article_id` (`article_id`),
KEY `article_flag_article_id_create_by` (`article_id`,`create_by`),
KEY `FK_article_flag_create_by_id` (`create_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `article_plain`
--
CREATE TABLE IF NOT EXISTS `article_plain` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`article_id` bigint(20) NOT NULL,
`body` longblob NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `article_plain_article_id` (`article_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `article_plain`
--
INSERT INTO `article_plain` (`id`, `article_id`, `body`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 1, 0x46726f6d3a204f54525320466565646261636b203c666565646261636b406f7472732e6f72673e0a546f3a20596f7572204f5452532053797374656d203c6f747273406c6f63616c686f73743e0a5375626a6563743a2057656c636f6d6520746f204f545253210a0a57656c636f6d65210a0a5468616e6b20796f7520666f7220696e7374616c6c696e67204f5452532e0a0a596f752077696c6c2066696e64207570646174657320616e64207061746368657320617420687474703a2f2f7777772e6f7472732e636f6d2f6f70656e2d736f757263652f2e0a4f6e6c696e6520646f63756d656e746174696f6e20697320617661696c61626c6520617420687474703a2f2f646f632e6f7472732e6f72672f2e0a596f752063616e20616c736f20757365206f7572206d61696c696e67206c6973747320687474703a2f2f6c697374732e6f7472732e6f72672f0a6f72206f757220666f72756d7320617420687474703a2f2f666f72756d732e6f7472732e6f72672f0a0a526567617264732c0a0a546865204f5452532050726f6a6563740a, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `article_search`
--
CREATE TABLE IF NOT EXISTS `article_search` (
`id` bigint(20) NOT NULL,
`ticket_id` bigint(20) NOT NULL,
`article_type_id` smallint(6) NOT NULL,
`article_sender_type_id` smallint(6) NOT NULL,
`a_from` text,
`a_to` text,
`a_cc` text,
`a_subject` text,
`a_body` mediumtext NOT NULL,
`incoming_time` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `article_search_article_sender_type_id` (`article_sender_type_id`),
KEY `article_search_article_type_id` (`article_type_id`),
KEY `article_search_ticket_id` (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `article_sender_type`
--
CREATE TABLE IF NOT EXISTS `article_sender_type` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `article_sender_type_name` (`name`),
KEY `FK_article_sender_type_create_by_id` (`create_by`),
KEY `FK_article_sender_type_change_by_id` (`change_by`),
KEY `FK_article_sender_type_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Daten für Tabelle `article_sender_type`
--
INSERT INTO `article_sender_type` (`id`, `name`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'agent', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'system', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'customer', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `article_type`
--
CREATE TABLE IF NOT EXISTS `article_type` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `article_type_name` (`name`),
KEY `FK_article_type_create_by_id` (`create_by`),
KEY `FK_article_type_change_by_id` (`change_by`),
KEY `FK_article_type_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
--
-- Daten für Tabelle `article_type`
--
INSERT INTO `article_type` (`id`, `name`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'email-external', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'email-internal', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'email-notification-ext', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(4, 'email-notification-int', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(5, 'phone', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(6, 'fax', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(7, 'sms', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(8, 'webrequest', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(9, 'note-internal', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(10, 'note-external', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(11, 'note-report', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `auto_response`
--
CREATE TABLE IF NOT EXISTS `auto_response` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`text0` text,
`text1` text,
`text2` text,
`type_id` smallint(6) NOT NULL,
`system_address_id` smallint(6) NOT NULL,
`charset` varchar(80) NOT NULL,
`content_type` varchar(250) DEFAULT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auto_response_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Daten für Tabelle `auto_response`
--
INSERT INTO `auto_response` (`id`, `name`, `text0`, `text1`, `text2`, `type_id`, `system_address_id`, `charset`, `content_type`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'default reply (after new ticket has been created)', 'This is a demo text which is send to every inquiry.\nIt could contain something like:\n\nThanks for your email. A new ticket has been created.\n\nYou wrote:\n<OTRS_CUSTOMER_EMAIL[6]>\n\nYour email will be answered by a human ASAP\n\nHave fun with OTRS! :-)\n\nYour OTRS Team\n', 'RE: <OTRS_CUSTOMER_SUBJECT[24]>', NULL, 1, 1, 'utf-8', 'text/plain', '', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'default reject (after follow up and rejected of a closed ticket)', 'Your previous ticket is closed.\n\n-- Your follow up has been rejected. --\n\nPlease create a new ticket.\n\nYour OTRS Team\n', 'Your email has been rejected! (RE: <OTRS_CUSTOMER_SUBJECT[24]>)', NULL, 2, 1, 'utf-8', 'text/plain', '', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'default follow up (after a ticket follow up has been added)', 'Thanks for your follow up email\n\nYou wrote:\n<OTRS_CUSTOMER_EMAIL[6]>\n\nYour email will be answered by a human ASAP.\n\nHave fun with OTRS!\n\nYour OTRS Team\n', 'RE: <OTRS_CUSTOMER_SUBJECT[24]>', NULL, 3, 1, 'utf-8', 'text/plain', '', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(4, 'default reject/new ticket created (after closed follow up with new ticket creation)', 'Your previous ticket is closed.\n\n-- A new ticket has been created for you. --\n\nYou wrote:\n<OTRS_CUSTOMER_EMAIL[6]>\n\nYour email will be answered by a human ASAP.\n\nHave fun with OTRS!\n\nYour OTRS Team\n', 'New ticket has been created! (RE: <OTRS_CUSTOMER_SUBJECT[24]>)', NULL, 4, 1, 'utf-8', 'text/plain', '', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `auto_response_type`
--
CREATE TABLE IF NOT EXISTS `auto_response_type` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auto_response_type_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Daten für Tabelle `auto_response_type`
--
INSERT INTO `auto_response_type` (`id`, `name`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'auto reply', 'Auto reply which will be sent out after a new ticket has been created.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, '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, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'auto follow up', 'Auto follow up is sent out after a follow up has been received for a ticket (in case queue follow up option is "possible").', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(4, '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, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(5, 'auto remove', 'Auto remove will be sent out after a customer removed the request.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `customer_company`
--
CREATE TABLE IF NOT EXISTS `customer_company` (
`customer_id` varchar(150) NOT NULL,
`name` varchar(200) NOT NULL,
`street` varchar(200) DEFAULT NULL,
`zip` varchar(200) DEFAULT NULL,
`city` varchar(200) DEFAULT NULL,
`country` varchar(200) DEFAULT NULL,
`url` varchar(200) DEFAULT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`customer_id`),
UNIQUE KEY `customer_company_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `customer_preferences`
--
CREATE TABLE IF NOT EXISTS `customer_preferences` (
`user_id` varchar(250) NOT NULL,
`preferences_key` varchar(150) NOT NULL,
`preferences_value` varchar(250) DEFAULT NULL,
KEY `customer_preferences_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `customer_user`
--
CREATE TABLE IF NOT EXISTS `customer_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(200) NOT NULL,
`email` varchar(150) NOT NULL,
`customer_id` varchar(150) NOT NULL,
`pw` varchar(64) DEFAULT NULL,
`title` varchar(50) DEFAULT NULL,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`phone` varchar(150) DEFAULT NULL,
`fax` varchar(150) DEFAULT NULL,
`mobile` varchar(150) DEFAULT NULL,
`street` varchar(150) DEFAULT NULL,
`zip` varchar(200) DEFAULT NULL,
`city` varchar(200) DEFAULT NULL,
`country` varchar(200) DEFAULT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `customer_user_login` (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `dynamic_field`
--
CREATE TABLE IF NOT EXISTS `dynamic_field` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`internal_field` smallint(6) NOT NULL DEFAULT '0',
`name` varchar(200) NOT NULL,
`label` varchar(200) NOT NULL,
`field_order` int(11) NOT NULL,
`field_type` varchar(200) NOT NULL,
`object_type` varchar(200) NOT NULL,
`config` longblob,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `dynamic_field_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Daten für Tabelle `dynamic_field`
--
INSERT INTO `dynamic_field` (`id`, `internal_field`, `name`, `label`, `field_order`, `field_type`, `object_type`, `config`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 1, 'ProcessManagementProcessID', 'ProcessManagementProcessID', 1, 'Text', 'Ticket', 0x2d2d2d0a44656661756c7456616c75653a2027270a, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 1, 'ProcessManagementActivityID', 'ProcessManagementActivityID', 1, 'Text', 'Ticket', 0x2d2d2d0a44656661756c7456616c75653a2027270a, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `dynamic_field_value`
--
CREATE TABLE IF NOT EXISTS `dynamic_field_value` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`field_id` int(11) NOT NULL,
`object_id` bigint(20) NOT NULL,
`value_text` text,
`value_date` datetime DEFAULT NULL,
`value_int` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `dynamic_field_value_field_values` (`object_id`),
KEY `dynamic_field_value_search_date` (`field_id`,`value_date`),
KEY `dynamic_field_value_search_int` (`field_id`,`value_int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `follow_up_possible`
--
CREATE TABLE IF NOT EXISTS `follow_up_possible` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `follow_up_possible_name` (`name`),
KEY `FK_follow_up_possible_create_by_id` (`create_by`),
KEY `FK_follow_up_possible_change_by_id` (`change_by`),
KEY `FK_follow_up_possible_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Daten für Tabelle `follow_up_possible`
--
INSERT INTO `follow_up_possible` (`id`, `name`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'possible', 'Follow ups after closed(+|-) possible. Ticket will be reopen.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'reject', 'Follow ups after closed(+|-) not possible. No new ticket will be created.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'new ticket', 'Follow ups after closed(+|-) not possible. A new ticket will be created..', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `generic_agent_jobs`
--
CREATE TABLE IF NOT EXISTS `generic_agent_jobs` (
`job_name` varchar(200) NOT NULL,
`job_key` varchar(200) NOT NULL,
`job_value` varchar(200) DEFAULT NULL,
KEY `generic_agent_jobs_job_name` (`job_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `gi_debugger_entry`
--
CREATE TABLE IF NOT EXISTS `gi_debugger_entry` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`communication_id` varchar(32) NOT NULL,
`communication_type` varchar(50) NOT NULL,
`remote_ip` varchar(50) DEFAULT NULL,
`webservice_id` int(11) NOT NULL,
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `gi_debugger_entry_communication_id` (`communication_id`),
KEY `gi_debugger_entry_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `gi_debugger_entry_content`
--
CREATE TABLE IF NOT EXISTS `gi_debugger_entry_content` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`gi_debugger_entry_id` bigint(20) NOT NULL,
`debug_level` varchar(50) NOT NULL,
`subject` varchar(255) NOT NULL,
`content` longblob,
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `gi_debugger_entry_content_create_time` (`create_time`),
KEY `gi_debugger_entry_content_debug_level` (`debug_level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `gi_object_lock_state`
--
CREATE TABLE IF NOT EXISTS `gi_object_lock_state` (
`webservice_id` int(11) NOT NULL,
`object_type` varchar(30) NOT NULL,
`object_id` bigint(20) NOT NULL,
`lock_state` varchar(30) NOT NULL,
`lock_state_counter` int(11) NOT NULL,
`create_time` datetime NOT NULL,
`change_time` datetime NOT NULL,
UNIQUE KEY `gi_object_lock_state_list` (`webservice_id`,`object_type`,`object_id`),
KEY `object_lock_state_list_state` (`webservice_id`,`object_type`,`object_id`,`lock_state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `gi_webservice_config`
--
CREATE TABLE IF NOT EXISTS `gi_webservice_config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`config` longblob NOT NULL,
`config_md5` varchar(32) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `gi_webservice_config_config_md5` (`config_md5`),
UNIQUE KEY `gi_webservice_config_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `gi_webservice_config_history`
--
CREATE TABLE IF NOT EXISTS `gi_webservice_config_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`config_id` int(11) NOT NULL,
`config` longblob NOT NULL,
`config_md5` varchar(32) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `gi_webservice_config_history_config_md5` (`config_md5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `groups`
--
CREATE TABLE IF NOT EXISTS `groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `groups_name` (`name`),
KEY `FK_groups_create_by_id` (`create_by`),
KEY `FK_groups_change_by_id` (`change_by`),
KEY `FK_groups_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Daten für Tabelle `groups`
--
INSERT INTO `groups` (`id`, `name`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'users', 'Group for default access.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'admin', 'Group of all administrators.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'stats', 'Group for statistics access.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `group_customer_user`
--
CREATE TABLE IF NOT EXISTS `group_customer_user` (
`user_id` varchar(100) NOT NULL,
`group_id` int(11) NOT NULL,
`permission_key` varchar(20) NOT NULL,
`permission_value` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
KEY `group_customer_user_group_id` (`group_id`),
KEY `group_customer_user_user_id` (`user_id`),
KEY `FK_group_customer_user_create_by_id` (`create_by`),
KEY `FK_group_customer_user_change_by_id` (`change_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `group_role`
--
CREATE TABLE IF NOT EXISTS `group_role` (
`role_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`permission_key` varchar(20) NOT NULL,
`permission_value` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
KEY `group_role_group_id` (`group_id`),
KEY `group_role_role_id` (`role_id`),
KEY `FK_group_role_create_by_id` (`create_by`),
KEY `FK_group_role_change_by_id` (`change_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `group_user`
--
CREATE TABLE IF NOT EXISTS `group_user` (
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`permission_key` varchar(20) NOT NULL,
`permission_value` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
KEY `group_user_group_id` (`group_id`),
KEY `group_user_user_id` (`user_id`),
KEY `FK_group_user_create_by_id` (`create_by`),
KEY `FK_group_user_change_by_id` (`change_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `group_user`
--
INSERT INTO `group_user` (`user_id`, `group_id`, `permission_key`, `permission_value`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 1, 'rw', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(1, 2, 'rw', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(1, 3, 'rw', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `link_object`
--
CREATE TABLE IF NOT EXISTS `link_object` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `link_object_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `link_relation`
--
CREATE TABLE IF NOT EXISTS `link_relation` (
`source_object_id` smallint(6) NOT NULL,
`source_key` varchar(50) NOT NULL,
`target_object_id` smallint(6) NOT NULL,
`target_key` varchar(50) NOT NULL,
`type_id` smallint(6) NOT NULL,
`state_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
UNIQUE KEY `link_relation_view` (`source_object_id`,`source_key`,`target_object_id`,`target_key`,`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `link_state`
--
CREATE TABLE IF NOT EXISTS `link_state` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `link_state_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Daten für Tabelle `link_state`
--
INSERT INTO `link_state` (`id`, `name`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'Valid', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'Temporary', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `link_type`
--
CREATE TABLE IF NOT EXISTS `link_type` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `link_type_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Daten für Tabelle `link_type`
--
INSERT INTO `link_type` (`id`, `name`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'Normal', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'ParentChild', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `mail_account`
--
CREATE TABLE IF NOT EXISTS `mail_account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(200) NOT NULL,
`pw` varchar(200) NOT NULL,
`host` varchar(200) NOT NULL,
`account_type` varchar(20) NOT NULL,
`queue_id` int(11) NOT NULL,
`trusted` smallint(6) NOT NULL,
`imap_folder` varchar(250) DEFAULT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `notifications`
--
CREATE TABLE IF NOT EXISTS `notifications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`notification_type` varchar(200) NOT NULL,
`notification_charset` varchar(60) NOT NULL,
`notification_language` varchar(60) NOT NULL,
`subject` varchar(200) NOT NULL,
`text` text NOT NULL,
`content_type` varchar(250) DEFAULT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;
--
-- Daten für Tabelle `notifications`
--
INSERT INTO `notifications` (`id`, `notification_type`, `notification_charset`, `notification_language`, `subject`, `text`, `content_type`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'Agent::NewTicket', 'utf-8', 'en', 'New ticket notification! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_UserFirstname>,\n\nThere is a new ticket in <OTRS_TICKET_Queue>!\n\n<OTRS_CUSTOMER_FROM> wrote:\n\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nYour OTRS Notification Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'Agent::FollowUp', 'utf-8', 'en', 'You''ve got a follow up! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_UserFirstname>,\n\nYou''ve got a follow up!\n\n<OTRS_CUSTOMER_FROM> wrote:\n\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nYour OTRS Notification Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'Agent::LockTimeout', 'utf-8', 'en', 'Lock Timeout! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_UserFirstname>,\n\nThe lock timeout period on [<OTRS_TICKET_TicketNumber>] has been reached, it is now unlocked.\n\n<OTRS_CUSTOMER_FROM> wrote:\n\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nYour OTRS Notification Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(4, 'Agent::OwnerUpdate', 'utf-8', 'en', 'Ticket owner assigned to you! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_UserFirstname>,\n\nTicket [<OTRS_TICKET_TicketNumber>] is assigned to you by <OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname>.\n\nComment:\n\n<OTRS_COMMENT>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nYour OTRS Notification Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(5, 'Agent::ResponsibleUpdate', 'utf-8', 'en', 'Ticket assigned to you! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_RESPONSIBLE_UserFirstname>,\n\nTicket [<OTRS_TICKET_TicketNumber>] is assigned to you by <OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname>.\n\nComment:\n\n<OTRS_COMMENT>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nYour OTRS Notification Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(6, 'Agent::AddNote', 'utf-8', 'en', 'New note! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_UserFirstname>,\n\n<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> added a new note to ticket [<OTRS_TICKET_TicketNumber>].\n\nNote:\n<OTRS_CUSTOMER_BODY>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nYour OTRS Notification Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(7, 'Agent::Move', 'utf-8', 'en', 'Moved ticket in <OTRS_CUSTOMER_QUEUE> queue! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_UserFirstname>,\n\n<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> moved a ticket [<OTRS_TICKET_TicketNumber>] into <OTRS_CUSTOMER_QUEUE>.\n\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nYour OTRS Notification Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(8, 'Agent::PendingReminder', 'utf-8', 'en', 'Ticket reminder has reached! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_UserFirstname>,\n\nThe ticket [<OTRS_TICKET_TicketNumber>] has reached its reminder time!\n\n<OTRS_CUSTOMER_FROM>\n\nwrote:\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\nPlease have a look at:\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nYour OTRS Notification Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(9, 'Agent::Escalation', 'utf-8', 'en', 'Ticket Escalation! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_UserFirstname>,\n\nThe ticket [<OTRS_TICKET_TicketNumber>] is escalated!\n\nEscalated at: <OTRS_TICKET_EscalationDestinationDate>\nEscalated since: <OTRS_TICKET_EscalationDestinationIn>\n\n<OTRS_CUSTOMER_FROM>\n\nwrote:\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\nPlease have a look at:\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nYour OTRS Notification Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(10, 'Agent::EscalationNotifyBefore', 'utf-8', 'en', 'Ticket Escalation Warning! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_UserFirstname>,\n\nThe ticket [<OTRS_TICKET_TicketNumber>] will escalate!\n\nEscalation at: <OTRS_TICKET_EscalationDestinationDate>\nEscalation in: <OTRS_TICKET_EscalationDestinationIn>\n\n<OTRS_CUSTOMER_FROM>\n\nwrote:\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\nPlease have a look at:\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nYour OTRS Notification Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(11, 'Agent::NewTicket', 'utf-8', 'de', 'Neues Ticket! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hallo <OTRS_UserFirstname> <OTRS_UserLastname>,\n\nes ist ein neues Ticket in <OTRS_TICKET_Queue>!\n\n<OTRS_CUSTOMER_FROM> schrieb:\n\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nIhr OTRS Benachrichtigungs-Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(12, 'Agent::FollowUp', 'utf-8', 'de', 'Nachfrage! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hallo <OTRS_UserFirstname> <OTRS_UserLastname>,\n\nSie haben eine Nachfrage bekommen!\n\n<OTRS_CUSTOMER_FROM> schrieb:\n\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nIhr OTRS Benachrichtigungs-Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(13, 'Agent::LockTimeout', 'utf-8', 'de', 'Lock Timeout! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hallo <OTRS_UserFirstname> <OTRS_UserLastname>,\n\nAufhebung der Sperre auf Dein gesperrtes Ticket [<OTRS_TICKET_TicketNumber>].\n\n<OTRS_CUSTOMER_FROM> schrieb:\n\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nIhr OTRS Benachrichtigungs-Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(14, 'Agent::OwnerUpdate', 'utf-8', 'de', 'Ticket Besitz uebertragen an Sie! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hallo <OTRS_UserFirstname> <OTRS_UserLastname>,\n\nDer Besitz des Tickets [<OTRS_TICKET_TicketNumber>] wurde an Sie von <OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> uebertragen.\n\nKommentar:\n\n<OTRS_COMMENT>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nIhr OTRS Benachrichtigungs-Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(15, 'Agent::ResponsibleUpdate', 'utf-8', 'de', 'Ticket Verantwortung uebertragen an Sie! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hallo <OTRS_RESPONSIBLE_UserFirstname> <OTRS_RESPONSIBLE_UserLastname>,\n\nDie Verantwortung des Tickets [<OTRS_TICKET_TicketNumber>] wurde an Sie von <OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> uebertragen.\n\nKommentar:\n\n<OTRS_COMMENT>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nIhr OTRS Benachrichtigungs-Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(16, 'Agent::AddNote', 'utf-8', 'de', 'Neue Notiz! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hallo <OTRS_UserFirstname> <OTRS_UserLastname>,\n\n<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> fuegte eine Notiz an Ticket [<OTRS_TICKET_TicketNumber>].\n\nNotiz:\n<OTRS_CUSTOMER_BODY>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nIhr OTRS Benachrichtigungs-Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(17, 'Agent::Move', 'utf-8', 'de', 'Ticket verschoben in "<OTRS_CUSTOMER_QUEUE>" Queue! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hallo <OTRS_UserFirstname> <OTRS_UserLastname>,\n\n<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> verschob Ticket [<OTRS_TICKET_TicketNumber>] nach "<OTRS_CUSTOMER_QUEUE>".\n\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nIhr OTRS Benachrichtigungs-Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(18, 'Agent::PendingReminder', 'utf-8', 'de', 'Ticket Erinnerung erreicht! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hallo <OTRS_UserFirstname> <OTRS_UserLastname>,\n\ndas Ticket [<OTRS_TICKET_TicketNumber>] hat die Erinnerungszeit erreicht!\n\n<OTRS_CUSTOMER_FROM>\n\nschrieb:\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\nBitte um weitere Bearbeitung:\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nIhr OTRS Benachrichtigungs-Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(19, 'Agent::Escalation', 'utf-8', 'de', 'Ticket Eskalation! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hallo <OTRS_UserFirstname> <OTRS_UserLastname>,\n\ndas Ticket [<OTRS_TICKET_TicketNumber>] ist eskaliert!\n\nEskaliert am: <OTRS_TICKET_EscalationDestinationDate>\nEskaliert seit: <OTRS_TICKET_EscalationDestinationIn>\n\n<OTRS_CUSTOMER_FROM>\n\nschrieb:\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\nBitte um Bearbeitung:\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nIhr OTRS Benachrichtigungs-Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(20, 'Agent::EscalationNotifyBefore', 'utf-8', 'de', 'Ticket Eskalations-Warnung! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hallo <OTRS_UserFirstname> <OTRS_UserLastname>,\n\ndas Ticket [<OTRS_TICKET_TicketNumber>] wird bald eskalieren!\n\nEskalation um: <OTRS_TICKET_EscalationDestinationDate>\nEskalation in: <OTRS_TICKET_EscalationDestinationIn>\n\n<OTRS_CUSTOMER_FROM>\n\nschrieb:\n<snip>\n<OTRS_CUSTOMER_EMAIL[30]>\n<snip>\n\nBitte um Bearbeitung:\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n\nIhr OTRS Benachrichtigungs-Master', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(21, 'Agent::NewTicket', 'utf-8', 'nl', 'Nieuw ticket (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Beste <OTRS_UserFirstname>,\n\nEr is een nieuw ticket aangemaakt in <OTRS_TICKET_Queue>!\n\n<OTRS_CUSTOMER_FROM> schreef:\n\n<OTRS_CUSTOMER_EMAIL[30]>\n(eerste 30 regels zijn weergegeven)\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(22, 'Agent::FollowUp', 'utf-8', 'nl', 'Reactie ontvangen (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Beste <OTRS_UserFirstname>,\n\nEr is een reactie ontvangen op onderstaand ticket.\n\n<OTRS_CUSTOMER_FROM> schreef:\n\n<OTRS_CUSTOMER_EMAIL[30]>\n(eerste 30 regels zijn weergegeven)\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(23, 'Agent::LockTimeout', 'utf-8', 'nl', 'Ticket ontgrendeld (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Beste <OTRS_UserFirstname>,\n\nDe bewerkingstijd van ticket [<OTRS_TICKET_TicketNumber>] is overschreden, het ticket is nu ontgrendeld.\n\n<OTRS_CUSTOMER_FROM> schreef:\n\n<OTRS_CUSTOMER_EMAIL[30]>\n(eerste 30 regels zijn weergegeven)\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(24, 'Agent::OwnerUpdate', 'utf-8', 'nl', 'Ticket toegewezen (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Beste <OTRS_UserFirstname>,\n\nTicket [<OTRS_TICKET_TicketNumber>] is aan jou toegewezen door <OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname>.\n\nOpmerking:\n\n<OTRS_COMMENT>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(25, 'Agent::ResponsibleUpdate', 'utf-8', 'nl', 'Verantwoordelijkheid bijgewerkt (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Beste <OTRS_RESPONSIBLE_UserFirstname>,\n\n<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> heeft je geregistreerd als verantwoordelijke voor ticket [<OTRS_TICKET_TicketNumber>].\n\nOpmerking:\n\n<OTRS_COMMENT>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(26, 'Agent::AddNote', 'utf-8', 'nl', 'Nieuwe notitie (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Beste <OTRS_UserFirstname>,\n\n<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> heeft een nieuwe notitie toegevoegd aan [<OTRS_TICKET_TicketNumber>].\n\nNotitie:\n<OTRS_CUSTOMER_BODY>\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(27, 'Agent::Move', 'utf-8', 'nl', 'Ticket verplaatst naar <OTRS_CUSTOMER_QUEUE> (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Beste <OTRS_UserFirstname>,\n\n<OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname> heeft [<OTRS_TICKET_TicketNumber>] verplaatst naar <OTRS_CUSTOMER_QUEUE>.\n\n<OTRS_CUSTOMER_EMAIL[30]>\n(eerste 30 regels zijn weergegeven)\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(28, 'Agent::PendingReminder', 'utf-8', 'nl', 'Herinnering (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Beste <OTRS_UserFirstname>,\n\nHet herinnermoment voor ticket [<OTRS_TICKET_TicketNumber>] is bereikt.\n\n<OTRS_CUSTOMER_FROM> schreef:\n\n<OTRS_CUSTOMER_EMAIL[30]>\n(eerste 30 regels zijn weergegeven)\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(29, 'Agent::Escalation', 'utf-8', 'nl', 'Escalatie (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Beste <OTRS_UserFirstname>,\n\nHet ticket [<OTRS_TICKET_TicketNumber>] is geëscaleerd!\n\nGeëscaleerd op: <OTRS_TICKET_EscalationDestinationDate>\nGeëscaleerd sinds: <OTRS_TICKET_EscalationDestinationIn>\n\n<OTRS_CUSTOMER_FROM> schreef:\n\n<OTRS_CUSTOMER_EMAIL[30]>\n(eerste 30 regels zijn weergegeven)\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(30, 'Agent::EscalationNotifyBefore', 'utf-8', 'nl', 'Ticket gaat escaleren (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Beste <OTRS_UserFirstname>,\n\nHet ticket [<OTRS_TICKET_TicketNumber>] gaat escaleren!\n\nEscalatie op: <OTRS_TICKET_EscalationDestinationDate>\nEscalatie over: <OTRS_TICKET_EscalationDestinationIn>\n\n<OTRS_CUSTOMER_FROM> schreef:\n\n<OTRS_CUSTOMER_EMAIL[30]>\n(eerste 30 regels zijn weergegeven)\n\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>\n', 'text/plain', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `notification_event`
--
CREATE TABLE IF NOT EXISTS `notification_event` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`subject` varchar(200) NOT NULL,
`text` text NOT NULL,
`content_type` varchar(250) NOT NULL,
`charset` varchar(100) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `notification_event_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `notification_event_item`
--
CREATE TABLE IF NOT EXISTS `notification_event_item` (
`notification_id` int(11) NOT NULL,
`event_key` varchar(200) NOT NULL,
`event_value` varchar(200) NOT NULL,
KEY `notification_event_item_event_key` (`event_key`),
KEY `notification_event_item_event_value` (`event_value`),
KEY `notification_event_item_notification_id` (`notification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `package_repository`
--
CREATE TABLE IF NOT EXISTS `package_repository` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`version` varchar(250) NOT NULL,
`vendor` varchar(250) NOT NULL,
`install_status` varchar(250) NOT NULL,
`filename` varchar(250) DEFAULT NULL,
`content_size` varchar(30) DEFAULT NULL,
`content_type` varchar(250) DEFAULT NULL,
`content` longblob NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `personal_queues`
--
CREATE TABLE IF NOT EXISTS `personal_queues` (
`user_id` int(11) NOT NULL,
`queue_id` int(11) NOT NULL,
KEY `personal_queues_queue_id` (`queue_id`),
KEY `personal_queues_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pm_activity`
--
CREATE TABLE IF NOT EXISTS `pm_activity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` varchar(50) NOT NULL,
`name` varchar(200) NOT NULL,
`config` longblob NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pm_activity_entity_id` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pm_activity_dialog`
--
CREATE TABLE IF NOT EXISTS `pm_activity_dialog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` varchar(50) NOT NULL,
`name` varchar(200) NOT NULL,
`config` longblob NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pm_activity_dialog_entity_id` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pm_entity`
--
CREATE TABLE IF NOT EXISTS `pm_entity` (
`entity_type` varchar(50) NOT NULL,
`entity_counter` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pm_entity_sync`
--
CREATE TABLE IF NOT EXISTS `pm_entity_sync` (
`entity_type` varchar(30) NOT NULL,
`entity_id` varchar(50) NOT NULL,
`sync_state` varchar(30) NOT NULL,
`create_time` datetime NOT NULL,
`change_time` datetime NOT NULL,
UNIQUE KEY `pm_entity_sync_list` (`entity_type`,`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pm_process`
--
CREATE TABLE IF NOT EXISTS `pm_process` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` varchar(50) NOT NULL,
`name` varchar(200) NOT NULL,
`state_entity_id` varchar(50) NOT NULL,
`layout` longblob NOT NULL,
`config` longblob NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pm_process_entity_id` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pm_transition`
--
CREATE TABLE IF NOT EXISTS `pm_transition` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` varchar(50) NOT NULL,
`name` varchar(200) NOT NULL,
`config` longblob NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pm_transition_entity_id` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pm_transition_action`
--
CREATE TABLE IF NOT EXISTS `pm_transition_action` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` varchar(50) NOT NULL,
`name` varchar(200) NOT NULL,
`config` longblob NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pm_transition_action_entity_id` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `postmaster_filter`
--
CREATE TABLE IF NOT EXISTS `postmaster_filter` (
`f_name` varchar(200) NOT NULL,
`f_stop` smallint(6) DEFAULT NULL,
`f_type` varchar(20) NOT NULL,
`f_key` varchar(200) NOT NULL,
`f_value` varchar(200) NOT NULL,
`f_not` smallint(6) DEFAULT NULL,
KEY `postmaster_filter_f_name` (`f_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `process_id`
--
CREATE TABLE IF NOT EXISTS `process_id` (
`process_name` varchar(200) NOT NULL,
`process_id` varchar(200) NOT NULL,
`process_host` varchar(200) NOT NULL,
`process_create` int(11) NOT NULL,
`process_change` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `queue`
--
CREATE TABLE IF NOT EXISTS `queue` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`group_id` int(11) NOT NULL,
`unlock_timeout` int(11) DEFAULT NULL,
`first_response_time` int(11) DEFAULT NULL,
`first_response_notify` smallint(6) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
`update_notify` smallint(6) DEFAULT NULL,
`solution_time` int(11) DEFAULT NULL,
`solution_notify` smallint(6) DEFAULT NULL,
`system_address_id` smallint(6) NOT NULL,
`calendar_name` varchar(100) DEFAULT NULL,
`default_sign_key` varchar(100) DEFAULT NULL,
`salutation_id` smallint(6) NOT NULL,
`signature_id` smallint(6) NOT NULL,
`follow_up_id` smallint(6) NOT NULL,
`follow_up_lock` smallint(6) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `queue_name` (`name`),
KEY `queue_group_id` (`group_id`),
KEY `FK_queue_follow_up_id_id` (`follow_up_id`),
KEY `FK_queue_salutation_id_id` (`salutation_id`),
KEY `FK_queue_signature_id_id` (`signature_id`),
KEY `FK_queue_system_address_id_id` (`system_address_id`),
KEY `FK_queue_create_by_id` (`create_by`),
KEY `FK_queue_change_by_id` (`change_by`),
KEY `FK_queue_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Daten für Tabelle `queue`
--
INSERT INTO `queue` (`id`, `name`, `group_id`, `unlock_timeout`, `first_response_time`, `first_response_notify`, `update_time`, `update_notify`, `solution_time`, `solution_notify`, `system_address_id`, `calendar_name`, `default_sign_key`, `salutation_id`, `signature_id`, `follow_up_id`, `follow_up_lock`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'Postmaster', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, 1, 1, 1, 'Postmaster queue.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'Raw', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, 1, 1, 1, 'All default incoming tickets.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'Junk', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, 1, 1, 1, 'All junk tickets.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(4, 'Misc', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, 1, 1, 1, 'All misc tickets.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `queue_auto_response`
--
CREATE TABLE IF NOT EXISTS `queue_auto_response` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`queue_id` int(11) NOT NULL,
`auto_response_id` int(11) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `queue_preferences`
--
CREATE TABLE IF NOT EXISTS `queue_preferences` (
`queue_id` int(11) NOT NULL,
`preferences_key` varchar(150) NOT NULL,
`preferences_value` varchar(250) DEFAULT NULL,
KEY `queue_preferences_queue_id` (`queue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `queue_standard_template`
--
CREATE TABLE IF NOT EXISTS `queue_standard_template` (
`queue_id` int(11) NOT NULL,
`standard_template_id` int(11) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `queue_standard_template`
--
INSERT INTO `queue_standard_template` (`queue_id`, `standard_template_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(4, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `roles`
--
CREATE TABLE IF NOT EXISTS `roles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `roles_name` (`name`),
KEY `FK_roles_create_by_id` (`create_by`),
KEY `FK_roles_change_by_id` (`change_by`),
KEY `FK_roles_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `role_user`
--
CREATE TABLE IF NOT EXISTS `role_user` (
`user_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
KEY `role_user_role_id` (`role_id`),
KEY `role_user_user_id` (`user_id`),
KEY `FK_role_user_create_by_id` (`create_by`),
KEY `FK_role_user_change_by_id` (`change_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `salutation`
--
CREATE TABLE IF NOT EXISTS `salutation` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`text` text NOT NULL,
`content_type` varchar(250) DEFAULT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `salutation_name` (`name`),
KEY `FK_salutation_create_by_id` (`create_by`),
KEY `FK_salutation_change_by_id` (`change_by`),
KEY `FK_salutation_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `salutation`
--
INSERT INTO `salutation` (`id`, `name`, `text`, `content_type`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'system standard salutation (en)', 'Dear <OTRS_CUSTOMER_REALNAME>,\n\nThank you for your request.\n\n', 'text/plain; charset=utf-8', 'Standard Salutation.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `scheduler_task_list`
--
CREATE TABLE IF NOT EXISTS `scheduler_task_list` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`task_data` text NOT NULL,
`task_data_md5` varchar(32) NOT NULL,
`task_type` varchar(200) NOT NULL,
`due_time` datetime NOT NULL,
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `scheduler_task_list_task_data_md5` (`task_data_md5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `search_profile`
--
CREATE TABLE IF NOT EXISTS `search_profile` (
`login` varchar(200) NOT NULL,
`profile_name` varchar(200) NOT NULL,
`profile_type` varchar(30) NOT NULL,
`profile_key` varchar(200) NOT NULL,
`profile_value` varchar(200) DEFAULT NULL,
KEY `search_profile_login` (`login`),
KEY `search_profile_profile_name` (`profile_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `service`
--
CREATE TABLE IF NOT EXISTS `service` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `service_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `service_customer_user`
--
CREATE TABLE IF NOT EXISTS `service_customer_user` (
`customer_user_login` varchar(200) NOT NULL,
`service_id` int(11) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
KEY `service_customer_user_customer_user_login` (`customer_user_login`(10)),
KEY `service_customer_user_service_id` (`service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `service_preferences`
--
CREATE TABLE IF NOT EXISTS `service_preferences` (
`service_id` int(11) NOT NULL,
`preferences_key` varchar(150) NOT NULL,
`preferences_value` varchar(250) DEFAULT NULL,
KEY `service_preferences_service_id` (`service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `service_sla`
--
CREATE TABLE IF NOT EXISTS `service_sla` (
`service_id` int(11) NOT NULL,
`sla_id` int(11) NOT NULL,
UNIQUE KEY `service_sla_service_sla` (`service_id`,`sla_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `sessions`
--
CREATE TABLE IF NOT EXISTS `sessions` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`session_id` varchar(100) NOT NULL,
`data_key` varchar(100) NOT NULL,
`data_value` text,
`serialized` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
KEY `sessions_data_key` (`data_key`),
KEY `sessions_session_id_data_key` (`session_id`,`data_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `signature`
--
CREATE TABLE IF NOT EXISTS `signature` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`text` text NOT NULL,
`content_type` varchar(250) DEFAULT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `signature_name` (`name`),
KEY `FK_signature_create_by_id` (`create_by`),
KEY `FK_signature_change_by_id` (`change_by`),
KEY `FK_signature_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `signature`
--
INSERT INTO `signature` (`id`, `name`, `text`, `content_type`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'system standard signature (en)', '\nYour Ticket-Team\n\n <OTRS_Agent_UserFirstname> <OTRS_Agent_UserLastname>\n\n--\n Super Support - Waterford Business Park\n 5201 Blue Lagoon Drive - 8th Floor & 9th Floor - Miami, 33126 USA\n Email: hot@example.com - Web: http://www.example.com/\n--', 'text/plain; charset=utf-8', 'Standard Signature.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `sla`
--
CREATE TABLE IF NOT EXISTS `sla` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`calendar_name` varchar(100) DEFAULT NULL,
`first_response_time` int(11) NOT NULL,
`first_response_notify` smallint(6) DEFAULT NULL,
`update_time` int(11) NOT NULL,
`update_notify` smallint(6) DEFAULT NULL,
`solution_time` int(11) NOT NULL,
`solution_notify` smallint(6) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sla_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `sla_preferences`
--
CREATE TABLE IF NOT EXISTS `sla_preferences` (
`sla_id` int(11) NOT NULL,
`preferences_key` varchar(150) NOT NULL,
`preferences_value` varchar(250) DEFAULT NULL,
KEY `sla_preferences_sla_id` (`sla_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `smime_signer_cert_relations`
--
CREATE TABLE IF NOT EXISTS `smime_signer_cert_relations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cert_hash` varchar(8) NOT NULL,
`cert_fingerprint` varchar(59) NOT NULL,
`ca_hash` varchar(8) NOT NULL,
`ca_fingerprint` varchar(59) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `standard_attachment`
--
CREATE TABLE IF NOT EXISTS `standard_attachment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`content_type` varchar(250) NOT NULL,
`content` longblob NOT NULL,
`filename` varchar(250) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `standard_attachment_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `standard_template`
--
CREATE TABLE IF NOT EXISTS `standard_template` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`text` text,
`content_type` varchar(250) DEFAULT NULL,
`template_type` varchar(100) NOT NULL DEFAULT 'Answer',
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `standard_template_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Daten für Tabelle `standard_template`
--
INSERT INTO `standard_template` (`id`, `name`, `text`, `content_type`, `template_type`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'empty answer', '', 'text/plain; charset=utf-8', 'Answer', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'test answer', 'Some test answer to show how a standard template can be used.', 'text/plain; charset=utf-8', 'Answer', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `standard_template_attachment`
--
CREATE TABLE IF NOT EXISTS `standard_template_attachment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`standard_attachment_id` int(11) NOT NULL,
`standard_template_id` int(11) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `system_address`
--
CREATE TABLE IF NOT EXISTS `system_address` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`value0` varchar(200) NOT NULL,
`value1` varchar(200) NOT NULL,
`value2` varchar(200) DEFAULT NULL,
`value3` varchar(200) DEFAULT NULL,
`queue_id` int(11) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK_system_address_create_by_id` (`create_by`),
KEY `FK_system_address_change_by_id` (`change_by`),
KEY `FK_system_address_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `system_address`
--
INSERT INTO `system_address` (`id`, `value0`, `value1`, `value2`, `value3`, `queue_id`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'otrs@localhost', 'OTRS System', NULL, NULL, 1, 'Standard Address.', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `system_data`
--
CREATE TABLE IF NOT EXISTS `system_data` (
`data_key` varchar(160) NOT NULL,
`data_value` longblob,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`data_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket`
--
CREATE TABLE IF NOT EXISTS `ticket` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`tn` varchar(50) NOT NULL,
`title` varchar(255) DEFAULT NULL,
`queue_id` int(11) NOT NULL,
`ticket_lock_id` smallint(6) NOT NULL,
`type_id` smallint(6) DEFAULT NULL,
`service_id` int(11) DEFAULT NULL,
`sla_id` int(11) DEFAULT NULL,
`user_id` int(11) NOT NULL,
`responsible_user_id` int(11) NOT NULL,
`ticket_priority_id` smallint(6) NOT NULL,
`ticket_state_id` smallint(6) NOT NULL,
`customer_id` varchar(150) DEFAULT NULL,
`customer_user_id` varchar(250) DEFAULT NULL,
`timeout` int(11) NOT NULL,
`until_time` int(11) NOT NULL,
`escalation_time` int(11) NOT NULL,
`escalation_update_time` int(11) NOT NULL,
`escalation_response_time` int(11) NOT NULL,
`escalation_solution_time` int(11) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`archive_flag` smallint(6) NOT NULL DEFAULT '0',
`create_time_unix` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ticket_tn` (`tn`),
KEY `ticket_archive_flag` (`archive_flag`),
KEY `ticket_create_time` (`create_time`),
KEY `ticket_create_time_unix` (`create_time_unix`),
KEY `ticket_customer_id` (`customer_id`),
KEY `ticket_customer_user_id` (`customer_user_id`),
KEY `ticket_escalation_response_time` (`escalation_response_time`),
KEY `ticket_escalation_solution_time` (`escalation_solution_time`),
KEY `ticket_escalation_time` (`escalation_time`),
KEY `ticket_escalation_update_time` (`escalation_update_time`),
KEY `ticket_queue_id` (`queue_id`),
KEY `ticket_queue_view` (`ticket_state_id`,`ticket_lock_id`),
KEY `ticket_responsible_user_id` (`responsible_user_id`),
KEY `ticket_ticket_lock_id` (`ticket_lock_id`),
KEY `ticket_ticket_priority_id` (`ticket_priority_id`),
KEY `ticket_ticket_state_id` (`ticket_state_id`),
KEY `ticket_timeout` (`timeout`),
KEY `ticket_title` (`title`),
KEY `ticket_type_id` (`type_id`),
KEY `ticket_until_time` (`until_time`),
KEY `ticket_user_id` (`user_id`),
KEY `FK_ticket_service_id_id` (`service_id`),
KEY `FK_ticket_sla_id_id` (`sla_id`),
KEY `FK_ticket_create_by_id` (`create_by`),
KEY `FK_ticket_change_by_id` (`change_by`),
KEY `FK_ticket_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `ticket`
--
INSERT INTO `ticket` (`id`, `tn`, `title`, `queue_id`, `ticket_lock_id`, `type_id`, `service_id`, `sla_id`, `user_id`, `responsible_user_id`, `ticket_priority_id`, `ticket_state_id`, `customer_id`, `customer_user_id`, `timeout`, `until_time`, `escalation_time`, `escalation_update_time`, `escalation_response_time`, `escalation_solution_time`, `valid_id`, `archive_flag`, `create_time_unix`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, '2010080210123456', 'Welcome to OTRS!', 2, 1, NULL, NULL, NULL, 1, 1, 3, 1, NULL, NULL, 0, 0, 0, 0, 0, 0, 1, 0, 1280750400, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_flag`
--
CREATE TABLE IF NOT EXISTS `ticket_flag` (
`ticket_id` bigint(20) NOT NULL,
`ticket_key` varchar(50) NOT NULL,
`ticket_value` varchar(50) DEFAULT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
UNIQUE KEY `ticket_flag_per_user` (`ticket_id`,`ticket_key`,`create_by`),
KEY `ticket_flag_ticket_id` (`ticket_id`),
KEY `ticket_flag_ticket_id_create_by` (`ticket_id`,`create_by`),
KEY `ticket_flag_ticket_id_ticket_key` (`ticket_id`,`ticket_key`),
KEY `FK_ticket_flag_create_by_id` (`create_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_history`
--
CREATE TABLE IF NOT EXISTS `ticket_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`history_type_id` smallint(6) NOT NULL,
`ticket_id` bigint(20) NOT NULL,
`article_id` bigint(20) DEFAULT NULL,
`type_id` smallint(6) NOT NULL,
`queue_id` int(11) NOT NULL,
`owner_id` int(11) NOT NULL,
`priority_id` smallint(6) NOT NULL,
`state_id` smallint(6) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `ticket_history_create_time` (`create_time`),
KEY `ticket_history_history_type_id` (`history_type_id`),
KEY `ticket_history_owner_id` (`owner_id`),
KEY `ticket_history_priority_id` (`priority_id`),
KEY `ticket_history_queue_id` (`queue_id`),
KEY `ticket_history_state_id` (`state_id`),
KEY `ticket_history_ticket_id` (`ticket_id`),
KEY `ticket_history_type_id` (`type_id`),
KEY `FK_ticket_history_article_id_id` (`article_id`),
KEY `FK_ticket_history_create_by_id` (`create_by`),
KEY `FK_ticket_history_change_by_id` (`change_by`),
KEY `FK_ticket_history_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `ticket_history`
--
INSERT INTO `ticket_history` (`id`, `name`, `history_type_id`, `ticket_id`, `article_id`, `type_id`, `queue_id`, `owner_id`, `priority_id`, `state_id`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'New Ticket [2010080210123456] created.', 1, 1, 1, 1, 1, 1, 3, 1, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_history_type`
--
CREATE TABLE IF NOT EXISTS `ticket_history_type` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ticket_history_type_name` (`name`),
KEY `FK_ticket_history_type_create_by_id` (`create_by`),
KEY `FK_ticket_history_type_change_by_id` (`change_by`),
KEY `FK_ticket_history_type_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;
--
-- Daten für Tabelle `ticket_history_type`
--
INSERT INTO `ticket_history_type` (`id`, `name`, `comments`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'NewTicket', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'FollowUp', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'SendAutoReject', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(4, 'SendAutoReply', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(5, 'SendAutoFollowUp', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(6, 'Forward', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(7, 'Bounce', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(8, 'SendAnswer', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(9, 'SendAgentNotification', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(10, 'SendCustomerNotification', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(11, 'EmailAgent', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(12, 'EmailCustomer', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(13, 'PhoneCallAgent', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(14, 'PhoneCallCustomer', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(15, 'AddNote', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(16, 'Move', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(17, 'Lock', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(18, 'Unlock', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(19, 'Remove', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(20, 'TimeAccounting', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(21, 'CustomerUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(22, 'PriorityUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(23, 'OwnerUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(24, 'LoopProtection', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(25, 'Misc', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(26, 'SetPendingTime', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(27, 'StateUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(28, 'TicketDynamicFieldUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(29, 'WebRequestCustomer', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(30, 'TicketLinkAdd', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(31, 'TicketLinkDelete', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(32, 'SystemRequest', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(33, 'Merged', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(34, 'ResponsibleUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(35, 'Subscribe', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(36, 'Unsubscribe', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(37, 'TypeUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(38, 'ServiceUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(39, 'SLAUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(40, 'ArchiveFlagUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(41, 'EscalationSolutionTimeStop', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(42, 'EscalationResponseTimeStart', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(43, 'EscalationUpdateTimeStart', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(44, 'EscalationSolutionTimeStart', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(45, 'EscalationResponseTimeNotifyBefore', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(46, 'EscalationUpdateTimeNotifyBefore', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(47, 'EscalationSolutionTimeNotifyBefore', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(48, 'EscalationResponseTimeStop', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(49, 'EscalationUpdateTimeStop', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(50, 'TitleUpdate', NULL, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_index`
--
CREATE TABLE IF NOT EXISTS `ticket_index` (
`ticket_id` bigint(20) NOT NULL,
`queue_id` int(11) NOT NULL,
`queue` varchar(200) NOT NULL,
`group_id` int(11) NOT NULL,
`s_lock` varchar(200) NOT NULL,
`s_state` varchar(200) NOT NULL,
`create_time_unix` bigint(20) NOT NULL,
KEY `ticket_index_group_id` (`group_id`),
KEY `ticket_index_queue_id` (`queue_id`),
KEY `ticket_index_ticket_id` (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_lock_index`
--
CREATE TABLE IF NOT EXISTS `ticket_lock_index` (
`ticket_id` bigint(20) NOT NULL,
KEY `ticket_lock_index_ticket_id` (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_lock_type`
--
CREATE TABLE IF NOT EXISTS `ticket_lock_type` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ticket_lock_type_name` (`name`),
KEY `FK_ticket_lock_type_create_by_id` (`create_by`),
KEY `FK_ticket_lock_type_change_by_id` (`change_by`),
KEY `FK_ticket_lock_type_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Daten für Tabelle `ticket_lock_type`
--
INSERT INTO `ticket_lock_type` (`id`, `name`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'unlock', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'lock', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'tmp_lock', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_loop_protection`
--
CREATE TABLE IF NOT EXISTS `ticket_loop_protection` (
`sent_to` varchar(250) NOT NULL,
`sent_date` varchar(150) NOT NULL,
KEY `ticket_loop_protection_sent_date` (`sent_date`),
KEY `ticket_loop_protection_sent_to` (`sent_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_priority`
--
CREATE TABLE IF NOT EXISTS `ticket_priority` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ticket_priority_name` (`name`),
KEY `FK_ticket_priority_create_by_id` (`create_by`),
KEY `FK_ticket_priority_change_by_id` (`change_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Daten für Tabelle `ticket_priority`
--
INSERT INTO `ticket_priority` (`id`, `name`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, '1 very low', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, '2 low', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, '3 normal', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(4, '4 high', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(5, '5 very high', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_state`
--
CREATE TABLE IF NOT EXISTS `ticket_state` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`type_id` smallint(6) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ticket_state_name` (`name`),
KEY `FK_ticket_state_type_id_id` (`type_id`),
KEY `FK_ticket_state_create_by_id` (`create_by`),
KEY `FK_ticket_state_change_by_id` (`change_by`),
KEY `FK_ticket_state_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Daten für Tabelle `ticket_state`
--
INSERT INTO `ticket_state` (`id`, `name`, `comments`, `type_id`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'new', 'New ticket created by customer.', 1, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'closed successful', 'Ticket is closed successful.', 3, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'closed unsuccessful', 'Ticket is closed unsuccessful.', 3, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(4, 'open', 'Open tickets.', 2, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(5, 'removed', 'Customer removed ticket.', 6, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(6, 'pending reminder', 'Ticket is pending for agent reminder.', 4, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(7, 'pending auto close+', 'Ticket is pending for automatic close.', 5, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(8, 'pending auto close-', 'Ticket is pending for automatic close.', 5, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(9, 'merged', 'State for merged tickets.', 7, 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_state_type`
--
CREATE TABLE IF NOT EXISTS `ticket_state_type` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`comments` varchar(250) DEFAULT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ticket_state_type_name` (`name`),
KEY `FK_ticket_state_type_create_by_id` (`create_by`),
KEY `FK_ticket_state_type_change_by_id` (`change_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Daten für Tabelle `ticket_state_type`
--
INSERT INTO `ticket_state_type` (`id`, `name`, `comments`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'new', 'All new state types (default: viewable).', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'open', 'All open state types (default: viewable).', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'closed', 'All closed state types (default: not viewable).', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(4, 'pending reminder', 'All ''pending reminder'' state types (default: viewable).', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(5, 'pending auto', 'All ''pending auto *'' state types (default: viewable).', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(6, 'removed', 'All ''removed'' state types (default: not viewable).', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(7, 'merged', 'State type for merged tickets (default: not viewable).', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_type`
--
CREATE TABLE IF NOT EXISTS `ticket_type` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ticket_type_name` (`name`),
KEY `FK_ticket_type_create_by_id` (`create_by`),
KEY `FK_ticket_type_change_by_id` (`change_by`),
KEY `FK_ticket_type_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `ticket_type`
--
INSERT INTO `ticket_type` (`id`, `name`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'Unclassified', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ticket_watcher`
--
CREATE TABLE IF NOT EXISTS `ticket_watcher` (
`ticket_id` bigint(20) NOT NULL,
`user_id` int(11) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
KEY `ticket_watcher_ticket_id` (`ticket_id`),
KEY `ticket_watcher_user_id` (`user_id`),
KEY `FK_ticket_watcher_create_by_id` (`create_by`),
KEY `FK_ticket_watcher_change_by_id` (`change_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `time_accounting`
--
CREATE TABLE IF NOT EXISTS `time_accounting` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) NOT NULL,
`article_id` bigint(20) DEFAULT NULL,
`time_unit` decimal(10,2) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `time_accounting_ticket_id` (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(200) NOT NULL,
`pw` varchar(64) NOT NULL,
`title` varchar(50) DEFAULT NULL,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_login` (`login`),
KEY `FK_users_create_by_id` (`create_by`),
KEY `FK_users_change_by_id` (`change_by`),
KEY `FK_users_valid_id_id` (`valid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `users`
--
INSERT INTO `users` (`id`, `login`, `pw`, `title`, `first_name`, `last_name`, `valid_id`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'root@localhost', 'roK20XGbWEsSM', NULL, 'Admin', 'OTRS', 1, '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `user_preferences`
--
CREATE TABLE IF NOT EXISTS `user_preferences` (
`user_id` int(11) NOT NULL,
`preferences_key` varchar(150) NOT NULL,
`preferences_value` longblob,
KEY `user_preferences_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `valid`
--
CREATE TABLE IF NOT EXISTS `valid` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `valid_name` (`name`),
KEY `FK_valid_create_by_id` (`create_by`),
KEY `FK_valid_change_by_id` (`change_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Daten für Tabelle `valid`
--
INSERT INTO `valid` (`id`, `name`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, 'valid', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(2, 'invalid', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1),
(3, 'invalid-temporarily', '2014-08-29 12:31:44', 1, '2014-08-29 12:31:44', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `virtual_fs`
--
CREATE TABLE IF NOT EXISTS `virtual_fs` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`filename` text NOT NULL,
`backend` varchar(60) NOT NULL,
`backend_key` varchar(160) NOT NULL,
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `virtual_fs_backend` (`backend`),
KEY `virtual_fs_filename` (`filename`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `virtual_fs_db`
--
CREATE TABLE IF NOT EXISTS `virtual_fs_db` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`filename` text NOT NULL,
`content` longblob NOT NULL,
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `virtual_fs_db_filename` (`filename`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `virtual_fs_preferences`
--
CREATE TABLE IF NOT EXISTS `virtual_fs_preferences` (
`virtual_fs_id` bigint(20) NOT NULL,
`preferences_key` varchar(150) NOT NULL,
`preferences_value` text,
KEY `virtual_fs_preferences_key_value` (`preferences_key`,`preferences_value`(150)),
KEY `virtual_fs_preferences_virtual_fs_id` (`virtual_fs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `web_upload_cache`
--
CREATE TABLE IF NOT EXISTS `web_upload_cache` (
`form_id` varchar(250) DEFAULT NULL,
`filename` varchar(250) DEFAULT NULL,
`content_id` varchar(250) DEFAULT NULL,
`content_size` varchar(30) DEFAULT NULL,
`content_type` varchar(250) DEFAULT NULL,
`content` longblob NOT NULL,
`create_time_unix` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `xml_storage`
--
CREATE TABLE IF NOT EXISTS `xml_storage` (
`xml_type` varchar(200) NOT NULL,
`xml_key` varchar(250) NOT NULL,
`xml_content_key` varchar(250) NOT NULL,
`xml_content_value` mediumtext,
KEY `xml_storage_key_type` (`xml_key`(10),`xml_type`(10)),
KEY `xml_storage_xml_content_key` (`xml_content_key`(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Constraints der exportierten Tabellen
--
--
-- Constraints der Tabelle `acl`
--
ALTER TABLE `acl`
ADD CONSTRAINT `FK_acl_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_acl_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_acl_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `article`
--
ALTER TABLE `article`
ADD CONSTRAINT `FK_article_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_article_article_sender_type_id_id` FOREIGN KEY (`article_sender_type_id`) REFERENCES `article_sender_type` (`id`),
ADD CONSTRAINT `FK_article_article_type_id_id` FOREIGN KEY (`article_type_id`) REFERENCES `article_type` (`id`),
ADD CONSTRAINT `FK_article_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_article_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_article_ticket_id_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`);
--
-- Constraints der Tabelle `article_flag`
--
ALTER TABLE `article_flag`
ADD CONSTRAINT `FK_article_flag_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_article_flag_article_id_id` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`);
--
-- Constraints der Tabelle `article_sender_type`
--
ALTER TABLE `article_sender_type`
ADD CONSTRAINT `FK_article_sender_type_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_article_sender_type_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_article_sender_type_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `article_type`
--
ALTER TABLE `article_type`
ADD CONSTRAINT `FK_article_type_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_article_type_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_article_type_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `follow_up_possible`
--
ALTER TABLE `follow_up_possible`
ADD CONSTRAINT `FK_follow_up_possible_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_follow_up_possible_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_follow_up_possible_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `groups`
--
ALTER TABLE `groups`
ADD CONSTRAINT `FK_groups_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_groups_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_groups_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `group_customer_user`
--
ALTER TABLE `group_customer_user`
ADD CONSTRAINT `FK_group_customer_user_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_group_customer_user_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_group_customer_user_group_id_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`);
--
-- Constraints der Tabelle `group_role`
--
ALTER TABLE `group_role`
ADD CONSTRAINT `FK_group_role_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_group_role_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_group_role_group_id_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
ADD CONSTRAINT `FK_group_role_role_id_id` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);
--
-- Constraints der Tabelle `group_user`
--
ALTER TABLE `group_user`
ADD CONSTRAINT `FK_group_user_user_id_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_group_user_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_group_user_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_group_user_group_id_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`);
--
-- Constraints der Tabelle `personal_queues`
--
ALTER TABLE `personal_queues`
ADD CONSTRAINT `FK_personal_queues_user_id_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_personal_queues_queue_id_id` FOREIGN KEY (`queue_id`) REFERENCES `queue` (`id`);
--
-- Constraints der Tabelle `queue`
--
ALTER TABLE `queue`
ADD CONSTRAINT `FK_queue_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_queue_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_queue_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_queue_follow_up_id_id` FOREIGN KEY (`follow_up_id`) REFERENCES `follow_up_possible` (`id`),
ADD CONSTRAINT `FK_queue_group_id_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
ADD CONSTRAINT `FK_queue_salutation_id_id` FOREIGN KEY (`salutation_id`) REFERENCES `salutation` (`id`),
ADD CONSTRAINT `FK_queue_signature_id_id` FOREIGN KEY (`signature_id`) REFERENCES `signature` (`id`),
ADD CONSTRAINT `FK_queue_system_address_id_id` FOREIGN KEY (`system_address_id`) REFERENCES `system_address` (`id`);
--
-- Constraints der Tabelle `queue_preferences`
--
ALTER TABLE `queue_preferences`
ADD CONSTRAINT `FK_queue_preferences_queue_id_id` FOREIGN KEY (`queue_id`) REFERENCES `queue` (`id`);
--
-- Constraints der Tabelle `roles`
--
ALTER TABLE `roles`
ADD CONSTRAINT `FK_roles_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_roles_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_roles_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `role_user`
--
ALTER TABLE `role_user`
ADD CONSTRAINT `FK_role_user_user_id_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_role_user_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_role_user_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `salutation`
--
ALTER TABLE `salutation`
ADD CONSTRAINT `FK_salutation_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_salutation_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_salutation_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `signature`
--
ALTER TABLE `signature`
ADD CONSTRAINT `FK_signature_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_signature_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_signature_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `system_address`
--
ALTER TABLE `system_address`
ADD CONSTRAINT `FK_system_address_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_system_address_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_system_address_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `ticket`
--
ALTER TABLE `ticket`
ADD CONSTRAINT `FK_ticket_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_ticket_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_queue_id_id` FOREIGN KEY (`queue_id`) REFERENCES `queue` (`id`),
ADD CONSTRAINT `FK_ticket_responsible_user_id_id` FOREIGN KEY (`responsible_user_id`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_service_id_id` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`),
ADD CONSTRAINT `FK_ticket_sla_id_id` FOREIGN KEY (`sla_id`) REFERENCES `sla` (`id`),
ADD CONSTRAINT `FK_ticket_ticket_lock_id_id` FOREIGN KEY (`ticket_lock_id`) REFERENCES `ticket_lock_type` (`id`),
ADD CONSTRAINT `FK_ticket_ticket_priority_id_id` FOREIGN KEY (`ticket_priority_id`) REFERENCES `ticket_priority` (`id`),
ADD CONSTRAINT `FK_ticket_ticket_state_id_id` FOREIGN KEY (`ticket_state_id`) REFERENCES `ticket_state` (`id`),
ADD CONSTRAINT `FK_ticket_type_id_id` FOREIGN KEY (`type_id`) REFERENCES `ticket_type` (`id`),
ADD CONSTRAINT `FK_ticket_user_id_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `ticket_flag`
--
ALTER TABLE `ticket_flag`
ADD CONSTRAINT `FK_ticket_flag_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_flag_ticket_id_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`);
--
-- Constraints der Tabelle `ticket_history`
--
ALTER TABLE `ticket_history`
ADD CONSTRAINT `FK_ticket_history_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_ticket_history_article_id_id` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
ADD CONSTRAINT `FK_ticket_history_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_history_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_history_history_type_id_id` FOREIGN KEY (`history_type_id`) REFERENCES `ticket_history_type` (`id`),
ADD CONSTRAINT `FK_ticket_history_owner_id_id` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_history_priority_id_id` FOREIGN KEY (`priority_id`) REFERENCES `ticket_priority` (`id`),
ADD CONSTRAINT `FK_ticket_history_queue_id_id` FOREIGN KEY (`queue_id`) REFERENCES `queue` (`id`),
ADD CONSTRAINT `FK_ticket_history_state_id_id` FOREIGN KEY (`state_id`) REFERENCES `ticket_state` (`id`),
ADD CONSTRAINT `FK_ticket_history_ticket_id_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`),
ADD CONSTRAINT `FK_ticket_history_type_id_id` FOREIGN KEY (`type_id`) REFERENCES `ticket_type` (`id`);
--
-- Constraints der Tabelle `ticket_history_type`
--
ALTER TABLE `ticket_history_type`
ADD CONSTRAINT `FK_ticket_history_type_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_ticket_history_type_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_history_type_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `ticket_index`
--
ALTER TABLE `ticket_index`
ADD CONSTRAINT `FK_ticket_index_ticket_id_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`),
ADD CONSTRAINT `FK_ticket_index_group_id_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
ADD CONSTRAINT `FK_ticket_index_queue_id_id` FOREIGN KEY (`queue_id`) REFERENCES `queue` (`id`);
--
-- Constraints der Tabelle `ticket_lock_index`
--
ALTER TABLE `ticket_lock_index`
ADD CONSTRAINT `FK_ticket_lock_index_ticket_id_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`);
--
-- Constraints der Tabelle `ticket_lock_type`
--
ALTER TABLE `ticket_lock_type`
ADD CONSTRAINT `FK_ticket_lock_type_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_ticket_lock_type_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_lock_type_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `ticket_priority`
--
ALTER TABLE `ticket_priority`
ADD CONSTRAINT `FK_ticket_priority_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_priority_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `ticket_state`
--
ALTER TABLE `ticket_state`
ADD CONSTRAINT `FK_ticket_state_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_ticket_state_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_state_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_state_type_id_id` FOREIGN KEY (`type_id`) REFERENCES `ticket_state_type` (`id`);
--
-- Constraints der Tabelle `ticket_state_type`
--
ALTER TABLE `ticket_state_type`
ADD CONSTRAINT `FK_ticket_state_type_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_state_type_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `ticket_type`
--
ALTER TABLE `ticket_type`
ADD CONSTRAINT `FK_ticket_type_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_ticket_type_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_type_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `ticket_watcher`
--
ALTER TABLE `ticket_watcher`
ADD CONSTRAINT `FK_ticket_watcher_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_watcher_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_ticket_watcher_ticket_id_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`),
ADD CONSTRAINT `FK_ticket_watcher_user_id_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `users`
--
ALTER TABLE `users`
ADD CONSTRAINT `FK_users_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`),
ADD CONSTRAINT `FK_users_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_users_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `user_preferences`
--
ALTER TABLE `user_preferences`
ADD CONSTRAINT `FK_user_preferences_user_id_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `valid`
--
ALTER TABLE `valid`
ADD CONSTRAINT `FK_valid_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_valid_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Zuugriff auf den insaller.pl geht übrigens erst nach einem Neustart der Maschine. Hab noch nicht genau herausgefunden, welche Dienste ich in stoppen und starten muss.
Nachdem sich jetzt 20 Minuten lang nichts getan hat und der Export sich nicht ändert, starte ich die Maschine nochmal durch.
Tja und nach dem Neustart heißt es dann:
CREATE DATABASE `otrs`
Can't create database 'otrs'; database exists
und ein Button: Zurück
Das bringt mich wieder zum Test der Datenbankverbindung.
Also lösche ich die DB mit phpMyAdmin wieder und vergebe dieses Mal das Passwort für den Benutzer, welches auch schon in der vorherigen Version (OTRS Yast) angelegt wurde und auch funktioniert hat.
Aber gleiches Ergebnis:
Code: Select all
-- Constraints der Tabelle `user_preferences`
--
ALTER TABLE `user_preferences`
ADD CONSTRAINT `FK_user_preferences_user_id_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
--
-- Constraints der Tabelle `valid`
--
ALTER TABLE `valid`
ADD CONSTRAINT `FK_valid_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FK_valid_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Ich hol jetzt ein Image zurück, das die Yast Version drauf hat und fange nochmal von vorne an. Diesmal mit den Tars. Für die OpenSuse scheint weder der Download für die 10er noch für die 11er zu funktionieren.
Mal schsuen, was die tars sagen.
Gruß Markus
Re: update von 3.2.16 auf 3.3.8
OK, neuer Versuch,
diesmal wieder mit einem Vanilla Image, einfach nur Apache, Maria DB und php, nicht viel mehr in der Grundkonfiguration. Nach der Installation folgende Schritte durchgeführt:
mysql_secure_installation durchführen, Datenbank Passwort für root gesetzt.
In die /etc/sysconfig/apache2 php5 in die Apache_Modules eingefügt, apache Neustart
Dann noch schnell den phpMyAdmin konfiguriert und in die Datenbank geschaut:
Geleiches Ergebnis, das Script hängt wieder fest.
Diesmal wurden die rpms installiert, Abhängikeiten gelöst, die bei der Installation des rpms mit: rpm -Uvh otrs-x.x.x.-01.rpm aufgetauscht sind.
Danach ließ sich das rpm einwandfrei installieren.
Aber wie gesagt, das Ergbnis ist, die Kiste hängt wieder.
Also teste ich gleich noch die Installation mit der Mysql Datenbank drauf.
Da ist das Problem, dass der mysql Service erst einmal angestartet werden muss, damit er in den Diensten im Yast erscheint und konfiguriert werden kann.
DAnn die rpms installiert, und irgendwie, jetzt läufts. Keine Ahnung warum.
diesmal wieder mit einem Vanilla Image, einfach nur Apache, Maria DB und php, nicht viel mehr in der Grundkonfiguration. Nach der Installation folgende Schritte durchgeführt:
mysql_secure_installation durchführen, Datenbank Passwort für root gesetzt.
In die /etc/sysconfig/apache2 php5 in die Apache_Modules eingefügt, apache Neustart
Dann noch schnell den phpMyAdmin konfiguriert und in die Datenbank geschaut:
Geleiches Ergebnis, das Script hängt wieder fest.
Diesmal wurden die rpms installiert, Abhängikeiten gelöst, die bei der Installation des rpms mit: rpm -Uvh otrs-x.x.x.-01.rpm aufgetauscht sind.
Danach ließ sich das rpm einwandfrei installieren.
Aber wie gesagt, das Ergbnis ist, die Kiste hängt wieder.
Also teste ich gleich noch die Installation mit der Mysql Datenbank drauf.
Da ist das Problem, dass der mysql Service erst einmal angestartet werden muss, damit er in den Diensten im Yast erscheint und konfiguriert werden kann.
DAnn die rpms installiert, und irgendwie, jetzt läufts. Keine Ahnung warum.