func dropTables() {
_, err := DB.DB.Exec("DROP TABLE IF EXISTS user")
errors.Panic(err)
_, err = DB.DB.Exec("DROP TABLE IF EXISTS user_follow")
errors.Panic(err)
}
func createTables() {
dri := driver.MySQL("mysql")
errors.Panic(
DB.Connect(dri, dsn(dri), 1, 1),
)
_, err := DB.DB.Exec(`
CREATE TABLE user (
id int AUTO_INCREMENT,
name varchar(50) UNIQUE NOT NULL,
age int NOT NULL DEFAULT 0,
followings int NOT NULL DEFAULT 0,
followers int NOT NULL DEFAULT 0,
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
`)
errors.Panic(err)
_, err = DB.DB.Exec(`
CREATE TABLE user_follow (
user_id varchar(16),
follow_user_id varchar(16),
PRIMARY KEY(user_id, follow_user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
`)
errors.Panic(err)
}