Difference between revisions of "Table llx events"

Latest revision as of 22:58, 7 January 2013

The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

Contains saved security events (readable by admin users on menu system tools - audit)

Contient les évènements sauvegardés d'audit de sécurité (consultable par les utilisateurs administrateurs dans le menu outils system - audit)

Contiene los eventos de seguridad (consultables por los usuarios administradores en el menú utilidades sistema - auditoría)

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
tms	timestamp	NO		Current date		Date of last modification. See page Field Tms.
type	varchar(32)	NO				type of event (list of supported events are found in the trigger htdocs/core/triggers/interface_all_Logevents.class.php)
entity	int(11)	NO		1		multi company id
dateevent	datetime	YES	MUL	NULL		date of event
fk_user	int(11)	YES		NULL		ID user (llx_user->rowid)
description	varchar(250)	NO				full description of event
ip	varchar(32)	NO				ip of user
user_agent	varchar(128)	YES		NULL		user agent
fk_object	int(11)	YES		NULL		ID of object (any table_of_related_object->rowid)

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
idx_events_dateevent	MULTIPLE	dateevent

@@ Line 1: / Line 1: @@
 [[Category:Table SQL]]
-[[Category:AgendaEn]]
-[[Category:Agenda]]
-[[Category:AgendaEs]]
 {{ListOfTables}}
 = Content/Contenu/Contenido =
-{{flag en}} Contains the triggers events
+{{flag en}} Contains saved security events (readable by admin users on menu ''system tools - audit'')
-{{flag fr}} Contient les évènements des triggers
+{{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 los triggers
+{{flag sp}} Contiene los eventos de seguridad (consultables por los usuarios administradores en el menú ''utilidades sistema - auditoría'')
 = 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>Type</b>
@@ Line 25: / Line 23: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
-|-
+{{FieldTms}}
-| tms
-| timestamp
-| NO
-|
-| CURRENT_TIMESTAMP
-|
-| last update date
 |-
 | type
@@ Line 45: / 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
 | int(11)
-| &nbsp;
+| NO
 |
 | 1
@@ Line 58: / Line 49: @@
 | datetime
 | YES
-|
+| MUL
 | NULL
 |
@@ Line 85: / Line 76: @@
 |
 |
-| ip
+| ip of user
+|-
+| user_agent
+| varchar(128)
+| YES
+|
+| NULL
+|
+| user agent
 |-
 | fk_object
@@ Line 94: / Line 93: @@
 |
 | ID of object (any table_of_related_object->rowid)
-|}
+|}&nbsp;
+== 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
+|}&nbsp;