The following is an example of some actions that might be stored in an actions table

acct	qualifier	event	gg	zone	command	comment
1001	1	422	NULL	NULL	/usr/local/bin/alarms/accesspermited	Access Permited / Door Unlocked
9887	1	NULL	NULL	NULL	/usr/local/bin/alarms/9887/defaultcmd	Default Trip command
9887	1	402	NULL	NULL	/usr/local/bin/alarms/9887/disarmed	Disarmed System
9887	3	402	NULL	NULL	/usr/local/bin/alarms/9887/armed	Armed System
9887	1	406	NULL	NULL	/usr/local/bin/alarms/9887/disarmed	Canceled Alarm / System Disarmed
9887	1	412	NULL	NULL	/usr/local/bin/alarms/9887/logonly	Panel Remote Access
6516	1	NULL	NULL	NULL	/usr/local/bin/alarms/default	Default Trip command
6516	3	NULL	NULL	NULL	/usr/local/bin/alarms/default	Default Restore or Closing
6516	6	NULL	NULL	NULL	/usr/local/bin/alarms/default	Default Condition still present
6516	1	110	NULL	NULL	/usr/local/bin/alarms/6516/firetrip	Fire Alarm
6516	1	301	NULL	NULL	/usr/local/bin/alarms/page116	AC Power Failure
6516	1	354	NULL	NULL	/usr/local/bin/alarms/tivocmd	Failure to communicate event
6516	1	370	1	12	/usr/local/bin/alarms/6516/dooropen	Back Door Open
6516	1	370	1	22	/usr/local/bin/alarms/6516/dooropen	Front Door Open
6516	3	402	NULL	NULL	/usr/local/bin/alarms/openclose	Open/Close
6516	1	412	NULL	NULL	/usr/local/bin/alarms/tivocmd	Successful download/access
6516	1	422	NULL	NULL	/usr/local/bin/alarms/accesspermited	Access Permited / Door Unlocked
6516	1	602	0	0	/usr/local/bin/alarms/tivoalarm	Periodic Test
2829	1	NULL	NULL	NULL	/usr/local/bin/alarms/2829/defaultcmd	Default Trip / Open command
2829	3	NULL	NULL	NULL	/usr/local/bin/alarms/2829/defaultcmd	Default Restore / Close command
2829	6	NULL	NULL	NULL	/usr/local/bin/alarms/2829/defaultcmd	Default persistant command
2829	1	132	NULL	NULL	/usr/local/bin/alarms/2829/page202	Default BURG (type 132) trip command
2829	1	402	NULL	NULL	/usr/local/bin/alarms/2829/opening	Default Opening Command
2829	3	402	NULL	NULL	/usr/local/bin/alarms/2829/closing	Default Closing Command

Schema one might use for such a table:


CREATE TABLE actions (
  acct int(5) NOT NULL default '0',
  qualifier int(1) NOT NULL default '0',
  event int(3) default NULL,
  gg int(2) default NULL,
  zone int(3) default NULL,
  command varchar(254) NOT NULL default '/usr/local/bin/alarms/defaultcmd',
  comment varchar(254) NOT NULL default ''
) TYPE=MyISAM;