#
# Database table for `headertags_default`
#

DROP TABLE IF EXISTS headertags_default;
CREATE TABLE headertags_default (
  default_title varchar(255) default '' NOT NULL, 
  default_description varchar(255) default '' NOT NULL,
  default_keywords varchar(255) default '' NOT NULL,
  default_logo_text varchar(255) default '' NOT NULL,
  default_logo_append_group tinyint(1) default 1 NOT NULL,
  default_logo_append_category tinyint(1) default 1 NOT NULL,
  default_logo_append_manufacturer tinyint(1) default 1 NOT NULL,
  default_logo_append_product tinyint(1) default 1 NOT NULL,
  meta_google tinyint(1) default 0 NOT NULL,
  meta_language tinyint(1) default 0 NOT NULL,
  meta_noodp tinyint(1) default 1 NOT NULL,
  meta_noydir tinyint(1) default 1 NOT NULL,
  meta_replyto tinyint(1) default 0 NOT NULL,
  meta_revisit tinyint(1) default 0 NOT NULL,
  meta_robots tinyint(1) default 0 NOT NULL,
  meta_unspam tinyint(1) default 0 NOT NULL,
  language_id int DEFAULT '1' NOT NULL,
  PRIMARY KEY (default_title,language_id)
) TYPE=MyISAM;

INSERT INTO `headertags_default` ( `default_title` , `default_description` , `default_keywords` , `default_logo_text` ,
 `default_logo_append_group`,
 `default_logo_append_category`,
 `default_logo_append_manufacturer`,
 `default_logo_append_product`,
 `meta_google`,
 `meta_language`,
 `meta_noodp`,
 `meta_noydir`,
 `meta_replyto`,
 `meta_revisit`,
 `meta_robots`,
 `meta_unspam`,
 `language_id` )
 VALUES ('Default title', 'Default description', 'Default Keywords', 'Default Logo Text', '0','1','1','1','0','0','1','1','0','0','0','0', '1');


#
# Database table for `headertags_page`
#

DROP TABLE IF EXISTS headertags;
CREATE TABLE headertags (
  page_name varchar(64) default '' NOT NULL,
  page_title varchar(120) default '' NOT NULL,
  page_description varchar(255) default '' NOT NULL,
  page_keywords varchar(255) default '' NOT NULL,
  page_logo varchar(255) default '' NOT NULL,
  append_default_title tinyint(1) default 0 NOT NULL,
  append_default_description tinyint(1) default 0 NOT NULL,
  append_default_keywords tinyint(1) default 0 NOT NULL,
  append_default_logo tinyint(1) default 0 NOT NULL,
  append_category tinyint(1) default 0 NOT NULL,
  append_manufacturer tinyint(1) default 0 NOT NULL,
  append_product tinyint(1) default 1 NOT NULL,
  append_root tinyint(1) default 1 NOT NULL,
  sortorder_title tinyint(2) default 0 NOT NULL,
  sortorder_description tinyint(2) default 0 NOT NULL,
  sortorder_keywords tinyint(2) default 0 NOT NULL,
  sortorder_logo tinyint(2) default 0 NOT NULL,
  sortorder_category tinyint(2) default 0 NOT NULL,
  sortorder_manufacturer tinyint(2) default 0 NOT NULL,
  sortorder_product tinyint(2) default 10 NOT NULL,
  sortorder_root tinyint(2) default 1 NOT NULL,
  language_id int DEFAULT '1' NOT NULL,
  PRIMARY KEY (page_name,language_id)
) TYPE=MyISAM;

INSERT INTO `headertags` ( `page_name` , `page_title` , `page_description` , `page_keywords` , `page_logo`, `append_default_title` , `append_default_description` , `append_default_keywords`, `append_default_logo`, `append_category`, `append_manufacturer`, `append_product`, `append_root`, `sortorder_title` , `sortorder_description` , `sortorder_keywords` , `sortorder_logo` , `sortorder_category` , `sortorder_manufacturer`, `sortorder_product`, `sortorder_root`, `language_id` )
 VALUES ('index.php', 'New Home Page Title', 'new description', 'new keywords1,keywords2', 'new logo text', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '10', '1', '1');
INSERT INTO `headertags` ( `page_name` , `page_title` , `page_description` , `page_keywords` , `page_logo`, `append_default_title` , `append_default_description` , `append_default_keywords`, `append_default_logo`, `append_category`, `append_manufacturer`, `append_product`, `append_root`, `sortorder_title` , `sortorder_description` , `sortorder_keywords` , `sortorder_logo` , `sortorder_category` , `sortorder_manufacturer`, `sortorder_product`, `sortorder_root`, `language_id` )
 VALUES ('product_info.php', 'products new home', 'products new description', 'products new keywords1,keywords2', 'products logo text', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '10', '1', '1');
INSERT INTO `headertags` ( `page_name` , `page_title` , `page_description` , `page_keywords` , `page_logo`, `append_default_title` , `append_default_description` , `append_default_keywords`, `append_default_logo`, `append_category`, `append_manufacturer`, `append_product`, `append_root`, `sortorder_title` , `sortorder_description` , `sortorder_keywords` , `sortorder_logo` , `sortorder_category` , `sortorder_manufacturer`, `sortorder_product`, `sortorder_root`, `language_id` )
 VALUES ('product_reviews.php', 'Product reviews', 'Product reviews', 'Product reviews', 'Reviews logo text', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '10', '1', '1');
INSERT INTO `headertags` ( `page_name` , `page_title` , `page_description` , `page_keywords` , `page_logo`, `append_default_title` , `append_default_description` , `append_default_keywords`, `append_default_logo`, `append_category`, `append_manufacturer`, `append_product`, `append_root`, `sortorder_title` , `sortorder_description` , `sortorder_keywords` , `sortorder_logo` , `sortorder_category` , `sortorder_manufacturer`, `sortorder_product`, `sortorder_root`, `language_id` )
 VALUES ('product_reviews_info.php', 'Product reviews info', 'Product reviews info', 'Product reviews info', 'Reviews logo text', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '10', '1', '1');
INSERT INTO `headertags` ( `page_name` , `page_title` , `page_description` , `page_keywords` , `page_logo`, `append_default_title` , `append_default_description` , `append_default_keywords`, `append_default_logo`, `append_category`, `append_manufacturer`, `append_product`, `append_root`, `sortorder_title` , `sortorder_description` , `sortorder_keywords` , `sortorder_logo` , `sortorder_category` , `sortorder_manufacturer`, `sortorder_product`, `sortorder_root`, `language_id` )
 VALUES ('product_reviews_write.php', 'Product reviews write', 'Product reviews write', 'Product reviews write', 'Reviews logo text', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '10', '1', '1');
INSERT INTO `headertags` ( `page_name` , `page_title` , `page_description` , `page_keywords` , `page_logo`, `append_default_title` , `append_default_description` , `append_default_keywords`, `append_default_logo`, `append_category`, `append_manufacturer`, `append_product`, `append_root`, `sortorder_title` , `sortorder_description` , `sortorder_keywords` , `sortorder_logo` , `sortorder_category` , `sortorder_manufacturer`, `sortorder_product`, `sortorder_root`, `language_id` )
 VALUES ('specials.php', 'specials', 'specials', 'specials', 'Specials logo text', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '10', '1', '1');



ALTER TABLE products_description ADD products_head_title_tag VARCHAR(80) NULL;
ALTER TABLE products_description ADD products_head_desc_tag LONGTEXT NULL;
ALTER TABLE products_description ADD products_head_keywords_tag LONGTEXT NULL;

ALTER TABLE categories_description ADD categories_htc_title_tag VARCHAR(80) NULL;
ALTER TABLE categories_description ADD categories_htc_desc_tag LONGTEXT NULL;
ALTER TABLE categories_description ADD categories_htc_keywords_tag LONGTEXT NULL;
ALTER TABLE categories_description ADD categories_htc_description LONGTEXT NULL;

ALTER TABLE manufacturers_info ADD manufacturers_htc_title_tag VARCHAR(80) NULL;
ALTER TABLE manufacturers_info ADD manufacturers_htc_desc_tag LONGTEXT NULL;
ALTER TABLE manufacturers_info ADD manufacturers_htc_keywords_tag LONGTEXT NULL;
ALTER TABLE manufacturers_info ADD manufacturers_htc_description LONGTEXT NULL;

INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` )
 VALUES ('543', 'Header Tags SEO', 'Header Tags SEO site wide options', '20' , '1');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
 VALUES (NULL,'Automatically Add New Pages', 'HEADER_TAGS_AUTO_ADD_PAGES', 'true', 'Adds any new pages when Page Control is accessed<br>(true=on false=off)', '543', '3', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
 VALUES (NULL,'Check for Missing Tags', 'HEADER_TAGS_CHECK_TAGS', 'true', 'Check to see if any products, categories or manufacturers contain empty meta tag fields<br>(true=on false=off)', '543', '4', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
 VALUES (NULL,'Display Column Box', 'HEADER_TAGS_DISPLAY_COLUMN_BOX', 'false', 'Display product box in column while on product page<br>(true=on false=off)', '543', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
 VALUES (NULL,'Disable Permission Warning', 'HEADER_TAGS_DIABLE_PERMISSION_WARNING', 'false', 'Prevent the warning that appears if the permissions for the includes/header_tags.php file appear to be incoorect.<br>(true=on false=off)', '543', '6', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
 VALUES (NULL,'Display Help Popups', 'HEADER_TAGS_DISPLAY_HELP_POPUPS', 'true', 'Display short popup messages that describes a feature<br>(true=on false=off)', '543', '7', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
 VALUES (NULL,'Display Social Bookmark', 'HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS', 'false', 'Display social bookmarks on the product page<br>(true=on false=off)', '543', '8', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
 VALUES  (NULL, 'Keyword Density Range', 'HEADER_TAGS_KEYWORD_DENSITY_RANGE', '0.02,0.06', 'Set the limits for the keyword density use to dynamically select the keywords. Enter two figures, separated by a comma', '543', '9', NULL, now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
 VALUES  (NULL, 'Separator - Description', 'HEADER_TAGS_SEPARATOR_DESCRIPTION', '-', 'Set the separator to be used for the description (and titles and logo).', '543', '10', NULL, now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
 VALUES  (NULL, 'Separator - Keywords', 'HEADER_TAGS_SEPARATOR_KEYWORD', ',', 'Set the separator to be used for the keywords.', '543', '11', NULL, now(), NULL);