debian-mirror-gitlab/spec/fixtures/gitlab/database/structure_example_cleaned.sql

Ignoring revisions in .git-blame-ignore-revs. Click here to bypass and see the normal blame view.

40 lines
1.1 KiB
MySQL
Raw Permalink Normal View History

2020-11-24 15:15:51 +05:30
CREATE EXTENSION IF NOT EXISTS pg_trgm;
2020-04-22 19:07:51 +05:30
2020-11-24 15:15:51 +05:30
CREATE TABLE abuse_reports (
2020-04-22 19:07:51 +05:30
id integer NOT NULL,
reporter_id integer,
user_id integer,
message text,
created_at timestamp without time zone,
updated_at timestamp without time zone,
message_html text,
cached_markdown_version integer
);
2020-11-24 15:15:51 +05:30
CREATE SEQUENCE abuse_reports_id_seq
2020-04-22 19:07:51 +05:30
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
2020-11-24 15:15:51 +05:30
ALTER TABLE ONLY abuse_reports ALTER COLUMN id SET DEFAULT nextval('abuse_reports_id_seq'::regclass);
2020-04-22 19:07:51 +05:30
2020-11-24 15:15:51 +05:30
ALTER TABLE ONLY abuse_reports
2020-04-22 19:07:51 +05:30
ADD CONSTRAINT abuse_reports_pkey PRIMARY KEY (id);
2021-09-30 23:02:18 +05:30
CREATE INDEX index_abuse_reports_on_user_id ON abuse_reports USING btree (user_id);
2023-03-04 22:38:38 +05:30
CREATE FUNCTION gitlab_schema_prevent_write() RETURNS trigger
LANGUAGE plpgsql
AS $$
BEGIN
IF COALESCE(NULLIF(current_setting(CONCAT('lock_writes.', TG_TABLE_NAME), true), ''), 'true') THEN
RAISE EXCEPTION 'Table: "%" is write protected within this Gitlab database.', TG_TABLE_NAME
USING ERRCODE = 'modifying_sql_data_not_permitted',
HINT = 'Make sure you are using the right database connection';
END IF;
RETURN NEW;
END
$$;