-- 9801 to 9820
-- main
ALTER TABLE  `Account` ADD  `active` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT  'n', ADD  `newsletter` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT  'n';
ALTER TABLE  `Profile` ADD  `profile_complete` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT  'n', DROP `birth_date`, DROP `birth_city`, DROP `favorite_books`, DROP `favorite_movies`, DROP `favorite_sports`, DROP `favorite_musics`, DROP `favorite_foods`;
ALTER TABLE  `To_Approved` ADD  `date` DATETIME NOT NULL, ADD  `reviewer_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `rate` , ADD  `review_content` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `reviewer_name` ;

CREATE TABLE IF NOT EXISTS `Account_Activation` (`account_id` int(11) NOT NULL DEFAULT '0', `unique_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `entered` date NOT NULL DEFAULT '0000-00-00', KEY `account_id` (`account_id`), KEY `unique_key` (`unique_key`), KEY `entered` (`entered`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `Control_Export_MailApp` (
  `domain_id` int(11) NOT NULL,
  `scheduled` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `running` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `last_run_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_exportlog` int(11) NOT NULL,
  PRIMARY KEY (`domain_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
