Created
August 28, 2020 13:03
-
-
Save leonciocaminha/a3fbc71ca9b2d0420b4c981ff651434a to your computer and use it in GitHub Desktop.
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
Institution.find_or_create_by(name: "ASSESSORIA ESPECIAL DA VICE-GOVERNADORIA") | |
Institution.find_or_create_by(name: "ASSESSORIA ESPECIAL DE COMUNICAÇÃO") | |
Institution.find_or_create_by(name: "ASSESSORIA PARA ASSUNTOS INTERNACIONAIS") | |
Institution.find_or_create_by(name: "ASSESSORIA ESPECIAL DO GOVERNADOR") | |
Institution.find_or_create_by(name: "ASSESSORIA DE RELAÇÕES INSTITUCIONAIS") | |
Institution.find_or_create_by(name: "SECRETARIA DA SEGURANÇA PÚBLICA E DEFESA SOCIAL (SSPDS)") | |
Institution.find_or_create_by(name: "SECRETARIA DAS CIDADES (SCIDADES)") | |
Institution.find_or_create_by(name: "SECRETARIA DO DESENVOLVIMENTO AGRÁRIO (SDA)") | |
Institution.find_or_create_by(name: "SECRETARIA DA INFRAESTRUTURA (SEINFRA)") | |
Institution.find_or_create_by(name: "SECRETARIA DO TURISMO (SETUR)") | |
Institution.find_or_create_by(name: "SECRETARIA DA CIÊNCIA, TECNOLOGIA E EDUCAÇÃO SUPERIOR (SECITECE)") | |
Institution.find_or_create_by(name: "SECRETARIA DO ESPORTE E JUVENTUDE (SEJUV)") | |
Institution.find_or_create_by(name: "SECRETARIA DOS RECURSOS HÍDRICOS (SRH)") | |
Institution.find_or_create_by(name: "SECRETARIA DA CULTURA (SECULT)") | |
Institution.find_or_create_by(name: "SECRETARIA DA SAÚDE (SESA") | |
Institution.find_or_create_by(name: "SECRETARIA DE PROTEÇÃO SOCIAL, JUSTIÇA, CIDADANIA, MULHERES E DIREITOS HUMANOS (SPS)") | |
Institution.find_or_create_by(name: "SECRETARIA DA EDUCAÇÃO (SEDUC)") | |
Institution.find_or_create_by(name: "SECRETARIA DA ADMINISTRAÇÃO PENITENCIÁRIA (SAP)") | |
Institution.find_or_create_by(name: "CONTROLADORIA GERAL DE DISCIPLINA DOS ÓRGÃOS DE SEGURANÇA PÚBLICA E SISTEMA PENITENCIÁRIO (CGD)") | |
Institution.find_or_create_by(name: "CONTROLADORIA E OUVIDORIA GERAL DO ESTADO (CGE)") | |
Institution.find_or_create_by(name: "SECRETARIA DA FAZENDA (SEFAZ)") | |
Institution.find_or_create_by(name: "SECRETARIA DO MEIO AMBIENTE (SEMA)") | |
Institution.find_or_create_by(name: "SECRETARIA DO DESENVOLVIMENTO ECONÔMICO E TRABALHO (SEDET)") | |
Institution.find_or_create_by(name: "SECRETARIA DO PLANEJAMENTO E GESTÃO (SEPLAG)") | |
Institution.find_or_create_by(name: "CASA CIVIL") | |
Institution.find_or_create_by(name: "CASA MILITAR") | |
Institution.find_or_create_by(name: "PROCURADORIA GERAL DO ESTADO (PGE)") | |
Institution.find_or_create_by(name: "CONSELHO ESTADUAL DE EDUCAÇÃO (CEE)") | |
Institution.find_or_create_by(name: "MINISTÉRIO PÚBLICO DO ESTADO DO CEARÁ") | |
Institution.find_or_create_by(name: "DEFENSORIA PÚBLICA DO ESTADO DO CEARÁ") | |
Institution.find_or_create_by(name: "TRIBUNAL DE JUSTIÇA DO ESTADO DO CEARÁ") | |
class CreateProtocols < ActiveRecord::Migration[6.0] | |
def change | |
create_table :protocols do |t| | |
t.string :name | |
t.string :subject | |
t.date :reunion_date | |
t.string :observation | |
t.timestamps | |
end | |
end | |
end | |
class CreateInstitutions < ActiveRecord::Migration[6.0] | |
def change | |
create_table :institutions do |t| | |
t.string :name | |
t.timestamps | |
end | |
end | |
end | |
class AddProtocolFileToProtocols < ActiveRecord::Migration[6.0] | |
def change | |
add_column :protocols, :protocol_file, :string | |
end | |
end | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment