· 8 years ago · Jul 16, 2018, 05:52 PM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.7
6-- Dumped by pg_dump version 9.6.7
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SET check_function_bodies = false;
14SET client_min_messages = warning;
15SET row_security = off;
16
17SET search_path = public, pg_catalog;
18
19ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT user_id_refs_id_40c41112;
20ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT group_id_refs_id_f4b32aac;
21ALTER TABLE ONLY public.django_admin_log DROP CONSTRAINT django_admin_log_user_id_fkey;
22ALTER TABLE ONLY public.django_admin_log DROP CONSTRAINT django_admin_log_content_type_id_fkey;
23ALTER TABLE ONLY public.core_provedorbloqueio DROP CONSTRAINT core_provedorbloqueio_provedor_id_fkey;
24ALTER TABLE ONLY public.auth_permission DROP CONSTRAINT content_type_id_refs_id_d043b34a;
25ALTER TABLE ONLY public.core_provedorbloqueio DROP CONSTRAINT bloqueio_id_refs_id_dc2e875f;
26ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT auth_user_user_permissions_permission_id_fkey;
27ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT auth_user_groups_group_id_fkey;
28ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT auth_group_permissions_permission_id_fkey;
29DROP INDEX public.django_session_session_key_like;
30DROP INDEX public.django_session_expire_date;
31DROP INDEX public.django_admin_log_user_id;
32DROP INDEX public.django_admin_log_content_type_id;
33DROP INDEX public.core_provedorbloqueio_provedor_id;
34DROP INDEX public.core_provedorbloqueio_bloqueio_id;
35DROP INDEX public.auth_user_username_like;
36DROP INDEX public.auth_user_user_permissions_user_id;
37DROP INDEX public.auth_user_user_permissions_permission_id;
38DROP INDEX public.auth_user_groups_user_id;
39DROP INDEX public.auth_user_groups_group_id;
40DROP INDEX public.auth_permission_content_type_id;
41DROP INDEX public.auth_group_permissions_permission_id;
42DROP INDEX public.auth_group_permissions_group_id;
43DROP INDEX public.auth_group_name_like;
44ALTER TABLE ONLY public.django_session DROP CONSTRAINT django_session_pkey;
45ALTER TABLE ONLY public.django_content_type DROP CONSTRAINT django_content_type_pkey;
46ALTER TABLE ONLY public.django_content_type DROP CONSTRAINT django_content_type_app_label_model_key;
47ALTER TABLE ONLY public.django_admin_log DROP CONSTRAINT django_admin_log_pkey;
48ALTER TABLE ONLY public.core_provedorbloqueio DROP CONSTRAINT core_provedorbloqueio_provedor_id_bloqueio_id_key;
49ALTER TABLE ONLY public.core_provedorbloqueio DROP CONSTRAINT core_provedorbloqueio_pkey;
50ALTER TABLE ONLY public.core_provedor DROP CONSTRAINT core_provedor_pkey;
51ALTER TABLE ONLY public.core_bloqueio DROP CONSTRAINT core_bloqueio_pkey;
52ALTER TABLE ONLY public.auth_user DROP CONSTRAINT auth_user_username_key;
53ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT auth_user_user_permissions_user_id_permission_id_key;
54ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT auth_user_user_permissions_pkey;
55ALTER TABLE ONLY public.auth_user DROP CONSTRAINT auth_user_pkey;
56ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT auth_user_groups_user_id_group_id_key;
57ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT auth_user_groups_pkey;
58ALTER TABLE ONLY public.auth_permission DROP CONSTRAINT auth_permission_pkey;
59ALTER TABLE ONLY public.auth_permission DROP CONSTRAINT auth_permission_content_type_id_codename_key;
60ALTER TABLE ONLY public.auth_group DROP CONSTRAINT auth_group_pkey;
61ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT auth_group_permissions_pkey;
62ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT auth_group_permissions_group_id_permission_id_key;
63ALTER TABLE ONLY public.auth_group DROP CONSTRAINT auth_group_name_key;
64ALTER TABLE public.django_content_type ALTER COLUMN id DROP DEFAULT;
65ALTER TABLE public.django_admin_log ALTER COLUMN id DROP DEFAULT;
66ALTER TABLE public.core_provedorbloqueio ALTER COLUMN id DROP DEFAULT;
67ALTER TABLE public.core_provedor ALTER COLUMN id DROP DEFAULT;
68ALTER TABLE public.core_bloqueio ALTER COLUMN id DROP DEFAULT;
69ALTER TABLE public.auth_user_user_permissions ALTER COLUMN id DROP DEFAULT;
70ALTER TABLE public.auth_user_groups ALTER COLUMN id DROP DEFAULT;
71ALTER TABLE public.auth_user ALTER COLUMN id DROP DEFAULT;
72ALTER TABLE public.auth_permission ALTER COLUMN id DROP DEFAULT;
73ALTER TABLE public.auth_group_permissions ALTER COLUMN id DROP DEFAULT;
74ALTER TABLE public.auth_group ALTER COLUMN id DROP DEFAULT;
75DROP TABLE public.django_session;
76DROP SEQUENCE public.django_content_type_id_seq;
77DROP TABLE public.django_content_type;
78DROP SEQUENCE public.django_admin_log_id_seq;
79DROP TABLE public.django_admin_log;
80DROP SEQUENCE public.core_provedorbloqueio_id_seq;
81DROP TABLE public.core_provedorbloqueio;
82DROP SEQUENCE public.core_provedor_id_seq;
83DROP TABLE public.core_provedor;
84DROP SEQUENCE public.core_bloqueio_id_seq;
85DROP TABLE public.core_bloqueio;
86DROP SEQUENCE public.auth_user_user_permissions_id_seq;
87DROP TABLE public.auth_user_user_permissions;
88DROP SEQUENCE public.auth_user_id_seq;
89DROP SEQUENCE public.auth_user_groups_id_seq;
90DROP TABLE public.auth_user_groups;
91DROP TABLE public.auth_user;
92DROP SEQUENCE public.auth_permission_id_seq;
93DROP TABLE public.auth_permission;
94DROP SEQUENCE public.auth_group_permissions_id_seq;
95DROP TABLE public.auth_group_permissions;
96DROP SEQUENCE public.auth_group_id_seq;
97DROP TABLE public.auth_group;
98DROP EXTENSION plpgsql;
99DROP SCHEMA public;
100--
101-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
102--
103
104CREATE SCHEMA public;
105
106
107ALTER SCHEMA public OWNER TO postgres;
108
109--
110-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
111--
112
113COMMENT ON SCHEMA public IS 'standard public schema';
114
115
116--
117-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
118--
119
120CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
121
122
123--
124-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
125--
126
127COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
128
129
130SET search_path = public, pg_catalog;
131
132SET default_tablespace = '';
133
134SET default_with_oids = false;
135
136--
137-- Name: auth_group; Type: TABLE; Schema: public; Owner: user_sgpadmin
138--
139
140CREATE TABLE auth_group (
141 id integer NOT NULL,
142 name character varying(80) NOT NULL
143);
144
145
146ALTER TABLE auth_group OWNER TO user_sgpadmin;
147
148--
149-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
150--
151
152CREATE SEQUENCE auth_group_id_seq
153 START WITH 1
154 INCREMENT BY 1
155 NO MINVALUE
156 NO MAXVALUE
157 CACHE 1;
158
159
160ALTER TABLE auth_group_id_seq OWNER TO user_sgpadmin;
161
162--
163-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
164--
165
166ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id;
167
168
169--
170-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: user_sgpadmin
171--
172
173CREATE TABLE auth_group_permissions (
174 id integer NOT NULL,
175 group_id integer NOT NULL,
176 permission_id integer NOT NULL
177);
178
179
180ALTER TABLE auth_group_permissions OWNER TO user_sgpadmin;
181
182--
183-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
184--
185
186CREATE SEQUENCE auth_group_permissions_id_seq
187 START WITH 1
188 INCREMENT BY 1
189 NO MINVALUE
190 NO MAXVALUE
191 CACHE 1;
192
193
194ALTER TABLE auth_group_permissions_id_seq OWNER TO user_sgpadmin;
195
196--
197-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
198--
199
200ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id;
201
202
203--
204-- Name: auth_permission; Type: TABLE; Schema: public; Owner: user_sgpadmin
205--
206
207CREATE TABLE auth_permission (
208 id integer NOT NULL,
209 name character varying(50) NOT NULL,
210 content_type_id integer NOT NULL,
211 codename character varying(100) NOT NULL
212);
213
214
215ALTER TABLE auth_permission OWNER TO user_sgpadmin;
216
217--
218-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
219--
220
221CREATE SEQUENCE auth_permission_id_seq
222 START WITH 1
223 INCREMENT BY 1
224 NO MINVALUE
225 NO MAXVALUE
226 CACHE 1;
227
228
229ALTER TABLE auth_permission_id_seq OWNER TO user_sgpadmin;
230
231--
232-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
233--
234
235ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;
236
237
238--
239-- Name: auth_user; Type: TABLE; Schema: public; Owner: user_sgpadmin
240--
241
242CREATE TABLE auth_user (
243 id integer NOT NULL,
244 password character varying(128) NOT NULL,
245 last_login timestamp with time zone NOT NULL,
246 is_superuser boolean NOT NULL,
247 username character varying(30) NOT NULL,
248 first_name character varying(30) NOT NULL,
249 last_name character varying(30) NOT NULL,
250 email character varying(75) NOT NULL,
251 is_staff boolean NOT NULL,
252 is_active boolean NOT NULL,
253 date_joined timestamp with time zone NOT NULL
254);
255
256
257ALTER TABLE auth_user OWNER TO user_sgpadmin;
258
259--
260-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: user_sgpadmin
261--
262
263CREATE TABLE auth_user_groups (
264 id integer NOT NULL,
265 user_id integer NOT NULL,
266 group_id integer NOT NULL
267);
268
269
270ALTER TABLE auth_user_groups OWNER TO user_sgpadmin;
271
272--
273-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
274--
275
276CREATE SEQUENCE auth_user_groups_id_seq
277 START WITH 1
278 INCREMENT BY 1
279 NO MINVALUE
280 NO MAXVALUE
281 CACHE 1;
282
283
284ALTER TABLE auth_user_groups_id_seq OWNER TO user_sgpadmin;
285
286--
287-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
288--
289
290ALTER SEQUENCE auth_user_groups_id_seq OWNED BY auth_user_groups.id;
291
292
293--
294-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
295--
296
297CREATE SEQUENCE auth_user_id_seq
298 START WITH 1
299 INCREMENT BY 1
300 NO MINVALUE
301 NO MAXVALUE
302 CACHE 1;
303
304
305ALTER TABLE auth_user_id_seq OWNER TO user_sgpadmin;
306
307--
308-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
309--
310
311ALTER SEQUENCE auth_user_id_seq OWNED BY auth_user.id;
312
313
314--
315-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: user_sgpadmin
316--
317
318CREATE TABLE auth_user_user_permissions (
319 id integer NOT NULL,
320 user_id integer NOT NULL,
321 permission_id integer NOT NULL
322);
323
324
325ALTER TABLE auth_user_user_permissions OWNER TO user_sgpadmin;
326
327--
328-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
329--
330
331CREATE SEQUENCE auth_user_user_permissions_id_seq
332 START WITH 1
333 INCREMENT BY 1
334 NO MINVALUE
335 NO MAXVALUE
336 CACHE 1;
337
338
339ALTER TABLE auth_user_user_permissions_id_seq OWNER TO user_sgpadmin;
340
341--
342-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
343--
344
345ALTER SEQUENCE auth_user_user_permissions_id_seq OWNED BY auth_user_user_permissions.id;
346
347
348--
349-- Name: core_bloqueio; Type: TABLE; Schema: public; Owner: user_sgpadmin
350--
351
352CREATE TABLE core_bloqueio (
353 id integer NOT NULL,
354 descricao character varying(250) NOT NULL,
355 url_name character varying(100) NOT NULL,
356 metodo character varying(10) NOT NULL
357);
358
359
360ALTER TABLE core_bloqueio OWNER TO user_sgpadmin;
361
362--
363-- Name: core_bloqueio_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
364--
365
366CREATE SEQUENCE core_bloqueio_id_seq
367 START WITH 1
368 INCREMENT BY 1
369 NO MINVALUE
370 NO MAXVALUE
371 CACHE 1;
372
373
374ALTER TABLE core_bloqueio_id_seq OWNER TO user_sgpadmin;
375
376--
377-- Name: core_bloqueio_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
378--
379
380ALTER SEQUENCE core_bloqueio_id_seq OWNED BY core_bloqueio.id;
381
382
383--
384-- Name: core_provedor; Type: TABLE; Schema: public; Owner: user_sgpadmin
385--
386
387CREATE TABLE core_provedor (
388 id integer NOT NULL,
389 sigla character varying(50) NOT NULL,
390 nome character varying(250) NOT NULL
391);
392
393
394ALTER TABLE core_provedor OWNER TO user_sgpadmin;
395
396--
397-- Name: core_provedor_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
398--
399
400CREATE SEQUENCE core_provedor_id_seq
401 START WITH 1
402 INCREMENT BY 1
403 NO MINVALUE
404 NO MAXVALUE
405 CACHE 1;
406
407
408ALTER TABLE core_provedor_id_seq OWNER TO user_sgpadmin;
409
410--
411-- Name: core_provedor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
412--
413
414ALTER SEQUENCE core_provedor_id_seq OWNED BY core_provedor.id;
415
416
417--
418-- Name: core_provedorbloqueio; Type: TABLE; Schema: public; Owner: user_sgpadmin
419--
420
421CREATE TABLE core_provedorbloqueio (
422 id integer NOT NULL,
423 provedor_id integer NOT NULL,
424 bloqueio_id integer NOT NULL
425);
426
427
428ALTER TABLE core_provedorbloqueio OWNER TO user_sgpadmin;
429
430--
431-- Name: core_provedorbloqueio_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
432--
433
434CREATE SEQUENCE core_provedorbloqueio_id_seq
435 START WITH 1
436 INCREMENT BY 1
437 NO MINVALUE
438 NO MAXVALUE
439 CACHE 1;
440
441
442ALTER TABLE core_provedorbloqueio_id_seq OWNER TO user_sgpadmin;
443
444--
445-- Name: core_provedorbloqueio_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
446--
447
448ALTER SEQUENCE core_provedorbloqueio_id_seq OWNED BY core_provedorbloqueio.id;
449
450
451--
452-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: user_sgpadmin
453--
454
455CREATE TABLE django_admin_log (
456 id integer NOT NULL,
457 action_time timestamp with time zone NOT NULL,
458 user_id integer NOT NULL,
459 content_type_id integer,
460 object_id text,
461 object_repr character varying(200) NOT NULL,
462 action_flag smallint NOT NULL,
463 change_message text NOT NULL,
464 CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
465);
466
467
468ALTER TABLE django_admin_log OWNER TO user_sgpadmin;
469
470--
471-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
472--
473
474CREATE SEQUENCE django_admin_log_id_seq
475 START WITH 1
476 INCREMENT BY 1
477 NO MINVALUE
478 NO MAXVALUE
479 CACHE 1;
480
481
482ALTER TABLE django_admin_log_id_seq OWNER TO user_sgpadmin;
483
484--
485-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
486--
487
488ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id;
489
490
491--
492-- Name: django_content_type; Type: TABLE; Schema: public; Owner: user_sgpadmin
493--
494
495CREATE TABLE django_content_type (
496 id integer NOT NULL,
497 name character varying(100) NOT NULL,
498 app_label character varying(100) NOT NULL,
499 model character varying(100) NOT NULL
500);
501
502
503ALTER TABLE django_content_type OWNER TO user_sgpadmin;
504
505--
506-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: user_sgpadmin
507--
508
509CREATE SEQUENCE django_content_type_id_seq
510 START WITH 1
511 INCREMENT BY 1
512 NO MINVALUE
513 NO MAXVALUE
514 CACHE 1;
515
516
517ALTER TABLE django_content_type_id_seq OWNER TO user_sgpadmin;
518
519--
520-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user_sgpadmin
521--
522
523ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id;
524
525
526--
527-- Name: django_session; Type: TABLE; Schema: public; Owner: user_sgpadmin
528--
529
530CREATE TABLE django_session (
531 session_key character varying(40) NOT NULL,
532 session_data text NOT NULL,
533 expire_date timestamp with time zone NOT NULL
534);
535
536
537ALTER TABLE django_session OWNER TO user_sgpadmin;
538
539--
540-- Name: auth_group id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
541--
542
543ALTER TABLE ONLY auth_group ALTER COLUMN id SET DEFAULT nextval('auth_group_id_seq'::regclass);
544
545
546--
547-- Name: auth_group_permissions id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
548--
549
550ALTER TABLE ONLY auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('auth_group_permissions_id_seq'::regclass);
551
552
553--
554-- Name: auth_permission id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
555--
556
557ALTER TABLE ONLY auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass);
558
559
560--
561-- Name: auth_user id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
562--
563
564ALTER TABLE ONLY auth_user ALTER COLUMN id SET DEFAULT nextval('auth_user_id_seq'::regclass);
565
566
567--
568-- Name: auth_user_groups id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
569--
570
571ALTER TABLE ONLY auth_user_groups ALTER COLUMN id SET DEFAULT nextval('auth_user_groups_id_seq'::regclass);
572
573
574--
575-- Name: auth_user_user_permissions id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
576--
577
578ALTER TABLE ONLY auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('auth_user_user_permissions_id_seq'::regclass);
579
580
581--
582-- Name: core_bloqueio id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
583--
584
585ALTER TABLE ONLY core_bloqueio ALTER COLUMN id SET DEFAULT nextval('core_bloqueio_id_seq'::regclass);
586
587
588--
589-- Name: core_provedor id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
590--
591
592ALTER TABLE ONLY core_provedor ALTER COLUMN id SET DEFAULT nextval('core_provedor_id_seq'::regclass);
593
594
595--
596-- Name: core_provedorbloqueio id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
597--
598
599ALTER TABLE ONLY core_provedorbloqueio ALTER COLUMN id SET DEFAULT nextval('core_provedorbloqueio_id_seq'::regclass);
600
601
602--
603-- Name: django_admin_log id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
604--
605
606ALTER TABLE ONLY django_admin_log ALTER COLUMN id SET DEFAULT nextval('django_admin_log_id_seq'::regclass);
607
608
609--
610-- Name: django_content_type id; Type: DEFAULT; Schema: public; Owner: user_sgpadmin
611--
612
613ALTER TABLE ONLY django_content_type ALTER COLUMN id SET DEFAULT nextval('django_content_type_id_seq'::regclass);
614
615
616--
617-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
618--
619
620COPY auth_group (id, name) FROM stdin;
621\.
622
623
624--
625-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
626--
627
628SELECT pg_catalog.setval('auth_group_id_seq', 1, false);
629
630
631--
632-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
633--
634
635COPY auth_group_permissions (id, group_id, permission_id) FROM stdin;
636\.
637
638
639--
640-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
641--
642
643SELECT pg_catalog.setval('auth_group_permissions_id_seq', 1, false);
644
645
646--
647-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
648--
649
650COPY auth_permission (id, name, content_type_id, codename) FROM stdin;
6511 Can add permission 1 add_permission
6522 Can change permission 1 change_permission
6533 Can delete permission 1 delete_permission
6544 Can add group 2 add_group
6555 Can change group 2 change_group
6566 Can delete group 2 delete_group
6577 Can add user 3 add_user
6588 Can change user 3 change_user
6599 Can delete user 3 delete_user
66010 Can add content type 4 add_contenttype
66111 Can change content type 4 change_contenttype
66212 Can delete content type 4 delete_contenttype
66313 Can add session 5 add_session
66414 Can change session 5 change_session
66515 Can delete session 5 delete_session
66616 Can add log entry 6 add_logentry
66717 Can change log entry 6 change_logentry
66818 Can delete log entry 6 delete_logentry
66919 Can add SGP - Provedor 7 add_provedor
67020 Can change SGP - Provedor 7 change_provedor
67121 Can delete SGP - Provedor 7 delete_provedor
67222 Can add SGP - Bloqueio Provedor 8 add_provedorbloqueio
67323 Can change SGP - Bloqueio Provedor 8 change_provedorbloqueio
67424 Can delete SGP - Bloqueio Provedor 8 delete_provedorbloqueio
67525 Can add SGP - Bloqueio 9 add_bloqueio
67626 Can change SGP - Bloqueio 9 change_bloqueio
67727 Can delete SGP - Bloqueio 9 delete_bloqueio
678\.
679
680
681--
682-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
683--
684
685SELECT pg_catalog.setval('auth_permission_id_seq', 27, true);
686
687
688--
689-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
690--
691
692COPY auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) FROM stdin;
6931 pbkdf2_sha256$12000$jZvEkoTFIxd5$C6nj5lLvf9G5no/Q5T+NmtRF2m+5muacI3Dvxz/EPIM= 2014-10-15 18:12:11.165965-03 t admin opencode@gmail.com t t 2014-09-04 00:38:20.731-03
694\.
695
696
697--
698-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
699--
700
701COPY auth_user_groups (id, user_id, group_id) FROM stdin;
702\.
703
704
705--
706-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
707--
708
709SELECT pg_catalog.setval('auth_user_groups_id_seq', 1, false);
710
711
712--
713-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
714--
715
716SELECT pg_catalog.setval('auth_user_id_seq', 2, true);
717
718
719--
720-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
721--
722
723COPY auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
7241 2 1
7252 2 2
7263 2 3
7274 2 4
7285 2 5
7296 2 6
7307 2 7
7318 2 8
7329 2 9
73310 2 10
73411 2 11
73512 2 12
73613 2 13
73714 2 14
73815 2 15
73916 2 16
74017 2 17
74118 2 18
74219 2 19
74320 2 20
74421 2 21
74522 2 22
74623 2 23
74724 2 24
74825 2 25
74926 2 26
75027 2 27
751\.
752
753
754--
755-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
756--
757
758SELECT pg_catalog.setval('auth_user_user_permissions_id_seq', 27, true);
759
760
761--
762-- Data for Name: core_bloqueio; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
763--
764
765COPY core_bloqueio (id, descricao, url_name, metodo) FROM stdin;
7662 Bloquear Autenticação no Sistema SGP sys_login
7673 Bloquear Cadastro de Novo Cliente cliente_add
7684 Bloquear Cadastro de Titulos em Lote titulo_add_lote
7695 Bloquear Cadastro de Titulos Avulsos titulo_add_avulso
7706 Bloquear Alteração Cadastro Cliente cliente_edit POST
7717 Bloquear Alteração de Plano plano_edit POST
7728 Bloquear Cadastro de Plano plano_add
7739 Bloquear Cadastro Serviço de Internet servicoi_add
77410 Bloquear Alteração Serviço de Internet servicoi_edit POST
77511 Bloquear Alteração de Status do Contrato contratostatus_add
776\.
777
778
779--
780-- Name: core_bloqueio_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
781--
782
783SELECT pg_catalog.setval('core_bloqueio_id_seq', 11, true);
784
785
786--
787-- Data for Name: core_provedor; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
788--
789
790COPY core_provedor (id, sigla, nome) FROM stdin;
791\.
792
793
794--
795-- Name: core_provedor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
796--
797
798SELECT pg_catalog.setval('core_provedor_id_seq', 5, true);
799
800
801--
802-- Data for Name: core_provedorbloqueio; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
803--
804
805COPY core_provedorbloqueio (id, provedor_id, bloqueio_id) FROM stdin;
806\.
807
808
809--
810-- Name: core_provedorbloqueio_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
811--
812
813SELECT pg_catalog.setval('core_provedorbloqueio_id_seq', 12, true);
814
815
816--
817-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
818--
819
820COPY django_admin_log (id, action_time, user_id, content_type_id, object_id, object_repr, action_flag, change_message) FROM stdin;
821\.
822
823
824--
825-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
826--
827
828SELECT pg_catalog.setval('django_admin_log_id_seq', 45, true);
829
830
831--
832-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
833--
834
835COPY django_content_type (id, name, app_label, model) FROM stdin;
8361 permission auth permission
8372 group auth group
8383 user auth user
8394 content type contenttypes contenttype
8405 session sessions session
8416 log entry admin logentry
8427 SGP - Provedor core provedor
8438 SGP - Bloqueio Provedor core provedorbloqueio
8449 SGP - Bloqueio core bloqueio
845\.
846
847
848--
849-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user_sgpadmin
850--
851
852SELECT pg_catalog.setval('django_content_type_id_seq', 9, true);
853
854
855--
856-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: user_sgpadmin
857--
858
859COPY django_session (session_key, session_data, expire_date) FROM stdin;
860\.
861
862
863--
864-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
865--
866
867ALTER TABLE ONLY auth_group
868 ADD CONSTRAINT auth_group_name_key UNIQUE (name);
869
870
871--
872-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
873--
874
875ALTER TABLE ONLY auth_group_permissions
876 ADD CONSTRAINT auth_group_permissions_group_id_permission_id_key UNIQUE (group_id, permission_id);
877
878
879--
880-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
881--
882
883ALTER TABLE ONLY auth_group_permissions
884 ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);
885
886
887--
888-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
889--
890
891ALTER TABLE ONLY auth_group
892 ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);
893
894
895--
896-- Name: auth_permission auth_permission_content_type_id_codename_key; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
897--
898
899ALTER TABLE ONLY auth_permission
900 ADD CONSTRAINT auth_permission_content_type_id_codename_key UNIQUE (content_type_id, codename);
901
902
903--
904-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
905--
906
907ALTER TABLE ONLY auth_permission
908 ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);
909
910
911--
912-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
913--
914
915ALTER TABLE ONLY auth_user_groups
916 ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);
917
918
919--
920-- Name: auth_user_groups auth_user_groups_user_id_group_id_key; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
921--
922
923ALTER TABLE ONLY auth_user_groups
924 ADD CONSTRAINT auth_user_groups_user_id_group_id_key UNIQUE (user_id, group_id);
925
926
927--
928-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
929--
930
931ALTER TABLE ONLY auth_user
932 ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);
933
934
935--
936-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
937--
938
939ALTER TABLE ONLY auth_user_user_permissions
940 ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);
941
942
943--
944-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
945--
946
947ALTER TABLE ONLY auth_user_user_permissions
948 ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_key UNIQUE (user_id, permission_id);
949
950
951--
952-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
953--
954
955ALTER TABLE ONLY auth_user
956 ADD CONSTRAINT auth_user_username_key UNIQUE (username);
957
958
959--
960-- Name: core_bloqueio core_bloqueio_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
961--
962
963ALTER TABLE ONLY core_bloqueio
964 ADD CONSTRAINT core_bloqueio_pkey PRIMARY KEY (id);
965
966
967--
968-- Name: core_provedor core_provedor_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
969--
970
971ALTER TABLE ONLY core_provedor
972 ADD CONSTRAINT core_provedor_pkey PRIMARY KEY (id);
973
974
975--
976-- Name: core_provedorbloqueio core_provedorbloqueio_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
977--
978
979ALTER TABLE ONLY core_provedorbloqueio
980 ADD CONSTRAINT core_provedorbloqueio_pkey PRIMARY KEY (id);
981
982
983--
984-- Name: core_provedorbloqueio core_provedorbloqueio_provedor_id_bloqueio_id_key; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
985--
986
987ALTER TABLE ONLY core_provedorbloqueio
988 ADD CONSTRAINT core_provedorbloqueio_provedor_id_bloqueio_id_key UNIQUE (provedor_id, bloqueio_id);
989
990
991--
992-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
993--
994
995ALTER TABLE ONLY django_admin_log
996 ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);
997
998
999--
1000-- Name: django_content_type django_content_type_app_label_model_key; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
1001--
1002
1003ALTER TABLE ONLY django_content_type
1004 ADD CONSTRAINT django_content_type_app_label_model_key UNIQUE (app_label, model);
1005
1006
1007--
1008-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
1009--
1010
1011ALTER TABLE ONLY django_content_type
1012 ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);
1013
1014
1015--
1016-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: user_sgpadmin
1017--
1018
1019ALTER TABLE ONLY django_session
1020 ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);
1021
1022
1023--
1024-- Name: auth_group_name_like; Type: INDEX; Schema: public; Owner: user_sgpadmin
1025--
1026
1027CREATE INDEX auth_group_name_like ON auth_group USING btree (name varchar_pattern_ops);
1028
1029
1030--
1031-- Name: auth_group_permissions_group_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1032--
1033
1034CREATE INDEX auth_group_permissions_group_id ON auth_group_permissions USING btree (group_id);
1035
1036
1037--
1038-- Name: auth_group_permissions_permission_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1039--
1040
1041CREATE INDEX auth_group_permissions_permission_id ON auth_group_permissions USING btree (permission_id);
1042
1043
1044--
1045-- Name: auth_permission_content_type_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1046--
1047
1048CREATE INDEX auth_permission_content_type_id ON auth_permission USING btree (content_type_id);
1049
1050
1051--
1052-- Name: auth_user_groups_group_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1053--
1054
1055CREATE INDEX auth_user_groups_group_id ON auth_user_groups USING btree (group_id);
1056
1057
1058--
1059-- Name: auth_user_groups_user_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1060--
1061
1062CREATE INDEX auth_user_groups_user_id ON auth_user_groups USING btree (user_id);
1063
1064
1065--
1066-- Name: auth_user_user_permissions_permission_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1067--
1068
1069CREATE INDEX auth_user_user_permissions_permission_id ON auth_user_user_permissions USING btree (permission_id);
1070
1071
1072--
1073-- Name: auth_user_user_permissions_user_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1074--
1075
1076CREATE INDEX auth_user_user_permissions_user_id ON auth_user_user_permissions USING btree (user_id);
1077
1078
1079--
1080-- Name: auth_user_username_like; Type: INDEX; Schema: public; Owner: user_sgpadmin
1081--
1082
1083CREATE INDEX auth_user_username_like ON auth_user USING btree (username varchar_pattern_ops);
1084
1085
1086--
1087-- Name: core_provedorbloqueio_bloqueio_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1088--
1089
1090CREATE INDEX core_provedorbloqueio_bloqueio_id ON core_provedorbloqueio USING btree (bloqueio_id);
1091
1092
1093--
1094-- Name: core_provedorbloqueio_provedor_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1095--
1096
1097CREATE INDEX core_provedorbloqueio_provedor_id ON core_provedorbloqueio USING btree (provedor_id);
1098
1099
1100--
1101-- Name: django_admin_log_content_type_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1102--
1103
1104CREATE INDEX django_admin_log_content_type_id ON django_admin_log USING btree (content_type_id);
1105
1106
1107--
1108-- Name: django_admin_log_user_id; Type: INDEX; Schema: public; Owner: user_sgpadmin
1109--
1110
1111CREATE INDEX django_admin_log_user_id ON django_admin_log USING btree (user_id);
1112
1113
1114--
1115-- Name: django_session_expire_date; Type: INDEX; Schema: public; Owner: user_sgpadmin
1116--
1117
1118CREATE INDEX django_session_expire_date ON django_session USING btree (expire_date);
1119
1120
1121--
1122-- Name: django_session_session_key_like; Type: INDEX; Schema: public; Owner: user_sgpadmin
1123--
1124
1125CREATE INDEX django_session_session_key_like ON django_session USING btree (session_key varchar_pattern_ops);
1126
1127
1128--
1129-- Name: auth_group_permissions auth_group_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: user_sgpadmin
1130--
1131
1132ALTER TABLE ONLY auth_group_permissions
1133 ADD CONSTRAINT auth_group_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
1134
1135
1136--
1137-- Name: auth_user_groups auth_user_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: user_sgpadmin
1138--
1139
1140ALTER TABLE ONLY auth_user_groups
1141 ADD CONSTRAINT auth_user_groups_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;
1142
1143
1144--
1145-- Name: auth_user_user_permissions auth_user_user_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: user_sgpadmin
1146--
1147
1148ALTER TABLE ONLY auth_user_user_permissions
1149 ADD CONSTRAINT auth_user_user_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
1150
1151
1152--
1153-- Name: core_provedorbloqueio bloqueio_id_refs_id_dc2e875f; Type: FK CONSTRAINT; Schema: public; Owner: user_sgpadmin
1154--
1155
1156ALTER TABLE ONLY core_provedorbloqueio
1157 ADD CONSTRAINT bloqueio_id_refs_id_dc2e875f FOREIGN KEY (bloqueio_id) REFERENCES core_bloqueio(id) DEFERRABLE INITIALLY DEFERRED;
1158
1159
1160--
1161-- Name: auth_permission content_type_id_refs_id_d043b34a; Type: FK CONSTRAINT; Schema: public; Owner: user_sgpadmin
1162--
1163
1164ALTER TABLE ONLY auth_permission
1165 ADD CONSTRAINT content_type_id_refs_id_d043b34a FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
1166
1167
1168--
1169-- Name: core_provedorbloqueio core_provedorbloqueio_provedor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: user_sgpadmin
1170--
1171
1172ALTER TABLE ONLY core_provedorbloqueio
1173 ADD CONSTRAINT core_provedorbloqueio_provedor_id_fkey FOREIGN KEY (provedor_id) REFERENCES core_provedor(id) DEFERRABLE INITIALLY DEFERRED;
1174
1175
1176--
1177-- Name: django_admin_log django_admin_log_content_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: user_sgpadmin
1178--
1179
1180ALTER TABLE ONLY django_admin_log
1181 ADD CONSTRAINT django_admin_log_content_type_id_fkey FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
1182
1183
1184--
1185-- Name: django_admin_log django_admin_log_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: user_sgpadmin
1186--
1187
1188ALTER TABLE ONLY django_admin_log
1189 ADD CONSTRAINT django_admin_log_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;
1190
1191
1192--
1193-- Name: auth_group_permissions group_id_refs_id_f4b32aac; Type: FK CONSTRAINT; Schema: public; Owner: user_sgpadmin
1194--
1195
1196ALTER TABLE ONLY auth_group_permissions
1197 ADD CONSTRAINT group_id_refs_id_f4b32aac FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;
1198
1199
1200--
1201-- Name: auth_user_groups user_id_refs_id_40c41112; Type: FK CONSTRAINT; Schema: public; Owner: user_sgpadmin
1202--
1203
1204ALTER TABLE ONLY auth_user_groups
1205 ADD CONSTRAINT user_id_refs_id_40c41112 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;
1206
1207
1208--
1209-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
1210--
1211
1212GRANT ALL ON SCHEMA public TO PUBLIC;
1213
1214
1215--
1216-- PostgreSQL database dump complete
1217--