[misterhouse-users] Common Event log database

[Jason S. <jas...@sh...>]

A while back someone was asking for sample data of sensors in my home (no 
I didnt forget your request, just thought it would be better to store it 
in a db instead of my flatfiles.), coupled with the introduction of the 
DBI object in the latest release of MH, led me to create an Event log 
table.  (all of my new Base_Item objects log to this table now).

I am by no means attached to the field definitions and was wondering if 
someone else had some better ideas for table structure / field names, and 
if we should standardize such a thing.

The format I am currently using:

# Host: localhost    Database: mh
#--------------------------------------------------------
#
# Table structure for table 'Events'
#

CREATE TABLE Events (
  ID bigint(20) NOT NULL auto_increment,
  Time timestamp(14) NOT NULL,
  Object varchar(100) default '',
  ObjectType varchar(100) default '',
  State varchar(100) default '',
  Substate varchar(100) default '',
  Setby varchar(100) default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data for table 'Events'
#

INSERT INTO Events VALUES (10,20030830183604,'$m_hall','Motion_Item','on','','$sg_hall_motion');