260 lines
11 KiB
Go
260 lines
11 KiB
Go
package table
|
||
|
||
import (
|
||
"database/sql/driver"
|
||
"fmt"
|
||
"time"
|
||
)
|
||
|
||
const (
|
||
//发送文本消息
|
||
MYSQL_BUSINESS_TYPE_SENDTEXTMSG = "SendTextMessage"
|
||
//发送图片信息
|
||
MYSQL_BUSINESS_TYPE_SENDIMGMSG = "SendImageMessage"
|
||
)
|
||
|
||
type LocalTime struct {
|
||
time.Time
|
||
}
|
||
|
||
// MarshalJSON on LocalTime format Time field with %Y-%m-%d %H:%M:%S
|
||
func (t LocalTime) MarshalJSON() ([]byte, error) {
|
||
formatted := fmt.Sprintf("\"%s\"", t.Format("2006-01-02 15:04:05"))
|
||
return []byte(formatted), nil
|
||
}
|
||
|
||
// Value insert timestamp into mysql need this function.
|
||
func (t LocalTime) Value() (driver.Value, error) {
|
||
var zeroTime time.Time
|
||
if t.Time.UnixNano() == zeroTime.UnixNano() {
|
||
return nil, nil
|
||
}
|
||
return t.Time, nil
|
||
}
|
||
|
||
// Scan valueof time.Time
|
||
func (t *LocalTime) Scan(v interface{}) error {
|
||
switch v.(type) {
|
||
case []byte:
|
||
timeBytes, ok := v.([]byte)
|
||
if ok {
|
||
todayZero, _ := time.ParseInLocation("2006-01-02 15:04:05", string(timeBytes), time.Local)
|
||
*t = LocalTime{Time: todayZero}
|
||
return nil
|
||
}
|
||
case time.Time:
|
||
value, ok := v.(time.Time)
|
||
if ok {
|
||
*t = LocalTime{Time: value}
|
||
return nil
|
||
}
|
||
|
||
}
|
||
|
||
return fmt.Errorf("can not convert %v to timestamp", v)
|
||
}
|
||
|
||
func NewLocalTime() *LocalTime {
|
||
return &LocalTime{time.Now()}
|
||
}
|
||
|
||
type CdnSnsImageInfo struct {
|
||
Ver uint32
|
||
Seq uint32
|
||
RetCode uint32
|
||
FileKey string
|
||
RecvLen uint32
|
||
FileURL string
|
||
ThumbURL string
|
||
EnableQuic uint32
|
||
RetrySec uint32
|
||
IsRetry uint32
|
||
IsOverLoad uint32
|
||
IsGetCDN uint32
|
||
XClientIP string
|
||
ImageMD5 string `gorm:"primary_key"`
|
||
ImageWidth uint32
|
||
ImageHeight uint32
|
||
}
|
||
|
||
type MysqlBase struct {
|
||
TargetIp string `gorm:"column:targetIp"`
|
||
}
|
||
|
||
// USerBusinessLog 用户行为日志
|
||
type UserBusinessLog struct {
|
||
Id uint `gorm:"primary_key,AUTO_INCREMENT"` //自增Id
|
||
UUID string `gorm:"column:uuid" json:"uuid"` //用户链接Id
|
||
UserName string `gorm:"column:user_name" json:"userName"` //登录的WXID
|
||
BusinessType string `gorm:"column:business_type" json:"businessType"` //业务类型 所调用的接口
|
||
ExecuteResult string `gorm:"column:ex_result" json:"executeResult"` //执行结果
|
||
}
|
||
|
||
// UserMessageLog 用户消息日志，用于去重
|
||
type UserMessageLog struct {
|
||
UserName string `gorm:"primary_key;column:user_name;unique" json:"userName"` // 唯一的用户名
|
||
MsgIds string `gorm:"column:msg_ids;type:text" json:"msgIds"` // 消息ID，以逗号分隔
|
||
}
|
||
|
||
// 用户登录日志
|
||
type UserLoginLog struct {
|
||
MysqlBase
|
||
Id uint `gorm:"primary_key,AUTO_INCREMENT" json:"id"`
|
||
UUId string
|
||
UserName string
|
||
NickName string
|
||
LoginType string
|
||
UpdatedAt LocalTime `json:"loginTime"`
|
||
RetCode int32 `gorm:"column:ret_code"`
|
||
ErrMsg string `gorm:"column:err_msg;type:text"`
|
||
}
|
||
|
||
// UserInfoEntity 用户信息
|
||
type UserInfoEntity struct {
|
||
MysqlBase
|
||
UUID string `gorm:"column:uuid" json:"uuid"`
|
||
Uin uint32 `gorm:"column:uin" json:"uin"`
|
||
WxId string `gorm:"column:wxId;primary_key" json:"wxId"`
|
||
NickName string `gorm:"column:nickname" json:"nickname"`
|
||
BindMobile string `gorm:"column:bindmobile" json:"bindmobile"`
|
||
Alias string `gorm:"column:alias" json:"alias"`
|
||
UserName string `gorm:"column:userName" json:"user_name"`
|
||
Password string `gorm:"column:password" json:"password"`
|
||
HeadURL string `gorm:"column:headurl" json:"headurl"`
|
||
Session []byte `gorm:"column:cookie" json:"cookie"`
|
||
SessionKey []byte `gorm:"column:sessionKey" json:"sessionKey"`
|
||
Proxy string `gorm:"column:proxy" json:"proxy"`
|
||
ClientVersion uint32 `gorm:"column:clientVersion" json:"clientVersion"`
|
||
ShortHost string `gorm:"column:shorthost" json:"shorthost"`
|
||
LongHost string `gorm:"column:longhost" json:"longhost"`
|
||
EcPublicKey []byte `gorm:"column:ecpukey" json:"ecpukey"`
|
||
EcPrivateKey []byte `gorm:"column:ecprkey" json:"ecprkey"`
|
||
CheckSumKey []byte `gorm:"column:checksumkey" json:"checksumkey"`
|
||
AutoAuthKey string `gorm:"column:autoauthkey;type:varchar(2048)" json:"autoauthkey"`
|
||
State int32 `gorm:"column:state" json:"state"`
|
||
InitContact int32 `gorm:"column:initcontact;default:0" json:"initcontact"`
|
||
SyncKey string `gorm:"column:synckey;type:varchar(1024)" json:"synckey"`
|
||
FavSyncKey string `gorm:"column:favsynckey;type:varchar(100)" json:"favsynckey"`
|
||
// 登录的Rsa 密钥版本
|
||
LoginRsaVer uint32
|
||
ErrMsg string `gorm:"type:text"`
|
||
|
||
// `gorm:"type:timestamp;default:CURRENT_TIMESTAMP"`
|
||
// `gorm:"type:timestamp;default:CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP"`
|
||
|
||
// 新设备创建时间
|
||
DeviceCreateTime LocalTime `gorm:"type:timestamp;default:CURRENT_TIMESTAMP" json:"deviceCreateTime"`
|
||
// 上次手动登录时间
|
||
LastLoginTime LocalTime `gorm:"type:timestamp;default:CURRENT_TIMESTAMP" json:"lastLoginTime"`
|
||
// 上次手动登录时间
|
||
LastAuthTime LocalTime `gorm:"type:timestamp;default:CURRENT_TIMESTAMP" json:"lastAuthTime"`
|
||
// 短连接启用状态
|
||
ShortLinkEnabled bool `gorm:"column:short_link_enabled;default:true" json:"shortLinkEnabled"`
|
||
}
|
||
|
||
// DeviceInfoEntity 设备信息
|
||
type DeviceInfoEntity struct {
|
||
WxId string `gorm:"column:wxid;primary_key" json:"wxid"`
|
||
UUIDOne string `gorm:"column:uuidone" json:"uuidone"`
|
||
UUIDTwo string `gorm:"column:uuidtwo" json:"uuidtwo"`
|
||
Imei string `gorm:"column:imei" json:"imei"`
|
||
DeviceID []byte `gorm:"column:deviceid" json:"deviceid"`
|
||
DeviceName string `gorm:"column:devicename" json:"devicename"`
|
||
TimeZone string `gorm:"column:timezone" json:"timezone"`
|
||
Language string `gorm:"column:language" json:"language"`
|
||
DeviceBrand string `gorm:"column:devicebrand" json:"devicebrand"`
|
||
RealCountry string `gorm:"column:realcountry" json:"realcountry"`
|
||
IphoneVer string `gorm:"column:iphonever" json:"iphonever"`
|
||
BundleID string `gorm:"column:boudleid" json:"boudleid"`
|
||
OsType string `gorm:"column:ostype" json:"ostype"`
|
||
AdSource string `gorm:"column:adsource" json:"adsource"`
|
||
OsTypeNumber string `gorm:"column:ostypenumber" json:"ostypenumber"`
|
||
CoreCount uint32 `gorm:"column:corecount" json:"corecount"`
|
||
CarrierName string `gorm:"column:carriername" json:"carriername"`
|
||
SoftTypeXML string `gorm:"column:softtypexml;type:varchar(2048)" json:"softtypexml"`
|
||
ClientCheckDataXML string `gorm:"column:clientcheckdataxml;type:varchar(4096)" json:"clientcheckdataxml"`
|
||
// extInfo
|
||
GUID2 string `json:"GUID2"`
|
||
}
|
||
|
||
// 授权key
|
||
type LicenseKey struct {
|
||
ID int `gorm:"column:id;primaryKey;autoIncrement" json:"id"`
|
||
DeviceToken string `gorm:"column:device_token;type:varchar(255)" json:"device_token"`
|
||
Status int `gorm:"column:status" json:"status"`
|
||
License string `gorm:"column:license;type:varchar(255);unique;not null" json:"license"`
|
||
ExpiryDate string `gorm:"column:expiry_date;type:varchar(255)" json:"expiry_date"`
|
||
StartDate string `gorm:"column:start_date;type:varchar(255)" json:"start_date"`
|
||
WxId string `gorm:"column:wx_id;type:varchar(255)" json:"wx_id"`
|
||
NickName string `gorm:"column:nick_name;type:varchar(255)" json:"nick_name"`
|
||
BindMobile string `gorm:"column:bindmobile" json:"bindmobile"`
|
||
Alias string `gorm:"column:alias" json:"alias"`
|
||
// 类型 1日 7 周 30月 90季 180 半年 365年 30000永久（数字为标识，非准确天数）
|
||
Type int `gorm:"column:type;type:int;default:0" json:"type"`
|
||
IsBanned int `gorm:"column:is_banned;type:int;default:0" json:"is_banned"`
|
||
}
|
||
|
||
type BlackList struct {
|
||
ID int `gorm:"primaryKey"`
|
||
Owner string `gorm:"column:owner;type:varchar(255)"`
|
||
Blacker string `gorm:"column:blacker;type:json"`
|
||
}
|
||
|
||
func (BlackList) TableName() string {
|
||
return "black_list"
|
||
}
|
||
|
||
// 指令：Command key str_value int_value
|
||
type Command struct {
|
||
UUID string `gorm:"column:uuid;primary_key" json:"uuid"`
|
||
A101 int `gorm:"column:a101;type:int;default:0" json:"a101"`
|
||
A111 int `gorm:"column:a111;type:int;default:0" json:"a111"`
|
||
A102 int `gorm:"column:a102;type:int;default:0" json:"a102"`
|
||
A103 int `gorm:"column:a103;type:int;default:0" json:"a103"`
|
||
A104 int `gorm:"column:a104;type:int;default:0" json:"a104"`
|
||
A104Str string `gorm:"column:a104_str;type:varchar(255)" json:"a104_str"`
|
||
A105 int `gorm:"column:a105;type:int;default:0" json:"a105"`
|
||
A106 int `gorm:"column:a106;type:int;default:0" json:"a106"`
|
||
A107 int `gorm:"column:a107;type:int;default:0" json:"a107"`
|
||
A109 int `gorm:"column:a109;type:int;default:0" json:"a109"`
|
||
A116 int `gorm:"column:a116;type:int;default:0" json:"a116"`
|
||
A116Str string `gorm:"column:a116_str;type:varchar(255)" json:"a116_str"`
|
||
A118 int `gorm:"column:a118;type:int;default:0" json:"a118"`
|
||
A118Str string `gorm:"column:a118_str;type:varchar(255)" json:"a118_str"`
|
||
A301 int `gorm:"column:a301;type:int;default:0" json:"a301"`
|
||
A301Str string `gorm:"column:a301_str;type:varchar(255)" json:"a301_str"`
|
||
A401 int `gorm:"column:a401;type:int;default:0" json:"a401"`
|
||
A402 int `gorm:"column:a402;type:int;default:0" json:"a402"`
|
||
A403 int `gorm:"column:a403;type:int;default:0" json:"a403"`
|
||
A601 int `gorm:"column:a601;type:int;default:0" json:"a601"`
|
||
A801 int `gorm:"column:a801;type:int;default:0" json:"a801"`
|
||
A811 int `gorm:"column:a811;type:int;default:0" json:"a811"`
|
||
B001 int `gorm:"column:b001;type:int;default:0" json:"b001"`
|
||
B001Str string `gorm:"column:b001_str;type:varchar(255)" json:"b001_str"`
|
||
B002 int `gorm:"column:b002;type:int;default:0" json:"b002"`
|
||
B002Str string `gorm:"column:b002_str;type:text" json:"b002_str"` // JSON string storing keyword-reply pairs
|
||
B003 int `gorm:"column:b003;type:int;default:0" json:"b003"` // Enable welcome message (0: disabled, 1: enabled)
|
||
B003Str string `gorm:"column:b003_str;type:text" json:"b003_str"` // JSON string storing welcome message config
|
||
B004 int `gorm:"column:b004;type:int;default:0" json:"b004"` // Enable admin keyword (0: disabled, 1: enabled)
|
||
B004Str string `gorm:"column:b004_str;type:text" json:"b004_str"` // JSON string storing admin keyword config
|
||
B005 int `gorm:"column:b005;type:int;default:0" json:"b005"` // Enable invite keyword (0: disabled, 1: enabled)
|
||
B005Str string `gorm:"column:b005_str;type:text" json:"b005_str"` // JSON string storing invite keyword config
|
||
B006 int `gorm:"column:b006;type:int;default:0" json:"b006"` // Enable kick keyword (0: disabled, 1: enabled)
|
||
B006Str string `gorm:"column:b006_str;type:text" json:"b006_str"` // JSON string storing kick keyword config
|
||
}
|
||
|
||
type ModContactDB struct {
|
||
UUID string `gorm:"type:varchar(36)" json:"uuid"` // 新增 UUID 字段
|
||
UserName string `gorm:"type:varchar(255)" json:"userName"`
|
||
UserUUIDCombined string `gorm:"primary_key;type:varchar(291);index" json:"user_uuid_combined"` // 新的组合字段，设置为主键
|
||
Data string `gorm:"type:json" json:"data"`
|
||
}
|
||
|
||
type AddMsgDB struct {
|
||
UUID string `gorm:"type:varchar(36)" json:"uuid"`
|
||
NewMsgId int64 `gorm:"type:bigint" json:"new_msg_id"`
|
||
MsgUUIDCombined string `gorm:"primary_key;type:varchar(291);index" json:"msg_uuid_combined"` // 新的组合字段，设置为主键
|
||
Data string `gorm:"type:json" json:"data"`
|
||
CreateTime uint32 `gorm:"type:int" json:"create_time"`
|
||
}
|