商城 mysql语句_简单商城的数据库建表sql

CREATE TABLE `product_info` (

`product_id` VARCHAR(32) NOT NULL,

`product_name` VARCHAR(64) NOT NULL COMMENT '商品名称',

`product_price` DECIMAL(8,2) NOT NULL COMMENT '单价',

`product_stock` INT(11) NOT NULL COMMENT '库存',

`product_description` VARCHAR(64) NOT NULL COMMENT '描述',

`product_icon` VARCHAR(512) NOT NULL COMMENT '小图',

`category_type` VARCHAR(512) NOT NULL COMMENT '类目编号',

`create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`update_time` TIMESTAMP NULL DEFAULT NULL COMMENT '修改时间',

PRIMARY KEY (`product_id`)

)

COMMENT='商品表'

COLLATE='latin1_swedish_ci'

ENGINE=InnoDB;

CREATE TABLE `procuct_category` (

&#