CREATE TABLE `pcc_events_organization` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `address` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `primary_contact` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `phone` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `website` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci NOT NULL,
  `notes` text collate utf8_unicode_ci NOT NULL,
  `published` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'yes',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `pcc_events_shifts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `volunteer_id` int(10) unsigned NOT NULL default '0',
  `event_id` int(10) unsigned NOT NULL default '0',
  `shift_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `shift_end_time`  datetime NOT NULL default '0000-00-00 00:00:00',
  `approved` enum('yes', 'no') collate utf8_unicode_ci NOT NULL default 'no',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE  `pcc_events_event_shifts` (
 `event_id` INT UNSIGNED NOT NULL ,
 `shift_id` INT UNSIGNED NOT NULL ,
PRIMARY KEY (  `event_id` ,  `shift_id` )
) ENGINE = MYISAM ;

CREATE TABLE `pcc_events_events` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `organization_id` int(10) unsigned NOT NULL default '0',
  `address` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `event_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `event_end_time`  datetime NOT NULL default '0000-00-00 00:00:00',
  `num_children` tinyint(3) unsigned NOT NULL default '0',
  `event_type` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `space_desc` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `notes` text collate utf8_unicode_ci NOT NULL,
  `published` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'yes',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;