2
Copyright 2010, 2012, 2014 Jose Robson Mariano Alves
4
This file is part of bgfinancas.
6
This program is free software: you can redistribute it and/or modify
7
it under the terms of the GNU General Public License as published by
8
the Free Software Foundation, either version 3 of the License, or
9
(at your option) any later version.
11
This package is distributed in the hope that it will be useful,
12
but WITHOUT ANY WARRANTY; without even the implied warranty of
13
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14
GNU General Public License for more details.
16
You should have received a copy of the GNU General Public License
17
along with this program. If not, see <http://www.gnu.org/licenses/>.
23
public class Database {
27
public static void GerarBanco(){
28
Conexao Banco = Conexao.getInstance();
29
Banco.executeUpdate("CREATE TABLE agenda (\n" +
30
" id_agenda INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
31
" id_tipo INTEGER, \n" +
32
" descricao VARCHAR_IGNORECASE(100), \n" +
33
" valor DECIMAL(10,2), \n" +
35
Banco.executeUpdate("CREATE TABLE agenda_tipos (\n" +
36
" id_tipo INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
37
" nome VARCHAR_IGNORECASE(100))");
38
Banco.executeUpdate("CREATE TABLE contas (\n" +
39
" id_conta INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
40
" nome VARCHAR_IGNORECASE(100), \n" +
41
" valor DECIMAL(10,2), \n" +
42
" ativada INTEGER, \n" +
43
" saldo_total VARCHAR_IGNORECASE(10))");
44
Banco.executeUpdate("CREATE TABLE despesas (\n" +
45
" id_despesa INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
46
" id_conta INTEGER, \n" +
47
" id_item INTEGER, \n" +
48
" quantidade DECIMAL(10,2), \n" +
49
" valor DECIMAL(10,2), \n" +
52
Banco.executeUpdate("CREATE TABLE despesas_categorias (\n" +
53
" id_categoria INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
54
" nome VARCHAR_IGNORECASE(100))");
55
Banco.executeUpdate("CREATE TABLE despesas_itens (\n" +
56
" id_item INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
57
" id_categoria INTEGER, \n" +
58
" nome VARCHAR_IGNORECASE(100))");
59
Banco.executeUpdate("CREATE TABLE planejamento (\n" +
60
" id_planejamento INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
63
" valor DECIMAL(10,2))");
64
Banco.executeUpdate("CREATE TABLE planejamento_componentes (\n" +
65
" id_planejamento INTEGER, \n" +
66
" id_item INTEGER, \n" +
67
" valor DECIMAL(10,2))");
68
Banco.executeUpdate("CREATE TABLE planejamento_itens (\n" +
69
" id_item INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
70
" nome VARCHAR_IGNORECASE(100))");
71
Banco.executeUpdate("CREATE TABLE receitas (\n" +
72
" id_receita INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
73
" id_conta INTEGER, \n" +
74
" id_item INTEGER, \n" +
75
" descricao VARCHAR_IGNORECASE(100), \n" +
76
" valor DECIMAL(10,2), \n" +
79
Banco.executeUpdate("CREATE TABLE receitas_categorias (\n" +
80
" id_categoria INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
81
" nome VARCHAR_IGNORECASE(100))");
82
Banco.executeUpdate("CREATE TABLE receitas_itens (\n" +
83
" id_item INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
84
" id_categoria INTEGER, \n" +
85
" nome VARCHAR_IGNORECASE(100))");
86
Banco.executeUpdate("CREATE TABLE relatorios_grupos (\n" +
87
" id_relatorios_grupos INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
88
" nome VARCHAR_IGNORECASE(100), \n" +
89
" valor DECIMAL(10,2), \n" +
90
" saldo_total VARCHAR_IGNORECASE(10))");
91
Banco.executeUpdate("CREATE TABLE relatorios_grupos_itens (\n" +
92
" id_relatorios_grupos INTEGER, \n" +
93
" id_despesas_categorias INTEGER)");
94
Banco.executeUpdate("CREATE TABLE transferencias (\n" +
95
" id_transferencia INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
96
" id_conta1 INTEGER, \n" +
97
" id_conta2 INTEGER, \n" +
98
" id_item INTEGER, \n" +
99
" descricao VARCHAR_IGNORECASE(100), \n" +
100
" valor DECIMAL(10,2), \n" +
103
Banco.executeUpdate("CREATE TABLE transferencias_categorias (\n" +
104
" id_categoria INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
105
" nome VARCHAR_IGNORECASE(100))");
106
Banco.executeUpdate("CREATE TABLE transferencias_itens (\n" +
107
" id_item INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
108
" id_categoria INTEGER, \n" +
109
" nome VARCHAR_IGNORECASE(100))");
110
Banco.executeUpdate("CREATE TABLE usuarios (\n" +
111
" id_usuarios INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \n" +
112
" nome VARCHAR_IGNORECASE(100), \n" +
113
" usuario VARCHAR_IGNORECASE(100), \n" +
114
" senha VARCHAR_IGNORECASE(100))");