Like 0
Fork 0

Last active 1 day ago

swee revised this gist 1 day ago. Go to revision

1 file changed, 425 insertions

gistfile1.txt(file created)

@@ -0,0 +1,425 @@
1 + version - all implicit
2 + id, version
3 +
4 + forgejo_version - all implicit
5 + id, version
6 +
7 + forgejo_sem_ver - all implicit
8 + version
9 +
10 + forgejo_migration - all implicit
11 + id, created_unix
12 +
13 + dbfs_meta - all implicit
14 + id, full_path, block_size, file_size, create_timestamp, modify_timestamp
15 +
16 + dbfs_data - all implicit
17 + id, revision, meta_id, blob_offset, blob_size, blob_data
18 +
19 + email_hash - all implicit
20 + hash, email
21 +
22 + access_token - all implicit
23 + id, uid, name, token_hash, token_salt, token_last_eight, scope, created_unix, updated_unix
24 +
25 + oauth2_application - SOME EXPLICIT
26 + id, uid, name, client_id, client_secret, confidential_client, redirect_uris, created_unix, updated_unix
27 + [!!!] change confidential_client from integer to boolean
28 +
29 + oauth2_authorization_code - all implicit
30 + id, grant_id, code, code_challenge, code_challenge_method, redirect_uri, valid_until
31 +
32 + oauth2_grant - all implicit
33 + id, user_id, application_id, counter, scope, nonce, created_unix, updated_unix
34 +
35 + session - all implicit
36 + key, data, expiry
37 +
38 + login_source - SOME EXPLICIT
39 + id, type, name, is_active, is_sync_enabled, cfg, created_unix, updated_unix
40 + [!!!] change is_active and is_sync_enabled from integer to boolean
41 +
42 + two_factor - all implicit
43 + id, uid, scratch_salt, scratch_hash, last_used_passcode, created_unix, secret
44 +
45 + webauthn_credential - SOME EXPLICIT
46 + id, name, lower_name, user_id, credential_id, public_key, attestation_type, aaguid, sign_count, clone_warning, created_unix, updated_unix, backup_eligible, backup_state, legacy
47 + [!!!] change clone_warning, backup_eligible, backup_state, and legacy from integer to boolean
48 +
49 + abuse_report - all implicit
50 + id, status, reporter_id, content_type, content_id, category, remarks, shadow_copy_id, created_unix, resolved_unix
51 +
52 + abuse_report_shadow_copy - all implicit
53 + id, raw_value, created_unix
54 +
55 + app_state - all implicit
56 + id, revision, content
57 +
58 + notice - all implicit
59 + id, type, description, created_unix
60 +
61 + system_setting - all implicit
62 + id, setting_key, setting_value, version, created, updated
63 +
64 + hook_task - SOME EXPLICIT
65 + id, hook_id, uuid, payload_content, payload_version, event_type, is_delivered, delivered, is_succeed, request_content, response_content
66 + [!!!] change is_delivered and is_succeed from integer to boolean
67 +
68 + webhook - SOME EXPLICIT
69 + id, repo_id, owner_id, is_system_webhook, url, http_method, content_type, secret, events, is_active, type, meta, last_status, header_authorization_encrypted, created_unix, updated_unix
70 + [!!!] change is_system_webhook, is_active from integer to boolean
71 +
72 + federation_host - SOME EXPLICIT
73 + id, host_fqdn, software_name, latest_activity, created, updated, key_id, public_key, host_port, host_schema
74 + [!!!] convert timestamps in latest_activity to whatever format postgres uses
75 +
76 + badge - all implicit
77 + id, description, image_url
78 +
79 + user_badge - all implicit
80 + id, badge_id, user_id
81 +
82 + forgejo_blocked_user - all implicit
83 + id, block_id, user_id, created_unix
84 +
85 + email_address - SOME EXPLICIT
86 + id, uid, email, lower_email, is_activated, is_primary
87 + [!!!] change is_activated, is_primary from integer to boolean
88 +
89 + external_login_user - SOME EXPLICIT
90 + external_id, user_id, login_source_id, raw_data, provider, email, name, first_name, last_name, nick_name, description, avatar_url, location, access_token, access_token_secret, refresh_token, expires_at
91 + [!!!] convert timestamps in expires_at to whatever format postgres uses
92 +
93 + follow - all implicit
94 + id, user_id, follow_id, created_unix
95 +
96 + user_open_id - SOME EXPLICIT
97 + id, uid, uri, show
98 + [!!!] change show from integer to boolean
99 +
100 + user_redirect - all implicit
101 + id, lower_name, redirect_user_id, created_unix
102 +
103 + user_setting - all implicit
104 + id, user_id, setting_key, setting_value
105 +
106 + federated_user - all implicit
107 + id, user_id, external_id, federation_host_id, key_id, public_key, normalized_original_url, inbox_path
108 +
109 + federated_user_follower - all implicit
110 + id, followed_user_id, following_user_id
111 +
112 + repo_archive_download_count - all implicit
113 + id, repo_id, release_id, type, count
114 +
115 + repo_archiver - all implicit
116 + id, repo_id, type, status, commit_id, created_unix
117 +
118 + user - SOME EXPLICIT
119 + id, lower_name, name, full_name, email, keep_email_private, email_notifications_preference, passwd, passwd_hash_algo, must_change_password, login_type, login_name, type, location, website, pronouns, rands, salt, language, description, created_unix, last_login_unix, last_repo_visibility, max_repo_creation, is_active, is_admin, is_restriction, allow_git_hook, allow_import_local, allow_create_organization, prohibit_login, avatar, avatar_email, use_custom_avatar, num_followers_ num_following, num_stars, num_repos, num_teams, num_members, visibility, repo_admin_change_team_access, diff_view_style, theme, keep_activity,Private, enable_repo_unit_hints
120 + [!!!] change enable_repo_unit_hints, is_active, is_admin, is_restricted, allow_git_hook, allow_import_local, allow_create_organization, prohibit_login, use_custom_avatar, repo_admin_change_team_access, keep_activity_private, keep_pronouns_private, keep_email_private, must_change_password, and last_repo_visibility, from integer to boolean
121 +
122 + attachment - all implicit
123 + id, uuid, repo_id, issue_id, release_id, uploader_id, comment_id, name, download_count, size, created_unix, external_url
124 +
125 + language_stat - SOME EXPLICIT
126 + id, repo_id, commit_id, is_primary, language, size, created_unix
127 + [!!!] change is_primary from integer to boolean
128 +
129 + mirror - SOME EXPLICIT
130 + id, repo_id, interval, enable_prune, updated_unix, next_update_unix, lfs_enabled, lfs_endpoint, remote_address
131 + [!!!] change enable_prune and lfs_enabled from integer to boolean
132 +
133 + push_mirror - SOME EXPLICIT
134 + id, repo_id, remote_name, remote_address, sync_on_commit, interval, created_unix, last_update, last_error, public_key, private_key, branch_filter
135 + [!!!] change sync_on_commit from integer to boolean
136 +
137 + repo_redirect - all implicit
138 + id, owner_id, lower_name, redirect_repo_id
139 +
140 + release - SOME EXPLICIT
141 + id, repo_id, publisher_id, tag_name, original_author, original_author_id, lower_tag_name, target, title, sha1, hide_archive_links, num_commits, note, is_draft, is_prerelease, is_tag, created_unix
142 + [!!!] change hide_archive_links, is_draft, is_prerelease, is_tag from integer to boolean
143 +
144 + forgejo_repo_flag - all implicit
145 + id, repo_id, name
146 +
147 + repo_indexer_status - all implicit
148 + id, repo_id, commit_sha, indexer_type
149 +
150 + following_repo - all implicit
151 + id, repo_id, external_id, federation_host_id, uri
152 +
153 + repo_unit - all implicit
154 + id, repo_id, type, config, created_unix, default_permissions
155 +
156 + star - all implicit
157 + id, uid, repo_id, created_unix
158 +
159 + topic - all implicit
160 + id, name, repo_count, created_unix, updated_unix
161 +
162 + repo_topic - all implicit
163 + repo_id, topic_id
164 +
165 + upload - all implicit
166 + id, uuid, name
167 +
168 + watch - all implicit
169 + id, user_id, repo_id, mode, created_unix, updated_unix
170 +
171 + action_artifact - all implicit
172 + id, run_id, runner_id, repo_id, owner_id, commit_sha, storage_path, file_size, file_compressed_size, content_encoding, artifact_path, artifact_name, status, created_unix, updated_unix, expired_unix
173 +
174 + action_run - SOME EXPLICIT
175 + id, title, repo_id, owner_id, workflow_id, index, trigger_user_id, schedule_id, ref, commit_sha, is_fork_pull_request, need_approval, approved_by, event, event_payload, trigger_event, status, version, started, stopped, previous_duration, created, updated, notify_email, pre_execution_error, concurrency_group, concurrency_type, pull_request_poster_id, pull_request_id, workflow_directory, pre_execution_error_code, pre_execution_error_details
176 + [!!!] change notify_email, is_fork_pull_request, and need_approval from integer to boolean
177 +
178 + action_run_index - all implicit
179 + group_id, max_index
180 +
181 + action_run_job - SOME EXPLICIT
182 + id, run_id, repo_id, owner_id, commit_sha, is_fork_pull_request, name, attempt, workflow_payload, job_id, needs, runs_on, task_id, status, started, stopped, created, updated
183 + [!!!] change is_fork_pull_request from integer to boolean
184 +
185 + action_runner - all implicit
186 + id, uuid, name, version, owner_id, repo_id, description, base, repo_range, token_hash, token_salt, last_online, last_active, agent_labels, created, updated, deleted
187 +
188 + action_runner_token - SOME EXPLICIT
189 + id, token, owner_id, repo_id, is_active, created, updated, deleted
190 + [!!!] change is_active from integer to boolean
191 +
192 + action_schedule - all implicit
193 + id, title, specs, repo_id, owner_id, workflow_id, trigger_user_id, ref, commit_sha, event, event_payload, content, created, updated, workflow_directory
194 +
195 + action_schedule_spec - all implicit
196 + id, repo_id, schedule_id, next, prev, spec, created, updated
197 +
198 + action_task - SOME EXPLICIT
199 + id, job_id, attempt, runner_id, status, started, stopped, repo_id, owner_id, commit_sha, is_fork_pull_request, token_hash, token_salt, token_last_eight, log_filename, log_in_storage, log_length, log_size, log_indexes, log_expired, created, updated
200 + [!!!] change log_expired, is_fork_pull_request, and log_in_storage from integer to boolean
201 +
202 + action_task_output - all implicit
203 + id, task_id, output_key, output_value
204 +
205 + action_task_step - all implicit
206 + id, name, task_id, index, repo_id, status, log_index, log_length, started, stopped, created, updated
207 +
208 + action_tasks_version - all implicit
209 + id, owner_id, repo_id, version, created_unix, updated_unix
210 +
211 + action_variable - all implicit
212 + id, owner_id, repo_id, name, data, created_unix, updated_unix
213 +
214 + task - all implicit
215 + id, doer_id, owner_id, repo_id, type, status, start_time, end_time, payload_content, message, created
216 +
217 + gpg_key - SOME EXPLICIT
218 + id, owner_id, key_id, primary_key_id, content, created_unix, expired_unix, added_unix, emails, verified, can_sign, can_encrypt_comms, can_encrypt_storage, can_certify
219 + [!!!] change can_certify, can_sign, can_encrypt_comms, can_encrypt_storage, and verified from integer to boolean
220 +
221 + gpg_key_import - all implicit
222 + key_id, content
223 +
224 + public_key - SOME EXPLICIT
225 + id, owner_id, name, fingerprint, content, mode, type, login_source_id, created_unix, updated_unix, verified
226 + [!!!] change verified from integer to boolean
227 +
228 + deploy_key - all implicit
229 + id, key_id, repo_id, name, fingerprint, mode, created_unix, updated_unix
230 +
231 + project_board - SOME EXPLICIT
232 + id, titme, default, sorting, color, project_id, creator_id, created_unix, updated_unix
233 + [!!!] change default from integer to boolean
234 +
235 + project_issue - all implicit
236 + id, issue_id, project_id, project_board_id, sorting
237 +
238 + project - SOME EXPLICIT
239 + id, title, description, owner_id, repo_id, creator_id, is_closed, board_type, card_type, type, created_unix, updated_unix, closed_date_unix
240 + [!!!] change is_closed from integer to boolean
241 +
242 + pull_auto_merge - SOME EXPLICIT
243 + id, pull_id, doer_id, merge_style, message, created_unix, delete_branch_after_merge
244 + [!!!] change delete_branch_after_merge from integer to boolean
245 +
246 + review_state - all implicit
247 + id, user_id, pull_id, commit_sha, updated_files, updated_unix
248 +
249 + secret - all implicit
250 + id, owner_id, repo_id, name, created_unix, data
251 +
252 + org_user - SOME EXPLICIT
253 + id, uid, org_id, is_public
254 + [!!!] change is_public from integer to boolean
255 +
256 + team - SOME EXPLICIT
257 + id, org_id, lower_name, name, description, authorize, num_repos, num_memebers, includes_all_repositories, can_create_org_repo
258 + [!!!] change can_create_org_repo and includes_all_repositories from integer to boolean
259 +
260 + team_user - all implicit
261 + id, org_id, team_id, uid
262 +
263 + team_repo - all implicit
264 + id, org_id, team_id, repo_id
265 +
266 + team_unit - all implicit
267 + id, org_id, team_id, type, access_mode
268 +
269 + team_invite - all implicit
270 + id, token, inviter_id, org_id, team_id, email, created_unix, updated_unix
271 +
272 + branch - SOME EXPLICIT
273 + id, repo_id, name, commit_id, commit_message, pusher_id, is_deleted, deleted_by_id, deleted_unix, commit_time created_unix, updated_unix
274 + [!!!] change is_deleted from integer to boolean
275 +
276 + renamed_branch - all implicit
277 + id, repo_id, from, to, created_unix
278 +
279 + commit_status - all implicit
280 + id, index, repo_Id, state, sha, target_url, description, context_hash, context, creator_id, created_unix, updated_unix
281 +
282 + commit_status_index - all implicit
283 + id, repo_id, sha, max_index
284 +
285 + commit_status_summary - all implicit
286 + id, repo_id, sha, state, target_url
287 +
288 + lfs_meta_object - all implicit
289 + id, oid, size, repository_id, created_unix, updated_unix
290 +
291 + lfs_lock - SOME EXPLICIT
292 + id, repo_id, owner_id, path, created
293 + [!!!] convert created to whatever timestamp format postgres uses
294 +
295 + protected_branch - SOME EXPLICIT
296 + id, repo_id, branch_name, can_push, enable_whitelist, whitelist_user_i_ds, whitelist_team_i_ds, enable_merge_whitelist, whitelist_deploy_keys, merge_whitelist_user_i_ds, merge_whitelist_team_i_ds, enable_status_check, status_check_contexts, enable_approvals_whitelist, approvals_whitelist_user_i_ds, approvals_whitelist_team_i_ds, required_approvals, block_on_rejected_reviews, block_on_official_review_requests, block_on_outdated_branch, dismiss_stale_approvals, require_signed_commits, protected_file_patterns, unprotected_file_patterns, apply_to_admins, created_unix, updated_unix
297 + [!!!] change block_on_rejected_reviews, block_on_official_review_requests, block_on_outdated_branch, dismiss_stale_approvals, ignore_stale_approvals, require_signed_commits, apply_to_admins, can_push, enable_whitelist, enable_merge_whitelist, whitelist_deploy_keys, enable_status_check, and enable_approvals_whitelist from integer to boolean
298 +
299 + protected_tag - all implicit
300 + id, repo_id, name_pattern, allowlist_user_i_ds, allowlist_team_i_ds, created_unix, updated_unix
301 +
302 + package - SOME EXPLICIT
303 + id, owner_id, repo_id, type, name, lower_name, semver_compatible, is_internal
304 + [!!!] change semver_compatible and is_internal from integer to boolean
305 +
306 + package_blob - all implicit
307 + id, size, hash_md5, hash_sha1, hash_sha256, hash_sha512, created_unix, hash_blake2b
308 +
309 + package_blob_upload - all implicit
310 + id, bytes_received, hash_state_bytes, created_unix, updated_unix
311 +
312 + package_cleanup_rule - SOME EXPLICIT
313 + id, enabled, owner_id, type, keep_count, keep_Pattern, remove_days, remove_pattern, match_full_name, created_unix, updated_unix
314 + [!!!] change enabled and match_full_name from integer to boolean
315 +
316 + package_file - SOME EXPLICIT
317 + id, version_id, blob_id, name, lower_name, composite_key, is_lead, created_unix
318 + [!!!] change is_lead from integer to boolean
319 +
320 + package_property - all implicit
321 + id, ref_type, ref_id, name, value
322 +
323 + package_version - SOME EXPLICIT
324 + id, package_id, creator_id, version, lower_version, created_unix, is_internal, metadata_json, downloaded_count
325 + [!!!] change is_internal from integer to boolean
326 +
327 + quota_rule - all implicit
328 + name, limit, subjects
329 +
330 + quota_group - all implicit
331 + name
332 +
333 + quota_group_rule_mapping - all implicit
334 + id, group_name, rule_name
335 +
336 + quota_group_mapping - all implicit
337 + id, kind, mapped_id, group_name
338 +
339 + issue_assignees - all implicit
340 + id, assignee_id, issue_id
341 +
342 + comment - SOME EXPLICIT
343 + id, type, poster_id, original_author, original_author_id, issue_id, label_id, old_project_id, project_id, old_milestone_id, milestone_id, time_id, assignee_id, removed_assignee, assignee_team_id, resolve_doer_id, old_title, new_title, old_ref, new_ref, dependent_issue_id, commit_id, line, tree_path, content, content_version, patch, created_unix, updated_unix, commit_sha, review_id, invalidated, ref_repo_id, ref_issue_id, ref_comment_id, ref_action, ref_is_pull
344 + [!!!] change removed_assignee, invalidated, ref_is_pull from integer to boolean
345 +
346 + issue_content_history - SOME EXPLICIT
347 + id, poster_id, issue_id, comment_id, edited_unix, content_text, is_first_created, is_deleted
348 + [!!!] change is_deleted and is_first_created from integer to boolean
349 +
350 + issue_dependency - all implicit
351 + id, user_id, issue_id, dependency_id, created_unix, updated_unix
352 +
353 + issue_index - all implicit
354 + group_id, max_index
355 +
356 + issue_user - SOME EXPLICIT
357 + id, uid, issue_id, is_read, is_mentioned
358 + [!!!] change is_read and is_mentioned from integer to boolean
359 +
360 + issue_watch - SOME EXPLICIT
361 + id, user_id, issue_id, is_watching, created_unix, updated_unix
362 + [!!!] change is_watching from integer to boolean
363 +
364 + label - SOME EXPLICIT
365 + id, repo_id, org_id, name, exclusive, description, color, num_issues, num_closed_issues, created_unix, updated_unix, archived_unix
366 + [!!!] change exclusive from integer to boolean
367 +
368 + issue_label - all implicit
369 + id, issue_id, label_id
370 +
371 + milestone - SOME EXPLICIT
372 + id, repo_id, name, content, is_closed, num_issues, num_closed_issues, completeness, created_unix, updated_unix, deadline_unix, closed_date_unix
373 + [!!!] change is_closed from integer to boolean
374 +
375 + reaction - all implicit
376 + id, type, issue_id, comment_id, user_id, original_author_id, original_author, created_unix
377 +
378 + review - SOME EXPLICIT
379 + id, type, reviewer_id, reviewer_team_id, original_author, original_author_id, issue_id, content, officail, commit_id, stale, dismissed, created_unix, updated_unix
380 + [!!!] change dismissed, official, and stale from integer to boolean
381 +
382 + repo_transfer - all implicit
383 + id, doer_id, recipient_id, repo_id, team_i_ds, created_unix, updated_unix
384 +
385 + action - SOME EXPLICIT
386 + id, user_id, op_type, act_user_id, repo_id, comment_id, ref_name, is_private, content, created_unix
387 + [!!!] change is_private from integer to boolean
388 +
389 + federated_user_activity - all implicit
390 + id, user_id, actor_id, actor_uri, note_content, note_url, original_note, created
391 +
392 + notification - all implicit
393 + id, user_id, repo_id, status, source, issue_id, comment_id, created_unix, updated_unix
394 +
395 + forgejo_auth_token - all implicit
396 + id, uid, lookup_key, hashed_validator, expiry, purpose
397 +
398 + repository - SOME EXPLICIT
399 + id, owner_id, owner_name, lower_name, name, description, website, original_service_type, original_url, default_branch, wiki_branch, num_watches, num_stars, num_forks, num_milestones, num_closed_milestones, num_projects, num_closed_projects, is_private, is_empty, is_archived, is_mirror, status, is_fork, fork_id, is_template, template_id, size, git_size, lfs_size, is_fsck_enabled, close_issues_via_commit_in_any_branch, object_format_name, trust_model, avatar, created_unix, updated_unix, archived_unix, topics
400 + [!!!] change is_private, is_empty, is_archived, is_mirror, is_fork. is_template, is_fsck_enabled, close_issues_via_commit_in_any_branch from integer to boolean
401 +
402 + collaboration - all implicit
403 + id, repo_id, user_id, mode, created_unix, updated_unix
404 +
405 + action_user - SOME EXPLICIT
406 + id, user_id, repo_id, trusted_with_pull_requests
407 + [!!!] change trusted_with_pull_requests from integer to boolean
408 +
409 + access - all implicit
410 + id, user_id, repo_id, mode
411 +
412 + issue - SOME EXPLICIT
413 + id, repo_id, index, poster_id, original_author, original_author_id, name, content, content_version, milestone_id, priority, is_closed, is_pull, num_comments, ref, pin_order, deadline_unix, created, created_unix, updated_unix, closed_unix, is_locked
414 + [!!!] change is_closed, is_pull, and is_locked from integer to boolean
415 +
416 + pull_request - SOME EXPLICIT
417 + id, type, status, conflicted_files, commits_ahead, commits_behind, changed_protected_files, issue_id, index, head_repo_id, head_branch, base_branch, merge_base, allow_maintainer_edit, has_merged, merge_commit_id, merger_id, flow
418 + [!!!] change allow_maintainer_edit and has_merged from integer to boolean
419 +
420 + stopwatch - all implicit
421 + id, issue_id, user_id, created_unix
422 +
423 + tracked_time - SOME EXPLICIT
424 + id, issue_id, user_id, created_unix, time, deleted
425 + [!!!] change deleted from integer to boolean
Newer Older

Powered by Opengist ⋅ Load: 862ms⋅

English