3、电视商城之mysql数据库设计以及sql语句
);create table consignee_management
(
consignee_id int not null auto_increment,
user_id int comment '1.普通用户
2.管理员',
consignee_name varchar(50),
consignee_address varchar(1000),
consignee_code varchar(10),
consignee_phone varchar(11),
primary key (consignee_id)
);
create table goods_info
(
goods_id int not null auto_increment,
goods_name varchar(200),
goods_price double,
goods_url varchar(1000),
goods_desc varchar(2000),
页:
[1]