Venue ID API: Database Tables: activity_log

Purpose

A log of all changes to the database.

Columns

uid Primary key
action_ts Time and date of event
ip_address IP address of client
user Email address of user who has initiated the event
action Number representing method used (see below)
status Result: 0 is failure, 1 is success
error_code Error code if action failed
affected_venue_id Affected venue ID (if known/applicable)
affected_user Affected user (if known/applicable)
details Additional details

Actions

101 venues/new
102 venues/modify
103 venues/update
104 venues/list_updates
105 venues/get_updates
106 venues/list_pending
107 venues/approve
108 venues/delete
109 venues/get
110 venues/get_pending
111 venues/get_coords
112 venues/search
201 users/new
202 users/modify
203 users/modify_self
204 users/list_pending
205 users/approve
206 users/delete
207 users/get
208 users/get_pending
301 admin/activity