Changes between Version 1 and Version 2 of BluePrint/Synchronisation


Ignore:
Timestamp:
12/22/08 01:16:45 (13 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • BluePrint/Synchronisation

    v1 v2  
    22
    33We need to be able to support synchronising data between instances
     4
     5In S2 this is done by record ids being UUIDs (Universally Unique IDs) built from each instance's 'base_uuid'
     6
     7There is a sync_instance table:
     8{{{
     9CREATE TABLE sync_instance (
     10    base_uuid VARCHAR(4) NOT NULL, -- Instance id
     11    owner VARCHAR(100), -- Instance owner's name
     12    contact TEXT, -- Contact details of the instance owner
     13    url VARCHAR(100) DEFAULT NULL, -- Server url if exists
     14    last_update TIMESTAMP NOT NULL, -- Last Time sync with the instance
     15    sync_count INT DEFAULT 0, -- Number of times synchronized
     16    PRIMARY KEY(base_uuid)
     17);
     18}}}