[Sommaire] [Imprimer]

   1  # This SQL script upgrades converts pages entered for the "infopages" mod into the new EZ-Pages format for Zen Cart v1.3.0

   2  #

   3  # $Id: convert_infopages_to_ezpages.sql 4243 2006-08-24 10:55:28Z drbyte $

   4  
   5  ## Add EZ-Pages table:

   6  CREATE TABLE ezpages (
   7    pages_id int(11) NOT NULL auto_increment,
   8    languages_id int(11) NOT NULL default '1',
   9    pages_title varchar(64) NOT NULL default '',
  10    alt_url varchar(255) NOT NULL default '',
  11    alt_url_external varchar(255) NOT NULL default '',
  12    pages_html_text text,
  13    status_header int(1) NOT NULL default '1',
  14    status_sidebox int(1) NOT NULL default '1',
  15    status_footer int(1) NOT NULL default '1',
  16    status_toc int(1) NOT NULL default '1',
  17    header_sort_order int(3) NOT NULL default '0',
  18    sidebox_sort_order int(3) NOT NULL default '0',
  19    footer_sort_order int(3) NOT NULL default '0',
  20    toc_sort_order int(3) NOT NULL default '0',
  21    page_open_new_window int(1) NOT NULL default '0',
  22    page_is_ssl int(1) NOT NULL default '0',
  23    toc_chapter int(11) NOT NULL default '0',
  24    PRIMARY KEY  (pages_id),
  25    KEY idx_lang_id_zen (languages_id),
  26    KEY idx_ezp_status_header_zen (status_header),
  27    KEY idx_ezp_status_sidebox_zen (status_sidebox),
  28    KEY idx_ezp_status_footer_zen (status_footer),
  29    KEY idx_ezp_status_toc_zen (status_toc)
  30  );
  31  
  32  
  33  
  34  ## The following can be used to import data from the infopages contrib if it was used:

  35  TRUNCATE ezpages;
  36  
  37  INSERT INTO ezpages (pages_id, pages_title, alt_url, pages_html_text, status_sidebox, sidebox_sort_order, footer_sort_order)
  38  SELECT pages_id, pages_title, alt_url, pages_html_text, status, vertical_sort_order, horizontal_sort_order
  39  FROM infopages;
  40