modeltest

type Account struct {
	UID     int64 `orm:"name(uid);pk"`
	Account int64 `orm:"name(account)"`
	Version int64 `orm:"name(version);occ(true);default(1)"`
}

type Admin struct {
	User

	Email string `orm:"name(email);len(20);unique(unique_email)"`
	Group int64  `orm:"name(group);fk(fk_name,#groups,id,NO ACTION)"`
}

type Group struct {
	ID      int64  `orm:"name(id);ai"`
	Name    string `orm:"name(name);len(500)"`
	Created int64  `orm:"name(created)"`
}

type User struct {
	ID       int    `orm:"name(id);ai;"`
	Username string `orm:"unique(unique_username);index(index_name);len(50)"`
	Password string `orm:"name(password);len(20)"`
	Regdate  int    `orm:"-"`
}

type UserInfo struct {
	UID       int    `orm:"name(uid);pk"`
	FirstName string `orm:"name(firstName);unique(unique_name);len(20)"`
	LastName  string `orm:"name(lastName);unique(unique_name);len(20)"`
	Sex       string `orm:"name(sex);default(male);len(6)"`
}