How messages work

The subject line is not always like a real subject line
I'm going to make sure that we can actually use the correct subject values as the special codes
Currently the following subjects are used:
EVENTS: stores the name of the event as the msgAttach and the text as msgText
EVENTSDATE: stores a date for the event in the text
EVENTSTIME: stores a time for the event in the text
EVENTSLOCATION: stores a location for the event in the text
VOTE: general vote for something
VOTEYEA: a yes vote for something
VOTENAY: a no vote for something
PM: a private message
POST: a post to a group or to the public
COMMENT: a comment on a specific post
PAD: a classified ad shown to the public
AD: a classified ad shown to the condo associates only
ADMINNOTICE: ADMIN MEETING, posted by building admin to building
ADMINAGENDA: ADMIN MEETING AGENDA, posted by building admin to building
ADMINMINUTES: ADMIN MEETING MINUTES, posted by building admin to building

YOU NEED TO CREATE A PUBLIC ENTITY WITH EID=-1 FOR MESSAGES TO WORK CORRECTLY OR RERUN THE SQL TABLE