· 8 years ago · Dec 03, 2017, 10:04 PM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.5
6-- Dumped by pg_dump version 9.6.4
7
8-- Started on 2017-12-03 20:03:04 -02
9
10SET statement_timeout = 0;
11SET lock_timeout = 0;
12SET idle_in_transaction_session_timeout = 0;
13SET client_encoding = 'UTF8';
14SET standard_conforming_strings = on;
15SET check_function_bodies = false;
16SET client_min_messages = warning;
17SET row_security = off;
18
19--
20-- TOC entry 1 (class 3079 OID 12431)
21-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
22--
23
24CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
25
26
27--
28-- TOC entry 2194 (class 0 OID 0)
29-- Dependencies: 1
30-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
31--
32
33COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
34
35
36SET search_path = public, pg_catalog;
37
38SET default_tablespace = '';
39
40SET default_with_oids = false;
41
42--
43-- TOC entry 185 (class 1259 OID 32804)
44-- Name: escolas; Type: TABLE; Schema: public; Owner: postgres
45--
46
47CREATE TABLE escolas (
48 id integer NOT NULL,
49 nome character varying(200),
50 cep character varying(9),
51 endereco character varying(250),
52 bairro character varying(100),
53 nro character varying(20),
54 lat character varying(25),
55 long character varying(25)
56);
57
58
59ALTER TABLE escolas OWNER TO postgres;
60
61--
62-- TOC entry 186 (class 1259 OID 32807)
63-- Name: escolas_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
64--
65
66CREATE SEQUENCE escolas_id_seq
67 START WITH 1
68 INCREMENT BY 1
69 NO MINVALUE
70 NO MAXVALUE
71 CACHE 1;
72
73
74ALTER TABLE escolas_id_seq OWNER TO postgres;
75
76--
77-- TOC entry 2195 (class 0 OID 0)
78-- Dependencies: 186
79-- Name: escolas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
80--
81
82ALTER SEQUENCE escolas_id_seq OWNED BY escolas.id;
83
84
85--
86-- TOC entry 189 (class 1259 OID 32831)
87-- Name: matriculas; Type: TABLE; Schema: public; Owner: postgres
88--
89
90CREATE TABLE matriculas (
91 nome character varying(200),
92 rg character varying(15) NOT NULL,
93 nascimento date,
94 serie integer,
95 cep character varying(9),
96 endereco character varying(250),
97 bairro character varying(100),
98 nro character varying(20),
99 token character varying(30),
100 data date,
101 id_escola integer
102);
103
104
105ALTER TABLE matriculas OWNER TO postgres;
106
107--
108-- TOC entry 188 (class 1259 OID 32828)
109-- Name: periodo; Type: TABLE; Schema: public; Owner: postgres
110--
111
112CREATE TABLE periodo (
113 inicio date,
114 fim date
115);
116
117
118ALTER TABLE periodo OWNER TO postgres;
119
120--
121-- TOC entry 187 (class 1259 OID 32818)
122-- Name: vagas; Type: TABLE; Schema: public; Owner: postgres
123--
124
125CREATE TABLE vagas (
126 id_escola integer NOT NULL,
127 serie integer NOT NULL,
128 vagas integer,
129 versao integer DEFAULT 1
130);
131
132
133ALTER TABLE vagas OWNER TO postgres;
134
135--
136-- TOC entry 2057 (class 2604 OID 32809)
137-- Name: escolas id; Type: DEFAULT; Schema: public; Owner: postgres
138--
139
140ALTER TABLE ONLY escolas ALTER COLUMN id SET DEFAULT nextval('escolas_id_seq'::regclass);
141
142
143--
144-- TOC entry 2183 (class 0 OID 32804)
145-- Dependencies: 185
146-- Data for Name: escolas; Type: TABLE DATA; Schema: public; Owner: postgres
147--
148
149COPY escolas (id, nome, cep, endereco, bairro, nro, lat, long) FROM stdin;
1501 EMEF Admar Corrêa 96201390 General Flores da Cunha Vila Santa Tereza 116 -32.0474759 -52.0840014
1512 EMEF Altamir de Lacerda 96203550 Dr. Raul Pilla Vila Bernardete 2099 -32.0645147 -52.1483048
1523 EMEF Ana Neri 96217010 Ana Pernigotti Bolaxa -32.1635362 -52.1760188
1534 EMEF Anselmo Dias Lopes 96203410 Rua Pedro Carneiro Pereira Vila Maria 12 -32.0663698 -52.1525166
1545 EMEF Assis Brasil 96214430 Rua Dr. James Darcy Vila Santa Rosa -32.0823332 -52.1940832
1556 Escola de Belas Artes Heitor de Lemos – EBAHL 96200460 Jockey Club Prado 194 -32.0338728 -52.1041139
1567 EMEF Cidade do Rio Grande – CAIC 96201900 Avenida Itália Carreiros -32.079669 -52.1589369
1578 EMEF Cipriano Porto Alegre 96211330 Rua Irmã Otilia América 229 -32.0407754 -52.1312629
1589 EMEF Clemente Pinto 96211560 Rua Dom Pedro I Cidade Nova 444 -32.0396389 -52.1193287
15910 EMEF Dolores Garcia 96209190 Rua Darcy Cunha Mattos Cassino 387 -32.1879352 -52.1781567
16011 EMEF Dom Pedro II 96213170 Rua Cristóvão Pereira Vila São João 880 -32.0586513 -52.171522
16112 EMEF França Pinto 96211660 Rua Minas Gerais Miguel de Castro Moreira -32.0457477 -52.1231065
16213 EMEF Frederico E. Buchholz 96212014 Rua E. U. A. do Norte Junção -32.0539441 -52.132621
16314 EMEF Helena Small 96200290 Rua Barão de Cotegipe Centro 155 -32.0376277 -52.1027579
16415 EMEF Humberto de Campos 96200000 Senandes -32.133274 -52.1886657
16516 EMEF Jayme Gomes Monteiro 96213020 Rua Pandiá Calógeras PROFILURB 1299 -32.0624985 -52.1690676
16617 EMEF João de Oliveira Martins 96214150 Rua Irmão IsÃcio Castelo Branco 125 -32.0758748 -52.1814745
16718 EMEF Manoel Martins Mano 96216230 Rua Eng. João Kramer de Lima Parque São Pedro -32.1074736 -52.181673
16819 EMEF Maria da Graça Reyes 96204200 Rua Principal Zona Portuária -32.144672 -52.106522
16920 EMEE Maria Lúcia Luzzardi 96211480 Rua Marechal Deodoro Cidade Nova 595 -32.0352642 -52.1120369
17021 EMEF MarÃlia Rodrigues Santos 96207170 Rua 3 Boa Vista -32.1183646 -52.1757699
17122 EMEF Mate Amargo 96203000 Avenida Itália Leônidas 1506 -32.072467 -52.1536875
17223 EMEF Navegantes 96202610 Rua Vasco da Gama Navegantes 301A -32.0469724 -52.0981488
17324 EMEF Nilo da Fonseca 96200003 Senandes -32.142238 -52.1978537
17425 EMEF Pedro Carlos Peixoto Primo 96210000 Avenida Cassino Querência 1316 -32.199267 -52.1866537
17526 EMEF Porto Seguro 96215500 Rua das Algas Parque Marinha 340 -32.0987112 -52.1870159
17627 EMEF Ramiz Galvão 96214000 MARIA FRANCISCA Vila Mangueira 27 -32.063666 -52.0884386
17728 EMEF Barão do Rio Branco 96212450 Avenida dos Bandeirantes Junção 76 -32.0541844 -52.1483049
17829 EMEF Roque AÃta Jr 96202020 Avenida Oswaldo Aranha Vila Bernardete -32.0600852 -52.1443256
17930 EMEF Rui Poester Peixoto 96212490 Rua Quintino Bocaiúva Vila São Miguel 324 -32.0550553 -52.1564628
18031 EMEF Sant’Ana 96212230 Rua Colômbia Junção 586 -32.054904 -52.1416729
18132 EMEF São João Batista 96213020 Rua Pandiá Calógeras São João 598 -32.0624985 -52.1690676
18233 EMEF São Miguel 96212660 Rua Pandiá Calógeras Vila São Miguel 148 -32.0576305 -52.1518533
18334 EMEF de Tempo Integral Valdir Castro 96214400 Rua Juan Llopart Santa Rosa -32.0804224 -52.1936171
18435 EMEF Viriato Corrêa 96201001 Rua Almirante Barroso Getúlio Vargas 433 -32.0398907 -52.0992609
18536 EMEF Wanda Rocha Martins 96205090 Rua Fernando Osório Filho Cassino 201 -32.1807189 -52.1648878
18637 EMEF Zelly Pereira Esmeraldo 96214612 Rua Dante Dapuzzo Cidade de Ãgueda -32.0815042 -52.1921136
18738 EMEF Zenir de Souza Braga 96203160 Rua Ângelo Trindade Trevo 1888 -32.0878452 -52.1628974
18839 EMEF Eliézer de Carvalho Rios 96207280 Rua Erechim Cassino 15 -32.1775346 -52.1449887
18940 EMEf Carmen Regina Teixeira Baldino 96211040 Duque de Caxias Centro 496 -32.0349219 -52.1158143
19041 Escola Municipal de Iniciação Esportiva Ney Amado Costa 96211000 Avenida Pelotas Cidade Nova -32.0389432 -52.1217176
19142 Escola Municipal para a Diversidade Cultural e Inclusão Escola Viva 96211000 Avenida Portugal Cidade Nova 38 -32.0389432 -52.1173402
192\.
193
194
195--
196-- TOC entry 2196 (class 0 OID 0)
197-- Dependencies: 186
198-- Name: escolas_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
199--
200
201SELECT pg_catalog.setval('escolas_id_seq', 42, true);
202
203
204--
205-- TOC entry 2187 (class 0 OID 32831)
206-- Dependencies: 189
207-- Data for Name: matriculas; Type: TABLE DATA; Schema: public; Owner: postgres
208--
209
210COPY matriculas (nome, rg, nascimento, serie, cep, endereco, bairro, nro, token, data, id_escola) FROM stdin;
211Tymon 123456 2010-10-10 3 96000000 lol lol lol abcd 2010-10-11 1
212\.
213
214
215--
216-- TOC entry 2186 (class 0 OID 32828)
217-- Dependencies: 188
218-- Data for Name: periodo; Type: TABLE DATA; Schema: public; Owner: postgres
219--
220
221COPY periodo (inicio, fim) FROM stdin;
2222017-12-01 2017-12-30
223\.
224
225
226--
227-- TOC entry 2185 (class 0 OID 32818)
228-- Dependencies: 187
229-- Data for Name: vagas; Type: TABLE DATA; Schema: public; Owner: postgres
230--
231
232COPY vagas (id_escola, serie, vagas, versao) FROM stdin;
2331 2 100 1
2342 3 10 1
2351 3 10 1
236\.
237
238
239--
240-- TOC entry 2060 (class 2606 OID 32817)
241-- Name: escolas pk_escolas; Type: CONSTRAINT; Schema: public; Owner: postgres
242--
243
244ALTER TABLE ONLY escolas
245 ADD CONSTRAINT pk_escolas PRIMARY KEY (id);
246
247
248--
249-- TOC entry 2064 (class 2606 OID 32838)
250-- Name: matriculas pk_matricula; Type: CONSTRAINT; Schema: public; Owner: postgres
251--
252
253ALTER TABLE ONLY matriculas
254 ADD CONSTRAINT pk_matricula PRIMARY KEY (rg);
255
256
257--
258-- TOC entry 2062 (class 2606 OID 32844)
259-- Name: vagas pk_vagas; Type: CONSTRAINT; Schema: public; Owner: postgres
260--
261
262ALTER TABLE ONLY vagas
263 ADD CONSTRAINT pk_vagas PRIMARY KEY (id_escola, serie);
264
265
266--
267-- TOC entry 2065 (class 2606 OID 32821)
268-- Name: vagas pk_vagas; Type: FK CONSTRAINT; Schema: public; Owner: postgres
269--
270
271ALTER TABLE ONLY vagas
272 ADD CONSTRAINT pk_vagas FOREIGN KEY (id_escola) REFERENCES escolas(id);
273
274
275-- Completed on 2017-12-03 20:03:04 -02
276
277--
278-- PostgreSQL database dump complete
279--