by (420 points)
Hi Team,

I want to Upgrade from Version 2.0.4 to 2.2.0 (Cms, not e-commerce)...
So, please guide me the sql changes for the new version... so that i can retain the old data and move to new version as well...

Means i want the 'changed sql script for 2.2.0'.

2 Answers

by (14.9k points)
Hello anshul,

one of the SeoToaster software engineer will reply shortly to your question to help you out with upgrading to SeoToaster 2.3 (the newest version)

Thanks for using SeoToaster
by (480 points)
ALTER TABLE  `template` CHANGE  `content`  `content` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;
ALTER TABLE  `page` ADD  `preview_image` TEXT NULL DEFAULT NULL COMMENT  'Page Preview Image';
INSERT INTO `page_option` (`id`, `title`, `context`, `active`) VALUES ('option_search', 'Search landing page', 'Seotoaster pages', 1);
ALTER TABLE `form` ADD COLUMN `captcha` ENUM('0','1') DEFAULT '0' NULL;
INSERT INTO `config`(`name`, `value`) VALUES ('recapthaPublicKey', '6LcaJdASAAAAADyAWIdBYytJMmYPEykb3Otz4pp6');
INSERT INTO `config`(`name`, `value`) VALUES ('recapthaPrivateKey', '6LcaJdASAAAAAH-e1dWpk96PACf3BQG1OGGvh5hK');
CREATE TABLE IF NOT EXISTS `form_page_conversion` (
  `page_id` int(10) unsigned NOT NULL,
  `form_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `conversion_code` TEXT COLLATE utf8_unicode_ci NULL,
  PRIMARY KEY (`page_id`,`form_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `form` DROP COLUMN `tracking_code`;
ALTER TABLE `user` ADD `gplus_profile` tinytext COLLATE 'utf8_unicode_ci' NULL;
INSERT INTO `template_type` (`id`, `title`) VALUES ('typemobile',    'Mobile page');
ALTER TABLE  `optimized` ADD INDEX (  `nav_name` );
ALTER TABLE  `optimized` ADD INDEX (  `url`(30) );
INSERT INTO `config` (`name`, `value`) VALUES ('version', '2.1.0');
INSERT INTO `template_type` (`id`, `title`) VALUES ('typemenu', 'Menu');
CREATE TABLE IF NOT EXISTS `user_attributes` (
  `user_id` int(10) unsigned NOT NULL,
  `attribute` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`user_id`,`attribute`(20)),
  CONSTRAINT `user_attributes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `optimized` ADD `seo_intro` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `teaser_text` ,
ADD `seo_intro_target` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `seo_intro`;
UPDATE `config` SET `name` = 'recaptchaPublicKey' WHERE `name` = 'recapthaPublicKey';
UPDATE `config` SET `name` = 'recaptchaPrivateKey' WHERE `name` = 'recapthaPrivateKey';
ALTER TABLE `email_triggers` ADD UNIQUE INDEX(`trigger_name`, `observer`);
ALTER TABLE `email_triggers_actions` ADD `service` ENUM( 'email', 'sms' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `id`;
UPDATE `email_triggers_actions` SET `service` = 'email' WHERE `service` IS NULL;
ALTER TABLE `plugin` ADD `version` varchar(20) COLLATE 'utf8_unicode_ci' NULL, COMMENT='';
ALTER TABLE `user` ADD `mobile_phone` varchar(20) COLLATE 'utf8_unicode_ci' NULL, COMMENT='';
ALTER TABLE `page` CHANGE `header_title` `header_title` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `optimized` CHANGE `header_title` `header_title` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
INSERT INTO `template_type` (`id`, `title`) VALUES ('type_partial_template', 'Partial template');
ALTER TABLE `form` ADD COLUMN `mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL;
ALTER TABLE `form` ADD COLUMN `enable_sms` enum('0','1') COLLATE utf8_unicode_ci DEFAULT '0';
ALTER TABLE `page_option` ADD COLUMN `option_usage` ENUM('once', 'many') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'many';
UPDATE `page_option` SET `option_usage`='once' WHERE `page_option`.`id` = 'option_member_landing';
UPDATE `page_option` SET `option_usage`='once' WHERE `page_option`.`id` = 'option_member_loginerror';
UPDATE `page_option` SET `option_usage`='once' WHERE `page_option`.`id` = 'option_member_signuplanding';
UPDATE `page_option` SET `option_usage`='once' WHERE `page_option`.`id` = 'option_search';
UPDATE `template_type` SET `title` = 'Regular' WHERE `id` = 'typeregular';
UPDATE `template_type` SET `title` = 'E-mail' WHERE `id` = 'typemail';
UPDATE `config` SET `value`='2.3.1' WHERE `name`='version';
SELECT value FROM `config` WHERE name = 'version';
INSERT INTO `template_type` (`id`, `title`) VALUES ('type_partial_template', 'Partial template');
UPDATE `config` SET `value`='2.2.6' WHERE `name`='version';
SELECT value FROM `config` WHERE name = 'version';
by (420 points)
many thanks for this... i will check it and let you know if any problem occurs... once again... thanks...
...