Table admin activity log

• Introduction
• Resources | Standards

• Database
• Schema

• Developers API
• Resources | Overrides |
• Tutorials

• Modules
• Overview | Payment |
• Shipping | Order Total

• Miscellaneous
• Security | XML Schemas |
• Porting modules from osC | Manually entering products

Database Version

1.3.5

Description

Stores every page access in the admin area. Can be used to identify security breaches, unauthorized access or even mistakes that other admins are making.

Its primary purpose for being created was to comply with Credit Card companies' terms of service requiring that activity related to anyone accessing customer payment records be tracked in case an audit were ever required.

Table Details

Primary Key

log_id

Indexed Fields

page_accessed

access_date

ip_address

Columns

log_id

A unique, auto incremented value, to identify each admin activity log record.

Type:	int(15)
Null:	No
Default:
Extra:	auto_increment

access_date

The date and time that the specific admin activity log record was made.

Type:	datetime
Null:	No
Default:	0001-01-01 00:00:00

admin_id

The admin id of the administrator that the specific admin activity log record is from. Foreign key to admin.admin_id.

Type:	int(11)
Null:	No
Default:	0

page_accessed

The php file name that was accessed in the admin area for the given admin activity log record.

Type:	varchar(80)
Null:	No
Default:

page_parameters

The querystring parameters of the URL in the admin area for the given admin activity log record.

Type:	varchar(150)
Null:	Yes
Default:	NULL

ip_address

The ip address of the computer accessing the specific page in the admin for the given admin activity log record.

Type:	varchar(15)
Null:	No
Default:

Default Entries

None.