GitLab

数据库：ucs

表名：trusted_category

sql：

# 可信商家-商品分类表
CREATE TABLE `trusted_category`(
	`id` int(11) PRIMARY KEY AUTO_INCREMENT,
	`cate_name` varchar(50) DEFAULT '' NOT NULL COMMENT '分类名',
	`p_id` int(11) DEFAULT 0 NOT NULL COMMENT '父级ID',
	`create_time` timestamp not null default current_timestamp,
	`last_update_time` timestamp not null default current_timestamp on update current_timestamp
)engine =InnoDB default charset =utf8;
ALTER TABLE trusted_category COMMENT = '可信商家-商品分类表';