ECShop是一款基于PHP语言开发的开源电子商务系统,其数据库结构设计用于存储和管理电子商务网站的各种数据。以下是ECShop数据库的主要结构说明:
以ecs_goods
商品表为例,其结构大致如下:
CREATE TABLE `ecs_goods` (
`goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`cat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`goods_sn` varchar(20) NOT NULL DEFAULT '',
`goods_name` varchar(120) NOT NULL DEFAULT '',
`goods_name_style` varchar(64) NOT NULL DEFAULT '',
`brand_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`provider_name` varchar(120) NOT NULL DEFAULT '',
`goods_number` smallint(5) unsigned NOT NULL DEFAULT '0',
`goods_weight` decimal(10,2) NOT NULL DEFAULT '0.00',
`market_price` decimal(10,2) NOT NULL DEFAULT '0.00',
`shop_price` decimal(10,2) NOT NULL DEFAULT '0.00',
`promote_price` decimal(10,2) NOT NULL DEFAULT '0.00',
`promote_start_date` int(10) unsigned NOT NULL DEFAULT '0',
`promote_end_date` int(10) unsigned NOT NULL DEFAULT '0',
`warn_number` smallint(5) unsigned NOT NULL DEFAULT '10',
`keywords` varchar(60) NOT NULL DEFAULT '',
`goods_brief` varchar(255) NOT NULL DEFAULT '',
`goods_thumb` varchar(255) NOT NULL DEFAULT '',
`goods_img` varchar(255) NOT NULL DEFAULT '',
`original_img` varchar(255) NOT NULL DEFAULT '',
`is_real` tinyint(1) unsigned NOT NULL DEFAULT '1',
`extension_code` varchar(30) NOT NULL DEFAULT '',
`is_on_sale` tinyint(1) unsigned NOT NULL DEFAULT '1',
`is_alone_sale` tinyint(1) unsigned NOT NULL DEFAULT '1',
`is_shipping` tinyint(1) unsigned NOT NULL DEFAULT '1',
`integral` smallint(5) unsigned NOT NULL DEFAULT '0',
`add_time` int(10) unsigned NOT NULL DEFAULT '0',
`sort_order` smallint(5) unsigned NOT NULL DEFAULT '50',
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_best` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_new` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_promote` tinyint(1) unsigned NOT NULL DEFAULT '0',
`bonus_type_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`last_update` int(10) unsigned NOT NULL DEFAULT '0',
`goods_type` smallint(5) unsigned NOT NULL DEFAULT '0',
`seller_note` varchar(255) NOT NULL DEFAULT '',
`give_integral` smallint(5) unsigned NOT NULL DEFAULT '0',
`rank_integral` smallint(5) unsigned NOT NULL DEFAULT '0',
`suppliers_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`is_check` tinyint(1) unsigned NOT NULL DEFAULT '0',
`tb_iid` bigint(20) unsigned NOT NULL DEFAULT '0',
`tb_data` text NOT NULL,
PRIMARY KEY (`goods_id`),
KEY `cat_id` (`cat_id`),
KEY `brand_id` (`brand_id`),
KEY `goods_sn` (`goods_sn`),
KEY `goods_name` (`goods_name`),
KEY `is_on_sale` (`is_on_sale`),
KEY `is_alone_sale` (`is_alone_sale`),
KEY `is_shipping` (`is_shipping`),
KEY `is_delete` (`is_delete`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ecs_config.php
文件中的数据库配置信息,确保数据库地址、用户名、密码和数据库名正确无误。同时,确保数据库服务器正常运行,并且防火墙允许访问。uploads
目录的权限,确保Web服务器有写入权限。同时,检查ecs_admin
配置文件中的图片上传路径是否正确。通过以上信息,您可以更好地了解ECShop的数据库结构及其相关应用。如果有更多具体问题,可以进一步咨询或查阅相关文档。
领取专属 10元无门槛券
手把手带您无忧上云