591
社区成员
发帖
与我相关
我的任务
分享
DROP TABLE IF EXISTS trade;
CREATE TABLE trade(
tradeid INT(11) not NULL auto_increment,
userid INT(11) NOT NULL,
tradetime datetime NOT NULL,
PRIMARY KEY (tradeid),
CONSTRAINT user_id_fk FOREIGN KEY(userid) REFERENCES userinfo(userid)
)ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
DROP TABLE if exists userinfo;
CREATE TABLE userinfo(
userid INT(11) NOT NULL auto_increment,
username VARCHAR(50) DEFAULT NULL,
accountid int(11) DEFAULT NULL,
PRIMARY KEY (userid),
CONSTRAINT account_id_fk FOREIGN KEY (accountid) REFERENCES account(accountid)
)ENGINE=INNODB auto_increment=7 DEFAULT charset=utf8;
CREATE TABLE trade(
tradeid INT(11) not NULL auto_increment,
userid INT(11) NOT NULL,
tradetime datetime NOT NULL,
PRIMARY KEY (tradeid),
CONSTRAINT user_id_fk FOREIGN KEY(userid) REFERENCES userinfo(userid)
)ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
CREATE TABLE userinfo(
userid INT(11) NOT NULL auto_increment,
username VARCHAR(50) DEFAULT NULL,
accountid int(11) DEFAULT NULL,
PRIMARY KEY (userid),
CONSTRAINT account_id_fk FOREIGN KEY (accountid) REFERENCES account(accountid)
)ENGINE=INNODB auto_increment=7 DEFAULT charset=utf8;