lccsw
15 lines
769 B
SQL
15 lines
769 B
SQL
-- ----------------------------
|
|
-- Title:订单精品
|
|
-- Author:lcc
|
|
-- Table:lc_receiver_fine
|
|
-- ---------------------------
|
|
create table lc_receiver_fine (
|
|
id int(10) not null auto_increment comment '自增id',
|
|
title varchar(50) not null default '' comment '标题',
|
|
price decimal(10,2) not null default '0.00' comment '价格',
|
|
status tinyint(1) not null default '0' comment '状态(1开启 0关闭 -1删除)',
|
|
u_time timestamp not null default current_timestamp on update current_timestamp comment '更新时间',
|
|
c_time int(10) not null default '0' comment '创建时间',
|
|
primary key (id)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 comment='订单精品'
|