一、创建表格
marksql := "create table mark (id int(20) primary key auto_increment,markname char(50)," +
"mlongitude float,mlatitude float,mdescribe char(255),mtype int,creattime char(50),mvalue float );"
smt, err := db.Db.Prepare(marksql)
checkErr(err)
smt.Exec()
二、创建外键
//定义好友fk1外键
idx_userid := "alter table user add index idx_userid(uid);"
smt, err = db.Db.Prepare(idx_userid)
checkErr(err)
smt.Exec()
idx_userid = "alter table friend add index idx_friuid(uid);"
smt, err = db.Db.Prepare(idx_userid)
checkErr(err)
smt.Exec()
//定义好友fk2外键
frifk2sql := "alter table friend add constraint fk2_fri_user foreign key(uid) references user(uid);"
smt, err = db.Db.Prepare(frifk2sql)
checkErr(err)
smt.Exec()
三、插入数据