81Kmu3YG

1type User struct {
2    ID      int     `sql:"primary_key;AUTO_INCREMENT"`
3    Name    string  `sql:"type:varchar(100);unique"`
4    Email   string  `sql:"type:varchar(100);unique"`
5    Address string  `sql:"type:varchar(100)"`
6}
7	
8func (db *DB) CreateUserTable() (sql.Result, error) {
9
10    statement := "CREATE TABLE IF NOT EXISTS %s (%s int, %s varchar, %s varchar, %s varchar)"
11    return db.Exec(
12        fmt.Sprintf(statement,
13            "user",
14            "id",
15            "name",
16            "email",
17            "address",
18        ),
19    )
20}