Created
November 27, 2015 23:06
-
-
Save andrechavesg/54896908cb7811c2f2e4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table Usuario ( | |
id int not null primary key auto_increment, | |
nome varchar(255) | |
); | |
create table Email ( | |
id int not null primary key auto_increment, | |
email varchar(255) not null, | |
usuario_id int not null, | |
FOREIGN KEY (usuario_id) references Usuario(id) | |
); | |
create table Compra ( | |
id int not null primary key auto_increment, | |
valor decimal(10,2) not null, | |
momentoDaCompra datetime, | |
usuario_id int not null, | |
FOREIGN KEY(usuario_id) REFERENCES Usuario(id) | |
); | |
insert into Usuario values (null,'Andre Chaves'); | |
insert into Usuario values (null,'Rafael Alves'); | |
insert into Usuario values (null,'Guilherme Silveira'); | |
insert into Usuario values (null,'Paulo Silveira'); | |
insert into Usuario values (null,'Sergio Lopes'); | |
insert into Usuario values (null,'Maurício Aniche'); | |
insert into compra (id,usuario_id,valor,momentoDaCompra) value (1,1,58.25,now()-interval 30 day); | |
insert into compra (id,usuario_id,valor,momentoDaCompra) value (2,1,58.25,now()-interval 30 day); | |
insert into compra (id,usuario_id,valor,momentoDaCompra) value (3,1,58.25,now()-interval 30 day); | |
insert into compra (id,usuario_id,valor,momentoDaCompra) value (4,2,60.35,now()-interval 700 hour); | |
insert into compra (id,usuario_id,valor,momentoDaCompra) value (5,3,60.35,now()-interval 29 day); | |
insert into compra (id,usuario_id,valor,momentoDaCompra) value (6,2,60.35,now()-interval 31 day); | |
insert into compra (id,usuario_id,valor,momentoDaCompra) value (7,2,60.35,now()-interval 32 day); | |
insert into compra (id,usuario_id,valor,momentoDaCompra) value (8,4,60.35,now()-interval 32 day); | |
insert into compra (id,usuario_id,valor,momentoDaCompra) value (9,2,60.35,now()-interval 700 hour); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment