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

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