hello alexander, though I thank you for your precise explanation, I still don't think we mean the same id.
> and we have GUID unique as well, so at the 'repligard' table new mapping > is created -- between GUID and newly generated autoincremental ID. Thus, > uniqueness is maintained. > the sitegroup id is not auto_incremented. Do we speak of the same id ? > CREATE TABLE topic ( > id int(11) DEFAULT '0' NOT NULL auto_increment, ^^^^^^^^^^^^^^^^ record id > up int(11) DEFAULT '0' NOT NULL, [.........] > code longtext NOT NULL, > sitegroup int(11) DEFAULT '0' NOT NULL, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ sitegroup id or value > PRIMARY KEY (id), > KEY up (up,name(14)), > KEY topic_sitegroup_idx (sitegroup) > ); > Repligard uses only GUIDs and 'changed' fields for making decisions. > If GUIDs are similar, 'changed' field determines actual update. But if you > have a SG with same attributes as that one you're trying to import but with > different GUID, Repligard will treat them as different entities. > The sitegroup id as an attribute that may be the same between the one existing on the target db before the import and the one beeing imported. You explain that repligard treat those as different entities. But what (value) is the sitegroup value of the newly imported sitegroup ? Doesn't it change ? If the a sitegroup with the same value already existed on the target then we may have two sitegroups on the target with different GUID but the same sitegroup value. Does it change during import ? Then repligard has to adjust all record's sitegroup values in order to get also the new sitegroup value. So, how does the sitegroup value behave during import in case of conflicting or equal sitegroup ids ? dieter -- Kind regards Dieter Heine Systemadministration Unix Astrium GmbH Raumfahrt Bremen EMail: [EMAIL PROTECTED] Fax: 49 421 539 5698 Phone: 49 421 539 4989 User Help Desk Astrium Hamburg Phone (office Bremen): on request --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
