|Version 2 (modified by 13 years ago) ( diff ),|
This page hosts the detailed specification for the Blueprint for the Synchronisation.
We need to be able to support synchronising data between instances
In S2 this is done by record ids being UUIDs (Universally Unique IDs) built from each instance's 'base_uuid'
There is a sync_instance table:
CREATE TABLE sync_instance ( base_uuid VARCHAR(4) NOT NULL, -- Instance id owner VARCHAR(100), -- Instance owner's name contact TEXT, -- Contact details of the instance owner url VARCHAR(100) DEFAULT NULL, -- Server url if exists last_update TIMESTAMP NOT NULL, -- Last Time sync with the instance sync_count INT DEFAULT 0, -- Number of times synchronized PRIMARY KEY(base_uuid) );