Skip to content

Commit 5d43d6a

Browse files
s3lases3lase
committed
DEV: Add intermediate DB tables from converter V1
1 parent 55d59c5 commit 5d43d6a

33 files changed

+2420
-31
lines changed

‎migrations/config/intermediate_db.yml

Lines changed: 255 additions & 31 deletions
Original file line numberDiff line numberDiff line change
@@ -7,14 +7,267 @@ output:
77

88
schema:
99
tables:
10+
badges:
11+
columns:
12+
add:
13+
- name: "existing_id"
14+
datatype: "text"
15+
exclude:
16+
- "grant_count"
17+
categories:
18+
columns:
19+
add:
20+
- name: "about_topic_title"
21+
datatype: text
22+
- name: "existing_id"
23+
datatype: text
24+
exclude:
25+
- "contains_messages"
26+
- "latest_post_id"
27+
- "latest_topic_id"
28+
- "name_lower"
29+
- "post_count"
30+
- "posts_day"
31+
- "posts_month"
32+
- "posts_week"
33+
- "posts_year"
34+
- "topic_count"
35+
- "topics_day"
36+
- "topics_month"
37+
- "topics_week"
38+
- "topics_year"
39+
category_custom_fields:
40+
primary_key_column_names: [ "category_id", "name" ]
41+
columns:
42+
exclude:
43+
- "created_at"
44+
- "id"
45+
category_users:
46+
columns:
47+
exclude:
48+
- "id"
49+
chat_channels:
50+
columns:
51+
add:
52+
- name: "is_group"
53+
datatype: boolean
54+
exclude:
55+
- "last_message_id"
56+
- "user_count_stale"
57+
chat_mentions: {}
58+
chat_message_reactions:
59+
primary_key_column_names: [ "chat_message_id", "user_id", "emoji" ]
60+
columns:
61+
exclude:
62+
- "id"
63+
chat_messages:
64+
columns:
65+
add:
66+
- name: "original_message"
67+
datatype: text
68+
exclude:
69+
- "cooked_version"
70+
- "cooked"
71+
chat_threads:
72+
primary_key_column_names: [original_id, channel_id, original_message_id, original_message_user_id ]
73+
group_users:
74+
primary_key_column_names: [ "group_id", "user_id" ]
75+
groups:
76+
columns:
77+
include:
78+
- "allow_membership_requests"
79+
- "allow_unknown_sender_topic_replies"
80+
- "automatic"
81+
- "automatic_membership_email_domains"
82+
- "bio_raw"
83+
- "created_at"
84+
- "default_notification_level"
85+
- "flair_bg_color"
86+
- "flair_color"
87+
- "flair_icon"
88+
- "flair_upload_id"
89+
- "full_name"
90+
- "grant_trust_level"
91+
- "id"
92+
- "members_visibility_level"
93+
- "membership_request_template"
94+
- "mentionable_level"
95+
- "messageable_level"
96+
- "name"
97+
- "primary_group"
98+
- "public_admission"
99+
- "public_exit"
100+
- "title"
101+
- "visibility_level"
102+
muted_users:
103+
columns:
104+
exclude:
105+
- "id"
106+
primary_key_column_names: [ "user_id", "muted_user_id" ]
107+
permalinks:
108+
primary_key_column_names: [ "url" ]
109+
columns:
110+
add:
111+
- name: "external_url_placeholders"
112+
datatype: json
113+
exclude:
114+
- "created_at"
115+
- "id"
116+
poll_options:
117+
columns:
118+
exclude:
119+
- "digest"
120+
- "html"
121+
poll_votes:
122+
primary_key_column_names: [ "poll_option_id", "user_id" ]
123+
polls: {}
124+
post_custom_fields:
125+
primary_key_column_names: [ "post_id", "name" ]
126+
columns:
127+
exclude:
128+
- "created_at"
129+
- "id"
130+
posts:
131+
columns:
132+
add:
133+
- name: "original_raw"
134+
datatype: text
135+
- name: "reply_to_post_id"
136+
datatype: numeric
137+
exclude:
138+
- "action_code"
139+
- "baked_at"
140+
- "baked_version"
141+
- "bookmark_count"
142+
- "cook_method"
143+
- "cooked"
144+
- "edit_reason"
145+
- "illegal_count"
146+
- "incoming_link_count"
147+
- "inappropriate_count"
148+
- "like_score"
149+
- "notify_moderators_count"
150+
- "notify_user_count"
151+
- "off_topic_count"
152+
- "outbound_message_id"
153+
- "percent_rank"
154+
- "public_version"
155+
- "raw_email"
156+
- "reply_quoted"
157+
- "reply_to_post_number"
158+
- "score"
159+
- "self_edits"
160+
- "sort_order"
161+
- "version"
162+
- "via_email"
163+
- "word_count"
164+
indexes:
165+
- name: "posts_by_topic_post_number"
166+
columns:
167+
- "topic_id"
168+
- "post_number"
169+
tag_groups: {}
170+
tag_users:
171+
primary_key_column_names: [ "tag_id", "user_id" ]
172+
tags:
173+
columns:
174+
add:
175+
- name: "tag_group_id"
176+
datatype: numeric
177+
exclude:
178+
- "pm_topic_count"
179+
- "public_topic_count"
180+
- "staff_topic_count"
181+
topic_tags:
182+
primary_key_column_names: [ "topic_id", "tag_id" ]
183+
topic_users:
184+
primary_key_column_names: ["user_id", "topic_id" ]
185+
columns:
186+
exclude:
187+
- "id"
188+
topics:
189+
columns:
190+
exclude:
191+
- "external_id"
192+
- "fancy_title"
193+
- "highest_post_number"
194+
- "highest_staff_post_number"
195+
- "last_post_user_id"
196+
- "last_posted_at"
197+
- "like_count"
198+
- "moderator_posts_count"
199+
- "notify_moderators_count"
200+
- "participant_count"
201+
- "percent_rank"
202+
- "posts_count"
203+
- "reply_count"
204+
- "reviewable_score"
205+
- "score"
206+
- "slow_mode_seconds"
207+
- "spam_count"
208+
- "visibility_reason_id"
209+
- "word_count"
210+
user_associated_accounts:
211+
primary_key_column_names: [ "user_id", "provider_name" ]
212+
columns:
213+
exclude:
214+
- "id"
215+
- "created_at"
216+
user_badges:
217+
columns:
218+
exclude:
219+
- "id"
220+
- "notification_id"
221+
- "seq"
222+
user_chat_channel_memberships:
223+
primary_key_column_names: [ "user_id", "chat_channel_id" ]
224+
columns:
225+
exclude:
226+
- "id"
227+
user_chat_thread_memberships:
228+
primary_key_column_names: [ "user_id", "thread_id" ]
229+
columns:
230+
exclude:
231+
- "id"
232+
user_custom_fields:
233+
columns:
234+
add:
235+
- name: "field_id"
236+
datatype: numeric
237+
nullable: false
238+
- name: "is_multiselect_field"
239+
datatype: boolean
240+
nullable: false
241+
exclude:
242+
- "id"
243+
- "created_at"
244+
indexes:
245+
- name: "user_field_values_multiselect"
246+
columns:
247+
- "user_id"
248+
- "field_id"
249+
- "value"
250+
unique: true
251+
condition: "WHERE is_multiselect_field = TRUE"
252+
- name: "user_field_values_not_multiselect"
253+
columns:
254+
- "user_id"
255+
- "field_id"
256+
unique: true
257+
condition: "WHERE is_multiselect_field = FALSE"
10258
user_emails:
11259
columns:
12260
include:
261+
- "created_at"
13262
- "email"
14263
- "primary"
15264
- "user_id"
16-
- "created_at"
17265
primary_key_column_names: [ "email" ]
266+
user_fields:
267+
columns:
268+
add:
269+
- name: "options"
270+
datatype: json
18271
user_options:
19272
primary_key_column_names: [ "user_id" ]
20273
users:
@@ -35,6 +288,7 @@ schema:
35288
- "suspended_till"
36289
- "username_lower"
37290

291+
38292
global:
39293
columns:
40294
modify:
@@ -63,11 +317,8 @@ schema:
63317
- "backup_metadata"
64318
- "badge_groupings"
65319
- "badge_types"
66-
- "badges"
67320
- "bookmarks"
68-
- "categories"
69321
- "categories_web_hooks"
70-
- "category_custom_fields"
71322
- "category_featured_topics"
72323
- "category_form_templates"
73324
- "category_groups"
@@ -79,20 +330,14 @@ schema:
79330
- "category_tag_groups"
80331
- "category_tag_stats"
81332
- "category_tags"
82-
- "category_users"
83333
- "chat_channel_archives"
84334
- "chat_channel_custom_fields"
85-
- "chat_channels"
86335
- "chat_drafts"
87336
- "chat_mention_notifications"
88-
- "chat_mentions"
89337
- "chat_message_custom_fields"
90338
- "chat_message_interactions"
91-
- "chat_message_reactions"
92339
- "chat_message_revisions"
93-
- "chat_messages"
94340
- "chat_thread_custom_fields"
95-
- "chat_threads"
96341
- "chat_webhook_events"
97342
- "child_themes"
98343
- "color_scheme_colors"
@@ -130,8 +375,6 @@ schema:
130375
- "group_mentions"
131376
- "group_requests"
132377
- "group_tag_notification_defaults"
133-
- "group_users"
134-
- "groups"
135378
- "groups_web_hooks"
136379
- "ignored_users"
137380
- "imap_sync_logs"
@@ -147,19 +390,13 @@ schema:
147390
- "linked_topics"
148391
- "message_bus"
149392
- "moved_posts"
150-
- "muted_users"
151393
- "notifications"
152394
- "oauth2_user_infos"
153395
- "onceoff_logs"
154396
- "optimized_images"
155-
- "permalinks"
156397
- "plugin_store_rows"
157-
- "poll_options"
158-
- "poll_votes"
159-
- "polls"
160398
- "post_action_types"
161399
- "post_actions"
162-
- "post_custom_fields"
163400
- "post_details"
164401
- "post_hotlinked_media"
165402
- "post_localizations"
@@ -169,7 +406,6 @@ schema:
169406
- "post_search_data"
170407
- "post_stats"
171408
- "post_timings"
172-
- "posts"
173409
- "problem_check_trackers"
174410
- "published_pages"
175411
- "push_subscriptions"
@@ -200,10 +436,7 @@ schema:
200436
- "summary_sections"
201437
- "tag_group_memberships"
202438
- "tag_group_permissions"
203-
- "tag_groups"
204439
- "tag_search_data"
205-
- "tag_users"
206-
- "tags"
207440
- "tags_web_hooks"
208441
- "theme_color_schemes"
209442
- "theme_fields"
@@ -225,13 +458,10 @@ schema:
225458
- "topic_links"
226459
- "topic_localizations"
227460
- "topic_search_data"
228-
- "topic_tags"
229461
- "topic_thumbnails"
230462
- "topic_timers"
231-
- "topic_users"
232463
- "topic_view_stats"
233464
- "topic_views"
234-
- "topics"
235465
- "translation_overrides"
236466
- "unsubscribe_keys"
237467
- "upload_references"
@@ -242,18 +472,12 @@ schema:
242472
- "user_api_key_scopes"
243473
- "user_api_keys"
244474
- "user_archived_messages"
245-
- "user_associated_accounts"
246475
- "user_associated_groups"
247476
- "user_auth_token_logs"
248477
- "user_auth_tokens"
249478
- "user_avatars"
250-
- "user_badges"
251-
- "user_chat_channel_memberships"
252-
- "user_chat_thread_memberships"
253-
- "user_custom_fields"
254479
- "user_exports"
255480
- "user_field_options"
256-
- "user_fields"
257481
- "user_histories"
258482
- "user_ip_address_histories"
259483
- "user_notification_schedules"

0 commit comments

Comments
 (0)