-- 9801 to 9820

--domain

ALTER TABLE  `Email_Notification` DROP  `about`;
ALTER TABLE  `Event` ADD  `custom_id` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ;
ALTER TABLE  `ImportTemporary` ADD  `listing_seo_title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL AFTER  `listing_title`, ADD  `listing_seo_description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL AFTER  `listing_long_description`, ADD  `custom_id` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL AFTER  `listing_template` ;
ALTER TABLE  `ImportTemporary_Event` ADD  `event_seo_title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL AFTER  `event_title`, ADD  `event_seo_description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL AFTER  `event_long_description`, ADD  `custom_id` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL AFTER  `event_category_5` ;
ALTER TABLE  `Listing` ADD  `custom_id` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ;

CREATE TABLE IF NOT EXISTS `MailAppList` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `module` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(1) DEFAULT NULL COMMENT 'P=Pending, F=Finished, R=Running, E=Error',
  `filename` varchar(100) DEFAULT NULL,
  `categories` text,
  `progress` int(11) DEFAULT NULL,
  `total_item_exported` int(11) NOT NULL DEFAULT '0',
  `last_account_exported` int(11) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_unicode_ci;

CREATE TABLE  IF NOT EXISTS `MailApp_Subscribers` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`account_id` INT( 11 ) NOT NULL ,
`subscriber_name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`subscriber_email` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`subscriber_type` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`list_id` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;

INSERT INTO  `Content` (`id`, `updated`, `type`, `title`, `description`, `keywords`, `url`, `section`, `content`, `sitemap`) VALUES (NULL ,  '0000-00-00 00:00:00',  'Add Profile Welcome Page',  'Welcome!',  '',  '',  '',  'general',  '<p>An email has been sent to you with the link to activate your account.</p><p>Please, activate your account before continue.</p><p>&nbsp;</p><p>If you have any questions, please do not hesitate to <a href="../contactus.php">contact us</a>.</p>',  '1');
INSERT INTO  `Email_Notification` (`id` , `email` , `days` , `deactivate` , `updated` , `bcc` , `subject` , `content_type` , `body` , `use_variables` ) VALUES ('39',  'Account Activation',  '0',  '0',  '0000-00-00 00:00:00', NULL ,  '[EDIRECTORY_TITLE] Account Activation',  'text/plain',  'Dear ACCOUNT_NAME,\r\n\r\nTo activate your account, please click on the link below.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nFor further assistance please contact SITEMGR_EMAIL.\r\n\r\nRegards\r\n\r\nEDIRECTORY_TITLE Team',  'ACCOUNT_NAME,LINK_ACTIVATE_ACCOUNT,SITEMGR_EMAIL,EDIRECTORY_TITLE');
INSERT INTO  `Email_Notification_Default` (`id` , `subject` , `body_text` , `body_html`) VALUES ('39',  '[EDIRECTORY_TITLE] Account Activation',  'Dear ACCOUNT_NAME,\r\n\r\nTo activate your account, please click on the link below.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nFor further assistance please contact SITEMGR_EMAIL.\r\n\r\nRegards\r\n\r\nEDIRECTORY_TITLE Team',  '<html>\r\n<head>\r\n<style type="text/css">\r\n.default_text_settings {\r\nfont-family: Verdana, Arial, Helvetica, sans-serif;\r\nfont-size: 8pt;\r\ncolor: #003365;\r\nmargin: 0;\r\npadding: 5px;\r\nbackground: #FBFBFB;\r\nborder: 1px solid #E9E9E9;\r\ntext-align: justify;\r\n};\r\n</style>\r\n</head>\r\n<body>\r\n<div class="default_text_settings">\r\nDear ACCOUNT_NAME,<br /><br />\r\nTo activate your account, please click on the link below.<br />\r\nLINK_ACTIVATE_ACCOUNT<br />\r\n\For further assistance please contact SITEMGR_EMAIL.<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\r\n</html>');
INSERT INTO  `Setting` (`name` , `value`) VALUES ('pendingReviews_per_page', '2');
UPDATE  `Email_Notification` SET  `body` =  'Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team', `use_variables` =  'ACCOUNT_NAME,LINK_ACTIVATE_ACCOUNT,ACCOUNT_LOGIN_INFORMATION,DEFAULT_URL,EDIRECTORY_TITLE' WHERE  `Email_Notification`.`id` =35 LIMIT 1 ;
UPDATE `Email_Notification_Default` SET `body_text` = 'Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team', `body_html` = '<html>\n<head>\n<style type="text/css">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class="default_text_settings">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>';

