CREATE TABLE IF NOT EXISTS `event_defaults` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `header_image` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `content` text,
  `offset` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ALTER TABLE `sites` ADD IF NOT EXISTS `facebook_app_id` VARCHAR( 255 ) NOT NULL AFTER `registration_page_id`;
ALTER TABLE `sites` ADD IF NOT EXISTS `facebook_app_secret` VARCHAR( 255 ) NOT NULL AFTER `facebook_app_id`;
