11 lines
508 B
MySQL
11 lines
508 B
MySQL
|
CREATE TABLE `ufutx_library`(
|
||
|
|
`id` BIGINT NOT NULL AUTO_INCREMENT ,
|
||
|
|
`category_id` int NOT null COMMENT "类别id",
|
||
|
|
`icon` varchar(255) NOT null COMMENT "图标",
|
||
|
|
`name` varchar(255) NOT null COMMENT "文件名",
|
||
|
|
`path` varchar(255) NOT null COMMENT "文件地址",
|
||
|
|
`role_id` varchar(255) NOT NULL COMMENT "授权角色",
|
||
|
|
`created_at` TIMESTAMP NULL DEFAULT NULL ,
|
||
|
|
`updated_at` TIMESTAMP NULL DEFAULT NULL ,
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE = InnoDB COMMENT = '资料库表';
|