· 5 years ago · Nov 19, 2020, 11:34 AM
1SET FOREIGN_KEY_CHECKS=0;
2
3CREATE TABLE `sgriweb`.`emissao_atmosferica_old` (
4 `cd_cnpj` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
5 `nr_ano` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
6 `cd_emissao_atmosferica` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
7 `in_util_comb_industria` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
8 `in_util_comb_outros` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
9 `in_legislacao_ambiental` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
10 `cd_equip_contr_emissoes_atm` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
11 `no_outros_equip` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
12 `in_util_equip_emissao` decimal(2, 0) NULL DEFAULT NULL,
13 PRIMARY KEY (`cd_cnpj`, `nr_ano`, `cd_emissao_atmosferica`) USING BTREE
14) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
15
16CREATE TABLE `sgriweb`.`etapa_old` (
17 `cd_cnpj` varchar(14) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
18 `nr_ano` varchar(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
19 `no_etapa` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
20 `indc_residuos_solidos` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
21 `indc_efluentes_liquidos` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
22 `indc_emissoes_atmosfericas` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
23 `indc_alteracao` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
24 `indc_processo_produtivo` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
25 `id_etapa` double(15, 3) NOT NULL DEFAULT 0.000,
26 `ds_etapa` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
27 `ds_residuo_gerados` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
28 PRIMARY KEY (`cd_cnpj`, `nr_ano`, `id_etapa`) USING BTREE
29) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
30
31CREATE TABLE `sgriweb`.`industria_old` (
32 `cd_cnpj` varchar(14) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
33 `cd_tipo_licenca` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
34 `licenca` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
35 `no_razao_social` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
36 `no_logradouro` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
37 `nr_logradouro` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
38 `no_bairro` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
39 `cd_municipio` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
40 `cd_cep` varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
41 `cd_ddd_industria` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
42 `nr_telefone_industria` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
43 `cd_ddd_fax_industria` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
44 `nr_fax_industria` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
45 `ds_email_industria` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
46 `cd_inscr_estadual` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
47 `no_logradouro_cor` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
48 `nr_logradouro_cor` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
49 `no_bairro_cor` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
50 `cd_municipio_cor` varchar(6) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
51 `cd_cep_cor` varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
52 `cd_ddd` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
53 `nr_telefone` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
54 `cd_ddd_fax` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
55 `nr_fax` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
56 `no_contato` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
57 `no_cargo` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
58 `ds_email` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
59 `ds_atividade` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
60 `hr_dia_prod` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
61 `nr_dia_mes_prod` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
62 `nr_meses_ano_prod` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
63 `nr_func_prod` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
64 `nr_func_adm` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
65 `nr_func_outros` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
66 `nr_area_util` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
67 `nr_lat_grau` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
68 `nr_lat_min` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
69 `nr_lat_seg` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
70 `nr_long_grau` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
71 `nr_long_min` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
72 `nr_long_seg` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
73 `no_logradouro_res` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
74 `nr_logradouro_res` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
75 `no_bairro_res` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
76 `cd_municipio_res` varchar(6) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
77 `cd_cep_res` varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
78 `no_responsavel` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
79 `cpf_responsavel` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
80 `ds_email_responsavel` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
81 `no_cargo_resp` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
82 `dt_preenchimento` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
83 `nr_ano_exercicio` varchar(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
84 `dt_inicio_periodo` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
85 `dt_termino_periodo` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
86 `cd_cnae` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
87 `cpf_tecnico` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
88 `registro_tecnico` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
89 `ds_email_tecnico` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
90 `cd_ddd_tecnico` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
91 `nr_telefone_tecnico` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
92 `cd_ddd_fax_tecnico` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
93 `nr_telefone_fax_tecnico` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
94 `indc_alteracao` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
95 `tipologia` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
96 `cd_situacao` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
97 `indc_gerenciadora` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
98 `indc_sist_gestao` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
99 `no_sist_gestao` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
100 `indc_inventariado` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
101 `indc_plano` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
102 `indc_licenca` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
103 `indc_envio_declaracao` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
104 `indc_retificadora` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
105 `indc_alteracao_plano` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
106 `nr_ano_plano` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
107 `nr_plano` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
108 `in_operacao_atual` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
109 `dt_inicio_atividade` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
110 `dt_ultima_atualizacao_ativ` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
111 `nu_processo_retificadora` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
112 `indc_copia_corresp` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
113 `desc_localizacao` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
114 `area_certificado_ambiental` decimal(1, 0) NULL DEFAULT NULL,
115 `nr_area_cons` decimal(10, 0) NULL DEFAULT NULL,
116 PRIMARY KEY (`cd_cnpj`, `nr_ano_exercicio`) USING BTREE
117) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
118
119ALTER TABLE `sgriweb`.`residuo_industria` ADD COLUMN `contorle_contaminantes` enum('S','N') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL AFTER `nr_qtd_anos_ant`;
120
121ALTER TABLE `sgriweb`.`residuo_industria` ADD COLUMN `controle_gerenciadora` enum('S','N') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL AFTER `contorle_contaminantes`;
122
123ALTER TABLE `sgriweb`.`residuo_industria` MODIFY COLUMN `id_etapa` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' AFTER `cd_residuo`;
124
125CREATE TABLE `sgriweb`.`sec_apps` (
126 `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
127 `app_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
128 `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
129 PRIMARY KEY (`app_name`) USING BTREE
130) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
131
132CREATE TABLE `sgriweb`.`sec_groups` (
133 `group_id` int(11) NOT NULL AUTO_INCREMENT,
134 `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
135 PRIMARY KEY (`group_id`) USING BTREE,
136 UNIQUE INDEX `description`(`description`) USING BTREE
137) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
138
139CREATE TABLE `sgriweb`.`sec_groups_apps` (
140 `group_id` int(11) NOT NULL,
141 `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
142 `priv_access` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
143 `priv_insert` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
144 `priv_delete` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
145 `priv_update` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
146 `priv_export` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
147 `priv_print` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
148 PRIMARY KEY (`group_id`, `app_name`) USING BTREE,
149 INDEX `sec_groups_apps_ibfk_2`(`app_name`) USING BTREE,
150 CONSTRAINT `sec_groups_apps_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `sgriweb`.`sec_groups` (`group_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
151 CONSTRAINT `sec_groups_apps_ibfk_2` FOREIGN KEY (`app_name`) REFERENCES `sgriweb`.`sec_apps` (`app_name`) ON DELETE CASCADE ON UPDATE RESTRICT
152) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
153
154CREATE TABLE `sgriweb`.`sec_logged` (
155 `login` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
156 `date_login` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
157 `sc_session` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
158 `ip` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
159) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
160
161CREATE TABLE `sgriweb`.`sec_users` (
162 `login` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
163 `pswd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
164 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
165 `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
166 `active` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
167 `activation_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
168 `priv_admin` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
169 PRIMARY KEY (`login`) USING BTREE
170) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
171
172CREATE TABLE `sgriweb`.`sec_users_apps` (
173 `login` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
174 `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
175 `priv_access` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
176 `priv_insert` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
177 `priv_delete` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
178 `priv_update` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
179 `priv_export` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
180 `priv_print` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
181 PRIMARY KEY (`login`, `app_name`) USING BTREE,
182 INDEX `sec_users_apps_ibfk_2`(`app_name`) USING BTREE
183) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
184
185CREATE TABLE `sgriweb`.`sec_users_groups` (
186 `login` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
187 `group_id` int(11) NOT NULL,
188 PRIMARY KEY (`login`, `group_id`) USING BTREE,
189 INDEX `sec_users_groups_ibfk_2`(`group_id`) USING BTREE,
190 CONSTRAINT `sec_users_groups_ibfk_1` FOREIGN KEY (`login`) REFERENCES `sgriweb`.`sec_users` (`login`) ON DELETE CASCADE ON UPDATE RESTRICT,
191 CONSTRAINT `sec_users_groups_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `sgriweb`.`sec_groups` (`group_id`) ON DELETE CASCADE ON UPDATE RESTRICT
192) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
193
194ALTER TABLE `sgriweb`.`usuarios` MODIFY COLUMN `senha` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `licenca`;
195
196CREATE TABLE `sgriweb`.`usuarios_old` (
197 `codigo_usuario` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
198 `nome_usuario` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
199 `cnpj` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
200 `cpf_resp` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
201 `licenca` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
202 `senha` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
203 `data_criacao` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
204 `hora_criacao` varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
205 `data_ultimo_acesso` varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
206 `hora_ultimo_acesso` varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
207 `bloqueado` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
208 `data_fim_utilizacao` varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
209 `e_mail` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
210 `administrador` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
211 `tipo_usuario` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
212 `pergunta_secreta` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
213 `resposta_secreta` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
214 `no_razao_social` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
215 `indc_inventariada` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
216 `codigo_user` decimal(5, 0) NULL DEFAULT NULL
217) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
218
219CREATE DEFINER = `root`@`%` PROCEDURE `sgriweb`.`anos`()
220BEGIN
221 DROP TEMPORARY TABLE
222 IF
223 EXISTS tabela;
224 CREATE TEMPORARY TABLE
225 IF
226 NOT EXISTS tabela ( ano INT );
227
228 SET @ano_atual = YEAR (
229 curdate());
230
231 SET @ano = 2005;
232 WHILE
233 @ano <= @ano_atual DO
234 INSERT INTO tabela
235 VALUES
236 ( @ano_atual );
237
238 SET @ano_atual = @ano_atual - 1;
239
240 END WHILE;
241 SELECT
242 *
243 FROM
244 tabela;
245END;
246
247DROP TABLE `sgriweb`.`protocolo_backup`;
248
249SET FOREIGN_KEY_CHECKS=1;