github.com/status-im/status-go@v1.1.0/appdatabase/migrations/sql/1709795716_migration_order_fix.up.sql (about)

     1  CREATE TABLE "settings2" (
     2      address VARCHAR NOT NULL, chaos_mode BOOLEAN DEFAULT false, currency VARCHAR DEFAULT 'usd', current_network VARCHAR NOT NULL, custom_bootnodes BLOB, custom_bootnodes_enabled BLOB, dapps_address VARCHAR NOT NULL, eip1581_address VARCHAR, fleet VARCHAR, hide_home_tooltip BOOLEAN DEFAULT false, installation_id VARCHAR NOT NULL, key_uid VARCHAR NOT NULL, keycard_instance_uid VARCHAR, keycard_paired_on UNSIGNED BIGINT, keycard_pairing VARCHAR, last_updated UNSIGNED BIGINT, log_level VARCHAR, mnemonic VARCHAR, name VARCHAR NOT NULL, networks BLOB NOT NULL, node_config BLOB, notifications_enabled BOOLEAN DEFAULT false, photo_path BLOB NOT NULL, pinned_mailservers BLOB, preferred_name VARCHAR, preview_privacy BOOLEAN DEFAULT false, public_key VARCHAR NOT NULL, remember_syncing_choice BOOLEAN DEFAULT false, signing_phrase VARCHAR NOT NULL, stickers_packs_installed BLOB, stickers_recent_stickers BLOB, syncing_on_mobile_network BOOLEAN DEFAULT false, synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY, usernames BLOB, wallet_root_address VARCHAR NOT NULL, wallet_set_up_passed BOOLEAN DEFAULT false, wallet_visible_tokens VARCHAR, stickers_packs_pending BLOB, waku_enabled BOOLEAN DEFAULT false, waku_bloom_filter_mode BOOLEAN DEFAULT false, appearance INT NOT NULL DEFAULT 0, remote_push_notifications_enabled BOOLEAN DEFAULT FALSE, send_push_notifications BOOLEAN DEFAULT TRUE, push_notifications_server_enabled BOOLEAN DEFAULT FALSE, push_notifications_from_contacts_only BOOLEAN DEFAULT FALSE, push_notifications_block_mentions BOOLEAN DEFAULT FALSE, webview_allow_permission_requests BOOLEAN DEFAULT FALSE, use_mailservers BOOLEAN DEFAULT TRUE, link_preview_request_enabled BOOLEAN DEFAULT TRUE, link_previews_enabled_sites BLOB, profile_pictures_visibility INT NOT NULL DEFAULT 1, anon_metrics_should_send BOOLEAN DEFAULT false, messages_from_contacts_only BOOLEAN DEFAULT FALSE, default_sync_period INTEGER DEFAULT 777600, -- 9 days
     3      current_user_status BLOB, send_status_updates BOOLEAN DEFAULT TRUE, gif_recents BLOB, gif_favorites BLOB, opensea_enabled BOOLEAN DEFAULT false, profile_pictures_show_to INT NOT NULL DEFAULT 1, telemetry_server_url VARCHAR NOT NULL DEFAULT "", backup_enabled BOOLEAN DEFAULT TRUE, last_backup INT NOT NULL DEFAULT 0, backup_fetched BOOLEAN DEFAULT FALSE, auto_message_enabled BOOLEAN DEFAULT FALSE, gif_api_key TEXT NOT NULL DEFAULT "", display_name TEXT NOT NULL DEFAULT "", test_networks_enabled BOOLEAN NOT NULL DEFAULT FALSE, mutual_contact_enabled BOOLEAN DEFAULT FALSE, bio TEXT NOT NULL DEFAULT "", mnemonic_removed BOOLEAN NOT NULL DEFAULT FALSE, latest_derived_path INT NOT NULL DEFAULT "0", device_name TEXT NOT NULL DEFAULT "", wallet_accounts_position_change_clock INTEGER NOT NULL DEFAULT 0, profile_migration_needed BOOLEAN NOT NULL DEFAULT FALSE, is_sepolia_enabled BOOLEAN NOT NULL DEFAULT FALSE, url_unfurling_mode INT NOT NULL DEFAULT 1, omit_transfers_history_scan BOOLEAN NOT NULL DEFAULT FALSE, mnemonic_was_not_shown BOOLEAN NOT NULL DEFAULT FALSE, wallet_token_preferences_change_clock INTEGER NOT NULL DEFAULT 0, wallet_token_preferences_group_by_community BOOLEAN NOT NULL DEFAULT FALSE, wallet_show_community_asset_when_sending_tokens INTEGER NOT NULL DEFAULT TRUE, wallet_display_assets_below_balance BOOLEAN NOT NULL DEFAULT FALSE, wallet_display_assets_below_balance_threshold UNSIGNED BIGINT NOT NULL DEFAULT 100000000, wallet_collectible_preferences_change_clock INTEGER NOT NULL DEFAULT 0, wallet_collectible_preferences_group_by_collection BOOLEAN NOT NULL DEFAULT FALSE, wallet_collectible_preferences_group_by_community BOOLEAN NOT NULL DEFAULT FALSE, peer_syncing_enabled BOOLEAN NOT NULL DEFAULT FALSE, is_goerli_enabled BOOLEAN NOT NULL DEFAULT FALSE
     4  ) WITHOUT ROWID;
     5  
     6  INSERT INTO
     7      settings2 (
     8      address, chaos_mode, currency, current_network, custom_bootnodes, custom_bootnodes_enabled, dapps_address, eip1581_address, fleet, hide_home_tooltip, installation_id, key_uid, keycard_instance_uid, keycard_paired_on, keycard_pairing, last_updated, log_level, mnemonic, name, networks, node_config, notifications_enabled, photo_path, pinned_mailservers, preferred_name, preview_privacy, public_key, remember_syncing_choice, signing_phrase, stickers_packs_installed, stickers_recent_stickers, syncing_on_mobile_network, synthetic_id, usernames, wallet_root_address, wallet_set_up_passed, wallet_visible_tokens, stickers_packs_pending, waku_enabled, waku_bloom_filter_mode, appearance, remote_push_notifications_enabled, send_push_notifications, push_notifications_server_enabled, push_notifications_from_contacts_only, push_notifications_block_mentions, webview_allow_permission_requests, use_mailservers, link_preview_request_enabled, link_previews_enabled_sites, profile_pictures_visibility, anon_metrics_should_send, messages_from_contacts_only, default_sync_period, current_user_status, send_status_updates, gif_recents, gif_favorites, opensea_enabled, profile_pictures_show_to, telemetry_server_url, backup_enabled, last_backup, backup_fetched, auto_message_enabled, gif_api_key, display_name, test_networks_enabled, mutual_contact_enabled, bio, mnemonic_removed, latest_derived_path, device_name, wallet_accounts_position_change_clock, profile_migration_needed, is_sepolia_enabled, url_unfurling_mode, omit_transfers_history_scan, wallet_show_community_asset_when_sending_tokens, wallet_display_assets_below_balance, wallet_display_assets_below_balance_threshold, wallet_collectible_preferences_change_clock, wallet_collectible_preferences_group_by_collection, wallet_collectible_preferences_group_by_community, is_goerli_enabled
     9  )
    10  SELECT
    11      address,
    12      chaos_mode,
    13      currency,
    14      current_network,
    15      custom_bootnodes,
    16      custom_bootnodes_enabled,
    17      dapps_address,
    18      eip1581_address,
    19      fleet,
    20      hide_home_tooltip,
    21      installation_id,
    22      key_uid,
    23      keycard_instance_uid,
    24      keycard_paired_on,
    25      keycard_pairing,
    26      last_updated,
    27      log_level,
    28      mnemonic,
    29      name,
    30      networks,
    31      node_config,
    32      notifications_enabled,
    33      photo_path,
    34      pinned_mailservers,
    35      preferred_name,
    36      preview_privacy,
    37      public_key,
    38      remember_syncing_choice,
    39      signing_phrase,
    40      stickers_packs_installed,
    41      stickers_recent_stickers,
    42      syncing_on_mobile_network,
    43      synthetic_id,
    44      usernames,
    45      wallet_root_address,
    46      wallet_set_up_passed,
    47      wallet_visible_tokens,
    48      stickers_packs_pending,
    49      waku_enabled,
    50      waku_bloom_filter_mode,
    51      appearance,
    52      remote_push_notifications_enabled,
    53      send_push_notifications,
    54      push_notifications_server_enabled,
    55      push_notifications_from_contacts_only,
    56      push_notifications_block_mentions,
    57      webview_allow_permission_requests,
    58      use_mailservers,
    59      link_preview_request_enabled,
    60      link_previews_enabled_sites,
    61      profile_pictures_visibility,
    62      anon_metrics_should_send,
    63      messages_from_contacts_only,
    64      default_sync_period,
    65      current_user_status,
    66      send_status_updates,
    67      gif_recents,
    68      gif_favorites,
    69      opensea_enabled,
    70      profile_pictures_show_to,
    71      telemetry_server_url,
    72      backup_enabled,
    73      last_backup,
    74      backup_fetched,
    75      auto_message_enabled,
    76      gif_api_key,
    77      display_name,
    78      test_networks_enabled,
    79      mutual_contact_enabled,
    80      bio,
    81      mnemonic_removed,
    82      latest_derived_path,
    83      device_name,
    84      wallet_accounts_position_change_clock,
    85      profile_migration_needed,
    86      is_sepolia_enabled,
    87      url_unfurling_mode,
    88      omit_transfers_history_scan,
    89      wallet_show_community_asset_when_sending_tokens,
    90      wallet_display_assets_below_balance,
    91      wallet_display_assets_below_balance_threshold,
    92      wallet_collectible_preferences_change_clock,
    93      wallet_collectible_preferences_group_by_collection,
    94      wallet_collectible_preferences_group_by_community,
    95      is_goerli_enabled
    96  FROM settings;
    97  
    98  DROP TABLE settings;
    99  
   100  ALTER TABLE settings2 RENAME TO settings;