A platform for community discussion. Free, open, simple.
-- 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;