?¨á?2?ü?àμ?ê±??°?ecshopμ?êy?Y?a±í·???á???￡?ecshop°?±?2.6.0?￡
2.6óD±í74?? 2.7μ±?DóD86??±í
è?óD?￠???ò??′í?óμ?μ?·???ó-′ó?òìí?ó￡????y￡?D?D?￡?
±?????3?D??üD?
×?D?μ?2.7μ±?D?àá??aad_custom /_affiliate_logμè±í ?￡í?′ó?ò?ú??
-- phpMyAdmin SQL Dump
-- version 3.0.0-rc2
-- https://www.doczj.com/doc/4f9762670.html,
-- ?÷?ú: localhost
-- éú3éè??ú: 2008 ?ê 11 ?? 14 è? 17:12
-- ·t???÷°?±?: 5.1.29
-- PHP °?±?: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
êy?Y?a: `ecshop`
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_account_log`
CREATE TABLE IF NOT EXISTS `ecs_account_log` (
`log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`user_id` mediumint(8) unsigned NOT NULL COMMENT 'ó??§μ???oó±￡′??úsession?Dμ?ido?￡??úusers±í?Dμ?user_id??ó|',
`user_money` decimal(10,2) NOT NULL COMMENT 'ó??§??±ê????μ?óà??',
`frozen_money` decimal(10,2) NOT NULL COMMENT '±??3?áμ?×ê?e',
`rank_points` mediumint(9) NOT NULL COMMENT 'μè???y·?￡??ú??·??y·?ê?·??aμ?',
`pay_points` mediumint(9) NOT NULL COMMENT '??·??y·?￡??úμè???y·?ê?·??aμ?',
`change_time` int(10) unsigned NOT NULL COMMENT '??±ê2ù×÷·￠éúμ?ê±??',
`change_desc` varchar(255) NOT NULL COMMENT '??±ê2ù×÷μ?±?×￠￡?ò?°?ê?￡?3??μ?ò??ìá???￡ò2?éê?ê?1üàí?±oóì¨D′μ?è?o??ú±?×￠',
`change_type` tinyint(3) unsigned NOT NULL COMMENT '2ù×÷ààDí￡?0?a3??μ￡?1?aìá??￡?2?a1üàí?±μ÷?ú￡?99?a????ààDí',
PRIMARY KEY (`log_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='ó??§?êo??é??????±í￡?°üà¨×ê?eoí?y·?μè' AUTO_INCREMENT=42 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_ad`
CREATE TABLE IF NOT EXISTS `ecs_ad` (
`ad_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`position_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '0,??ía1???￡?′ó1?aê?′ú±íμ?ê???1????ù′|μ?1?????￡?í?±íad_position?Dμ?×???position_
idμ??μ',
`media_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1???ààDí￡?0￡?í???￡?1￡?flash;2,′ú??￡?3￡???×?',
`ad_name` varchar(60) NOT NULL COMMENT '??ì?1???????μ?1?????3?',
`ad_link` varchar(255) NOT NULL COMMENT '1???á′?óμ??·',
`ad_code` text NOT NULL COMMENT '1???á′?óμ?±í??￡???×?1????íê???×??òí???oíflash?íê??ü??μ?μ??·￡?′ú??1????íê?′ú???ú
èY',
`start_time` int(11) NOT NULL DEFAULT '0' COMMENT '1????aê?ê±??',
`end_time` int(11) NOT NULL DEFAULT '0' COMMENT '1????áê?ê±??',
`link_man` varchar(60) NOT NULL COMMENT '1???áa?μè?',
`link_email` varchar(60) NOT NULL COMMENT '1???áa?μè?μ?óê??',
`link_phone` varchar(60) NOT NULL COMMENT '1???áa?μè?μ?μ??°',
`click_count` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '??1???μ??÷êy', `enabled` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '??1???ê?·?1?±?￡?1￡??a??￡?0￡?1?±?￡?1?±?oó1?????2??ùóDD§￡??±?á??D??a??',
PRIMARY KEY (`ad_id`),
KEY `position_id` (`position_id`),
KEY `enabled` (`enabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='1???áD±í????±í￡?°üà¨???ú??íaμ?í???￡???×?￡?flash￡?′ú??1???'
AUTO_INCREMENT=6 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_admin_action`
CREATE TABLE IF NOT EXISTS `ecs_admin_action` (
`action_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`parent_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '??id??μ???id￡???ó|±?±íμ?action_id×???',
`action_code` varchar(20) NOT NULL COMMENT '′ú±íè¨?Tμ?ó￠??×?·?′?￡???ó|oo???úó??????t?D￡?è?1???×???óD?3??×?·?′?￡??í±íê?óD??è
¨?T',
PRIMARY KEY (`action_id`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='1üàí?±è¨?TáD±íê÷' AUTO_INCREMENT=104 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_admin_log`
CREATE TABLE IF NOT EXISTS `ecs_admin_log` (
`log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`log_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'D′è???ê±??',
`user_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '??è????ù????μ?2ù×÷??id￡?í?ecs_admin_userμ?user_id',
`log_info` varchar(255) NOT NULL COMMENT '1üàí2ù×÷?úèY',
`ip_address` varchar(15) NOT NULL COMMENT '1üàí??μ???ip',
PRIMARY KEY (`log_id`),
KEY `log_time` (`log_time`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='1üàí?±2ù×÷è???±í' AUTO_INCREMENT=158 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_admin_message`
CREATE TABLE IF NOT EXISTS `ecs_admin_message` (
`message_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`sender_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '·￠?í??á???μ?1üàí?±id￡?í?ecs_admin_userμ?user_id',
`receiver_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '?óê????￠μ?1üàí?±id￡?í?ecs_admin_userμ?user_id￡?è?1?ê????à??1üàí?±·￠?í￡??òí?ò??????￠??????1üàí?±id·￠?íò?ì?',
`sent_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'á???·￠?íê±??',
`read_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'á??????áê±??',
`readed` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'á???ê?·????á￡?1￡?ò????á￡?0￡??′???á',
`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'á???ê?·?ò??-ê?·?ò??-±?é?3y￡?1￡?ò?é?3y￡?0￡??′é?3y',
`title` varchar(150) NOT NULL COMMENT 'á???μ??÷ìa',
`message` text NOT NULL COMMENT 'á???μ??úèY',
PRIMARY KEY (`message_id`),
KEY `sender_id` (`sender_id`,`receiver_id`),
KEY `receiver_id` (`receiver_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='1üàí?±á???????±í' AUTO_INCREMENT=7 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_admin_user`
CREATE TABLE IF NOT EXISTS `ecs_admin_user` (
`user_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?￡?1üàí?±′úo?',
`user_name` varchar(60) NOT NULL COMMENT '1üàí?±μ?????',
`email` varchar(60) NOT NULL COMMENT '1üàí?±óê??',
`password` varchar(32) NOT NULL COMMENT '1üàí?±μ??????ü?ó?ü′?',
`add_time` int(11) NOT NULL DEFAULT '0' COMMENT '1üàí?±ìí?óê±??',
`last_login` int(11) NOT NULL DEFAULT '0' COMMENT '1üàí?±×?oóò?′?μ???ê±??',
`last_ip` varchar(15) NOT NULL COMMENT '1üàí?±×?oóò?′?μ???ip',
`action_list` text NOT NULL COMMENT '1üàí?±1üàíè¨?TáD±í',
`nav_list` text NOT NULL COMMENT '1üàí?±μ?o?à???????',
`lang_type` varchar(50) NOT NULL,
`agency_id` smallint(5) unsigned NOT NULL COMMENT '??1üàí?±?o?eμ?°ìê?′|μ?id￡?í?ecs_agencyμ?agency_id×????￡è?1?1üàí?±???o?e°ìê?′|￡?
?ò′?′|?a0',
`todolist` longtext COMMENT '??ê?±?????μ?êy?Y',
PRIMARY KEY (`user_id`),
KEY `user_name` (`user_name`),
KEY `agency_id` (`agency_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='1üàí?±×êá?è¨?TáD±í' AUTO_INCREMENT=4 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_adsense`
CREATE TABLE IF NOT EXISTS `ecs_adsense` (
`from_ad` smallint(5) NOT NULL DEFAULT '0' COMMENT '1???′úo?￡?-1ê???ía1???￡?è?1?ê????ú1????ò?aecs_adμ?ad_id',
`referer` varchar(255) NOT NULL COMMENT 'ò3??à′?′',
`clicks` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'μ??÷?ê',
KEY `from_ad` (`from_ad`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='1???μ??÷?êí3??±í';
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_ad_position`
CREATE TABLE IF NOT EXISTS `ecs_ad_position` (
`position_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '1?????×???id',
`position_name` varchar(60) NOT NULL COMMENT '1???????3?',
`ad_width` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '1??????í?è',
`ad_height` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '1????????è',
`position_desc` varchar(255) NOT NULL COMMENT '1??????èê?',
`position_style` text NOT NULL COMMENT '1??????￡°?′ú??',
PRIMARY KEY (`position_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='1???????????±í' AUTO_INCREMENT=2 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_affiliate_log`
CREATE TABLE IF NOT EXISTS `ecs_affiliate_log` (
`log_id` mediumint(8) NOT NULL AUTO_INCREMENT,
`order_id` mediumint(8) NOT NULL,
`time` int(10) NOT NULL,
`user_id` mediumint(8) NOT NULL,
`user_name` varchar(60) DEFAULT NULL,
`money` decimal(10,2) NOT NULL DEFAULT '0.00',
`point` int(10) NOT NULL DEFAULT '0',
`separate_type` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='·?3é?à1?μ?±í￡??1???D??í?' AUTO_INCREMENT=1 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_agency`
CREATE TABLE IF NOT EXISTS `ecs_agency` (
`agency_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '°ìê?′|ID',
`agency_name` varchar(255) NOT NULL COMMENT '°ìê?′|??×?',
`agency_desc` text NOT NULL COMMENT '°ìê?′|?èê?',
PRIMARY KEY (`agency_id`),
KEY `agency_name` (`agency_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='°ìê?′|D??￠' AUTO_INCREMENT=5 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_area_region`
CREATE TABLE IF NOT EXISTS `ecs_area_region` (
`shipping_area_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '???í??óòμ?ido?￡?μèí?óúecs_shipping_areaμ?shipping_area_idμ??μ',
`region_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'μ???áD±í￡?μèí?óúecs_regionμ?region_id',
PRIMARY KEY (`shipping_area_id`,`region_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='????±íecs_shipping_area?Dμ?shipping_area_nameμ?μ?????°üà¨ecs_region?Dμ?3?êD';
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_article`
CREATE TABLE IF NOT EXISTS `ecs_article` (
`article_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?', `cat_id` smallint(5) NOT NULL DEFAULT '0' COMMENT '??????μ?·?àà￡?í?ecs_article_catμ?cat_id,è?1?2??ú￡???×??ˉ3é?a±￡á?ààDí??2??üé?3y' ,
`title` varchar(150) NOT NULL COMMENT '????ìa??',
`content` longtext NOT NULL COMMENT '?????úèY',
`author` varchar(30) NOT NULL COMMENT '????×÷??',
`author_email` varchar(60) NOT NULL COMMENT '????×÷??μ?email',
`keywords` varchar(255) NOT NULL COMMENT '????μ?1??ü×?',
`article_type` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '????ààDí￡?0￡???í¨￡?1￡????￥￡?2oí′óóú2μ?￡??a±￡á?????￡?±￡á?????2??üé?3y',
`is_open` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'ê?·???ê??￡1￡???ê?￡?0￡?2???ê?',
`add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '????ìí?óê±??',
`file_url` varchar(255) NOT NULL COMMENT 'é?′????t?ò??ía2????tμ?url',
`open_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0,?y3￡￡?μ±??×????a1?ò??2ê±￡??á?ú????×?oóìí?óò???á′?ó?°?à1??????±￡?á??óμ??·μèóúf ile_urlμ??μ￡?μ?3ìDò?ú′?′|óDbug',
`link` varchar(255) NOT NULL COMMENT '??????±êìa?ùòyó?μ?á??ó￡?è?1?????óD?μ??2??ü??ê??????úèY￡??′??±í?Dcontentμ??μ', PRIMARY KEY (`article_id`),
KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='?????úèY±í' AUTO_INCREMENT=11 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_article_cat`
CREATE TABLE IF NOT EXISTS `ecs_article_cat` (
`cat_id` smallint(5) NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`cat_name` varchar(255) NOT NULL COMMENT '·?àà??3?',
`cat_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '·?ààààDí￡?1￡???í¨·?àà￡?2￡??μí3·?àà￡?3￡?í?μêD??￠￡?4￡?°??ú·?àà￡?5￡?í?μê°??ú',
`keywords` varchar(255) NOT NULL COMMENT '·?àà1??ü×?',
`cat_desc` varchar(255) NOT NULL COMMENT '·?àà?μ?÷??×?',
`sort_order` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '·?àà??ê??3Dò',
`show_in_nav` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?·??úμ?o?à???ê?￡?0￡?·?￡?1￡?ê?',
`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '???úμ?id￡?è??μóú??±ícat_id×???',
PRIMARY KEY (`cat_id`),
KEY `cat_type` (`cat_type`),
KEY `sort_order` (`sort_order`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='????·?ààD??￠±í' AUTO_INCREMENT=7 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_attribute`
CREATE TABLE IF NOT EXISTS `ecs_attribute` (
`attr_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`cat_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?·ààDí￡?í?ecs_goods_typeμ?cat_id',
`attr_name` varchar(60) NOT NULL COMMENT 'ê?D???3?',
`attr_input_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'μ±ìí?óéì?·ê±￡???ê?D?μ?ìí?óàà±e￡?0￡??aê?1¤ê?è?￡?1￡??a????ê?è?￡?2￡??a?àDD??±?ê?è?',
`attr_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'ê?D?ê?·??à??￡?0￡?·?￡?1￡?ê?￡?è?1??éò??à??￡??ò?éò?×??¨ò?ê?D?￡?2￠?ò?éò??ù?Y?μμ?2?í??¨2?í?μ???',
`attr_values` text NOT NULL COMMENT 'è?1?attr_input_type?a1￡??′????ê?è?￡??òattr_name??ó|μ??μμ?è??μ?íê???×???μ??μ', `attr_index` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?D?ê?·??éò??ì?÷￡?0￡?2?Dèòa?ì?÷￡?1￡?1??ü×??ì?÷￡?2￡?·??§?ì?÷￡???ê?D?ó|??ê?è?1??ì?÷μ??°￡??éò?í¨1y??ê?D??òμ?óD??ê?D?μ?éì?·',
`sort_order` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?D???ê?μ??3Dò￡?êy×???′ó?????°￡?è?1?êy×?ò??ù?ò°′id?3Dò',
`is_linked` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?·?1?áa￡?0￡?2?1?áa￡?1￡?1?áa￡?è?1?1?áa￡????′ó??§?ú1o?ò??éì?·ê±￡???óDóD??ê?D??àí??μμ?éì?·??±?í?????ó??§',
`attr_group` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?D?·?×é￡??àí?μ??aò???ê?D?×é?￡???μó|??è?×?ecs_goods_typeμ?attr_groupμ??μμ??3Dò' ,
PRIMARY KEY (`attr_id`),
KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='éì?·ààDíê?D?±í￡???±í????μ?ê?????éì?·ààDíμ??ùóDê?D?μ??????é??￡???ì?μ?éì?·μ?ê?D?2??ú??±í' AUTO_INCREMENT=175 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_auction_log`
CREATE TABLE IF NOT EXISTS `ecs_auction_log` (
`log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`act_id` mediumint(8) unsigned NOT NULL COMMENT '???????ˉμ?id￡?è??μóúecs_goods_activityμ?act_id×???',
`bid_user` mediumint(8) unsigned NOT NULL COMMENT '3???μ?ó??§id￡?è??μóúecs_usersμ?user_id',
`bid_price` decimal(10,2) unsigned NOT NULL COMMENT '3???????',
`bid_time` int(10) unsigned NOT NULL COMMENT '3???ê±??',
PRIMARY KEY (`log_id`),
KEY `act_id` (`act_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='????3???????D??￠±í' AUTO_INCREMENT=3 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_auto_manage`
CREATE TABLE IF NOT EXISTS `ecs_auto_manage` (
`item_id` mediumint(8) NOT NULL COMMENT 'è?1?ê?éì?·?íê?ecs_goodsμ?goods_id￡?è?1?ê??????íê?ecs_articleμ?article_id',
`type` varchar(10) NOT NULL COMMENT 'goodsê?éì?·￡?articleê?????',
`starttime` int(10) NOT NULL COMMENT 'é???ê±??',
`endtime` int(10) NOT NULL COMMENT '????ê±??',
PRIMARY KEY (`item_id`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='′|àí????￡?éì?·×??ˉé?????μ?????è???áD±í￡?Dèòa°2×°????è???2??t2?óDD§';
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_bonus_type`
CREATE TABLE IF NOT EXISTS `ecs_bonus_type` (
`type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'oì°üààDíá÷??o?', `type_name` varchar(60) NOT NULL COMMENT 'oì°ü??3?',
`type_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'oì°ü?ù?μμ??e??',
`send_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'oì°ü·￠?íààDí.0,°′ó??§è??á?±μè??,?á?±??3?·￠·?;1,°′éì?·àà±e·￠?í;2,°′??μ￥?e???ù′?μ
?μ????è·￠?í;3,????·￠?í',
`min_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'è?1?ê?°′?e??·￠?íoì°ü,????ê?×?D??e??.?′??òa1o?ò3?1y???e??μ?éì?·???éò?áìμ?oì°ü', `max_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
`send_start_date` int(11) NOT NULL DEFAULT '0' COMMENT 'oì°ü·￠?íμ??aê?ê±??',
`send_end_date` int(11) NOT NULL DEFAULT '0' COMMENT 'oì°ü·￠?íμ??áê?ê±??',
`use_start_date` int(11) NOT NULL DEFAULT '0' COMMENT 'oì°ü?éò?ê1ó?μ??aê?ê±??', `use_end_date` int(11) NOT NULL DEFAULT '0' COMMENT 'oì°ü?éò?ê1ó?μ??áê?ê±??',
`min_goods_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '?éò?ê1ó???oì°üμ?éì?·μ?×?μí????.?′??òa′?μ???????μ?éì?·2??éò?ê1ó?oì°ü',
PRIMARY KEY (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='oì°üààDí±í' AUTO_INCREMENT=6 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_booking_goods`
CREATE TABLE IF NOT EXISTS `ecs_booking_goods` (
`rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'μ?????è±??????μ?ó??§μ?id￡?è??μecs_usersμ?user_id',
`email` varchar(60) NOT NULL COMMENT 'ò3??ì?μ?ó??§μ?email￡???è?è??μóúecs_usersμ?email',
`link_man` varchar(60) NOT NULL COMMENT 'ò3??ì?μ?ó??§μ?D???￡???è?è??μóúecs_usersμ?consignee ',
`tel` varchar(60) NOT NULL COMMENT 'ò3??ì?μ?ó??§μ?μ??°￡???è?è??μóúecs_usersμ?tel', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'è±??μ???μ?éì?·id￡?è??μóúecs_goodsμ? goods_id',
`goods_desc` varchar(255) NOT NULL COMMENT 'è±??μ???ê±á?μ???1o?èê?',
`goods_number` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '??1oêyá?',
`booking_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'è±??μ???μ?ê±??',
`is_dispose` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?·?ò??-±?′|àí', `dispose_user` varchar(30) NOT NULL COMMENT '′|àí??è±??μ???μ?1üàí?±ó??§??￡?è??μóúsession,??sessionè??μóúecs_admin_userμ?user
_name',
`dispose_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '′|àíμ?ê±??',
`dispose_note` varchar(255) NOT NULL COMMENT '′|àíê±1üàí?±á?μ?±?×￠',
PRIMARY KEY (`rec_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='è±??μ???μ???1ooí′|àí????±í' AUTO_INCREMENT=4 ;
* ------------------------------------------------------
-- ±íμ??á11 `ecs_brand`
CREATE TABLE IF NOT EXISTS `ecs_brand` (
`brand_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`brand_name` varchar(60) NOT NULL COMMENT '?·????3?',
`brand_logo` varchar(80) NOT NULL COMMENT 'é?′?μ????·??1???logoí???',
`brand_desc` text NOT NULL COMMENT '?·???èê?',
`site_url` varchar(255) NOT NULL COMMENT '?·??μ?í??·',
`sort_order` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '?·???ú?°ì¨ò3??μ???ê??3Dò￡?êy×???′ó????oó',
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '???·??ê?·???ê?￡?0￡?·?￡?1￡???ê?',
PRIMARY KEY (`brand_id`),
KEY `is_show` (`is_show`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='éì?·?·??D??￠????±í' AUTO_INCREMENT=9 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_card`
CREATE TABLE IF NOT EXISTS `ecs_card` (
`card_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`card_name` varchar(120) NOT NULL COMMENT 'o??¨??3?',
`card_img` varchar(255) NOT NULL COMMENT 'o??¨í???μ???3?',
`card_fee` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'o??¨?ùDè·?ó?', `free_money` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '??μ￥′?μ???×???μ??μoóê1ó?′?o??¨?a·?',
`card_desc` varchar(255) NOT NULL COMMENT 'o??¨μ??èê?',
PRIMARY KEY (`card_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='o??¨μ?????μ?D??￠' AUTO_INCREMENT=2 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_cart`
CREATE TABLE IF NOT EXISTS `ecs_cart` (
`rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'ó??§μ???id￡?è?×?session￡?',
`session_id` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'μ???μ?sessionid￡?è?1???ó??§í?3?￡???sessionid??ó|μ?1o??3μ?Dμ??ùóD????????±?é?3y'
,
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?·μ?id￡?è?×?±ígoodsμ?goods_id',
`goods_sn` varchar(60) NOT NULL COMMENT 'éì?·μ???o?￡?è?×?±ígoodsμ?goods_sn',
`goods_name` varchar(120) NOT NULL COMMENT 'éì?·μ???3?￡?è?×?±ígoodsμ?goods_name', `market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'éì?·μ?êD3???￡?è?×?±ígoodsμ?market_price',
`goods_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'éì?·μ?±?μê??￡?è?×?±ígoodsμ?shop_price',
`goods_number` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT
'éì?·μ?1o?òêyá?￡??ú1o??3μê±￡?êμ?ê?a′?2???éù',
`goods_attr` text NOT NULL COMMENT 'éì?·μ?ê?D?￡??Dà¨o?à?ê???ê?D?ì?óDμ?????',
`is_real` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'è?×?ecs_goodsμ?is_real', `extension_code` varchar(30) NOT NULL COMMENT 'éì?·μ?à??1ê?D?￡?è?×?ecs_goodsμ?extension_code',
`parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '??éì?·μ???éì?·id￡???óD???μ?a0￡?óDμ??°????éì?·?íê???idμ????t',
`rec_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1o??3μéì?·ààDí￡?0￡???í¨￡?1￡?í?1?￡?2￡?????￡?3￡??á±|??±?',
`is_gift` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?·?ê??ù?·￡?0￡?·?￡?????￡?ê?2??óó??Y???ˉμ?id￡?è??μóúecs_favourable_activity
μ?act_id',
`can_handsel` tinyint(3) unsigned NOT NULL DEFAULT '0',
`goods_attr_id` mediumint(8) NOT NULL COMMENT '??éì?·μ?ê?D?μ?id￡?è?×?goods_attrμ?goods_attr_id￡?è?1?óD?à??￡???????á?×?oóò???￡?
?é?üê???bug',
PRIMARY KEY (`rec_id`),
KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='1o??3μ1o??D??￠????±í' AUTO_INCREMENT=82 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_category`
CREATE TABLE IF NOT EXISTS `ecs_category` (
`cat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`cat_name` varchar(90) NOT NULL COMMENT '·?àà??3?',
`keywords` varchar(255) NOT NULL COMMENT '·?ààμ?1??ü×?￡??é?üê??aá????÷',
`cat_desc` varchar(255) NOT NULL COMMENT '·?àà?èê?',
`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '??·?ààμ???id￡?è??μóú??±íμ?cat_id×???',
`sort_order` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '??·?àà?úò3????ê?μ??3Dò￡?êy×???′ó?3Dò????oó￡?í?êy×?￡?id?ú?°μ??è??ê?',
`template_file` varchar(50) NOT NULL COMMENT '2?è·?¨×???￡?°′??×?oí±íéè??2?￡?ó|??ê???·?ààμ?μ￥?à?￡°????tμ???×?',
`measure_unit` varchar(15) NOT NULL COMMENT '??·?ààμ???á?μ￥??',
`show_in_nav` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ê?·???ê??úμ?o?à?￡?0￡?2?￡?1￡???ê??úμ?o?à?',
`style` varchar(150) NOT NULL COMMENT '??·?ààμ?μ￥?àμ??ùê?±íμ?°üà¨???t??2?·?μ????t?·??',
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'ê?·??ú?°ì¨ò3????ê?￡?1￡???ê?￡?0￡?2???ê?',
`grade` tinyint(4) NOT NULL DEFAULT '0' COMMENT '??·?ààμ?×???oí×?μí??????μ?????·???￡?μ±′óóú1ê±￡??á?ù?Y×?′ó×?D?????????·?3é????￡?
?á?úò3????ê?????·??§￡?è?0-300,300-600,600-900?a??',
`filter_attr` smallint(6) NOT NULL DEFAULT '0' COMMENT 'è?1???×???óD?μ￡??ò??·?àà???1?á°′?????μ??ó|?ú±ígoods_attrμ?goods_attr_id?ù??ó|μ?
ê?D?é???￡?è?￡?·a????é???óDoì￡?oú·?ààé???',
PRIMARY KEY (`cat_id`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='éì?··?àà±í￡?????éì?··?ààD??￠' AUTO_INCREMENT=9 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_collect_goods`
CREATE TABLE IF NOT EXISTS `ecs_collect_goods` (
`rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ê?2?????μ?×???id', `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '??ì?ê?2?????μ??á?±id￡?è??μóúecs_usersμ?user_id',
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?2?μ?éì?·id￡?è??μóúecs_goodsμ?goods_id',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?2?ê±??',
`is_attention` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ê?·?1?×￠??ê?2?éì?·￡?1￡?ê?￡?0￡?·?',
PRIMARY KEY (`rec_id`),
KEY `user_id` (`user_id`),
KEY `goods_id` (`goods_id`),
KEY `is_attention` (`is_attention`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='?á?±ê?2?éì?·μ?????áD±í￡?ò?ì?????ò???ê?2?éì?·' AUTO_INCREMENT=3 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_comment`
CREATE TABLE IF NOT EXISTS `ecs_comment` (
`comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ó??§?à??μ?×???id', `comment_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'ó??§?à??μ?ààDí￡?0￡??à??μ?ê?éì?·￡?1￡??à??μ?ê?????',
`id_value` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '?????ò??éì?·μ?id￡???????ó|μ?ê?ecs_article
μ?article_id￡?éì?·??ó|μ?ê?ecs_goodsμ?goods_id',
`email` varchar(60) NOT NULL COMMENT '?à??ê±ìá??μ?emailμ??·￡???è?è?μ?ecs_usersμ?email',
`user_name` varchar(60) NOT NULL COMMENT '?à?????????òéì?·μ?è?μ???3?￡?è??μecs_usersμ?user_name',
`content` text NOT NULL COMMENT '?à??μ??úèY',
`comment_rank` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '???????ò??éì?·μ?D???￡???óD1μ?5D?￡?óéêy×?′úì?￡????D5ê?′ú±í5D?',
`add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '?à??μ?ê±??',
`ip_address` varchar(15) NOT NULL COMMENT '?à??ê±μ?ó??§ip',
`status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?·?±?1üàí?±?ú×???ê?￡?1￡?ê?￡?0￡??′?ú×???ê?',
`parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '?à??μ????úμ?￡?è??μ??±íμ?comment_id×???￡?è?1???×????a0￡??òê?ò?????í¨?à??￡?·??ò??ì??à???íê???×???μ??μ?ù??ó|μ??à??μ????′',
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '·￠±í???à??μ?ó??§μ?ó??§id￡?è??μóúecs_usersμ?user_id',
PRIMARY KEY (`comment_id`),
KEY `parent_id` (`parent_id`),
KEY `id_value` (`id_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='ó??§??????oí2ú?·μ??à??áD±í' AUTO_INCREMENT=5 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_crons`
CREATE TABLE IF NOT EXISTS `ecs_crons` (
`cron_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`cron_code` varchar(20) NOT NULL COMMENT '??2??t???t?ú?àó|?·????μ?2?°üà¨''.php''2?·?μ????t??￡???DD??2??t??í¨1y??×???μ??μ?°?ò????DDμ????t',
`cron_name` varchar(120) NOT NULL COMMENT '????è???μ???3?',
`cron_desc` text COMMENT '????è???μ??èê?',
`cron_order` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'ó|??ê?ó?á?éè??????è????′DDμ??3Dòμ?￡??′μ±í?ê±′￥·￠2??è???ê±?è?′DD??ò???￡?è?1?ò??ùó|??ê?id?ú?°μ??è?′DD?Y2?è·?¨',
`cron_config` text NOT NULL COMMENT '????′?′|àíμ?êy?Yμ?êyá?μ??μ￡?ààDí￡???3?DòáD?ˉ￡?±èè?é???ììμ?è???￡???′??′DD????éì?·?ò????μ?′|àí',
`thistime` int(10) NOT NULL DEFAULT '0' COMMENT '??????è???é?′?±??′DDμ?ê±??',
`nextime` int(10) NOT NULL COMMENT '??????è?????′?±??′DDμ?ê±??',
`day` tinyint(2) NOT NULL COMMENT 'è?1???×???óD?μ￡??ò????è??????ú????μ??aò?ìì?′DD??????è???',
`week` varchar(1) NOT NULL COMMENT 'è?1???×???óD?μ￡??ò????è??????ú???üμ??aò?ìì?′DD??????è???',
`hour` varchar(2) NOT NULL COMMENT
'è?1???×???óD?μ￡??ò??????è??????ú??ììμ??a??D?ê±???′DD??????è???',
`minute` varchar(255) NOT NULL COMMENT 'è?1???×???óD?μ￡??ò??????è??????ú??D?ê±μ??a??·??ó???′DD??????è???￡???×???μ??μ?éò??à??￡?ó?????????',
`enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '??????è???ê?·??a??￡?0￡?1?±?￡?1￡??a??',
`run_once` tinyint(1) NOT NULL DEFAULT '0' COMMENT '?′DDoóê?·?1?±?￡??a??1?±?μ?òa???1μ??ù?D????',
`allow_ip` varchar(100) NOT NULL COMMENT '?êDí??DD??????è???μ?·t???÷ip',
`alow_files` varchar(255) NOT NULL COMMENT '??DD′￥·￠??????è???μ????táD±í?é?à???μ￡??a??′ú±í?ùóDDí?éμ????t???éò?',
PRIMARY KEY (`cron_id`),
KEY `nextime` (`nextime`),
KEY `enable` (`enable`),
KEY `cron_code` (`cron_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='????è???2??t°2×°????D??￠' AUTO_INCREMENT=4 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_email_list`
CREATE TABLE IF NOT EXISTS `ecs_email_list` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT COMMENT 'óê?t????μ?×???id',
`email` varchar(60) NOT NULL COMMENT 'óê?t?????ùì?μ?óê??μ??·',
`stat` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ê?·?è·è?￡??éò?ó??§è·è?ò2?éò?1üàí?±è·è?￡?0￡??′è·è?￡?1￡?ò?è·è?',
`hash` varchar(10) NOT NULL COMMENT 'óê??è·è?μ??é?¤??￡??μí3éú3éoó·￠?íμ?ó??§óê??￡?ó??§?é?¤?¤??ê±í¨1y???μ?D??ê?·?o?·¨￡??÷òaó?à′·à?1·?·¨?é?¤óê??',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='???óμ?×ó?ó??????±í' AUTO_INCREMENT=5 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_email_sendlist`
CREATE TABLE IF NOT EXISTS `ecs_email_sendlist` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT COMMENT 'óê?t·￠?í?óáD×???id',
`email` varchar(100) NOT NULL COMMENT '??óê?t??òa·￠?íμ?μ?óê??μ??·',
`template_id` mediumint(8) NOT NULL COMMENT '??óê?tμ??￡°?id￡?è??μóúecs_mail_templatesμ?template_id',
`email_content` text NOT NULL COMMENT 'óê?t·￠?íμ??úèY',
`error` tinyint(1) NOT NULL DEFAULT '0' COMMENT '′í?ó′?êy￡?2??a?éê2?′ó?μ?￡?2?ó|??ê?·￠?íóê?tμ?꧰ü????',
`pri` tinyint(10) NOT NULL COMMENT '??óê?t·￠?íμ?ó??è??￡?0￡???í¨￡?1￡???',
`last_send` int(10) NOT NULL COMMENT 'é?ò?′?·￠?íμ?ê±??',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='???ó·￠?í?óáD±í' AUTO_INCREMENT=18 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_error_log`
CREATE TABLE IF NOT EXISTS `ecs_error_log` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '????è???′í?ó×???id',
`info` varchar(255) NOT NULL COMMENT '′í?ó?ê??D??￠',
`file` varchar(100) NOT NULL COMMENT '2úéú′í?óμ??′DD???tμ??????·??',
`time` int(10) NOT NULL COMMENT '′í?ó·￠éúμ?ê±??',
PRIMARY KEY (`id`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='??±íó?à′????ò3??′￥·￠????è???ê±ê§°ü?ù2úéúμ?′í?ó￡?′ó3ìDòà′?′￡????°?÷òaê??
????3????è????ù??ó|μ?2??t???t2?′??úμ?′í?ó' AUTO_INCREMENT=1 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_favourable_activity`
CREATE TABLE IF NOT EXISTS `ecs_favourable_activity` (
`act_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ó??Y???ˉμ?×???id', `act_name` varchar(255) NOT NULL COMMENT 'ó??Y???ˉμ????ˉ??3?',
`start_time` int(10) unsigned NOT NULL COMMENT '???ˉμ??aê?ê±??',
`end_time` int(10) unsigned NOT NULL COMMENT '???ˉμ??áê?ê±??',
`user_rank` varchar(255) NOT NULL COMMENT '?éò?2??ó???ˉμ?ó??§D??￠￡?è??μóúecs_user_rankμ?rank_id￡????D0ê?·??á?±￡?????ê??àó|
μ??á?±μè??￡??à???μó??oo?·???',
`act_range` tinyint(3) unsigned NOT NULL COMMENT 'ó??Y·??§￡?0￡?è?2?éì?·￡?1￡?°′·?àà￡?2￡?°′?·??￡?3￡?°′éì?·',
`act_range_ext` varchar(255) NOT NULL COMMENT '?ù?Yó??Y???ˉ·??§μ?2?í?￡???′|òaò?2?í?￡?μ?ê???ê?ó??Y·??§μ???ê?￡?è?￡?è?1?ê?éì?·￡??
?′|ê?éì?·μ?id￡?è?1?ê??·??￡???′|ê??·??μ?id',
`min_amount` decimal(10,2) unsigned NOT NULL COMMENT '??μ￥′?μ??e?????T￡?2?2??ó???ˉ',
`max_amount` decimal(10,2) unsigned NOT NULL COMMENT '2??ó???ˉμ???μ￥?e?????T￡?0￡?±íê???óDé??T',
`act_type` tinyint(3) unsigned NOT NULL COMMENT '2??ó???ˉμ?ó??Y·?ê?￡?0￡??í?ù?·?òó??Y1o?ò￡?1￡????e???a￡?????′ò??ó??Y',
`act_type_ext` decimal(10,2) unsigned NOT NULL COMMENT 'è?1?ê??í?ù?·￡???′|ê??êDíμ?×?′óêyá?￡?0￡??Têyá??T??￡????????a￡??òê????a?e??￡?μ￥??
?a￡?′ò??￡?ê??????μ￡?100??￡?8???íê?80',
`gift` text NOT NULL COMMENT
'è?1?óDì??Yéì?·￡??aà?ê?DòáD?ˉoóμ?ì??Yéì?·μ?id,name,priceD??￠;è??μóúecs_goodsμ?go ods_id￡?goods_name￡?????ê?ìí?ó???ˉê±ì?D′μ?',
`sort_order` tinyint(3) unsigned NOT NULL COMMENT '???ˉ?úó??Y???ˉò3????ê?μ??èoó?3Dò￡?êy×???′ó????oó',
PRIMARY KEY (`act_id`),
KEY `act_name` (`act_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='ó??Y???ˉμ?????D??￠￡?ó??Y???ˉ°üà¨?íà?￡????a￡?′ò??' AUTO_INCREMENT=5 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_feedback`
CREATE TABLE IF NOT EXISTS `ecs_feedback` (
`msg_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '·′à?D??￠×???id', `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '???úμ?￡?è?×???±ímsg_id￡?·′à????μ?a0￡????′·′à??a?úμ?id',
`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '·′à?μ?ó??§μ?id',
`user_name` varchar(60) NOT NULL COMMENT '·′à?μ?ó??§μ?ó??§??',
`user_email` varchar(60) NOT NULL COMMENT '·′à?μ?ó??§μ?óê??',
`msg_title` varchar(200) NOT NULL COMMENT '·′à?μ?±êìa￡????′?areply',
`msg_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '·′à?μ?ààDí￡?0￡?á???￡?1￡?í???￡?2￡??ˉ?ê￡?3￡?ê?oó￡?4￡??ó1o',
`msg_content` text NOT NULL COMMENT '·′à?μ??úèY',
`msg_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '·′à?μ?ê±??',
`message_img` varchar(255) NOT NULL DEFAULT '0' COMMENT 'ó??§é?′?μ????tμ?μ??·', `order_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '??·′à?1?áaμ???μ￥id￡?óéó??§ìá??￡?è??μóú
ecs_order_infoμ?order_id￡?0￡??a?T?￥??￡?',
PRIMARY KEY (`msg_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='ó??§·′à?D??￠±í￡?°üà¨á???￡?í???￡?×é?ˉμè' AUTO_INCREMENT=7 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_friend_link`
CREATE TABLE IF NOT EXISTS `ecs_friend_link` (
`link_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ó??éá′?ó×???id', `link_name` varchar(255) NOT NULL COMMENT 'ó??éá′?óμ???3?￡?imgμ?altμ??úèY;',
`link_url` varchar(255) NOT NULL COMMENT 'ó??éá′?óí???μ?á′?óμ??·',
`link_logo` varchar(255) NOT NULL COMMENT 'ó??éá′?óμ?logo',
`show_order` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '?úò3??μ???ê??3Dò', PRIMARY KEY (`link_id`),
KEY `show_order` (`show_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='ó??éá′?ó????D??￠±í' AUTO_INCREMENT=3 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_goods`
CREATE TABLE IF NOT EXISTS `ecs_goods` (
`goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'éì?·μ?×???id', `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?·?ùê?éì?··?ààid￡?è??μecs_categoryμ?cat_id',
`goods_sn` varchar(60) NOT NULL COMMENT 'éì?·μ??¨ò???o?',
`goods_name` varchar(120) NOT NULL COMMENT 'éì?·μ???3?',
`goods_name_style` varchar(60) NOT NULL DEFAULT '+' COMMENT 'éì?·??3???ê?μ??ùê?￡?°üà¨??é?oí×?ì??ùê?￡???ê?è?#ff00ff+strong',
`click_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?·μ??÷êy',
`brand_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '?·??id￡?è??μóúecs_brand μ?brand_id',
`provider_name` varchar(100) NOT NULL COMMENT '1???è?μ???3?￡?3ìDò?1??êμ????1|?ü', `goods_number` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?·?a′?êyá?', `goods_weight` decimal(10,3) unsigned NOT NULL DEFAULT '0.000' COMMENT 'éì?·μ???á?￡?ò??§???aμ￥??',
`market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'êD3?ê???', `shop_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '±?μêê???', `promote_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '′ù?ú????', `promote_start_date` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '′ù?ú?????aê?è??ú',
`promote_end_date` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '′ù?ú???áê?è??ú', `warn_number` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'éì?·±¨?ˉêyá?',
`keywords` varchar(255) NOT NULL COMMENT 'éì?·1??ü×?￡?·??úéì?·ò3μ?1??ü×??D￡??a???÷òy??ê???ó?',
`goods_brief` varchar(255) NOT NULL COMMENT 'éì?·μ??ò?ì?èê?',
`goods_desc` text NOT NULL COMMENT 'éì?·μ??ê???èê?',
`goods_thumb` varchar(255) NOT NULL COMMENT 'éì?·?ú?°ì¨??ê?μ??￠??í???￡?è??ú·?ààé???ê±??ê?μ?D?í???',
`goods_img` varchar(255) NOT NULL COMMENT 'éì?·μ?êμ?ê′óD?í???￡?è???è???éì?·ò3ê±?ééüéì?·ê?D??ù??ê?μ?′óí???',
`original_img` varchar(255) NOT NULL COMMENT 'ó|??ê?é?′?μ?éì?·μ??-ê?í???',
`is_real` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'ê?·?ê?êμ??￡?1￡?ê?￡?0￡?·?￡?±èè?Dé?a?¨?í?a0￡?2?ê?êμ??',
`extension_code` varchar(30) NOT NULL COMMENT 'éì?·μ?à??1ê?D?￡?±èè???Dé?a?¨',
`is_on_sale` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '??éì?·ê?·??a·??úê?￡?1￡?ê?￡?0￡?·?',
`is_alone_sale` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'ê?·??üμ￥?à?úê?￡?1￡?ê?￡?0￡?·?￡?è?1?2??üμ￥?à?úê?￡??ò???ü×÷?a?3éì?·μ????t?ò???ù?·?
úê?',
`integral` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1o?ò??éì?·?éò?ê1ó?μ??y·?êyá?￡?1à??ó|??ê?ó??y·?′úì??e????·?￡?μ?3ìDòo????1??óDêμ?
???1|?ü',
`add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?·μ?ìí?óê±??',
`sort_order` smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT 'ó|??ê?éì?·μ???ê??3Dò￡?2?1y??°?3ìDò?D??êμ????1|?ü',
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?·ê?·?ò??-é?3y￡?0￡?·?￡?1￡?ò?é?3y',
`is_best` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?·?ê????·￡?0￡?·?￡?1￡?ê?',
`is_new` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?·?ê?D??·￡?0￡?·?￡?1￡?ê?',
`is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ê?·?èè?ú￡?0￡?·?￡?1￡?ê?', `is_promote` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT
'ê?·?ì???′ù?ú￡?0￡?·?￡?1￡?ê?',
`bonus_type_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1o?ò??éì?·?ù?üáìμ?μ?oì°üààDí',
`last_update` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '×??üò?′??üD?éì?·????μ?ê±??',
`goods_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?·?ùê?ààDíid￡?è??μ±ígoods_typeμ?cat_id',
`seller_note` varchar(255) NOT NULL COMMENT 'éì?·μ?éì?ò±?×￠￡???éì?ò?é??',
`give_integral` int(11) NOT NULL DEFAULT '-1' COMMENT '1o?ò??éì?·ê±??±ê3é1|??ò×?ù?íμ??y·?êyá??￡',
PRIMARY KEY (`goods_id`),
KEY `goods_sn` (`goods_sn`),
KEY `cat_id` (`cat_id`),
KEY `last_update` (`last_update`),
KEY `brand_id` (`brand_id`),
KEY `goods_weight` (`goods_weight`),
KEY `promote_end_date` (`promote_end_date`),
KEY `promote_start_date` (`promote_start_date`),
KEY `goods_number` (`goods_number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='éì?·±í' AUTO_INCREMENT=35 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_goods_activity`
CREATE TABLE IF NOT EXISTS `ecs_goods_activity` (
`act_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`act_name` varchar(255) NOT NULL COMMENT '′ù?ú???ˉμ???3?',
`act_desc` text NOT NULL COMMENT '′ù?ú???ˉμ??èê?',
`act_type` tinyint(3) unsigned NOT NULL,
`goods_id` mediumint(8) unsigned NOT NULL COMMENT '2??ó???ˉμ?id￡?è??μóúecs_goodsμ?goods_id',
`goods_name` varchar(255) NOT NULL COMMENT
'éì?·μ???3?￡?è??μóúecs_goodsμ?goods_id',
`start_time` int(10) unsigned NOT NULL COMMENT '???ˉ?aê?ê±??',
`end_time` int(10) unsigned NOT NULL COMMENT '???ˉ?áê?ê±??',
`is_finished` tinyint(3) unsigned NOT NULL COMMENT '???ˉê?·??áê?￡?0￡??áê?￡?1￡??′?áê?',
`ext_info` text NOT NULL COMMENT 'DòáD?ˉoóμ?′ù?ú???ˉμ?????D??￠￡?°üà¨×?μí??￡?×?????￡?3???·ù?è￡?±￡?¤?eμè',
PRIMARY KEY (`act_id`),
KEY `act_name` (`act_name`,`act_type`,`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='???????ˉoí?á±|??±????ˉ????D??￠±í' AUTO_INCREMENT=5 ;
* ------------------------------------------------------
-- ±íμ??á11 `ecs_goods_article`
CREATE TABLE IF NOT EXISTS `ecs_goods_article` (
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?·id￡?è?×?ecs_goodsμ?goods_id',
`article_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '????id￡?è?×? ecs_article μ?article_id',
`admin_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '2???ê?1üàí?±μ?id￡?μ?ê?3ìDò?D??o???óDìá?°μ?',
PRIMARY KEY (`goods_id`,`article_id`,`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='????1?áa2ú?·±í￡??′?????Dìáμ?μ??à1?2ú?·';
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_goods_attr`
CREATE TABLE IF NOT EXISTS `ecs_goods_attr` (
`goods_attr_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '????ì?ê?D?ê?óúμ?éì?·￡?è??μóúecs_goodsμ?goods_id',
`attr_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '????ì?ê?D?ê?óúμ?ê?D?ààDíμ?id￡?è?×?ecs_attribute μ?attr_id',
`attr_value` text NOT NULL COMMENT '????ì?ê?D?μ??μ',
`attr_price` varchar(255) NOT NULL COMMENT '??ê?D???ó|?úéì?·?-????é?òa?óμ?????', PRIMARY KEY (`goods_attr_id`),
KEY `goods_id` (`goods_id`),
KEY `attr_id` (`attr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='??ì?éì?·μ?ê?D?±í' AUTO_INCREMENT=62 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_goods_cat`
CREATE TABLE IF NOT EXISTS `ecs_goods_cat` (
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?·id',
`cat_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'éì?··?ààid', PRIMARY KEY (`goods_id`,`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMEN T='éì?·μ?à??1·?àà'; -- ------------------------------------------------------
-- ±íμ??á11 `ecs_goods_gallery`
CREATE TABLE IF NOT EXISTS `ecs_goods_gallery` (
`img_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'éì?·?à2á×???id', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'í???ê?óúéì?·μ?id', `img_url` varchar(255) NOT NULL COMMENT 'êμ?êí???url',
`img_desc` varchar(255) NOT NULL COMMENT 'í????μ?÷D??￠',
`thumb_url` varchar(255) NOT NULL COMMENT '?￠??í???url',
`img_original` varchar(255) NOT NULL COMMENT '?ù?Y??×?2?￡?ó|??ê?é?′?μ?í??????tμ?×??-ê?μ????tμ?url',
PRIMARY KEY (`img_id`),
KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='éì?·?à2á±í￡???3????úò3??μ?éì?·?à2á?D' AUTO_INCREMENT=23 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_goods_type`
CREATE TABLE IF NOT EXISTS `ecs_goods_type` (
`cat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '×???IDo?',
`cat_name` varchar(60) NOT NULL COMMENT 'éì?·ààDí??',
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'ààDí×′ì?￡?1￡??a?éó?￡?0?a2??éó?￡?2??éó?μ?ààDí￡??úìí?óéì?·μ?ê±oò????éì?·ê?D???2??
é??',
`attr_group` varchar(255) NOT NULL COMMENT 'éì?·ê?D?·?×é￡???ò???éì?·ààDíμ?ê?D?·?3é×é￡??ú??ê?μ?ê±oòò2ê?°′×é??ê??￡??×???μ??μ?
?ê??úê?D?μ??°ò?DD￡???±êìaμ?×÷ó?',
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='éì?·ààDí±í￡???±í??ì??????íê?ò???éì?·ààDí' AUTO_INCREMENT=10 ;
-- ------------------------------------------------------
-- ±íμ??á11 `ecs_group_goods`
CREATE TABLE IF NOT EXISTS `ecs_group_goods` (
`parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '??éì?·id',
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '???téì?·id',
`goods_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '???téì?·μ?????',
`admin_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'ìí?ó?????tμ?1üàí?±μ?id',
ecshop留言板添加一项必填项-联系人 一、首先要为你的数据库的ecs_comment增加一个字段以存储联系人姓名： 可以直接在后台-->数据库管理--->SQL查询里里直接执行以下sql语句: alter table ecs_comment add contact varchar(60) not null default ''; 此处注意，这条sql语句中的表前缀ecs_要和你网站的前缀一致，不然会报错，如果你不知道你ecshop网站的数据表前缀. 二： 步骤1. 更改文件message_board.dwt