db

type Channel struct {
	ID        int    `sql:"id"`
	Name      string `sql:"name"`
	Type      int    `sql:"type"`
	Project   int64  `sql:"project"`
	Device    int64  `sql:"device"`
	Color     string `sql:"color"`
	MaxLength int    `sql:"max_length"`
}

type Device struct {
	ID        int64  `sql:"id"`
	Name      string `sql:"name"`
	Project   int64  `sql:"project"`
	LongID    string `sql:"longID"`
	Hostname  string `sql:"hostname"`
	Port      int    `sql:"port"`
	Connector bool   `sql:"connector"`
	Key       string `sql:"key"`
	UseKey    bool   `sql:"use_key"`
}

type Matrix struct {
	ID         int64  `sql:"id"`
	Device     int64  `sql:"device"`
	Channel    int64  `sql:"channel"`
	Project    int64  `sql:"project"`
	Width      int    `sql:"width"`
	Height     int    `sql:"height"`
	Type       int    `sql:"type"`
	Coloring   string `sql:"coloring"`
	Offset     int    `sql:"offset"`
	Brightness int    `sql:"brightness"`
}

type Project struct {
	ID            int       `sql:"id"`
	Name          string    `sql:"name"`
	Created       time.Time `sql:"created"`
	LastUpdate    time.Time `sql:"last_update"`
	Client        string    `sql:"client"`
	Active        bool      `sql:"active"`
	FrontendState string    `sql:"frontend_state"`
}

type User struct {
	ID        int       `sql:"id"`
	Name      string    `sql:"name"`
	Username  string    `sql:"username"`
	Password  string    `sql:"password"`
	Created   time.Time `sql:"created"`
	LastLogin time.Time `sql:"last_login"`
}