This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# @author: Lucas D'Ávila (Portabilis) | |
echo -e "\n\n** Atualizando apt-get" | |
sudo apt-get update -y | |
echo -e "\n\n** Instalando git" | |
sudo apt-get install -y git-core | |
echo -e "\n\n** Instalando apache e mod_rewrite" | |
sudo apt-get install -y apache2 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# @autor: Lucas D'Ávila (Portabilis) | |
echo -e "\n\n** Configurando virtual host" | |
sudo apt-get install -y rpl | |
sudo rm -f /etc/apache2/sites-enabled/ieducar | |
sudo rm -f /etc/apache2/sites-available/ieducar | |
sudo wget https://s3-us-west-2.amazonaws.com/portabilis2/public/ieducar/apache/sites-available/ieducar -P /etc/apache2/sites-available/ | |
sudo rpl "/home/portabilis" "/home/$USER" /etc/apache2/sites-available/ieducar |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
echo -e "\n** Rodando migração 72_alterar_nome_coluna_moradia_aluno.sql" | |
~/.pgvm/environments/8.2.23/bin/psql -d ieducar -p 5433 -c " | |
ALTER TABLE modules.moradia_aluno RENAME COLUMN foca TO fossa;" | |
echo -e "\n** Rodando migração 73_cria_campo_sus_fisica_documento.sql" | |
~/.pgvm/environments/8.2.23/bin/psql -d ieducar -p 5433 -c " | |
ALTER TABLE cadastro.fisica ADD COLUMN sus character varying(20);" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# @author: Lucas D'Ávila (Portabilis) | |
echo -e "\n\n** Instalando dependências para instalação postgresql" | |
sudo apt-get install -y libreadline6 libreadline6-dev make gcc zlib1g-dev | |
echo -e "\n\n** Instalando postgres 8.2.23 via pgvm" | |
pgvm install 8.2.23 | |
echo -e "\n\n** Criando cluster main" | |
pgvm use 8.2.23 | |
pgvm cluster create main |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
echo -e "\n** Rodando migração 53_cria_campo_observacao_matricula.sql" | |
~/.pgvm/environments/8.2.23/bin/psql -d ieducar -p 5433 -c " | |
ALTER TABLE pmieducar.matricula ADD COLUMN observacao character varying(300); | |
UPDATE pmieducar.matricula set observacao = 'Não Informado' where aprovado= 6;" | |
echo -e "\n** Rodando migração 54_retira_obrigatoriedade_de_campos_hora_em_escola_serie.sql" | |
~/.pgvm/environments/8.2.23/bin/psql -d ieducar -p 5433 -c " | |
ALTER TABLE pmieducar.escola_serie ALTER COLUMN hora_inicial drop not null; |