The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
TypeScript analyticsbibusiness-intelligencebusinessintelligenceclojuredashboarddatadata-analysisdata-visualizationdatabasemetabasemysqlpostgrespostgresqlreportingslacksql-editorvisualization
--
-- Name: citext; Type: EXTENSION; Schema: -; Owner: -
--
CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;
--
-- Name: activity; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.activity (
id integer NOT NULL,
topic character varying(32) NOT NULL,
"timestamp" timestamp with time zone NOT NULL,
user_id integer,
model character varying(16),
model_id integer,
database_id integer,
table_id integer,
custom_id character varying(48),
details text NOT NULL
);
--
-- Name: activity_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.activity ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.activity_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: application_permissions_revision; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.application_permissions_revision (
id integer NOT NULL,
before text NOT NULL,
after text NOT NULL,
user_id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
remark text
);
--
-- Name: application_permissions_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.application_permissions_revision ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.application_permissions_revision_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: bookmark_ordering; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.bookmark_ordering (
id integer NOT NULL,
user_id integer NOT NULL,
type character varying(255) NOT NULL,
item_id integer NOT NULL,
ordering integer NOT NULL
);
--
-- Name: bookmark_ordering_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.bookmark_ordering ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.bookmark_ordering_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: card_bookmark; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.card_bookmark (
id integer NOT NULL,
user_id integer NOT NULL,
card_id integer NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL
);
--
-- Name: card_bookmark_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.card_bookmark ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.card_bookmark_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: card_label; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.card_label (
id integer NOT NULL,
card_id integer NOT NULL,
label_id integer NOT NULL
);
--
-- Name: card_label_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.card_label ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.card_label_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: collection; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.collection (
id integer NOT NULL,
name text NOT NULL,
description text,
color character(7) NOT NULL,
archived boolean DEFAULT false NOT NULL,
location character varying(254) DEFAULT '/'::character varying NOT NULL,
personal_owner_id integer,
slug character varying(254) NOT NULL,
namespace character varying(254),
authority_level character varying(255),
entity_id character(21)
);
--
-- Name: collection_bookmark; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.collection_bookmark (
id integer NOT NULL,
user_id integer NOT NULL,
collection_id integer NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL
);
--
-- Name: collection_bookmark_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.collection_bookmark ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.collection_bookmark_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: collection_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.collection ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.collection_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: collection_permission_graph_revision; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.collection_permission_graph_revision (
id integer NOT NULL,
before text NOT NULL,
after text NOT NULL,
user_id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
remark text
);
--
-- Name: collection_permission_graph_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.collection_permission_graph_revision ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.collection_permission_graph_revision_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: computation_job; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.computation_job (
id integer NOT NULL,
creator_id integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
type character varying(254) NOT NULL,
status character varying(254) NOT NULL,
context text,
ended_at timestamp without time zone
);
--
-- Name: computation_job_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.computation_job ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.computation_job_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: computation_job_result; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.computation_job_result (
id integer NOT NULL,
job_id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
permanence character varying(254) NOT NULL,
payload text NOT NULL
);
--
-- Name: computation_job_result_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.computation_job_result ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.computation_job_result_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: core_session; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.core_session (
id character varying(254) NOT NULL,
user_id integer NOT NULL,
created_at timestamp with time zone NOT NULL,
anti_csrf_token text
);
--
-- Name: core_user; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.core_user (
id integer NOT NULL,
email public.citext NOT NULL,
first_name character varying(254),
last_name character varying(254),
password character varying(254),
password_salt character varying(254) DEFAULT 'default'::character varying,
date_joined timestamp with time zone NOT NULL,
last_login timestamp with time zone,
is_superuser boolean DEFAULT false NOT NULL,
is_active boolean DEFAULT true NOT NULL,
reset_token character varying(254),
reset_triggered bigint,
is_qbnewb boolean DEFAULT true NOT NULL,
google_auth boolean DEFAULT false NOT NULL,
ldap_auth boolean DEFAULT false NOT NULL,
login_attributes text,
updated_at timestamp without time zone,
sso_source character varying(254),
locale character varying(5),
is_datasetnewb boolean DEFAULT true NOT NULL,
settings text
);
--
-- Name: core_user_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.core_user ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.core_user_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: dashboard_bookmark; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.dashboard_bookmark (
id integer NOT NULL,
user_id integer NOT NULL,
dashboard_id integer NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL
);
--
-- Name: dashboard_bookmark_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.dashboard_bookmark ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.dashboard_bookmark_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: dashboard_favorite; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.dashboard_favorite (
id integer NOT NULL,
user_id integer NOT NULL,
dashboard_id integer NOT NULL
);
--
-- Name: dashboard_favorite_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.dashboard_favorite ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.dashboard_favorite_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: dashboardcard_series; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.dashboardcard_series (
id integer NOT NULL,
dashboardcard_id integer NOT NULL,
card_id integer NOT NULL,
"position" integer NOT NULL
);
--
-- Name: dashboardcard_series_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.dashboardcard_series ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.dashboardcard_series_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: data_migrations; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.data_migrations (
id character varying(254) NOT NULL,
"timestamp" timestamp without time zone NOT NULL
);
--
-- Name: dependency; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.dependency (
id integer NOT NULL,
model character varying(32) NOT NULL,
model_id integer NOT NULL,
dependent_on_model character varying(32) NOT NULL,
dependent_on_id integer NOT NULL,
created_at timestamp with time zone NOT NULL
);
--
-- Name: dependency_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.dependency ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.dependency_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: dimension; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.dimension (
id integer NOT NULL,
field_id integer NOT NULL,
name character varying(254) NOT NULL,
type character varying(254) NOT NULL,
human_readable_field_id integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
entity_id character(21)
);
--
-- Name: dimension_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.dimension ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.dimension_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: group_table_access_policy; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.group_table_access_policy (
id integer NOT NULL,
group_id integer NOT NULL,
table_id integer NOT NULL,
card_id integer,
attribute_remappings text
);
--
-- Name: group_table_access_policy_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.group_table_access_policy ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.group_table_access_policy_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: label; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.label (
id integer NOT NULL,
name character varying(254) NOT NULL,
slug character varying(254) NOT NULL,
icon character varying(128)
);
--
-- Name: label_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.label ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.label_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: login_history; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.login_history (
id integer NOT NULL,
"timestamp" timestamp with time zone DEFAULT now() NOT NULL,
user_id integer NOT NULL,
session_id character varying(254),
device_id character(36) NOT NULL,
device_description text NOT NULL,
ip_address text NOT NULL
);
--
-- Name: login_history_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.login_history ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.login_history_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: metabase_database; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.metabase_database (
id integer NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
name character varying(254) NOT NULL,
description text,
details text,
engine character varying(254) NOT NULL,
is_sample boolean DEFAULT false NOT NULL,
is_full_sync boolean DEFAULT true NOT NULL,
points_of_interest text,
caveats text,
metadata_sync_schedule character varying(254) DEFAULT '0 50 * * * ? *'::character varying NOT NULL,
cache_field_values_schedule character varying(254) DEFAULT '0 50 0 * * ? *'::character varying NOT NULL,
timezone character varying(254),
is_on_demand boolean DEFAULT false NOT NULL,
options text,
auto_run_queries boolean DEFAULT true NOT NULL,
refingerprint boolean,
cache_ttl integer,
initial_sync_status character varying(32) DEFAULT 'complete'::character varying NOT NULL,
creator_id integer,
settings text
);
--
-- Name: metabase_database_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.metabase_database ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.metabase_database_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: metabase_field; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.metabase_field (
id integer NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
name character varying(254) NOT NULL,
base_type character varying(255) NOT NULL,
semantic_type character varying(255),
active boolean DEFAULT true NOT NULL,
description text,
preview_display boolean DEFAULT true NOT NULL,
"position" integer DEFAULT 0 NOT NULL,
table_id integer NOT NULL,
parent_id integer,
display_name character varying(254),
visibility_type character varying(32) DEFAULT 'normal'::character varying NOT NULL,
fk_target_field_id integer,
last_analyzed timestamp with time zone,
points_of_interest text,
caveats text,
fingerprint text,
fingerprint_version integer DEFAULT 0 NOT NULL,
database_type text NOT NULL,
has_field_values text,
settings text,
database_position integer DEFAULT 0 NOT NULL,
custom_position integer DEFAULT 0 NOT NULL,
effective_type character varying(255),
coercion_strategy character varying(255),
nfc_path character varying(254),
database_required boolean DEFAULT false NOT NULL
);
--
-- Name: metabase_field_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.metabase_field ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.metabase_field_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: metabase_fieldvalues; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.metabase_fieldvalues (
id integer NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
"values" text,
human_readable_values text,
field_id integer NOT NULL,
has_more_values boolean DEFAULT false,
type character varying(32) DEFAULT 'full'::character varying NOT NULL,
hash_key text
);
--
-- Name: metabase_fieldvalues_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.metabase_fieldvalues ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.metabase_fieldvalues_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: metabase_table; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.metabase_table (
id integer NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
name character varying(254) NOT NULL,
description text,
entity_type character varying(254),
active boolean NOT NULL,
db_id integer NOT NULL,
display_name character varying(254),
visibility_type character varying(254),
schema character varying(254),
points_of_interest text,
caveats text,
show_in_getting_started boolean DEFAULT false NOT NULL,
field_order character varying(254) DEFAULT 'database'::character varying NOT NULL,
initial_sync_status character varying(32) DEFAULT 'complete'::character varying NOT NULL
);
--
-- Name: metabase_table_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.metabase_table ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.metabase_table_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: metric; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.metric (
id integer NOT NULL,
table_id integer NOT NULL,
creator_id integer NOT NULL,
name character varying(254) NOT NULL,
description text,
archived boolean DEFAULT false NOT NULL,
definition text NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
points_of_interest text,
caveats text,
how_is_this_calculated text,
show_in_getting_started boolean DEFAULT false NOT NULL,
entity_id character(21)
);
--
-- Name: metric_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.metric ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.metric_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: metric_important_field; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.metric_important_field (
id integer NOT NULL,
metric_id integer NOT NULL,
field_id integer NOT NULL
);
--
-- Name: metric_important_field_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.metric_important_field ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.metric_important_field_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: moderation_review; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.moderation_review (
id integer NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
status character varying(255),
text text,
moderated_item_id integer NOT NULL,
moderated_item_type character varying(255) NOT NULL,
moderator_id integer NOT NULL,
most_recent boolean NOT NULL
);
--
-- Name: moderation_review_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.moderation_review ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.moderation_review_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: native_query_snippet; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.native_query_snippet (
id integer NOT NULL,
name character varying(254) NOT NULL,
description text,
content text NOT NULL,
creator_id integer NOT NULL,
archived boolean DEFAULT false NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
collection_id integer,
entity_id character(21)
);
--
-- Name: native_query_snippet_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.native_query_snippet ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.native_query_snippet_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: permissions; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.permissions (
id integer NOT NULL,
object character varying(254) NOT NULL,
group_id integer NOT NULL
);
--
-- Name: permissions_group; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.permissions_group (
id integer NOT NULL,
name character varying(255) NOT NULL
);
--
-- Name: permissions_group_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.permissions_group ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.permissions_group_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: permissions_group_membership; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.permissions_group_membership (
id integer NOT NULL,
user_id integer NOT NULL,
group_id integer NOT NULL,
is_group_manager boolean DEFAULT false NOT NULL
);
--
-- Name: permissions_group_membership_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.permissions_group_membership ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.permissions_group_membership_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.permissions_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: permissions_revision; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.permissions_revision (
id integer NOT NULL,
before text NOT NULL,
after text NOT NULL,
user_id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
remark text
);
--
-- Name: permissions_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.permissions_revision ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.permissions_revision_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: persisted_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.persisted_info (
id integer NOT NULL,
database_id integer NOT NULL,
card_id integer NOT NULL,
question_slug text NOT NULL,
table_name text NOT NULL,
definition text,
query_hash text,
active boolean DEFAULT false NOT NULL,
state text NOT NULL,
refresh_begin timestamp with time zone NOT NULL,
refresh_end timestamp with time zone,
state_change_at timestamp with time zone,
error text,
created_at timestamp with time zone DEFAULT now() NOT NULL,
creator_id integer
);
--
-- Name: persisted_info_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.persisted_info ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.persisted_info_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: pulse; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.pulse (
id integer NOT NULL,
creator_id integer NOT NULL,
name character varying(254),
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
skip_if_empty boolean DEFAULT false NOT NULL,
alert_condition character varying(254),
alert_first_only boolean,
alert_above_goal boolean,
collection_id integer,
collection_position smallint,
archived boolean DEFAULT false,
dashboard_id integer,
parameters text NOT NULL,
entity_id character(21)
);
--
-- Name: pulse_card; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.pulse_card (
id integer NOT NULL,
pulse_id integer NOT NULL,
card_id integer NOT NULL,
"position" integer NOT NULL,
include_csv boolean DEFAULT false NOT NULL,
include_xls boolean DEFAULT false NOT NULL,
dashboard_card_id integer,
entity_id character(21)
);
--
-- Name: pulse_card_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.pulse_card ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.pulse_card_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: pulse_channel; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.pulse_channel (
id integer NOT NULL,
pulse_id integer NOT NULL,
channel_type character varying(32) NOT NULL,
details text NOT NULL,
schedule_type character varying(32) NOT NULL,
schedule_hour integer,
schedule_day character varying(64),
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
schedule_frame character varying(32),
enabled boolean DEFAULT true NOT NULL,
entity_id character(21)
);
--
-- Name: pulse_channel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.pulse_channel ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.pulse_channel_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: pulse_channel_recipient; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.pulse_channel_recipient (
id integer NOT NULL,
pulse_channel_id integer NOT NULL,
user_id integer NOT NULL
);
--
-- Name: pulse_channel_recipient_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.pulse_channel_recipient ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.pulse_channel_recipient_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: pulse_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.pulse ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.pulse_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: qrtz_blob_triggers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_blob_triggers (
sched_name character varying(120) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
blob_data bytea
);
--
-- Name: qrtz_calendars; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_calendars (
sched_name character varying(120) NOT NULL,
calendar_name character varying(200) NOT NULL,
calendar bytea NOT NULL
);
--
-- Name: qrtz_cron_triggers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_cron_triggers (
sched_name character varying(120) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
cron_expression character varying(120) NOT NULL,
time_zone_id character varying(80)
);
--
-- Name: qrtz_fired_triggers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_fired_triggers (
sched_name character varying(120) NOT NULL,
entry_id character varying(95) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
instance_name character varying(200) NOT NULL,
fired_time bigint NOT NULL,
sched_time bigint,
priority integer NOT NULL,
state character varying(16) NOT NULL,
job_name character varying(200),
job_group character varying(200),
is_nonconcurrent boolean,
requests_recovery boolean
);
--
-- Name: qrtz_job_details; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_job_details (
sched_name character varying(120) NOT NULL,
job_name character varying(200) NOT NULL,
job_group character varying(200) NOT NULL,
description character varying(250),
job_class_name character varying(250) NOT NULL,
is_durable boolean NOT NULL,
is_nonconcurrent boolean NOT NULL,
is_update_data boolean NOT NULL,
requests_recovery boolean NOT NULL,
job_data bytea
);
--
-- Name: qrtz_locks; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_locks (
sched_name character varying(120) NOT NULL,
lock_name character varying(40) NOT NULL
);
--
-- Name: qrtz_paused_trigger_grps; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_paused_trigger_grps (
sched_name character varying(120) NOT NULL,
trigger_group character varying(200) NOT NULL
);
--
-- Name: qrtz_scheduler_state; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_scheduler_state (
sched_name character varying(120) NOT NULL,
instance_name character varying(200) NOT NULL,
last_checkin_time bigint NOT NULL,
checkin_interval bigint NOT NULL
);
--
-- Name: qrtz_simple_triggers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_simple_triggers (
sched_name character varying(120) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
repeat_count bigint NOT NULL,
repeat_interval bigint NOT NULL,
times_triggered bigint NOT NULL
);
--
-- Name: qrtz_simprop_triggers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_simprop_triggers (
sched_name character varying(120) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
str_prop_1 character varying(512),
str_prop_2 character varying(512),
str_prop_3 character varying(512),
int_prop_1 integer,
int_prop_2 integer,
long_prop_1 bigint,
long_prop_2 bigint,
dec_prop_1 numeric(13,4),
dec_prop_2 numeric(13,4),
bool_prop_1 boolean,
bool_prop_2 boolean
);
--
-- Name: qrtz_triggers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.qrtz_triggers (
sched_name character varying(120) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
job_name character varying(200) NOT NULL,
job_group character varying(200) NOT NULL,
description character varying(250),
next_fire_time bigint,
prev_fire_time bigint,
priority integer,
trigger_state character varying(16) NOT NULL,
trigger_type character varying(8) NOT NULL,
start_time bigint NOT NULL,
end_time bigint,
calendar_name character varying(200),
misfire_instr smallint,
job_data bytea
);
--
-- Name: query; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.query (
query_hash bytea NOT NULL,
average_execution_time integer NOT NULL,
query text
);
--
-- Name: query_cache; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.query_cache (
query_hash bytea NOT NULL,
updated_at timestamp with time zone NOT NULL,
results bytea NOT NULL
);
--
-- Name: query_execution; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.query_execution (
id integer NOT NULL,
hash bytea NOT NULL,
started_at timestamp with time zone NOT NULL,
running_time integer NOT NULL,
result_rows integer NOT NULL,
native boolean NOT NULL,
context character varying(32),
error text,
executor_id integer,
card_id integer,
dashboard_id integer,
pulse_id integer,
database_id integer,
cache_hit boolean
);
--
-- Name: query_execution_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.query_execution ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.query_execution_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: report_card; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.report_card (
id integer NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
name character varying(254) NOT NULL,
description text,
display character varying(254) NOT NULL,
dataset_query text NOT NULL,
visualization_settings text NOT NULL,
creator_id integer NOT NULL,
database_id integer NOT NULL,
table_id integer,
query_type character varying(16),
archived boolean DEFAULT false NOT NULL,
collection_id integer,
public_uuid character(36),
made_public_by_id integer,
enable_embedding boolean DEFAULT false NOT NULL,
embedding_params text,
cache_ttl integer,
result_metadata text,
collection_position smallint,
dataset boolean DEFAULT false NOT NULL,
entity_id character(21),
parameters text,
parameter_mappings text,
collection_preview boolean DEFAULT true NOT NULL
);
--
-- Name: report_card_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.report_card ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.report_card_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: report_cardfavorite; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.report_cardfavorite (
id integer NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
card_id integer NOT NULL,
owner_id integer NOT NULL
);
--
-- Name: report_cardfavorite_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.report_cardfavorite ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.report_cardfavorite_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: report_dashboard; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.report_dashboard (
id integer NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
name character varying(254) NOT NULL,
description text,
creator_id integer NOT NULL,
parameters text NOT NULL,
points_of_interest text,
caveats text,
show_in_getting_started boolean DEFAULT false NOT NULL,
public_uuid character(36),
made_public_by_id integer,
enable_embedding boolean DEFAULT false NOT NULL,
embedding_params text,
archived boolean DEFAULT false NOT NULL,
"position" integer,
collection_id integer,
collection_position smallint,
cache_ttl integer,
entity_id character(21)
);
--
-- Name: report_dashboard_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.report_dashboard ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.report_dashboard_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: report_dashboardcard; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.report_dashboardcard (
id integer NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
"sizeX" integer NOT NULL,
"sizeY" integer NOT NULL,
"row" integer DEFAULT 0 NOT NULL,
col integer DEFAULT 0 NOT NULL,
card_id integer,
dashboard_id integer NOT NULL,
parameter_mappings text NOT NULL,
visualization_settings text NOT NULL,
entity_id character(21)
);
--
-- Name: report_dashboardcard_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.report_dashboardcard ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.report_dashboardcard_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: revision; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.revision (
id integer NOT NULL,
model character varying(16) NOT NULL,
model_id integer NOT NULL,
user_id integer NOT NULL,
"timestamp" timestamp with time zone NOT NULL,
object text NOT NULL,
is_reversion boolean DEFAULT false NOT NULL,
is_creation boolean DEFAULT false NOT NULL,
message text
);
--
-- Name: revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.revision ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.revision_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: secret; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.secret (
id integer NOT NULL,
version integer DEFAULT 1 NOT NULL,
creator_id integer,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone,
name character varying(254) NOT NULL,
kind character varying(254) NOT NULL,
source character varying(254),
value bytea NOT NULL
);
--
-- Name: secret_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.secret ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.secret_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: segment; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.segment (
id integer NOT NULL,
table_id integer NOT NULL,
creator_id integer NOT NULL,
name character varying(254) NOT NULL,
description text,
archived boolean DEFAULT false NOT NULL,
definition text NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
points_of_interest text,
caveats text,
show_in_getting_started boolean DEFAULT false NOT NULL,
entity_id character(21)
);
--
-- Name: segment_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.segment ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.segment_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: setting; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.setting (
key character varying(254) NOT NULL,
value text NOT NULL
);
--
-- Name: task_history; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.task_history (
id integer NOT NULL,
task character varying(254) NOT NULL,
db_id integer,
started_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
ended_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
duration integer NOT NULL,
task_details text
);
--
-- Name: task_history_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.task_history ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.task_history_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: timeline; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.timeline (
id integer NOT NULL,
name character varying(255) NOT NULL,
description character varying(255),
icon character varying(128) NOT NULL,
collection_id integer,
archived boolean DEFAULT false NOT NULL,
creator_id integer NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
"default" boolean DEFAULT false NOT NULL,
entity_id character(21)
);
--
-- Name: timeline_event; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.timeline_event (
id integer NOT NULL,
timeline_id integer NOT NULL,
name character varying(255) NOT NULL,
description character varying(255),
"timestamp" timestamp with time zone NOT NULL,
time_matters boolean NOT NULL,
timezone character varying(255) NOT NULL,
icon character varying(128) NOT NULL,
archived boolean DEFAULT false NOT NULL,
creator_id integer NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL
);
--
-- Name: timeline_event_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.timeline_event ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.timeline_event_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: timeline_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.timeline ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.timeline_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: view_log; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.view_log (
id integer NOT NULL,
user_id integer,
model character varying(16) NOT NULL,
model_id integer NOT NULL,
"timestamp" timestamp with time zone NOT NULL,
metadata text
);
--
-- Name: view_log_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.view_log ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.view_log_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: activity activity_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.activity
ADD CONSTRAINT activity_pkey PRIMARY KEY (id);
--
-- Name: bookmark_ordering bookmark_ordering_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.bookmark_ordering
ADD CONSTRAINT bookmark_ordering_pkey PRIMARY KEY (id);
--
-- Name: card_bookmark card_bookmark_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.card_bookmark
ADD CONSTRAINT card_bookmark_pkey PRIMARY KEY (id);
--
-- Name: card_label card_label_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.card_label
ADD CONSTRAINT card_label_pkey PRIMARY KEY (id);
--
-- Name: collection_bookmark collection_bookmark_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.collection_bookmark
ADD CONSTRAINT collection_bookmark_pkey PRIMARY KEY (id);
--
-- Name: collection collection_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.collection
ADD CONSTRAINT collection_entity_id_key UNIQUE (entity_id);
--
-- Name: collection collection_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.collection
ADD CONSTRAINT collection_pkey PRIMARY KEY (id);
--
-- Name: collection_permission_graph_revision collection_revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.collection_permission_graph_revision
ADD CONSTRAINT collection_revision_pkey PRIMARY KEY (id);
--
-- Name: computation_job computation_job_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.computation_job
ADD CONSTRAINT computation_job_pkey PRIMARY KEY (id);
--
-- Name: computation_job_result computation_job_result_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.computation_job_result
ADD CONSTRAINT computation_job_result_pkey PRIMARY KEY (id);
--
-- Name: core_session core_session_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.core_session
ADD CONSTRAINT core_session_pkey PRIMARY KEY (id);
--
-- Name: core_user core_user_email_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.core_user
ADD CONSTRAINT core_user_email_key UNIQUE (email);
--
-- Name: core_user core_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.core_user
ADD CONSTRAINT core_user_pkey PRIMARY KEY (id);
--
-- Name: dashboard_bookmark dashboard_bookmark_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboard_bookmark
ADD CONSTRAINT dashboard_bookmark_pkey PRIMARY KEY (id);
--
-- Name: dashboard_favorite dashboard_favorite_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboard_favorite
ADD CONSTRAINT dashboard_favorite_pkey PRIMARY KEY (id);
--
-- Name: dashboardcard_series dashboardcard_series_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboardcard_series
ADD CONSTRAINT dashboardcard_series_pkey PRIMARY KEY (id);
--
-- Name: data_migrations data_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.data_migrations
ADD CONSTRAINT data_migrations_pkey PRIMARY KEY (id);
--
-- Name: dependency dependency_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dependency
ADD CONSTRAINT dependency_pkey PRIMARY KEY (id);
--
-- Name: dimension dimension_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dimension
ADD CONSTRAINT dimension_entity_id_key UNIQUE (entity_id);
--
-- Name: dimension dimension_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dimension
ADD CONSTRAINT dimension_pkey PRIMARY KEY (id);
--
-- Name: application_permissions_revision general_permissions_revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.application_permissions_revision
ADD CONSTRAINT general_permissions_revision_pkey PRIMARY KEY (id);
--
-- Name: group_table_access_policy group_table_access_policy_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.group_table_access_policy
ADD CONSTRAINT group_table_access_policy_pkey PRIMARY KEY (id);
--
-- Name: metabase_field idx_uniq_field_table_id_parent_id_name; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_field
ADD CONSTRAINT idx_uniq_field_table_id_parent_id_name UNIQUE (table_id, parent_id, name);
--
-- Name: metabase_table idx_uniq_table_db_id_schema_name; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_table
ADD CONSTRAINT idx_uniq_table_db_id_schema_name UNIQUE (db_id, schema, name);
--
-- Name: report_cardfavorite idx_unique_cardfavorite_card_id_owner_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_cardfavorite
ADD CONSTRAINT idx_unique_cardfavorite_card_id_owner_id UNIQUE (card_id, owner_id);
--
-- Name: label label_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.label
ADD CONSTRAINT label_pkey PRIMARY KEY (id);
--
-- Name: label label_slug_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.label
ADD CONSTRAINT label_slug_key UNIQUE (slug);
--
-- Name: login_history login_history_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.login_history
ADD CONSTRAINT login_history_pkey PRIMARY KEY (id);
--
-- Name: metabase_database metabase_database_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_database
ADD CONSTRAINT metabase_database_pkey PRIMARY KEY (id);
--
-- Name: metabase_field metabase_field_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_field
ADD CONSTRAINT metabase_field_pkey PRIMARY KEY (id);
--
-- Name: metabase_fieldvalues metabase_fieldvalues_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_fieldvalues
ADD CONSTRAINT metabase_fieldvalues_pkey PRIMARY KEY (id);
--
-- Name: metabase_table metabase_table_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_table
ADD CONSTRAINT metabase_table_pkey PRIMARY KEY (id);
--
-- Name: metric metric_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metric
ADD CONSTRAINT metric_entity_id_key UNIQUE (entity_id);
--
-- Name: metric_important_field metric_important_field_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metric_important_field
ADD CONSTRAINT metric_important_field_pkey PRIMARY KEY (id);
--
-- Name: metric metric_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metric
ADD CONSTRAINT metric_pkey PRIMARY KEY (id);
--
-- Name: moderation_review moderation_review_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.moderation_review
ADD CONSTRAINT moderation_review_pkey PRIMARY KEY (id);
--
-- Name: native_query_snippet native_query_snippet_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.native_query_snippet
ADD CONSTRAINT native_query_snippet_entity_id_key UNIQUE (entity_id);
--
-- Name: native_query_snippet native_query_snippet_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.native_query_snippet
ADD CONSTRAINT native_query_snippet_name_key UNIQUE (name);
--
-- Name: native_query_snippet native_query_snippet_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.native_query_snippet
ADD CONSTRAINT native_query_snippet_pkey PRIMARY KEY (id);
--
-- Name: permissions permissions_group_id_object_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions
ADD CONSTRAINT permissions_group_id_object_key UNIQUE (group_id, object);
--
-- Name: permissions_group_membership permissions_group_membership_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions_group_membership
ADD CONSTRAINT permissions_group_membership_pkey PRIMARY KEY (id);
--
-- Name: permissions_group permissions_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions_group
ADD CONSTRAINT permissions_group_pkey PRIMARY KEY (id);
--
-- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions
ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);
--
-- Name: permissions_revision permissions_revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions_revision
ADD CONSTRAINT permissions_revision_pkey PRIMARY KEY (id);
--
-- Name: persisted_info persisted_info_card_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.persisted_info
ADD CONSTRAINT persisted_info_card_id_key UNIQUE (card_id);
--
-- Name: persisted_info persisted_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.persisted_info
ADD CONSTRAINT persisted_info_pkey PRIMARY KEY (id);
--
-- Name: qrtz_blob_triggers pk_qrtz_blob_triggers; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_blob_triggers
ADD CONSTRAINT pk_qrtz_blob_triggers PRIMARY KEY (sched_name, trigger_name, trigger_group);
--
-- Name: qrtz_calendars pk_qrtz_calendars; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_calendars
ADD CONSTRAINT pk_qrtz_calendars PRIMARY KEY (sched_name, calendar_name);
--
-- Name: qrtz_cron_triggers pk_qrtz_cron_triggers; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_cron_triggers
ADD CONSTRAINT pk_qrtz_cron_triggers PRIMARY KEY (sched_name, trigger_name, trigger_group);
--
-- Name: qrtz_fired_triggers pk_qrtz_fired_triggers; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_fired_triggers
ADD CONSTRAINT pk_qrtz_fired_triggers PRIMARY KEY (sched_name, entry_id);
--
-- Name: qrtz_job_details pk_qrtz_job_details; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_job_details
ADD CONSTRAINT pk_qrtz_job_details PRIMARY KEY (sched_name, job_name, job_group);
--
-- Name: qrtz_locks pk_qrtz_locks; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_locks
ADD CONSTRAINT pk_qrtz_locks PRIMARY KEY (sched_name, lock_name);
--
-- Name: qrtz_scheduler_state pk_qrtz_scheduler_state; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_scheduler_state
ADD CONSTRAINT pk_qrtz_scheduler_state PRIMARY KEY (sched_name, instance_name);
--
-- Name: qrtz_simple_triggers pk_qrtz_simple_triggers; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_simple_triggers
ADD CONSTRAINT pk_qrtz_simple_triggers PRIMARY KEY (sched_name, trigger_name, trigger_group);
--
-- Name: qrtz_simprop_triggers pk_qrtz_simprop_triggers; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_simprop_triggers
ADD CONSTRAINT pk_qrtz_simprop_triggers PRIMARY KEY (sched_name, trigger_name, trigger_group);
--
-- Name: qrtz_triggers pk_qrtz_triggers; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_triggers
ADD CONSTRAINT pk_qrtz_triggers PRIMARY KEY (sched_name, trigger_name, trigger_group);
--
-- Name: qrtz_paused_trigger_grps pk_sched_name; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_paused_trigger_grps
ADD CONSTRAINT pk_sched_name PRIMARY KEY (sched_name, trigger_group);
--
-- Name: pulse_card pulse_card_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_card
ADD CONSTRAINT pulse_card_entity_id_key UNIQUE (entity_id);
--
-- Name: pulse_card pulse_card_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_card
ADD CONSTRAINT pulse_card_pkey PRIMARY KEY (id);
--
-- Name: pulse_channel pulse_channel_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_channel
ADD CONSTRAINT pulse_channel_entity_id_key UNIQUE (entity_id);
--
-- Name: pulse_channel pulse_channel_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_channel
ADD CONSTRAINT pulse_channel_pkey PRIMARY KEY (id);
--
-- Name: pulse_channel_recipient pulse_channel_recipient_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_channel_recipient
ADD CONSTRAINT pulse_channel_recipient_pkey PRIMARY KEY (id);
--
-- Name: pulse pulse_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse
ADD CONSTRAINT pulse_entity_id_key UNIQUE (entity_id);
--
-- Name: pulse pulse_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse
ADD CONSTRAINT pulse_pkey PRIMARY KEY (id);
--
-- Name: query_cache query_cache_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.query_cache
ADD CONSTRAINT query_cache_pkey PRIMARY KEY (query_hash);
--
-- Name: query_execution query_execution_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.query_execution
ADD CONSTRAINT query_execution_pkey PRIMARY KEY (id);
--
-- Name: query query_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.query
ADD CONSTRAINT query_pkey PRIMARY KEY (query_hash);
--
-- Name: report_card report_card_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_card
ADD CONSTRAINT report_card_entity_id_key UNIQUE (entity_id);
--
-- Name: report_card report_card_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_card
ADD CONSTRAINT report_card_pkey PRIMARY KEY (id);
--
-- Name: report_card report_card_public_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_card
ADD CONSTRAINT report_card_public_uuid_key UNIQUE (public_uuid);
--
-- Name: report_cardfavorite report_cardfavorite_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_cardfavorite
ADD CONSTRAINT report_cardfavorite_pkey PRIMARY KEY (id);
--
-- Name: report_dashboard report_dashboard_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_dashboard
ADD CONSTRAINT report_dashboard_entity_id_key UNIQUE (entity_id);
--
-- Name: report_dashboard report_dashboard_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_dashboard
ADD CONSTRAINT report_dashboard_pkey PRIMARY KEY (id);
--
-- Name: report_dashboard report_dashboard_public_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_dashboard
ADD CONSTRAINT report_dashboard_public_uuid_key UNIQUE (public_uuid);
--
-- Name: report_dashboardcard report_dashboardcard_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_dashboardcard
ADD CONSTRAINT report_dashboardcard_entity_id_key UNIQUE (entity_id);
--
-- Name: report_dashboardcard report_dashboardcard_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_dashboardcard
ADD CONSTRAINT report_dashboardcard_pkey PRIMARY KEY (id);
--
-- Name: revision revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.revision
ADD CONSTRAINT revision_pkey PRIMARY KEY (id);
--
-- Name: secret secret_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.secret
ADD CONSTRAINT secret_pkey PRIMARY KEY (id, version);
--
-- Name: segment segment_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.segment
ADD CONSTRAINT segment_entity_id_key UNIQUE (entity_id);
--
-- Name: segment segment_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.segment
ADD CONSTRAINT segment_pkey PRIMARY KEY (id);
--
-- Name: setting setting_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.setting
ADD CONSTRAINT setting_pkey PRIMARY KEY (key);
--
-- Name: task_history task_history_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.task_history
ADD CONSTRAINT task_history_pkey PRIMARY KEY (id);
--
-- Name: timeline timeline_entity_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.timeline
ADD CONSTRAINT timeline_entity_id_key UNIQUE (entity_id);
--
-- Name: timeline_event timeline_event_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.timeline_event
ADD CONSTRAINT timeline_event_pkey PRIMARY KEY (id);
--
-- Name: timeline timeline_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.timeline
ADD CONSTRAINT timeline_pkey PRIMARY KEY (id);
--
-- Name: bookmark_ordering unique_bookmark_user_id_ordering; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.bookmark_ordering
ADD CONSTRAINT unique_bookmark_user_id_ordering UNIQUE (user_id, ordering);
--
-- Name: bookmark_ordering unique_bookmark_user_id_type_item_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.bookmark_ordering
ADD CONSTRAINT unique_bookmark_user_id_type_item_id UNIQUE (user_id, type, item_id);
--
-- Name: card_bookmark unique_card_bookmark_user_id_card_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.card_bookmark
ADD CONSTRAINT unique_card_bookmark_user_id_card_id UNIQUE (user_id, card_id);
--
-- Name: card_label unique_card_label_card_id_label_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.card_label
ADD CONSTRAINT unique_card_label_card_id_label_id UNIQUE (card_id, label_id);
--
-- Name: collection_bookmark unique_collection_bookmark_user_id_collection_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.collection_bookmark
ADD CONSTRAINT unique_collection_bookmark_user_id_collection_id UNIQUE (user_id, collection_id);
--
-- Name: collection unique_collection_personal_owner_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.collection
ADD CONSTRAINT unique_collection_personal_owner_id UNIQUE (personal_owner_id);
--
-- Name: dashboard_bookmark unique_dashboard_bookmark_user_id_dashboard_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboard_bookmark
ADD CONSTRAINT unique_dashboard_bookmark_user_id_dashboard_id UNIQUE (user_id, dashboard_id);
--
-- Name: dashboard_favorite unique_dashboard_favorite_user_id_dashboard_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboard_favorite
ADD CONSTRAINT unique_dashboard_favorite_user_id_dashboard_id UNIQUE (user_id, dashboard_id);
--
-- Name: dimension unique_dimension_field_id_name; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dimension
ADD CONSTRAINT unique_dimension_field_id_name UNIQUE (field_id, name);
--
-- Name: group_table_access_policy unique_gtap_table_id_group_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.group_table_access_policy
ADD CONSTRAINT unique_gtap_table_id_group_id UNIQUE (table_id, group_id);
--
-- Name: metric_important_field unique_metric_important_field_metric_id_field_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metric_important_field
ADD CONSTRAINT unique_metric_important_field_metric_id_field_id UNIQUE (metric_id, field_id);
--
-- Name: permissions_group_membership unique_permissions_group_membership_user_id_group_id; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions_group_membership
ADD CONSTRAINT unique_permissions_group_membership_user_id_group_id UNIQUE (user_id, group_id);
--
-- Name: permissions_group unique_permissions_group_name; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions_group
ADD CONSTRAINT unique_permissions_group_name UNIQUE (name);
--
-- Name: view_log view_log_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.view_log
ADD CONSTRAINT view_log_pkey PRIMARY KEY (id);
--
-- Name: idx_activity_custom_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_activity_custom_id ON public.activity USING btree (custom_id);
--
-- Name: idx_activity_timestamp; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_activity_timestamp ON public.activity USING btree ("timestamp");
--
-- Name: idx_activity_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_activity_user_id ON public.activity USING btree (user_id);
--
-- Name: idx_bookmark_ordering_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_bookmark_ordering_user_id ON public.bookmark_ordering USING btree (user_id);
--
-- Name: idx_card_bookmark_card_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_card_bookmark_card_id ON public.card_bookmark USING btree (card_id);
--
-- Name: idx_card_bookmark_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_card_bookmark_user_id ON public.card_bookmark USING btree (user_id);
--
-- Name: idx_card_collection_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_card_collection_id ON public.report_card USING btree (collection_id);
--
-- Name: idx_card_creator_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_card_creator_id ON public.report_card USING btree (creator_id);
--
-- Name: idx_card_label_card_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_card_label_card_id ON public.card_label USING btree (card_id);
--
-- Name: idx_card_label_label_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_card_label_label_id ON public.card_label USING btree (label_id);
--
-- Name: idx_card_public_uuid; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_card_public_uuid ON public.report_card USING btree (public_uuid);
--
-- Name: idx_cardfavorite_card_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_cardfavorite_card_id ON public.report_cardfavorite USING btree (card_id);
--
-- Name: idx_cardfavorite_owner_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_cardfavorite_owner_id ON public.report_cardfavorite USING btree (owner_id);
--
-- Name: idx_collection_bookmark_collection_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_collection_bookmark_collection_id ON public.collection_bookmark USING btree (collection_id);
--
-- Name: idx_collection_bookmark_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_collection_bookmark_user_id ON public.collection_bookmark USING btree (user_id);
--
-- Name: idx_collection_location; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_collection_location ON public.collection USING btree (location);
--
-- Name: idx_collection_personal_owner_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_collection_personal_owner_id ON public.collection USING btree (personal_owner_id);
--
-- Name: idx_dashboard_bookmark_dashboard_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboard_bookmark_dashboard_id ON public.dashboard_bookmark USING btree (dashboard_id);
--
-- Name: idx_dashboard_bookmark_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboard_bookmark_user_id ON public.dashboard_bookmark USING btree (user_id);
--
-- Name: idx_dashboard_collection_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboard_collection_id ON public.report_dashboard USING btree (collection_id);
--
-- Name: idx_dashboard_creator_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboard_creator_id ON public.report_dashboard USING btree (creator_id);
--
-- Name: idx_dashboard_favorite_dashboard_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboard_favorite_dashboard_id ON public.dashboard_favorite USING btree (dashboard_id);
--
-- Name: idx_dashboard_favorite_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboard_favorite_user_id ON public.dashboard_favorite USING btree (user_id);
--
-- Name: idx_dashboard_public_uuid; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboard_public_uuid ON public.report_dashboard USING btree (public_uuid);
--
-- Name: idx_dashboardcard_card_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboardcard_card_id ON public.report_dashboardcard USING btree (card_id);
--
-- Name: idx_dashboardcard_dashboard_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboardcard_dashboard_id ON public.report_dashboardcard USING btree (dashboard_id);
--
-- Name: idx_dashboardcard_series_card_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboardcard_series_card_id ON public.dashboardcard_series USING btree (card_id);
--
-- Name: idx_dashboardcard_series_dashboardcard_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dashboardcard_series_dashboardcard_id ON public.dashboardcard_series USING btree (dashboardcard_id);
--
-- Name: idx_data_migrations_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_data_migrations_id ON public.data_migrations USING btree (id);
--
-- Name: idx_dependency_dependent_on_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dependency_dependent_on_id ON public.dependency USING btree (dependent_on_id);
--
-- Name: idx_dependency_dependent_on_model; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dependency_dependent_on_model ON public.dependency USING btree (dependent_on_model);
--
-- Name: idx_dependency_model; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dependency_model ON public.dependency USING btree (model);
--
-- Name: idx_dependency_model_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dependency_model_id ON public.dependency USING btree (model_id);
--
-- Name: idx_dimension_field_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_dimension_field_id ON public.dimension USING btree (field_id);
--
-- Name: idx_field_parent_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_field_parent_id ON public.metabase_field USING btree (parent_id);
--
-- Name: idx_field_table_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_field_table_id ON public.metabase_field USING btree (table_id);
--
-- Name: idx_fieldvalues_field_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_fieldvalues_field_id ON public.metabase_fieldvalues USING btree (field_id);
--
-- Name: idx_gtap_table_id_group_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_gtap_table_id_group_id ON public.group_table_access_policy USING btree (table_id, group_id);
--
-- Name: idx_label_slug; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_label_slug ON public.label USING btree (slug);
--
-- Name: idx_lower_email; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_lower_email ON public.core_user USING btree (lower((email)::text));
--
-- Name: idx_metabase_table_db_id_schema; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_metabase_table_db_id_schema ON public.metabase_table USING btree (db_id, schema);
--
-- Name: idx_metabase_table_show_in_getting_started; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_metabase_table_show_in_getting_started ON public.metabase_table USING btree (show_in_getting_started);
--
-- Name: idx_metric_creator_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_metric_creator_id ON public.metric USING btree (creator_id);
--
-- Name: idx_metric_important_field_field_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_metric_important_field_field_id ON public.metric_important_field USING btree (field_id);
--
-- Name: idx_metric_important_field_metric_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_metric_important_field_metric_id ON public.metric_important_field USING btree (metric_id);
--
-- Name: idx_metric_show_in_getting_started; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_metric_show_in_getting_started ON public.metric USING btree (show_in_getting_started);
--
-- Name: idx_metric_table_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_metric_table_id ON public.metric USING btree (table_id);
--
-- Name: idx_moderation_review_item_type_item_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_moderation_review_item_type_item_id ON public.moderation_review USING btree (moderated_item_type, moderated_item_id);
--
-- Name: idx_permissions_group_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_permissions_group_id ON public.permissions USING btree (group_id);
--
-- Name: idx_permissions_group_id_object; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_permissions_group_id_object ON public.permissions USING btree (group_id, object);
--
-- Name: idx_permissions_group_membership_group_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_permissions_group_membership_group_id ON public.permissions_group_membership USING btree (group_id);
--
-- Name: idx_permissions_group_membership_group_id_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_permissions_group_membership_group_id_user_id ON public.permissions_group_membership USING btree (group_id, user_id);
--
-- Name: idx_permissions_group_membership_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_permissions_group_membership_user_id ON public.permissions_group_membership USING btree (user_id);
--
-- Name: idx_permissions_group_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_permissions_group_name ON public.permissions_group USING btree (name);
--
-- Name: idx_permissions_object; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_permissions_object ON public.permissions USING btree (object);
--
-- Name: idx_pulse_card_card_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_pulse_card_card_id ON public.pulse_card USING btree (card_id);
--
-- Name: idx_pulse_card_pulse_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_pulse_card_pulse_id ON public.pulse_card USING btree (pulse_id);
--
-- Name: idx_pulse_channel_pulse_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_pulse_channel_pulse_id ON public.pulse_channel USING btree (pulse_id);
--
-- Name: idx_pulse_channel_schedule_type; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_pulse_channel_schedule_type ON public.pulse_channel USING btree (schedule_type);
--
-- Name: idx_pulse_collection_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_pulse_collection_id ON public.pulse USING btree (collection_id);
--
-- Name: idx_pulse_creator_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_pulse_creator_id ON public.pulse USING btree (creator_id);
--
-- Name: idx_qrtz_ft_inst_job_req_rcvry; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_ft_inst_job_req_rcvry ON public.qrtz_fired_triggers USING btree (sched_name, instance_name, requests_recovery);
--
-- Name: idx_qrtz_ft_j_g; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_ft_j_g ON public.qrtz_fired_triggers USING btree (sched_name, job_name, job_group);
--
-- Name: idx_qrtz_ft_jg; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_ft_jg ON public.qrtz_fired_triggers USING btree (sched_name, job_group);
--
-- Name: idx_qrtz_ft_t_g; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_ft_t_g ON public.qrtz_fired_triggers USING btree (sched_name, trigger_name, trigger_group);
--
-- Name: idx_qrtz_ft_tg; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_ft_tg ON public.qrtz_fired_triggers USING btree (sched_name, trigger_group);
--
-- Name: idx_qrtz_ft_trig_inst_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_ft_trig_inst_name ON public.qrtz_fired_triggers USING btree (sched_name, instance_name);
--
-- Name: idx_qrtz_j_grp; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_j_grp ON public.qrtz_job_details USING btree (sched_name, job_group);
--
-- Name: idx_qrtz_j_req_recovery; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_j_req_recovery ON public.qrtz_job_details USING btree (sched_name, requests_recovery);
--
-- Name: idx_qrtz_t_c; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_c ON public.qrtz_triggers USING btree (sched_name, calendar_name);
--
-- Name: idx_qrtz_t_g; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_g ON public.qrtz_triggers USING btree (sched_name, trigger_group);
--
-- Name: idx_qrtz_t_j; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_j ON public.qrtz_triggers USING btree (sched_name, job_name, job_group);
--
-- Name: idx_qrtz_t_jg; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_jg ON public.qrtz_triggers USING btree (sched_name, job_group);
--
-- Name: idx_qrtz_t_n_g_state; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_n_g_state ON public.qrtz_triggers USING btree (sched_name, trigger_group, trigger_state);
--
-- Name: idx_qrtz_t_n_state; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_n_state ON public.qrtz_triggers USING btree (sched_name, trigger_name, trigger_group, trigger_state);
--
-- Name: idx_qrtz_t_next_fire_time; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_next_fire_time ON public.qrtz_triggers USING btree (sched_name, next_fire_time);
--
-- Name: idx_qrtz_t_nft_misfire; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_nft_misfire ON public.qrtz_triggers USING btree (sched_name, misfire_instr, next_fire_time);
--
-- Name: idx_qrtz_t_nft_st; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_nft_st ON public.qrtz_triggers USING btree (sched_name, trigger_state, next_fire_time);
--
-- Name: idx_qrtz_t_nft_st_misfire; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_nft_st_misfire ON public.qrtz_triggers USING btree (sched_name, misfire_instr, next_fire_time, trigger_state);
--
-- Name: idx_qrtz_t_nft_st_misfire_grp; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_nft_st_misfire_grp ON public.qrtz_triggers USING btree (sched_name, misfire_instr, next_fire_time, trigger_group, trigger_state);
--
-- Name: idx_qrtz_t_state; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_qrtz_t_state ON public.qrtz_triggers USING btree (sched_name, trigger_state);
--
-- Name: idx_query_cache_updated_at; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_query_cache_updated_at ON public.query_cache USING btree (updated_at);
--
-- Name: idx_query_execution_card_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_query_execution_card_id ON public.query_execution USING btree (card_id);
--
-- Name: idx_query_execution_card_id_started_at; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_query_execution_card_id_started_at ON public.query_execution USING btree (card_id, started_at);
--
-- Name: idx_query_execution_query_hash_started_at; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_query_execution_query_hash_started_at ON public.query_execution USING btree (hash, started_at);
--
-- Name: idx_query_execution_started_at; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_query_execution_started_at ON public.query_execution USING btree (started_at);
--
-- Name: idx_report_dashboard_show_in_getting_started; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_report_dashboard_show_in_getting_started ON public.report_dashboard USING btree (show_in_getting_started);
--
-- Name: idx_revision_model_model_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_revision_model_model_id ON public.revision USING btree (model, model_id);
--
-- Name: idx_segment_creator_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_segment_creator_id ON public.segment USING btree (creator_id);
--
-- Name: idx_segment_show_in_getting_started; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_segment_show_in_getting_started ON public.segment USING btree (show_in_getting_started);
--
-- Name: idx_segment_table_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_segment_table_id ON public.segment USING btree (table_id);
--
-- Name: idx_session_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_session_id ON public.login_history USING btree (session_id);
--
-- Name: idx_snippet_collection_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_snippet_collection_id ON public.native_query_snippet USING btree (collection_id);
--
-- Name: idx_snippet_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_snippet_name ON public.native_query_snippet USING btree (name);
--
-- Name: idx_table_db_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_table_db_id ON public.metabase_table USING btree (db_id);
--
-- Name: idx_task_history_db_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_task_history_db_id ON public.task_history USING btree (db_id);
--
-- Name: idx_task_history_end_time; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_task_history_end_time ON public.task_history USING btree (ended_at);
--
-- Name: idx_timeline_collection_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_timeline_collection_id ON public.timeline USING btree (collection_id);
--
-- Name: idx_timeline_event_timeline_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_timeline_event_timeline_id ON public.timeline_event USING btree (timeline_id);
--
-- Name: idx_timeline_event_timeline_id_timestamp; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_timeline_event_timeline_id_timestamp ON public.timeline_event USING btree (timeline_id, "timestamp");
--
-- Name: idx_timestamp; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_timestamp ON public.login_history USING btree ("timestamp");
--
-- Name: idx_uniq_field_table_id_parent_id_name_2col; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX idx_uniq_field_table_id_parent_id_name_2col ON public.metabase_field USING btree (table_id, name) WHERE (parent_id IS NULL);
--
-- Name: idx_uniq_table_db_id_schema_name_2col; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX idx_uniq_table_db_id_schema_name_2col ON public.metabase_table USING btree (db_id, name) WHERE (schema IS NULL);
--
-- Name: idx_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_user_id ON public.login_history USING btree (user_id);
--
-- Name: idx_user_id_device_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_user_id_device_id ON public.login_history USING btree (session_id, device_id);
--
-- Name: idx_user_id_timestamp; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_user_id_timestamp ON public.login_history USING btree (user_id, "timestamp");
--
-- Name: idx_view_log_timestamp; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_view_log_timestamp ON public.view_log USING btree (model_id);
--
-- Name: idx_view_log_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_view_log_user_id ON public.view_log USING btree (user_id);
--
-- Name: activity fk_activity_ref_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.activity
ADD CONSTRAINT fk_activity_ref_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: bookmark_ordering fk_bookmark_ordering_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.bookmark_ordering
ADD CONSTRAINT fk_bookmark_ordering_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: card_bookmark fk_card_bookmark_dashboard_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.card_bookmark
ADD CONSTRAINT fk_card_bookmark_dashboard_id FOREIGN KEY (card_id) REFERENCES public.report_card(id) ON DELETE CASCADE;
--
-- Name: card_bookmark fk_card_bookmark_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.card_bookmark
ADD CONSTRAINT fk_card_bookmark_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: report_card fk_card_collection_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_card
ADD CONSTRAINT fk_card_collection_id FOREIGN KEY (collection_id) REFERENCES public.collection(id) ON DELETE SET NULL;
--
-- Name: card_label fk_card_label_ref_card_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.card_label
ADD CONSTRAINT fk_card_label_ref_card_id FOREIGN KEY (card_id) REFERENCES public.report_card(id) ON DELETE CASCADE;
--
-- Name: card_label fk_card_label_ref_label_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.card_label
ADD CONSTRAINT fk_card_label_ref_label_id FOREIGN KEY (label_id) REFERENCES public.label(id) ON DELETE CASCADE;
--
-- Name: report_card fk_card_made_public_by_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_card
ADD CONSTRAINT fk_card_made_public_by_id FOREIGN KEY (made_public_by_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: report_card fk_card_ref_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_card
ADD CONSTRAINT fk_card_ref_user_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: report_cardfavorite fk_cardfavorite_ref_card_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_cardfavorite
ADD CONSTRAINT fk_cardfavorite_ref_card_id FOREIGN KEY (card_id) REFERENCES public.report_card(id) ON DELETE CASCADE;
--
-- Name: report_cardfavorite fk_cardfavorite_ref_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_cardfavorite
ADD CONSTRAINT fk_cardfavorite_ref_user_id FOREIGN KEY (owner_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: collection_bookmark fk_collection_bookmark_collection_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.collection_bookmark
ADD CONSTRAINT fk_collection_bookmark_collection_id FOREIGN KEY (collection_id) REFERENCES public.collection(id) ON DELETE CASCADE;
--
-- Name: collection_bookmark fk_collection_bookmark_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.collection_bookmark
ADD CONSTRAINT fk_collection_bookmark_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: collection fk_collection_personal_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.collection
ADD CONSTRAINT fk_collection_personal_owner_id FOREIGN KEY (personal_owner_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: collection_permission_graph_revision fk_collection_revision_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.collection_permission_graph_revision
ADD CONSTRAINT fk_collection_revision_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: computation_job fk_computation_job_ref_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.computation_job
ADD CONSTRAINT fk_computation_job_ref_user_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: computation_job_result fk_computation_result_ref_job_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.computation_job_result
ADD CONSTRAINT fk_computation_result_ref_job_id FOREIGN KEY (job_id) REFERENCES public.computation_job(id) ON DELETE CASCADE;
--
-- Name: dashboard_bookmark fk_dashboard_bookmark_dashboard_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboard_bookmark
ADD CONSTRAINT fk_dashboard_bookmark_dashboard_id FOREIGN KEY (dashboard_id) REFERENCES public.report_dashboard(id) ON DELETE CASCADE;
--
-- Name: dashboard_bookmark fk_dashboard_bookmark_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboard_bookmark
ADD CONSTRAINT fk_dashboard_bookmark_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: report_dashboard fk_dashboard_collection_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_dashboard
ADD CONSTRAINT fk_dashboard_collection_id FOREIGN KEY (collection_id) REFERENCES public.collection(id) ON DELETE SET NULL;
--
-- Name: dashboard_favorite fk_dashboard_favorite_dashboard_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboard_favorite
ADD CONSTRAINT fk_dashboard_favorite_dashboard_id FOREIGN KEY (dashboard_id) REFERENCES public.report_dashboard(id) ON DELETE CASCADE;
--
-- Name: dashboard_favorite fk_dashboard_favorite_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboard_favorite
ADD CONSTRAINT fk_dashboard_favorite_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: report_dashboard fk_dashboard_made_public_by_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_dashboard
ADD CONSTRAINT fk_dashboard_made_public_by_id FOREIGN KEY (made_public_by_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: report_dashboard fk_dashboard_ref_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_dashboard
ADD CONSTRAINT fk_dashboard_ref_user_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: report_dashboardcard fk_dashboardcard_ref_card_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_dashboardcard
ADD CONSTRAINT fk_dashboardcard_ref_card_id FOREIGN KEY (card_id) REFERENCES public.report_card(id) ON DELETE CASCADE;
--
-- Name: report_dashboardcard fk_dashboardcard_ref_dashboard_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_dashboardcard
ADD CONSTRAINT fk_dashboardcard_ref_dashboard_id FOREIGN KEY (dashboard_id) REFERENCES public.report_dashboard(id) ON DELETE CASCADE;
--
-- Name: dashboardcard_series fk_dashboardcard_series_ref_card_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboardcard_series
ADD CONSTRAINT fk_dashboardcard_series_ref_card_id FOREIGN KEY (card_id) REFERENCES public.report_card(id) ON DELETE CASCADE;
--
-- Name: dashboardcard_series fk_dashboardcard_series_ref_dashboardcard_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dashboardcard_series
ADD CONSTRAINT fk_dashboardcard_series_ref_dashboardcard_id FOREIGN KEY (dashboardcard_id) REFERENCES public.report_dashboardcard(id) ON DELETE CASCADE;
--
-- Name: metabase_database fk_database_creator_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_database
ADD CONSTRAINT fk_database_creator_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id) ON DELETE SET NULL;
--
-- Name: dimension fk_dimension_displayfk_ref_field_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dimension
ADD CONSTRAINT fk_dimension_displayfk_ref_field_id FOREIGN KEY (human_readable_field_id) REFERENCES public.metabase_field(id) ON DELETE CASCADE;
--
-- Name: dimension fk_dimension_ref_field_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.dimension
ADD CONSTRAINT fk_dimension_ref_field_id FOREIGN KEY (field_id) REFERENCES public.metabase_field(id) ON DELETE CASCADE;
--
-- Name: timeline_event fk_event_creator_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.timeline_event
ADD CONSTRAINT fk_event_creator_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: timeline_event fk_events_timeline_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.timeline_event
ADD CONSTRAINT fk_events_timeline_id FOREIGN KEY (timeline_id) REFERENCES public.timeline(id) ON DELETE CASCADE;
--
-- Name: metabase_field fk_field_parent_ref_field_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_field
ADD CONSTRAINT fk_field_parent_ref_field_id FOREIGN KEY (parent_id) REFERENCES public.metabase_field(id) ON DELETE CASCADE;
--
-- Name: metabase_field fk_field_ref_table_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_field
ADD CONSTRAINT fk_field_ref_table_id FOREIGN KEY (table_id) REFERENCES public.metabase_table(id) ON DELETE CASCADE;
--
-- Name: metabase_fieldvalues fk_fieldvalues_ref_field_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_fieldvalues
ADD CONSTRAINT fk_fieldvalues_ref_field_id FOREIGN KEY (field_id) REFERENCES public.metabase_field(id) ON DELETE CASCADE;
--
-- Name: application_permissions_revision fk_general_permissions_revision_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.application_permissions_revision
ADD CONSTRAINT fk_general_permissions_revision_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id);
--
-- Name: group_table_access_policy fk_gtap_card_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.group_table_access_policy
ADD CONSTRAINT fk_gtap_card_id FOREIGN KEY (card_id) REFERENCES public.report_card(id) ON DELETE CASCADE;
--
-- Name: group_table_access_policy fk_gtap_group_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.group_table_access_policy
ADD CONSTRAINT fk_gtap_group_id FOREIGN KEY (group_id) REFERENCES public.permissions_group(id) ON DELETE CASCADE;
--
-- Name: group_table_access_policy fk_gtap_table_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.group_table_access_policy
ADD CONSTRAINT fk_gtap_table_id FOREIGN KEY (table_id) REFERENCES public.metabase_table(id) ON DELETE CASCADE;
--
-- Name: login_history fk_login_history_session_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.login_history
ADD CONSTRAINT fk_login_history_session_id FOREIGN KEY (session_id) REFERENCES public.core_session(id) ON DELETE SET NULL;
--
-- Name: login_history fk_login_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.login_history
ADD CONSTRAINT fk_login_history_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: metric_important_field fk_metric_important_field_metabase_field_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metric_important_field
ADD CONSTRAINT fk_metric_important_field_metabase_field_id FOREIGN KEY (field_id) REFERENCES public.metabase_field(id) ON DELETE CASCADE;
--
-- Name: metric_important_field fk_metric_important_field_metric_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metric_important_field
ADD CONSTRAINT fk_metric_important_field_metric_id FOREIGN KEY (metric_id) REFERENCES public.metric(id) ON DELETE CASCADE;
--
-- Name: metric fk_metric_ref_creator_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metric
ADD CONSTRAINT fk_metric_ref_creator_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: metric fk_metric_ref_table_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metric
ADD CONSTRAINT fk_metric_ref_table_id FOREIGN KEY (table_id) REFERENCES public.metabase_table(id) ON DELETE CASCADE;
--
-- Name: permissions_group_membership fk_permissions_group_group_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions_group_membership
ADD CONSTRAINT fk_permissions_group_group_id FOREIGN KEY (group_id) REFERENCES public.permissions_group(id) ON DELETE CASCADE;
--
-- Name: permissions fk_permissions_group_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions
ADD CONSTRAINT fk_permissions_group_id FOREIGN KEY (group_id) REFERENCES public.permissions_group(id) ON DELETE CASCADE;
--
-- Name: permissions_group_membership fk_permissions_group_membership_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions_group_membership
ADD CONSTRAINT fk_permissions_group_membership_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: permissions_revision fk_permissions_revision_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.permissions_revision
ADD CONSTRAINT fk_permissions_revision_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: persisted_info fk_persisted_info_card_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.persisted_info
ADD CONSTRAINT fk_persisted_info_card_id FOREIGN KEY (card_id) REFERENCES public.report_card(id) ON DELETE CASCADE;
--
-- Name: persisted_info fk_persisted_info_database_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.persisted_info
ADD CONSTRAINT fk_persisted_info_database_id FOREIGN KEY (database_id) REFERENCES public.metabase_database(id) ON DELETE CASCADE;
--
-- Name: persisted_info fk_persisted_info_ref_creator_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.persisted_info
ADD CONSTRAINT fk_persisted_info_ref_creator_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id);
--
-- Name: pulse_card fk_pulse_card_ref_card_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_card
ADD CONSTRAINT fk_pulse_card_ref_card_id FOREIGN KEY (card_id) REFERENCES public.report_card(id) ON DELETE CASCADE;
--
-- Name: pulse_card fk_pulse_card_ref_pulse_card_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_card
ADD CONSTRAINT fk_pulse_card_ref_pulse_card_id FOREIGN KEY (dashboard_card_id) REFERENCES public.report_dashboardcard(id) ON DELETE CASCADE;
--
-- Name: pulse_card fk_pulse_card_ref_pulse_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_card
ADD CONSTRAINT fk_pulse_card_ref_pulse_id FOREIGN KEY (pulse_id) REFERENCES public.pulse(id) ON DELETE CASCADE;
--
-- Name: pulse_channel_recipient fk_pulse_channel_recipient_ref_pulse_channel_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_channel_recipient
ADD CONSTRAINT fk_pulse_channel_recipient_ref_pulse_channel_id FOREIGN KEY (pulse_channel_id) REFERENCES public.pulse_channel(id) ON DELETE CASCADE;
--
-- Name: pulse_channel_recipient fk_pulse_channel_recipient_ref_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_channel_recipient
ADD CONSTRAINT fk_pulse_channel_recipient_ref_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: pulse_channel fk_pulse_channel_ref_pulse_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse_channel
ADD CONSTRAINT fk_pulse_channel_ref_pulse_id FOREIGN KEY (pulse_id) REFERENCES public.pulse(id) ON DELETE CASCADE;
--
-- Name: pulse fk_pulse_collection_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse
ADD CONSTRAINT fk_pulse_collection_id FOREIGN KEY (collection_id) REFERENCES public.collection(id) ON DELETE SET NULL;
--
-- Name: pulse fk_pulse_ref_creator_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse
ADD CONSTRAINT fk_pulse_ref_creator_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: pulse fk_pulse_ref_dashboard_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.pulse
ADD CONSTRAINT fk_pulse_ref_dashboard_id FOREIGN KEY (dashboard_id) REFERENCES public.report_dashboard(id) ON DELETE CASCADE;
--
-- Name: qrtz_blob_triggers fk_qrtz_blob_triggers_triggers; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_blob_triggers
ADD CONSTRAINT fk_qrtz_blob_triggers_triggers FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);
--
-- Name: qrtz_cron_triggers fk_qrtz_cron_triggers_triggers; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_cron_triggers
ADD CONSTRAINT fk_qrtz_cron_triggers_triggers FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);
--
-- Name: qrtz_simple_triggers fk_qrtz_simple_triggers_triggers; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_simple_triggers
ADD CONSTRAINT fk_qrtz_simple_triggers_triggers FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);
--
-- Name: qrtz_simprop_triggers fk_qrtz_simprop_triggers_triggers; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_simprop_triggers
ADD CONSTRAINT fk_qrtz_simprop_triggers_triggers FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);
--
-- Name: qrtz_triggers fk_qrtz_triggers_job_details; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.qrtz_triggers
ADD CONSTRAINT fk_qrtz_triggers_job_details FOREIGN KEY (sched_name, job_name, job_group) REFERENCES public.qrtz_job_details(sched_name, job_name, job_group);
--
-- Name: report_card fk_report_card_ref_database_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_card
ADD CONSTRAINT fk_report_card_ref_database_id FOREIGN KEY (database_id) REFERENCES public.metabase_database(id) ON DELETE CASCADE;
--
-- Name: report_card fk_report_card_ref_table_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.report_card
ADD CONSTRAINT fk_report_card_ref_table_id FOREIGN KEY (table_id) REFERENCES public.metabase_table(id) ON DELETE CASCADE;
--
-- Name: revision fk_revision_ref_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.revision
ADD CONSTRAINT fk_revision_ref_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: secret fk_secret_ref_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.secret
ADD CONSTRAINT fk_secret_ref_user_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id);
--
-- Name: segment fk_segment_ref_creator_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.segment
ADD CONSTRAINT fk_segment_ref_creator_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: segment fk_segment_ref_table_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.segment
ADD CONSTRAINT fk_segment_ref_table_id FOREIGN KEY (table_id) REFERENCES public.metabase_table(id) ON DELETE CASCADE;
--
-- Name: core_session fk_session_ref_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.core_session
ADD CONSTRAINT fk_session_ref_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: native_query_snippet fk_snippet_collection_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.native_query_snippet
ADD CONSTRAINT fk_snippet_collection_id FOREIGN KEY (collection_id) REFERENCES public.collection(id) ON DELETE SET NULL;
--
-- Name: native_query_snippet fk_snippet_creator_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.native_query_snippet
ADD CONSTRAINT fk_snippet_creator_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: metabase_table fk_table_ref_database_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.metabase_table
ADD CONSTRAINT fk_table_ref_database_id FOREIGN KEY (db_id) REFERENCES public.metabase_database(id) ON DELETE CASCADE;
--
-- Name: timeline fk_timeline_collection_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.timeline
ADD CONSTRAINT fk_timeline_collection_id FOREIGN KEY (collection_id) REFERENCES public.collection(id) ON DELETE CASCADE;
--
-- Name: timeline fk_timeline_creator_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.timeline
ADD CONSTRAINT fk_timeline_creator_id FOREIGN KEY (creator_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- Name: view_log fk_view_log_ref_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.view_log
ADD CONSTRAINT fk_view_log_ref_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) ON DELETE CASCADE;
--
-- PostgreSQL database dump complete
--
--
-- Metabase initialization data
--
-- v43.00-002 and v43.00-003;
INSERT INTO public.permissions_group (name) VALUES ('All Users'), ('Administrators');
-- v43.00-006;
INSERT INTO public.permissions (group_id, object) SELECT
admin_group.id AS group_id,
'/' AS object
FROM (
SELECT id
FROM public.permissions_group
WHERE name = 'Administrators'
) admin_group;
-- v43.00-020;
INSERT INTO public.permissions (group_id, object) SELECT
all_users_group.id AS group_id,
'/collection/root/' AS object
FROM (
SELECT id
FROM public.permissions_group
WHERE name = 'All Users'
) all_users_group;
-- v43.00-047 but change general => application because we renamed in v43.00-058;
INSERT INTO public.permissions (group_id, object) SELECT
all_users_group.id AS group_id,
'/application/subscription/' AS object
FROM (
SELECT id
FROM public.permissions_group
WHERE name = 'All Users'
) all_users_group ;
-- v44.00-033;
INSERT INTO public.permissions (group_id, object) SELECT
all_users_group.id AS group_id,
'/collection/namespace/snippets/root/' AS object
FROM (
SELECT id
FROM public.permissions_group
WHERE name = 'All Users'
) all_users_group;