首页 > 代码库 > 模仿ecshop建立木瓜商城数据库(MySQL)

模仿ecshop建立木瓜商城数据库(MySQL)

1. 安装ecshop(打开gd扩展)

2. 使用图形化界面工具,如phpmyadmin查看数据。(以前用命令行,主要锻炼代码熟练度!)

 

# 建木瓜库

create database mugua charset utf8;

 

# 选中木瓜

use mugua;

 

# 创建商品表(创建的字段应和ecshop里的一样,并且一一对应)

create table goods(
goods_id int primary key auto_increment,
cat_id smallint not null default 0,
goods_sn char(15) not null default ‘‘,
goods_name varchar(30) not null default ‘‘,
click_count mediumint unsigned not null default 0,
brand_id smallint not null default 0,
goods_number smallint not null default 0,
market_price decimal(7, 2) not null default 0.00,
shop_price decimal(7,2) not null default 0.00,
add_time int unsigned not null default 0
)charset utf8;

 

# 把ec的商品数据导入到木瓜库

insert into mugua.goods
select
goods_id, cat_id, goods_sn, goods_name, click_count,
brand_id, goods_number, market_price,
shop_price,
add_time
from shop.goods;

 

# 创建类目表

create table category(
cat_id smallint primary key auto_increment,
cat_name varchar(30) not null default ‘‘,
parent_id smallint not null default 0
)charset utf8;

 

# 把ec的类目数据导入到木瓜库

insert into mugua.category
select
cat_id, cat_name, parent_id
from shop.category;

 

# 创建品牌表

create table brand(
brand_id smallint primary key auto_increment,
brand_name varchar(30) not null default ‘‘
)charset utf8;

 

# 把ec的品牌数据导入到木瓜库

insert into mugua.brand
select
brand_id, brand_name
from shop.brand;

 

模仿ecshop建立木瓜商城数据库(MySQL)