-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSQL_insert.sql
More file actions
103 lines (96 loc) · 6.94 KB
/
SQL_insert.sql
File metadata and controls
103 lines (96 loc) · 6.94 KB
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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
USE system31;
INSERT INTO condominio
(codigo, nome, cidade, bairro, rua, numero, cep, qtd_imoveis)
VALUES
(DEFAULT, 'Vale Do Sol', 'Campina Grande', 'Centro', 'Maria das Graças', 100, 58418215, 5),
(DEFAULT, 'Lua Mar', 'Campina Grande', 'São José', 'Av. professor Almeida Barreto', 150, 58400328, 7),
(DEFAULT, 'Riacho', 'Campina Grande', 'Dinamérica', 'João Fonseca', 2510, 58418000, 10),
(DEFAULT, 'Beija Flor', 'Belo Jardim', 'Centro', 'Siqueira Campos', 1250, 55155250, 15),
(DEFAULT, 'Rio Dourado', 'João Pessoa', 'Cabo Branco', 'Lirios dos Campos', 1234, 50000123, 20);
INSERT INTO administrador
(cpf, rg, nome, sexo, estado_civil, email, telefone, senha, data_nascimento, rua, num_home, bairro, cep, cidade, cod_condom)
VALUES
(09915396400, 387945912, 'João', 'M', 'casado', 'joao@hotmail.com', '81989541212', '123456', '1995-09-12', 'Nilton Senhorinho', 50, 'Centro', 77777888, 'Campina Grande', 1),
(09915391234, 387945123, 'Maria', 'F', 'casado', 'maria@hotmail.com', '81989540000', '654321', '1995-12-30', 'Arruda Vasconscelos', 100, 'Dinamérica', 99999888,'Campina Grande', 2),
(09915312345, 387941234, 'José', 'M', 'solteiro', 'jose@hotmail.com', '81989541111', '000000', '1955-01-22', 'Governador Valadares', 234, 'Bodocongó', 66666888, 'Campina Grande', 3),
(09915123456, 387912345, 'Francisca', 'F', 'casado', 'francisca@hotmail.com', '81989542222', '102030', '1980-10-13', 'Maria Lidia', 510, 'Malvinas', 55555888,'Belo Jardim', 4),
(09911234567, 387123456, 'Antonio', 'M', 'solteiro', 'antonio@hotmail.com', '81989543333', '5555555', '1990-05-20', 'Torres Maciel', 201, 'Centro', 44444888, 'João Pessoa', 5);
INSERT INTO imovel
(numero_imovel, cod_condom, taxa_condominio, valor_aluguel, vagas_garagem, qtd_quartos, qtd_banheiros, qtd_suites, varanda, manutencao, aluguel_ou_venda, area_metros_quadrado)
VALUES
(1, 1, 100.00, 500.00, 1, 2, 1, 0, FALSE, FALSE, 'A', 40),
(2, 1, 100.00, 500.00, 1, 2, 1, 0, FALSE, FALSE, 'A', 40),
(3, 1, 100.00, 500.00, 1, 2, 1, 0, FALSE, FALSE, 'A', 40),
(4, 1, 100.00, 500.00, 1, 2, 1, 0, FALSE, FALSE, 'A', 40),
(5, 1, 100.00, 500.00, 1, 2, 1, 0, FALSE, FALSE, 'A', 40),
(10, 2, 200.00, 700.00, 2, 2, 1, 1, FALSE, FALSE, 'A', 50),
(20, 2, 200.00, 700.00, 2, 2, 1, 1, FALSE, FALSE, 'A', 50),
(30, 2, 200.00, 700.00, 2, 2, 1, 1, FALSE, FALSE, 'A', 50),
(40, 2, 200.00, 700.00, 2, 2, 1, 1, FALSE, FALSE, 'A', 50),
(50, 2, 200.00, 700.00, 2, 2, 1, 1, FALSE, FALSE, 'A', 50),
(60, 2, 200.00, 700.00, 2, 2, 1, 1, FALSE, FALSE, 'A', 50),
(70, 2, 200.00, 700.00, 2, 2, 1, 1, FALSE, FALSE, 'A', 50),
(101, 3, 150.00, 400.00, 0, 1, 1, 0, FALSE, FALSE, 'V', 35),
(102, 3, 150.00, 400.00, 0, 1, 1, 0, FALSE, FALSE, 'V', 35),
(103, 3, 150.00, 400.00, 0, 1, 1, 0, FALSE, FALSE, 'V', 35),
(104, 3, 150.00, 400.00, 0, 1, 1, 0, FALSE, FALSE, 'V', 35),
(105, 3, 150.00, 400.00, 0, 1, 1, 0, FALSE, FALSE, 'V', 35),
(106, 3, 150.00, 400.00, 0, 1, 1, 0, FALSE, FALSE, 'V', 35),
(107, 3, 150.00, 400.00, 0, 1, 1, 0, FALSE, FALSE, 'V', 35),
(108, 3, 150.00, 400.00, 0, 1, 1, 0, FALSE, FALSE, 'V', 35),
(109, 3, 150.00, 400.00, 0, 1, 1, 0, FALSE, FALSE, 'V', 35),
(110, 3, 150.00, 400.00, 0, 1, 1, 0, FALSE, FALSE, 'V', 35),
(201, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(202, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(203, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(204, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(205, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(206, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(207, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(208, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(209, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(210, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(211, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(212, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(213, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(214, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(215, 4, 300.00, 1000.00, 4, 5, 2, 3, TRUE, FALSE, 'A', 95),
(1001, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1002, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1003, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1004, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1005, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1006, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1007, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1008, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1009, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1010, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1011, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1012, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1013, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1014, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1015, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1016, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1017, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1018, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1019, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45),
(1020, 5, 125.00, 480.00, 1, 1, 1, 1, TRUE, FALSE, 'A', 45);
INSERT INTO morador_titular
(cpf, nome, sexo, num_imovel, cod_condom, renda, inadimplencia, sindico, email, telefone)
VALUES
(12345678955, 'Bruno', 'M', 0, 1, 1000.00, FALSE, FALSE, 'bruno@gmail.com', '83977551122'),
(12345678911, 'Carlos', 'M', 1, 1, 1000.00, FALSE, FALSE, 'carlos@gmail.com', '83977551122'),
(12345678944, 'Samantha', 'F', 10, 2, 5000.00, FALSE, FALSE, 'samantha@gmail.com', '83977551122'),
(12345678933, 'Vinicius', 'M', 20, 2, 5000.00, FALSE, FALSE, 'vinicius@gmail.com', '83977551122'),
(12345678922, 'Rafaela', 'F', 100, 3, 4000.00, FALSE, FALSE, 'rafaela@gmail.com', '83977551122'),
(12345678966, 'Vitor', 'M', 101, 3, 4000.00, FALSE, FALSE, 'vitor@gmail.com', '83977551122'),
(12345678988, 'Vitoria', 'F', 200, 4, 10000.00, FALSE, FALSE, 'vitoria@gmail.com', '83977551122'),
(12345678977, 'Raul', 'M', 201, 4, 10000.00, FALSE, FALSE, 'raul@gmail.com', '83977551122'),
(12345678999, 'Marcela', 'F', 1000, 5, 1500.00, FALSE, FALSE, 'marcela@gmail.com', '83977551122'),
(12345678123, 'Carla', 'F', 1005, 5, 1500.00, FALSE, FALSE, 'carla@gmail.com', '83977551122');
INSERT INTO morador_dependendente
(cpf, nome, sexo, email, telefone, sindico, cpf_titular)
VALUES
(00011122233, 'Fábio', 'M', 'fabio@academico.ifpb.edu.br', '835544332211', FALSE, 1234567855),
(00011122244, 'Sara', 'F', 'sara@academico.ifpb.edu.br', '835544332299', FALSE, 1234567811),
(00011122255, 'Vilma', 'F', 'vilma@academico.ifpb.edu.br', '835544332288', FALSE, 1234567123);