Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
kunden:zollner [2013/11/13 10:34] stefan.barth |
— (aktuell) | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
- | ^ ^ Prodsystem ^^^^^^^^^^^^^ ^ Testsystem ^^^^^^^^^^^^^ ^ | ||
- | ^ ::: ^ T!M ||||||||||^ Version | [[software:tim:changelog:tim35|v3.5]] ^ ::: ^ T!M ||||||||||^ Version | [[software:tim:changelog:tim36|v3.6]] ^ ::: | | ||
- | ^ ::: ^ Pfad | F:\tim |||||||||||^ ::: ^Pfad | E:\Tim |||||||||||^ ::: | | ||
- | ^ ::: ^ Mandant | bmwm |||||||||||^ ::: ^ Mandant | Testmandant |||||||||||^ ::: | | ||
- | ^ ::: ^ Username | tim.support |||||||||||^ ::: ^ Username | tim.support |||||||||||^ ::: | | ||
- | ^ ::: ^ Passwort | task!nmotion |||||||||||^ ::: ^Passwort | task!nmotion |||||||||||^ ::: | | ||
- | ^ ::: ^ Hostname | zznt171v |||||||||^ Port| 8080 ^ ::: ^Hostname | zznt136v.intern.zollner.de |||||||||^ Port| 8383 ^ ::: | | ||
- | ^ ::: ^ Besonderheiten | |||||||||||^ ::: ^Besonderheiten | |||||||||||^ ::: | | ||
- | ^ ::: ^ ::: | TEXT |||||||||||^ ::: ^ ::: | TEXT |||||||||||^ ::: | | ||
- | ^ ::: ^ Datenbank ^^^^^^^^^^^^^ ::: ^ Datenbank ^^^^^^^^^^^^^ ::: | | ||
- | ^ ::: ^ Username | root|||||||||||^ ::: ^Username | root|||||||||||^ ::: | | ||
- | ^ ::: ^ Passwort | t1m |||||||||||^ ::: ^Passwort | root |||||||||||^ ::: | | ||
- | ^ ::: ^ Datenbankname | tim |||||||||||^ ::: ^ Datenbankname | tim|||||||||||^ ::: | | ||
- | ^ ::: ^ Besonderheiten | Stringvalue von "variableinstance" muss varchar(4000) sein! |||||||||||^ ::: ^Besonderheiten | Stringvalue von "variableinstance" muss varchar(4000) sein!|||||||||||^ ::: | | ||
- | ^ ::: ^ Besonderheiten | view_instance wurde angepasst, siehe unten |||||||||||^ ::: ^Besonderheiten | |||||||||||^ ::: | | ||
- | ^ ::: ^ Archivationhandler| domain=zollner_de;username=1tim;password=Task!nmotion;endpoint=http://server64/pam4/Pam4SecureWS.asmxwsdl; |||||||||||^^||||||||||||^ ::: | | ||
- | ^ ::: ^ Kontrolle (Client) | http://server64/pam4 | Username |||||||^ 1tim | password ^ Task!nmotion ||||||||||||||^ ::: | | ||
- | ^ ::: ^ Mailserver ^^^^^^^^^^^^^ ::: ^ Mailserver ^^^^^^^^^^^^^ ::: | | ||
- | ^ ::: ^ Hostname | HIER |||||||^ Port | HIER ^ SSL | HIER ^ ::: ^Hostname | HIER |||||||^ Port | HIER ^ SSL | HIER ^ ::: | | ||
- | ^ ::: ^ Username | HIER |||||||||||^ ::: ^Username | |||||||||||^ ::: | | ||
- | ^ ::: ^ Passwort | HIER |||||||||||^ ::: ^Passwort | |||||||||||^ ::: | | ||
- | ^ ::: ^ Besonderheiten | HIER |||||||||||^ ::: ^Besonderheiten | HIER |||||||||||^ ::: | | ||
- | ^ ::: ^ ::: | TEXT |||||||||||^ ::: ^ ::: | TEXT |||||||||||^ ::: | | ||
- | ^ ::: ^ LDAP ^^^^^^^^^^^^^ ::: ^ LDAP ^^^^^^^^^^^^^ ::: | | ||
- | ^ ::: ^ Hostname | HIER |||||||||^ Port| HIER ^ ::: | Hostname | HIER |||||||||^ Port| HIER ^ ::: | | ||
- | ^ ::: ^ Username | HIER |||||||||||^ ::: ^Username | HIER |||||||||||^ ::: | | ||
- | ^ ::: ^ Passwort | HIER |||||||||||^ ::: ^ Passwort | HIER |||||||||||^ ::: | | ||
- | ^ ::: ^ Authentifizierungsart | HIER |||||||||||^ ::: ^ Authentifizierungsart | HIER |||||||||||^ ::: | | ||
- | |||
- | ^ Hardware ^^^^ | ||
- | ^ ^ Prodsystem ^ ^ Testsystem ^ | ||
- | ^CPU|Intel Xeon x7560 2,27 Ghz ^ ::: | Intel(R) Xeon(R) X7560 2,27 GHz | | ||
- | ^RAM|4,00 GB ^ ::: | 6,00 GB | | ||
- | ^Festplatte|Vorhanden: 40 GB , Frei: 13 GB ^ ::: | Vorhanden: 5 GB , Frei: 3,88 GB | | ||
- | ^Betriebsystem|Windows 2008 R2 Standard x64 ^ ::: | Windows Server 2008 Standard x64 | | ||
- | |||
- | <code sql> | ||
- | DROP VIEW IF EXISTS `view_instance`; | ||
- | CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_instance` AS select `pi`.`ID_` AS `id`, | ||
- | `pi`.`NAME_` AS `name`, | ||
- | `pd`.`NAME_` AS `definitionName`, | ||
- | `pi`.`CLIENT_` AS `clientId`, | ||
- | `pi`.`CREATION_TIME_` AS `creationTime`, | ||
- | `pi`.`KEY_` AS `key`, | ||
- | `pi`.`CREATION_USER_` AS `creationUserId`, | ||
- | `pi`.`PROCESSDEFINITION_` AS `definitionId`, | ||
- | `pi`.`DESCRIPTION_` AS `instanceDescription`, | ||
- | `pi`.`CREATION_GROUP_` AS `creationGroup`, | ||
- | `pi`.`END_` AS `end`, | ||
- | `pi`.`ARCHIV_` AS `archiv`, | ||
- | `pi`.`ARCHIVATIONUSER_ID_` AS `archivationUserID`, | ||
- | `pi`.`PARENT_FOLDER_` AS `parentFolderID`, | ||
- | `pi`.`ROOTTOKEN_` AS `rootToken`, | ||
- | `pi`.`SUPERPROCESSTOKEN_` AS `parentProcessToken`, | ||
- | `pi`.`NEXT_ESCALATIONTIME_` AS `nextEscalationTime`, | ||
- | `pi`.`processVariableIndex_ID_` AS `processVariableIndexId`, | ||
- | `pvi`.`field1` AS `index1`, | ||
- | `pvi`.`value1` AS `value1`, | ||
- | `pvi`.`field2` AS `index2`, | ||
- | `pvi`.`value2` AS `value2`, | ||
- | `pvi`.`field3` AS `index3`, | ||
- | `pvi`.`value3` AS `value3`, | ||
- | `pvi`.`field4` AS `index4`, | ||
- | `pvi`.`value4` AS `value4`, | ||
- | `pvi`.`field5` AS `index5`, | ||
- | `pvi`.`value5` AS `value5`, | ||
- | `pvi`.`field6` AS `index6`, | ||
- | `pvi`.`value6` AS `value6`, | ||
- | `pvi`.`field7` AS `index7`, | ||
- | `pvi`.`value7` AS `value7`, | ||
- | `pvi`.`field8` AS `index8`, | ||
- | `pvi`.`value8` AS `value8`, | ||
- | `pvi`.`field9` AS `index9`, | ||
- | `pvi`.`value9` AS `value9`, | ||
- | `pvi`.`field10` AS `index10`, | ||
- | `pvi`.`value10` AS `value10` from ((`loom_processinstance` `pi` join `loom_processvariableindex` `pvi` on((`pi`.`processVariableIndex_ID_` = `pvi`.`ID_`))) join `loom_processdefinition` `pd` on((`pi`.`PROCESSDEFINITION_` = `pd`.`ID_`))) where ((`pi`.`ARCHIVATIONUSER_ID_` <> 1022) and isnull(`pi`.`SUPERPROCESSTOKEN_`)); | ||
- | </code> |