· 8 years ago · Apr 09, 2018, 04:28 PM
1CREATE TABLE IF NOT EXISTS amizade(
2 id INT NOT NULL AUTO_INCREMENT,
3 u_id INT,
4 a_id INT,
5 CONSTRAINT id_pk PRIMARY KEY(id),
6 CONSTRAINT u_id_fk FOREIGN KEY(u_id) REFERENCES usuarios(id),
7 CONSTRAINT a_id_fk FOREIGN KEY(a_id) REFERENCES usuarios(id)
8) DEFAULT CHARSET=utf8;