1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 13.2 (Debian 13.2-1.pgdg100+1)
6-- Dumped by pg_dump version 13.1
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;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET xmloption = content;
16SET client_min_messages = warning;
17SET row_security = off;
18
19SET default_tablespace = '';
20
21SET default_table_access_method = heap;
22
23--
24-- Name: auth_group; Type: TABLE; Schema: public; Owner: chartepssg_admin
25--
26
27CREATE TABLE public.auth_group (
28 id integer NOT NULL,
29 name character varying(150) NOT NULL
30);
31
32
33ALTER TABLE public.auth_group OWNER TO chartepssg_admin;
34
35--
36-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
37--
38
39CREATE SEQUENCE public.auth_group_id_seq
40 AS integer
41 START WITH 1
42 INCREMENT BY 1
43 NO MINVALUE
44 NO MAXVALUE
45 CACHE 1;
46
47
48ALTER TABLE public.auth_group_id_seq OWNER TO chartepssg_admin;
49
50--
51-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
52--
53
54ALTER SEQUENCE public.auth_group_id_seq OWNED BY public.auth_group.id;
55
56
57--
58-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: chartepssg_admin
59--
60
61CREATE TABLE public.auth_group_permissions (
62 id integer NOT NULL,
63 group_id integer NOT NULL,
64 permission_id integer NOT NULL
65);
66
67
68ALTER TABLE public.auth_group_permissions OWNER TO chartepssg_admin;
69
70--
71-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
72--
73
74CREATE SEQUENCE public.auth_group_permissions_id_seq
75 AS integer
76 START WITH 1
77 INCREMENT BY 1
78 NO MINVALUE
79 NO MAXVALUE
80 CACHE 1;
81
82
83ALTER TABLE public.auth_group_permissions_id_seq OWNER TO chartepssg_admin;
84
85--
86-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
87--
88
89ALTER SEQUENCE public.auth_group_permissions_id_seq OWNED BY public.auth_group_permissions.id;
90
91
92--
93-- Name: auth_permission; Type: TABLE; Schema: public; Owner: chartepssg_admin
94--
95
96CREATE TABLE public.auth_permission (
97 id integer NOT NULL,
98 name character varying(255) NOT NULL,
99 content_type_id integer NOT NULL,
100 codename character varying(100) NOT NULL
101);
102
103
104ALTER TABLE public.auth_permission OWNER TO chartepssg_admin;
105
106--
107-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
108--
109
110CREATE SEQUENCE public.auth_permission_id_seq
111 AS integer
112 START WITH 1
113 INCREMENT BY 1
114 NO MINVALUE
115 NO MAXVALUE
116 CACHE 1;
117
118
119ALTER TABLE public.auth_permission_id_seq OWNER TO chartepssg_admin;
120
121--
122-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
123--
124
125ALTER SEQUENCE public.auth_permission_id_seq OWNED BY public.auth_permission.id;
126
127
128--
129-- Name: auth_user; Type: TABLE; Schema: public; Owner: chartepssg_admin
130--
131
132CREATE TABLE public.auth_user (
133 id integer NOT NULL,
134<<<hidden due to potential security issue>>>
135 last_login timestamp with time zone,
136 is_superuser boolean NOT NULL,
137 username character varying(150) NOT NULL,
138 first_name character varying(150) NOT NULL,
139 last_name character varying(150) NOT NULL,
140 email character varying(254) NOT NULL,
141 is_staff boolean NOT NULL,
142 is_active boolean NOT NULL,
143 date_joined timestamp with time zone NOT NULL
144);
145
146
147ALTER TABLE public.auth_user OWNER TO chartepssg_admin;
148
149--
150-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: chartepssg_admin
151--
152
153CREATE TABLE public.auth_user_groups (
154 id integer NOT NULL,
155 user_id integer NOT NULL,
156 group_id integer NOT NULL
157);
158
159
160ALTER TABLE public.auth_user_groups OWNER TO chartepssg_admin;
161
162--
163-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
164--
165
166CREATE SEQUENCE public.auth_user_groups_id_seq
167 AS integer
168 START WITH 1
169 INCREMENT BY 1
170 NO MINVALUE
171 NO MAXVALUE
172 CACHE 1;
173
174
175ALTER TABLE public.auth_user_groups_id_seq OWNER TO chartepssg_admin;
176
177--
178-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
179--
180
181ALTER SEQUENCE public.auth_user_groups_id_seq OWNED BY public.auth_user_groups.id;
182
183
184--
185-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
186--
187
188CREATE SEQUENCE public.auth_user_id_seq
189 AS integer
190 START WITH 1
191 INCREMENT BY 1
192 NO MINVALUE
193 NO MAXVALUE
194 CACHE 1;
195
196
197ALTER TABLE public.auth_user_id_seq OWNER TO chartepssg_admin;
198
199--
200-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
201--
202
203ALTER SEQUENCE public.auth_user_id_seq OWNED BY public.auth_user.id;
204
205
206--
207-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: chartepssg_admin
208--
209
210CREATE TABLE public.auth_user_user_permissions (
211 id integer NOT NULL,
212 user_id integer NOT NULL,
213 permission_id integer NOT NULL
214);
215
216
217ALTER TABLE public.auth_user_user_permissions OWNER TO chartepssg_admin;
218
219--
220-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
221--
222
223CREATE SEQUENCE public.auth_user_user_permissions_id_seq
224 AS integer
225 START WITH 1
226 INCREMENT BY 1
227 NO MINVALUE
228 NO MAXVALUE
229 CACHE 1;
230
231
232ALTER TABLE public.auth_user_user_permissions_id_seq OWNER TO chartepssg_admin;
233
234--
235-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
236--
237
238ALTER SEQUENCE public.auth_user_user_permissions_id_seq OWNED BY public.auth_user_user_permissions.id;
239
240
241--
242-- Name: django_content_type; Type: TABLE; Schema: public; Owner: chartepssg_admin
243--
244
245CREATE TABLE public.django_content_type (
246 id integer NOT NULL,
247 app_label character varying(100) NOT NULL,
248 model character varying(100) NOT NULL
249);
250
251
252ALTER TABLE public.django_content_type OWNER TO chartepssg_admin;
253
254--
255-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
256--
257
258CREATE SEQUENCE public.django_content_type_id_seq
259 AS integer
260 START WITH 1
261 INCREMENT BY 1
262 NO MINVALUE
263 NO MAXVALUE
264 CACHE 1;
265
266
267ALTER TABLE public.django_content_type_id_seq OWNER TO chartepssg_admin;
268
269--
270-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
271--
272
273ALTER SEQUENCE public.django_content_type_id_seq OWNED BY public.django_content_type.id;
274
275
276--
277-- Name: django_migrations; Type: TABLE; Schema: public; Owner: chartepssg_admin
278--
279
280CREATE TABLE public.django_migrations (
281 id integer NOT NULL,
282 app character varying(255) NOT NULL,
283 name character varying(255) NOT NULL,
284 applied timestamp with time zone NOT NULL
285);
286
287
288ALTER TABLE public.django_migrations OWNER TO chartepssg_admin;
289
290--
291-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
292--
293
294CREATE SEQUENCE public.django_migrations_id_seq
295 AS integer
296 START WITH 1
297 INCREMENT BY 1
298 NO MINVALUE
299 NO MAXVALUE
300 CACHE 1;
301
302
303ALTER TABLE public.django_migrations_id_seq OWNER TO chartepssg_admin;
304
305--
306-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
307--
308
309ALTER SEQUENCE public.django_migrations_id_seq OWNED BY public.django_migrations.id;
310
311
312--
313-- Name: django_session; Type: TABLE; Schema: public; Owner: chartepssg_admin
314--
315
316CREATE TABLE public.django_session (
317 session_key character varying(40) NOT NULL,
318 session_data text NOT NULL,
319 expire_date timestamp with time zone NOT NULL
320);
321
322
323ALTER TABLE public.django_session OWNER TO chartepssg_admin;
324
325--
326-- Name: django_site; Type: TABLE; Schema: public; Owner: chartepssg_admin
327--
328
329CREATE TABLE public.django_site (
330 id integer NOT NULL,
331 domain character varying(100) NOT NULL,
332 name character varying(50) NOT NULL
333);
334
335
336ALTER TABLE public.django_site OWNER TO chartepssg_admin;
337
338--
339-- Name: django_site_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
340--
341
342CREATE SEQUENCE public.django_site_id_seq
343 AS integer
344 START WITH 1
345 INCREMENT BY 1
346 NO MINVALUE
347 NO MAXVALUE
348 CACHE 1;
349
350
351ALTER TABLE public.django_site_id_seq OWNER TO chartepssg_admin;
352
353--
354-- Name: django_site_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
355--
356
357ALTER SEQUENCE public.django_site_id_seq OWNED BY public.django_site.id;
358
359
360--
361-- Name: ev_store; Type: TABLE; Schema: public; Owner: chartepssg_admin
362--
363
364CREATE TABLE public.ev_store (
365 sensing_time timestamp without time zone NOT NULL,
366 sid_num smallint NOT NULL,
367 file_pos integer,
368 product integer,
369 spid integer NOT NULL,
370 sequence_count integer NOT NULL,
371 block_index smallint NOT NULL,
372 packet_type character varying(100) NOT NULL,
373 ool_rec_time timestamp without time zone,
374 param_name character varying(100),
375 payload jsonb,
376 hex jsonb
377);
378
379
380ALTER TABLE public.ev_store OWNER TO chartepssg_admin;
381
382--
383-- Name: event_subscriptions; Type: TABLE; Schema: public; Owner: chartepssg_admin
384--
385
386CREATE TABLE public.event_subscriptions (
387 django_user_id bigint NOT NULL,
388 event_classname character varying(500),
389 sid_num smallint,
390 property_name character varying(100),
391 property_test character varying(100),
392 property_value character varying(100),
393 CONSTRAINT event_subscriptions_django_user_id_check CHECK ((django_user_id >= 0))
394);
395
396
397ALTER TABLE public.event_subscriptions OWNER TO chartepssg_admin;
398
399--
400-- Name: events; Type: TABLE; Schema: public; Owner: chartepssg_admin
401--
402
403CREATE TABLE public.events (
404 id integer NOT NULL,
405 event_class character varying(100) NOT NULL,
406 sid_num smallint,
407 gen_time timestamp without time zone NOT NULL,
408 start_time timestamp without time zone NOT NULL,
409 stop_time timestamp without time zone,
410 properties xml
411);
412
413
414ALTER TABLE public.events OWNER TO chartepssg_admin;
415
416--
417-- Name: events_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
418--
419
420CREATE SEQUENCE public.events_id_seq
421 AS integer
422 START WITH 1
423 INCREMENT BY 1
424 NO MINVALUE
425 NO MAXVALUE
426 CACHE 1;
427
428
429ALTER TABLE public.events_id_seq OWNER TO chartepssg_admin;
430
431--
432-- Name: events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
433--
434
435ALTER SEQUENCE public.events_id_seq OWNED BY public.events.id;
436
437
438--
439-- Name: fdf_events; Type: TABLE; Schema: public; Owner: chartepssg_admin
440--
441
442CREATE TABLE public.fdf_events (
443 start_time timestamp without time zone NOT NULL,
444 stop_time timestamp without time zone NOT NULL,
445 scid character varying(4) NOT NULL,
446 orbit bigint NOT NULL,
447 name character varying(25) NOT NULL,
448 target character varying(12),
449 fdf_uid bigint NOT NULL,
450 extra character varying(100),
451 gen_time timestamp without time zone NOT NULL,
452 CONSTRAINT fdf_events_fdf_uid_check CHECK ((fdf_uid >= 0)),
453 CONSTRAINT fdf_events_orbit_check CHECK ((orbit >= 0))
454);
455
456
457ALTER TABLE public.fdf_events OWNER TO chartepssg_admin;
458
459--
460-- Name: geo_events; Type: TABLE; Schema: public; Owner: chartepssg_admin
461--
462
463CREATE TABLE public.geo_events (
464 sensing_time timestamp without time zone NOT NULL,
465 sid_num smallint NOT NULL,
466 product bigint NOT NULL,
467 event_type character varying(32) NOT NULL,
468 absolute_orbit_number integer NOT NULL,
469 cycle_number integer NOT NULL,
470 relative_orbit_number integer NOT NULL,
471 from_anx integer NOT NULL,
472 pso integer NOT NULL,
473 duration integer NOT NULL,
474 pso_duration integer NOT NULL,
475 unique_id character varying(32) NOT NULL,
476 entity character varying(32),
477 aos_elevation double precision,
478 los_elevation double precision,
479 point_id integer,
480 sc_ang double precision,
481 sz_ang double precision,
482 zone_id character varying(64),
483 zone_surface character varying(64)
484);
485
486
487ALTER TABLE public.geo_events OWNER TO chartepssg_admin;
488
489--
490-- Name: jobs; Type: TABLE; Schema: public; Owner: chartepssg_admin
491--
492
493CREATE TABLE public.jobs (
494 id integer NOT NULL,
495 gen_time timestamp without time zone DEFAULT CURRENT_DATE NOT NULL,
496 category character varying(100) NOT NULL,
497 status character varying(20),
498 activity character varying(100) NOT NULL,
499 filename character varying(200),
500 dirname character varying(1000),
501 sid_num smallint,
502 sensing_start timestamp without time zone,
503 sensing_stop timestamp without time zone,
504 tablename character varying(100),
505 earliest_execution_time timestamp without time zone,
506 process_id bigint,
507 CONSTRAINT jobs_process_id_check CHECK ((process_id >= 0))
508);
509
510
511ALTER TABLE public.jobs OWNER TO chartepssg_admin;
512
513--
514-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
515--
516
517CREATE SEQUENCE public.jobs_id_seq
518 AS integer
519 START WITH 1
520 INCREMENT BY 1
521 NO MINVALUE
522 NO MAXVALUE
523 CACHE 1;
524
525
526ALTER TABLE public.jobs_id_seq OWNER TO chartepssg_admin;
527
528--
529-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
530--
531
532ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;
533
534
535--
536-- Name: orb_histo; Type: TABLE; Schema: public; Owner: chartepssg_admin
537--
538
539CREATE TABLE public.orb_histo (
540 scid character varying(4) NOT NULL,
541 utc_time timestamp without time zone NOT NULL,
542 longitude double precision NOT NULL,
543 geod_latitude double precision NOT NULL,
544 geod_height double precision NOT NULL,
545 geoc_latitude double precision NOT NULL,
546 geoc_radius double precision NOT NULL,
547 x double precision NOT NULL,
548 y double precision NOT NULL,
549 z double precision NOT NULL,
550 x_velocity double precision NOT NULL,
551 y_velocity double precision NOT NULL,
552 z_velocity double precision NOT NULL
553);
554
555
556ALTER TABLE public.orb_histo OWNER TO chartepssg_admin;
557
558--
559-- Name: processes; Type: TABLE; Schema: public; Owner: chartepssg_admin
560--
561
562CREATE TABLE public.processes (
563 id integer NOT NULL,
564 gen_time timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
565 worker character varying(100) NOT NULL,
566 pid bigint,
567 execute_start timestamp without time zone NOT NULL,
568 execute_stop timestamp without time zone,
569 status character varying(100) NOT NULL,
570 working_dir character varying(1000),
571 log_error_count integer,
572 log_warning_count integer,
573 log_info_count integer,
574 CONSTRAINT processes_pid_check CHECK ((pid >= 0))
575);
576
577
578ALTER TABLE public.processes OWNER TO chartepssg_admin;
579
580--
581-- Name: processes_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
582--
583
584CREATE SEQUENCE public.processes_id_seq
585 AS integer
586 START WITH 1
587 INCREMENT BY 1
588 NO MINVALUE
589 NO MAXVALUE
590 CACHE 1;
591
592
593ALTER TABLE public.processes_id_seq OWNER TO chartepssg_admin;
594
595--
596-- Name: processes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
597--
598
599ALTER SEQUENCE public.processes_id_seq OWNED BY public.processes.id;
600
601
602--
603-- Name: products; Type: TABLE; Schema: public; Owner: chartepssg_admin
604--
605
606CREATE TABLE public.products (
607 id integer NOT NULL,
608 activity character varying(50) NOT NULL,
609 filename character varying(200) NOT NULL,
610 ingestion_time timestamp without time zone,
611 result character varying(100) NOT NULL,
612 sensing_start timestamp without time zone,
613 mtime timestamp without time zone,
614 filesize integer,
615 notes character varying(500),
616 sid_num smallint
617);
618
619
620ALTER TABLE public.products OWNER TO chartepssg_admin;
621
622--
623-- Name: products_id_seq; Type: SEQUENCE; Schema: public; Owner: chartepssg_admin
624--
625
626CREATE SEQUENCE public.products_id_seq
627 AS integer
628 START WITH 1
629 INCREMENT BY 1
630 NO MINVALUE
631 NO MAXVALUE
632 CACHE 1;
633
634
635ALTER TABLE public.products_id_seq OWNER TO chartepssg_admin;
636
637--
638-- Name: products_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chartepssg_admin
639--
640
641ALTER SEQUENCE public.products_id_seq OWNED BY public.products.id;
642
643
644--
645-- Name: reports; Type: TABLE; Schema: public; Owner: chartepssg_admin
646--
647
648CREATE TABLE public.reports (
649 activity character varying(50) NOT NULL,
650 sid_num smallint,
651 sensing_start timestamp without time zone NOT NULL,
652 sensing_stop timestamp without time zone NOT NULL,
653 archive_filename character varying(500) NOT NULL,
654 gen_time timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
655 last_revision_time timestamp without time zone,
656 revision_count integer,
657 last_publish_time timestamp without time zone,
658 username character varying(50)
659);
660
661
662ALTER TABLE public.reports OWNER TO chartepssg_admin;
663
664--
665-- Name: subscriptions; Type: TABLE; Schema: public; Owner: chartepssg_admin
666--
667
668CREATE TABLE public.subscriptions (
669 django_user_id bigint NOT NULL,
670 category character varying(20) NOT NULL,
671 name character varying(500) NOT NULL,
672 properties xml,
673 CONSTRAINT subscriptions_django_user_id_check CHECK ((django_user_id >= 0))
674);
675
676
677ALTER TABLE public.subscriptions OWNER TO chartepssg_admin;
678
679--
680-- Name: tc_ack_store; Type: TABLE; Schema: public; Owner: chartepssg_admin
681--
682
683CREATE TABLE public.tc_ack_store (
684 sensing_time timestamp without time zone NOT NULL,
685 sid_num smallint NOT NULL,
686 file_pos integer,
687 product integer,
688 payload jsonb,
689 hex jsonb,
690 uplink_time timestamp without time zone NOT NULL,
691 execut_time timestamp without time zone NOT NULL,
692 last_update_time timestamp without time zone NOT NULL,
693 request_id bigint NOT NULL,
694 request_element_index integer NOT NULL,
695 variable_address_size integer NOT NULL,
696 pus_id integer NOT NULL,
697 pus_ssc smallint NOT NULL,
698 pus_service_type smallint NOT NULL,
699 pus_service_subtype smallint NOT NULL,
700 pus_ack_flags smallint NOT NULL,
701 uplink_flag smallint NOT NULL,
702 command_source_host smallint NOT NULL,
703 command_source_type smallint NOT NULL,
704 request_details_fixed_size integer NOT NULL,
705 version_major smallint NOT NULL,
706 version_minor smallint NOT NULL,
707 num_verification_results integer NOT NULL,
708 CONSTRAINT tc_ack_store_command_source_host_check CHECK ((command_source_host >= 0)),
709 CONSTRAINT tc_ack_store_command_source_type_check CHECK ((command_source_type >= 0)),
710 CONSTRAINT tc_ack_store_num_verification_results_check CHECK ((num_verification_results >= 0)),
711 CONSTRAINT tc_ack_store_pus_ack_flags_check CHECK ((pus_ack_flags >= 0)),
712 CONSTRAINT tc_ack_store_pus_id_check CHECK ((pus_id >= 0)),
713 CONSTRAINT tc_ack_store_pus_service_subtype_check CHECK ((pus_service_subtype >= 0)),
714 CONSTRAINT tc_ack_store_pus_service_type_check CHECK ((pus_service_type >= 0)),
715 CONSTRAINT tc_ack_store_pus_ssc_check CHECK ((pus_ssc >= 0)),
716 CONSTRAINT tc_ack_store_request_details_fixed_size_check CHECK ((request_details_fixed_size >= 0)),
717 CONSTRAINT tc_ack_store_request_element_index_check CHECK ((request_element_index >= 0)),
718 CONSTRAINT tc_ack_store_request_id_check CHECK ((request_id >= 0)),
719 CONSTRAINT tc_ack_store_uplink_flag_check CHECK ((uplink_flag >= 0)),
720 CONSTRAINT tc_ack_store_variable_address_size_check CHECK ((variable_address_size >= 0)),
721 CONSTRAINT tc_ack_store_version_major_check CHECK ((version_major >= 0)),
722 CONSTRAINT tc_ack_store_version_minor_check CHECK ((version_minor >= 0))
723);
724
725
726ALTER TABLE public.tc_ack_store OWNER TO chartepssg_admin;
727
728--
729-- Name: tc_store; Type: TABLE; Schema: public; Owner: chartepssg_admin
730--
731
732CREATE TABLE public.tc_store (
733 sensing_time timestamp without time zone NOT NULL,
734 sid_num smallint NOT NULL,
735 name character varying(100) NOT NULL,
736 file_pos integer,
737 product integer,
738 payload jsonb,
739 hex jsonb,
740 description character varying(1000),
741 uplink_time timestamp without time zone NOT NULL,
742 execut_time timestamp without time zone NOT NULL,
743 last_update_time timestamp without time zone NOT NULL,
744 request_id bigint NOT NULL,
745 request_element_index integer NOT NULL,
746 variable_address_size integer NOT NULL,
747 pus_id integer NOT NULL,
748 pus_ssc smallint NOT NULL,
749 pus_service_type smallint NOT NULL,
750 pus_service_subtype smallint NOT NULL,
751 pus_ack_flags smallint NOT NULL,
752 uplink_flag smallint NOT NULL,
753 command_source_host smallint NOT NULL,
754 command_source_type smallint NOT NULL,
755 request_details_fixed_size integer NOT NULL,
756 parent_seq_id character varying(9) NOT NULL,
757 destination_id character varying(31) NOT NULL,
758 command_type character varying(9) NOT NULL,
759 subsystem smallint NOT NULL,
760 group_block_info smallint NOT NULL,
761 source_id integer NOT NULL,
762 interlock_type smallint NOT NULL,
763 interlock_stage_id integer NOT NULL,
764 interlock_stage_type smallint NOT NULL,
765 notification_info smallint NOT NULL,
766 check_states smallint NOT NULL,
767 ptv_status integer NOT NULL,
768 overall_ver_status integer NOT NULL,
769 num_params integer NOT NULL,
770 request_data_size integer NOT NULL,
771 load_tt_apid integer NOT NULL,
772 load_tt_seq integer NOT NULL,
773 obq_info smallint NOT NULL,
774 enc_exec_time bytea NOT NULL,
775 hdr_format smallint NOT NULL,
776 service_mode smallint NOT NULL,
777 uplink_mode smallint NOT NULL,
778 map_id smallint NOT NULL,
779 frame_type smallint NOT NULL,
780 frame_count smallint NOT NULL,
781 num_exec_ver_stages smallint NOT NULL,
782 ack_flags smallint NOT NULL,
783 ver_states bytea NOT NULL,
784 tt_obq_status integer NOT NULL,
785 optional_param_info bigint NOT NULL,
786 parameter_details_size integer NOT NULL,
787 encoded_data_size integer NOT NULL,
788 tc_request_id bigint NOT NULL,
789 obqd_id integer NOT NULL,
790 subschedule_id bigint NOT NULL,
791 tt_load_status smallint NOT NULL,
792 tt_del_status smallint NOT NULL,
793 predicted_time bigint NOT NULL,
794 delete_apid integer NOT NULL,
795 delete_ssc integer NOT NULL,
796 delete_release_time bigint NOT NULL,
797 variable_data bytea NOT NULL,
798 CONSTRAINT tc_store_ack_flags_check CHECK ((ack_flags >= 0)),
799 CONSTRAINT tc_store_check_states_check CHECK ((check_states >= 0)),
800 CONSTRAINT tc_store_command_source_host_check CHECK ((command_source_host >= 0)),
801 CONSTRAINT tc_store_command_source_type_check CHECK ((command_source_type >= 0)),
802 CONSTRAINT tc_store_delete_apid_check CHECK ((delete_apid >= 0)),
803 CONSTRAINT tc_store_delete_release_time_check CHECK ((delete_release_time >= 0)),
804 CONSTRAINT tc_store_delete_ssc_check CHECK ((delete_ssc >= 0)),
805 CONSTRAINT tc_store_encoded_data_size_check CHECK ((encoded_data_size >= 0)),
806 CONSTRAINT tc_store_frame_count_check CHECK ((frame_count >= 0)),
807 CONSTRAINT tc_store_frame_type_check CHECK ((frame_type >= 0)),
808 CONSTRAINT tc_store_group_block_info_check CHECK ((group_block_info >= 0)),
809 CONSTRAINT tc_store_hdr_format_check CHECK ((hdr_format >= 0)),
810 CONSTRAINT tc_store_interlock_stage_id_check CHECK ((interlock_stage_id >= 0)),
811 CONSTRAINT tc_store_interlock_stage_type_check CHECK ((interlock_stage_type >= 0)),
812 CONSTRAINT tc_store_interlock_type_check CHECK ((interlock_type >= 0)),
813 CONSTRAINT tc_store_load_tt_apid_check CHECK ((load_tt_apid >= 0)),
814 CONSTRAINT tc_store_load_tt_seq_check CHECK ((load_tt_seq >= 0)),
815 CONSTRAINT tc_store_map_id_check CHECK ((map_id >= 0)),
816 CONSTRAINT tc_store_notification_info_check CHECK ((notification_info >= 0)),
817 CONSTRAINT tc_store_num_exec_ver_stages_check CHECK ((num_exec_ver_stages >= 0)),
818 CONSTRAINT tc_store_num_params_check CHECK ((num_params >= 0)),
819 CONSTRAINT tc_store_obq_info_check CHECK ((obq_info >= 0)),
820 CONSTRAINT tc_store_obqd_id_check CHECK ((obqd_id >= 0)),
821 CONSTRAINT tc_store_optional_param_info_check CHECK ((optional_param_info >= 0)),
822 CONSTRAINT tc_store_overall_ver_status_check CHECK ((overall_ver_status >= 0)),
823 CONSTRAINT tc_store_parameter_details_size_check CHECK ((parameter_details_size >= 0)),
824 CONSTRAINT tc_store_predicted_time_check CHECK ((predicted_time >= 0)),
825 CONSTRAINT tc_store_ptv_status_check CHECK ((ptv_status >= 0)),
826 CONSTRAINT tc_store_pus_ack_flags_check CHECK ((pus_ack_flags >= 0)),
827 CONSTRAINT tc_store_pus_id_check CHECK ((pus_id >= 0)),
828 CONSTRAINT tc_store_pus_service_subtype_check CHECK ((pus_service_subtype >= 0)),
829 CONSTRAINT tc_store_pus_service_type_check CHECK ((pus_service_type >= 0)),
830 CONSTRAINT tc_store_pus_ssc_check CHECK ((pus_ssc >= 0)),
831 CONSTRAINT tc_store_request_data_size_check CHECK ((request_data_size >= 0)),
832 CONSTRAINT tc_store_request_details_fixed_size_check CHECK ((request_details_fixed_size >= 0)),
833 CONSTRAINT tc_store_request_element_index_check CHECK ((request_element_index >= 0)),
834 CONSTRAINT tc_store_request_id_check CHECK ((request_id >= 0)),
835 CONSTRAINT tc_store_service_mode_check CHECK ((service_mode >= 0)),
836 CONSTRAINT tc_store_source_id_check CHECK ((source_id >= 0)),
837 CONSTRAINT tc_store_subschedule_id_check CHECK ((subschedule_id >= 0)),
838 CONSTRAINT tc_store_subsystem_check CHECK ((subsystem >= 0)),
839 CONSTRAINT tc_store_tc_request_id_check CHECK ((tc_request_id >= 0)),
840 CONSTRAINT tc_store_tt_del_status_check CHECK ((tt_del_status >= 0)),
841 CONSTRAINT tc_store_tt_load_status_check CHECK ((tt_load_status >= 0)),
842 CONSTRAINT tc_store_tt_obq_status_check CHECK ((tt_obq_status >= 0)),
843 CONSTRAINT tc_store_uplink_flag_check CHECK ((uplink_flag >= 0)),
844 CONSTRAINT tc_store_uplink_mode_check CHECK ((uplink_mode >= 0)),
845 CONSTRAINT tc_store_variable_address_size_check CHECK ((variable_address_size >= 0))
846);
847
848
849ALTER TABLE public.tc_store OWNER TO chartepssg_admin;
850
851--
852-- Name: tm; Type: TABLE; Schema: public; Owner: chartepssg_admin
853--
854
855CREATE TABLE public.tm (
856 sensing_time timestamp without time zone NOT NULL,
857 sid_num smallint NOT NULL,
858 product integer,
859 file_pos bigint,
860 spid integer NOT NULL,
861 obt bigint NOT NULL,
862 sequence_count integer NOT NULL,
863 block_index integer NOT NULL,
864 payload jsonb NOT NULL,
865 hex jsonb NOT NULL,
866 destination_id integer,
867 time_status integer,
868 packet_time timestamp without time zone NOT NULL,
869 CONSTRAINT tm_block_index_check CHECK ((block_index >= 0)),
870 CONSTRAINT tm_destination_id_check CHECK ((destination_id >= 0)),
871 CONSTRAINT tm_file_pos_check CHECK ((file_pos >= 0)),
872 CONSTRAINT tm_obt_check CHECK ((obt >= 0)),
873 CONSTRAINT tm_sequence_count_check CHECK ((sequence_count >= 0)),
874 CONSTRAINT tm_spid_check CHECK ((spid >= 0)),
875 CONSTRAINT tm_time_status_check CHECK ((time_status >= 0))
876);
877
878
879ALTER TABLE public.tm OWNER TO chartepssg_admin;
880
881--
882-- Name: tm_stats; Type: TABLE; Schema: public; Owner: chartepssg_admin
883--
884
885CREATE TABLE public.tm_stats (
886 sensing_time timestamp without time zone NOT NULL,
887 sid_num smallint NOT NULL,
888 gen_time timestamp without time zone,
889 region smallint NOT NULL,
890 rowcount integer,
891 raw_mins jsonb,
892 raw_maxs jsonb,
893 raw_avgs jsonb,
894 raw_stds jsonb,
895 raw_cnts jsonb,
896 cal_mins jsonb,
897 cal_maxs jsonb,
898 cal_avgs jsonb,
899 cal_stds jsonb,
900 CONSTRAINT tm_stats_region_check CHECK ((region >= 0)),
901 CONSTRAINT tm_stats_rowcount_check CHECK ((rowcount >= 0))
902);
903
904
905ALTER TABLE public.tm_stats OWNER TO chartepssg_admin;
906
907--
908-- Name: users; Type: TABLE; Schema: public; Owner: chartepssg_admin
909--
910
911CREATE TABLE public.users (
912 django_user_id bigint NOT NULL,
913 daily_digest smallint NOT NULL,
914 notifications smallint,
915 write_events smallint,
916 properties xml,
917 CONSTRAINT users_django_user_id_check CHECK ((django_user_id >= 0))
918);
919
920
921ALTER TABLE public.users OWNER TO chartepssg_admin;
922
923--
924-- Name: auth_group id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
925--
926
927ALTER TABLE ONLY public.auth_group ALTER COLUMN id SET DEFAULT nextval('public.auth_group_id_seq'::regclass);
928
929
930--
931-- Name: auth_group_permissions id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
932--
933
934ALTER TABLE ONLY public.auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('public.auth_group_permissions_id_seq'::regclass);
935
936
937--
938-- Name: auth_permission id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
939--
940
941ALTER TABLE ONLY public.auth_permission ALTER COLUMN id SET DEFAULT nextval('public.auth_permission_id_seq'::regclass);
942
943
944--
945-- Name: auth_user id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
946--
947
948ALTER TABLE ONLY public.auth_user ALTER COLUMN id SET DEFAULT nextval('public.auth_user_id_seq'::regclass);
949
950
951--
952-- Name: auth_user_groups id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
953--
954
955ALTER TABLE ONLY public.auth_user_groups ALTER COLUMN id SET DEFAULT nextval('public.auth_user_groups_id_seq'::regclass);
956
957
958--
959-- Name: auth_user_user_permissions id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
960--
961
962ALTER TABLE ONLY public.auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('public.auth_user_user_permissions_id_seq'::regclass);
963
964
965--
966-- Name: django_content_type id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
967--
968
969ALTER TABLE ONLY public.django_content_type ALTER COLUMN id SET DEFAULT nextval('public.django_content_type_id_seq'::regclass);
970
971
972--
973-- Name: django_migrations id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
974--
975
976ALTER TABLE ONLY public.django_migrations ALTER COLUMN id SET DEFAULT nextval('public.django_migrations_id_seq'::regclass);
977
978
979--
980-- Name: django_site id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
981--
982
983ALTER TABLE ONLY public.django_site ALTER COLUMN id SET DEFAULT nextval('public.django_site_id_seq'::regclass);
984
985
986--
987-- Name: events id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
988--
989
990ALTER TABLE ONLY public.events ALTER COLUMN id SET DEFAULT nextval('public.events_id_seq'::regclass);
991
992
993--
994-- Name: jobs id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
995--
996
997ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass);
998
999
1000--
1001-- Name: processes id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
1002--
1003
1004ALTER TABLE ONLY public.processes ALTER COLUMN id SET DEFAULT nextval('public.processes_id_seq'::regclass);
1005
1006
1007--
1008-- Name: products id; Type: DEFAULT; Schema: public; Owner: chartepssg_admin
1009--
1010
1011ALTER TABLE ONLY public.products ALTER COLUMN id SET DEFAULT nextval('public.products_id_seq'::regclass);
1012
1013
1014--
1015-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1016--
1017
1018ALTER TABLE ONLY public.auth_group
1019 ADD CONSTRAINT auth_group_name_key UNIQUE (name);
1020
1021
1022--
1023-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1024--
1025
1026ALTER TABLE ONLY public.auth_group_permissions
1027 ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);
1028
1029
1030--
1031-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1032--
1033
1034ALTER TABLE ONLY public.auth_group_permissions
1035 ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);
1036
1037
1038--
1039-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1040--
1041
1042ALTER TABLE ONLY public.auth_group
1043 ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);
1044
1045
1046--
1047-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1048--
1049
1050ALTER TABLE ONLY public.auth_permission
1051 ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);
1052
1053
1054--
1055-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1056--
1057
1058ALTER TABLE ONLY public.auth_permission
1059 ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);
1060
1061
1062--
1063-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1064--
1065
1066ALTER TABLE ONLY public.auth_user_groups
1067 ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);
1068
1069
1070--
1071-- Name: auth_user_groups auth_user_groups_user_id_group_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1072--
1073
1074ALTER TABLE ONLY public.auth_user_groups
1075 ADD CONSTRAINT auth_user_groups_user_id_group_id_94350c0c_uniq UNIQUE (user_id, group_id);
1076
1077
1078--
1079-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1080--
1081
1082ALTER TABLE ONLY public.auth_user
1083 ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);
1084
1085
1086--
1087-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1088--
1089
1090ALTER TABLE ONLY public.auth_user_user_permissions
1091 ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);
1092
1093
1094--
1095-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1096--
1097
1098ALTER TABLE ONLY public.auth_user_user_permissions
1099 ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_14a6b632_uniq UNIQUE (user_id, permission_id);
1100
1101
1102--
1103-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1104--
1105
1106ALTER TABLE ONLY public.auth_user
1107 ADD CONSTRAINT auth_user_username_key UNIQUE (username);
1108
1109
1110--
1111-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1112--
1113
1114ALTER TABLE ONLY public.django_content_type
1115 ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);
1116
1117
1118--
1119-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1120--
1121
1122ALTER TABLE ONLY public.django_content_type
1123 ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);
1124
1125
1126--
1127-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1128--
1129
1130ALTER TABLE ONLY public.django_migrations
1131 ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);
1132
1133
1134--
1135-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1136--
1137
1138ALTER TABLE ONLY public.django_session
1139 ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);
1140
1141
1142--
1143-- Name: django_site django_site_domain_a2e37b91_uniq; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1144--
1145
1146ALTER TABLE ONLY public.django_site
1147 ADD CONSTRAINT django_site_domain_a2e37b91_uniq UNIQUE (domain);
1148
1149
1150--
1151-- Name: django_site django_site_pkey; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1152--
1153
1154ALTER TABLE ONLY public.django_site
1155 ADD CONSTRAINT django_site_pkey PRIMARY KEY (id);
1156
1157
1158--
1159-- Name: ev_store ev_store_idx0; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1160--
1161
1162ALTER TABLE ONLY public.ev_store
1163 ADD CONSTRAINT ev_store_idx0 PRIMARY KEY (sid_num, sensing_time, spid, block_index);
1164
1165
1166--
1167-- Name: events events_pk; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1168--
1169
1170ALTER TABLE ONLY public.events
1171 ADD CONSTRAINT events_pk PRIMARY KEY (id);
1172
1173
1174--
1175-- Name: geo_events geo_events_c; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1176--
1177
1178ALTER TABLE ONLY public.geo_events
1179 ADD CONSTRAINT geo_events_c PRIMARY KEY (sid_num, sensing_time);
1180
1181
1182--
1183-- Name: jobs jobs_pk; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1184--
1185
1186ALTER TABLE ONLY public.jobs
1187 ADD CONSTRAINT jobs_pk PRIMARY KEY (id);
1188
1189
1190--
1191-- Name: products products_pk; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1192--
1193
1194ALTER TABLE ONLY public.products
1195 ADD CONSTRAINT products_pk PRIMARY KEY (id);
1196
1197
1198--
1199-- Name: reports reports_idx; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1200--
1201
1202ALTER TABLE ONLY public.reports
1203 ADD CONSTRAINT reports_idx PRIMARY KEY (activity, sensing_start);
1204
1205
1206--
1207-- Name: subscriptions subscriptions_pk; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1208--
1209
1210ALTER TABLE ONLY public.subscriptions
1211 ADD CONSTRAINT subscriptions_pk PRIMARY KEY (django_user_id, category, name);
1212
1213
1214--
1215-- Name: tc_ack_store tc_ack_store_idx0; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1216--
1217
1218ALTER TABLE ONLY public.tc_ack_store
1219 ADD CONSTRAINT tc_ack_store_idx0 PRIMARY KEY (sid_num, sensing_time, last_update_time);
1220
1221
1222--
1223-- Name: tc_store tc_store_idx0; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1224--
1225
1226ALTER TABLE ONLY public.tc_store
1227 ADD CONSTRAINT tc_store_idx0 PRIMARY KEY (sid_num, sensing_time, last_update_time);
1228
1229
1230--
1231-- Name: tm tm_idx0; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1232--
1233
1234ALTER TABLE ONLY public.tm
1235 ADD CONSTRAINT tm_idx0 PRIMARY KEY (sid_num, sensing_time, spid, sequence_count);
1236
1237
1238--
1239-- Name: tm_stats tm_stats_idx0; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1240--
1241
1242ALTER TABLE ONLY public.tm_stats
1243 ADD CONSTRAINT tm_stats_idx0 PRIMARY KEY (sid_num, sensing_time, region);
1244
1245
1246--
1247-- Name: users users_pk; Type: CONSTRAINT; Schema: public; Owner: chartepssg_admin
1248--
1249
1250ALTER TABLE ONLY public.users
1251 ADD CONSTRAINT users_pk PRIMARY KEY (django_user_id);
1252
1253
1254--
1255-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: chartepssg_admin
1256--
1257
1258CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);
1259
1260
1261--
1262-- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: chartepssg_admin
1263--
1264
1265CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);
1266
1267
1268--
1269-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: chartepssg_admin
1270--
1271
1272CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);
1273
1274
1275--
1276-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: chartepssg_admin
1277--
1278
1279CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);
1280
1281
1282--
1283-- Name: auth_user_groups_group_id_97559544; Type: INDEX; Schema: public; Owner: chartepssg_admin
1284--
1285
1286CREATE INDEX auth_user_groups_group_id_97559544 ON public.auth_user_groups USING btree (group_id);
1287
1288
1289--
1290-- Name: auth_user_groups_user_id_6a12ed8b; Type: INDEX; Schema: public; Owner: chartepssg_admin
1291--
1292
1293CREATE INDEX auth_user_groups_user_id_6a12ed8b ON public.auth_user_groups USING btree (user_id);
1294
1295
1296--
1297-- Name: auth_user_user_permissions_permission_id_1fbb5f2c; Type: INDEX; Schema: public; Owner: chartepssg_admin
1298--
1299
1300CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON public.auth_user_user_permissions USING btree (permission_id);
1301
1302
1303--
1304-- Name: auth_user_user_permissions_user_id_a95ead1b; Type: INDEX; Schema: public; Owner: chartepssg_admin
1305--
1306
1307CREATE INDEX auth_user_user_permissions_user_id_a95ead1b ON public.auth_user_user_permissions USING btree (user_id);
1308
1309
1310--
1311-- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: chartepssg_admin
1312--
1313
1314CREATE INDEX auth_user_username_6821ab7c_like ON public.auth_user USING btree (username varchar_pattern_ops);
1315
1316
1317--
1318-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: chartepssg_admin
1319--
1320
1321CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);
1322
1323
1324--
1325-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: chartepssg_admin
1326--
1327
1328CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);
1329
1330
1331--
1332-- Name: django_site_domain_a2e37b91_like; Type: INDEX; Schema: public; Owner: chartepssg_admin
1333--
1334
1335CREATE INDEX django_site_domain_a2e37b91_like ON public.django_site USING btree (domain varchar_pattern_ops);
1336
1337
1338--
1339-- Name: events_strt; Type: INDEX; Schema: public; Owner: chartepssg_admin
1340--
1341
1342CREATE INDEX events_strt ON public.events USING btree (event_class, start_time);
1343
1344
1345--
1346-- Name: jobs_idx; Type: INDEX; Schema: public; Owner: chartepssg_admin
1347--
1348
1349CREATE INDEX jobs_idx ON public.jobs USING btree (category, activity, status, sensing_start);
1350
1351
1352--
1353-- Name: orb_histo_t; Type: INDEX; Schema: public; Owner: chartepssg_admin
1354--
1355
1356CREATE UNIQUE INDEX orb_histo_t ON public.orb_histo USING btree (scid, utc_time);
1357
1358
1359--
1360-- Name: products_f; Type: INDEX; Schema: public; Owner: chartepssg_admin
1361--
1362
1363CREATE INDEX products_f ON public.products USING btree (filename);
1364
1365
1366--
1367-- Name: products_s; Type: INDEX; Schema: public; Owner: chartepssg_admin
1368--
1369
1370CREATE INDEX products_s ON public.products USING btree (sensing_start);
1371
1372
1373--
1374-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: chartepssg_admin
1375--
1376
1377ALTER TABLE ONLY public.auth_group_permissions
1378 ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
1379
1380
1381--
1382-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: chartepssg_admin
1383--
1384
1385ALTER TABLE ONLY public.auth_group_permissions
1386 ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;
1387
1388
1389--
1390-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: chartepssg_admin
1391--
1392
1393ALTER TABLE ONLY public.auth_permission
1394 ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
1395
1396
1397--
1398-- Name: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: chartepssg_admin
1399--
1400
1401ALTER TABLE ONLY public.auth_user_groups
1402 ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;
1403
1404
1405--
1406-- Name: auth_user_groups auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: chartepssg_admin
1407--
1408
1409ALTER TABLE ONLY public.auth_user_groups
1410 ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;
1411
1412
1413--
1414-- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: chartepssg_admin
1415--
1416
1417ALTER TABLE ONLY public.auth_user_user_permissions
1418 ADD CONSTRAINT auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
1419
1420
1421--
1422-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: chartepssg_admin
1423--
1424
1425ALTER TABLE ONLY public.auth_user_user_permissions
1426 ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;
1427
1428
1429--
1430-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
1431--
1432
1433GRANT ALL ON SCHEMA public TO chartepssg_admin;
1434GRANT USAGE ON SCHEMA public TO chartepssg_enduser;
1435GRANT USAGE ON SCHEMA public TO chartepssg_web;
1436GRANT USAGE ON SCHEMA public TO chartepssg_expert;
1437GRANT USAGE ON SCHEMA public TO chartepssg_ingester;
1438
1439
1440--
1441-- Name: TABLE auth_group; Type: ACL; Schema: public; Owner: chartepssg_admin
1442--
1443
1444GRANT SELECT ON TABLE public.auth_group TO chartepssg_enduser;
1445GRANT SELECT ON TABLE public.auth_group TO chartepssg_web;
1446GRANT SELECT ON TABLE public.auth_group TO chartepssg_expert;
1447GRANT ALL ON TABLE public.auth_group TO chartepssg_ingester;
1448
1449
1450--
1451-- Name: SEQUENCE auth_group_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1452--
1453
1454GRANT ALL ON SEQUENCE public.auth_group_id_seq TO chartepssg_ingester;
1455
1456
1457--
1458-- Name: TABLE auth_group_permissions; Type: ACL; Schema: public; Owner: chartepssg_admin
1459--
1460
1461GRANT SELECT ON TABLE public.auth_group_permissions TO chartepssg_enduser;
1462GRANT SELECT ON TABLE public.auth_group_permissions TO chartepssg_web;
1463GRANT SELECT ON TABLE public.auth_group_permissions TO chartepssg_expert;
1464GRANT ALL ON TABLE public.auth_group_permissions TO chartepssg_ingester;
1465
1466
1467--
1468-- Name: SEQUENCE auth_group_permissions_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1469--
1470
1471GRANT ALL ON SEQUENCE public.auth_group_permissions_id_seq TO chartepssg_ingester;
1472
1473
1474--
1475-- Name: TABLE auth_permission; Type: ACL; Schema: public; Owner: chartepssg_admin
1476--
1477
1478GRANT SELECT ON TABLE public.auth_permission TO chartepssg_enduser;
1479GRANT SELECT ON TABLE public.auth_permission TO chartepssg_web;
1480GRANT SELECT ON TABLE public.auth_permission TO chartepssg_expert;
1481GRANT ALL ON TABLE public.auth_permission TO chartepssg_ingester;
1482
1483
1484--
1485-- Name: SEQUENCE auth_permission_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1486--
1487
1488GRANT ALL ON SEQUENCE public.auth_permission_id_seq TO chartepssg_ingester;
1489
1490
1491--
1492-- Name: TABLE auth_user; Type: ACL; Schema: public; Owner: chartepssg_admin
1493--
1494
1495GRANT SELECT ON TABLE public.auth_user TO chartepssg_enduser;
1496GRANT SELECT ON TABLE public.auth_user TO chartepssg_web;
1497GRANT SELECT ON TABLE public.auth_user TO chartepssg_expert;
1498GRANT ALL ON TABLE public.auth_user TO chartepssg_ingester;
1499
1500
1501--
1502-- Name: TABLE auth_user_groups; Type: ACL; Schema: public; Owner: chartepssg_admin
1503--
1504
1505GRANT SELECT ON TABLE public.auth_user_groups TO chartepssg_enduser;
1506GRANT SELECT ON TABLE public.auth_user_groups TO chartepssg_web;
1507GRANT SELECT ON TABLE public.auth_user_groups TO chartepssg_expert;
1508GRANT ALL ON TABLE public.auth_user_groups TO chartepssg_ingester;
1509
1510
1511--
1512-- Name: SEQUENCE auth_user_groups_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1513--
1514
1515GRANT ALL ON SEQUENCE public.auth_user_groups_id_seq TO chartepssg_ingester;
1516
1517
1518--
1519-- Name: SEQUENCE auth_user_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1520--
1521
1522GRANT ALL ON SEQUENCE public.auth_user_id_seq TO chartepssg_ingester;
1523
1524
1525--
1526-- Name: TABLE auth_user_user_permissions; Type: ACL; Schema: public; Owner: chartepssg_admin
1527--
1528
1529GRANT SELECT ON TABLE public.auth_user_user_permissions TO chartepssg_enduser;
1530GRANT SELECT ON TABLE public.auth_user_user_permissions TO chartepssg_web;
1531GRANT SELECT ON TABLE public.auth_user_user_permissions TO chartepssg_expert;
1532GRANT ALL ON TABLE public.auth_user_user_permissions TO chartepssg_ingester;
1533
1534
1535--
1536-- Name: SEQUENCE auth_user_user_permissions_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1537--
1538
1539GRANT ALL ON SEQUENCE public.auth_user_user_permissions_id_seq TO chartepssg_ingester;
1540
1541
1542--
1543-- Name: TABLE django_content_type; Type: ACL; Schema: public; Owner: chartepssg_admin
1544--
1545
1546GRANT SELECT ON TABLE public.django_content_type TO chartepssg_enduser;
1547GRANT SELECT ON TABLE public.django_content_type TO chartepssg_web;
1548GRANT SELECT ON TABLE public.django_content_type TO chartepssg_expert;
1549GRANT ALL ON TABLE public.django_content_type TO chartepssg_ingester;
1550
1551
1552--
1553-- Name: SEQUENCE django_content_type_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1554--
1555
1556GRANT ALL ON SEQUENCE public.django_content_type_id_seq TO chartepssg_ingester;
1557
1558
1559--
1560-- Name: TABLE django_migrations; Type: ACL; Schema: public; Owner: chartepssg_admin
1561--
1562
1563GRANT SELECT ON TABLE public.django_migrations TO chartepssg_enduser;
1564GRANT SELECT ON TABLE public.django_migrations TO chartepssg_web;
1565GRANT SELECT ON TABLE public.django_migrations TO chartepssg_expert;
1566GRANT ALL ON TABLE public.django_migrations TO chartepssg_ingester;
1567
1568
1569--
1570-- Name: SEQUENCE django_migrations_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1571--
1572
1573GRANT ALL ON SEQUENCE public.django_migrations_id_seq TO chartepssg_ingester;
1574
1575
1576--
1577-- Name: TABLE django_session; Type: ACL; Schema: public; Owner: chartepssg_admin
1578--
1579
1580GRANT SELECT ON TABLE public.django_session TO chartepssg_enduser;
1581GRANT SELECT ON TABLE public.django_session TO chartepssg_web;
1582GRANT SELECT ON TABLE public.django_session TO chartepssg_expert;
1583GRANT ALL ON TABLE public.django_session TO chartepssg_ingester;
1584
1585
1586--
1587-- Name: TABLE django_site; Type: ACL; Schema: public; Owner: chartepssg_admin
1588--
1589
1590GRANT SELECT ON TABLE public.django_site TO chartepssg_enduser;
1591GRANT SELECT ON TABLE public.django_site TO chartepssg_web;
1592GRANT SELECT ON TABLE public.django_site TO chartepssg_expert;
1593GRANT ALL ON TABLE public.django_site TO chartepssg_ingester;
1594
1595
1596--
1597-- Name: SEQUENCE django_site_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1598--
1599
1600GRANT ALL ON SEQUENCE public.django_site_id_seq TO chartepssg_ingester;
1601
1602
1603--
1604-- Name: TABLE ev_store; Type: ACL; Schema: public; Owner: chartepssg_admin
1605--
1606
1607GRANT SELECT ON TABLE public.ev_store TO chartepssg_enduser;
1608GRANT SELECT ON TABLE public.ev_store TO chartepssg_web;
1609GRANT SELECT ON TABLE public.ev_store TO chartepssg_expert;
1610GRANT ALL ON TABLE public.ev_store TO chartepssg_ingester;
1611
1612
1613--
1614-- Name: TABLE event_subscriptions; Type: ACL; Schema: public; Owner: chartepssg_admin
1615--
1616
1617GRANT SELECT ON TABLE public.event_subscriptions TO chartepssg_enduser;
1618GRANT SELECT ON TABLE public.event_subscriptions TO chartepssg_web;
1619GRANT SELECT ON TABLE public.event_subscriptions TO chartepssg_expert;
1620GRANT ALL ON TABLE public.event_subscriptions TO chartepssg_ingester;
1621
1622
1623--
1624-- Name: TABLE events; Type: ACL; Schema: public; Owner: chartepssg_admin
1625--
1626
1627GRANT SELECT ON TABLE public.events TO chartepssg_enduser;
1628GRANT SELECT ON TABLE public.events TO chartepssg_web;
1629GRANT SELECT ON TABLE public.events TO chartepssg_expert;
1630GRANT ALL ON TABLE public.events TO chartepssg_ingester;
1631
1632
1633--
1634-- Name: SEQUENCE events_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1635--
1636
1637GRANT ALL ON SEQUENCE public.events_id_seq TO chartepssg_ingester;
1638
1639
1640--
1641-- Name: TABLE fdf_events; Type: ACL; Schema: public; Owner: chartepssg_admin
1642--
1643
1644GRANT SELECT ON TABLE public.fdf_events TO chartepssg_enduser;
1645GRANT SELECT ON TABLE public.fdf_events TO chartepssg_web;
1646GRANT SELECT ON TABLE public.fdf_events TO chartepssg_expert;
1647GRANT ALL ON TABLE public.fdf_events TO chartepssg_ingester;
1648
1649
1650--
1651-- Name: TABLE geo_events; Type: ACL; Schema: public; Owner: chartepssg_admin
1652--
1653
1654GRANT SELECT ON TABLE public.geo_events TO chartepssg_enduser;
1655GRANT SELECT ON TABLE public.geo_events TO chartepssg_web;
1656GRANT SELECT ON TABLE public.geo_events TO chartepssg_expert;
1657GRANT ALL ON TABLE public.geo_events TO chartepssg_ingester;
1658
1659
1660--
1661-- Name: TABLE jobs; Type: ACL; Schema: public; Owner: chartepssg_admin
1662--
1663
1664GRANT SELECT ON TABLE public.jobs TO chartepssg_enduser;
1665GRANT SELECT ON TABLE public.jobs TO chartepssg_web;
1666GRANT SELECT ON TABLE public.jobs TO chartepssg_expert;
1667GRANT ALL ON TABLE public.jobs TO chartepssg_ingester;
1668
1669
1670--
1671-- Name: SEQUENCE jobs_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1672--
1673
1674GRANT ALL ON SEQUENCE public.jobs_id_seq TO chartepssg_ingester;
1675
1676
1677--
1678-- Name: TABLE orb_histo; Type: ACL; Schema: public; Owner: chartepssg_admin
1679--
1680
1681GRANT SELECT ON TABLE public.orb_histo TO chartepssg_enduser;
1682GRANT SELECT ON TABLE public.orb_histo TO chartepssg_web;
1683GRANT SELECT ON TABLE public.orb_histo TO chartepssg_expert;
1684GRANT ALL ON TABLE public.orb_histo TO chartepssg_ingester;
1685
1686
1687--
1688-- Name: TABLE processes; Type: ACL; Schema: public; Owner: chartepssg_admin
1689--
1690
1691GRANT SELECT ON TABLE public.processes TO chartepssg_enduser;
1692GRANT SELECT ON TABLE public.processes TO chartepssg_web;
1693GRANT SELECT ON TABLE public.processes TO chartepssg_expert;
1694GRANT ALL ON TABLE public.processes TO chartepssg_ingester;
1695
1696
1697--
1698-- Name: SEQUENCE processes_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1699--
1700
1701GRANT ALL ON SEQUENCE public.processes_id_seq TO chartepssg_ingester;
1702
1703
1704--
1705-- Name: TABLE products; Type: ACL; Schema: public; Owner: chartepssg_admin
1706--
1707
1708GRANT SELECT ON TABLE public.products TO chartepssg_enduser;
1709GRANT SELECT ON TABLE public.products TO chartepssg_web;
1710GRANT SELECT ON TABLE public.products TO chartepssg_expert;
1711GRANT ALL ON TABLE public.products TO chartepssg_ingester;
1712
1713
1714--
1715-- Name: SEQUENCE products_id_seq; Type: ACL; Schema: public; Owner: chartepssg_admin
1716--
1717
1718GRANT ALL ON SEQUENCE public.products_id_seq TO chartepssg_ingester;
1719
1720
1721--
1722-- Name: TABLE reports; Type: ACL; Schema: public; Owner: chartepssg_admin
1723--
1724
1725GRANT SELECT ON TABLE public.reports TO chartepssg_enduser;
1726GRANT SELECT ON TABLE public.reports TO chartepssg_web;
1727GRANT SELECT ON TABLE public.reports TO chartepssg_expert;
1728GRANT ALL ON TABLE public.reports TO chartepssg_ingester;
1729
1730
1731--
1732-- Name: TABLE subscriptions; Type: ACL; Schema: public; Owner: chartepssg_admin
1733--
1734
1735GRANT SELECT ON TABLE public.subscriptions TO chartepssg_enduser;
1736GRANT SELECT ON TABLE public.subscriptions TO chartepssg_web;
1737GRANT SELECT ON TABLE public.subscriptions TO chartepssg_expert;
1738GRANT ALL ON TABLE public.subscriptions TO chartepssg_ingester;
1739
1740
1741--
1742-- Name: TABLE tc_ack_store; Type: ACL; Schema: public; Owner: chartepssg_admin
1743--
1744
1745GRANT SELECT ON TABLE public.tc_ack_store TO chartepssg_enduser;
1746GRANT SELECT ON TABLE public.tc_ack_store TO chartepssg_web;
1747GRANT SELECT ON TABLE public.tc_ack_store TO chartepssg_expert;
1748GRANT ALL ON TABLE public.tc_ack_store TO chartepssg_ingester;
1749
1750
1751--
1752-- Name: TABLE tc_store; Type: ACL; Schema: public; Owner: chartepssg_admin
1753--
1754
1755GRANT SELECT ON TABLE public.tc_store TO chartepssg_enduser;
1756GRANT SELECT ON TABLE public.tc_store TO chartepssg_web;
1757GRANT SELECT ON TABLE public.tc_store TO chartepssg_expert;
1758GRANT ALL ON TABLE public.tc_store TO chartepssg_ingester;
1759
1760
1761--
1762-- Name: TABLE tm; Type: ACL; Schema: public; Owner: chartepssg_admin
1763--
1764
1765GRANT SELECT ON TABLE public.tm TO chartepssg_enduser;
1766GRANT SELECT ON TABLE public.tm TO chartepssg_web;
1767GRANT SELECT ON TABLE public.tm TO chartepssg_expert;
1768GRANT ALL ON TABLE public.tm TO chartepssg_ingester;
1769
1770
1771--
1772-- Name: TABLE tm_stats; Type: ACL; Schema: public; Owner: chartepssg_admin
1773--
1774
1775GRANT SELECT ON TABLE public.tm_stats TO chartepssg_enduser;
1776GRANT SELECT ON TABLE public.tm_stats TO chartepssg_web;
1777GRANT SELECT ON TABLE public.tm_stats TO chartepssg_expert;
1778GRANT ALL ON TABLE public.tm_stats TO chartepssg_ingester;
1779
1780
1781--
1782-- Name: TABLE users; Type: ACL; Schema: public; Owner: chartepssg_admin
1783--
1784
1785GRANT SELECT ON TABLE public.users TO chartepssg_enduser;
1786GRANT SELECT ON TABLE public.users TO chartepssg_web;
1787GRANT SELECT ON TABLE public.users TO chartepssg_expert;
1788GRANT ALL ON TABLE public.users TO chartepssg_ingester;
1789
1790
1791--
1792-- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: public; Owner: chartepssg_admin
1793--
1794
1795ALTER DEFAULT PRIVILEGES FOR ROLE chartepssg_admin IN SCHEMA public REVOKE ALL ON SEQUENCES FROM chartepssg_admin;
1796ALTER DEFAULT PRIVILEGES FOR ROLE chartepssg_admin IN SCHEMA public GRANT ALL ON SEQUENCES TO chartepssg_ingester;
1797
1798
1799--
1800-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: public; Owner: chartepssg_admin
1801--
1802
1803ALTER DEFAULT PRIVILEGES FOR ROLE chartepssg_admin IN SCHEMA public REVOKE ALL ON TABLES FROM chartepssg_admin;
1804ALTER DEFAULT PRIVILEGES FOR ROLE chartepssg_admin IN SCHEMA public GRANT SELECT ON TABLES TO chartepssg_enduser;
1805ALTER DEFAULT PRIVILEGES FOR ROLE chartepssg_admin IN SCHEMA public GRANT SELECT ON TABLES TO chartepssg_web;
1806ALTER DEFAULT PRIVILEGES FOR ROLE chartepssg_admin IN SCHEMA public GRANT SELECT ON TABLES TO chartepssg_expert;
1807ALTER DEFAULT PRIVILEGES FOR ROLE chartepssg_admin IN SCHEMA public GRANT ALL ON TABLES TO chartepssg_ingester;
1808
1809
1810--
1811-- PostgreSQL database dump complete
1812--