Skip to content

Instantly share code, notes, and snippets.

@andrechavesg
Created November 27, 2015 23:06
Show Gist options
  • Save andrechavesg/54896908cb7811c2f2e4 to your computer and use it in GitHub Desktop.
Save andrechavesg/54896908cb7811c2f2e4 to your computer and use it in GitHub Desktop.
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