Skip to content

A platform for community discussion. Free, open, simple.

20.4 KB
Raw Blame
-- This file is auto-generated from the IntermediateDB schema. To make changes,
-- update the configuration files in "migrations/tooling/config/schema/" and then run
-- `migrations/bin/disco schema generate` to regenerate this file.

CREATE TABLE badge_groupings
(
    original_id NUMERIC  NOT NULL PRIMARY KEY,
    created_at  DATETIME,
    description TEXT,
    name        TEXT     NOT NULL,
    position    INTEGER  NOT NULL
);


CREATE TABLE badges
(
    original_id         NUMERIC  NOT NULL PRIMARY KEY,
    allow_title         BOOLEAN,
    auto_revoke         BOOLEAN,
    badge_grouping_id   NUMERIC,
    badge_type_id       NUMERIC  NOT NULL,
    created_at          DATETIME,
    description         TEXT,
    enabled             BOOLEAN,
    existing_id         NUMERIC,
    icon                TEXT,
    image_upload_id     TEXT,
    listable            BOOLEAN,
    long_description    TEXT,
    multiple_grant      BOOLEAN,
    name                TEXT     NOT NULL,
    "query"             TEXT,
    show_in_post_header BOOLEAN,
    show_posts          BOOLEAN,
    target_posts        BOOLEAN,
    "trigger"           INTEGER
);


CREATE TABLE categories
(
    original_id                               NUMERIC  NOT NULL PRIMARY KEY,
    about_topic_title                         TEXT,
    all_topics_wiki                           BOOLEAN,
    allow_badges                              BOOLEAN,
    allow_global_tags                         BOOLEAN,
    allow_unlimited_owner_edits_on_first_post BOOLEAN,
    auto_close_based_on_last_post             BOOLEAN,
    auto_close_hours                          FLOAT,
    color                                     TEXT,
    created_at                                DATETIME,
    default_list_filter                       TEXT,
    default_slow_mode_seconds                 INTEGER,
    default_top_period                        TEXT,
    default_view                              TEXT,
    description                               TEXT,
    email_in                                  TEXT,
    email_in_allow_strangers                  BOOLEAN,
    emoji                                     TEXT,
    existing_id                               NUMERIC,
    icon                                      TEXT,
    locale                                    TEXT,
    mailinglist_mirror                        BOOLEAN,
    minimum_required_tags                     INTEGER,
    name                                      TEXT     NOT NULL,
    navigate_to_first_post_after_read         BOOLEAN,
    num_featured_topics                       INTEGER,
    parent_category_id                        NUMERIC,
    position                                  INTEGER,
    read_only_banner                          TEXT,
    read_restricted                           BOOLEAN,
    search_priority                           INTEGER,
    show_subcategory_list                     BOOLEAN,
    slug                                      TEXT     NOT NULL,
    sort_ascending                            BOOLEAN,
    sort_order                                TEXT,
    style_type                                INTEGER,
    subcategory_list_style                    TEXT,
    text_color                                TEXT,
    topic_featured_link_allowed               BOOLEAN,
    topic_id                                  NUMERIC,
    topic_template                            TEXT,
    topic_title_placeholder                   TEXT,
    uploaded_background_dark_id               TEXT,
    uploaded_background_id                    TEXT,
    uploaded_logo_dark_id                     TEXT,
    uploaded_logo_id                          TEXT,
    user_id                                   NUMERIC  NOT NULL
);


CREATE TABLE category_custom_fields
(
    category_id NUMERIC NOT NULL,
    name        TEXT    NOT NULL,
    value       TEXT,
    PRIMARY KEY (category_id, name)
);


CREATE TABLE category_moderation_groups
(
    category_id NUMERIC  NOT NULL,
    group_id    NUMERIC  NOT NULL,
    created_at  DATETIME,
    PRIMARY KEY (category_id, group_id)
);


CREATE TABLE category_users
(
    category_id        NUMERIC  NOT NULL,
    user_id            NUMERIC  NOT NULL,
    last_seen_at       DATETIME,
    notification_level INTEGER  NOT NULL,
    PRIMARY KEY (category_id, user_id)
);


CREATE TABLE custom_emojis
(
    original_id NUMERIC  NOT NULL PRIMARY KEY,
    created_at  DATETIME,
    "group"     TEXT,
    name        TEXT     NOT NULL,
    upload_id   TEXT     NOT NULL,
    user_id     NUMERIC
);


CREATE TABLE embed_emojis
(
    name        TEXT         NOT NULL,
    owner_id    NUMERIC      NOT NULL,
    owner_type  ENUM_INTEGER NOT NULL,
    placeholder TEXT         NOT NULL
);

CREATE INDEX idx_embed_emojis_owner_type_owner_id ON embed_emojis (owner_type, owner_id);

CREATE TABLE embed_events
(
    event_id    NUMERIC,
    owner_id    NUMERIC      NOT NULL,
    owner_type  ENUM_INTEGER NOT NULL,
    placeholder TEXT         NOT NULL
);

CREATE INDEX idx_embed_events_owner_type_owner_id ON embed_events (owner_type, owner_id);

CREATE TABLE embed_hashtags
(
    hashtag_type      ENUM_INTEGER,
    name              TEXT         NOT NULL,
    original_markdown TEXT,
    owner_id          NUMERIC      NOT NULL,
    owner_type        ENUM_INTEGER NOT NULL,
    placeholder       TEXT         NOT NULL,
    target_id         NUMERIC
);

CREATE INDEX idx_embed_hashtags_owner_type_owner_id ON embed_hashtags (owner_type, owner_id);

CREATE TABLE embed_links
(
    label_url_offset   INTEGER,
    original_markdown  TEXT,
    owner_id           NUMERIC      NOT NULL,
    owner_type         ENUM_INTEGER NOT NULL,
    placeholder        TEXT         NOT NULL,
    target_id          NUMERIC,
    target_name        TEXT,
    target_post_number INTEGER,
    target_suffix      TEXT,
    target_tag_path    TEXT,
    target_topic_id    NUMERIC,
    target_type        ENUM_INTEGER,
    text               TEXT,
    url                TEXT,
    url_offset         INTEGER
);

CREATE INDEX idx_embed_links_owner_type_owner_id ON embed_links (owner_type, owner_id);

CREATE TABLE embed_mentions
(
    mention_type      ENUM_INTEGER,
    name              TEXT,
    original_markdown TEXT,
    owner_id          NUMERIC      NOT NULL,
    owner_type        ENUM_INTEGER NOT NULL,
    placeholder       TEXT         NOT NULL,
    target_id         NUMERIC
);

CREATE INDEX idx_embed_mentions_owner_type_owner_id ON embed_mentions (owner_type, owner_id);

CREATE TABLE embed_polls
(
    owner_id    NUMERIC      NOT NULL,
    owner_type  ENUM_INTEGER NOT NULL,
    placeholder TEXT         NOT NULL,
    poll_id     NUMERIC
);

CREATE INDEX idx_embed_polls_owner_type_owner_id ON embed_polls (owner_type, owner_id);

CREATE TABLE embed_quotes
(
    original_markdown  TEXT,
    owner_id           NUMERIC      NOT NULL,
    owner_type         ENUM_INTEGER NOT NULL,
    placeholder        TEXT         NOT NULL,
    quoted_name        TEXT,
    quoted_post_id     NUMERIC,
    quoted_post_number INTEGER,
    quoted_topic_id    NUMERIC,
    quoted_user_id     NUMERIC,
    quoted_username    TEXT
);

CREATE INDEX idx_embed_quotes_owner_type_owner_id ON embed_quotes (owner_type, owner_id);

CREATE TABLE embed_uploads
(
    external_host     TEXT,
    original_markdown TEXT,
    owner_id          NUMERIC      NOT NULL,
    owner_type        ENUM_INTEGER NOT NULL,
    placeholder       TEXT         NOT NULL,
    upload_id         TEXT
);

CREATE INDEX idx_embed_uploads_owner_type_owner_id ON embed_uploads (owner_type, owner_id);
CREATE INDEX idx_embed_uploads_upload_id ON embed_uploads (upload_id) WHERE upload_id IS NOT NULL;

CREATE TABLE group_users
(
    group_id           NUMERIC  NOT NULL,
    user_id            NUMERIC  NOT NULL,
    created_at         DATETIME,
    notification_level INTEGER,
    owner              BOOLEAN,
    PRIMARY KEY (group_id, user_id)
);


CREATE TABLE "groups"
(
    original_id                        NUMERIC  NOT NULL PRIMARY KEY,
    allow_membership_requests          BOOLEAN,
    allow_unknown_sender_topic_replies BOOLEAN,
    automatic_membership_email_domains TEXT,
    bio_raw                            TEXT,
    created_at                         DATETIME,
    default_notification_level         INTEGER,
    existing_id                        NUMERIC,
    flair_bg_color                     TEXT,
    flair_color                        TEXT,
    flair_icon                         TEXT,
    flair_upload_id                    TEXT,
    full_name                          TEXT,
    grant_trust_level                  INTEGER,
    incoming_email                     TEXT,
    members_visibility_level           INTEGER,
    membership_request_template        TEXT,
    mentionable_level                  INTEGER,
    messageable_level                  INTEGER,
    name                               TEXT     NOT NULL,
    primary_group                      BOOLEAN,
    public_admission                   BOOLEAN,
    public_exit                        BOOLEAN,
    publish_read_state                 BOOLEAN,
    title                              TEXT,
    visibility_level                   INTEGER
);


CREATE TABLE log_entries
(
    created_at DATETIME  NOT NULL,
    details    JSON_TEXT,
    exception  TEXT,
    message    TEXT      NOT NULL,
    type       ENUM_TEXT NOT NULL
);


CREATE TABLE muted_users
(
    user_id       NUMERIC  NOT NULL,
    muted_user_id NUMERIC  NOT NULL,
    created_at    DATETIME,
    PRIMARY KEY (user_id, muted_user_id)
);


CREATE TABLE permalink_normalizations
(
    normalization TEXT NOT NULL PRIMARY KEY
);


CREATE TABLE posts
(
    original_id      NUMERIC      NOT NULL PRIMARY KEY,
    action_code      TEXT,
    created_at       DATETIME,
    deleted_at       DATETIME,
    deleted_by_id    NUMERIC,
    hidden           BOOLEAN,
    hidden_at        DATETIME,
    hidden_reason_id ENUM_INTEGER,
    last_editor_id   NUMERIC,
    like_count       INTEGER,
    locale           TEXT,
    locked_by_id     NUMERIC,
    original_raw     TEXT,
    post_number      INTEGER,
    post_type        ENUM_INTEGER,
    raw              TEXT         NOT NULL,
    reply_to_post_id INTEGER,
    reply_to_user_id NUMERIC,
    sort_order       INTEGER,
    topic_id         NUMERIC      NOT NULL,
    user_deleted     BOOLEAN,
    user_id          NUMERIC,
    wiki             BOOLEAN
);

CREATE INDEX idx_posts_topic_id_post_number ON posts (topic_id, post_number);

CREATE TABLE site_settings
(
    name            TEXT         NOT NULL PRIMARY KEY,
    import_mode     ENUM_INTEGER NOT NULL,
    last_changed_at DATETIME,
    value           TEXT
);


CREATE TABLE tag_group_memberships
(
    tag_group_id NUMERIC  NOT NULL,
    tag_id       NUMERIC  NOT NULL,
    created_at   DATETIME,
    PRIMARY KEY (tag_group_id, tag_id)
);


CREATE TABLE tag_group_permissions
(
    tag_group_id    NUMERIC  NOT NULL,
    group_id        NUMERIC  NOT NULL,
    permission_type INTEGER  NOT NULL,
    created_at      DATETIME,
    PRIMARY KEY (tag_group_id, group_id, permission_type)
);


CREATE TABLE tag_groups
(
    original_id   NUMERIC  NOT NULL PRIMARY KEY,
    created_at    DATETIME,
    name          TEXT     NOT NULL,
    one_per_topic BOOLEAN,
    parent_tag_id NUMERIC
);


CREATE TABLE tag_synonyms
(
    synonym_tag_id NUMERIC NOT NULL PRIMARY KEY,
    target_tag_id  NUMERIC NOT NULL
);


CREATE TABLE tag_users
(
    tag_id             NUMERIC  NOT NULL,
    user_id            NUMERIC  NOT NULL,
    created_at         DATETIME,
    notification_level INTEGER  NOT NULL,
    PRIMARY KEY (tag_id, user_id)
);


CREATE TABLE tags
(
    original_id NUMERIC  NOT NULL PRIMARY KEY,
    created_at  DATETIME,
    description TEXT,
    locale      TEXT,
    name        TEXT     NOT NULL,
    slug        TEXT     NOT NULL
);


CREATE TABLE topic_allowed_groups
(
    topic_id NUMERIC NOT NULL,
    group_id NUMERIC NOT NULL,
    PRIMARY KEY (topic_id, group_id)
);


CREATE TABLE topic_allowed_users
(
    topic_id   NUMERIC  NOT NULL,
    user_id    NUMERIC  NOT NULL,
    created_at DATETIME,
    PRIMARY KEY (topic_id, user_id)
);


CREATE TABLE topic_tags
(
    topic_id   NUMERIC  NOT NULL,
    tag_id     NUMERIC  NOT NULL,
    created_at DATETIME,
    PRIMARY KEY (topic_id, tag_id)
);


CREATE TABLE topic_users
(
    topic_id                 NUMERIC  NOT NULL,
    user_id                  NUMERIC  NOT NULL,
    cleared_pinned_at        DATETIME,
    first_visited_at         DATETIME,
    last_emailed_post_number INTEGER,
    last_posted_at           DATETIME,
    last_read_post_number    INTEGER,
    last_visited_at          DATETIME,
    notification_level       INTEGER,
    notifications_changed_at DATETIME,
    notifications_reason_id  NUMERIC,
    total_msecs_viewed       INTEGER,
    PRIMARY KEY (topic_id, user_id)
);


CREATE TABLE topics
(
    original_id          NUMERIC  NOT NULL PRIMARY KEY,
    archetype            TEXT,
    archived             BOOLEAN,
    bannered_until       DATETIME,
    category_id          NUMERIC,
    closed               BOOLEAN,
    created_at           DATETIME,
    deleted_at           DATETIME,
    deleted_by_id        NUMERIC,
    external_id          NUMERIC,
    featured_link        TEXT,
    locale               TEXT,
    og_image_upload_id   TEXT,
    pinned_at            DATETIME,
    pinned_globally      BOOLEAN,
    pinned_until         DATETIME,
    slow_mode_seconds    INTEGER,
    slug                 TEXT,
    subtype              TEXT,
    title                TEXT     NOT NULL,
    user_id              NUMERIC,
    views                INTEGER,
    visibility_reason_id NUMERIC,
    visible              BOOLEAN
);

CREATE INDEX idx_topics_archetype ON topics (archetype);
CREATE INDEX idx_topics_slug ON topics (slug);

CREATE TABLE upload_sources
(
    id          TEXT         NOT NULL PRIMARY KEY,
    data        BLOB,
    description TEXT,
    filename    TEXT         NOT NULL,
    origin      TEXT,
    path        TEXT,
    type        ENUM_INTEGER,
    url         TEXT,
    user_id     NUMERIC
);


CREATE TABLE user_associated_accounts
(
    user_id       NUMERIC   NOT NULL,
    provider_name TEXT      NOT NULL,
    created_at    DATETIME,
    info          JSON_TEXT,
    last_used     DATETIME,
    provider_uid  TEXT      NOT NULL,
    PRIMARY KEY (user_id, provider_name)
);


CREATE TABLE user_custom_fields
(
    user_id    NUMERIC  NOT NULL,
    name       TEXT     NOT NULL,
    value      TEXT     NOT NULL,
    created_at DATETIME,
    PRIMARY KEY (user_id, name, value)
);


CREATE TABLE user_emails
(
    user_id    NUMERIC  NOT NULL,
    email      TEXT     NOT NULL,
    created_at DATETIME,
    "primary"  BOOLEAN,
    PRIMARY KEY (user_id, email)
);


CREATE TABLE user_field_options
(
    user_field_id NUMERIC  NOT NULL,
    value         TEXT     NOT NULL,
    created_at    DATETIME,
    PRIMARY KEY (user_field_id, value)
);


CREATE TABLE user_field_values
(
    user_id              NUMERIC  NOT NULL,
    field_id             NUMERIC  NOT NULL,
    value                TEXT     NOT NULL,
    created_at           DATETIME,
    is_multiselect_field BOOLEAN,
    PRIMARY KEY (user_id, field_id, value)
);

CREATE UNIQUE INDEX idx_unique_user_field_values_multiselect ON user_field_values (user_id, field_id, value) WHERE is_multiselect_field = TRUE;
CREATE UNIQUE INDEX idx_unique_user_field_values_not_multiselect ON user_field_values (user_id, field_id) WHERE is_multiselect_field = FALSE;

CREATE TABLE user_fields
(
    original_id       NUMERIC  NOT NULL PRIMARY KEY,
    created_at        DATETIME,
    description       TEXT     NOT NULL,
    editable          BOOLEAN,
    external_name     TEXT,
    external_type     TEXT,
    field_type_enum   INTEGER  NOT NULL,
    name              TEXT     NOT NULL,
    position          INTEGER,
    requirement       INTEGER,
    searchable        BOOLEAN,
    show_on_profile   BOOLEAN,
    show_on_signup    BOOLEAN,
    show_on_user_card BOOLEAN
);


CREATE TABLE user_options
(
    user_id                                        NUMERIC  NOT NULL PRIMARY KEY,
    allow_private_messages                         BOOLEAN,
    auto_track_topics_after_msecs                  INTEGER,
    automatically_translate                        BOOLEAN,
    automatically_unpin_topics                     BOOLEAN,
    bookmark_auto_delete_preference                INTEGER,
    color_scheme_id                                NUMERIC,
    composition_mode                               INTEGER,
    dark_scheme_id                                 NUMERIC,
    default_calendar                               INTEGER,
    digest_after_minutes                           INTEGER,
    dynamic_favicon                                BOOLEAN,
    email_digests                                  BOOLEAN,
    email_in_reply_to                              BOOLEAN,
    email_level                                    INTEGER,
    email_messages_level                           INTEGER,
    email_previous_replies                         INTEGER,
    enable_allowed_pm_users                        BOOLEAN,
    enable_defer                                   BOOLEAN,
    enable_markdown_monospace_font                 BOOLEAN,
    enable_quoting                                 BOOLEAN,
    enable_smart_lists                             BOOLEAN,
    enable_upcoming_change_available_notifications BOOLEAN,
    external_links_in_new_tab                      BOOLEAN,
    hidden_composer_toolbar_buttons                TEXT,
    hide_presence                                  BOOLEAN,
    hide_profile                                   BOOLEAN,
    hide_profile_and_presence                      BOOLEAN,
    homepage_id                                    NUMERIC,
    include_tl0_in_digests                         BOOLEAN,
    interface_color_mode                           INTEGER,
    last_redirected_to_top_at                      DATETIME,
    like_notification_frequency                    INTEGER,
    mailing_list_mode                              BOOLEAN,
    mailing_list_mode_frequency                    INTEGER,
    new_topic_duration_minutes                     INTEGER,
    notification_level_when_replying               INTEGER,
    notify_on_linked_posts                         BOOLEAN,
    oldest_search_log_date                         DATETIME,
    push_notification_level                        INTEGER,
    seen_popups                                    INTEGER,
    send_shortcut                                  INTEGER,
    show_original_content                          BOOLEAN,
    sidebar_link_to_filtered_list                  BOOLEAN,
    sidebar_show_count_of_new_items                BOOLEAN,
    skip_new_user_tips                             BOOLEAN,
    text_size_key                                  INTEGER,
    text_size_seq                                  INTEGER,
    theme_ids                                      INTEGER,
    theme_key_seq                                  INTEGER,
    timezone                                       TEXT,
    title_count_mode_key                           INTEGER,
    understood_languages                           TEXT,
    watched_precedence_over_muted                  BOOLEAN
);


CREATE TABLE user_suspensions
(
    user_id         NUMERIC  NOT NULL,
    suspended_at    DATETIME NOT NULL,
    reason          TEXT,
    suspended_by_id NUMERIC,
    suspended_till  DATETIME,
    PRIMARY KEY (user_id, suspended_at)
);


CREATE TABLE users
(
    original_id               NUMERIC   NOT NULL PRIMARY KEY,
    active                    BOOLEAN,
    admin                     BOOLEAN,
    approved                  BOOLEAN,
    approved_at               DATETIME,
    approved_by_id            NUMERIC,
    avatar_type               INTEGER,
    created_at                DATETIME  NOT NULL,
    date_of_birth             DATE,
    first_seen_at             DATETIME,
    flair_group_id            NUMERIC,
    group_locked_trust_level  INTEGER,
    ip_address                INET_TEXT,
    last_seen_at              DATETIME,
    locale                    TEXT,
    manual_locked_trust_level INTEGER,
    moderator                 BOOLEAN,
    name                      TEXT,
    original_username         TEXT,
    primary_group_id          NUMERIC,
    registration_ip_address   INET_TEXT,
    silenced_till             DATETIME,
    staged                    BOOLEAN,
    title                     TEXT,
    trust_level               INTEGER   NOT NULL,
    uploaded_avatar_id        TEXT,
    username                  TEXT      NOT NULL,
    views                     INTEGER
);

CREATE INDEX idx_users_uploaded_avatar_id ON users (uploaded_avatar_id) WHERE uploaded_avatar_id IS NOT NULL;