dbschema

Documentation

Index

• type Album
• type Attathment
• type Category
• type Comment
• type Config
• type Link
• type Ocontent
• type Post
• type Tag
• type User

Types

type Album

type Album struct {
	Id           int    `xorm:"not null pk autoincr INT(10)"`
	Title        string `xorm:"not null VARCHAR(180)"`
	Description  string `xorm:"not null default '' VARCHAR(200)"`
	Content      string `xorm:"not null TEXT"`
	Created      int    `xorm:"not null created INT(10)"`
	Updated      int    `xorm:"not null default 0 updated INT(10)"`
	Views        int    `xorm:"not null default 0 INT(10)"`
	Comments     int    `xorm:"not null default 0 INT(10)"`
	Likes        int    `xorm:"not null default 0 INT(10)"`
	Display      string `xorm:"not null default 'ALL' ENUM('ALL','SELF','FRIEND','PWD')"`
	Deleted      int    `xorm:"not null default 0 INT(10)"`
	AllowComment string `xorm:"not null default 'Y' ENUM('Y','N')"`
	Tags         string `xorm:"not null default '' VARCHAR(255)"`
	Catid        int    `xorm:"not null default 0 INT(10)"`
}

type Attathment

type Attathment struct {
	Id        int    `xorm:"not null pk autoincr INT(10)"`
	Name      string `xorm:"not null VARCHAR(100)"`
	Path      string `xorm:"not null VARCHAR(255)"`
	Extension string `xorm:"not null VARCHAR(5)"`
	Type      string `xorm:"not null default 'image' ENUM('image','media','other')"`
	Size      int64  `xorm:"not null BIGINT(20)"`
	Uid       int    `xorm:"not null INT(10)"`
	Deleted   int    `xorm:"not null default 0 INT(10)"`
	Created   int    `xorm:"not null created INT(10)"`
	Audited   int    `xorm:"not null default 0 INT(10)"`
	RcId      int    `xorm:"not null default 0 INT(10)"`
	RcType    string `xorm:"not null default '' VARCHAR(30)"`
	Tags      string `xorm:"not null default '' VARCHAR(255)"`
}

type Category

type Category struct {
	Id          int    `xorm:"not null pk autoincr INT(10)"`
	Pid         int    `xorm:"not null default 0 INT(10)"`
	Name        string `xorm:"not null VARCHAR(30)"`
	Description string `xorm:"not null default '' VARCHAR(200)"`
	Haschild    string `xorm:"not null default 'N' ENUM('Y','N')"`
	Updated     int    `xorm:"not null default 0 updated INT(10)"`
	RcType      string `xorm:"not null default 'post' VARCHAR(30)"`
	Sort        int    `xorm:"not null default 0 INT(10)"`
	Tmpl        string `xorm:"not null default '' VARCHAR(100)"`
}

type Comment

type Comment struct {
	Id           int64  `xorm:"BIGINT(20)"`
	Content      string `xorm:"not null TEXT"`
	Quote        string `xorm:"TEXT"`
	Etype        string `xorm:"not null default 'html' CHAR(10)"`
	RootId       int64  `xorm:"not null default 0 BIGINT(20)"`
	RId          int64  `xorm:"not null default 0 BIGINT(20)"`
	RType        string `xorm:"ENUM('reply','append')"`
	RelatedTimes int    `xorm:"not null default 0 INT(10)"`
	RootTimes    int    `xorm:"not null default 0 INT(10)"`
	Uid          int64  `xorm:"not null default 0 BIGINT(20)"`
	Uname        string `xorm:"not null VARCHAR(30)"`
	Up           int64  `xorm:"not null default 0 BIGINT(20)"`
	Down         int64  `xorm:"not null default 0 BIGINT(20)"`
	Created      int    `xorm:"not null default 0 created INT(10)"`
	Updated      int    `xorm:"not null default 0 updated INT(10)"`
	Status       int    `xorm:"not null default 0 INT(1)"`
	RcId         int64  `xorm:"not null default 0 BIGINT(20)"`
	RcType       string `xorm:"not null default 'post' CHAR(30)"`
	ForUname     string `xorm:"VARCHAR(30)"`
	ForUid       int64  `xorm:"not null default 0 BIGINT(20)"`
}

type Config

type Config struct {
	Id      int    `xorm:"not null pk autoincr INT(10)"`
	Key     string `xorm:"not null VARCHAR(60)"`
	Val     string `xorm:"not null VARCHAR(200)"`
	Updated int    `xorm:"not null default 0 updated INT(10)"`
}

type Link

type Link struct {
	Id       int    `xorm:"not null pk autoincr INT(10)"`
	Name     string `xorm:"not null VARCHAR(30)"`
	Url      string `xorm:"not null VARCHAR(200)"`
	Logo     string `xorm:"not null VARCHAR(200)"`
	Show     string `xorm:"not null default 'N' ENUM('Y','N')"`
	Verified int    `xorm:"not null default 0 INT(10)"`
	Created  int    `xorm:"not null default 0 created INT(10)"`
	Updated  int    `xorm:"not null default 0 updated INT(10)"`
	Catid    int    `xorm:"not null default 0 INT(10)"`
	Sort     int    `xorm:"not null default 0 INT(10)"`
}

type Ocontent

type Ocontent struct {
	Id      int64  `xorm:"BIGINT(30)"`
	RcId    int64  `xorm:"not null BIGINT(20)"`
	RcType  string `xorm:"not null default 'post' VARCHAR(30)"`
	Content string `xorm:"not null TEXT"`
	Etype   string `xorm:"not null default 'markdown' ENUM('markdown')"`
}

type Post

type Post struct {
	Id           int    `xorm:"not null pk autoincr INT(10)"`
	Title        string `xorm:"not null VARCHAR(180)"`
	Description  string `xorm:"not null VARCHAR(200)"`
	Content      string `xorm:"not null TEXT"`
	Etype        string `xorm:"not null default 'html' ENUM('html','markdown')"`
	Created      int    `xorm:"not null default 0 created INT(10)"`
	Updated      int    `xorm:"not null default 0 updated INT(10)"`
	Display      string `xorm:"not null default 'ALL' ENUM('ALL','SELF','FRIEND','PWD')"`
	Uid          int    `xorm:"not null default 0 INT(10)"`
	Uname        string `xorm:"not null default '' VARCHAR(30)"`
	Passwd       string `xorm:"not null default '' VARCHAR(64)"`
	Views        int    `xorm:"not null default 0 INT(10)"`
	Comments     int    `xorm:"not null default 0 INT(10)"`
	Likes        int    `xorm:"not null default 0 INT(10)"`
	Deleted      int    `xorm:"not null default 0 INT(10)"`
	Year         int    `xorm:"not null INT(5)"`
	Month        int    `xorm:"not null TINYINT(1)"`
	AllowComment string `xorm:"not null default 'Y' ENUM('Y','N')"`
	Tags         string `xorm:"not null default '' VARCHAR(255)"`
	Catid        int    `xorm:"not null default 0 INT(10)"`
}

type Tag

type Tag struct {
	Id      int    `xorm:"not null pk autoincr INT(10)"`
	Name    string `xorm:"not null VARCHAR(30)"`
	Uid     int    `xorm:"not null INT(10)"`
	Created int    `xorm:"not null created INT(10)"`
	Times   int    `xorm:"not null INT(10)"`
	RcType  string `xorm:"not null default 'post' VARCHAR(30)"`
}

type User

type User struct {
	Id        int    `xorm:"not null pk autoincr INT(10)"`
	Uname     string `xorm:"not null VARCHAR(30)"`
	Passwd    string `xorm:"not null CHAR(64)"`
	Salt      string `xorm:"not null CHAR(64)"`
	Email     string `xorm:"not null default '' VARCHAR(100)"`
	Mobile    string `xorm:"not null default '' VARCHAR(15)"`
	LoginTime int    `xorm:"not null default 0 INT(10)"`
	LoginIp   string `xorm:"not null default '' VARCHAR(40)"`
	Created   int    `xorm:"not null default 0 created INT(10)"`
	Updated   int    `xorm:"not null default 0 updated INT(10)"`
	Active    string `xorm:"not null default 'Y' ENUM('Y','N')"`
	Avatar    string `xorm:"not null default '' VARCHAR(200)"`
}