ecshop数据库详细分析

本文格式为Word版，下载可任意编辑——ecshop数据库详细分析?¨á?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μè±í?￡í?′ó?ò?ú??--phpMyAdminSQLDump--version3.0.0-rc2

--http://.

--?÷?ú:localhost

--éú3éè??ú:2023?ê11??14è?17:12--·t???÷°?±?:5.1.29--PHP°?±?:5.2.6

SETSQL_MODE=\

/*!40101SET@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT*/;/*!40101SET@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS*/;/*!40101SET@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION*/;/*!40101SETNAMESutf8*/;

êy?Y?a:`ecshop`

----±íμ??á11`ecs_account_log`

CREATETABLEIFNOTEXISTS`ecs_account_log`(

`log_id`mediumint(8)unsignedNOTNULLAUTO_INCREMENTCOMMENT'×???IDo?',`user_id`mediumint(8)unsignedNOTNULLCOMMENT'ó??§μ???oó±￡′??úsession?Dμ?ido?￡??úusers±í?Dμ?user_id??ó|',`user_money`decimal(10,2)NOTNULLCOMMENT'ó??§??±ê????μ?óà??',`frozen_money`decimal(10,2)NOTNULLCOMMENT'±??3?áμ?×ê?e',

`rank_points`mediumint(9)NOTNULLCOMMENT'μè???y·?￡??ú??·??y·?ê?·??aμ?',`pay_points`mediumint(9)NOTNULLCOMMENT'??·??y·?￡??úμè???y·?ê?·??aμ?',`change_time`int(10)unsignedNOTNULLCOMMENT'??±ê2ù×÷·￠éúμ?ê±??',`change_desc`varchar(255)NOTNULL`change_type`tinyint(3)unsignedNOT

'2ù×÷ààDí￡?0?a3??μ￡?1?aìá??￡?2?a1üàí?±μ÷?ú￡?99?a????ààDí',PRIMARYKEY(`log_id`),KEY`user_id`(`user_id`)

)ENGINE=MyISAMDEFAULTCHARSET=utf8ROW_FORMAT=DYNAMICCOMMENT='ó??§?êo??é??????±í￡?°üà¨×ê?eoí?y·?μè'AUTO_INCREMENT=42;

NULL

COMMENTCOMMENT

'??±ê2ù×÷μ?±?×￠￡?ò?°?ê?￡?3??μ?ò??ìá???￡ò2?éê?ê?1üàí?±oóì¨D′μ?è?o??ú±?×￠',

--

--±íμ??á11`ecs_ad`

CREATETABLEIFNOTEXISTS`ecs_ad`(

`ad_id`smallint(5)unsignedNOTNULLAUTO_INCREMENTCOMMENT'×???IDo?',

`position_id`smallint(5)unsignedNOTNULLDEFAULT'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)NOTNULLCOMMENT'??ì?1???????μ?1?????3?',`ad_link`varchar(255)NOTNULLCOMMENT'1???á′?óμ??·',

`ad_code`textNOTNULLCOMMENT'1???á′?óμ?±í??￡???×?1????íê???×??òí???oíflash?íê??ü??μ?μ??·￡?′ú??1????íê?′ú???úèY',

`start_time`int(11)NOTNULLDEFAULT'0'COMMENT'1????aê?ê±??',`end_time`int(11)NOTNULLDEFAULT'0'COMMENT'1????áê?ê±??',`link_man`varchar(60)NOTNULLCOMMENT'1???áa?μè?',

`link_email`varchar(60)NOTNULLCOMMENT'1???áa?μè?μ?óê??',

`link_phone`varchar(60)NOTNULLCOMMENT'1???áa?μè?μ?μ??°',

`click_count`mediumint(8)unsignedNOTNULLDEFAULT'0'COMMENT'??1???μ??÷êy',`enabled`tinyint(3)unsignedNOTNULLDEFAULT'1'COMMENT'??1???ê?·?1?±?￡?1￡??a??￡?0￡?1?±?￡?1?±?oó1?????2??ùóDD§￡??±?á??D??a??',PRIMARYKEY(`ad_id`),

KEY`position_id`(`position_id`),KEY`enabled`(`enabled`))ENGINE=MyISAMDEFAULT

CHARSET=utf8

ROW_FORMAT=DYNAMIC

COMMENT='1???áD±í????±í￡?°üà¨???ú??íaμ?í???￡???×?￡?flash￡?′ú??1???'AUTO_INCREMENT=6;

----±íμ??á11`ecs_admin_action`

CREATETABLEIFNOTEXISTS`ecs_admin_action`(

`action_id`tinyint(3)unsignedNOTNULLAUTO_INCREMENTCOMMENT'×???IDo?',`parent_id`tinyint(3)unsignedNOTNULLDEFAULT'0'COMMENT'??id??μ???id￡???ó|±?±íμ?action_id×???',

`action_code`varchar(20)NOTNULLCOMMENT'′ú±íè¨?Tμ?ó￠??×?·?′?￡???ó|oo???úó??????t?D￡?è?1???×???óD?3??×?·?′?￡??í±íê?óD??è¨?T',

PRIMARYKEY(`action_id`),

KEY`parent_id`(`parent_id`))ENGINE=MyISAMDEFAULTCHARSET=utf8ROW_FORMAT=DYNAMICCOMMENT='1üàí?±è¨?TáD±íê÷'AUTO_INCREMENT=104;

--

--±íμ??á11`ecs_admin_log`

CREATETABLEIFNOTEXISTS`ecs_admin_log`(

`log_id`int(10)unsignedNOTNULLAUTO_INCREMENTCOMMENT'×???IDo?',`log_time`int(10)unsignedNOTNULLDEFAULT'0'COMMENT'D′è???ê±??',`user_id`

tinyint(3)

unsigned

NOT

NULL

DEFAULT

'0'

COMMENT

'??è????ù????μ?2ù×÷??id￡?í?ecs_admin_userμ?user_id',`log_info`varchar(255)NOTNULLCOMMENT'1üàí2ù×÷?úèY',`ip_address`varchar(15)NOTNULLCOMMENT'1üàí??μ???ip',PRIMARYKEY(`log_id`),KEY`log_time`(`log_time`),KEY`user_id`(`user_id`)

)ENGINE=MyISAMDEFAULTCHARSET=utf8ROW_FORMAT=DYNAMICCOMMENT='1üàí?±2ù×÷è???±í'AUTO_INCREMENT=158;

----±íμ??á11`ecs_admin_message`

CREATETABLEIFNOTEXISTS`ecs_admin_message`(

`message_id`smallint(5)unsignedNOTNULLAUTO_INCREMENTCOMMENT'×???IDo?',`sender_id`tinyint(3)unsignedNOTNULLDEFAULT'0'COMMENT'·￠?í??á???μ?1üàí?±id￡?í?ecs_admin_userμ?user_id',`receiver_id`tinyint(3)unsignedNOTNULL

DEFAULT

'0'

COMMENT

'?óê????￠μ?1üàí?±id￡?í?ecs_admin_userμ?user_id￡?è?1?ê????à??1üàí?±·￠?í￡??òí?ò??????￠??????1üàí?±id·￠?íò?ì?',

`sent_time`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'á???·￠?íê±??',`read_time`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'á??????áê±??',`readed`tinyint(1)unsignedNOTNULLDEFAULT'0'COMMENT'á???ê?·????á￡?1￡?ò????á￡?0￡??′???á',`deleted`tinyint(1)unsignedNOT

NULL

DEFAULT

'0'

COMMENT

'á???ê?·?ò??-ê?·?ò??-±?é?3y￡?1￡?ò?é?3y￡?0￡??′é?3y',`title`varchar(150)NOTNULLCOMMENT'á???μ??÷ìa',`message`textNOTNULLCOMMENT'á???μ??úèY',PRIMARYKEY(`message_id`),

KEY`sender_id`(`sender_id`,`receiver_id`),

KEY`receiver_id`(`receiver_id`))ENGINE=MyISAMDEFAULTCHARSET=utf8ROW_FORMAT=DYNAMICCOMMENT='1üàí?±á???????±í'AUTO_INCREMENT=7;

--

--±íμ??á11`ecs_admin_user`

CREATETABLEIFNOTEXISTS`ecs_admin_user`(`user_id`smallint(5)'×???IDo?￡?1üàí?±′úo?',

unsigned

NOT

NULL

AUTO_INCREMENT

COMMENT

`user_name`varchar(60)NOTNULLCOMMENT'1üàí?±μ?????',`email`varchar(60)NOTNULLCOMMENT'1üàí?±óê??',

`password`varchar(32)NOTNULLCOMMENT'1üàí?±μ??????ü?ó?ü′?',

`add_time`int(11)NOTNULLDEFAULT'0'COMMENT'1üàí?±ìí?óê±??',

`last_login`int(11)NOTNULLDEFAULT'0'COMMENT'1üàí?±×?oóò?′?μ???ê±??',`last_ip`varchar(15)NOTNULLCOMMENT'1üàí?±×?oóò?′?μ???ip',`action_list`textNOTNULLCOMMENT'1üàí?±1üàíè¨?TáD±í',`nav_list`textNOTNULLCOMMENT'1üàí?±μ?o?à???????',`lang_type`varchar(50)NOTNULL,`agency_id`smallint(5)unsignedNOT

NULLCOMMENT

'??1üàí?±?o?eμ?°ìê?′|μ?id￡?í?ecs_agencyμ?agency_id×????￡è?1?1üàí?±???o?e°ìê?′|￡??ò′?′|?a0',

`todolist`longtextCOMMENT'??ê?±?????μ?êy?Y',PRIMARYKEY(`user_id`),

KEY`user_name`(`user_name`),KEY`agency_id`(`agency_id`)

)ENGINE=MyISAMDEFAULTCHARSET=utf8COMMENT='1üàí?±×êá?è¨?TáD±í'AUTO_INCREMENT=4;

----±íμ??á11`ecs_adsense`

CREATETABLEIFNOTEXISTS`ecs_adsense`(

`from_ad`smallint(5)NOTNULLDEFAULT'1???′úo?￡?-1ê???ía1???￡?è?1?ê????ú1????ò?aecs_adμ?ad_id',

'0'

COMMENT

ROW_FORMAT=DYNAMIC

`referer`varchar(255)NOTNULLCOMMENT'ò3??à′?′',

`clicks`int(10)unsignedNOTNULLDEFAULT'0'COMMENT'μ??÷?ê',KEY`from_ad`(`from_ad`)

)ENGINE=MyISAMDEFAULTCOMMENT='1???μ??÷?êí3??±í';

CHARSET=utf8

ROW_FORMAT=DYNAMIC

----±íμ??á11`ecs_ad_position`

CREATETABLEIFNOTEXISTS`ecs_ad_position`(

`position_id`tinyint(3)unsignedNOTNULLAUTO_INCREMENTCOMMENT'1?????×???id',

`position_name`varchar(60)NOTNULLCOMMENT'1???????3?',

`ad_width`smallint(5)unsignedNOTNULLDEFAULT'0'COMMENT'1??????í?è',`ad_height`smallint(5)unsignedNOTNULLDEFAULT'0'COMMENT'1????????è',`position_desc`varchar(255)NOTNULLCOMMENT'1??????èê?',`position_style`textNOTNULLCOMMENT'1??????￡°?′ú??',

PRIMARYKEY(`position_id`)

)ENGINE=MyISAMDEFAULTCHARSET=utf8ROW_FORMAT=DYNAMICCOMMENT='1???????????±í'AUTO_INCREMENT=2;

----±íμ??á11`ecs_affiliate_log`

CREATETABLEIFNOTEXISTS`ecs_affiliate_log`(`log_id`mediumint(8)NOTNULLAUTO_INCREMENT,`order_id`mediumint(8)NOTNULL,`time`int(10)NOTNULL,

`user_id`mediumint(8)NOTNULL,

`user_name`varchar(60)DEFAULTNULL,

`money`decimal(10,2)NOTNULLDEFAULT'0.00',`point`int(10)NOTNULLDEFAULT'0',

`separate_type`tinyint(1)NOTNULLDE