2014麦包包ecshop模板.zip源码ECSHOP网站模板打包下载

-- phpMyAdmin SQL Dump -- version 3.5.1 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2014 年 08 月 26 日 08:12 -- 服务器版本: 5.5.24-log -- PHP 版本: 5.3.13 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- -- 数据库: `mbmaibaobao` -- -- -------------------------------------------------------- -- -- 表的结构 `esc_ad` -- CREATE TABLE IF NOT EXISTS `esc_ad` ( `ad_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `position_id` smallint(5) unsigned NOT NULL DEFAULT '0', `media_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `ad_name` varchar(60) NOT NULL DEFAULT '', `ad_link` varchar(255) NOT NULL DEFAULT '', `ad_code` text NOT NULL, `start_time` int(11) NOT NULL DEFAULT '0', `end_time` int(11) NOT NULL DEFAULT '0', `link_man` varchar(60) NOT NULL DEFAULT '', `link_email` varchar(60) NOT NULL DEFAULT '', `link_phone` varchar(60) NOT NULL DEFAULT '', `click_count` mediumint(8) unsigned NOT NULL DEFAULT '0', `enabled` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`ad_id`), KEY `position_id` (`position_id`), KEY `enabled` (`enabled`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=196 ; -- -- 转存表中的数据 `esc_ad` -- INSERT INTO `esc_ad` (`ad_id`, `position_id`, `media_type`, `ad_name`, `ad_link`, `ad_code`, `start_time`, `end_time`, `link_man`, `link_email`, `link_phone`, `click_count`, `enabled`) VALUES (195, 161, 0, 'Logo右边广告', '#', '1408916763717198664.jpg', 1408867200, 1537689600, '', '', '', 0, 1); -- -------------------------------------------------------- -- -- 表的结构 `esc_ad_position` -- CREATE TABLE IF NOT EXISTS `esc_ad_position` ( `position_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `position_name` varchar(60) NOT NULL DEFAULT '', `ad_width` smallint(5) unsigned NOT NULL DEFAULT '0', `ad_height` smallint(5) unsigned NOT NULL DEFAULT '0', `position_desc` varchar(255) NOT NULL DEFAULT '', `position_style` text NOT NULL, PRIMARY KEY (`position_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=162 ; -- -- 转存表中的数据 `esc_ad_position` -- INSERT INTO `esc_ad_position` (`position_id`, `position_name`, `ad_width`, `ad_height`, `position_desc`, `position_style`) VALUES (161, 'Logo右边广告', 228, 70, '', '\r\n{foreach from=$ads item=ad}\r\n{$ad}\r\n{/foreach}\r\n'); -- -------------------------------------------------------- -- -- 表的结构 `esc_template` -- CREATE TABLE IF NOT EXISTS `esc_template` ( `filename` varchar(30) NOT NULL DEFAULT '', `region` varchar(40) NOT NULL DEFAULT '', `library` varchar(40) NOT NULL DEFAULT '', `sort_order` tinyint(1) unsigned NOT NULL DEFAULT '0', `id` smallint(5) unsigned NOT NULL DEFAULT '0', `number` tinyint(1) unsigned NOT NULL DEFAULT '5', `type` tinyint(1) unsigned NOT NULL DEFAULT '0', `theme` varchar(60) NOT NULL DEFAULT '', `remarks` varchar(30) NOT NULL DEFAULT '', KEY `filename` (`filename`,`region`), KEY `theme` (`theme`), KEY `remarks` (`remarks`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `esc_template` -- INSERT INTO `esc_template` (`filename`, `region`, `library`, `sort_order`, `id`, `number`, `type`, `theme`, `remarks`) VALUES ('index', '左边区域', '/library/vote_list.lbi', 8, 0, 0, 0, 'default', ''), ('index', '左边区域', '/library/email_list.lbi', 9, 0, 0, 0, 'default', ''), ('index', '左边区域', '/library/order_query.lbi', 6, 0, 0, 0, 'default', ''), ('index', '左边区域', '/library/cart.lbi', 0, 0, 0, 0, 'default', ''), ('index', '左边区域', '/library/promotion_info.lbi', 3, 0, 0, 0, 'default', ''), ('index', '左边区域', '/library/auction.lbi', 4, 0, 3, 0, 'default', ''), ('index', '左边区域', '/library/group_buy.lbi', 5, 0, 3, 0, 'default', ''), ('index', '', '/library/recommend_promotion.lbi', 0, 0, 4, 0, 'default', ''), ('index', '右边主区域', '/library/recommend_hot.lbi', 2, 0, 10, 0, 'default', ''), ('index', '右边主区域', '/library/recommend_new.lbi', 1, 0, 10, 0, 'default', ''), ('index', '右边主区域', '/library/recommend_best.lbi', 0, 0, 10, 0, 'default', ''), ('index', '左边区域', '/library/invoice_query.lbi', 7, 0, 0, 0, 'default', ''), ('index', '左边区域', '/library/top10.lbi', 2, 0, 0, 0, 'default', ''), ('index', '左边区域', '/library/category_tree.lbi', 1, 0, 0, 0, 'default', ''), ('index', '', '/library/brands.lbi', 0, 0, 11, 0, 'default', ''), ('category', '左边区域', '/library/category_tree.lbi', 1, 0, 0, 0, 'default', ''), ('category', '右边区域', '/library/recommend_best.lbi', 0, 0, 5, 0, 'default', ''), ('category', '右边区域', '/library/goods_list.lbi', 1, 0, 0, 0, 'default', ''), ('category', '右边区域', '/library/pages.lbi', 2, 0, 0, 0, 'default', ''), ('category', '左边区域', '/library/cart.lbi', 0, 0, 0, 0, 'default', ''), ('category', '左边区域', '/library/price_grade.lbi', 3, 0, 0, 0, 'default', ''), ('category', '左边区域', '/library/filter_attr.lbi', 2, 0, 0, 0, 'default', ''), ('index', '全宽行', '/library/cat_goods.lbi', 0, 132, 5, 1, 'ecmoban_maibaobao', ''), ('index', '', '/library/brands.lbi', 0, 0, 3, 0, 'ecmoban_maibaobao', ''), ('index', '', '/library/auction.lbi', 0, 0, 3, 0, 'ecmoban_maibaobao', ''), ('index', '', '/library/group_buy.lbi', 0, 0, 5, 0, 'ecmoban_maibaobao', ''), ('index', '促销商品区域', '/library/recommend_promotion.lbi', 0, 0, 5, 0, 'ecmoban_maibaobao', ''), ('index', '全宽行', '/library/recommend_hot.lbi', 1, 0, 5, 0, 'ecmoban_maibaobao', ''), ('index', '全宽行', '/library/recommend_new.lbi', 0, 0, 5, 0, 'ecmoban_maibaobao', ''), ('index', '全宽行', '/library/recommend_best.lbi', 2, 0, 5, 0, 'ecmoban_maibaobao', '');