query

type Access struct {
	ID               int            `db:"id"`
	UA               string         `db:"ua"`
	BrowserID        string         `db:"browser_id"`
	BrowserVersion   string         `db:"browser_version"`
	OSID             string         `db:"os_id"`
	OSVersion        string         `db:"os_version"`
	URL              string         `db:"url"`
	Path             string         `db:"path"`
	QueryString      sql.NullString `db:"query_string"`
	IP               int64          `db:"ip"`
	Entrypoint       string         `db:"entrypoint"`
	EntrypointDomain sql.NullString `db:"entrypoint_domain"`
	Referer          string         `db:"referer"`
	RefererDomain    sql.NullString `db:"referer_domain"`
	Time             int64          `db:"time"`
	ContentID        sql.NullInt64  `db:"content_id"`
	MetaID           sql.NullInt64  `db:"meta_id"`
	Robot            int8           `db:"robot"`
	RobotID          string         `db:"robot_id"`
	RobotVersion     string         `db:"robot_version"`
}

type Comments struct {
	Coid     uint32         `db:"coid"     form:"coid"`
	Cid      uint32         `db:"cid"      form:"cid"`
	OwnerId  uint32         `db:"ownerId"  form:"ownerId"`
	Parent   uint32         `db:"parent"   form:"parent"`
	Created  int64          `db:"created"  form:"created"`
	Author   string         `db:"author"   form:"author"`
	Mail     string         `db:"mail"     form:"mail"`
	Ip       string         `db:"ip"       form:"ip"`
	Agent    string         `db:"agent"    form:"agent"`
	Text     string         `db:"text"     form:"text"`
	Type     string         `db:"type"     form:"type"`
	Status   string         `db:"status"   form:"status"`
	AuthorId uint8          `db:"authorId" form:"authorId"`
	Url      sql.NullString `db:"url"      form:"url"`
}

type CommsWithTitleMix struct {
	Comments
	Title string `db:"title"     form:"title"`
}

type Contents struct {
	Cid          int            `db:"cid"`
	Title        string         `db:"title"`
	Slug         string         `db:"slug"`
	Created      int64          `db:"created"`
	Modified     int64          `db:"modified"`
	Text         []byte         `db:"text"`
	Order        uint8          `db:"order"`
	AuthorId     uint8          `db:"authorId"`
	Template     sql.NullString `db:"template"`
	Type         string         `db:"type"`
	Status       string         `db:"status"`
	Password     sql.NullString `db:"password"`
	AllowComment uint8          `db:"allowComment"`
	AllowPing    uint8          `db:"allowPing"`
	AllowFeed    uint8          `db:"allowFeed"`
	CommentsNum  uint16         `db:"commentsNum"`
	Parent       uint16         `db:"parent"`
	Views        uint16         `db:"views"`
	Likes        uint32         `db:"likes"`
}

type Fields struct {
	Cid        int     `db:"cid"`
	Name       string  `db:"name"`
	Type       string  `db:"type"`
	StrValue   string  `db:"str_value"`
	IntValue   int     `db:"int_value"`
	FloatValue float64 `db:"float_value"`
}

type MediasWithTitleMix struct {
	Contents
	PostTitle string `db:"post_title"     form:"post_title"`
}

type PostWithBGMusicMix struct {
	Contents
	Music string `db:"music"     form:"music"`
}

type PostsWithCoverMix struct {
	Contents
	Cover string `db:"cover"     form:"cover"`
}

type User struct {
	Uid        string `db:"uid"`
	Name       string `db:"name"`
	Password   string `db:"password"`
	Mail       string `db:"mail"`
	Url        string `db:"url"`
	ScreenName string `db:"screenName"`
	Created    int64  `db:"created"`
	Activated  int64  `db:"activated"`
	Logged     int64  `db:"logged"`
	Group      string `db:"group"`
	AuthCode   string `db:"authCode"`
}