[phpBB Debug] PHP Warning: in file [ROOT]/includes/crs/crs_misc_functions.php on line 37: mime_content_type(): Empty filename or path Zen Cart 源代码 convert_infopages_to_ezpages.sql
# This SQL script upgrades converts pages entered for the "infopages" mod into the new EZ-Pages format for Zen Cart v1.3.0
#
# $Id: convert_infopages_to_ezpages.sql 4243 2006-08-24 10:55:28Z drbyte $
## Add EZ-Pages table:
CREATE TABLE ezpages (
pages_id int(11) NOT NULL auto_increment,
languages_id int(11) NOT NULL default '1',
pages_title varchar(64) NOT NULL default '',
alt_url varchar(255) NOT NULL default '',
alt_url_external varchar(255) NOT NULL default '',
pages_html_text text,
status_header int(1) NOT NULL default '1',
status_sidebox int(1) NOT NULL default '1',
status_footer int(1) NOT NULL default '1',
status_toc int(1) NOT NULL default '1',
header_sort_order int(3) NOT NULL default '0',
sidebox_sort_order int(3) NOT NULL default '0',
footer_sort_order int(3) NOT NULL default '0',
toc_sort_order int(3) NOT NULL default '0',
page_open_new_window int(1) NOT NULL default '0',
page_is_ssl int(1) NOT NULL default '0',
toc_chapter int(11) NOT NULL default '0',
PRIMARY KEY (pages_id),
KEY idx_lang_id_zen (languages_id),
KEY idx_ezp_status_header_zen (status_header),
KEY idx_ezp_status_sidebox_zen (status_sidebox),
KEY idx_ezp_status_footer_zen (status_footer),
KEY idx_ezp_status_toc_zen (status_toc)
);
## The following can be used to import data from the infopages contrib if it was used:
TRUNCATE ezpages;
INSERT INTO ezpages (pages_id, pages_title, alt_url, pages_html_text, status_sidebox, sidebox_sort_order, footer_sort_order)
SELECT pages_id, pages_title, alt_url, pages_html_text, status, vertical_sort_order, horizontal_sort_order
FROM infopages;