components/places/sql/create_shared_temp_tables.sql

-- This Source Code Form is subject to the terms of the Mozilla Public
-- License, v. 2.0. If a copy of the MPL was not distributed with this
-- file, You can obtain one at http://mozilla.org/MPL/2.0/.

-- This file defines temp tables shared between the main and Sync connections.

-- This table is used, along with moz_places_afterinsert_trigger, to update
-- origins after places removals. During an INSERT into moz_places, origins are
-- accumulated in this table, then a DELETE FROM moz_updateoriginsinsert_temp
-- will take care of updating the moz_origins table for every new origin. See
-- CREATE_PLACES_AFTERINSERT_TRIGGER_ORIGINS below for details.
CREATE TEMP TABLE moz_updateoriginsinsert_temp (
    place_id INTEGER PRIMARY KEY,
    prefix TEXT NOT NULL,
    host TEXT NOT NULL,
    rev_host TEXT NOT NULL,
    frecency INTEGER NOT NULL
);



-- This table is used (along with moz_updateoriginsupdate_temp) in a similar way
-- to moz_updateoriginsinsert_temp, but for deletes, and triggered via
-- moz_places_afterdelete_trigger.
--
-- When rows are added to this table, moz_places.origin_id may be null.  That's
-- why this table uses prefix + host as its primary key, not origin_id.
CREATE TEMP TABLE moz_updateoriginsdelete_temp (
    prefix TEXT NOT NULL,
    host TEXT NOT NULL,
    frecency_delta INTEGER NOT NULL,
    PRIMARY KEY (prefix, host)
) WITHOUT ROWID;

-- This table is used (along with moz_updateoriginsdelete_temp) in a similar way
-- to moz_updateoriginsinsert_temp, but for updates to places' frecencies, and
-- triggered via moz_places_afterupdate_frecency_trigger.
--
-- When rows are added to this table, moz_places.origin_id may be null.  That's
-- why this table uses prefix + host as its primary key, not origin_id.
CREATE TEMP TABLE moz_updateoriginsupdate_temp (
    prefix TEXT NOT NULL,
    host TEXT NOT NULL,
    frecency_delta INTEGER NOT NULL,
    PRIMARY KEY (prefix, host)
) WITHOUT ROWID;