box-server/dev/modules/user.lua

local root = class("moduleUser", require("base.baseModule"))

function root:ctor(uid)
    root.super.ctor(self, uid, "user", "uid", true)
    self.uid = uid
end

function root:mysql_get_init_columns()
    return {
        uid = "int(11) unsigned NOT NULL",
        nickname = "varchar(50)",
        password = "varchar(45) DEFAULT NULL",
        uuid = "varchar(200) DEFAULT NULL",
        udid = "varchar(200) DEFAULT NULL",
        channel = "int(11) DEFAULT NULL",
        device = "varchar(45) DEFAULT NULL",
        loginTime = "int(11) DEFAULT 0",
        sysVer = "varchar(1024) DEFAULT NULL",
        version = "varchar(45) DEFAULT NULL",
        appVersion = "varchar(45) DEFAULT NULL",
        deviceId = "varchar(200) DEFAULT NULL",
        headUrl = "varchar(500) DEFAULT NULL",
        sex = "int(11) DEFAULT NULL",
        token = "varchar(255)",
        lastLoginTime = "int(11) DEFAULT 0",
        logoutTime = "int(11) DEFAULT 0",
        registerTime = "int(11) DEFAULT 0 COMMENT '注册时间'",
        registerVersion = "varchar(45) DEFAULT NULL COMMENT '注册版本'",
        ip = "varchar(45) DEFAULT NULL COMMENT 'IP'",
        status = "int(11) DEFAULT 0 COMMENT '账号状态 0:正常 1:封号 2:注销'"
    }
end

----------------------------------------
-- 接口
----------------------------------------
-- 获取自己的信息
function root:itf_get_info(role, msg)
    local items = self:redis_get_key_info("itemList")
    return code.OK, {items = items}
end

return root