atualizar_bd_mysql_301.sql 8.68 KB
Edit Raw Blame History Permalink



1

2

3

4

5

6

7

8

9

10

11

12

13

14

15


SET FOREIGN_KEY_CHECKS=0;

UPDATE versao SET versao_codigo='8.4.39';
UPDATE versao SET ultima_atualizacao_bd='2015-11-27';
UPDATE versao SET ultima_atualizacao_codigo='2015-11-27';
UPDATE versao SET versao_bd=301;

DELETE FROM artefatos_tipo WHERE artefato_tipo_id=41;

INSERT INTO artefatos_tipo (artefato_tipo_id, artefato_tipo_nome, artefato_tipo_civil, artefato_tipo_arquivo, artefato_tipo_endereco, artefato_tipo_imagem, artefato_tipo_descricao, artefato_tipo_campos, artefato_tipo_html) VALUES
(41,'Relatório de Status das Tarefas','mpog','status_pro.html','modulos/projetos/artefatos/mpog','','',0x613A393A7B733A353A2263616D706F223B613A363A7B693A313B613A323A7B733A343A227469706F223B733A343A226C6F676F223B733A353A226461646F73223B733A31313A2270726F6A65746F5F636961223B7D693A323B613A323A7B733A343A227469706F223B733A393A226361626563616C686F223B733A353A226461646F73223B733A31313A2270726F6A65746F5F636961223B7D693A333B613A323A7B733A343A227469706F223B733A31333A22626C6F636F5F73696D706C6573223B733A353A226461646F73223B733A31343A2270726F6A65746F5F636F6469676F223B7D693A343B613A323A7B733A343A227469706F223B733A31333A22626C6F636F5F73696D706C6573223B733A353A226461646F73223B733A31323A2270726F6A65746F5F6E6F6D65223B7D693A353B613A323A7B733A343A227469706F223B733A31343A226C697374615F657370656369616C223B733A353A226461646F73223B733A31323A226C697374615F737461747573223B7D693A363B613A323A7B733A343A227469706F223B733A363A2262726173616F223B733A353A226461646F73223B733A31313A2270726F6A65746F5F636961223B7D7D733A31313A226D6F64656C6F5F7469706F223B733A323A223431223B733A363A2265646963616F223B623A303B733A393A22696D7072657373616F223B623A303B733A393A226D6F64656C6F5F6964223B693A303B733A393A2270617261677261666F223B693A303B733A31353A226D6F64656C6F5F6461646F735F6964223B693A303B733A363A226D6F64656C6F223B4E3B733A333A22716E74223B693A363B7D,'<table width=\"100%\" cellspacing=0 cellpadding=0 align=\"center\" border=0 style=\"margin-left:12pt; margin-right: 12pt\"><tr><td>\t<table width=\"100%\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\">\t\t<tr>\t\t\t<td valign=\"middle\" align=\"center\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\">{campo1}</td>\t\t\t<td width=\"100%\" align=\"center\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><b>{campo2}</b></td>\t\t\t<td valign=\"middle\" align=\"center\">{campo6}</td>\t\t</tr>\t\t<tr><td colspan=\"3\" align=\"center\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><b>METODOLOGIA DE GERENCIAMENTO DE PROJETOS</b></td></tr>\t\t<tr><td colspan=\"3\" align=\"center\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><strong>Relat&oacute;rio de Status das Tarefas</strong></td></tr>\t\t<tr>\t\t\t<td colspan=\"3\" align=\"center\">\t\t\t\t<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\">\t\t\t\t\t<tr>\t\t\t\t\t\t<td width=\"8%\" bgcolor=\"#cccccc\" nowrap=\"nowrap\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><b>Código/Sigla:</b></td>\t\t\t\t\t\t<td width=\"19%\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\">{campo3}</td>\t\t\t\t\t\t<td width=\"11%\" nowrap=\"nowrap\" bgcolor=\"#cccccc\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><b>Nome do Projeto:</b></td>\t\t\t\t\t\t<td width=\"62%\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\">{campo4}</td>\t\t\t\t\t</tr>\t\t\t\t</table>\t\t\t</td>\t\t</tr>\t</table>\t<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"> \t\t<tr><td colspan=20 align=\"center\" >&nbsp;</td></tr>\t\t<tr><td colspan=20 align=\"left\"><b>1.&nbsp;TAREFAS</b></td></tr>\t\t<tr><td colspan=20 align=\"left\">{campo5}</td></tr>\t</table></td></tr></table>');

INSERT INTO artefatos_tipo (artefato_tipo_id, artefato_tipo_nome, artefato_tipo_civil, artefato_tipo_arquivo, artefato_tipo_endereco, artefato_tipo_imagem, artefato_tipo_descricao, artefato_tipo_campos, artefato_tipo_html) VALUES
 (51,'Cabeçalho Projeto Simples','mpog','cabecalho_projeto_pro.html','modulos/atas/artefatos/mpog',NULL,NULL,0x613A393A7B733A353A2263616D706F223B613A353A7B693A313B613A323A7B733A343A227469706F223B733A343A226C6F676F223B733A353A226461646F73223B733A31313A2270726F6A65746F5F636961223B7D693A323B613A323A7B733A343A227469706F223B733A393A226361626563616C686F223B733A353A226461646F73223B733A31313A2270726F6A65746F5F636961223B7D693A333B613A323A7B733A343A227469706F223B733A31343A226C697374615F657370656369616C223B733A353A226461646F73223B733A31343A2270726F6A65746F5F636F6469676F223B7D693A343B613A323A7B733A343A227469706F223B733A31333A22626C6F636F5F73696D706C6573223B733A353A226461646F73223B733A31323A2270726F6A65746F5F6E6F6D65223B7D693A353B613A323A7B733A343A227469706F223B733A31333A22626C6F636F5F73696D706C6573223B733A353A226461646F73223B733A31363A22746974756C6F5F6361626563616C686F223B7D7D733A31313A226D6F64656C6F5F7469706F223B733A323A223437223B733A363A2265646963616F223B623A303B733A393A22696D7072657373616F223B623A303B733A393A226D6F64656C6F5F6964223B693A303B733A393A2270617261677261666F223B693A303B733A31353A226D6F64656C6F5F6461646F735F6964223B693A303B733A363A226D6F64656C6F223B4E3B733A333A22716E74223B693A363B7D,'<table width=\"100%\" cellspacing=0 cellpadding=0 align=\"center\" border=0><tr><td><table width=\"100%\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><tr><td valign=\"middle\" align=\"center\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\">{campo1}</td><td width=\"100%\" align=\"center\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><b>{campo2}</b></td><td valign=\"middle\" align=\"center\"><img src=\"imagens/brasao_republica.gif\" alt=\"\" border=0 /></td></tr><tr><td colspan=\"3\" align=\"center\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><b>METODOLOGIA DE GERENCIAMENTO DE PROJETOS</b></td></tr><tr><td colspan=\"3\" align=\"center\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><strong>{campo5}</strong></td></tr><tr><td colspan=\"3\" align=\"center\"><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><tr><td width=\"8%\" bgcolor=\"#cccccc\" nowrap=\"nowrap\"><b>Código/Sigla:</b></td><td width=\"19%\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\">{campo3}</td><td width=\"11%\" nowrap=\"nowrap\" bgcolor=\"#cccccc\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><b>Nome do Projeto:</b></td><td width=\"62%\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\">{campo4}</td></tr></table></td></tr></table></td></tr></table>'),
 (52,'Cabeçalho Projeto Simples','cnj','cabecalho_projeto_pro.html','modulos/atas/artefatos/cnj',NULL,NULL,0x613A393A7B733A353A2263616D706F223B613A353A7B693A313B613A323A7B733A343A227469706F223B733A343A226C6F676F223B733A353A226461646F73223B733A31313A2270726F6A65746F5F636961223B7D693A323B613A323A7B733A343A227469706F223B733A393A226361626563616C686F223B733A353A226461646F73223B733A31313A2270726F6A65746F5F636961223B7D693A333B613A323A7B733A343A227469706F223B733A31343A226C697374615F657370656369616C223B733A353A226461646F73223B733A31343A2270726F6A65746F5F636F6469676F223B7D693A343B613A323A7B733A343A227469706F223B733A31333A22626C6F636F5F73696D706C6573223B733A353A226461646F73223B733A31323A2270726F6A65746F5F6E6F6D65223B7D693A353B613A323A7B733A343A227469706F223B733A31333A22626C6F636F5F73696D706C6573223B733A353A226461646F73223B733A31363A22746974756C6F5F6361626563616C686F223B7D7D733A31313A226D6F64656C6F5F7469706F223B733A323A223437223B733A363A2265646963616F223B623A303B733A393A22696D7072657373616F223B623A303B733A393A226D6F64656C6F5F6964223B693A303B733A393A2270617261677261666F223B693A303B733A31353A226D6F64656C6F5F6461646F735F6964223B693A303B733A363A226D6F64656C6F223B4E3B733A333A22716E74223B693A363B7D,'<table width=\"100%\" cellspacing=0 cellpadding=0 align=\"center\"><tr><td colspan=20 align=center><table width=\"100%\" border=0 cellpadding=\"0\" cellspacing=\"0\"><tr><td valign=\"middle\" align=\"center\"><span style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><img src=\"imagens/cnj.png\" alt=\"\" border=0 /></span></td><td width=\"100%\" align=\"center\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\"><b>{campo2}</b><br /><strong>{campo3} {campo4} </strong><br /><strong>{campo5}</strong></td><td valign=\"middle\" align=\"center\">{campo1}</td></tr><tr><td colspan=\"20\" align=\"center\" style=\"font-family:Times New Roman, Times, serif; font-size:12pt;\">&nbsp;</td></tr></table></td></tr></table>');