create_sync_temp_tables.sql

Enable keyboard shortcuts

-- 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/.

DROP TABLE IF EXISTS addresses_sync_staging;

CREATE TEMP TABLE addresses_sync_staging (

    guid                TEXT NOT NULL PRIMARY KEY CHECK(length(guid) != 0),

    payload             TEXT NOT NULL CHECK(length(payload) != 0)

);

DROP TABLE IF EXISTS credit_cards_sync_staging;

CREATE TEMP TABLE credit_cards_sync_staging (

    guid                TEXT NOT NULL PRIMARY KEY CHECK(length(guid) != 0),

    payload             TEXT NOT NULL CHECK(length(payload) != 0)

);

DROP TABLE IF EXISTS addresses_sync_outgoing_staging;

CREATE TEMP TABLE addresses_sync_outgoing_staging (

    guid                TEXT NOT NULL PRIMARY KEY CHECK(length(guid) != 0),

    payload             TEXT NOT NULL CHECK(length(payload) != 0),

    sync_change_counter INTEGER NOT NULL

);

DROP TABLE IF EXISTS credit_cards_sync_outgoing_staging;

CREATE TEMP TABLE credit_cards_sync_outgoing_staging (

    guid                TEXT NOT NULL PRIMARY KEY CHECK(length(guid) != 0),

    payload             TEXT NOT NULL CHECK(length(payload) != 0),

    sync_change_counter INTEGER NOT NULL

);