swee / gistfile1.txt

version - all implicit id, version forgejo_version - all implicit id, version forgejo_sem_ver - all implicit version forgejo_migration - all implicit id, created_unix dbfs_meta - all implicit id, full_path, block_size, file_size, create_timestamp, modify_timestamp dbfs_data - all implicit id, revision, meta_id, blob_offset, blob_size, blob_data email_hash - all implicit hash, email access_token - all implicit id, uid, name, token_hash, token_salt, token_last_eight, scope, created_unix, updated_unix oauth2_application - SOME EXPLICIT id, uid, name, client_id, client_secret, confidential_client, redirect_uris, created_unix, updated_unix [!!!] change confidential_client from integer to boolean oauth2_authorization_code - all implicit id, grant_id, code, code_challenge, code_challenge_method, redirect_uri, valid_until oauth2_grant - all implicit id, user_id, application_id, counter, scope, nonce, created_unix, updated_unix session - all implicit key, data, expiry login_source - SOME EXPLICIT id, type, name, is_active, is_sync_enabled, cfg, created_unix, updated_unix [!!!] change is_active and is_sync_enabled from integer to boolean two_factor - all implicit id, uid, scratch_salt, scratch_hash, last_used_passcode, created_unix, secret webauthn_credential - SOME EXPLICIT 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 [!!!] change clone_warning, backup_eligible, backup_state, and legacy from integer to boolean abuse_report - all implicit id, status, reporter_id, content_type, content_id, category, remarks, shadow_copy_id, created_unix, resolved_unix abuse_report_shadow_copy - all implicit id, raw_value, created_unix app_state - all implicit id, revision, content notice - all implicit id, type, description, created_unix system_setting - all implicit id, setting_key, setting_value, version, created, updated hook_task - SOME EXPLICIT id, hook_id, uuid, payload_content, payload_version, event_type, is_delivered, delivered, is_succeed, request_content, response_content [!!!] change is_delivered and is_succeed from integer to boolean webhook - SOME EXPLICIT 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 [!!!] change is_system_webhook, is_active from integer to boolean federation_host - SOME EXPLICIT id, host_fqdn, software_name, latest_activity, created, updated, key_id, public_key, host_port, host_schema [!!!] convert timestamps in latest_activity to whatever format postgres uses badge - all implicit id, description, image_url user_badge - all implicit id, badge_id, user_id forgejo_blocked_user - all implicit id, block_id, user_id, created_unix email_address - SOME EXPLICIT id, uid, email, lower_email, is_activated, is_primary [!!!] change is_activated, is_primary from integer to boolean external_login_user - SOME EXPLICIT 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 [!!!] convert timestamps in expires_at to whatever format postgres uses follow - all implicit id, user_id, follow_id, created_unix user_open_id - SOME EXPLICIT id, uid, uri, show [!!!] change show from integer to boolean user_redirect - all implicit id, lower_name, redirect_user_id, created_unix user_setting - all implicit id, user_id, setting_key, setting_value federated_user - all implicit id, user_id, external_id, federation_host_id, key_id, public_key, normalized_original_url, inbox_path federated_user_follower - all implicit id, followed_user_id, following_user_id repo_archive_download_count - all implicit id, repo_id, release_id, type, count repo_archiver - all implicit id, repo_id, type, status, commit_id, created_unix user - SOME EXPLICIT 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 [!!!] 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 attachment - all implicit id, uuid, repo_id, issue_id, release_id, uploader_id, comment_id, name, download_count, size, created_unix, external_url language_stat - SOME EXPLICIT id, repo_id, commit_id, is_primary, language, size, created_unix [!!!] change is_primary from integer to boolean mirror - SOME EXPLICIT id, repo_id, interval, enable_prune, updated_unix, next_update_unix, lfs_enabled, lfs_endpoint, remote_address [!!!] change enable_prune and lfs_enabled from integer to boolean push_mirror - SOME EXPLICIT id, repo_id, remote_name, remote_address, sync_on_commit, interval, created_unix, last_update, last_error, public_key, private_key, branch_filter [!!!] change sync_on_commit from integer to boolean repo_redirect - all implicit id, owner_id, lower_name, redirect_repo_id release - SOME EXPLICIT 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 [!!!] change hide_archive_links, is_draft, is_prerelease, is_tag from integer to boolean forgejo_repo_flag - all implicit id, repo_id, name repo_indexer_status - all implicit id, repo_id, commit_sha, indexer_type following_repo - all implicit id, repo_id, external_id, federation_host_id, uri repo_unit - all implicit id, repo_id, type, config, created_unix, default_permissions star - all implicit id, uid, repo_id, created_unix topic - all implicit id, name, repo_count, created_unix, updated_unix repo_topic - all implicit repo_id, topic_id upload - all implicit id, uuid, name watch - all implicit id, user_id, repo_id, mode, created_unix, updated_unix action_artifact - all implicit 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 action_run - SOME EXPLICIT 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 [!!!] change notify_email, is_fork_pull_request, and need_approval from integer to boolean action_run_index - all implicit group_id, max_index action_run_job - SOME EXPLICIT 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 [!!!] change is_fork_pull_request from integer to boolean action_runner - all implicit 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 action_runner_token - SOME EXPLICIT id, token, owner_id, repo_id, is_active, created, updated, deleted [!!!] change is_active from integer to boolean action_schedule - all implicit id, title, specs, repo_id, owner_id, workflow_id, trigger_user_id, ref, commit_sha, event, event_payload, content, created, updated, workflow_directory action_schedule_spec - all implicit id, repo_id, schedule_id, next, prev, spec, created, updated action_task - SOME EXPLICIT 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 [!!!] change log_expired, is_fork_pull_request, and log_in_storage from integer to boolean action_task_output - all implicit id, task_id, output_key, output_value action_task_step - all implicit id, name, task_id, index, repo_id, status, log_index, log_length, started, stopped, created, updated action_tasks_version - all implicit id, owner_id, repo_id, version, created_unix, updated_unix action_variable - all implicit id, owner_id, repo_id, name, data, created_unix, updated_unix task - all implicit id, doer_id, owner_id, repo_id, type, status, start_time, end_time, payload_content, message, created gpg_key - SOME EXPLICIT 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 [!!!] change can_certify, can_sign, can_encrypt_comms, can_encrypt_storage, and verified from integer to boolean gpg_key_import - all implicit key_id, content public_key - SOME EXPLICIT id, owner_id, name, fingerprint, content, mode, type, login_source_id, created_unix, updated_unix, verified [!!!] change verified from integer to boolean deploy_key - all implicit id, key_id, repo_id, name, fingerprint, mode, created_unix, updated_unix project_board - SOME EXPLICIT id, titme, default, sorting, color, project_id, creator_id, created_unix, updated_unix [!!!] change default from integer to boolean project_issue - all implicit id, issue_id, project_id, project_board_id, sorting project - SOME EXPLICIT id, title, description, owner_id, repo_id, creator_id, is_closed, board_type, card_type, type, created_unix, updated_unix, closed_date_unix [!!!] change is_closed from integer to boolean pull_auto_merge - SOME EXPLICIT id, pull_id, doer_id, merge_style, message, created_unix, delete_branch_after_merge [!!!] change delete_branch_after_merge from integer to boolean review_state - all implicit id, user_id, pull_id, commit_sha, updated_files, updated_unix secret - all implicit id, owner_id, repo_id, name, created_unix, data org_user - SOME EXPLICIT id, uid, org_id, is_public [!!!] change is_public from integer to boolean team - SOME EXPLICIT id, org_id, lower_name, name, description, authorize, num_repos, num_memebers, includes_all_repositories, can_create_org_repo [!!!] change can_create_org_repo and includes_all_repositories from integer to boolean team_user - all implicit id, org_id, team_id, uid team_repo - all implicit id, org_id, team_id, repo_id team_unit - all implicit id, org_id, team_id, type, access_mode team_invite - all implicit id, token, inviter_id, org_id, team_id, email, created_unix, updated_unix branch - SOME EXPLICIT id, repo_id, name, commit_id, commit_message, pusher_id, is_deleted, deleted_by_id, deleted_unix, commit_time created_unix, updated_unix [!!!] change is_deleted from integer to boolean renamed_branch - all implicit id, repo_id, from, to, created_unix commit_status - all implicit id, index, repo_Id, state, sha, target_url, description, context_hash, context, creator_id, created_unix, updated_unix commit_status_index - all implicit id, repo_id, sha, max_index commit_status_summary - all implicit id, repo_id, sha, state, target_url lfs_meta_object - all implicit id, oid, size, repository_id, created_unix, updated_unix lfs_lock - SOME EXPLICIT id, repo_id, owner_id, path, created [!!!] convert created to whatever timestamp format postgres uses protected_branch - SOME EXPLICIT 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 [!!!] 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 protected_tag - all implicit id, repo_id, name_pattern, allowlist_user_i_ds, allowlist_team_i_ds, created_unix, updated_unix package - SOME EXPLICIT id, owner_id, repo_id, type, name, lower_name, semver_compatible, is_internal [!!!] change semver_compatible and is_internal from integer to boolean package_blob - all implicit id, size, hash_md5, hash_sha1, hash_sha256, hash_sha512, created_unix, hash_blake2b package_blob_upload - all implicit id, bytes_received, hash_state_bytes, created_unix, updated_unix package_cleanup_rule - SOME EXPLICIT id, enabled, owner_id, type, keep_count, keep_Pattern, remove_days, remove_pattern, match_full_name, created_unix, updated_unix [!!!] change enabled and match_full_name from integer to boolean package_file - SOME EXPLICIT id, version_id, blob_id, name, lower_name, composite_key, is_lead, created_unix [!!!] change is_lead from integer to boolean package_property - all implicit id, ref_type, ref_id, name, value package_version - SOME EXPLICIT id, package_id, creator_id, version, lower_version, created_unix, is_internal, metadata_json, downloaded_count [!!!] change is_internal from integer to boolean quota_rule - all implicit name, limit, subjects quota_group - all implicit name quota_group_rule_mapping - all implicit id, group_name, rule_name quota_group_mapping - all implicit id, kind, mapped_id, group_name issue_assignees - all implicit id, assignee_id, issue_id comment - SOME EXPLICIT 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 [!!!] change removed_assignee, invalidated, ref_is_pull from integer to boolean issue_content_history - SOME EXPLICIT id, poster_id, issue_id, comment_id, edited_unix, content_text, is_first_created, is_deleted [!!!] change is_deleted and is_first_created from integer to boolean issue_dependency - all implicit id, user_id, issue_id, dependency_id, created_unix, updated_unix issue_index - all implicit group_id, max_index issue_user - SOME EXPLICIT id, uid, issue_id, is_read, is_mentioned [!!!] change is_read and is_mentioned from integer to boolean issue_watch - SOME EXPLICIT id, user_id, issue_id, is_watching, created_unix, updated_unix [!!!] change is_watching from integer to boolean label - SOME EXPLICIT id, repo_id, org_id, name, exclusive, description, color, num_issues, num_closed_issues, created_unix, updated_unix, archived_unix [!!!] change exclusive from integer to boolean issue_label - all implicit id, issue_id, label_id milestone - SOME EXPLICIT id, repo_id, name, content, is_closed, num_issues, num_closed_issues, completeness, created_unix, updated_unix, deadline_unix, closed_date_unix [!!!] change is_closed from integer to boolean reaction - all implicit id, type, issue_id, comment_id, user_id, original_author_id, original_author, created_unix review - SOME EXPLICIT id, type, reviewer_id, reviewer_team_id, original_author, original_author_id, issue_id, content, officail, commit_id, stale, dismissed, created_unix, updated_unix [!!!] change dismissed, official, and stale from integer to boolean repo_transfer - all implicit id, doer_id, recipient_id, repo_id, team_i_ds, created_unix, updated_unix action - SOME EXPLICIT id, user_id, op_type, act_user_id, repo_id, comment_id, ref_name, is_private, content, created_unix [!!!] change is_private from integer to boolean federated_user_activity - all implicit id, user_id, actor_id, actor_uri, note_content, note_url, original_note, created notification - all implicit id, user_id, repo_id, status, source, issue_id, comment_id, created_unix, updated_unix forgejo_auth_token - all implicit id, uid, lookup_key, hashed_validator, expiry, purpose repository - SOME EXPLICIT 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 [!!!] 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 collaboration - all implicit id, repo_id, user_id, mode, created_unix, updated_unix action_user - SOME EXPLICIT id, user_id, repo_id, trusted_with_pull_requests [!!!] change trusted_with_pull_requests from integer to boolean access - all implicit id, user_id, repo_id, mode issue - SOME EXPLICIT 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 [!!!] change is_closed, is_pull, and is_locked from integer to boolean pull_request - SOME EXPLICIT 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 [!!!] change allow_maintainer_edit and has_merged from integer to boolean stopwatch - all implicit id, issue_id, user_id, created_unix tracked_time - SOME EXPLICIT id, issue_id, user_id, created_unix, time, deleted [!!!] change deleted from integer to boolean