-
Notifications
You must be signed in to change notification settings - Fork 0
/
popg_dml.sql
69 lines (57 loc) · 4.35 KB
/
popg_dml.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
INSERT INTO Planos VALUES (000001,'bronze',20,0);
INSERT INTO Planos VALUES (000002,'prata',40,2);
INSERT INTO Planos VALUES (000003,'ouro',60,4);
INSERT INTO Planos VALUES (000004,'platina',80,6);
INSERT INTO Planos VALUES (000005,'diamane',100,10);
INSERT INTO Cliente VALUES (TRUE,1,11111111111,'joaozinho',999999999,'1500-12-01',000001);
INSERT INTO Cliente VALUES (TRUE,2,22222222222,'pedriho',999998888,'2037-01-01',000003);
INSERT INTO Cliente VALUES (TRUE,2,33333333333,'rafa',999996666,'1000-12-01',000002);
INSERT INTO Cliente VALUES (FALSE,3,00000000004,'fulano',999996969,'2000-12-01', NULL);
INSERT INTO Cliente VALUES (FALSE,1,44444444444,'sicrano',99985858,'1500-12-01',NULL);
INSERT INTO Funcionario VALUES (1200.25, 'professor', '8:00:00', '23:00:00', 110000000000,'Edudarda',99555555,'1998-12-01', NULL);
INSERT INTO Funcionario VALUES (1200.25, 'professor', '8:00:00', '23:00:00', 220000000000,'Fernanda',99666666,'1999-01-01', NULL);
INSERT INTO Funcionario VALUES (300.55, 'estagiario', '13:00:00', '16:00:00', 330000000000,'Ryan',99777777,'2000-12-01', 110000000000);
INSERT INTO Funcionario VALUES (1200.25, 'nutricionista', '8:00:00', '23:00:00', 440000000000,'Claudjane',99888888,'1998-12-01', NULL);
INSERT INTO Funcionario VALUES (1200.25, 'faxineiro', '8:00:00', '23:00:00', 550000000000,'Bosco',99999999,'2010-12-01', NULL);
UPDATE Funcionario SET fk_Funcionario_CPF=330000000000 WHERE (CPF=110000000000);
INSERT INTO Avaliacao VALUES (123456,25.5,40.3,15.0,'2000-07-23',11111111111);
INSERT INTO Avaliacao VALUES (123455,21.5,45.3,10.0,'2000-09-23',11111111111);
INSERT INTO Avaliacao VALUES (123400,22.5,50.3,25.8,'2009-07-23',22222222222);
INSERT INTO Avaliacao VALUES (123477,35.5,60.3,13.0,'2010-07-23',33333333333);
INSERT INTO Avaliacao VALUES (123499,5.5,70.3,19.0,'2011-07-23',33333333333);
INSERT INTO Filial_Gerente VALUES (000509,'rua dr. josefina fina', 9696, 'graças', 2000.75, 012234567899, 'fabio', 98989898, '2021-05-25');
INSERT INTO Filial_Gerente VALUES (000609,'avenida ruy barbosa', 2000, 'jaqueira', 2000.75, 01223456999, 'Renato', 96969696, '2021-06-25');
INSERT INTO Filial_Gerente VALUES (000709,'rua amelia', 25, 'Torre', 2000.75, 01223459999, 'maria joano', 56565656, '2090-05-25');
INSERT INTO Filial_Gerente VALUES (000810,'rua real da torre', 13, 'Madalena', 2000.75, 012234511111, 'luisa', 91916565, '2165-05-25');
INSERT INTO Filial_Gerente VALUES (000910,'rua da hora', 78, 'Passargada', 2000.75, 012234888888, 'leticia', 99993357, '2001-05-25');
INSERT INTO Equipamentos VALUES (987654, 'flexora', '1500-02-28');
INSERT INTO Equipamentos VALUES (987555, 'abdutora', '2004-02-29');
INSERT INTO Equipamentos VALUES (984444, 'leg45', '1990-11-12');
INSERT INTO Equipamentos VALUES (989999, 'extensora', '1596-06-18');
INSERT INTO Equipamentos VALUES (981111, 'Hack', '1870-04-08');
INSERT INTO Eventos VALUES (999000, 'catraca livre', '2018-02-28', NULL, 000505);
INSERT INTO Eventos VALUES (111000, 'catraca livre', '2010-03-28', NULL, 000505);
INSERT INTO Eventos VALUES (222220, 'Carnaval cavalheira', '2001-06-28', NULL, 000070);
INSERT INTO Eventos VALUES (333300, 'Open bar delux', '2008-02-28', NULL, 000808);
INSERT INTO Eventos VALUES (444400, 'seminario de boxe para idosos', '2013-09-28', NULL, 000909);
INSERT INTO Aulas VALUES (123987, 'boxe', '8:00:00', '9:00:00');
INSERT INTO Aulas VALUES (123666, 'muay thay', '9:00:00', '10:00:00');
INSERT INTO Aulas VALUES (123333, 'smart fight', '10:00:00', '11:00:00');
INSERT INTO Aulas VALUES (123444, 'yoga', '11:00:00', '12:00:00');
INSERT INTO Aulas VALUES (123000, 'Bale', '13:00:00', '14:00:00');
INSERT INTO possui Values (000505,123987);
INSERT INTO possui Values (000505,123666);
INSERT INTO possui Values (000606,123333);
INSERT INTO possui Values (000070,123444);
INSERT INTO possui Values (000909,123000);
INSERT INTO aloca VALUES (987555,000509,012234567899);
INSERT INTO aloca VALUES (984444,000509,012234567899);
INSERT INTO aloca VALUES (989999,000609,01223456999);
INSERT INTO aloca VALUES (981111,000609,01223456999);
INSERT INTO aloca VALUES (987555,000709,01223459999);
INSERT INTO aloca VALUES (984444,000709,01223459999);
INSERT INTO aloca VALUES (989999,000709,01223459999);
INSERT INTO aloca VALUES (987555,000810,012234511111);
INSERT INTO aloca VALUES (984444,000810,012234511111);
INSERT INTO aloca VALUES (989999,000910,012234888888);
INSERT INTO aloca VALUES (981111,000910,012234888888);