· 6 years ago · Jun 07, 2019, 09:00 PM
1██████╗ ███████╗███╗ ███╗ ██████╗ ███╗ ██╗███████╗ █████╗ ██████╗
2██╔══██╗██╔════╝████╗ ████║██╔═══██╗████╗ ██║██╔════╝██╔══██╗██╔══██╗
3██║ ██║█████╗ ██╔████╔██║██║ ██║██╔██╗ ██║███████╗███████║██║ ██║
4██║ ██║██╔══╝ ██║╚██╔╝██║██║ ██║██║╚██╗██║╚════██║██╔══██║██║ ██║
5██████╔╝███████╗██║ ╚═╝ ██║╚██████╔╝██║ ╚████║███████║██║ ██║██████╔╝
6╚═════╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═══╝╚══════╝╚═╝ ╚═╝╚═════╝
7
8TARGET : http://www.portal.facom.ufu.br/ ( FACULDADE DA COMPUTAÇÃO DE UBERLÂNDIA )
9
10"SORRY BRAZIL"
11
12Dados Dumpados Abaixo
13
14By : DemonSad
15
16--------------------------------------------------------------------------------
17-- PostgreSQL database dump
18--
19
20
21DROP DATABASE IF EXISTS 'DB-PI';
22
23
24CREATE DATABASE "DB-PI"
25 WITH ENCODING = 'UTF8'
26 CONNECTION LIMIT = -1;
27
28
29SET statement_timeout = 0;
30SET client_encoding = 'UTF8';
31SET standard_conforming_strings = off;
32SET check_function_bodies = false;
33SET client_min_messages = warning;
34SET escape_string_warning = off;
35
36SET search_path = public, pg_catalog;
37
38--
39-- TOC entry 1505 (class 1259 OID 33905)
40-- Dependencies: 6
41-- Name: user_serial; Type: SEQUENCE; Schema: public; Owner: -
42--
43
44CREATE SEQUENCE user_serial
45 START WITH 1
46 INCREMENT BY 1
47 NO MAXVALUE
48 NO MINVALUE
49 CACHE 1;
50
51
52--
53-- TOC entry 1806 (class 0 OID 0)
54-- Dependencies: 1505
55-- Name: user_serial; Type: SEQUENCE SET; Schema: public; Owner: -
56--
57
58SELECT pg_catalog.setval('user_serial', 1922, true);
59
60
61SET default_tablespace = '';
62
63SET default_with_oids = false;
64
65--
66-- TOC entry 1507 (class 1259 OID 35942)
67-- Dependencies: 1786 6
68-- Name: contato; Type: TABLE; Schema: public; Owner: -; Tablespace:
69--
70
71CREATE TABLE contato (
72 id integer DEFAULT nextval('user_serial'::regclass) NOT NULL,
73 nome character varying(40),
74 telefone character varying(13)
75);
76
77
78--
79-- TOC entry 1506 (class 1259 OID 33913)
80-- Dependencies: 6
81-- Name: contato_serial; Type: SEQUENCE; Schema: public; Owner: -
82--
83
84CREATE SEQUENCE contato_serial
85 START WITH 1
86 INCREMENT BY 1
87 NO MAXVALUE
88 NO MINVALUE
89 CACHE 1;
90
91
92--
93-- TOC entry 1809 (class 0 OID 0)
94-- Dependencies: 1506
95-- Name: contato_serial; Type: SEQUENCE SET; Schema: public; Owner: -
96--
97
98SELECT pg_catalog.setval('contato_serial', 172, true);
99
100
101--
102-- TOC entry 1508 (class 1259 OID 35977)
103-- Dependencies: 1787 1788 1789 1790 1791 1792 1793 1794 1795 6
104-- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
105--
106
107CREATE TABLE users (
108 id integer DEFAULT nextval('contato_serial'::regclass) NOT NULL,
109 name character varying(45) DEFAULT NULL::character varying,
110 address1 character varying(45) DEFAULT NULL::character varying,
111 address2 character varying(45) DEFAULT NULL::character varying,
112 city character varying(45) DEFAULT NULL::character varying,
113 state character varying(45) DEFAULT NULL::character varying,
114 zip character varying(45) DEFAULT NULL::character varying,
115 password character varying(45) DEFAULT NULL::character varying,
116 email character varying(45) DEFAULT NULL::character varying
117);
118
119
120--
121-- TOC entry 1800 (class 0 OID 35942)
122-- Dependencies: 1507
123-- Data for Name: contato; Type: TABLE DATA; Schema: public; Owner: -
124--
125
126INSERT INTO contato (id, nome, telefone) VALUES (1921, 'Ronaldo', '12345678');
127INSERT INTO contato (id, nome, telefone) VALUES (1913, 'pedro', '123');
128INSERT INTO contato (id, nome, telefone) VALUES (1917, 'Bretas', '96622424');
129INSERT INTO contato (id, nome, telefone) VALUES (1918, 'Chacal', '21000125');
130
131
132--
133-- TOC entry 1801 (class 0 OID 35977)
134-- Dependencies: 1508
135-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: -
136--
137
138INSERT INTO users (id, name, address1, address2, city, state, zip, password, email) VALUES (1, 'FLAVIO', 'AV. JOAO NAVES', 'CAMPUS SANTA MONICA', 'UBERLANDIA', 'MG', '38400-902', '123', 'flavio@facom.ufu.br');
139INSERT INTO users (id, name, address1, address2, city, state, zip, password, email) VALUES (2, '38400', NULL, NULL, NULL, NULL, NULL, '123', 'user@facom.ufu.br');
140INSERT INTO users (id, name, address1, address2, city, state, zip, password, email) VALUES (3, 'User Name2', 'Joao Naves, 2121', 'Santa Monica', 'Uberlandia', 'MG', '38400', '123', 'username2@facom.ufu.br');
141INSERT INTO users (id, name, address1, address2, city, state, zip, password, email) VALUES (4, 'Flavio de Oliveira Silva II', 'Joao Navas, 2121', 'Campus Santa Mônica', 'Uberlândia', 'MG', '38400-902', '123', 'userflavio@facom.ufu.br');
142INSERT INTO users (id, name, address1, address2, city, state, zip, password, email) VALUES (5, 'dante', 'abcdefghij', 'klmnopq', 'rstuv', 'xyz', '38414366', 'null', 'null');
143
144
145
146--
147-- TOC entry 1797 (class 2606 OID 35947)
148-- Dependencies: 1507 1507
149-- Name: contato_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
150--
151
152ALTER TABLE ONLY contato
153 ADD CONSTRAINT contato_pkey PRIMARY KEY (id);
154
155
156--
157-- TOC entry 1799 (class 2606 OID 35990)
158-- Dependencies: 1508 1508
159-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
160--
161
162ALTER TABLE ONLY users
163 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
164
165
166--
167-- TOC entry 1805 (class 0 OID 0)
168-- Dependencies: 6
169-- Name: public; Type: ACL; Schema: -; Owner: -
170--
171
172REVOKE ALL ON SCHEMA public FROM PUBLIC;
173REVOKE ALL ON SCHEMA public FROM postgres;
174GRANT ALL ON SCHEMA public TO postgres;
175GRANT ALL ON SCHEMA public TO PUBLIC;
176
177
178--
179-- TOC entry 1807 (class 0 OID 0)
180-- Dependencies: 1505
181-- Name: user_serial; Type: ACL; Schema: public; Owner: -
182--
183
184REVOKE ALL ON SEQUENCE user_serial FROM PUBLIC;
185GRANT ALL ON SEQUENCE user_serial TO webuser;
186
187
188--
189-- TOC entry 1808 (class 0 OID 0)
190-- Dependencies: 1507
191-- Name: contato; Type: ACL; Schema: public; Owner: -
192--
193
194REVOKE ALL ON TABLE contato FROM PUBLIC;
195GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE contato TO webuser;
196
197
198--
199-- TOC entry 1810 (class 0 OID 0)
200-- Dependencies: 1506
201-- Name: contato_serial; Type: ACL; Schema: public; Owner: -
202--
203
204REVOKE ALL ON SEQUENCE contato_serial FROM PUBLIC;
205GRANT ALL ON SEQUENCE contato_serial TO webuser;
206
207
208--
209-- TOC entry 1811 (class 0 OID 0)
210-- Dependencies: 1508
211-- Name: users; Type: ACL; Schema: public; Owner: -
212--
213
214REVOKE ALL ON TABLE users FROM PUBLIC;
215GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE users TO webuser;
216
217-- PostgreSQL database dump complete
218--