mysql 建表语句模板

create table t9
(
   goodsid int unsigned not null comment '商品ID',
   classid int unsigned  not null comment '分类ID',
   goodsname varchar(20) not null comment '商品名称',
   is_stop tinyint unsigned  not null comment '是否停用 1停用 0 正常',
   primary key pk_goodsid(goodsid),
   unique key uk_name(goodsname),
   key idx_classid_goodsid(classid,goodsid)
)  engine = innodb default charset = utf8 comment = '商品表'

其中一些规范，可参见阿里的规范 https://www.jianshu.com/p/991b1bdf7f20