CREATE TABLE `book_cat` (
`
id
` int(11) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT
'0'
COMMENT
'父类id'
,
`name` varchar(50) NOT NULL DEFAULT
''
COMMENT
'类别名称'
,
`weight` tinyint(4) NOT NULL DEFAULT
'1'
COMMENT
'权重'
,
`status` tinyint(1) NOT NULL DEFAULT
'1'
COMMENT
'状态 1:有效 0:无效'
,
`updated_time` timestamp NOT NULL DEFAULT
'0000-00-00 00:00:00'
COMMENT
'最后一次更新时间'
,
`created_time` timestamp NOT NULL DEFAULT
'0000-00-00 00:00:00'
COMMENT
'插入时间'
,
PRIMARY KEY (`
id
`),
UNIQUE KEY `idx_name` (`
id
`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=
'书籍分类'
;