266 lines
8.1 KiB
SQL
266 lines
8.1 KiB
SQL
|
|
--
|
|
-- Name: ir_category; Type: TABLE; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS public.ir_category (
|
|
id character varying(26) NOT NULL,
|
|
name character varying(512) NOT NULL,
|
|
teamid character varying(26) NOT NULL,
|
|
userid character varying(26) NOT NULL,
|
|
collapsed boolean DEFAULT false,
|
|
createat bigint NOT NULL,
|
|
updateat bigint DEFAULT 0 NOT NULL,
|
|
deleteat bigint DEFAULT 0 NOT NULL
|
|
);
|
|
ALTER TABLE public.ir_category OWNER TO mattermost;
|
|
|
|
|
|
--
|
|
-- Name: ir_category_item; Type: TABLE; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
|
|
CREATE TABLE IF NOT EXISTS public.ir_category_item (
|
|
type character varying(1) NOT NULL,
|
|
categoryid character varying(26) NOT NULL,
|
|
itemid character varying(26) NOT NULL
|
|
);
|
|
ALTER TABLE public.ir_category_item OWNER TO mattermost;
|
|
|
|
|
|
--
|
|
-- Name: ir_channelaction; Type: TABLE; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS public.ir_channelaction (
|
|
id character varying(26) NOT NULL,
|
|
channelid character varying(26),
|
|
enabled boolean DEFAULT false,
|
|
deleteat bigint DEFAULT '0'::bigint NOT NULL,
|
|
actiontype character varying(65536) NOT NULL,
|
|
triggertype character varying(65536) NOT NULL,
|
|
payload json NOT NULL
|
|
);
|
|
|
|
|
|
ALTER TABLE public.ir_channelaction OWNER TO mattermost;
|
|
|
|
--
|
|
-- Name: ir_incident; Type: TABLE; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
CREATE TABLE public.ir_incident (
|
|
id character varying(26) NOT NULL,
|
|
name character varying(1024) NOT NULL,
|
|
description character varying(4096) NOT NULL,
|
|
isactive boolean NOT NULL,
|
|
commanderuserid character varying(26) NOT NULL,
|
|
teamid character varying(26) NOT NULL,
|
|
channelid character varying(26) NOT NULL,
|
|
createat bigint NOT NULL,
|
|
endat bigint DEFAULT '0'::bigint NOT NULL,
|
|
deleteat bigint DEFAULT '0'::bigint NOT NULL,
|
|
activestage bigint NOT NULL,
|
|
postid character varying(26) DEFAULT ''::character varying NOT NULL,
|
|
playbookid character varying(26) DEFAULT ''::character varying NOT NULL,
|
|
checklistsjson json NOT NULL,
|
|
activestagetitle character varying(1024) DEFAULT ''::character varying,
|
|
reminderpostid character varying(26),
|
|
broadcastchannelid character varying(26) DEFAULT ''::character varying,
|
|
previousreminder bigint DEFAULT '0'::bigint NOT NULL,
|
|
remindermessagetemplate character varying(65536) DEFAULT ''::text,
|
|
currentstatus character varying(1024) DEFAULT 'Active'::character varying NOT NULL,
|
|
reporteruserid character varying(26) DEFAULT ''::character varying NOT NULL,
|
|
concatenatedinviteduserids character varying(65536) DEFAULT ''::text,
|
|
defaultcommanderid character varying(26) DEFAULT ''::character varying,
|
|
announcementchannelid character varying(26) DEFAULT ''::character varying,
|
|
concatenatedwebhookoncreationurls character varying(65536) DEFAULT ''::text,
|
|
concatenatedinvitedgroupids character varying(65536) DEFAULT ''::text,
|
|
retrospective character varying(65536) DEFAULT ''::text,
|
|
messageonjoin character varying(65536) DEFAULT ''::text,
|
|
retrospectivepublishedat bigint DEFAULT '0'::bigint NOT NULL,
|
|
retrospectivereminderintervalseconds bigint DEFAULT '0'::bigint NOT NULL,
|
|
retrospectivewascanceled boolean DEFAULT false,
|
|
concatenatedwebhookonstatusupdateurls character varying(65536) DEFAULT ''::text,
|
|
laststatusupdateat bigint DEFAULT '0'::bigint,
|
|
exportchannelonfinishedenabled boolean DEFAULT false NOT NULL,
|
|
categorizechannelenabled boolean DEFAULT false,
|
|
categoryname character varying(65536) DEFAULT ''::text,
|
|
concatenatedbroadcastchannelids character varying(65536) DEFAULT ''::text,
|
|
channelidtorootid character varying(65536) DEFAULT ''::text,
|
|
remindertimerdefaultseconds bigint DEFAULT '0'::bigint NOT NULL,
|
|
statusupdateenabled boolean DEFAULT true,
|
|
retrospectiveenabled boolean DEFAULT true
|
|
);
|
|
|
|
|
|
ALTER TABLE public.ir_incident OWNER TO mattermost;
|
|
|
|
|
|
--
|
|
-- Name: focalboard_blocks; Type: TABLE; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS public.focalboard_blocks (
|
|
id character varying(36) NOT NULL,
|
|
insert_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
parent_id character varying(36),
|
|
schema bigint,
|
|
type text,
|
|
title text,
|
|
fields json,
|
|
create_at bigint,
|
|
update_at bigint,
|
|
delete_at bigint,
|
|
root_id character varying(36),
|
|
modified_by character varying(36) NOT NULL,
|
|
workspace_id character varying(36) NOT NULL,
|
|
created_by character varying(36) NOT NULL
|
|
);
|
|
|
|
ALTER TABLE public.focalboard_blocks OWNER TO mattermost;
|
|
|
|
|
|
--
|
|
-- Name: focalboard_blocks_history; Type: TABLE; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS public.focalboard_blocks_history (
|
|
id character varying(36) NOT NULL,
|
|
insert_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
parent_id character varying(36),
|
|
schema bigint,
|
|
type text,
|
|
title text,
|
|
fields json,
|
|
create_at bigint,
|
|
update_at bigint,
|
|
delete_at bigint,
|
|
root_id character varying(36),
|
|
modified_by character varying(36),
|
|
workspace_id character varying(36),
|
|
created_by character varying(36)
|
|
);
|
|
|
|
ALTER TABLE public.focalboard_blocks_history OWNER TO mattermost;
|
|
|
|
|
|
--
|
|
-- Name: focalboard_sessions; Type: TABLE; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS public.focalboard_sessions (
|
|
id character varying(100) NOT NULL,
|
|
token character varying(100),
|
|
user_id character varying(100),
|
|
props json,
|
|
create_at bigint,
|
|
update_at bigint,
|
|
auth_service character varying(20)
|
|
);
|
|
|
|
|
|
ALTER TABLE public.focalboard_sessions OWNER TO mattermost;
|
|
|
|
|
|
--
|
|
-- Name: focalboard_users; Type: TABLE; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS public.focalboard_users (
|
|
id character varying(100) NOT NULL,
|
|
username character varying(100),
|
|
email character varying(255),
|
|
password character varying(100),
|
|
mfa_secret character varying(100),
|
|
auth_service character varying(20),
|
|
auth_data character varying(255),
|
|
props json,
|
|
create_at bigint,
|
|
update_at bigint,
|
|
delete_at bigint
|
|
);
|
|
|
|
ALTER TABLE public.focalboard_users OWNER TO mattermost;
|
|
|
|
|
|
--
|
|
-- Name: focalboard_blocks idx_25969_primary; Type: CONSTRAINT; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
ALTER TABLE ONLY public.focalboard_blocks
|
|
ADD CONSTRAINT idx_25969_primary PRIMARY KEY (workspace_id, id);
|
|
|
|
|
|
--
|
|
-- Name: focalboard_blocks_history idx_25975_primary; Type: CONSTRAINT; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
ALTER TABLE ONLY public.focalboard_blocks_history
|
|
ADD CONSTRAINT idx_25975_primary PRIMARY KEY (id, insert_at);
|
|
|
|
|
|
--
|
|
-- Name: focalboard_sessions idx_25987_primary; Type: CONSTRAINT; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
ALTER TABLE ONLY public.focalboard_sessions
|
|
ADD CONSTRAINT idx_25987_primary PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- Name: focalboard_users idx_26003_primary; Type: CONSTRAINT; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
ALTER TABLE ONLY public.focalboard_users
|
|
ADD CONSTRAINT idx_26003_primary PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- Name: ir_channelaction idx_26042_primary; Type: CONSTRAINT; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
ALTER TABLE ONLY public.ir_channelaction
|
|
ADD CONSTRAINT idx_26042_primary PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- Name: ir_incident idx_26049_primary; Type: CONSTRAINT; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
ALTER TABLE ONLY public.ir_incident
|
|
ADD CONSTRAINT idx_26049_primary PRIMARY KEY (id);
|
|
|
|
|
|
|
|
--
|
|
-- Name: ir_category_item ir_category_item_pkey; Type: CONSTRAINT; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
ALTER TABLE ONLY public.ir_category_item
|
|
ADD CONSTRAINT ir_category_item_pkey PRIMARY KEY (categoryid, itemid, type);
|
|
|
|
|
|
--
|
|
-- Name: ir_category ir_category_pkey; Type: CONSTRAINT; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
ALTER TABLE ONLY public.ir_category
|
|
ADD CONSTRAINT ir_category_pkey PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- Name: ir_category_item_categoryid; Type: INDEX; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
CREATE INDEX IF NOT EXISTS ir_category_item_categoryid ON public.ir_category_item USING btree (categoryid);
|
|
|
|
|
|
--
|
|
-- Name: ir_category_teamid_userid; Type: INDEX; Schema: public; Owner: mattermost
|
|
--
|
|
|
|
CREATE INDEX IF NOT EXISTS ir_category_teamid_userid ON public.ir_category USING btree (teamid, userid);
|
|
|