1024537 - Event Platfrom update: Add event contact/email field

Status: RESOLVED FIXED

(Webmaker Graveyard :: Events, defect)

Description

[Lucy Harris [:lucyeoh]]

Giving organizers a field to insert a contact email/phone number so people can contact them for more information, directions etc. will make it easier for people to attend events they learn about solely from the events platform. 

Note: we probably should not make a contact phone number mandatory for privacy reasons but I think it might be alright to require a contact email? Even if people just had the option to list a contact email I think would make events more accessible.

Comment 1

[Gavin Suntop [:gvn]]

I'd propose adding a checkbox to opt in to making your email address public when creating or editing an event.

Comment 2

[Gavin Suntop [:gvn]]

Attachment: https://github.com/mozilla/webmaker-events-service/pull/49

Note: We'll need to make a schema change. Just let me know what you need for that...

Comment 3

[Gavin Suntop [:gvn]]

Attachment: https://github.com/mozilla/webmaker-events-2/pull/120

Comment 4

[Jon Buckley [:jbuck]]

Comment on attachment 8450647 [details] [review]
https://github.com/mozilla/webmaker-events-service/pull/49

r+, but add an sql migration file to the migrations folder, like https://github.com/mozilla/webmaker-events-service/blob/master/migrations/20140624-add-mentor.bio.sql (it'll be a different column type though)

Comment 5

[Gavin Suntop [:gvn]]

Ok, added the migration:

https://github.com/mozilla/webmaker-events-service/blob/master/migrations/20140707-add-is-email-public.sql

Jbuck, can you run it?

Comment 6

[Jon Buckley [:jbuck]]

Migration run:

CREATE TABLE `Events` (
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `address` varchar(255) DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  `longitude` float DEFAULT NULL,
  `attendees` int(11) DEFAULT NULL,
  `beginDate` datetime DEFAULT NULL,
  `endDate` datetime DEFAULT NULL,
  `beginTime` datetime DEFAULT NULL,
  `endTime` datetime DEFAULT NULL,
  `registerLink` varchar(255) DEFAULT NULL,
  `picture` varchar(255) DEFAULT NULL,
  `organizer` varchar(255) DEFAULT NULL,
  `organizerId` varchar(255) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `city` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `ageGroup` varchar(255) DEFAULT NULL,
  `skillLevel` varchar(255) DEFAULT NULL,
  `areAttendeesPublic` tinyint(1) NOT NULL DEFAULT '0',
  `isEmailPublic` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3667 DEFAULT CHARSET=utf8;