GlpiHistory » History » Version 2

moyo, 05/01/2008 06:44 PM

1 1 moyo
=== Etat Actuel ===
2 1 moyo
3 1 moyo
4 1 moyo
Table glpi_history
5 1 moyo
6 1 moyo
  - Common fields 
7 1 moyo
    - FK_glpi_device : item ID
8 1 moyo
    - device_type : device type ID
9 1 moyo
    - user_name : name of the user who made the update
10 1 moyo
    - date_mod : update date
11 1 moyo
  - Specific fields
12 1 moyo
    - device_internal_type : device type for device history
13 1 moyo
    - id_search_option : ID in search option array
14 1 moyo
    - old_value : old value 
15 1 moyo
    - new_value : new value
16 2 moyo
    - linked_action : action type 
17 2 moyo
18 2 moyo
||'''linked action'''         || '''Desc'''            ||'''device_internal_type'''||'''id_search_option'''||'''old_value'''      ||'''new_value'''      ||
19 2 moyo
||                            || item field update     ||                          ||  id_searcj_option    ||  old_value          || new value           ||
20 2 moyo
||HISTORY_ADD_DEVICE          || Intern dev add        || device type              ||                      ||                     || new value           ||
21 2 moyo
||HISTORY_UPDATE_DEVICE       ||Inter dev update specif|| device type              ||                      || old value           || new value           ||
22 2 moyo
||HISTORY_DELETE_DEVICE       ||Intern dev delete      || device type              ||                      || old value           ||                     ||
23 2 moyo
||HISTORY_INSTALL_SOFTWARE    ||Install software       ||                          ||                      ||                     || soft/comp name/vers ||
24 2 moyo
||HISTORY_UNINSTALL_SOFTWARE  ||  Uninstall soft       ||                          ||                      || soft/comp name/vers ||                     ||
25 2 moyo
||HISTORY_DISCONNECT_DEVICE   ||Direct/Port disconnect ||                          ||                      ||item name/serial     ||                     ||
26 2 moyo
||HISTORY_CONNECT_DEVICE      ||Direct/Port connect    ||                          ||                      ||                     ||item name/serial     ||
27 2 moyo
||HISTORY_DELETE_ITEM         ||Item deleted           ||                          ||                      ||                     ||                     ||
28 2 moyo
||HISTORY_RESTORE_ITEM        ||Item restored          ||                          ||                      ||                     ||                     ||
29 2 moyo
|| '''Not used in CORE'''     ||                       ||                          ||                      ||                     ||                     ||
30 2 moyo
||HISTORY_LOG_SIMPLE_MESSAGE  ||Simple message         ||                          ||                      ||                     ||                     ||
31 2 moyo
||HISTORY_OCS_IMPORT          ||OCS import             ||                          ||                      ||                     ||                     ||
32 2 moyo
||HISTORY_OCS_DELETE          ||OCS deletion           ||                          ||                      ||                     ||                     ||
33 2 moyo
||HISTORY_OCS_IDCHANGED       || OCS ID change         ||                          ||                      ||                     ||                     ||
34 2 moyo
||HISTORY_OCS_LINK            || OCS link              ||                          ||                      ||                     ||                     ||
35 2 moyo
36 1 moyo
37 1 moyo
38 1 moyo
39 1 moyo