Api: Admin communication system

[daleighan]

This will be a part on user profiles that allows for the tracking of e-mail and text communications. It should also allow the resending of communications. There will also be a web branch for this. What it will need: 1) A new user_coms table 2) Store all outgoing texts/emails in this table 3) An interface that shows the history of emails sent out to a user and allows sending them again. It may eventually have various ways of sorting users 4) An interface that shows a text messaging thread with the user

[daleighan]

create table user_communications (
  id int(11) NOT NULL AUTO_INCREMENT,
  user_id int(11) NOT NULL,
  creator_id int(11),
  type enum('sms', 'email') NOT NULL,
  content text NOT NULL,
  created_at datetime NOT NULL,
  updated_at datetime NOT NULL,
  deleted_at datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
);
alter table cars add column airtable_data text default null after comments;