表备注在Schema中如何执行?不是列备注
在Migration里面创建表时如何给表备注???
CREATE TABLE
PRIMARY KEY (
KEY
KEY
KEY
) ENGINE=InnoDB AUTO_INCREMENT=3248 DEFAULT CHARSET=utf8 COMMENT='城市';
CREATE TABLE
t_city(
idint(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
namevarchar(255) NOT NULL DEFAULT '' COMMENT '名称|required',
deepsmallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '层级/hide',
parent_idint(10) unsigned NOT NULL DEFAULT '0' COMMENT '父id|number/tree',
lftint(10) unsigned NOT NULL DEFAULT '0' COMMENT '左边界/hide',
rghtint(10) unsigned NOT NULL DEFAULT '0' COMMENT '右边界/hide',
ctimeint(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间/time',
utimeint(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间/time',
statustinyint(3) NOT NULL DEFAULT '1' COMMENT '状态:0-已删除,1-正常,2-不显示',
PRIMARY KEY (
id),
KEY
status(
status),
KEY
lft, rght(
lft,
rght),
KEY
deep(
deep)
) ENGINE=InnoDB AUTO_INCREMENT=3248 DEFAULT CHARSET=utf8 COMMENT='城市';
0 个回复