Changes between Version 1 and Version 2 of BluePrint/Synchronisation

Timestamp:

12/22/08 01:16:45 (17 years ago)

Author:

Fran Boon

Comment:

--

BluePrint/Synchronisation

@@ -2 +2 @@
 
 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)
+);
+}}}