INSERT INTO `mm_EventSubtype` (`id`, `typeId`, `title`, `sorter`) VALUES
('treeTrimming', 'workshop', 'Tree Trimming', 2350);

-- -----------------
-- -----------------

CREATE TABLE `mm_EventRegistrationType` (
  `id` char(16) NOT NULL,
  `title` varchar(32) NOT NULL,
  `sorter` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `mm_EventRegistrationType` (`id`, `title`, `sorter`) VALUES
('all', 'All', 0),
('members', 'Members Only', 1);


ALTER TABLE `mm_EventRegistrationType`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sorter` (`sorter`);

-- -----------------
-- -----------------

ALTER TABLE `mm_Event` ADD `allowedAttendeeType` VARCHAR(16) NULL AFTER `description`;

UPDATE `mm_Event` SET `allowedAttendeeType` = 'all' WHERE `mm_Event`.`type` = 'workshop';