ecshop数据库详细分析

»¨ÁË2ÖܶàµÄʱ¼ä°ÑecshopµÄÊý¾Ý¿â±í·ÖÎöÁËÏ£¬ecshop°æ±¾2.6.0¡£

2.6Óбí74¸ö 2.7µ±ÖÐÓÐ86¸ö±í

ÈçÓÐç¢Â©»òÕß´íÎóµÄµØ·½»¶Ó-´ó¼ÒÌí¼Ó£¬Ö¸Õý£¬Ð»Ð»£¡

±¾ÎĽ«³ÖÐø¸üÐÂ

×îеÄ2.7µ±ÖжàÁË¡ªad_custom /_affiliate_logµÈ±í Ï£Íû´ó¼Ò¸ú½ø

-- phpMyAdmin SQL Dump

-- version 3.0.0-rc2

--

-- Ö÷»ú: localhost

-- Éú³ÉÈÕÆÚ: 2008 Äê 11 Ô 14 ÈÕ 17:12

-- ·þÎñÆ÷°æ±¾: 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 */;

Êý¾Ý¿â: `ecshop`

-- ------------------------------------------------------

-- ±íµÄ½á¹¹ `ecs_account_log`

CREATE TABLE IF NOT EXISTS `ecs_account_log` (

`log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '×ÔÔöIDºÅ',

`user_id` mediumint(8) unsigned NOT NULL COMMENT 'Óû§µÇ¼ºó±£´æÔÚsessionÖеÄidºÅ£¬¸úusers±íÖеÄuser_id¶ÔÓ¦',

`user_money` decimal(10,2) NOT NULL COMMENT 'Óû§¸Ã±Ê¼Ç¼µÄÓà¶î',

`frozen_money` decimal(10,2) NOT NULL COMMENT '±»¶³½áµÄ×ʽð',

`rank_points` mediumint(9) NOT NULL COMMENT 'µÈ¼¶»ý·Ö£¬¸úÏû·Ñ»ý·ÖÊÇ·Ö¿ªµÄ',

`pay_points` mediumint(9) NOT NULL COMMENT 'Ïû·Ñ»ý·Ö£¬¸úµÈ¼¶»ý·ÖÊÇ·Ö¿ªµÄ',

`change_time` int(10) unsigned NOT NULL COMMENT '¸Ã±Ê²Ù×÷·¢ÉúµÄʱ¼ä',

`change_desc` varchar(255) NOT NULL COMMENT '¸Ã±Ê²Ù×÷µÄ±¸×¢£¬Ò»°ãÊÇ£¬³äÖµ»òÕßÌáÏÖ¡£Ò²¿ÉÊÇÊǹÜÀíÔ±ºǫ́дµÄÈκÎÔÚ±¸×¢',

`change_type` tinyint(3) unsigned NOT NULL COMMENT '²Ù×÷ÀàÐÍ£¬0Ϊ³äÖµ£¬1ΪÌáÏÖ£¬2Ϊ¹ÜÀíÔ±µ÷½Ú£¬99ΪÆäËûÀàÐÍ',

PRIMARY KEY (`log_id`),

KEY `user_id` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Óû§ÕʺÅÇé¿ö¼Ç¼±í£¬°üÀ¨×ʽðºÍ»ý·ÖµÈ' AUTO_INCREMENT=42 ;

-- ------------------------------------------------------

-- ±íµÄ½á¹¹ `ecs_ad`

CREATE TABLE IF NOT EXISTS `ecs_ad` (

`ad_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '×ÔÔöIDºÅ',

`position_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '0,Õ¾Íâ¹ã¸æ£»´Ó1¿ªÊ¼´ú±íµÄÊǸùã¸æËù´¦µÄ¹ã¸æλ£¬Í¬±íad_positionÖеÄ×Ö¶Îposition_

idµÄÖµ',

`media_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '¹ã¸æÀàÐÍ£¬0£¬Í¼Æ¬£»1£¬flash;2,´úÂ룻3£¬ÎÄ×Ö',

`ad_name` varchar(60) NOT NULL COMMENT '¸ÃÌõ¹ã¸æ¼Ç¼µÄ¹ã¸æÃû³Æ',

`ad_link` varchar(255) NOT NULL COMMENT '¹ã¸æÁ´½ÓµØÖ·',

`ad_code` text NOT NULL COMMENT '¹ã¸æÁ´½ÓµÄ±íÏÖ£¬ÎÄ×Ö¹ã¸æ¾ÍÊÇÎÄ×Ö»òͼƬºÍflash¾ÍÊÇËüÃǵĵØÖ·£¬´úÂë¹ã¸æ¾ÍÊÇ´úÂëÄÚ

ÈÝ',

`start_time` int(11) NOT NULL DEFAULT '0' COMMENT '¹ã¸æ¿ªÊ¼Ê±¼ä',

`end_time` int(11) NOT NULL DEFAULT '0' COMMENT '¹ã¸æ½áÊøʱ¼ä',

`link_man` varchar(60) NOT NULL COMMENT '¹ã¸æÁªÏµÈË',

`link_email` varchar(60) NOT NULL COMMENT '¹ã¸æÁªÏµÈ˵ÄÓÊÏä',

`link_phone` varchar(60) NOT NULL COMMENT '¹ã¸æÁªÏµÈ˵ĵ绰',

`click_count` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '¸Ã¹ã¸æµã»÷Êý', `enabled` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '¸Ã¹ã¸æÊÇ·ñ¹Ø±Õ£¬1£¬¿ªÆô£»0£¬¹Ø±Õ£»¹Ø±Õºó¹ã¸æ½«²»ÔÙÓÐЧ£¬Ö±ÖÁÖØпªÆô',

PRIMARY KEY (`ad_id`),

KEY `position_id` (`position_id`),

KEY `enabled` (`enabled`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='¹ã¸æÁбíÅäÖÃ±í£¬°üÀ¨Õ¾ÄÚÕ¾ÍâµÄͼƬ£¬ÎÄ×Ö£¬flash£¬´úÂë¹ã¸æ'

AUTO_INCREMENT=6 ;

-- ------------------------------------------------------

-- ±íµÄ½á¹¹ `ecs_admin_action`

CREATE TABLE IF NOT EXISTS `ecs_admin_action` (

`action_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '×ÔÔöIDºÅ',

`parent_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '¸ÃidÏîµÄ¸¸id£¬¶ÔÓ¦±¾±íµÄaction_id×Ö¶Î',

`action_code` varchar(20) NOT NULL COMMENT '´ú±íȨÏÞµÄÓ¢ÎÄ×Ö·û´®£¬¶ÔÓ¦ººÎÄÔÚÓïÑÔÎļþÖУ¬Èç¹û¸Ã×Ö¶ÎÓÐij¸ö×Ö·û´®£¬¾Í±íʾÓиÃÈ

¨ÏÞ',

PRIMARY KEY (`action_id`),

KEY `parent_id` (`parent_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='¹ÜÀíԱȨÏÞÁбíÊ÷' AUTO_INCREMENT=104 ;