Hi Chris,
I was not thinking of a dynamic schema, I was thinking of something like this...Each Object table would have a field "Exchange" the field would initially be populated as "0000000000" (in this example there are 10 nodes represented by each digit). If the record had been exported to node 1 then the Exchange field would be modified to "0000000001". Where "1" means exported. When the Node 1 returns the data exchange file and it says that it has received the record, the data exchange routine could modify the record to "0000000002" where "2" means imported to node. If we then get the CA to export to node 2, the record would be modified to "0000000012". I am sure there is a better way than this method, but there must be a simple way to get the field in the single record without the table structure dynamically changing.
No, I see no better way. I would only replace 0, 1, 2 by -, N, P, C. Characters are better readable by humans. The maximum number of nodes would be 255 (mysql limit).
The major problem with this are outdated states. If a client tries to send a new request to us and the request has already been at state PENDING then there is now way to signal the other node that the object is longer of interest.
Perhaps I have an idea in the evening. E.g. "R" for rejected. If the node gets an "R" and the state is "P"ending then we can set the state to "C"ommited but I want to sleep about it. This is really critical - but we are on a good way to make it simple ;)
Michael -- _______________________________________________________________ Michael Bell Humboldt-Universitaet zu Berlin Tel.: +49 (0)30-2093 2482 ZE Computer- und Medienservice Fax: +49 (0)30-2093 2704 Unter den Linden 6 [EMAIL PROTECTED] D-10099 Berlin _______________________________________________________________
smime.p7s
Description: S/MIME Cryptographic Signature
