anonymize.sql

/* Anonymize Chromium History file*/
UPDATE cluster_keywords SET
    keyword = LOWER(hex(randomblob(8)));
UPDATE clusters SET
    label = LOWER(hex(randomblob(16))),
    raw_label = LOWER(hex(randomblob(16)));
UPDATE clusters_and_visits SET
    url_for_deduping = 'https://'||LOWER(hex(randomblob(8)))||'.com',
    normalized_url = 'https://'||LOWER(hex(randomblob(8)))||'.com',
    url_for_display = 'https://'||LOWER(hex(randomblob(8)))||'.com';
UPDATE content_annotations SET
    related_searches = LOWER(hex(randomblob(8))),
    search_normalized_url = 'https://'||LOWER(hex(randomblob(8)))||'.com',
    search_terms = LOWER(hex(randomblob(8)));
UPDATE downloads SET
    current_path = 'C:\temp',
    target_path = 'C:\temp',
    referrer = 'https://'||LOWER(hex(randomblob(8)))||'.com',
    tab_url = 'https://'||LOWER(hex(randomblob(8)))||'.com',
    tab_referrer_url = 'https://'||LOWER(hex(randomblob(8)))||'.com';
UPDATE downloads_url_chains SET
    url = 'https://'||LOWER(hex(randomblob(8)))||'.com';
UPDATE keyword_search_terms SET
    term = LOWER(hex(randomblob(8))),
    normalized_term = LOWER(hex(randomblob(8)));
UPDATE segments SET
    name = 'https://'||LOWER(hex(randomblob(8)))||'.com';
UPDATE content_annotations SET
    search_normalized_url = 'https://'||LOWER(hex(randomblob(8)))||'.com',
    search_terms = LOWER(hex(randomblob(8)));
UPDATE urls SET
    url = 'https://'||LOWER(hex(randomblob(8)))||'.com',
    title = LOWER(hex(randomblob(8)));
UPDATE visited_links SET
    top_level_url = 'https://'||LOWER(hex(randomblob(8)))||'.com',
    frame_url = 'https://'||LOWER(hex(randomblob(8)))||'.com';
UPDATE visits SET
    external_referrer_url = 'https://'||LOWER(hex(randomblob(8)))||'.com';
DELETE FROM visit_source;
VACUUM;