22 lines
833 B
Lua
22 lines
833 B
Lua
require("fwutils.webapi")
|
|
-- CREATE TABLE `fw_role` (
|
|
-- `id` int NOT NULL AUTO_INCREMENT,
|
|
-- `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
|
|
-- `sort` int DEFAULT NULL COMMENT '排序',
|
|
-- `desc` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
|
|
-- `create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
-- `default_filepath` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '默认页面',
|
|
-- PRIMARY KEY (`id`)
|
|
-- ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
local M = {}
|
|
|
|
|
|
|
|
function M.list(search,limit,conn)
|
|
return query_model_ex(conn,"fw_role",{},limit.start,limit.length,function(sel)
|
|
end,function(sel_data)
|
|
sel_data:orderby("`sort` DESC")
|
|
end)
|
|
end
|
|
|
|
return M |