28,936
edits
Changes
no edit summary
Line 8:
Line 8:
|-+| tms
−| timestamp
−| NO
−|
−| CURRENT_TIMESTAMP
−|
−| last update date
+
{{flag fr}} Contient les évènements sauvegardés d'audit de sécurité (consultable par les utilisateurs administrateurs dans le menu ''outils system - audit'')
{{flag fr}} Contient les évènements sauvegardés d'audit de sécurité (consultable par les utilisateurs administrateurs dans le menu ''outils system - audit'')
−{{flag sp}} Contiene los eventos de seguridad (consultables por los usuarios administradores en el menú ''utilidades del sistema - auditoría'')
+{{flag sp}} Contiene los eventos de seguridad (consultables por los usuarios administradores en el menú ''utilidades sistema - auditoría'')
= Structure =
= Structure =
−{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
+== Table ==
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| <b>Field</b>
|style="background-color: #e9e9ef"| <b>Field</b>
|style="background-color: #e9e9ef"| <b>Type</b>
|style="background-color: #e9e9ef"| <b>Type</b>
Line 22:
Line 23:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
−{{FieldTms}}
−|-
|-
| type
| type
Line 42:
Line 36:
|
|
|
|
−| type of event
+| type of event (list of supported events are found in the trigger htdocs/core/triggers/interface_all_Logevents.class.php)
|-
|-
| entity
| entity
| int(11)
| int(11)
−|
+| NO
|
|
| 1
| 1
Line 55:
Line 49:
| datetime
| datetime
| YES
| YES
−|
+| MUL
| NULL
| NULL
|
|
Line 82:
Line 76:
|
|
|
|
−| ip
+| ip of user
+|-
+| user_agent
+| varchar(128)
+| YES
+|
+| NULL
+|
+| user agent
|-
|-
| fk_object
| fk_object
Line 91:
Line 93:
|
|
| ID of object (any table_of_related_object->rowid)
| ID of object (any table_of_related_object->rowid)
−|}
+|}
+== Keys ==
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|-
+| idx_events_dateevent
+| MULTIPLE
+| dateevent
+|}