db

type BookTable struct {
	ID         int64     `db:"id"`
	Hash       string    `db:"hash"`
	FolderHash string    `db:"folder_hash"`
	FilePath   string    `db:"file_path"`
	FileSize   int       `db:"file_size"`
	Page       int       `db:"page"`
	ModTime    time.Time `db:"mod_time"`
}

type FolderTable struct {
	ID         int64     `db:"id"`
	Hash       string    `db:"hash"`
	ParentHash string    `db:"parent_hash"`
	FilePath   string    `db:"file_path"`
	ModTime    time.Time `db:"mod_time"`
}

type HistoryTable struct {
	ID       int64     `db:"id"`
	UserName string    `db:"user_name"`
	BookHash string    `db:"book_hash"`
	ReadPos  int       `db:"read_pos"`
	Reaction int       `db:"reaction"`
	ModTime  time.Time `db:"mod_time"`
}

type UserTable struct {
	ID         int64     `db:"id"`
	Name       string    `db:"name"`
	PassHash   string    `db:"passhash"`
	Permission int       `db:"permission"`
	CreatedAt  time.Time `db:"created_at"`
	UpdatedAt  time.Time `db:"updated_at"`
}